FA_APP_SRC_TBL

(SQL Table)
 Index Back

FA Application Source Table

FA Application Source Table shows the valid sources of application data used in the different FA functions such as budgeting and packaging.

  • Related Language Record: FA_APP_SRC_LANG

  • Parent record: FA_APP_SRC_TYP

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

    3 SOURCE_RANK_TYPE Character(1) VARCHAR2(1) NOT NULL Source Rank Type
    B=Budgets
    P=Packaging
    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %Date

    5 AWARD_PERIOD Character(1) VARCHAR2(1) NOT NULL Award Period
    A=Academic
    N=Non Standard

    Default Value: A

    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 DESCRLONG Long Character CLOB Long Description