| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SEV_STDNT_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
SEVIS Student Visa Category
EV=Exchange Visitor
FM=F or M Visa Student
Default Value: FM
|
| 2 |
SEV_EVENT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
SEVIS Event Type
|
| 3 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 4 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 5 |
SEV_EVENT_TAG |
Character(25) |
VARCHAR2(25) NOT NULL |
SEVIS Event Tag
|
| 6 |
SEV_EVENT_ADD |
Character(1) |
VARCHAR2(1) NOT NULL |
SEVIS Allow Manual Addition
Y/N Table Edit
Default Value: N
|
| 7 |
SEV_FORM_RQST |
Character(1) |
VARCHAR2(1) NOT NULL |
Form Request Available
Y/N Table Edit
Default Value: N
|
| 8 |
SEV_PRINT_FORM |
Character(1) |
VARCHAR2(1) NOT NULL |
SEVIS Print Form
Y/N Table Edit
Default Value: N
|
| 9 |
SEV_EXTRACT |
Character(1) |
VARCHAR2(1) NOT NULL |
SEVIS Extract
M=Master Synch
N=None
Y=Send to SEVIS
Default Value: N
|
| 10 |
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
Default Value: A
Prompt Table:
SEV_XLAT_STT_VW
|
| 11 |
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
|
| 12 |
SEV_COMPARE_DTL |
Character(1) |
VARCHAR2(1) NOT NULL |
SEVIS Additional Data
N=No Additional Data
R=Required Additional Data
Y=Optional Additional Data
Y/N Table Edit
Default Value: N
|