STDNT_ADMDEP_VW

(SQL View)
 Index Back

Deposit Program Information


SELECT A.EMPLID , C.BUSINESS_UNIT , A.ADMIT_TERM , SUM(F.DUE_AMT - F.WAIVED_AMT - F.RECEIVED_AMT) FROM PS_ADM_APPL_PROG A , PS_BUS_UNIT_TBL_SF C , PS_ADM_APPL_DEP_PR D , PS_HOME_CAMPUS_TBL E , PS_ADM_APPL_DEP F WHERE D.EMPLID = F.EMPLID AND D.ADM_APPL_NBR = F.ADM_APPL_NBR AND D.APPL_DEP_NBR = F.APPL_DEP_NBR AND A.INSTITUTION = C.INSTITUTION AND A.EFFDT = ( SELECT MAX(A1.EFFDT ) FROM PS_ADM_APPL_PROG A1 WHERE A.EMPLID = A1.EMPLID AND A.ACAD_CAREER = A1.ACAD_CAREER AND A.STDNT_CAR_NBR = A1.STDNT_CAR_NBR AND A.ADM_APPL_NBR = A1.ADM_APPL_NBR AND A.APPL_PROG_NBR = A1.APPL_PROG_NBR) AND A.EFFSEQ = ( SELECT MAX(A2.EFFSEQ ) FROM PS_ADM_APPL_PROG A2 WHERE A.EMPLID = A2.EMPLID AND A.ACAD_CAREER = A2.ACAD_CAREER AND A.STDNT_CAR_NBR = A2.STDNT_CAR_NBR AND A.ADM_APPL_NBR = A2.ADM_APPL_NBR AND A.APPL_PROG_NBR = A2.APPL_PROG_NBR AND A.EFFDT = A2.EFFDT) AND (A.PROG_STATUS = 'PM' OR A.PROG_STATUS = 'AD' OR A.PROG_STATUS = 'AC') AND A.EMPLID = D.EMPLID AND A.ADM_APPL_NBR = D.ADM_APPL_NBR AND A.ACAD_PROG = D.ACAD_PROG AND A.INSTITUTION = E.INSTITUTION AND A.ACAD_PROG = E.ACAD_PROG AND C.BUSINESS_UNIT = E.BUSINESS_UNIT AND E.EFFDT = ( SELECT MAX(E1.EFFDT) FROM PS_HOME_CAMPUS_TBL E1 WHERE E.INSTITUTION = E1.INSTITUTION AND E.ACAD_PROG = E1.ACAD_PROG AND E.EFFDT <= %CurrentDateIn) AND A.CAMPUS = E.CAMPUS GROUP BY A.EMPLID, C.BUSINESS_UNIT, A.ADMIT_TERM

  • Parent record: ADM_APPL_DEP

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Default Value: ADM_APPL_DEP.EMPLID

    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    3 ADMIT_TERM Character(4) VARCHAR2(4) NOT NULL Admit Term
    4 DUE_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Due Amount