SEV_HST_EMD(SQL Table) |
Index Back |
|---|---|
SEVIS Alerts Employer Details |
| # | 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_PRG_NBR |
Character(9) | VARCHAR2(9) NOT NULL | SEVIS Program Number |
| 3 | SEV_BATCH_ID |
Character(14) | VARCHAR2(14) NOT NULL | SEVIS Compare Batch ID |
| 4 | SEV_EVENT_NBR |
Number(5,0) | INTEGER NOT NULL | SEVIS Alert Detail Number |
| 5 | SEQUENCE_NBR |
Number(2,0) | SMALLINT NOT NULL | Sequence Number |
| 6 | SEV_EMPL_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
SEVIS Employment Type
01=Optional Practical Training 02=Curricular Practical Training 03=Off-Campus |
| 7 | SEQNUM |
Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 8 | SEQUENCE_NUMBER |
Number(2,0) | SMALLINT NOT NULL | Sequence Number |
| 9 | SEV_EMPLOYER_NAME | Character(254) | VARCHAR2(254) NOT NULL | Supervisor First Name |
| 10 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 11 | END_DATE | Date(10) | DATE | End Date |
| 12 | SEV_EXT_EMPLOYER | Character(1) | VARCHAR2(1) NOT NULL | Supervisor First Name |
| 13 | SEV_PRV_START_DT | Date(10) | DATE | SEVIS 6.0 - Previous OPT Start Date |
| 14 | SEV_PRV_EMP_NAME | Character(254) | VARCHAR2(254) NOT NULL | Supervisor First Name |
| 15 | SEV_ADDRESS1 | Character(60) | VARCHAR2(60) NOT NULL | SEVIS Address 1 |
| 16 | SEV_ADDRESS2 | Character(60) | VARCHAR2(60) NOT NULL | SEVIS Address 2 |
| 17 | US_CITY | Character(60) | VARCHAR2(60) NOT NULL | City |
| 18 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 19 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 20 | SEV_USADR_EXPCD | Character(2) | VARCHAR2(2) NOT NULL |
SEVIS Explanation Code
OB=Campus business address OH=Campus housing address OM=Campus mailing address ON=New mailing address OO=Other override OP=New physical address |
| 21 | SEV_USADR_EXPTX | Character(200) | VARCHAR2(200) NOT NULL | SEVIS Explanation Code |
| 22 | SEV_EMPL_CODE | Character(2) | VARCHAR2(2) NOT NULL |
SEVIS Employment Code
01=Full Time 02=Part Time |
| 23 | SEV_EMPL_EIN | Character(9) | VARCHAR2(9) NOT NULL | Employer Identification Number |
| 24 | SEV_JOB_TITLE | Character(64) | VARCHAR2(64) NOT NULL | Job Title |
| 25 | SEV_CRSE_REL | Long Character(1000) | VARCHAR2(1000) | Course Relevance |
| 26 | SEV_SELF_EMPL | Character(1) | VARCHAR2(1) NOT NULL | Self Employed |
| 27 | SEV_SPVR_FNAME | Character(80) | VARCHAR2(80) NOT NULL | Supervisor First Name |
| 28 | SEV_SPVR_LNAME | Character(40) | VARCHAR2(40) NOT NULL | Supervisor Last Name |
| 29 | SEV_PHONE | Number(10,0) | DECIMAL(10) NOT NULL | Sevis Phone |
| 30 | SEV_SPVR_EXT | Number(8,0) | INTEGER NOT NULL | Supervisor Phone Ext |
| 31 | EMAIL_ADDR | Character(70) | VARCHAR2(70) NOT NULL | Email Address |