SEV_MST_BIO_VW

(SQL View)
 Index Back

SEVIS Master - Bio Demo Data


SELECT A.EMPLID , A.SEV_SCHOOL_CD , A.SEV_PRG_NBR , A.EFFDT , A.SEV_EXT_BATCH_ID , A.SEV_EXT_REQUEST_ID , A.EFF_STATUS , A.LAST_NAME , A.FIRST_NAME , A.MIDDLE_NAME , A.NAME_SUFFIX , A.BIRTHDATE , A.SEX , A.BIRTHCOUNTRY , A.BIRTHPLACE , A.COUNTRY_CODE_PERM , A.POSITION_CODE , A.CITIZEN_COUNTRY , A.VISA_PERMIT_TYPE , A.SEV_ISSUE_REASON , A.DRIVERS_LICENSE_NO , A.STATE , A.NATIONAL_ID , A.TAXPAYER_ID_NO , A.PASSPORT_NBR , A.COUNTRY_PASSPORT , A.EXPIRATN_DT , A.VISA_WRKPMT_NBR , A.COUNTRY_CD , A.EXPIRATION_DT , A.SEV_ADM_NBR , A.SEV_PORT_ENTRY , A.SEV_IMM_STATUS , A.SEV_ENTRY_DT , A.SEV_CRIMINAL_CONV , A.SEV_STDNT_TERM_RSN , A.SEV_TERM_DT , A.SEV_FORM_NBR , A.SEV_CREATE_REASON , A.START_DATE , A.END_DATE , A.SEV_EXTEND_FAILURE , A.SEV_CONCLD_FAILURE , A.SEV_APPROV_FAILURE , A.SEV_OTHER_FAILURE , A.SEV_INIT_START_DT , A.SEV_INFRACTION , A.SEV_EV_TERM_RSN , A.SEV_BRTH_CNT_RSN , A.DT_ISSUED , A.LASTUPDOPRID , A.LASTUPDDTTM FROM PS_SEV_MST_BIO A WHERE A.LASTUPDDTTM = ( SELECT MAX(A1.LASTUPDDTTM) FROM PS_SEV_MST_BIO A1 WHERE A1.EMPLID = A.EMPLID AND A1.SEV_SCHOOL_CD = A.SEV_SCHOOL_CD AND A1.SEV_PRG_NBR = A.SEV_PRG_NBR)

# 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 AS_OF_DATE Date(10) DATE As of Date
5 SEV_EXT_BATCH_ID Character(14) VARCHAR2(14) NOT NULL SEVIS Extract Batch ID
6 SEV_EXT_REQUEST_ID Character(20) VARCHAR2(20) NOT NULL SEVIS Extract Request ID
7 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
8 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
9 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
10 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL MIDDLE_NAME
11 NAME_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Suffix

Prompt Table: NAME_SUFFIX_TBL

12 BIRTHDATE Date(10) DATE Date of Birth
13 SEX Character(1) VARCHAR2(1) NOT NULL Gender
F=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec
14 BIRTHCOUNTRY Character(3) VARCHAR2(3) NOT NULL Birth Country

Prompt Table: COUNTRY_TBL

15 BIRTHPLACE Character(30) VARCHAR2(30) NOT NULL Birth Location
16 COUNTRY_CODE_PERM Character(3) VARCHAR2(3) NOT NULL Permanent Country

Prompt Table: COUNTRY_TBL

17 POSITION_CODE Character(3) VARCHAR2(3) NOT NULL Position Code
18 CITIZEN_COUNTRY Character(3) VARCHAR2(3) NOT NULL Country of Citizenship

Prompt Table: COUNTRY_TBL

19 VISA_PERMIT_TYPE Character(3) VARCHAR2(3) NOT NULL Visa/Permit Type

Prompt Table: VISA_PERMIT_USA

20 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
21 DRIVERS_LICENSE_NO Character(20) VARCHAR2(20) NOT NULL Driver's License #
22 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: STATE_NAMES_VW

23 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
24 TAXPAYER_ID_NO Character(9) VARCHAR2(9) NOT NULL Taxpayer ID Number
25 PASSPORT_NBR Character(15) VARCHAR2(15) NOT NULL Passport Number
26 COUNTRY_PASSPORT Character(3) VARCHAR2(3) NOT NULL Country Issuing Passport

Prompt Table: COUNTRY_TBL

27 EXPIRATN_DT Date(10) DATE Expiration Date
28 VISA_WRKPMT_NBR Character(15) VARCHAR2(15) NOT NULL Visa/Permit Number
29 COUNTRY_CD Character(3) VARCHAR2(3) NOT NULL Country Code

Prompt Table: COUNTRY_TBL

30 EXPIRATION_DT Date(10) DATE Expiration Date
31 SEV_ADM_NBR Character(11) VARCHAR2(11) NOT NULL SEVIS Admission Number
32 SEV_PORT_ENTRY Character(3) VARCHAR2(3) NOT NULL SEVIS Port of Entry

Prompt Table: SEV_POE_TBL

33 SEV_IMM_STATUS Character(3) VARCHAR2(3) NOT NULL SEVIS Immigration Status
34 SEV_ENTRY_DT Date(10) DATE SEVIS Entry Date
35 SEV_CRIMINAL_CONV Character(1) VARCHAR2(1) NOT NULL SEVIS Criminal Conviction

Y/N Table Edit

36 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
37 SEV_TERM_DT Date(10) DATE SEVIS Termination Date
38 SEV_FORM_NBR Character(30) VARCHAR2(30) NOT NULL SEVIS Form Number
39 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
40 START_DATE Date(10) DATE Start Date for Gen Standing PO
41 END_DATE Date(10) DATE End Date
42 SEV_EXTEND_FAILURE Character(1) VARCHAR2(1) NOT NULL SEVIS Extend Failure
43 SEV_CONCLD_FAILURE Character(1) VARCHAR2(1) NOT NULL SEVIS Conclude Failure
44 SEV_APPROV_FAILURE Character(1) VARCHAR2(1) NOT NULL SEVIS Approval Failure
45 SEV_OTHER_FAILURE Character(1) VARCHAR2(1) NOT NULL SEVIS Other Failure
46 SEV_INIT_START_DT Date(10) DATE Initial Start Date
47 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
48 SEV_EV_TERM_RSN Character(6) VARCHAR2(6) NOT NULL Termination Reason

Prompt Table: SEV_EV_TERM_RSN

49 SEV_BRTH_CNT_RSN Character(2) VARCHAR2(2) NOT NULL SEVIS Birth Country Reason Code
01=Born to Foreign Diplomat
02=Expatriated
50 DT_ISSUED Date(10) DATE Issue Date
51 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
52 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.