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.
Questions:
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)
Considering:
1) New role for the non-ITS staff identify them
2) New role for secretary to manage the non-ITS profiles