SEV_SCH_INS_VW2

(SQL View)
Index Back

SEVIS School Code Inst VW2

This record maps the SEVIS School Code to Institution/Acad Career

SELECT DISTINCT A.SEV_SCHOOL_CD ,A.INSTITUTION FROM PS_SEV_SCH_INS_TBL A

  • Parent record: SEV_SCHL_CD_TBL
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SEV_SCHOOL_CD Character(15) VARCHAR2(15) NOT NULL SEVIS School Code
    2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL