| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Default Value: DS2019_FORM.EMPLID
|
| 2 |
SEV_PRG_NBR |
Character(9) |
VARCHAR2(9) NOT NULL |
SEVIS Program Number
Default Value: DS2019_FORM.SEV_PRG_NBR
Prompt Table:
SEV_PRG_SP_TBL
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: DS2019_FORM.EFFDT
|
| 4 |
SEV_DEP_EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
SEVIS Dependent ID
Prompt Table:
PEOPLE_SRCH
|
| 5 |
SEV_RELATIONSHIP |
Character(2) |
VARCHAR2(2) NOT NULL |
SEVIS Relationship
01=Spouse
02=Child
Default Value: 02
|
| 6 |
SEV_DS_REL_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
SEVIS Relationship Status
A=Active
D=Deleted
E=Ended Status
T=Terminated
Default Value: A
|
| 7 |
COUNTRY_CODE_PERM |
Character(3) |
VARCHAR2(3) NOT NULL |
Permanent Country
Prompt Table:
COUNTRY_TBL
|
| 8 |
SEV_DS_END_REASON |
Character(2) |
VARCHAR2(2) NOT NULL |
DS2019 End Status Reason for Dependents
02=Death
03=Child over 21
04=Divorce
09=Other
|
| 9 |
SEV_DS_TERM_REASON |
Character(2) |
VARCHAR2(2) NOT NULL |
DS2019 Termination Reason for Dependents
01=Conviction of a Crime
03=Child Over 21
03=Child Over 21
03=Child Over 21
05=Unauthorized Employment
09=Other
|
| 10 |
SEV_EFFDT |
Date(10) |
DATE |
SEVIS Effective Date
|
| 11 |
SEV_BRTH_CNT_RSN |
Character(2) |
VARCHAR2(2) NOT NULL |
SEVIS Birth Country Reason Code
01=Born to Foreign Diplomat
02=Expatriated
|
| 12 |
SEV_REMARKS |
Long Character(500) |
VARCHAR2(500) |
Remarks
|