SEV_EXT_BATCH_IDSEV_EXT_REQUEST_IDEMPLIDSEV_DEP_EMPLID0=Unsuccessful
1=Successful
SEV_DOWNLD_DEP(SQL Table) |
Index Back |
|---|---|
SEVIS Download Result DepDependent record. |
| # | 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_DEP_EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | SEVIS Dependent ID |
| 5 | SEV_ID | Character(11) | VARCHAR2(11) NOT NULL | SEVIS ID |
| 6 | SEV_FILE_ERROR | Character(5) | VARCHAR2(5) NOT NULL | SEVIS File Upload Error |
| 7 | SEV_FILE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
SEVIS File Upload Status
0=Unsuccessful 1=Successful |
| 8 | SEV_REMARKS | Long Character(500) | VARCHAR2(500) | Remarks |