STDNT_BGT_IT_VW

(SQL View)
 Index Back

Stdnt Bdgt Item Summary Vw

STDNT_BGT_IT_VW is a view of max-effective dated budgets and budget items for a given year/student.

SELECT DISTINCT a.emplid, a.institution, a.aid_year, b.award_period, a.bgt_item_category FROM PS_STDNT_BUDGET_IT a, ps_stdnt_cr_term b WHERE a.effdt=(Select max(a1.Effdt) from PS_STDNT_BUDGET_IT 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_BUDGET_IT 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