SFA_ISRDUP_AY

(SQL View)
 Index Back

Aid Year Table for ISIR Dup Rq

This view contains a list of the different Aid Years and their descriptions for each institution. It is limited to aid years 2004 and earlier because ISIR Duplicate Requests are not valid after 2005.

SELECT INSTITUTION , AID_YEAR , DESCR ,DESCRSHORT FROM PS_AID_YEAR_TBL WHERE AID_YEAR <= '2004'

  • Related Language Record: SFA_ISRDUPAYLNG

    • # 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