STDNT_BGT_AD_VW

(SQL View)
 Index Back

Stdnt Bdgt Item Amt Summary Vw

STDNT_BGT_AD_VW is a view of max-effective dated budgets and budget item amounts for a given year/student.

SELECT a.emplid , a.institution , a.aid_year , b.award_period , a.bgt_item_category , b.strm , a.budget_item_amount , a.pell_item_amount ,A.SFA_PELITMAMT_LHT FROM PS_STDNT_BUDGET_IT a , ps_stdnt_cr_term b WHERE a.effdt=( SELECT MAX(a1.Effdt) FROM ps_stdnt_term_bdgt a1 WHERE a1.emplid = a.emplid AND a1.aid_year = a.aid_year AND a1.institution = a.institution AND a1.acad_career = a.acad_career AND a1.strm = a.strm AND a1.effdt <= %CurrentDateIn) AND a.effseq=( SELECT MAX(a2.Effseq) FROM ps_stdnt_term_bdgt a2 WHERE a2.emplid = a.emplid AND a2.aid_year = a.aid_year AND a2.institution = a.institution AND a2.acad_career = a.acad_career AND a2.strm = a.strm AND a2.effdt = a.effdt) AND a.emplid = b.emplid AND a.institution = b.institution AND a.aid_year = b.aid_year AND a.acad_career = b.acad_career AND a.strm = b.strm

  • Parent record: STUDENT_AID

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

    Prompt Table: INSTITUTION_TBL

    3 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year
    4 AWARD_PERIOD Character(1) VARCHAR2(1) NOT NULL Award Period
    A=Academic
    N=Non Standard
    5 BGT_ITEM_CATEGORY Character(4) VARCHAR2(4) NOT NULL Budget Item Category
    6 STRM Character(4) VARCHAR2(4) NOT NULL Term
    7 BUDGET_ITEM_AMOUNT Number(8,2) DECIMAL(7,2) NOT NULL Budget Item Amount
    8 PELL_ITEM_AMOUNT Number(8,2) DECIMAL(7,2) NOT NULL Pell Amount
    9 SFA_PELITMAMT_LHT Number(8,2) DECIMAL(7,2) NOT NULL Filed used for the calculation of Less than half time Pell COA Budget Item amount.