APRADEG APRAMAJ GOBSEVS PARPMAJ SARADAP SARCHKB SARDCSN SARQKER SARRRFT SARWADF SCRRMAJ SDRPCNC SDRPMJR SDRPMNR SFRRGFE SFRTMSL SFRTMST SGBSTDN SGRASSI SGRCOLR SHRDGMR SHRPREV SMRAQUA SMRIECC SMRIEMJ SMRIEMN SMRRQCM SORCCON SORCMJR SORCMNR SORCOMM SORCONC SOREQUI SORLFOS SORMAJR SORMINR SORMMJR SRBPRED SRBRECR SRTPREL SSRRESV SSRRMAJ STVCIPC STVMAJR TBRIAMJ

Model STVMAJR


Model Label : Banner STVMAJR ERD
Path : Default Folder/B70/Common/STVMAJR

List of Objects

Object Name Object Type Layer Name
APRADEG TABLE ERD
APRAMAJ TABLE ERD
GOBSEVS TABLE ERD
PARPMAJ TABLE ERD
SARADAP TABLE ERD
SARCHKB TABLE ERD
SARDCSN TABLE ERD
SARQKER TABLE ERD
SARRRFT TABLE ERD
SARWADF TABLE ERD
SCRRMAJ TABLE ERD
SDRPCNC TABLE ERD
SDRPMJR TABLE ERD
SDRPMNR TABLE ERD
SFRRGFE TABLE ERD
SFRTMSL TABLE ERD
SFRTMST TABLE ERD
SGBSTDN TABLE ERD
SGRASSI TABLE ERD
SGRCOLR TABLE ERD
SHRDGMR TABLE ERD
SHRPREV TABLE ERD
SMRAQUA TABLE ERD
SMRIECC TABLE ERD
SMRIEMJ TABLE ERD
SMRIEMN TABLE ERD
SMRRQCM TABLE ERD
SORCCON TABLE ERD
SORCMJR TABLE ERD
SORCMNR TABLE ERD
SORCOMM TABLE ERD
SORCONC TABLE ERD
SOREQUI TABLE ERD
SORLFOS TABLE ERD
SORMAJR TABLE ERD
SORMINR TABLE ERD
SORMMJR TABLE ERD
SRBPRED TABLE ERD
SRBRECR TABLE ERD
SRTPREL TABLE ERD
SSRRESV TABLE ERD
SSRRMAJ TABLE ERD
STVCIPC TABLE ERD
STVMAJR TABLE Tables
TBRIAMJ TABLE ERD

Comments

Model View

''

Table APRADEG

