AID_YEAR_TBL

(SQL Table)
 Index Back

Aid Year Table

This table contains a list of the different Aid Years and their descriptions for each institution. It is primarily used in the Financial Aid Module

  • Related Language Record: AID_YR_TBL_LANG

  • Parent Record Of AGGR_LN_TYPE_VW AIDYEARCARERLNG AIDYRCARCOPYLNG AIDYRPROGCPYLNG AID_YEAR_CAREER AID_YR_CAR_COPY AID_YR_PROG_CPY BDGT_CATG_COPY BDGT_CATG_LANG BDGT_CATG_SRCH BUDGET_CATG_LNG BUDGET_CATG_TBL CNASSETUPVWLNG CNAS_SETUP_LANG CNAS_SETUP_TBL CNAS_SETUP_VW DISBRULEITMLNG DISBRULEZCOPYLN DISBSPLTSRCHLNG DISB_GLB_SRCH DISB_RULE_GLB DISB_RULE_ITM DISB_RULE_ZCOPY DISB_SPLITVWLNG DISB_SPLIT_SRCH DISB_SPLIT_VW FA_APP_SRC_TYP FA_CASH_PROGRAM FA_RECONPER_TBL INAS_LCL_PLCY INSTSCHLCDSLNG INSTSCHLVWLNG INST_LOAD_CNTRL INST_SCHL_VW INST_SCHOOL_CDS ISIRFLDSRCHLNG ISIRINSTSCVWLNG ISIRXREF_VWLNG ISIR_FLD_SRCH ISIR_INST_CNTRL ISIR_INST_SC_VW ISIR_XREF_VW LENDER_LDTBL_VW LNDLCHGXREFLNG LN_CAREER_VW LN_DESTPROF_TBL LN_DESTPR_LANG LN_DESTVW_LANG LN_DEST_ADD_VW LN_DEST_DESC_VW LN_DEST_LNG1_VW LN_DEST_LNG3_VW LN_DEST_VW LN_DL_CHG_XREF LN_EDIT_DFLT LN_EDIT_LANG LN_EDIT_TBL LN_FEEADDVWLNG LN_FEE_ADD_VW LN_FEE_SRCH LN_FEE_SRCHLNG LN_INSTUTN2_LNG LN_INSTUTN_2_VW LN_INSTUTN_TBL LN_TYPE_CL1_LNG LN_TYPE_CL2_LNG LN_TYPE_TBL LN_TYPE_VW_CL1 LN_TYPE_VW_CL2 LOAN_CASH_SUM PELL_ATTENDING PELL_PMT_OPN_VW PELL_PMT_OPTION PRG_CSH_DEST_VW PROG_CASH_PER PROG_CASH_PROG PROG_CASH_SUM RSTRC_AID RSTRC_AIDLNG RUN_CNTL_BDGT_P SERVICER_TBL SERVICER_VW SERVICER_VW2 SERVICER_VW_LN SFA_ASG_PARMS SFA_ASG_SETUP SFA_CODID_XF_VW SFA_COD_LN_ATTD SFA_COD_OPEID SFA_COD_OPEIDVW SFA_LN_ATTSRCH SFA_LN_SCHL_VW SFA_OPEID_XF_VW SFA_OPEID_XREF SFA_SLC_SETUP SFA_SLC_SETUPVW SFA_SPG_CMP_STY SFA_SULA_LD_CPY SFA_SULA_LD_TBL SRVCR_LOAD_LAN SRVCR_LOAD_TBL STDNTAYCAREERLN STDNT_AY_CAREER STDNT_PKG_SRCH STUPKG_CAR_SCTY STUPKG_INS_SCTY STUPKG_PLN_SCTY STUPKG_PRG_SCTY UPD904366_2_AET

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