Review: edu.hawaii.its.itsadm.staff.extern.StaffDirectoryModel()
SELECT
...
PERSONNEL.PERSPICTURE,
...
PERSONNEL.roleId,
...
PERSONNEL.persLastName,
...
PERSONNEL.persFirstName,
...
PERSONNEL.persMiddleName,
PERSONNEL.persFullName,
...
PERSONNEL.persNickName,
...
PERSPOSITION.sectId,
...
SECTION.sectName,
...
PERSPOSITION.pposStatus,
...
BUILDING.id as buildingId, BUILDING.name as persWorkLocationBuilding,
...
PERSONNEL.persWorkLocationFloor,
...
PERSONNEL.persWorkLocationNumber,
PERSONNEL.persOldLocation,
...
PERSONNEL.persEmail,
...
PERSONNEL.persWorkPhone1,
...
PERSONNEL.
...
persWorkFax
FROM
...
PERSONNEL,
...
PERSPOSITION,
...
SECTION
...
, BUILDING
WHERE
...
PERSONNEL.persId
...
=
...
PERSPOSITION.
...
persId
AND
...
PERSPOSITION.sectId
...
=
...
SECTION.sectId
...
AND PERSONNEL.buildingId = BUILDING.id(+)
AND
...
PERSPOSITION.pposStatus
...
=
...
'A'
...
AND
...
PERSPOSITION.pposType
...
=
...
1
--AND
...
PERSPOSITION.sectId
...
IN
...
("")
;
Need to add Non-ITSers to the above tables or create a standalone table to UNION with the above.
...