SF_ISET_DEP1_VW

(SQL View)
 Index Back

Deposit Program Information


SELECT B.INSTITUTION_SET , C.BUSINESS_UNIT ,A.EMPLID , A.ADM_APPL_NBR , D.APPL_DEP_NBR , A.INSTITUTION , A.ACAD_PROG , A.ACAD_CAREER , A.ADMIT_TERM , F.DUE_DT , F.DUE_AMT , F.RECEIVED_DT , F.RECEIVED_AMT , F.WAIVED_AMT , F.POST_FLAG , F.CURRENCY_CD , C.SF_ENABLE_WEB_PAY , F.DUE_AMT - F.RECEIVED_AMT - F.WAIVED_AMT , B.ITEM_TYPE_DEPOSIT FROM PS_ADM_APPL_PROG A , PS_ISET_BU_DTL B , 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 B.BUSINESS_UNIT = C.BUSINESS_UNIT 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 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 E1.EFFDT <= %CurrentDateIn) AND A.CAMPUS = E.CAMPUS AND B.BUSINESS_UNIT = E.BUSINESS_UNIT

  • Parent record: ADM_APPL_DEP

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION_SET Character(5) VARCHAR2(5) NOT NULL Institution Set
    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Default Value: ADM_APPL_DEP.EMPLID

    4 ADM_APPL_NBR Character(8) VARCHAR2(8) NOT NULL Application Nbr
    5 APPL_DEP_NBR Number(3,0) SMALLINT NOT NULL Application Deposit Nbr
    6 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    7 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program
    8 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
    9 ITEM_TERM Character(4) VARCHAR2(4) NOT NULL Item Term
    10 DUE_DT Date(10) DATE Due Date
    11 DUE_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Due Amount
    12 RECEIVED_DT Date(10) DATE Certificate Received Date
    13 RECEIVED_AMT Signed Number(16,2) DECIMAL(14,2) NOT NULL Received Amount
    14 WAIVED_AMT Signed Number(16,2) DECIMAL(14,2) NOT NULL Waived Amount
    15 POST_FLAG Character(1) VARCHAR2(1) NOT NULL Line Post Flag
    D=Deleted
    N=Not Posted
    Y=Posted
    16 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    17 SF_ENABLE_WEB_PAY Character(1) VARCHAR2(1) NOT NULL Accept Self-Service Payments
    18 BALANCE_REMAIN Signed Number(18,2) DECIMAL(16,2) NOT NULL Remaining Balance
    19 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type