STDNT_AN_VWLNG

(SQL View)
 Index Back

Rel ln Anticipated Aid Smry VW

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.LANGUAGE_CD ,B.DESCR FROM PS_ANTICIPATED_AID A , PS_ITEM_TYPE_LNG 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_LNG D WHERE D.SETID = B.SETID AND D.ITEM_TYPE = B.ITEM_TYPE AND D.LANGUAGE_CD = B.LANGUAGE_CD AND D.EFFDT <= %CurrentDateIn)

  • Related Language Record for STDNT_AN_VW

  • 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description