STDNT_AWRD_CATG

(SQL View)
 Index Back

Award Category Summary Vw

This is a View of the Stdnt_Awards Table that brings in the Fin Aid Type (ie Loan,Grant, etc.) associated with the Item Type for Summary Panels. Used to view items by Category

select distinct A.EMPLID , A.INSTITUTION , A.AID_YEAR , B.FIN_AID_TYPE from PS_STDNT_AWARDS A, PS_ITEM_TYPE_FA B where A.AID_YEAR = B.AID_YEAR and A.setid = b.setid and A.ITEM_TYPE = B.ITEM_TYPE and b.effdt = (select max(effdt) from ps_item_type_fa c where c.setid = b.setid and c.aid_year = b.aid_year and c.item_type = b.item_type )

  • 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

    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: AID_YEAR_TBL

    4 FIN_AID_TYPE Character(4) VARCHAR2(4) NOT NULL Fin Aid Type
    A=Athletic
    B=Bursary
    F=Fellowship
    G=Grant
    L=Loan
    S=Scholarship
    V=Waiver
    W=Work/Study