Model SEVIS

Model Label : Banner General SEVIS
Path : Default Folder/B70/General/SEVIS

List of Objects

Object Name	Object Type	Layer Name
GOBSEVS	TABLE	Default
GORSEVD	TABLE	Default
GORSEVH	TABLE	Default
GORSEVS	TABLE	Default
GORSVAH	TABLE	Default
GORSVEH	TABLE	Default
GTVSVCC	TABLE	Default
GTVSVCP	TABLE	Default
GTVSVCR	TABLE	Default
GTVSVDT	TABLE	Default
GTVSVEL	TABLE	Default
GTVSVEP	TABLE	Default
GTVSVFT	TABLE	Default
GTVSVPC	TABLE	Default
GTVSVRP	TABLE	Default
GTVSVTR	TABLE	Default
GTVSVTS	TABLE	Default
SPBPERS	TABLE	Default
SPBPERS link	User Object	Default
SPRIDEN	TABLE	Default
SPRIDEN link	User Object	Default
STVRELT	TABLE	Default
STVVTYP	TABLE	Default

Comments

Model View

Table GOBSEVS

Schema Name GENERAL
Label GOBSEVS
Server name S4B70
Creation Date 09/29/2003 12:04:33:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
GOBSEVS_PIDM	GOBSEVS_PIDM	NUMBER(8,0)	No	*	*
GOBSEVS_ENG_PROF_REQ_IND	GOBSEVS_ENG_PROF_REQ_IND	VARCHAR2(1)	No
GOBSEVS_ENG_PROF_MET_IND	GOBSEVS_ENG_PROF_MET_IND	VARCHAR2(1)	No
GOBSEVS_CRIMINAL_CONVICT_IND	GOBSEVS_CRIMINAL_CONVICT_IND	VARCHAR2(1)	No
GOBSEVS_TERMINATE_STUDENT_IND	GOBSEVS_TERMINATE_STUDENT_IND	VARCHAR2(1)	No
GOBSEVS_EXTEND_FAILURE_IND	GOBSEVS_EXTEND_FAILURE_IND	VARCHAR2(1)	No
GOBSEVS_TRANSFER_FAIL_IND	GOBSEVS_TRANSFER_FAIL_IND	VARCHAR2(1)	No
GOBSEVS_APPROVAL_FAIL_IND	GOBSEVS_APPROVAL_FAIL_IND	VARCHAR2(1)	No
GOBSEVS_OTHER_INFRACT_IND	GOBSEVS_OTHER_INFRACT_IND	VARCHAR2(1)	No
GOBSEVS_ACTIVITY_DATE	GOBSEVS_ACTIVITY_DATE	DATE	No
GOBSEVS_USER_ID	GOBSEVS_USER_ID	VARCHAR2(30)	No
GOBSEVS_BIRTH_NATN_CODE	GOBSEVS_BIRTH_NATN_CODE	VARCHAR2(5)	Yes		*
GOBSEVS_LEGAL_NATN_CODE	GOBSEVS_LEGAL_NATN_CODE	VARCHAR2(5)	Yes		*
GOBSEVS_PROGRAM_BEGIN_DATE	GOBSEVS_PROGRAM_BEGIN_DATE	DATE	Yes
GOBSEVS_PROGRAM_END_DATE	GOBSEVS_PROGRAM_END_DATE	DATE	Yes
GOBSEVS_PROGRAM_ENROLL_DATE	GOBSEVS_PROGRAM_ENROLL_DATE	DATE	Yes
GOBSEVS_ENG_PROF_REASON	GOBSEVS_ENG_PROF_REASON	VARCHAR2(500)	Yes
GOBSEVS_ACADEMIC_TERM_MONTHS	GOBSEVS_ACADEMIC_TERM_MONTHS	NUMBER(3,0)	Yes
GOBSEVS_TUITION_EXPENSE	GOBSEVS_TUITION_EXPENSE	NUMBER(12,2)	Yes
GOBSEVS_PERSONAL_FUNDS	GOBSEVS_PERSONAL_FUNDS	NUMBER(12,2)	Yes
GOBSEVS_TRANS_CDE	GOBSEVS_TRANS_CDE	VARCHAR2(10)	Yes
GOBSEVS_SEVIS_ID	GOBSEVS_SEVIS_ID	VARCHAR2(11)	Yes
GOBSEVS_VTYP_CODE	GOBSEVS_VTYP_CODE	VARCHAR2(2)	Yes		*
GOBSEVS_SVCR_CODE	GOBSEVS_SVCR_CODE	VARCHAR2(4)	Yes		*
GOBSEVS_SESSION_START_DATE	GOBSEVS_SESSION_START_DATE	DATE	Yes
GOBSEVS_SESSION_END_DATE	GOBSEVS_SESSION_END_DATE	DATE	Yes
GOBSEVS_TRANSFER_COMMENT	GOBSEVS_TRANSFER_COMMENT	VARCHAR2(500)	Yes
GOBSEVS_ISSUE_COMMENT	GOBSEVS_ISSUE_COMMENT	VARCHAR2(500)	Yes
GOBSEVS_SVEL_CODE	GOBSEVS_SVEL_CODE	VARCHAR2(2)	Yes		*
GOBSEVS_MAJR_CODE	GOBSEVS_MAJR_CODE	VARCHAR2(4)	Yes		*
GOBSEVS_STUDY_LENGTH	GOBSEVS_STUDY_LENGTH	NUMBER(3,0)	Yes
GOBSEVS_LIVING_EXPENSES	GOBSEVS_LIVING_EXPENSES	NUMBER(12,2)	Yes
GOBSEVS_SVFT_CODE	GOBSEVS_SVFT_CODE	VARCHAR2(2)	Yes		*
GOBSEVS_AUTH_START_DATE	GOBSEVS_AUTH_START_DATE	DATE	Yes
GOBSEVS_COMPLETION_REMARKS	GOBSEVS_COMPLETION_REMARKS	VARCHAR2(500)	Yes
GOBSEVS_NEW_PROGRAM_END_DATE	GOBSEVS_NEW_PROGRAM_END_DATE	DATE	Yes
GOBSEVS_DA_PROGRAM_START_DATE	GOBSEVS_DA_PROGRAM_START_DATE	DATE	Yes
GOBSEVS_DA_PROGRAM_END_DATE	GOBSEVS_DA_PROGRAM_END_DATE	DATE	Yes
GOBSEVS_DISC_ACTION_TEXT	GOBSEVS_DISC_ACTION_TEXT	VARCHAR2(500)	Yes
GOBSEVS_EMPLOYMENT_CDE	GOBSEVS_EMPLOYMENT_CDE	VARCHAR2(2)	Yes
GOBSEVS_EMPLOYMENT_COMMENT	GOBSEVS_EMPLOYMENT_COMMENT	VARCHAR2(500)	Yes
GOBSEVS_EMPLOYMENT_START_DATE	GOBSEVS_EMPLOYMENT_START_DATE	DATE	Yes
GOBSEVS_EMPLOYMENT_END_DATE	GOBSEVS_EMPLOYMENT_END_DATE	DATE	Yes
GOBSEVS_EMPLOYMENT_TYPE_CDE	GOBSEVS_EMPLOYMENT_TYPE_CDE	VARCHAR2(2)	Yes
GOBSEVS_EMPLOYER_LAST_NAME	GOBSEVS_EMPLOYER_LAST_NAME	VARCHAR2(500)	Yes
GOBSEVS_EMPLOYER_FIRST_NAME	GOBSEVS_EMPLOYER_FIRST_NAME	VARCHAR2(40)	Yes
GOBSEVS_EMP_ADDRESS_LINE1	GOBSEVS_EMP_ADDRESS_LINE1	VARCHAR2(60)	Yes
GOBSEVS_EMP_ADDRESS_LINE2	GOBSEVS_EMP_ADDRESS_LINE2	VARCHAR2(60)	Yes
GOBSEVS_EMPLOYER_CITY	GOBSEVS_EMPLOYER_CITY	VARCHAR2(60)	Yes
GOBSEVS_EMPLOYER_STATE	GOBSEVS_EMPLOYER_STATE	VARCHAR2(2)	Yes
GOBSEVS_EMPLOYER_ZIP	GOBSEVS_EMPLOYER_ZIP	VARCHAR2(9)	Yes
GOBSEVS_COURSE_RELEVANCE	GOBSEVS_COURSE_RELEVANCE	VARCHAR2(500)	Yes
GOBSEVS_EXTEND_END_DATE	GOBSEVS_EXTEND_END_DATE	DATE	Yes
GOBSEVS_SVTR_CODE	GOBSEVS_SVTR_CODE	VARCHAR2(6)	Yes		*
GOBSEVS_TERMINATE_DATE	GOBSEVS_TERMINATE_DATE	DATE	Yes
GOBSEVS_APPROVAL_FAIL_COMMENT	GOBSEVS_APPROVAL_FAIL_COMMENT	VARCHAR2(500)	Yes
GOBSEVS_OTHER_INFRACT_COMMENT	GOBSEVS_OTHER_INFRACT_COMMENT	VARCHAR2(500)	Yes
GOBSEVS_SVEP_CODE	GOBSEVS_SVEP_CODE	VARCHAR2(4)	Yes		*
GOBSEVS_END_PROGRAM_EFF_DATE	GOBSEVS_END_PROGRAM_EFF_DATE	DATE	Yes
GOBSEVS_EV_FORM_NUMBER	GOBSEVS_EV_FORM_NUMBER	VARCHAR2(40)	Yes
GOBSEVS_SVRP_CODE	GOBSEVS_SVRP_CODE	VARCHAR2(2)	Yes		*
GOBSEVS_REPRINT_REASON_COMMENT	GOBSEVS_REPRINT_REASON_COMMENT	VARCHAR2(500)	Yes
GOBSEVS_SVCR_COMMENT	GOBSEVS_SVCR_COMMENT	VARCHAR2(500)	Yes
GOBSEVS_PRINT_REQUEST_IND	GOBSEVS_PRINT_REQUEST_IND	VARCHAR2(1)	No
GOBSEVS_DEPENDENT_EXPENSES	GOBSEVS_DEPENDENT_EXPENSES	NUMBER(12,2)	Yes
GOBSEVS_OTHER_FUNDS	GOBSEVS_OTHER_FUNDS	NUMBER(12,2)	Yes
GOBSEVS_OTHER_FUNDS_COMMENT	GOBSEVS_OTHER_FUNDS_COMMENT	VARCHAR2(500)	Yes
GOBSEVS_OTHER_EXPENSES	GOBSEVS_OTHER_EXPENSES	NUMBER(12,2)	Yes
GOBSEVS_OTHER_EXP_COMMENT	GOBSEVS_OTHER_EXP_COMMENT	VARCHAR2(500)	Yes
GOBSEVS_AUTH_END_DATE	GOBSEVS_AUTH_END_DATE	DATE	Yes
GOBSEVS_NEW_PROGRAM_START_DATE	GOBSEVS_NEW_PROGRAM_START_DATE	DATE	Yes
GOBSEVS_SVPC_CODE	GOBSEVS_SVPC_CODE	VARCHAR2(3)	Yes		*
GOBSEVS_SVSC_CODE	GOBSEVS_SVSC_CODE	VARCHAR2(7)	Yes
GOBSEVS_SVSC_COMMENT	GOBSEVS_SVSC_COMMENT	VARCHAR2(500)	Yes
GOBSEVS_COMMUTER_IND	GOBSEVS_COMMUTER_IND	VARCHAR2(1)	No
GOBSEVS_ADMISSION_NUMBER	GOBSEVS_ADMISSION_NUMBER	VARCHAR2(11)	Yes
GOBSEVS_DRIVERS_LIC_NUMBER	GOBSEVS_DRIVERS_LIC_NUMBER	VARCHAR2(30)	Yes
GOBSEVS_STAT_CODE_DRIVERS_LIC	GOBSEVS_STAT_CODE_DRIVERS_LIC	VARCHAR2(2)	Yes		*
GOBSEVS_TIN	GOBSEVS_TIN	VARCHAR2(9)	Yes
GOBSEVS_MAJR_CODE_2	GOBSEVS_MAJR_CODE_2	VARCHAR2(4)	Yes		*
GOBSEVS_MAJR_CODE_MINR	GOBSEVS_MAJR_CODE_MINR	VARCHAR2(4)	Yes		*
GOBSEVS_SCHOOL_FUNDS	GOBSEVS_SCHOOL_FUNDS	NUMBER(12,2)	Yes
GOBSEVS_SCHOOL_FUNDS_COMMENT	GOBSEVS_SCHOOL_FUNDS_COMMENT	VARCHAR2(500)	Yes
GOBSEVS_EMPLOYMENT_FUNDS	GOBSEVS_EMPLOYMENT_FUNDS	NUMBER(12,2)	Yes
GOBSEVS_FUNDING_COMMENT	GOBSEVS_FUNDING_COMMENT	VARCHAR2(500)	Yes
GOBSEVS_SVFT_COMMENT	GOBSEVS_SVFT_COMMENT	VARCHAR2(500)	Yes
GOBSEVS_SVEP_COMMENT	GOBSEVS_SVEP_COMMENT	VARCHAR2(500)	Yes
GOBSEVS_DA_COMMENT	GOBSEVS_DA_COMMENT	VARCHAR2(500)	Yes
GOBSEVS_SVTR_COMMENT	GOBSEVS_SVTR_COMMENT	VARCHAR2(500)	Yes
GOBSEVS_PASSPORT_NUMBER	GOBSEVS_PASSPORT_NUMBER	VARCHAR2(25)	Yes
GOBSEVS_NATN_CODE_PASSPORT	GOBSEVS_NATN_CODE_PASSPORT	VARCHAR2(5)	Yes		*
GOBSEVS_PASSPORT_EXPIRE_DATE	GOBSEVS_PASSPORT_EXPIRE_DATE	DATE	Yes
GOBSEVS_VISA_NUMBER	GOBSEVS_VISA_NUMBER	VARCHAR2(25)	Yes
GOBSEVS_SVCP_CODE	GOBSEVS_SVCP_CODE	VARCHAR2(3)	Yes		*
GOBSEVS_VISA_EXPIRE_DATE	GOBSEVS_VISA_EXPIRE_DATE	DATE	Yes
GOBSEVS_PENT_CODE	GOBSEVS_PENT_CODE	VARCHAR2(3)	Yes		*
GOBSEVS_PENT_COMMENT	GOBSEVS_PENT_COMMENT	VARCHAR2(500)	Yes
GOBSEVS_ENTRY_DATE	GOBSEVS_ENTRY_DATE	DATE	Yes
GOBSEVS_EMPL_AUTH_IND	GOBSEVS_EMPL_AUTH_IND	VARCHAR2(1)	No
GOBSEVS_RFC_COMMENT	GOBSEVS_RFC_COMMENT	VARCHAR2(500)	Yes
GOBSEVS_EDIT_PROGRAM_COMMENT	GOBSEVS_EDIT_PROGRAM_COMMENT	VARCHAR2(500)	Yes
GOBSEVS_EMPLOYMENT_TIME_CDE	GOBSEVS_EMPLOYMENT_TIME_CDE	VARCHAR2(2)	Yes
GOBSEVS_PROGRAM_SPONSOR_FUNDS	GOBSEVS_PROGRAM_SPONSOR_FUNDS	NUMBER(12,2)	Yes
GOBSEVS_GOVT_ORG_FUNDS	GOBSEVS_GOVT_ORG_FUNDS	NUMBER(12,2)	Yes
GOBSEVS_SVGO_CODE	GOBSEVS_SVGO_CODE	VARCHAR2(6)	Yes		*
GOBSEVS_GOVT_ORG_FUNDS_2	GOBSEVS_GOVT_ORG_FUNDS_2	NUMBER(12,2)	Yes
GOBSEVS_SVGO_CODE_2	GOBSEVS_SVGO_CODE_2	VARCHAR2(6)	Yes		*
GOBSEVS_INTL_ORG_FUNDS	GOBSEVS_INTL_ORG_FUNDS	NUMBER(12,2)	Yes
GOBSEVS_SVIO_CODE	GOBSEVS_SVIO_CODE	VARCHAR2(6)	Yes		*
GOBSEVS_INTL_ORG_FUNDS_2	GOBSEVS_INTL_ORG_FUNDS_2	NUMBER(12,2)	Yes
GOBSEVS_SVIO_CODE_2	GOBSEVS_SVIO_CODE_2	VARCHAR2(6)	Yes		*
GOBSEVS_EV_GOVT_FUNDS	GOBSEVS_EV_GOVT_FUNDS	NUMBER(12,2)	Yes
GOBSEVS_BINATION_FUNDS	GOBSEVS_BINATION_FUNDS	NUMBER(12,2)	Yes
GOBSEVS_OTHER_ORG_FUNDS	GOBSEVS_OTHER_ORG_FUNDS	NUMBER(12,2)	Yes
GOBSEVS_PROGRAM_START_IND	GOBSEVS_PROGRAM_START_IND	VARCHAR2(1)	No
GOBSEVS_EXTEND_PROGRAM_COMMENT	GOBSEVS_EXTEND_PROGRAM_COMMENT	VARCHAR2(500)	Yes
GOBSEVS_AMEND_PROGRAM_COMMENT	GOBSEVS_AMEND_PROGRAM_COMMENT	VARCHAR2(500)	Yes
GOBSEVS_MATRICULATION_CDE	GOBSEVS_MATRICULATION_CDE	VARCHAR2(2)	Yes
GOBSEVS_EXTEND_FAILURE_COMMENT	GOBSEVS_EXTEND_FAILURE_COMMENT	VARCHAR2(500)	Yes
GOBSEVS_CONCLUDE_TRANS_COMMENT	GOBSEVS_CONCLUDE_TRANS_COMMENT	VARCHAR2(500)	Yes
GOBSEVS_BIRTH_CITY	GOBSEVS_BIRTH_CITY	VARCHAR2(200)	Yes
GOBSEVS_EDIT_BIO_COMMENT	GOBSEVS_EDIT_BIO_COMMENT	VARCHAR2(500)	Yes
GOBSEVS_ATYP_CODE_ACT_SITE	GOBSEVS_ATYP_CODE_ACT_SITE	VARCHAR2(2)	Yes		*
GOBSEVS_NATN_CODE_PERM_RES	GOBSEVS_NATN_CODE_PERM_RES	VARCHAR2(5)	Yes
GOBSEVS_FIN_SUPPORT_COMMENT	GOBSEVS_FIN_SUPPORT_COMMENT	VARCHAR2(500)	Yes
GOBSEVS_SVIT_CODE	GOBSEVS_SVIT_CODE	VARCHAR2(3)	Yes		*
GOBSEVS_ACT_SITE_NAME	GOBSEVS_ACT_SITE_NAME	VARCHAR2(60)	Yes
GOBSEVS_ACT_SITE_COMMENT	GOBSEVS_ACT_SITE_COMMENT	VARCHAR2(500)	Yes
GOBSEVS_SVCC_CODE	GOBSEVS_SVCC_CODE	VARCHAR2(3)	Yes		*
GOBSEVS_SCHOOL_CDE	GOBSEVS_SCHOOL_CDE	VARCHAR2(15)	Yes
GOBSEVS_PROGRAM_CDE	GOBSEVS_PROGRAM_CDE	VARCHAR2(9)	Yes
GOBSEVS_OFFICER_ID	GOBSEVS_OFFICER_ID	VARCHAR2(10)	Yes
GOBSEVS_SVEL_COMMENT	GOBSEVS_SVEL_COMMENT	VARCHAR2(500)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GOBSEVS_ATYP_CODE_ACT_SITE	STVATYP_CODE	STVATYP
GOBSEVS_MAJR_CODE	STVMAJR_CODE	STVMAJR
GOBSEVS_BIRTH_NATN_CODE	STVNATN_CODE	STVNATN
GOBSEVS_PENT_CODE	STVPENT_CODE	STVPENT
GOBSEVS_STAT_CODE_DRIVERS_LIC	STVSTAT_CODE	STVSTAT
GOBSEVS_VTYP_CODE	STVVTYP_CODE	STVVTYP
GOBSEVS_MAJR_CODE_2	STVMAJR_CODE	STVMAJR
GOBSEVS_LEGAL_NATN_CODE	STVNATN_CODE	STVNATN
GOBSEVS_MAJR_CODE_MINR	STVMAJR_CODE	STVMAJR
GOBSEVS_NATN_CODE_PASSPORT	STVNATN_CODE	STVNATN
GOBSEVS_SVCC_CODE	GTVSVCC_CODE	GTVSVCC
GOBSEVS_SVCP_CODE	GTVSVCP_CODE	GTVSVCP
GOBSEVS_SVCR_CODE	GTVSVCR_CODE	GTVSVCR
GOBSEVS_SVEL_CODE	GTVSVEL_CODE	GTVSVEL
GOBSEVS_SVEP_CODE	GTVSVEP_CODE	GTVSVEP
GOBSEVS_SVFT_CODE	GTVSVFT_CODE	GTVSVFT
GOBSEVS_SVGO_CODE	GTVSVGO_CODE	GTVSVGO
GOBSEVS_SVGO_CODE_2	GTVSVGO_CODE	GTVSVGO
GOBSEVS_SVIO_CODE	GTVSVIO_CODE	GTVSVIO
GOBSEVS_SVIO_CODE_2	GTVSVIO_CODE	GTVSVIO
GOBSEVS_SVIT_CODE	GTVSVIT_CODE	GTVSVIT
GOBSEVS_SVPC_CODE	GTVSVPC_CODE	GTVSVPC
GOBSEVS_SVRP_CODE	GTVSVRP_CODE	GTVSVRP
GOBSEVS_SVTR_CODE	GTVSVTR_CODE	GTVSVTR
GOBSEVS_PIDM	GORSEVS_PIDM	GORSEVS