Schema Name ALUMNI
Label APRADEG
Server name S4B70
Creation Date 09/29/2003 12:12:53:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
APRADEG_PIDM APRADEG_PIDM NUMBER(8,0) No * *
APRADEG_SEQ_NO APRADEG_SEQ_NO NUMBER(5,0) No *
APRADEG_SBGI_CODE APRADEG_SBGI_CODE VARCHAR2(6) Yes *
APRADEG_DEGC_CODE APRADEG_DEGC_CODE VARCHAR2(6) Yes *
APRADEG_DATE APRADEG_DATE DATE Yes
APRADEG_HONR_CODE APRADEG_HONR_CODE VARCHAR2(6) Yes *
APRADEG_COLL_CODE APRADEG_COLL_CODE VARCHAR2(2) Yes *
APRADEG_ACTIVITY_DATE APRADEG_ACTIVITY_DATE DATE No
APRADEG_ACYR_CODE APRADEG_ACYR_CODE VARCHAR2(4) Yes *
APRADEG_ACYR_CODE_BULLETIN APRADEG_ACYR_CODE_BULLETIN VARCHAR2(4) Yes *
APRADEG_CAMP_CODE APRADEG_CAMP_CODE VARCHAR2(3) Yes *
APRADEG_DEPT_CODE APRADEG_DEPT_CODE VARCHAR2(4) Yes *
APRADEG_COMMENTS APRADEG_COMMENTS VARCHAR2(2000) Yes
APRADEG_MAJR_CODE_MINR_1 APRADEG_MAJR_CODE_MINR_1 VARCHAR2(4) Yes *
APRADEG_MAJR_CODE_MINR_2 APRADEG_MAJR_CODE_MINR_2 VARCHAR2(4) Yes *
APRADEG_MAJR_CODE_CONC_1 APRADEG_MAJR_CODE_CONC_1 VARCHAR2(4) Yes *
APRADEG_MAJR_CODE_CONC_2 APRADEG_MAJR_CODE_CONC_2 VARCHAR2(4) Yes *
APRADEG_MAJR_CODE_CONC_3 APRADEG_MAJR_CODE_CONC_3 VARCHAR2(4) Yes *
APRADEG_MAJR_CODE_CONC_4 APRADEG_MAJR_CODE_CONC_4 VARCHAR2(4) Yes *
APRADEG_MAJR_CODE_CONC_5 APRADEG_MAJR_CODE_CONC_5 VARCHAR2(4) Yes *
APRADEG_MAJR_CODE_CONC_6 APRADEG_MAJR_CODE_CONC_6 VARCHAR2(4) Yes *
APRADEG_DEPT_CODE_2 APRADEG_DEPT_CODE_2 VARCHAR2(4) Yes *
APRADEG_HONR_CODE_2 APRADEG_HONR_CODE_2 VARCHAR2(6) Yes *
APRADEG_HONR_CODE_3 APRADEG_HONR_CODE_3 VARCHAR2(6) Yes *
APRADEG_HONR_CODE_4 APRADEG_HONR_CODE_4 VARCHAR2(6) Yes *
APRADEG_HONR_CODE_5 APRADEG_HONR_CODE_5 VARCHAR2(6) Yes *
APRADEG_HOND_CODE_1 APRADEG_HOND_CODE_1 VARCHAR2(6) Yes *
APRADEG_HOND_CODE_2 APRADEG_HOND_CODE_2 VARCHAR2(6) Yes *
APRADEG_HOND_CODE_3 APRADEG_HOND_CODE_3 VARCHAR2(6) Yes *
APRADEG_HOND_CODE_4 APRADEG_HOND_CODE_4 VARCHAR2(6) Yes *
APRADEG_HOND_CODE_5 APRADEG_HOND_CODE_5 VARCHAR2(6) Yes *
APRADEG_OK_FOR_NOTES_IND APRADEG_OK_FOR_NOTES_IND VARCHAR2(1) Yes
APRADEG_DISP_NOTES_IND APRADEG_DISP_NOTES_IND VARCHAR2(1) Yes
APRADEG_DISP_NOTES_DATE APRADEG_DISP_NOTES_DATE DATE Yes
APRADEG_USER APRADEG_USER VARCHAR2(30) No
APRADEG_REVIEWED_IND APRADEG_REVIEWED_IND VARCHAR2(1) Yes
APRADEG_REVIEWED_USER APRADEG_REVIEWED_USER VARCHAR2(30) Yes
APRADEG_MAJOR_COMMENT APRADEG_MAJOR_COMMENT VARCHAR2(60) Yes

Foreign Key information

