SEV_EXT_BATCH_IDSEV_EXT_REQUEST_IDEMPLIDPrompt Table: SEV_EVENT_TYPE
0=Unsuccessful
1=Successful
N=Master Record Not Found
Y=Master Record Found
Default Value: Y
SEV_DOWNLD_STDN(SQL Table) |
Index Back |
|---|---|
SEVIS Download - Student |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SEV_EXT_BATCH_ID |
Character(14) | VARCHAR2(14) NOT NULL | SEVIS Extract Batch ID |
| 2 | SEV_EXT_REQUEST_ID |
Character(20) | VARCHAR2(20) NOT NULL | SEVIS Extract Request ID |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | SEV_EVENT_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
SEVIS Event Type
Prompt Table: SEV_EVENT_TYPE |
| 5 | SEV_ID | Character(11) | VARCHAR2(11) NOT NULL | SEVIS ID |
| 6 | SEV_DSO_EMPLID | Character(11) | VARCHAR2(11) NOT NULL | SEVIS School Official Emplid |
| 7 | SEV_RO_EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Responsible Officer |
| 8 | SEV_PROCESS_DTTM | DateTime(26) | TIMESTAMP | SEVIS Process DateTime |
| 9 | SEV_FILE_ERROR | Character(5) | VARCHAR2(5) NOT NULL | SEVIS File Upload Error |
| 10 | SEV_FILE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
SEVIS File Upload Status
0=Unsuccessful 1=Successful |
| 11 | SEV_MST_FOUND | Character(1) | VARCHAR2(1) NOT NULL |
SEVIS Master Record Error
N=Master Record Not Found Y=Master Record Found Default Value: Y |
| 12 | SEV_REMARKS | Long Character(500) | VARCHAR2(500) | Remarks |
| 13 | SEV_PROV_ADDR | Character(254) | VARCHAR2(254) NOT NULL | SEVIS US Government Organization 1 Other Name |
| 14 | SEV_CORR_ADDR | Character(254) | VARCHAR2(254) NOT NULL | SEVIS US Government Organization 1 Other Name |
| 15 | SEV_ADDR_MSG | Character(254) | VARCHAR2(254) NOT NULL | SEVIS US Government Organization 1 Other Name |
| 16 | SEV_PROV_MADDR | Character(254) | VARCHAR2(254) NOT NULL | SEVIS US Government Organization 1 Other Name |
| 17 | SEV_CORR_MADDR | Character(254) | VARCHAR2(254) NOT NULL | SEVIS US Government Organization 1 Other Name |
| 18 | SEV_MADDR_MSG | Character(254) | VARCHAR2(254) NOT NULL | SEVIS US Government Organization 1 Other Name |
| 19 | SEV_ADDR_RESULT | Character(254) | VARCHAR2(254) NOT NULL | US Address Result |
| 20 | SEV_CORR_ADDR1 | Character(64) | VARCHAR2(64) NOT NULL | Corrected US Address 1 |
| 21 | SEV_CORR_ADDR2 | Character(64) | VARCHAR2(64) NOT NULL | Corrected US Address 2 |
| 22 | SEV_CORR_CITY | Character(60) | VARCHAR2(60) NOT NULL | Corrected US City |
| 23 | SEV_CORR_MADDR1 | Character(64) | VARCHAR2(64) NOT NULL | Corrected Mail Address 1 |
| 24 | SEV_CORR_MADDR2 | Character(64) | VARCHAR2(64) NOT NULL | Corrected Mail Address 2 |
| 25 | SEV_CORR_MCITY | Character(60) | VARCHAR2(60) NOT NULL | Corrected Mail City |
| 26 | SEV_CORR_MPOSTAL | Character(10) | VARCHAR2(10) NOT NULL | Corrected Mail Postal Code |
| 27 | SEV_CORR_MSTATE | Character(2) | VARCHAR2(2) NOT NULL | Corrected Mail State |
| 28 | SEV_CORR_POSTAL | Character(10) | VARCHAR2(10) NOT NULL | Corrected US Postal Code |
| 29 | SEV_CORR_STATE | Character(2) | VARCHAR2(2) NOT NULL | Corrected US State |
| 30 | SEV_MADDR_RESULT | Character(254) | VARCHAR2(254) NOT NULL | Mail Address Result |
| 31 | SEV_PROV_ADDR1 | Character(64) | VARCHAR2(64) NOT NULL | Provided US Address 1 |
| 32 | SEV_PROV_ADDR2 | Character(64) | VARCHAR2(64) NOT NULL | Provided US Address 2 |
| 33 | SEV_PROV_CITY | Character(60) | VARCHAR2(60) NOT NULL | Provided US City |
| 34 | SEV_PROV_MADDR1 | Character(64) | VARCHAR2(64) NOT NULL | Provided Mail Address 1 |
| 35 | SEV_PROV_MADDR2 | Character(64) | VARCHAR2(64) NOT NULL | Provided Mail Address 2 |
| 36 | SEV_PROV_MCITY | Character(60) | VARCHAR2(60) NOT NULL | Provided Mail City |
| 37 | SEV_PROV_MPOSTAL | Character(5) | VARCHAR2(5) NOT NULL | Provided Mail Postal Code |
| 38 | SEV_PROV_POSTAL | Character(5) | VARCHAR2(5) NOT NULL | Provided US Postal Code |
| 39 | SEV_PROV_STATE | Character(2) | VARCHAR2(2) NOT NULL | Provided US State |
| 40 | SEV_PROV_MSTATE | Character(2) | VARCHAR2(2) NOT NULL | Provided Mail State |