FA_APP_SRC_RANK

(SQL Table)
 Index Back

Budget Tuition Source Ranking

Budget Source Rank defines the ranking order of application source types. The ranking order is used to determine where to derive the data to be used in assigning budgets to students.

  • Parent record: FA_APP_SRC_TBL

    • # 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 INFORMATION_SOURCE Character(1) VARCHAR2(1) NOT NULL Source of Information
    F=FAFSA Data
    I=Institutional Application
    7 INST_APP_SOURCE Character(1) VARCHAR2(1) NOT NULL Application Source
    0=Need Access
    0=Need Access
    1=Electronic Initial Application
    2=Renewal Application
    3=Electronic Correction
    4=FAFSA Express
    5=ACT
    6=I-NET
    7=NCS
    8=Profile
    9=Institutional Application
    O=FT Canada Student Loan
    P=PT Canada Student Loan

    Prompt Table: %EDITTABLE

    8 SOURCE_RANK Number(2,0) SMALLINT NOT NULL Source Ranking