Column name is Foreign Key For Column on Table
APRADEG_PIDM APBCONS_PIDM APBCONS
APRADEG_ACYR_CODE STVACYR_CODE STVACYR
APRADEG_CAMP_CODE STVCAMP_CODE STVCAMP
APRADEG_COLL_CODE STVCOLL_CODE STVCOLL
APRADEG_DEGC_CODE STVDEGC_CODE STVDEGC
APRADEG_DEPT_CODE STVDEPT_CODE STVDEPT
APRADEG_HOND_CODE_1 STVHOND_CODE STVHOND
APRADEG_HONR_CODE STVHONR_CODE STVHONR
APRADEG_MAJR_CODE_MINR_1 STVMAJR_CODE STVMAJR
APRADEG_SBGI_CODE STVSBGI_CODE STVSBGI
APRADEG_ACYR_CODE_BULLETIN STVACYR_CODE STVACYR
APRADEG_DEPT_CODE_2 STVDEPT_CODE STVDEPT
APRADEG_HOND_CODE_2 STVHOND_CODE STVHOND
APRADEG_HONR_CODE_2 STVHONR_CODE STVHONR
APRADEG_MAJR_CODE_MINR_2 STVMAJR_CODE STVMAJR
APRADEG_HOND_CODE_3 STVHOND_CODE STVHOND
APRADEG_HONR_CODE_3 STVHONR_CODE STVHONR
APRADEG_MAJR_CODE_CONC_1 STVMAJR_CODE STVMAJR
APRADEG_HOND_CODE_4 STVHOND_CODE STVHOND
APRADEG_HONR_CODE_4 STVHONR_CODE STVHONR
APRADEG_MAJR_CODE_CONC_2 STVMAJR_CODE STVMAJR
APRADEG_HOND_CODE_5 STVHOND_CODE STVHOND
APRADEG_HONR_CODE_5 STVHONR_CODE STVHONR
APRADEG_MAJR_CODE_CONC_3 STVMAJR_CODE STVMAJR
APRADEG_MAJR_CODE_CONC_4 STVMAJR_CODE STVMAJR
APRADEG_MAJR_CODE_CONC_5 STVMAJR_CODE STVMAJR
APRADEG_MAJR_CODE_CONC_6 STVMAJR_CODE STVMAJR

Index

Index Name Index Type Column Name
PK_APRADEG Unique APRADEG_PIDM
PK_APRADEG Unique APRADEG_SEQ_NO

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
get_academic C/C++ Function [F:\BANNER\C\APPDEXT.PC] Use(select )
get_degr_status C/C++ Function [F:\BANNER\C\ADPVSER.PC] Use(select )
getdegc C/C++ Function [F:\BANNER\C\AFPTELF.PC] Use(select )
insadeg C/C++ Function [F:\BANNER\C\APPSTDI.PC] Use(insert,select )
insamaj C/C++ Function [F:\BANNER\C\APPSTDI.PC] Use(select )
pcolmaj C/C++ Function [F:\BANNER\C\APPSTDI.PC] Use(select )
sel_alum_grad C/C++ Function [F:\BANNER\C\ADPVSER.PC] Use(select )
sel_alum_nodegr C/C++ Function [F:\BANNER\C\ADPVSER.PC] Use(select )
sel_alum_under C/C++ Function [F:\BANNER\C\ADPVSER.PC] Use(select )
selacaddegr C/C++ Function [F:\BANNER\C\APPDPRC.PC] Use(select )
seladeg C/C++ Function [F:\BANNER\C\APPSTDI.PC] Use(select )
selgrad C/C++ Function [F:\BANNER\C\AGPMATG.PC] Use(select )
selmajors C/C++ Function [F:\BANNER\C\APPCLST.PC] Use(select )
APRADEG SYNONYM S4B70.PUBLIC Rely on ()
APRACYR TABLE S4B70.ALUMNI Join
APRAMAJ TABLE S4B70.ALUMNI Refer( No Action )
AA_DEGREE VIEW S4B70.BANINST1 Use(select )
PRE-DELETE Forms Trigger BANNER7_FORMS.APACONS.APBCONS Use(select )
PRE-DELETE Forms Trigger BANNER7_FORMS_10G.APACONS.APBCONS Use(select )
PRE-INSERT Forms Trigger BANNER7_FORMS_10G.APAADEG.APRADEG Use(select )
PRE-INSERT Forms Trigger BANNER7_FORMS.APAADEG.APRADEG Use(select )
F_CHECK_FOR_MORE FUNCTION S4B70.BANINST1 Use(select )
F_INST_DEGR FUNCTION S4B70.BANINST1 Use(select )
F_OTHER_INST_DEGR FUNCTION S4B70.BANINST1 Use(select )
DEGC_TYPE Package Type S4B70.BANINST1.BWAKADVS Rely on ()
APRADEG_REC Package variable S4B70.BANINST1.BWDKCPRF Rely on ()
APRADEG_REC Package variable S4B70.BANINST1.BWDKCPRF Rely on ()
APRADEGVIEWC Package cursor S4B70.BANINST1.BWDKCPRF Rely on () Use(select )
SEARCHVIEWC Package cursor S4B70.BANINST1.BWAKADVS Use(select )
P_EVALUATE_MG_ELIGIBILITY Package procedure S4B70.BANINST1.AXKEXMG Use(select )
P_LOAD_DEGREE Package procedure S4B70.BANINST1.APKLDRD Rely on ()
P_LOAD_DEGREE Package procedure S4B70.BANINST1.APKLDRD Rely on () Use(insert,update,select )
OK_LOAD Forms Sub Procedure BANNER7_FORMS_10G.APADRVW.UPLOAD_DEGREE Use(insert,update,select )
OK_LOAD Forms Sub Procedure BANNER7_FORMS.APADRVW.UPLOAD_DEGREE Use(insert,update,select )
F_GET_DEGREE_CHANGES_IND Package function S4B70.BANINST1.APKWIND Use(select )
APRADEG Forms DataBlock BANNER7_FORMS_10G.APAADEG Rely on () Use(insert,update,delete,select )
APRADEG Forms DataBlock BANNER7_FORMS_10G.APASBIO Rely on () Use(select )
APRADEG Forms DataBlock BANNER7_FORMS.APASBIO Rely on () Use(select )
APRADEG Forms DataBlock BANNER7_FORMS.APAADEG Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_APRADEG INDEX S4B70.ALUMNI Rely on ()
APBCONS TABLE S4B70.ALUMNI Refer( No Action )
STVACYR TABLE S4B70.SATURN Refer( No Action )
STVCAMP TABLE S4B70.SATURN Refer( No Action )
STVCOLL TABLE S4B70.SATURN Refer( No Action )
STVDEGC TABLE S4B70.SATURN Refer( No Action )
STVDEPT TABLE S4B70.SATURN Refer( No Action )
STVHOND TABLE S4B70.SATURN Refer( No Action )
STVHONR TABLE S4B70.SATURN Refer( No Action )
STVMAJR TABLE S4B70.SATURN Refer( No Action )
STVSBGI TABLE S4B70.SATURN Refer( No Action )