Index

Index Name	Index Type	Column Name
PK_GOBSEVS	Unique	GOBSEVS_PIDM

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
gorseve.pc	C/C++ File	N/A	Use(select )
GOBSEVS	SYNONYM	S4B70.PUBLIC	Rely on ()
GORSVAS	TABLE	S4B70."GENERAL"	Join
GORSVEI	TABLE	S4B70."GENERAL"	Join
SPBPERS	TABLE	S4B70.SATURN	Join
SPRIDEN	TABLE	S4B70.SATURN	Join
GOVSVAS	VIEW	S4B70.BANINST1	Use(select )
GOVSVEI	VIEW	S4B70.BANINST1	Use(select )
GOVSVEV	VIEW	S4B70.BANINST1	Use(select )
GOVSVSD	VIEW	S4B70.BANINST1	Use(select )
GOVSVTS	VIEW	S4B70.BANINST1	Use(select )
P_CREATE_EV	Package procedure	S4B70.BANINST1.GOKSVSQ	Use(insert )
P_CREATE_STUDENT	Package procedure	S4B70.BANINST1.GOKSVSQ	Use(insert )
P_PROCESS_IMPORT_DATA	Package procedure	S4B70.BANINST1.GOKSVEX	Use(update )
P_PROCESS_SQL_RULES	Package procedure	S4B70.BANINST1.GOKSVSQ	Use(select )
GOBSEVS	Forms DataBlock	BANNER7_FORMS.GOASEVS	Rely on () Use(insert,update,delete,select )
GOBSEVS	Forms DataBlock	BANNER7_FORMS_10G.GOASEVS	Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GOBSEVS	INDEX	S4B70."GENERAL"	Rely on ()
GORSEVS	TABLE	S4B70."GENERAL"	Join
GTVSVCC	TABLE	S4B70."GENERAL"	Refer( No Action )
GTVSVCP	TABLE	S4B70."GENERAL"	Refer( No Action )
GTVSVCR	TABLE	S4B70."GENERAL"	Refer( No Action )
GTVSVEL	TABLE	S4B70."GENERAL"	Refer( No Action )
GTVSVEP	TABLE	S4B70."GENERAL"	Refer( No Action )
GTVSVFT	TABLE	S4B70."GENERAL"	Refer( No Action )
GTVSVGO	TABLE	S4B70."GENERAL"	Refer( No Action )
GTVSVIO	TABLE	S4B70."GENERAL"	Refer( No Action )
GTVSVIT	TABLE	S4B70."GENERAL"	Refer( No Action )
GTVSVPC	TABLE	S4B70."GENERAL"	Refer( No Action )
GTVSVRP	TABLE	S4B70."GENERAL"	Refer( No Action )
GTVSVTR	TABLE	S4B70."GENERAL"	Refer( No Action )
STVATYP	TABLE	S4B70.SATURN	Refer( No Action )
STVMAJR	TABLE	S4B70.SATURN	Refer( No Action )
STVNATN	TABLE	S4B70.SATURN	Refer( No Action )
STVPENT	TABLE	S4B70.SATURN	Refer( No Action )
STVSTAT	TABLE	S4B70.SATURN	Refer( No Action )
STVVTYP	TABLE	S4B70.SATURN	Refer( No Action )

