SEV_REV_DEP

(SQL Table)
 Index Back

SEVIS Alerts - Dependents

# 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 SEQUENCE_NBR Number(2,0) SMALLINT NOT NULL Sequence Number

Default Value: 1

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

Prompt Table: VISA_PERMIT_TBL

20 COUNTRY_CODE_PERM Character(3) VARCHAR2(3) NOT NULL Permanent Country
21 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
22 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
23 SEV_EFFDT Date(10) DATE SEVIS Effective Date
24 SEV_DEP_CNCL_RSN Character(2) VARCHAR2(2) NOT NULL SEVIS Cancellation Reason
01=Record Created in error
02=Not accompanying student
25 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
26 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
27 SEV_BRTH_CNT_RSN Character(2) VARCHAR2(2) NOT NULL SEVIS Birth Country Reason Code
01=Born to Foreign Diplomat
02=Expatriated
28 SEV_FORM_PURPOSE Character(2) VARCHAR2(2) NOT NULL Purpose of Form
06=Accompanied by family members
08=Dependents to enter separately
29 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

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