SFANTCAIDVWLNG

(SQL View)
 Index Back

Anticipated Aid Summary View

SFANTCAIDVWLNG is the related language recordfor the record SF_ANTC_AID_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 , A.AID_YEAR , A.STRM , A.ITEM_TYPE ,B.LANGUAGE_CD , B.DESCR FROM PS_ANTC_AID_SUM_VW A , PS_ITEM_TYPE_LANG B , PS_SET_CNTRL_REC C WHERE C.SETCNTRLVALUE = A.INSTITUTION AND C.RECNAME = 'ITEM_TYPE_FA' AND B.SETID = C.SETID AND B.ITEM_TYPE = A.ITEM_TYPE AND B.AID_YEAR = A.AID_YEAR AND B.EFFDT = ( SELECT MAX(EFFDT) FROM PS_ITEM_TYPE_LANG WHERE B.SETID = SETID AND B.ITEM_TYPE = ITEM_TYPE AND B.AID_YEAR = AID_YEAR AND EFFDT <= %CurrentDateIn)

  • Related Language Record for SF_ANTC_AID_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 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year

    Default Value: OPR_DEF_TBL_CS.AID_YEAR

    Prompt Table: STUDENT_AID

    4 STRM Character(4) VARCHAR2(4) NOT NULL Term

    Prompt Table: DISB_ID_TBL

    5 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type

    Prompt Table: ITEM_TYPE_FA

    6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description

    Default Value: ITEM_TYPE_TBL.DESCR