| # |
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 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
%EDITTABLE2
|
| 6 |
SEV_EVENT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
SEVIS Event Type
Prompt Table:
SEV_EVENT_TYPE
|
| 7 |
SEV_ALERT_ERROR |
Character(1) |
VARCHAR2(1) NOT NULL |
SEVIS Alert Error
Y/N Table Edit
Default Value: N
|
| 8 |
SEV_ALERT_ADD_DATA |
Character(1) |
VARCHAR2(1) NOT NULL |
SEVIS Additional Data
N=No Additional Data
R=Required Additional Data
Y=Optional Additional Data
Default Value: N
|
| 9 |
SEV_PRINT_FORM |
Character(1) |
VARCHAR2(1) NOT NULL |
SEVIS Print Form
Y/N Table Edit
Default Value: Y
|
| 10 |
SEV_EXTRACT |
Character(1) |
VARCHAR2(1) NOT NULL |
SEVIS Extract
M=Master Synch
N=None
Y=Send to SEVIS
Default Value: N
|
| 11 |
SEV_DSO_EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
SEVIS School Official Emplid
Prompt Table:
SEV_SCH_OFF_VW
|
| 12 |
SEV_RO_EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Responsible Officer
|
| 13 |
SEV_EXT_BATCH_ID |
Character(14) |
VARCHAR2(14) NOT NULL |
SEVIS Extract Batch ID
|
| 14 |
SEV_EXT_REQUEST_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
SEVIS Extract Request ID
|
| 15 |
SEV_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
SEVIS ID
|
| 16 |
SEV_PROCESS_DTTM |
DateTime(26) |
TIMESTAMP |
SEVIS Process DateTime
|
| 17 |
SEV_FILE_ERROR |
Character(5) |
VARCHAR2(5) NOT NULL |
SEVIS File Upload Error
|
| 18 |
SEV_FILE_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
SEVIS File Upload Status
0=Unsuccessful
1=Successful
|
| 19 |
SEV_MANUAL_ADD |
Character(1) |
VARCHAR2(1) NOT NULL |
Manually Inserted
Default Value: N
|
| 20 |
SEV_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
SEVIS Status
A=Active
C=Cancelled
D=Deactivated
F=Draft
I=Initial
L=Invalid
N=No Show
P=Completed
T=Terminated
V=Inactive
|
| 21 |
SEV_CHANGE_LVL_YN |
Character(1) |
VARCHAR2(1) NOT NULL |
Change Level Occurred
Y/N Table Edit
|
| 22 |
SEQNUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 23 |
SEV_REMARKS |
Long Character(500) |
VARCHAR2(500) |
Remarks
|