Comments

Source Code Comments

SEVIS Reporting base table

Columns Comments for GOBSEVS_PIDM (1)

Source Code Comments

PERSONAL ID NUMBER: Internal identification number of the person

Columns Comments for GOBSEVS_ENG_PROF_REQ_IND (2)

Source Code Comments

ENGLISH PROFICIENCY REQUIRED INDICATOR: Is English required for the program

Columns Comments for GOBSEVS_ENG_PROF_MET_IND (3)

Source Code Comments

ENGLICH PROFICIENCY MET INDICATOR: Has the English requirement been met

Columns Comments for GOBSEVS_CRIMINAL_CONVICT_IND (4)

Source Code Comments

CRIMINAL CONVICTION INDICATOR: Indicator to show that the student has a criminal conviction

Columns Comments for GOBSEVS_TERMINATE_STUDENT_IND (5)

Source Code Comments

STUDENT TERMINATION INDICATOR: Indicator to show if the student was terminated

Columns Comments for GOBSEVS_EXTEND_FAILURE_IND (6)

Source Code Comments

EXTENSION FAILURE INDICATOR: Indicator to show if the exchange visitor failed to extend the program

Columns Comments for GOBSEVS_TRANSFER_FAIL_IND (7)

Source Code Comments

TRANSFER FAILURE INDICATOR: Indicator to show if a transfer of an exchange visitor has failed

Columns Comments for GOBSEVS_APPROVAL_FAIL_IND (8)

Source Code Comments

TRANSFER APPROVAL FILURE INDICATOR: Indicator to show if there was a failure to secure approval for a transfer

Columns Comments for GOBSEVS_OTHER_INFRACT_IND (9)

Source Code Comments

OTHER INFRACTIONS INDICATOR:Indicator to show that the exchange visitor has received other, minor disciplinary actions

Columns Comments for GOBSEVS_ACTIVITY_DATE (10)

Source Code Comments

ACTIVITY DATE: The most recent date a record was created or updated

Columns Comments for GOBSEVS_USER_ID (11)

Source Code Comments

USER ID: The most recent user to create or update a record.

Columns Comments for GOBSEVS_BIRTH_NATN_CODE (12)

Source Code Comments

BIRTH NATION CODE: Country of birth of the student/exchange visitor

Columns Comments for GOBSEVS_LEGAL_NATN_CODE (13)

Source Code Comments

LEGAL NATIN CODE: Country of citizenship of the student/exchange visitor

Columns Comments for GOBSEVS_PROGRAM_BEGIN_DATE (14)

Source Code Comments

PROGRAM BEGIN DATE: Date the program begins

Columns Comments for GOBSEVS_PROGRAM_END_DATE (15)

