GOBSEVS GORSEVD GORSEVH GORSEVS GORSVAH GORSVEH GTVSVCC GTVSVCR GTVSVDT GTVSVEL GTVSVEP GTVSVFT GTVSVPC GTVSVRP GTVSVTR GTVSVTS SPBPERS SPRIDEN STVRELT STVVTYP SPBPERS reference SPRIDEN reference

Model Sevis


Model Label : Banner General SEVIS
Path : BANNER DEV/General/ERD/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
GTVSVCR TABLE Default
GTVSVDT TABLE Default
GTVSVEL TABLE Non-General
GTVSVEP TABLE Default
GTVSVFT TABLE Default
GTVSVPC TABLE Default
GTVSVRP TABLE Default
GTVSVTR TABLE Default
GTVSVTS TABLE Default
SPBPERS TABLE Non-General
SPBPERS reference User Object Default
SPRIDEN TABLE Non-General
SPRIDEN reference User Object Default
STVRELT TABLE Non-General
STVVTYP TABLE Non-General

Comments

Model View

''

Table GOBSEVS

Schema Name GENERAL
Label GOBSEVS
Server name MALDEV8_B60
Creation Date 05/23/2003 13:35:50: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_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_SVIT_CODE GTVSVIT_CODE GTVSVIT
GOBSEVS_SVPC_CODE GTVSVPC_CODE GTVSVPC
GOBSEVS_SVRP_CODE GTVSVRP_CODE GTVSVRP
GOBSEVS_SVTR_CODE GTVSVTR_CODE GTVSVTR
GOBSEVS_PENT_CODE STVPENT_CODE STVPENT
GOBSEVS_STAT_CODE_DRIVERS_LIC STVSTAT_CODE STVSTAT
GOBSEVS_ATYP_CODE_ACT_SITE STVATYP_CODE STVATYP
GOBSEVS_VTYP_CODE STVVTYP_CODE STVVTYP
GOBSEVS_PIDM GORSEVS_PIDM GORSEVS

Index

Index Name Index Type Column Name
PK_GOBSEVS Unique GOBSEVS_PIDM

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.

Columns Comments for GOBSEVS_FIN_SUPPORT_COMMENT (125)

Source Code Comments

FINANCIAL SUPPORT COMMENT: Financial support remarks.

Columns Comments for GOBSEVS_SVIT_CODE (126)

Source Code Comments

INFRACTION CODE: SEVIS infraction code.

Columns Comments for GOBSEVS_ACT_SITE_NAME (127)

Source Code Comments

ACTIVITY SITE NAME: Name to identify the site of activity.

Columns Comments for GOBSEVS_ACT_SITE_COMMENT (128)

Source Code Comments

ACTIVITY SITE COMMENT: Remarks used when adding or deleting the site of activity.

Columns Comments for GOBSEVS_SVCC_CODE (129)

Source Code Comments

CATEGORY CODE: SEVIS category code used in EV reporting.

Columns Comments for GOBSEVS_SCHOOL_CDE (130)

Source Code Comments

SEVIS-assigned school ID number.

Columns Comments for GOBSEVS_PROGRAM_CDE (131)

Source Code Comments

SEVIS-assigned EV program ID number.

Columns Comments for GOBSEVS_OFFICER_ID (132)

Source Code Comments

SEVIS-assigned ID number for data approver.

Columns Comments for GOBSEVS_SVEL_COMMENT (133)

Source Code Comments

EDUCATION LEVEL COMMENT: Comment on education level.

Table GORSEVD

Schema Name GENERAL
Label GORSEVD
Server name MALDEV8_B60
Creation Date 02/27/2003 18:59:32:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GORSEVD_PIDM GORSEVD_PIDM NUMBER(8,0) No *
GORSEVD_SEQ_NO GORSEVD_SEQ_NO NUMBER(2,0) No *
GORSEVD_RELT_CODE GORSEVD_RELT_CODE VARCHAR2(3) No *
GORSEVD_ACTIVITY_DATE GORSEVD_ACTIVITY_DATE DATE No
GORSEVD_USER_ID GORSEVD_USER_ID VARCHAR2(30) No
GORSEVD_DEP_PIDM GORSEVD_DEP_PIDM NUMBER(8,0) Yes
GORSEVD_DEP_LAST_NAME GORSEVD_DEP_LAST_NAME VARCHAR2(40) Yes
GORSEVD_DEP_FIRST_NAME GORSEVD_DEP_FIRST_NAME VARCHAR2(25) Yes
GORSEVD_DEP_MIDDLE_NAME GORSEVD_DEP_MIDDLE_NAME VARCHAR2(25) Yes
GORSEVD_DEP_BIRTH_NATN_CODE GORSEVD_DEP_BIRTH_NATN_CODE VARCHAR2(5) Yes *
GORSEVD_DEP_LEGAL_NATN_CODE GORSEVD_DEP_LEGAL_NATN_CODE VARCHAR2(5) Yes *
GORSEVD_DEP_BIRTH_DATE GORSEVD_DEP_BIRTH_DATE DATE Yes
GORSEVD_DEP_SEVIS_ID GORSEVD_DEP_SEVIS_ID VARCHAR2(11) Yes
GORSEVD_SVDT_CODE GORSEVD_SVDT_CODE VARCHAR2(2) Yes *
GORSEVD_GENDER GORSEVD_GENDER VARCHAR2(1) Yes
GORSEVD_VTYP_CODE GORSEVD_VTYP_CODE VARCHAR2(2) Yes *
GORSEVD_DEP_BIRTH_CITY GORSEVD_DEP_BIRTH_CITY VARCHAR2(200) Yes
GORSEVD_NATN_CODE_PERM_RES GORSEVD_NATN_CODE_PERM_RES VARCHAR2(5) Yes *
GORSEVD_TERMINATE_EFF_DATE GORSEVD_TERMINATE_EFF_DATE DATE Yes
GORSEVD_DEP_COMMENT GORSEVD_DEP_COMMENT VARCHAR2(500) Yes
GORSEVD_SVDT_COMMENT GORSEVD_SVDT_COMMENT VARCHAR2(500) Yes
GORSEVD_DEP_NAME_SUFFIX GORSEVD_DEP_NAME_SUFFIX VARCHAR2(3) Yes

Foreign Key information

Column name is Foreign Key For Column on Table
GORSEVD_SVDT_CODE GTVSVDT_CODE GTVSVDT
GORSEVD_RELT_CODE STVRELT_CODE STVRELT
GORSEVD_VTYP_CODE STVVTYP_CODE STVVTYP

Index

Index Name Index Type Column Name
PK_GORSEVD Unique GORSEVD_PIDM
PK_GORSEVD Unique GORSEVD_SEQ_NO

Comments

Source Code Comments

SEVIS Reporting Dependent Table

Columns Comments for GORSEVD_PIDM (1)

Source Code Comments

PERSONAL ID NUMBER: PIDM of person for whom the dependent is being estasblished.

Columns Comments for GORSEVD_SEQ_NO (2)

Source Code Comments

SEQUENCE NUMBER: Sequence number for GORSEVD key uniqueness.

Columns Comments for GORSEVD_RELT_CODE (3)

Source Code Comments

RELATIONSHIP CODE: Dependent relationship code