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,
PERSONNEL.persWorkLocationBuilding, PERSONNEL.persWorkLocationFloor, PERSONNEL.persWorkLocationNumber,
PERSONNEL.persOldLocation,
PERSONNEL.persEmail, PERSONNEL.persWorkPhone1, PERSONNEL.persWorkFax
FROM PERSONNEL, PERSPOSITION, SECTION
WHERE
PERSONNEL.persId = PERSPOSITION.persId
AND PERSPOSITION.sectId = SECTION.sectId
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?
2) Should the non-ITSers show up in the Internal Org Structure view?
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