STDNT_AD_VW

(SQL View)
 Index Back

Deposit Program Information


SELECT A.EMPLID , A.ADM_APPL_NBR , A.INSTITUTION , C.BUSINESS_UNIT , A.ACAD_PROG , A.ACAD_CAREER , A.ADMIT_TERM , F.CURRENCY_CD , 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 , A.ADM_APPL_NBR , A.INSTITUTION ,C.BUSINESS_UNIT , A.ACAD_PROG , A.ACAD_CAREER , A.ADMIT_TERM , F.CURRENCY_CD

  • 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 ADM_APPL_NBR Character(8) VARCHAR2(8) NOT NULL Application Nbr
    3 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    5 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program
    6 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic Career
    BAC=Bachelor (NLD)
    BBL=Vocational Coaching (NLD)
    BOL=Vocational Training (NLD)
    BUSN=Graduate Business
    CNED=Continuing Education
    CRED=Semester Credit
    EDU=Education (NLD)
    EXED=Extended Education
    GRAD=Graduate
    LAW=Law
    MEDS=Medical School
    NONA=Non Award
    PGRD=Postgraduate
    RSCH=Research
    TECH=Technical
    UENG=Undergraduate Engineering
    UGRD=Undergraduate
    VAVO=Advanced General Educ. (NLD)
    VETM=Veterinary Medicine
    7 ADMIT_TERM Character(4) VARCHAR2(4) NOT NULL Admit Term
    8 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    9 DUE_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Due Amount