Student Directory

Owned by Scott Ogasawara
Mar 08, 2022
1 min read


--Studnt Directory SQL from blueside
select PLCLINK.plcid,STDLINK.stdLastName, STDLINK.stdFirstName, SEC.sectName, CONLINK.contactFirstname||' '||CONLINK.contactLastname as contactName, 
BUILDING.name as persWorkLocationBuilding, PERS.persWorkLocationFloor, PERS.persWorkLocationNumber, PERS.persNickName, PERS.persEmail, PERS.persWorkPhone1, PERS.persWorkFax, PERS.PERSPICTURE 
FROM  (select * from personnel, persposition where personnel.persid = persposition.persid and personnel.roleid = 9) PERS, 
  SECEADM.student@secedb_link STDLINK, SECEADM.placement@secedb_link PLCLINK, 
  SECEADM.jobcontacts@secedb_link SEWALINK, SECEADM.contact@secedb_link CONLINK, 
  SECTION SEC, BUILDING WHERE PERS.empid = PLCLINK.plcid 
  AND PERS.pposStatus = 'A' AND PLCLINK.plcjobid = SEWALINK.jobid 
  AND PLCLINK.stdid = STDLINK.stdid AND SEWALINK.contactid = CONLINK.contactid 
  AND SEWALINK.aprid = 2 AND PERS.sectid = SEC.sectid 
  AND PERS.buildingId = BUILDING.id(+)
 -- AND PERS.sectId IN (215)
;