Results

 

 
SELECT D.LAST_NAME, D.FIRST_NAME, D.MIDDLE_NAME, B.EMPLID, B.ACAD_PROG, C.ACAD_PLAN, E.UNT_TAKEN_PRGRSS, B.ADMIT_TERM, A.ADMIT_TYPE, D.PHONE, D.EMAIL_ADDR, F.STDNT_DEGR, F.INSTITUTION, F.DEGREE, G.ACAD_PLAN, H.DESCR, F.COMPLETION_TERM, TO_CHAR(F.DEGR_CONFER_DT,'YYYY-MM-DD'), F.HONORS_SUFFIX,H.INSTITUTION,H.ACAD_PLAN,TO_CHAR(H.EFFDT,'YYYY-MM-DD')
FROM PS_ADM_APPL_DATA A, PS_ADM_APPL_SCTY A1, PS_ADM_APPL_PROG B, PS_ADM_MAINT_SCTY B1, PS_ADM_APPL_PLAN C, PS_CU_BIO_VW D, PS_STDNT_CAR_TERM E, PS_ACAD_DEGR F, PS_ACAD_DEGR_PLAN G, PS_ACAD_PLAN_TBL H
WHERE A.EMPLID = A1.EMPLID
AND A.ACAD_CAREER = A1.ACAD_CAREER
AND A.ADM_APPL_NBR = A1.ADM_APPL_NBR
AND A1.OPRCLASS = 'CUHCPPBAR01'
AND A1.OPRID = '11002650'
AND B.EMPLID = B1.EMPLID
AND B.ACAD_CAREER = B1.ACAD_CAREER
AND B.STDNT_CAR_NBR = B1.STDNT_CAR_NBR
AND B.ADM_APPL_NBR = B1.ADM_APPL_NBR
AND B.APPL_PROG_NBR = B1.APPL_PROG_NBR
AND B1.OPRCLASS = 'CUHCPPBAR01'
AND B1.OPRID = '11002650'
AND A.INSTITUTION = :1
AND A.ACAD_CAREER = 'UGRD'
AND A.EMPLID = B.EMPLID
AND A.ACAD_CAREER = B.ACAD_CAREER
AND A.STDNT_CAR_NBR = B.STDNT_CAR_NBR
AND A.ADM_APPL_NBR = B.ADM_APPL_NBR
AND B.EFFDT =
(SELECT MAX(B_ED.EFFDT) FROM PS_ADM_APPL_PROG B_ED
WHERE B.EMPLID = B_ED.EMPLID
AND B.ACAD_CAREER = B_ED.ACAD_CAREER
AND B.STDNT_CAR_NBR = B_ED.STDNT_CAR_NBR
AND B.ADM_APPL_NBR = B_ED.ADM_APPL_NBR
AND B.APPL_PROG_NBR = B_ED.APPL_PROG_NBR
AND B_ED.EFFDT <= SYSDATE)
AND B.EFFSEQ =
(SELECT MAX(B_ES.EFFSEQ) FROM PS_ADM_APPL_PROG B_ES
WHERE B.EMPLID = B_ES.EMPLID
AND B.ACAD_CAREER = B_ES.ACAD_CAREER
AND B.STDNT_CAR_NBR = B_ES.STDNT_CAR_NBR
AND B.ADM_APPL_NBR = B_ES.ADM_APPL_NBR
AND B.APPL_PROG_NBR = B_ES.APPL_PROG_NBR
AND B.EFFDT = B_ES.EFFDT)
AND B.ADMIT_TERM BETWEEN :2 AND :3
AND B.PROG_ACTION = 'MATR'
AND B.EMPLID = C.EMPLID
AND B.ACAD_CAREER = C.ACAD_CAREER
AND B.STDNT_CAR_NBR = C.STDNT_CAR_NBR
AND B.ADM_APPL_NBR = C.ADM_APPL_NBR
AND B.APPL_PROG_NBR = C.APPL_PROG_NBR
AND B.EFFSEQ = C.EFFSEQ
AND B.EFFDT = C.EFFDT
AND A.EMPLID = D.EMPLID
AND B.EMPLID = E.EMPLID
AND B.ACAD_CAREER = E.ACAD_CAREER
AND B.STDNT_CAR_NBR = E.STDNT_CAR_NBR
AND E.INSTITUTION = B.INSTITUTION
AND E.UNT_TAKEN_PRGRSS > 0
AND E.STRM = :3
AND A.EMPLID = F.EMPLID
AND F.ACAD_DEGR_STATUS = 'A'
AND F.EMPLID = G.EMPLID
AND F.STDNT_DEGR = G.STDNT_DEGR
AND G.ACAD_PLAN = H.ACAD_PLAN
AND H.EFFDT =
(SELECT MAX(H_ED.EFFDT) FROM PS_ACAD_PLAN_TBL H_ED
WHERE H.INSTITUTION = H_ED.INSTITUTION
AND H.ACAD_PLAN = H_ED.ACAD_PLAN
AND H_ED.EFFDT <= F.DEGR_CONFER_DT)
AND H.INSTITUTION = F.INSTITUTION
ORDER BY 1, 2, 3
  • No labels