Staff Directory

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