Screenshot:
Queries:
Query Details:
SELECT A.EMPLID, A.INSTITUTION, A.STRM, TO_CHAR(A.EFFDT,'YYYY-MM-DD'), A.EFFSEQ
FROM PS_SCCPU_FATRM_BND A
WHERE ( A.EFFDT =
(SELECT MAX(A_ED.EFFDT) FROM PS_SCCPU_FATRM_BND A_ED
WHERE A.EMPLID = A_ED.EMPLID
AND A.INSTITUTION = A_ED.INSTITUTION
AND A.STRM = A_ED.STRM
AND A_ED.EFFDT <= SYSDATE)
AND A.EFFSEQ =
(SELECT MAX(A_ES.EFFSEQ) FROM PS_SCCPU_FATRM_BND A_ES
WHERE A.EMPLID = A_ES.EMPLID
AND A.INSTITUTION = A_ES.INSTITUTION
AND A.STRM = A_ES.STRM
AND A.EFFDT = A_ES.EFFDT)
AND A.STRM = :1
AND A.EMPLID IN (SELECT B.EMPLID
FROM PS_STDNT_FA_TERM B
WHERE B.EFFDT =
(SELECT MAX(B_ED.EFFDT) FROM PS_STDNT_FA_TERM B_ED
WHERE B.EMPLID = B_ED.EMPLID
AND B.INSTITUTION = B_ED.INSTITUTION
AND B.STRM = B_ED.STRM
AND B_ED.EFFDT <= SYSDATE)
AND B.EFFSEQ =
(SELECT MAX(B_ES.EFFSEQ) FROM PS_STDNT_FA_TERM B_ES
WHERE B.EMPLID = B_ES.EMPLID
AND B.INSTITUTION = B_ES.INSTITUTION
AND B.STRM = B_ES.STRM
AND B.EFFDT = B_ES.EFFDT)
AND B.STRM = :1
AND ( B.OVRD_ENRL_INTNSY = 'N'
OR B.SFA_ENRL_INTENSITY <> 1)
AND B.ACAD_CAREER = 'UGRD'))