SEV_SCHL_CD_TBL

(SQL Table)
 Index Back

SEVIS School Code Table

This record contains each School Code Number and its related information.

  • Parent Record Of SEV_PRG_INS_VW SEV_SCH_INS_TBL SEV_SCH_INS_VW SEV_SCH_INS_VW2 SEV_SCH_INS_VW3 SEV_SCH_OFF_TBL SEV_SCH_OFF_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SEV_SCHOOL_CD Character(15) VARCHAR2(15) NOT NULL SEVIS School Code
    2 SEV_DESCR Character(30) VARCHAR2(30) NOT NULL SEVIS Description
    3 SEV_ADDRESS1 Character(60) VARCHAR2(60) NOT NULL SEVIS Address 1
    4 SEV_CITY Character(60) VARCHAR2(60) NOT NULL SEVIS City
    5 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_NM_US_VW

    6 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    7 SCHOOL_OFFICIAL Character(30) VARCHAR2(30) NOT NULL School Official (name)
    8 TITLE Character(35) VARCHAR2(35) NOT NULL Title
    9 APPRVL_DT Date(10) DATE NOT NULL Approval Date