Skip to end of metadata
Go to start of metadata

You are viewing an old version of this content. View the current version.

Compare with Current View Version History

« Previous Version 2 Next »

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.




  • No labels