Source Code Comments

PROGRAM END DATE: Date the program ends

Columns Comments for GOBSEVS_PROGRAM_ENROLL_DATE (16)

Source Code Comments

ENROLLED DATE: Date on which the student/exchange visitor enrolled in the program

Columns Comments for GOBSEVS_ENG_PROF_REASON (17)

Source Code Comments

REASON ENGLISH PROFICIENCY IS NOT REQUIRED: Reason English is not required for the program

Columns Comments for GOBSEVS_ACADEMIC_TERM_MONTHS (18)

Source Code Comments

ACADEMIC TERM LENGTH: Length of academic term in months

Columns Comments for GOBSEVS_TUITION_EXPENSE (19)

Source Code Comments

TUITION EXPENSES: Tuition expenses for length of program

Columns Comments for GOBSEVS_PERSONAL_FUNDS (20)

Source Code Comments

PERSONAL FUNDS: Funds provided by the student/exchange visitor

Columns Comments for GOBSEVS_TRANS_CDE (21)

Source Code Comments

SEVIS TRANSACTION CODE: Transaction code for the record submitted

Columns Comments for GOBSEVS_SEVIS_ID (22)

Source Code Comments

SEVIS ID: ID for the person as assigned by SEVIS

Columns Comments for GOBSEVS_VTYP_CODE (23)

