STDNT_AN_VW

(SQL View)
 Index Back

Anticipated Aid Summary View

The Anticipated Financial Aid table stores the amount of financial aid per award that is anticipated for a given disbursement period within a term. Once the aid has been disbursed (posted to the student account) the anticipated amount is decreased by the disbursed amount. Rows are added to the table each time activity that impacts the disbursemment amount takes place.

SELECT A.EMPLID ,A.INSTITUTION ,F.BUSINESS_UNIT ,A.STRM ,B.DESCR ,A.ACAD_CAREER ,A.DISBURSEMENT_ID ,A.AS_OF_DTTM ,-1 * A.NET_AWARD_AMT ,A.DISB_APPLY_DT ,A.DISB_EXPIRE_DT ,A.CURRENCY_CD FROM PS_ANTICIPATED_AID A , PS_ITEM_TYPE_TBL B , PS_STDNT_AWRD_DISB F WHERE A.NET_AWARD_AMT > 0 AND (A.DISB_EXPIRE_DT > %CurrentDateIn OR A.DISB_EXPIRE_DT IS NULL) AND A.EMPLID = F.EMPLID AND A.INSTITUTION = F.INSTITUTION AND A.AID_YEAR = F.AID_YEAR AND A.ITEM_TYPE = F.ITEM_TYPE AND A.ACAD_CAREER = F.ACAD_CAREER AND A.DISBURSEMENT_ID = F.DISBURSEMENT_ID AND A.AS_OF_DTTM=( SELECT MAX(AS_OF_DTTM) FROM PS_ANTICIPATED_AID C WHERE A.EMPLID=C.EMPLID AND A.INSTITUTION=C.INSTITUTION AND A.AID_YEAR=C.AID_YEAR AND A.ITEM_TYPE=C.ITEM_TYPE AND A.ACAD_CAREER=C.ACAD_CAREER AND A.DISBURSEMENT_ID=C.DISBURSEMENT_ID) AND A.ITEM_TYPE = B.ITEM_TYPE AND B.SETID = ( SELECT E.SETID FROM PS_SET_CNTRL_REC E WHERE E.SETCNTRLVALUE = A.INSTITUTION AND E.RECNAME = 'ITEM_TYPE_TBL') AND B.EFFDT = ( SELECT MAX(D.EFFDT) FROM PS_ITEM_TYPE_TBL D WHERE D.SETID = B.SETID AND D.ITEM_TYPE = B.ITEM_TYPE AND D.EFFDT <= %CurrentDateIn)

  • Related Language Record: STDNT_AN_VWLNG

  • Parent record: STUDENT_AID

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

    Prompt Table: STUDENT_AID

    2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    4 STRM Character(4) VARCHAR2(4) NOT NULL Term

    Prompt Table: DISB_ID_TBL

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    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 DISBURSEMENT_ID Character(2) VARCHAR2(2) NOT NULL Disbursement ID

    Prompt Table: DISB_ID_TBL

    8 AS_OF_DTTM DateTime(26) TIMESTAMP As of Date/Time
    9 NET_AWARD_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL Net Award Amount
    10 DISB_APPLY_DT Date(10) DATE Disbursement Apply Date

    Default Value: %date

    11 DISB_EXPIRE_DT Date(10) DATE Disbursement Expire Date

    Default Value: %date

    12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL