| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PEOPLE_SRCH
|
| 2 |
SEV_PRG_NBR |
Character(9) |
VARCHAR2(9) NOT NULL |
SEVIS Program Number
Default Value: OPR_DEF_TBL_CS.SEV_PRG_NBR
Prompt Table:
SEV_PRG_SCTY_PR
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 4 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 5 |
INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
|
| 6 |
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
|
| 7 |
ACAD_PROG |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Program
Prompt Table:
ACAD_PROG_TBL
|
| 8 |
ADMIT_TERM |
Character(4) |
VARCHAR2(4) NOT NULL |
Admit Term
|
| 9 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
SEV_CITIZEN_VW
|
| 10 |
COUNTRY_CODE_PERM |
Character(3) |
VARCHAR2(3) NOT NULL |
Permanent Country
Prompt Table:
COUNTRY_TBL
|
| 11 |
POSITION_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Position Code
Prompt Table:
SEV_POS_CD_TBL
|
| 12 |
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
Default Value: NEW
|
| 13 |
SEV_INIT_START_DT |
Date(10) |
DATE |
Initial Start Date
|
| 14 |
SEV_FORM_NBR |
Character(30) |
VARCHAR2(30) NOT NULL |
SEVIS Form Number
|
| 15 |
START_DATE |
Date(10) |
DATE NOT NULL |
Start Date for Gen Standing PO
|
| 16 |
END_DATE |
Date(10) |
DATE NOT NULL |
End Date
|
| 17 |
VISITOR_CATEGORY |
Character(2) |
VARCHAR2(2) NOT NULL |
Visitor's Category
|
| 18 |
SUBJ_FIELD_CODE |
Character(8) |
VARCHAR2(8) NOT NULL |
Subj/Field Code
Prompt Table:
SEV_CIP_CODE_VW
|
| 19 |
FUNDING_RECEIVED |
Character(1) |
VARCHAR2(1) NOT NULL |
Received US Government Funds
Y/N Table Edit
Default Value: N
|
| 20 |
SUPPORT_AMT |
Number(8,0) |
INTEGER NOT NULL |
Current Program Sponsor Funds
|
| 21 |
AGENCY_CODE1 |
Character(8) |
VARCHAR2(8) NOT NULL |
US Government Agency Code
Prompt Table:
SEV_AGEN_CD_TBL
|
| 22 |
AGENCY_AMT1 |
Number(8,0) |
INTEGER NOT NULL |
Support Amount
|
| 23 |
AGENCY_CODE2 |
Character(8) |
VARCHAR2(8) NOT NULL |
US Government Agency Code 2
Prompt Table:
SEV_AGEN_CD_TBL
|
| 24 |
AGENCY_AMT2 |
Number(8,0) |
INTEGER NOT NULL |
Support Amount
|
| 25 |
ORG_CODE1 |
Character(8) |
VARCHAR2(8) NOT NULL |
Intl Organization Code
Prompt Table:
SEV_INT_ORG_TBL
|
| 26 |
ORG_AMT1 |
Number(8,0) |
INTEGER NOT NULL |
Support Amount
|
| 27 |
ORG_CODE2 |
Character(8) |
VARCHAR2(8) NOT NULL |
Intl Organization Code 2
Prompt Table:
SEV_INT_ORG_TBL
|
| 28 |
ORG_AMT2 |
Number(8,0) |
INTEGER NOT NULL |
Support Amount
|
| 29 |
VIS_COVERAGE_AMT |
Number(8,0) |
INTEGER NOT NULL |
Exchange Visitor's Government
|
| 30 |
VIS_COUNTRY_AMT |
Number(8,0) |
INTEGER NOT NULL |
Binational Commission
|
| 31 |
OTHER_ORG_AMT |
Number(8,0) |
INTEGER NOT NULL |
Other Organizations Support
|
| 32 |
PERSONAL_FUND_AMT |
Number(8,0) |
INTEGER NOT NULL |
Personal Funds
|
| 33 |
SEV_FUNDING_VERIFY |
Character(1) |
VARCHAR2(1) NOT NULL |
SEVIS Funding Verified
Y/N Table Edit
Default Value: N
|
| 34 |
SEV_RO_EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Responsible Officer
Prompt Table:
SEV_PRG_OFF_VW
|
| 35 |
DATE_PREPARER |
Date(10) |
DATE |
Date Prepared
Default Value: %date
|
| 36 |
DATE_SIGNED |
Date(10) |
DATE |
Date Signed
|
| 37 |
SEV_BRTH_CNT_RSN |
Character(2) |
VARCHAR2(2) NOT NULL |
SEVIS Birth Country Reason Code
01=Born to Foreign Diplomat
02=Expatriated
|
| 38 |
SEV_GOVT_OTHER1 |
Character(60) |
VARCHAR2(60) NOT NULL |
SEVIS US Government Organization 1 Other Name
|
| 39 |
SEV_GOVT_OTHER2 |
Character(60) |
VARCHAR2(60) NOT NULL |
SEVIS US Government Organization Other Name
|
| 40 |
SEV_INTL_OTHER1 |
Character(60) |
VARCHAR2(60) NOT NULL |
SEVIS International Organization Other Name
|
| 41 |
SEV_INTL_OTHER2 |
Character(60) |
VARCHAR2(60) NOT NULL |
SEVIS International Organization Other Name
|
| 42 |
SEV_ORG_OTHER |
Character(60) |
VARCHAR2(60) NOT NULL |
SEVIS Organization Other Name
|
| 43 |
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
|
| 44 |
SEV_FRN_DEG_LVL |
Character(100) |
VARCHAR2(100) NOT NULL |
SEVIS 6.0 - Foreign Degree Level
|
| 45 |
SEV_FRN_FLD_STDY |
Character(100) |
VARCHAR2(100) NOT NULL |
SEVIS 6.0 - Foreign Field of Study
|
| 46 |
SEV_REMARKS |
Long Character(500) |
VARCHAR2(500) |
Remarks
|
| 47 |
SEV_USADR_EXPCD |
Character(2) |
VARCHAR2(2) NOT NULL |
SEVIS Explanation Code
OB=Campus business address
OH=Campus housing address
OM=Campus mailing address
ON=New mailing address
OO=Other override
OP=New physical address
|
| 48 |
SEV_USADR_EXPTX |
Character(200) |
VARCHAR2(200) NOT NULL |
SEVIS Explanation Code
|
| 49 |
SEV_MLADR_EXPCD |
Character(2) |
VARCHAR2(2) NOT NULL |
SEVIS Explanation Code
OB=Campus business address
OH=Campus housing address
OM=Campus mailing address
ON=New mailing address
OO=Other override
OP=New physical address
|
| 50 |
SEV_MLADR_EXPTX |
Character(200) |
VARCHAR2(200) NOT NULL |
SEVIS Explanation Code
|