Source Code Comments

VISA TYPE: Code for the Visa type requested for the person

Columns Comments for GOBSEVS_SVCR_CODE (24)

Source Code Comments

CREATE REASON CODE: Code for the reason to create record

Columns Comments for GOBSEVS_SESSION_START_DATE (25)

Source Code Comments

SESSION START DATE: Date on which the session starts

Columns Comments for GOBSEVS_SESSION_END_DATE (26)

Source Code Comments

SESSION END DATE: Date on which the session ends

Columns Comments for GOBSEVS_TRANSFER_COMMENT (27)

Source Code Comments

TRANSFER COMMENTS: Comments from the school about a transfer student

Columns Comments for GOBSEVS_ISSUE_COMMENT (28)

Source Code Comments

ISSUE COMMENTS: Additional comments about the reason to issue the Visa to the person

Columns Comments for GOBSEVS_SVEL_CODE (29)

Source Code Comments

EDUCATIONAL LEVEL: Code for the educational level of the person

Columns Comments for GOBSEVS_MAJR_CODE (30)

Source Code Comments

PRIMARY MAJOR: Major code of the student

Columns Comments for GOBSEVS_STUDY_LENGTH (31)

Source Code Comments

PROGRAM OF STUDY LENGTH: Length of the program of student in months

Columns Comments for GOBSEVS_LIVING_EXPENSES (32)

Source Code Comments

LIVING EXPENSES: Dollar amount of the student's living expenses

Columns Comments for GOBSEVS_SVFT_CODE (33)

Source Code Comments

DROP BELOW FULL TIME CODE: Code to indicate the reason the student dropped below full time

Columns Comments for GOBSEVS_AUTH_START_DATE (34)

Source Code Comments

AUTHORIZATION START DATE: Date in which the student was authorized to drop below full time

Columns Comments for GOBSEVS_COMPLETION_REMARKS (35)

Source Code Comments

COMPLETION REMARKS: Comments regarding the students completion of the program

Columns Comments for GOBSEVS_NEW_PROGRAM_END_DATE (36)

Source Code Comments

PROGRAM CHANGED END DATE: New program end date as the result of a change

Columns Comments for GOBSEVS_DA_PROGRAM_START_DATE (37)

Source Code Comments

PROGRAM DEFERRED START DATE: New program start date as the result of deferred attendance

Columns Comments for GOBSEVS_DA_PROGRAM_END_DATE (38)

Source Code Comments

PROGRAM DEFERRED END DATE: New program end date as the result of deferred attendance

Columns Comments for GOBSEVS_DISC_ACTION_TEXT (39)

Source Code Comments

DISCIPLINARY ACTION COMENTS: Comments to explain the disciplinary action against the student

Columns Comments for GOBSEVS_EMPLOYMENT_CDE (40)

Source Code Comments

STUDENT EMPLOYMENT CODE: A code to show if the student is employed

Columns Comments for GOBSEVS_EMPLOYMENT_COMMENT (41)

Source Code Comments

STUDENT EMPLOYMENT COMMENTS: Comments to allow the school to explain the recommendation for the students employment

Columns Comments for GOBSEVS_EMPLOYMENT_START_DATE (42)

Source Code Comments

EMPLOYMENT START DATE: Start date of the student's employment

Columns Comments for GOBSEVS_EMPLOYMENT_END_DATE (43)

Source Code Comments

EMPLOYMENT END DATE: End date of the student's employment

Columns Comments for GOBSEVS_EMPLOYMENT_TYPE_CDE (44)

Source Code Comments

EMPLOYMENT TYPE CODE:Code to show the type of employment for the student

Columns Comments for GOBSEVS_EMPLOYER_LAST_NAME (45)

Source Code Comments

EMPLOYER LAST NAME: Last name of the student's employer

Columns Comments for GOBSEVS_EMPLOYER_FIRST_NAME (46)

Source Code Comments

EMPLOYER FIRST NAME: First name of the student's employer

Columns Comments for GOBSEVS_EMP_ADDRESS_LINE1 (47)

Source Code Comments

EMPLOYER ADDRESS LINE 1: First line of the student's employer address

Columns Comments for GOBSEVS_EMP_ADDRESS_LINE2 (48)

Source Code Comments

EMPLOYER ADDRESS LINE 2: Second line of the student's employer address

Columns Comments for GOBSEVS_EMPLOYER_CITY (49)

Source Code Comments

EMPLOYER CITY: City of the student's employer

Columns Comments for GOBSEVS_EMPLOYER_STATE (50)

Source Code Comments

EMPLOYER STATE: State of the student's employer

Columns Comments for GOBSEVS_EMPLOYER_ZIP (51)

Source Code Comments

EMPLOYER ZIP: Zip code of the student's employer

Columns Comments for GOBSEVS_COURSE_RELEVANCE (52)

Source Code Comments

COURSE RELEVANCE COMMENTS: Comments to explain the employ and its relevance to the student's course work

Columns Comments for GOBSEVS_EXTEND_END_DATE (53)

Source Code Comments

EXTENSION END DATE: The new program end date due to an extension

Columns Comments for GOBSEVS_SVTR_CODE (54)

Source Code Comments

TERMINATION REASON CODE: Code to show the reason why the student/exchange visitor was terminated

Columns Comments for GOBSEVS_TERMINATE_DATE (55)

Source Code Comments

TERMINATION DATE: Date on which the student/echange visitor was terminated

Columns Comments for GOBSEVS_APPROVAL_FAIL_COMMENT (56)

