TIV_SCHOOL_TBL

(SQL Table)
 Index Back

Title IV Schools

Use SCHOOL_TBL to assign codes to schools, colleges, and universities to use as an edit table for SCHOOL_CODE in your database.

  • Related Language Record: TIVSCHOOLTBLLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year

    Default Value: OPR_DEF_TBL_CS.AID_YEAR

    Prompt Table: FED_AID_YR_TBL

    2 CPS_SCHOOL_CODE Character(6) VARCHAR2(6) NOT NULL CPS School Code. Also known as Title IV School Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: TIV_SCHOOL_TBL.DESCR

    5 TIV_ADDRESS Character(30) VARCHAR2(30) NOT NULL TIV Institution Code Address
    6 TIV_CITY Character(24) VARCHAR2(24) NOT NULL TIV Institution City
    7 TIV_STATE Character(2) VARCHAR2(2) NOT NULL TIV Institution State

    Prompt Table: HCR_ST_NM_VW_I

    8 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    9 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Default Value: INSTALLATION.COUNTRY

    Prompt Table: COUNTRY_TBL

    10 TIV_DLPART Character(1) VARCHAR2(1) NOT NULL TIV Inst Code DL Participant
    N=Not DL Participant
    Y=DL Participant