Comments

Source Code Comments

Academic Degree Repeating Table

Columns Comments for APRADEG_PIDM (1)

Source Code Comments

This field specifies the internal system generated identification number.

Columns Comments for APRADEG_SEQ_NO (2)

Source Code Comments

This field specifies the internal sequence number.

Columns Comments for APRADEG_SBGI_CODE (3)

Source Code Comments

This field specifies the institution at which the constituent earned the degree.

Columns Comments for APRADEG_DEGC_CODE (4)

Source Code Comments

This field spsecifies the type of degree earned by the constituent.

Columns Comments for APRADEG_DATE (5)

Source Code Comments

This field specifies the date the degree was awarded to the constituent.

Columns Comments for APRADEG_HONR_CODE (6)

Source Code Comments

This field specifies the honors the constituent received with the associated degree.

Columns Comments for APRADEG_COLL_CODE (7)

Source Code Comments

This field specifies the college that awarded the associated degree to the constituent.

Columns Comments for APRADEG_ACTIVITY_DATE (8)

Source Code Comments

This system maintained field specifies the date this file was created or updated.

Columns Comments for APRADEG_ACYR_CODE (9)

Source Code Comments

The Academic Year Code associated with this degree.

Columns Comments for APRADEG_ACYR_CODE_BULLETIN (10)

Source Code Comments

The Academic Year Bulletin Code associated with this degree.

Columns Comments for APRADEG_CAMP_CODE (11)

Source Code Comments

The campus associated with this degree.

Columns Comments for APRADEG_DEPT_CODE (12)

Source Code Comments

The first department associated with this degree.

Columns Comments for APRADEG_COMMENTS (13)

Source Code Comments

Free form text comments about this degree.

Columns Comments for APRADEG_MAJR_CODE_MINR_1 (14)

Source Code Comments

The first Minor code associated with this degree.

Columns Comments for APRADEG_MAJR_CODE_MINR_2 (15)

Source Code Comments

The second Minor code associated with this degree.

Columns Comments for APRADEG_MAJR_CODE_CONC_1 (16)

Source Code Comments

The first Concentration Code assosiated with this degree.

Columns Comments for APRADEG_MAJR_CODE_CONC_2 (17)