Source Code Comments

TRANSFER APPROVAL FAILURE COMMENTS: Comments about the failure to obtain approval for a transfer

Columns Comments for GOBSEVS_OTHER_INFRACT_COMMENT (57)

Source Code Comments

OTHER INFRACTIONS COMMENTS: Comments on the other, minor disciplinary actions that the exchange visitor has received

Columns Comments for GOBSEVS_SVEP_CODE (58)

Source Code Comments

EXCHANGE VISITOR PROGRAM END CODE: Code to show why the exchange visitor's program has ended

Columns Comments for GOBSEVS_END_PROGRAM_EFF_DATE (59)

Source Code Comments

EXCHANGE VISITOR PROGRAM END DATE: Date on which the exchange visitor's program ended

Columns Comments for GOBSEVS_EV_FORM_NUMBER (60)

Source Code Comments

EXCHANGE VISITOR FORM NUMBER: Exchange visitor's form number

Columns Comments for GOBSEVS_SVRP_CODE (61)

Source Code Comments

REASON FOR FORM REPRINT: Code to show a reason for the reprint of the exchange visitor's form

Columns Comments for GOBSEVS_REPRINT_REASON_COMMENT (62)

Source Code Comments

FORM REPRINT REASON COMMENTS: Comments to explain the need for a form reprint

Columns Comments for GOBSEVS_SVCR_COMMENT (63)

Source Code Comments

CREATE REASON COMMENT: Create reason comment

Columns Comments for GOBSEVS_PRINT_REQUEST_IND (64)

Source Code Comments

PRINT REQUEST INDICATOR: Print request indicator

Columns Comments for GOBSEVS_DEPENDENT_EXPENSES (65)

Source Code Comments

DEPENDENT EXPENSES: Student dependent expenses.

Columns Comments for GOBSEVS_OTHER_FUNDS (66)

Source Code Comments

OTHER FUNDS: Amount of funds from other sources.

Columns Comments for GOBSEVS_OTHER_FUNDS_COMMENT (67)

Source Code Comments

OTHER FUNDS DESCRIPTION: Description of the other sources of funding.

Columns Comments for GOBSEVS_OTHER_EXPENSES (68)

Source Code Comments

OTHER EXPENSES: Expenses from other sources.

Columns Comments for GOBSEVS_OTHER_EXP_COMMENT (69)

Source Code Comments

OTHER EXPENSES DESCRIPTION: Description of the other expenses.

Columns Comments for GOBSEVS_AUTH_END_DATE (70)

Source Code Comments

AUTHORIZATION END DATE: Date when the student ended less than full time study.

Columns Comments for GOBSEVS_NEW_PROGRAM_START_DATE (71)

Source Code Comments

NEW PROGRAM START DATE: Date when the new program will begin.

Columns Comments for GOBSEVS_SVPC_CODE (72)

Source Code Comments

POSITION CODE: Exchange visitor position code.

Columns Comments for GOBSEVS_SVSC_CODE (73)

Source Code Comments

SUBJECT CODE: Exchange visitior subject code.

Columns Comments for GOBSEVS_SVSC_COMMENT (74)

Source Code Comments

SUBJECT REMARKS: Remarks for the subject of field of study.

Columns Comments for GOBSEVS_COMMUTER_IND (75)

Source Code Comments

COMMUTER INDICATOR: Denotes whether or not a student commutes from a foreign country. If Y, then, no USA address is required.

Columns Comments for GOBSEVS_ADMISSION_NUMBER (76)

Source Code Comments

ADMISSION NUMBER: I-94 admission number.

Columns Comments for GOBSEVS_DRIVERS_LIC_NUMBER (77)

Source Code Comments

DRIVER'S LICENSE NUMBER: Student's driver's license number.

Columns Comments for GOBSEVS_STAT_CODE_DRIVERS_LIC (78)

Source Code Comments

DRIVER'S LICENSE STATE: State of the student's driver's license.

Columns Comments for GOBSEVS_TIN (79)

Source Code Comments

TIN: Student's tax ID number.

Columns Comments for GOBSEVS_MAJR_CODE_2 (80)

Source Code Comments

SECONDARY MAJOR: Banner code for secondary major from STVMAJR.

Columns Comments for GOBSEVS_MAJR_CODE_MINR (81)

Source Code Comments

MINOR: Banner code for minor from STVMAJR.

Columns Comments for GOBSEVS_SCHOOL_FUNDS (82)

Source Code Comments

SCHOOL FUNDS: Amount of funding provided by the school.

Columns Comments for GOBSEVS_SCHOOL_FUNDS_COMMENT (83)

Source Code Comments

SCHOOL FUNDING REMARKS: Explanation of school funding.

Columns Comments for GOBSEVS_EMPLOYMENT_FUNDS (84)

Source Code Comments

EMPLOYMENT FUNDING: Funds received from on-campus employment.

Columns Comments for GOBSEVS_FUNDING_COMMENT (85)

Source Code Comments

FUNDING COMMENT: General comment on funding.

Columns Comments for GOBSEVS_SVFT_COMMENT (86)

Source Code Comments

DROP BELOW FT REMARKS: Drop below full time remarks.

Columns Comments for GOBSEVS_SVEP_COMMENT (87)

Source Code Comments

EXTEND PROGRAM REMARKS: Program extention remarks.

Columns Comments for GOBSEVS_DA_COMMENT (88)

Source Code Comments

DEFER ATTENDENCE REMARKS: Comments about the deferred attendence.

Columns Comments for GOBSEVS_SVTR_COMMENT (89)

Source Code Comments

TERMINATION REMARKS: Comments about termination.

Columns Comments for GOBSEVS_PASSPORT_NUMBER (90)

Source Code Comments

PASSPORT NUMBER: Passport number.

Columns Comments for GOBSEVS_NATN_CODE_PASSPORT (91)

