| # |
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 |
SEQNUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence Number
Default Value: 1
|
| 5 |
EFFDT |
Date(10) |
DATE |
Effective Date
|
| 6 |
SEV_EXT_BATCH_ID |
Character(14) |
VARCHAR2(14) NOT NULL |
SEVIS Extract Batch ID
|
| 7 |
SEV_EXT_REQUEST_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
SEVIS Extract Request ID
|
| 8 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
|
| 9 |
SEV_MAJOR |
Character(10) |
VARCHAR2(10) NOT NULL |
SEVIS Major - Acad Plan
Prompt Table:
ACAD_PLAN_TBL
|
| 10 |
SEV_CIP_MAJOR |
Character(13) |
VARCHAR2(13) NOT NULL |
CIP 2000
|
| 11 |
SEV_SEC_MAJOR |
Character(10) |
VARCHAR2(10) NOT NULL |
SEVIS Secondary Major
Prompt Table:
ACAD_PLAN_TBL
|
| 12 |
SEV_CIP_SEC_MAJOR |
Character(13) |
VARCHAR2(13) NOT NULL |
CIP 2000
|
| 13 |
SEV_MINOR |
Character(10) |
VARCHAR2(10) NOT NULL |
SEVIS Minor
|
| 14 |
SEV_CIP_MINOR |
Character(13) |
VARCHAR2(13) NOT NULL |
CIP 2000
|
| 15 |
LENGTH_OF_STUDY |
Number(2,0) |
SMALLINT NOT NULL |
SEVIS Length of study
|
| 16 |
FROM_DATE |
Date(10) |
DATE |
From Date
|
| 17 |
TO_DATE |
Date(10) |
DATE |
Latest Date to be sent to PYR
|
| 18 |
SEV_END_PGM_RSN |
Character(4) |
VARCHAR2(4) NOT NULL |
SEVIS End Program Reason
APED=Adjusted program end date
CCHG=Cancellation - status change
CCHG=Cancellation - status change
CHG=Change of Status
CHG=Change of Status
COMP=Completed
COMP=Completed
CSHS=Cultural shock/homesickness
DCHG=Denied - change of status
DCHG=Denied - change of status
DOE=Death of EV
ICP=Inability to continue program
ICP=Inability to continue program
IFS=Inadequate financial support
MEHE=Medical emergency/health
MEHF=Medical/health of family
NOS=No Show
NOS=No Show
OTHR=Other
PCP=PgmCmp >=30 days before End Dt
PCP=PgmCmp >=30 days before End Dt
POCE=Program objectives comp early
WFP=Withdrawal from program
|
| 19 |
SEV_EFFDT |
Date(10) |
DATE |
SEVIS Effective Date
|
| 20 |
ENG_PROFICIENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
English Proficiency Required
Y/N Table Edit
|
| 21 |
PROFICENCY_TEST |
Character(1) |
VARCHAR2(1) NOT NULL |
Proficient
N=Student is not proficient yet
Y=Student is proficient
|
| 22 |
ACAD_PLAN |
Character(10) |
VARCHAR2(10) NOT NULL |
Academic Plan
|
| 23 |
SUBJ_FIELD_CODE |
Character(8) |
VARCHAR2(8) NOT NULL |
Subj/Field Code
Prompt Table:
SEV_CIP_CODE_VW
|
| 24 |
VISITOR_CATEGORY |
Character(2) |
VARCHAR2(2) NOT NULL |
Visitor's Category
|
| 25 |
SEV_MATRIC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Matriculation Type
A=Associates
B=Bachelors
D=Doctorate
M=Masters
|
| 26 |
PROG_ACTION |
Character(4) |
VARCHAR2(4) NOT NULL |
Program Action
ACTV=Activate
ADMT=Admit
ADRV=Admission Revocation
APPL=Application
COMP=Completion of Program
COND=Conditional Admit
DATA=Data Change
DDEF=Defer Decision
DEFR=Defer Enrollment
DEIN=Intention to Matriculate
DENY=Deny
DISC=Discontinuation
DISM=Dismissal
LEAV=Leave of Absence
MATR=Matriculation
PLNC=Plan Change
PRGC=Program Change
RADM=Readmit
RAPP=Readmit Application
RECN=Reconsideration
REVK=Revoke Degree
RLOA=Return from Leave of Absence
SPND=Suspension
TRAN=Transfer to Other Career
VDIS=Voluntarily Discontinued
WADM=Administrative Withdrawal
WAIT=Waitlist
WAOF=Waitlist Offer
WAPP=Applicant Withdrawal
|
| 27 |
INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table:
INSTITUTION_TBL
|
| 28 |
ACAD_CAREER |
Character(4) |
VARCHAR2(4) NOT NULL |
Academic Career
BAC=Bachelor (NLD)
BBL=Vocational Coaching (NLD)
BOL=Vocational Training (NLD)
BUSN=Graduate Business
CNED=Continuing Education
CRED=Semester Credit
EDU=Education (NLD)
EXED=Extended Education
GRAD=Graduate
LAW=Law
MEDS=Medical School
NONA=Non Award
PGRD=Postgraduate
RSCH=Research
TECH=Technical
UENG=Undergraduate Engineering
UGRD=Undergraduate
VAVO=Advanced General Educ. (NLD)
VETM=Veterinary Medicine
Prompt Table:
ACAD_CAR_TBL
|
| 29 |
STDNT_CAR_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Student Career Nbr
|
| 30 |
SEV_ORIG_TO_DATE |
Date(10) |
DATE |
Original End Date
|
| 31 |
LVL_OF_EDUC |
Character(2) |
VARCHAR2(2) NOT NULL |
Level of Education
01=Primary
02=Secondary
03=Associate
04=Bachelors
05=Masters
06=Doctorate
07=Language training
08=High School
09=Flight training
10=Other vocational school
11=Other
99=No Valid Values
|
| 32 |
SEV_CANCEL_RSN |
Character(2) |
VARCHAR2(2) NOT NULL |
SEVIS Student Cancellation Reason
01=Student not attending
02=Visa for different SEVIS ID
03=Registered under different ID
04=Arrived under different ID
05=Record created in error
06=Offer withdrawn
|
| 33 |
NBR_MONTH |
Number(2,0) |
SMALLINT NOT NULL |
Months in an academic term
|
| 34 |
TUITION_FEES |
Number(8,0) |
INTEGER NOT NULL |
Tuition and fees
|
| 35 |
LIVING_EXPENSES |
Number(8,0) |
INTEGER NOT NULL |
Living expenses
|
| 36 |
DEPENDENT_EXPENSES |
Number(8,0) |
INTEGER NOT NULL |
Dependent Expenses
|
| 37 |
OTHER_EXPENSES |
Number(8,0) |
INTEGER NOT NULL |
Other expenses
|
| 38 |
PERSONAL_FUND |
Number(8,0) |
INTEGER NOT NULL |
Student's personal funds
|
| 39 |
SCHOOL_FUND |
Number(8,0) |
INTEGER NOT NULL |
School fund
|
| 40 |
FUND_OTHER_SOURCE |
Number(8,0) |
INTEGER NOT NULL |
Funds from another source
|
| 41 |
ON_CAMPUS_EMPLOY |
Number(8,0) |
INTEGER NOT NULL |
On-campus employment
|
| 42 |
SUPPORT_AMT |
Number(8,0) |
INTEGER NOT NULL |
Current Program Sponsor Funds
|
| 43 |
AGENCY_AMT1 |
Number(8,0) |
INTEGER NOT NULL |
Support Amount
|
| 44 |
AGENCY_CODE1 |
Character(8) |
VARCHAR2(8) NOT NULL |
US Government Agency Code
Prompt Table:
SEV_AGEN_CD_TBL
|
| 45 |
AGENCY_AMT2 |
Number(8,0) |
INTEGER NOT NULL |
Support Amount
|
| 46 |
AGENCY_CODE2 |
Character(8) |
VARCHAR2(8) NOT NULL |
US Government Agency Code 2
Prompt Table:
SEV_AGEN_CD_TBL
|
| 47 |
ORG_AMT1 |
Number(8,0) |
INTEGER NOT NULL |
Support Amount
|
| 48 |
ORG_CODE1 |
Character(8) |
VARCHAR2(8) NOT NULL |
Intl Organization Code
Prompt Table:
SEV_INT_ORG_TBL
|
| 49 |
ORG_AMT2 |
Number(8,0) |
INTEGER NOT NULL |
Support Amount
|
| 50 |
ORG_CODE2 |
Character(8) |
VARCHAR2(8) NOT NULL |
Intl Organization Code 2
Prompt Table:
SEV_INT_ORG_TBL
|
| 51 |
VIS_COVERAGE_AMT |
Number(8,0) |
INTEGER NOT NULL |
Exchange Visitor's Government
|
| 52 |
VIS_COUNTRY_AMT |
Number(8,0) |
INTEGER NOT NULL |
Binational Commission
|
| 53 |
OTHER_ORG_AMT |
Number(8,0) |
INTEGER NOT NULL |
Other Organizations Support
|
| 54 |
PERSONAL_FUND_AMT |
Number(8,0) |
INTEGER NOT NULL |
Personal Funds
|
| 55 |
FUNDING_RECEIVED |
Character(1) |
VARCHAR2(1) NOT NULL |
Received US Government Funds
Y/N Table Edit
|
| 56 |
SEV_GOVT_OTHER1 |
Character(60) |
VARCHAR2(60) NOT NULL |
SEVIS US Government Organization 1 Other Name
|
| 57 |
SEV_GOVT_OTHER2 |
Character(60) |
VARCHAR2(60) NOT NULL |
SEVIS US Government Organization Other Name
|
| 58 |
SEV_INTL_OTHER1 |
Character(60) |
VARCHAR2(60) NOT NULL |
SEVIS International Organization Other Name
|
| 59 |
SEV_INTL_OTHER2 |
Character(60) |
VARCHAR2(60) NOT NULL |
SEVIS International Organization Other Name
|
| 60 |
SEV_ORG_OTHER |
Character(60) |
VARCHAR2(60) NOT NULL |
SEVIS Organization Other Name
|
| 61 |
SEV_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
SEVIS Status
A=Active
C=Cancelled
D=Deactivated
F=Draft
I=Initial
L=Invalid
N=No Show
P=Completed
T=Terminated
V=Inactive
|
| 62 |
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.
|
| 63 |
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.
|
| 64 |
SEV_OCC_CAT |
Character(2) |
VARCHAR2(2) NOT NULL |
SEVIS Occupational Category - New field introduced in SEVIS 5.7 to track the category associated with the Intern or Trainee occupation.
01=Arts and Culture
02=Information Media and Comm
03=Ed/Soc/Lib/Consl/Soc Sciences
04=Mgmt. Bus/Commerce/Fin
05=Health Related Occupations
06=Aviation
07=Eng./Arch/Math/Ind Occupations
08=Construction Building Trades
09=Agriculture Forestry Fishing
10=Public Admin. and Law
11=Other
12=Hospitality and Tourism
99=Unknown
|
| 65 |
SEV_FRN_DEG_LVL |
Character(100) |
VARCHAR2(100) NOT NULL |
SEVIS 6.0 - Foreign Degree Level
|
| 66 |
SEV_FRN_FLD_STDY |
Character(100) |
VARCHAR2(100) NOT NULL |
SEVIS 6.0 - Foreign Field of Study
|
| 67 |
SEV_ISS_DATE |
Date(10) |
DATE |
SEVIS Initial Session Start Date
|