Source Code Comments

The second Concentration Code assosiated with this degree.

Columns Comments for APRADEG_MAJR_CODE_CONC_3 (18)

Source Code Comments

The third Concentration Code assosiated with this degree.

Columns Comments for APRADEG_MAJR_CODE_CONC_4 (19)

Source Code Comments

The fourth Concentration Code assosiated with this degree.

Columns Comments for APRADEG_MAJR_CODE_CONC_5 (20)

Source Code Comments

The fifth Concentration Code assosiated with this degree.

Columns Comments for APRADEG_MAJR_CODE_CONC_6 (21)

Source Code Comments

The sixth Concentration Code assosiated with this degree.

Columns Comments for APRADEG_DEPT_CODE_2 (22)

Source Code Comments

The second department associated with this degree.

Columns Comments for APRADEG_HONR_CODE_2 (23)

Source Code Comments

This field specifies the honors the constituent received with the associated degree.

Columns Comments for APRADEG_HONR_CODE_3 (24)

Source Code Comments

This field specifies the honors the constituent received with the associated degree.

Columns Comments for APRADEG_HONR_CODE_4 (25)

Source Code Comments

This field specifies the honors the constituent received with the associated degree.

Columns Comments for APRADEG_HONR_CODE_5 (26)

Source Code Comments

This field specifies the honors the constituent received with the associated degree.

Columns Comments for APRADEG_HOND_CODE_1 (27)

Source Code Comments

This field specifies the departmental honors the constituent received with the associated degree.

Columns Comments for APRADEG_HOND_CODE_2 (28)

Source Code Comments

This field specifies the departmental honors the constituent received with the associated degree.

Columns Comments for APRADEG_HOND_CODE_3 (29)

Source Code Comments

This field specifies the departmental honors the constituent received with the associated degree.

Columns Comments for APRADEG_HOND_CODE_4 (30)

Source Code Comments

This field specifies the departmental honors the constituent received with the associated degree.

Columns Comments for APRADEG_HOND_CODE_5 (31)

Source Code Comments

This field specifies the departmental honors the constituent received with the associated degree.

Columns Comments for APRADEG_OK_FOR_NOTES_IND (32)

Source Code Comments

OK for Notes Indicator, Y indicates that this degree can be used in Class Notes.

Columns Comments for APRADEG_DISP_NOTES_IND (33)

Source Code Comments

Displayed in Notes Indicator, Y indicates that this degree was displaeyd in Class Notes.

Columns Comments for APRADEG_DISP_NOTES_DATE (34)

Source Code Comments

The date that this degree was displayed in Class Notes.

Columns Comments for APRADEG_USER (35)

Source Code Comments

The User ID of the person who created or last modified this degree record.

Columns Comments for APRADEG_REVIEWED_IND (36)

Source Code Comments

Reviewed Indicator, Y indicates that this degree has been reviewed and accepted.

Columns Comments for APRADEG_REVIEWED_USER (37)

Source Code Comments

The User ID of the person who reviewed and accepted this degree.

Columns Comments for APRADEG_MAJOR_COMMENT (38)

Source Code Comments

Free form text comments about this degree.

Table APRAMAJ

Schema Name ALUMNI
Label APRAMAJ
Server name S4B70
Creation Date 09/29/2003 12:12:53:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
APRAMAJ_PIDM APRAMAJ_PIDM NUMBER(8,0) No * *
APRAMAJ_ADEG_SEQ_NO APRAMAJ_ADEG_SEQ_NO NUMBER(5,0) No * *
APRAMAJ_MAJR_CODE APRAMAJ_MAJR_CODE VARCHAR2(4) No * *
APRAMAJ_ACTIVITY_DATE APRAMAJ_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
APRAMAJ_PIDM APRADEG_PIDM APRADEG
APRAMAJ_ADEG_SEQ_NO APRADEG_SEQ_NO APRADEG
APRAMAJ_MAJR_CODE STVMAJR_CODE STVMAJR

Index

