Query SQL:
SELECT B.LAST_NAME, B.FIRST_NAME, B.MIDDLE_NAME, A.EMPLID, A.EMPL_RCD, D.JOBCODE, E.DESCR, D.EMPL_STATUS, D.BUSINESS_UNIT, A.WEEK_WORKLOAD_HRS, C.SUBJECT, C.CATALOG_NBR, C.CLASS_SECTION, C.DESCR, C.SSR_COMPONENT, C.SESSION_CODE, C.ROOM_CAP_REQUEST, C.ENRL_CAP, C.ENRL_TOT, C.ACAD_GROUP, C.ACAD_ORG, C.ACAD_CAREER, C.CLASS_STAT, TO_CHAR(C.START_DT,'YYYY-MM-DD'), TO_CHAR(C.END_DT,'YYYY-MM-DD'), TO_CHAR(SYSDATE,'YYYY-MM-DD'), TO_CHAR(SYSDATE,'YYYY-MM-DD'),C.CRSE_ID,C.CRSE_OFFER_NBR,C.STRM,E.SETID,E.JOBCODE
FROM PS_INSTR_TERM_DTL A, PS_NAMES_FERPA_VW B, PS_CLASS_TBL C, PS_EMPLOYMENT_HOME D, PS_JOBCODE_TBL_VW E
WHERE ( A.INSTITUTION = :1
AND A.STRM = :2
AND A.EMPLID = B.EMPLID
AND B.NAME_TYPE = 'PRI'
AND A.INSTITUTION = C.INSTITUTION
AND A.STRM = C.STRM
AND C.CRSE_ID = A.CRSE_ID
AND C.CRSE_OFFER_NBR = A.CRSE_OFFER_NBR
AND C.SESSION_CODE = A.SESSION_CODE
AND C.CLASS_NBR = A.CLASS_NBR
AND D.EMPLID = A.EMPLID
AND D.EMPL_RCD = A.EMPL_RCD
AND D.EFFDT =
(SELECT MAX(D_ED.EFFDT) FROM PS_EMPLOYMENT_HOME D_ED
WHERE D.EMPLID = D_ED.EMPLID
AND D.EMPL_RCD = D_ED.EMPL_RCD
AND D_ED.EFFDT <= C.START_DT)
AND D.JOBCODE = E.JOBCODE (+) )
ORDER BY 1, 2, 3