INST_AID_YR_VW

(SQL View)
 Index Back

Inst Aid Year Table View

This view contains a list of the two current Aid Years and their descriptions for each institution used by the Profile/Need Acceess Load. It is used as a Prompt Table for the field AID_YEAR on INST_LOAD_VW and INST_NA_LOAD_VW. This is a view of the AID_YEAR_TBL. This view will need to be modified every year to only select the two aid years that are actively loading.

SELECT institution ,aid_year ,descr ,descrshort ,acad_year_start ,acad_year_end FROM PS_AID_YEAR_TBL WHERE aid_year BETWEEN '1997' AND '2010'

  • Related Language Record: AID_YR_TBL_LANG

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

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    2 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year

    Default Value: OPR_DEF_TBL_CS.AID_YEAR

    Prompt Table: FED_AID_YR_TBL

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

    Default Value: FED_AID_YR_TBL.DESCR

    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: FED_AID_YR_TBL.DESCRSHORT

    5 ACAD_YEAR_START Date(10) DATE Academic Year Start Date
    6 ACAD_YEAR_END Date(10) DATE Academic Year End Date