Index Name Index Type Column Name
PK_APRAMAJ Unique APRAMAJ_PIDM
PK_APRAMAJ Unique APRAMAJ_ADEG_SEQ_NO
PK_APRAMAJ Unique APRAMAJ_MAJR_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
get_academic C/C++ Function [F:\BANNER\C\APPDEXT.PC] Use(select )
insamaj C/C++ Function [F:\BANNER\C\APPSTDI.PC] Use(insert,select )
pcolmaj C/C++ Function [F:\BANNER\C\APPSTDI.PC] Use(insert,select )
selcomb_cons C/C++ Function [F:\BANNER\C\ALPMSEL.PC] Use(select )
seldegrmajr C/C++ Function [F:\BANNER\C\APPDPRC.PC] Use(select )
selmajors C/C++ Function [F:\BANNER\C\APPCLST.PC] Use(select )
APRAMAJ SYNONYM S4B70.PUBLIC Rely on ()
AA_DEGREE VIEW S4B70.BANINST1 Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS_10G.APAADEG.APRADEG Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS.APAADEG.APRADEG Use(select )
ON-CHECK-DELETE-MASTER Forms Trigger BANNER7_FORMS_10G.APAADEG.APRADEG Use(select )
ON-CHECK-DELETE-MASTER Forms Trigger BANNER7_FORMS.APAADEG.APRADEG Use(select )
ON-CHECK-DELETE-MASTER Forms Trigger BANNER7_FORMS_10G.APASBIO.APRADEG Use(select )
ON-CHECK-DELETE-MASTER Forms Trigger BANNER7_FORMS.APASBIO.APRADEG Use(select )
F_INST_DEGR FUNCTION S4B70.BANINST1 Use(select )
F_OTHER_INST_DEGR FUNCTION S4B70.BANINST1 Use(select )
MAJR_TYPE Package Type S4B70.BANINST1.BWAKADVS Rely on ()
APRAMAJ_REC Package variable S4B70.BANINST1.BWDKCPRF Rely on ()
APRAMAJ_REC Package variable S4B70.BANINST1.BWDKCPRF Rely on ()
APRAMAJVIEWC Package cursor S4B70.BANINST1.BWDKCPRF Rely on () Use(select )
SEARCHVIEWC Package cursor S4B70.BANINST1.BWAKADVS Use(select )
P_LOAD_DEGREE Package procedure S4B70.BANINST1.APKLDRD Rely on ()
P_LOAD_DEGREE Package procedure S4B70.BANINST1.APKLDRD Rely on () Use(insert,select )
OK_LOAD Forms Sub Procedure BANNER7_FORMS_10G.APADRVW.UPLOAD_DEGREE Use(insert,select )
OK_LOAD Forms Sub Procedure BANNER7_FORMS.APADRVW.UPLOAD_DEGREE Use(insert,select )
F_ADEG_MAJOR_ROWID Package function S4B70.BANINST1.AOKODSF Use(select )
F_CHECK_FOR_MORE_MAJORS Package function S4B70.BANINST1.AOKODSF Use(select )
APRAMAJ Forms DataBlock BANNER7_FORMS_10G.APAADEG Rely on () Use(insert,update,delete,select )
APRAMAJ Forms DataBlock BANNER7_FORMS.APASBIO Rely on () Use(select )
APRAMAJ Forms DataBlock BANNER7_FORMS_10G.APASBIO Rely on () Use(select )
APRAMAJ Forms DataBlock BANNER7_FORMS.APAADEG Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_APRAMAJ INDEX S4B70.ALUMNI Rely on ()
APRADEG TABLE S4B70.ALUMNI Refer( No Action )
STVMAJR TABLE S4B70.SATURN Refer( No Action )

Comments

Source Code Comments

Academic Major Repeating Table

Columns Comments for APRAMAJ_PIDM (1)

Source Code Comments

This field specifies the internal system generated identification number.

Columns Comments for APRAMAJ_ADEG_SEQ_NO (2)

Source Code Comments

This field specifies the internal sequence number.

Columns Comments for APRAMAJ_MAJR_CODE (3)

Source Code Comments

This field specifies the constituents major area(s) of study.

Columns Comments for APRAMAJ_ACTIVITY_DATE (4)

Source Code Comments

This system maintained field specifies the date this record was created or updated.

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