FED_AID_YR_TBL

(SQL Table)
 Index Back

Dept of Educ. Aid Year Table

This table contains a list of the different Aid Years and their descriptions used by the Dept. of Education. It is used primarily in the Financial Aid Module.

  • Related Language Record: FED_AID_YR_LANG

  • Parent Record Of FAEDIDESTVWLNG FAEDIDSTSRCHLNG FA_EDI_DEST FA_EDI_DEST_LNG FA_EDI_DEST_VW FA_EDI_DST_SRCH INST_XREF INST_XREF_LANG ISIRSARXREFLNG ISIR_COMMT_LANG ISIR_COMMT_TBL ISIR_REJECT_LNG ISIR_REJECT_TBL ISIR_SAR_XREF LN_ACTNTYPE_TBL LN_ACTN_PRG_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: FED_AID_YR_TBL.DESCR

    4 START_DATE Date(10) DATE NOT NULL Start Date for Gen Standing PO

    Default Value: %date

    5 END_DATE Date(10) DATE NOT NULL End Date