Source Code Comments

PASSPORT ISSUE NATION: The Banner code of the nation that issued the passport.

Columns Comments for GOBSEVS_PASSPORT_EXPIRE_DATE (92)

Source Code Comments

PASSPORT EXPIRATION DATE: Passport expiration date.

Columns Comments for GOBSEVS_VISA_NUMBER (93)

Source Code Comments

VISA NUMBER: Visa number.

Columns Comments for GOBSEVS_SVCP_CODE (94)

Source Code Comments

VISA CONSULAR POST: Code of the consular post that issued the visa.

Columns Comments for GOBSEVS_VISA_EXPIRE_DATE (95)

Source Code Comments

VISA EXPIRE DATE: Date when the visa expires.

Columns Comments for GOBSEVS_PENT_CODE (96)

Source Code Comments

PORT OF ENTRY: Banner code for port of entry.

Columns Comments for GOBSEVS_PENT_COMMENT (97)

Source Code Comments

PORT OF ENTRY COMMENTS: Port of entry comments.

Columns Comments for GOBSEVS_ENTRY_DATE (98)

Source Code Comments

DATE OF ENTRY: Date of entry.

Columns Comments for GOBSEVS_EMPL_AUTH_IND (99)

Source Code Comments

EMPLOYMENT AUTHORITY: Indicator to show that a recommendation for employment exists.

Columns Comments for GOBSEVS_RFC_COMMENT (100)

Source Code Comments

RESUME FULL COURSE REMARKS: Resume full course comments.

Columns Comments for GOBSEVS_EDIT_PROGRAM_COMMENT (101)

Source Code Comments

EDIT PROGRAM COMMENTS: Remarks about why program information was edited.

Columns Comments for GOBSEVS_EMPLOYMENT_TIME_CDE (102)

Source Code Comments

EMPLOYMENT TIME CODE: Employment time code indicates full or part-time status.

Columns Comments for GOBSEVS_PROGRAM_SPONSOR_FUNDS (103)

Source Code Comments

PROGRAM SPONSOR FUNDS: The amount of financial support from the program sponsor.

Columns Comments for GOBSEVS_GOVT_ORG_FUNDS (104)

Source Code Comments

GOVERNMENT ORG 1 FUNDS: Funds received from a government organization.

Columns Comments for GOBSEVS_SVGO_CODE (105)

Source Code Comments

GOVERNMENT ORG 1 CODE: Code to describe the government organization.

Columns Comments for GOBSEVS_GOVT_ORG_FUNDS_2 (106)

Source Code Comments

GOVERNMENT ORG 2 FUNDS: Funds received from a government organization.

Columns Comments for GOBSEVS_SVGO_CODE_2 (107)

Source Code Comments

GOVERNMENT ORG 2 CODE: Code to describe the government organization.

Columns Comments for GOBSEVS_INTL_ORG_FUNDS (108)

Source Code Comments

INTERNATIONAL ORG 1 FUNDS: Funds received from an international organization.

Columns Comments for GOBSEVS_SVIO_CODE (109)

Source Code Comments

INTERNATIONAL ORG 1 CODE: Code to describe the international organization.

Columns Comments for GOBSEVS_INTL_ORG_FUNDS_2 (110)

Source Code Comments

INTERNATIONAL ORG 2 FUNDS: Funds received from an international organization.

Columns Comments for GOBSEVS_SVIO_CODE_2 (111)

Source Code Comments

INTERNATIONAL ORG 2 CODE: Code to describe the international organization.

Columns Comments for GOBSEVS_EV_GOVT_FUNDS (112)

Source Code Comments

EV GOVERNMENT FUNDS: Funds provided by the exchange visitor's government.

Columns Comments for GOBSEVS_BINATION_FUNDS (113)

Source Code Comments

BI-NATIONAL COMMISSION FUNDS: Funds provided by a bi-national commission.

Columns Comments for GOBSEVS_OTHER_ORG_FUNDS (114)

Source Code Comments

OTHER ORGANIZATION FUNDS: Funds provided by another type of organization.

Columns Comments for GOBSEVS_PROGRAM_START_IND (115)

Source Code Comments

PROGRAM START INDICATOR: Indicator to show if the exchange visitor started the program.

Columns Comments for GOBSEVS_EXTEND_PROGRAM_COMMENT (116)

Source Code Comments

EXTEND PROGRAM REMARKS: Comments to explain why a program was extended.

Columns Comments for GOBSEVS_AMEND_PROGRAM_COMMENT (117)

Source Code Comments

AMEND PROGRAM REMARKS: Comments to explain how a program was amended.

Columns Comments for GOBSEVS_MATRICULATION_CDE (118)

Source Code Comments

MATRICULATION CODE: Matriculation code.

Columns Comments for GOBSEVS_EXTEND_FAILURE_COMMENT (119)

Source Code Comments

EXTEND FAUILURE END REMARKS: Comments to explain an extension failure.

Columns Comments for GOBSEVS_CONCLUDE_TRANS_COMMENT (120)

Source Code Comments

CONCLUDE FAILURE REMARKS: Comments to explain why a transfer was not concluded.

Columns Comments for GOBSEVS_BIRTH_CITY (121)

Source Code Comments

EV BIRTH CITY: Exchange visitor birth city.

Columns Comments for GOBSEVS_EDIT_BIO_COMMENT (122)

Source Code Comments

EDIT EV BIO COMMENT: Comments to explain why EV biographical data was edited.

Columns Comments for GOBSEVS_ATYP_CODE_ACT_SITE (123)

Source Code Comments

ACTIVITY SITE ADDRESS TYPE: Banner address code for the activity site address.

Columns Comments for GOBSEVS_NATN_CODE_PERM_RES (124)

Source Code Comments

PERMANENT RESIDENCY COUNTRY CODE: Banner code for nation of permanent residency.