SEV_SCH_INS_VW2(SQL View) |
Index Back |
---|---|
SEVIS School Code Inst VW2This 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 |
# | 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 |