SEV_HST_DEP

(SQL Table)
 Index Back

SEVIS History - Dependents

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 SEV_SCHOOL_CD Character(15) VARCHAR2(15) NOT NULL SEVIS School Code
3 SEV_PRG_NBR Character(9) VARCHAR2(9) NOT NULL SEVIS Program Number
4 SEV_BATCH_ID Character(14) VARCHAR2(14) NOT NULL SEVIS Compare Batch ID
5 SEV_EVENT_NBR Number(5,0) INTEGER NOT NULL SEVIS Alert Detail Number
6 SEQUENCE_NBR Number(2,0) SMALLINT NOT NULL Sequence Number

Default Value: 1

7 SEV_DEP_EMPLID Character(11) VARCHAR2(11) NOT NULL SEVIS Dependent ID
8 SEV_RELATIONSHIP Character(2) VARCHAR2(2) NOT NULL SEVIS Relationship
01=Spouse
02=Child
9 SEV_REL_STATUS Character(1) VARCHAR2(1) NOT NULL SEVIS Relationship Status
A=Active
C=Cancelled
T=Terminated
10 SEV_ID Character(11) VARCHAR2(11) NOT NULL SEVIS ID
11 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
12 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
13 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL MIDDLE_NAME
14 NAME_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Suffix
15 BIRTHDATE Date(10) DATE Date of Birth
16 SEX Character(1) VARCHAR2(1) NOT NULL Gender
F=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec
17 BIRTHCOUNTRY Character(3) VARCHAR2(3) NOT NULL Birth Country
18 BIRTHPLACE Character(30) VARCHAR2(30) NOT NULL Birth Location
19 CITIZEN_COUNTRY Character(3) VARCHAR2(3) NOT NULL Country of Citizenship
20 VISA_PERMIT_TYPE Character(3) VARCHAR2(3) NOT NULL Visa/Permit Type

Prompt Table: VISA_PERMIT_TBL

21 COUNTRY_CODE_PERM Character(3) VARCHAR2(3) NOT NULL Permanent Country
22 SEV_TERM_RSN Character(2) VARCHAR2(2) NOT NULL SEVIS Termination Reason
01=Conviction of a Crime
02=Death
03=Child Over 21
04=Divorce
05=Unauthorized Employment
06=Principal Status Terminated
07=271 days later than Prg End Dt
08=271 days after Prncpl Trsfr Dt
09=Other
10=Principal Status Completed
23 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
24 SEV_EFFDT Date(10) DATE SEVIS Effective Date
25 SEV_DEP_CNCL_RSN Character(2) VARCHAR2(2) NOT NULL SEVIS Cancellation Reason
01=Record Created in error
02=Not accompanying student
26 SEV_FM_REPRINT Character(2) VARCHAR2(2) NOT NULL SEVIS F/M Reprint Reason
01=Travel Reprint Reason
02=Lost Reprint Reason
03=Stolen Reprint Reason
04=Damaged Reprint Reason
50=Updated
50=Updated
27 SEV_J_REPRINT Character(2) VARCHAR2(2) NOT NULL SEVIS J Reprint Reason
05=Other Reprint Reason
12=Lost Reprint Reason
13=Damaged Reprint Reason
14=Stolen Reprint Reason
28 SEV_BRTH_CNT_RSN Character(2) VARCHAR2(2) NOT NULL SEVIS Birth Country Reason Code
01=Born to Foreign Diplomat
02=Expatriated
29 SEV_FORM_PURPOSE Character(2) VARCHAR2(2) NOT NULL Purpose of Form
06=Accompanied by family members
08=Dependents to enter separately
30 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

31 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
32 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email Address
33 SEV_PREF_NAME Character(145) VARCHAR2(145) NOT NULL SEVIS Preferred Name
34 SEV_PASS_NAME Character(145) VARCHAR2(145) NOT NULL SEVIS Preferred Name
35 SEV_CITIZEN_STAT Character(2) VARCHAR2(2) NOT NULL SEVIS Citizen Status
03=Born to Foreign Diplomat
04=Expatriate