INST_SCHL_VW

(SQL View)
 Index Back

Institution Appl Schools apld

This table stores Institutional Application data related to the various schools the student has sent their financial aid application data to.

select cps_school_code, aid_year, institution, descr, descrshort from PS_INST_SCHOOL_CDS

  • Related Language Record: INSTSCHLVWLNG

  • Parent record: AID_YEAR_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CPS_SCHOOL_CODE Character(6) VARCHAR2(6) NOT NULL CPS School Code. Also known as Title IV School Code

    Prompt Table: TIV_SCHOOL_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 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

    Default Value: TIV_SCHOOL_TBL.DESCR

    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: INST_SCHOOL_CDS.DESCR