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.
...
1) Should we restrict secretary access to only their section?
- not necessary
2) Should the non-ITSers show up in the Internal Org Structure view?
- can if can clearly indicate as NON-ITS
3) Should non-ITSers be included in mailing lists? (grouper)
...