FA_FED_SUM_VW

(SQL View)
 Index Back

Federlal Aid Sum 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.BUSINESS_UNIT ,A.COMMON_ID ,A.COMMON_ID ,A.ITEM_TERM ,SUM(ITEM_AMT) FROM PS_ITEM_SF A , PS_ITEM_TYPE_FA B , PS_BUS_UNIT_TBL_SF C WHERE A.BUSINESS_UNIT=C.BUSINESS_UNIT AND A.ITEM_TYPE=B.ITEM_TYPE AND B.FA_SOURCE='F' AND B.EFFDT= ( SELECT MAX(EFFDT) FROM PS_ITEM_TYPE_FA D WHERE B.SETID=D.SETID AND B.ITEM_TYPE=D.ITEM_TYPE AND B.AID_YEAR=D.AID_YEAR AND D.EFFDT<=%CurrentDateIn) AND B.EFF_STATUS='A' AND B.SETID= ( SELECT E.SETID FROM PS_SET_CNTRL_REC E WHERE E.RECNAME= 'ITEM_TYPE_FA' AND E.SETCNTRLVALUE= C.INSTITUTION) AND A.ITEM_AMT < 0 AND A.SA_ID_TYPE = 'P' GROUP BY A.BUSINESS_UNIT, A.COMMON_ID, A.COMMON_ID, A.ITEM_TERM

  • Parent record: STUDENT_AID

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: SP_BU_SF_NONVW

    2 COMMON_ID Character(11) VARCHAR2(11) NOT NULL Common ID to store Personal ID / Ext Org ID value
    3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: STUDENT_AID

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

    Prompt Table: DISB_ID_TBL

    5 AMOUNT Signed Number(20,3) DECIMAL(18,3) NOT NULL Commuting Allowance Paid Per Cycle.