SEV_HST_BIO

(SQL Table)
Index Back

SEVIS History - Bio Demo Data

# 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 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
8 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
9 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL MIDDLE_NAME
10 NAME_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Suffix
11 BIRTHDATE Date(10) DATE Date of Birth
12 SEX Character(1) VARCHAR2(1) NOT NULL Gender
F=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec
13 BIRTHCOUNTRY Character(3) VARCHAR2(3) NOT NULL Birth Country
14 BIRTHPLACE Character(30) VARCHAR2(30) NOT NULL Birth Location
15 COUNTRY_CODE_PERM Character(3) VARCHAR2(3) NOT NULL Permanent Country
16 POSITION_CODE Character(3) VARCHAR2(3) NOT NULL Position Code
17 CITIZEN_COUNTRY Character(3) VARCHAR2(3) NOT NULL Country of Citizenship
18 VISA_PERMIT_TYPE Character(3) VARCHAR2(3) NOT NULL Visa/Permit Type
19 SEV_ISSUE_REASON Character(1) VARCHAR2(1) NOT NULL SEVIS Issue Reason
C=Continued Attendance
I=Initial Creation
O=Other
R=Reinstatement Request
S=Initial - Change of Status
T=School Transfer
20 DRIVERS_LICENSE_NO Character(20) VARCHAR2(20) NOT NULL Driver's License #
21 STATE Character(6) VARCHAR2(6) NOT NULL State
22 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
23 TAXPAYER_ID_NO Character(9) VARCHAR2(9) NOT NULL Taxpayer ID Number
24 PASSPORT_NBR Character(15) VARCHAR2(15) NOT NULL Passport Number
25 COUNTRY_PASSPORT Character(3) VARCHAR2(3) NOT NULL Country Issuing Passport
26 EXPIRATN_DT Date(10) DATE Expiration Date
27 VISA_WRKPMT_NBR Character(15) VARCHAR2(15) NOT NULL Visa/Permit Number
28 COUNTRY_CD Character(3) VARCHAR2(3) NOT NULL Country Code
29 EXPIRATION_DT Date(10) DATE Expiration Date
30 SEV_ADM_NBR Character(11) VARCHAR2(11) NOT NULL SEVIS Admission Number
31 SEV_PORT_ENTRY Character(3) VARCHAR2(3) NOT NULL SEVIS Port of Entry
32 SEV_IMM_STATUS Character(3) VARCHAR2(3) NOT NULL SEVIS Immigration Status
33 SEV_ENTRY_DT Date(10) DATE SEVIS Entry Date
34 SEV_CRIMINAL_CONV Character(1) VARCHAR2(1) NOT NULL SEVIS Criminal Conviction

Y/N Table Edit

Default Value: N

35 SEV_STDNT_TERM_RSN Character(2) VARCHAR2(2) NOT NULL SEVIS Student Termination Reason
01=Unauthorized Withdrawal
02=Death
03=Unauthorized Employment
04=Unauth Drop Below Full Course
05=Unauth DBFC Time Exceeded
06=Change of Nonimmigrant Classif
06=Change of Nonimmigrant Classif
07=Chng of Nonimmig Class Denied
07=Chng of Nonimmig Class Denied
08=Expulsion
09=Suspension
10=Absent fr Country for 5 months
11=Failure to Enroll
12=Costs Exceed Resources
12=Costs Exceed Resources
13=Transfer Student No Show
14=Denied Transfer (M-1 Only)
15=Extension Denied (M-1 Only)
16=Failing to Maintain Status
17=Violation Change of Status
18=Change of Status Denied
19=Change of Status Withdrawn
20=Change of Status Approved
21=Transfer Withdrawn (M-1 Only)
22=No Show-Manual Termination
23=Authorized Early Withdrawal
25=School Withdrawn
36 SEV_TERM_DT Date(10) DATE SEVIS Termination Date
37 SEV_FORM_NBR Character(30) VARCHAR2(30) NOT NULL SEVIS Form Number
38 SEV_CREATE_REASON Character(4) VARCHAR2(4) NOT NULL SEVIS Create Reason
1=Begin New Program
2=Continuing Exchange Visitor
3=Transfer In From Non-SEVIS
CONT=Continuing
NEW=New
39 START_DATE Date(10) DATE Start Date for Gen Standing PO
40 END_DATE Date(10) DATE End Date
41 SEV_EXTEND_FAILURE Character(1) VARCHAR2(1) NOT NULL SEVIS Extend Failure
42 SEV_CONCLD_FAILURE Character(1) VARCHAR2(1) NOT NULL SEVIS Conclude Failure
43 SEV_APPROV_FAILURE Character(1) VARCHAR2(1) NOT NULL SEVIS Approval Failure
44 SEV_OTHER_FAILURE Character(1) VARCHAR2(1) NOT NULL SEVIS Other Failure
45 SEV_INIT_START_DT Date(10) DATE Initial Start Date
46 SEV_INFRACTION Character(3) VARCHAR2(3) NOT NULL EV Infraction Type
CON=Failure to conclude transfer
EXT=Failure to extend DS-2019
OTH=Other
REC=Failure to get RO/ARO approval
47 SEV_EV_TERM_RSN Character(6) VARCHAR2(6) NOT NULL Termination Reason

Prompt Table: SEV_EV_TERM_RSN

48 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
49 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
50 SEV_BRTH_CNT_RSN Character(2) VARCHAR2(2) NOT NULL SEVIS Birth Country Reason Code
01=Born to Foreign Diplomat
02=Expatriated
51 DT_ISSUED Date(10) DATE Issue Date
52 SEV_CAPGAP_EXT Character(1) VARCHAR2(1) NOT NULL SEVIS 6.0 - Cap Gap Extension Status
C=Cancelled
F=Filed
T=Waitlisted
53 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email Address
54 SEV_PREF_NAME Character(145) VARCHAR2(145) NOT NULL SEVIS Preferred Name
55 SEV_PASS_NAME Character(145) VARCHAR2(145) NOT NULL SEVIS Preferred Name
56 SEV_PHONE Number(10,0) DECIMAL(10) NOT NULL Sevis Phone
57 SEV_FOREIGN_PHONE Number(20,0) DECIMAL(20) NOT NULL Foreign Phone
58 SEV_NO_PHONE Character(1) VARCHAR2(1) NOT NULL No Phone
59 SEV_PHONE_COUNTRY Number(4,0) SMALLINT NOT NULL Phone Country
60 SEV_CITIZEN_STAT Character(2) VARCHAR2(2) NOT NULL SEVIS Citizen Status
03=Born to Foreign Diplomat
04=Expatriate