SEV_SCHOOL_CDDefault Value: SEV_SCHL_CD_TBL.SEV_SCHOOL_CD
INSTITUTIONPrompt Table: INSTITUTION_TBL
SEV_SCH_INS_VW(SQL View) |
Index Back |
|---|---|
SEVIS School Code InstitutionThis record maps the SEVIS School Code to Institution/Acad Career |
| SELECT DISTINCT SEV_SCHOOL_CD , INSTITUTION FROM PS_SEV_SCH_INS_TBL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SEV_SCHOOL_CD |
Character(15) | VARCHAR2(15) NOT NULL |
SEVIS School Code
Default Value: SEV_SCHL_CD_TBL.SEV_SCHOOL_CD |
| 2 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |