RORCRHR RPRCLVL SFRMHRS SGBSTDN SHRLGPA SHRTTRM SMRPRLE SOBCURR SORCCON SORCMJR SORCMNR SPBPERS SPRIDEN STVACYR STVADMT STVAPRN STVASTD STVBLCK STVBSKL STVCAMP STVCAPL STVCAST STVCOLL STVDEGC STVDEPT STVEDLV STVEGOL STVEMEX STVGAIN STVINCM STVLEAV STVLEVL STVMAJR STVORSN STVPRAC STVPREV STVRATE STVRESD STVSESS STVSITE STVSTST STVSTYP STVTERM STVTRCN STVVOED

Model SGBSTDN


Model Label : Banner SGBSTDN ERD

List of Objects

Object Name Object Type Layer Name
RORCRHR TABLE ERD
RPRCLVL TABLE ERD
SFRMHRS TABLE ERD
SGBSTDN TABLE Tables
SHRLGPA TABLE ERD
SHRTTRM TABLE ERD
SMRPRLE TABLE ERD
SOBCURR TABLE ERD
SORCCON TABLE ERD
SORCMJR TABLE ERD
SORCMNR TABLE ERD
SPBPERS TABLE ERD
SPRIDEN TABLE ERD
STVACYR TABLE ERD
STVADMT TABLE ERD
STVAPRN TABLE ERD
STVASTD TABLE ERD
STVBLCK TABLE ERD
STVBSKL TABLE ERD
STVCAMP TABLE ERD
STVCAPL TABLE ERD
STVCAST TABLE ERD
STVCOLL TABLE ERD
STVDEGC TABLE ERD
STVDEPT TABLE ERD
STVEDLV TABLE ERD
STVEGOL TABLE ERD
STVEMEX TABLE ERD
STVGAIN TABLE ERD
STVINCM TABLE ERD
STVLEAV TABLE ERD
STVLEVL TABLE ERD
STVMAJR TABLE ERD
STVORSN TABLE ERD
STVPRAC TABLE ERD
STVPREV TABLE ERD
STVRATE TABLE ERD
STVRESD TABLE ERD
STVSESS TABLE ERD
STVSITE TABLE ERD
STVSTST TABLE ERD
STVSTYP TABLE ERD
STVTERM TABLE ERD
STVTRCN TABLE ERD
STVVOED TABLE ERD

Comments

Model View

''

Table RORCRHR

Schema Name FAISMGR
Label RORCRHR
Server name S4B70
Creation Date 09/29/2003 12:14:17:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
RORCRHR_AIDY_CODE RORCRHR_AIDY_CODE VARCHAR2(4) No * *
RORCRHR_LEVL_CODE RORCRHR_LEVL_CODE VARCHAR2(2) No * *
RORCRHR_TERM_CODE RORCRHR_TERM_CODE VARCHAR2(6) No * *
RORCRHR_ACTIVITY_DATE RORCRHR_ACTIVITY_DATE DATE No
RORCRHR_FULL_TIME_CR_HRS RORCRHR_FULL_TIME_CR_HRS NUMBER(9,3) Yes
RORCRHR_3QUARTER_CR_HRS RORCRHR_3QUARTER_CR_HRS NUMBER(9,3) Yes
RORCRHR_HALF_TIME_CR_HRS RORCRHR_HALF_TIME_CR_HRS NUMBER(9,3) Yes

Foreign Key information

Column name is Foreign Key For Column on Table
RORCRHR_AIDY_CODE ROBINST_AIDY_CODE ROBINST
RORCRHR_LEVL_CODE STVLEVL_CODE STVLEVL
RORCRHR_TERM_CODE STVTERM_CODE STVTERM
RORCRHR_TERM_CODE SFRSTCR_TERM_CODE SFRSTCR
RORCRHR_LEVL_CODE SFRSTCR_LEVL_CODE SFRSTCR
RORCRHR_LEVL_CODE SGBSTDN_LEVL_CODE SGBSTDN

Index

Index Name Index Type Column Name
PK_RORCRHR Unique RORCRHR_AIDY_CODE
PK_RORCRHR Unique RORCRHR_LEVL_CODE
PK_RORCRHR Unique RORCRHR_TERM_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
UCL7 Cobol Paragraph [F:\banner\cobol].RPEDISB.UCL-CALCULATE-LOAD Use(select )
UCL7 Cobol Paragraph [F:\banner\cobol].RPOVLDT.UCL-CALCULATE-LOAD Use(select )
UCL7 Cobol Paragraph [F:\banner\cobol].RPBVLDT.UCL-CALCULATE-LOAD Use(select )
UCL7 Cobol Paragraph [F:\banner\cobol].RPEPINT.UCL-CALCULATE-LOAD Use(select )
UCL7 Cobol Paragraph [F:\banner\cobol].RPEPELL.UCL-CALCULATE-LOAD Use(select )
UCL7 Cobol Paragraph [F:\banner\cobol].RPEPCKG.UCL-CALCULATE-LOAD Use(select )
check_curterm C/C++ Function [F:\BANNER\C\RRREXIT.PC] Use(select )
check_preterm C/C++ Function [F:\BANNER\C\RRREXIT.PC] Use(select )
chk_enrl_hrs C/C++ Function [F:\BANNER\C\RRREXIT.PC] Use(select )
find_candidate C/C++ Function [F:\BANNER\C\RRREXIT.PC] Use(select )
sel_fa_term_count C/C++ Function [F:\BANNER\C\RERPL00.PC] Use(select )
sel_fa_term_count C/C++ Function [F:\BANNER\C\RERPL01.PC] Use(select )
sel_fa_term_count C/C++ Function [F:\BANNER\C\RERPL02.PC] Use(select )
sel_fa_term_count C/C++ Function [F:\BANNER\C\RERPL03.PC] Use(select )
sel_fa_term_count C/C++ Function [F:\BANNER\C\RERPL04.PC] Use(select )
sel_rorcrhr C/C++ Function [F:\BANNER\C\RRRAREQ.PC] Use(select )
select_enrollments C/C++ Function [F:\BANNER\C\RPBLMIE.PC] Use(select )
RORENRL TABLE S4B70.FAISMGR Join
NEW_RECORD_3 Forms Trigger BANNER7_FORMS.REAPV98 Use(select )
NEW_RECORD_3 Forms Trigger BANNER7_FORMS.REAPV99 Use(select )
NEW_RECORD_4 Forms Trigger BANNER7_FORMS.REAPV98 Use(select )
NEW_RECORD_4 Forms Trigger BANNER7_FORMS.REAPV99 Use(select )
NEW_RECORD_5 Forms Trigger BANNER7_FORMS.REAPV98 Use(select )
NEW_RECORD_5 Forms Trigger BANNER7_FORMS.REAPV99 Use(select )
NEW_RECORD_2A Forms Procedure BANNER7_FORMS.REAOR01 Use(select )
NEW_RECORD_2A Forms Procedure BANNER7_FORMS.REAOR02 Use(select )
NEW_RECORD_2A Forms Procedure BANNER7_FORMS.REAOR03 Use(select )
NEW_RECORD_2A Forms Procedure BANNER7_FORMS.REAOR00 Use(select )
NEW_RECORD_2A Forms Procedure BANNER7_FORMS_10G.REAOR02 Use(select )
NEW_RECORD_2A Forms Procedure BANNER7_FORMS_10G.REAOR05 Use(select )
NEW_RECORD_2A Forms Procedure BANNER7_FORMS_10G.REAOR03 Use(select )
NEW_RECORD_2A Forms Procedure BANNER7_FORMS_10G.REAOR04 Use(select )
NEW_RECORD_2A Forms Procedure BANNER7_FORMS.REAOR04 Use(select )
NEW_RECORD_2A Forms Procedure BANNER7_FORMS.REAPV99 Use(select )
NEW_RECORD_2A Forms Procedure BANNER7_FORMS.REAPV98 Use(select )
NEW_RECORD_2A Forms Procedure BANNER7_FORMS.REAOR05 Use(select )
F_GET_DEFAULT_ENROLL_STATUS Package function S4B70.BANINST1.RPKLOAN Rely on ()
P_CALC_LOAN_ENROLL_STATUS Package procedure S4B70.BANINST1.RPKLOAN Rely on ()
P_CALC_LOAN_ENROLL_STATUS Package procedure S4B70.BANINST1.RPKLOAN Use(select )
RORCRHR SYNONYM S4B70.PUBLIC Rely on ()
RORCRHR Forms DataBlock BANNER7_FORMS_10G.ROAINST Rely on () Use(insert,update,delete,select )
RORCRHR Forms DataBlock BANNER7_FORMS.ROAINST Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_RORCRHR INDEX S4B70.FAISMGR Rely on ()
ROBINST TABLE S4B70.FAISMGR Refer( No Action )
SFRSTCR TABLE S4B70.SATURN Join
SGBSTDN TABLE S4B70.SATURN Join
STVLEVL TABLE S4B70.SATURN Refer( No Action )
STVTERM TABLE S4B70.SATURN Refer( No Action )

Comments

Source Code Comments

Credit Hours Table

Columns Comments for RORCRHR_AIDY_CODE (1)

Source Code Comments

AID YEAR CODE: The aid year to be associated with information in this record. EXAMPLES: 9091, 9192, 9293, etc.

Columns Comments for RORCRHR_LEVL_CODE (2)

Source Code Comments

LEVEL CODE: This field identifies the educational level associated with the valid credit hours.

Columns Comments for RORCRHR_TERM_CODE (3)

Source Code Comments

TERM CODE: This field represents the valid term code associated with the credit hours listed.

Columns Comments for RORCRHR_ACTIVITY_DATE (4)

Source Code Comments

ACTIVITY DATE: The date that information for this record in the table was entered or last updated

Columns Comments for RORCRHR_FULL_TIME_CR_HRS (5)

Source Code Comments

FULL TIME CREDIT HOURS: This field identifies the number of credit hours a student must be enrolled in order to be considered enrolled full time.

Columns Comments for RORCRHR_3QUARTER_CR_HRS (6)

Source Code Comments

THREE QUARTER CREDIT HOURS: This field identifies the number of credit hours a student must be enrolled to be considered three quarter time.

Columns Comments for RORCRHR_HALF_TIME_CR_HRS (7)

Source Code Comments

HALF TIME CREDIT HOURS: This field identifies the number of credit hours a student must be enrolled in order to be considered enrolled on a half time basis.

Table RPRCLVL

Schema Name FAISMGR
Label RPRCLVL
Server name S4B70
Creation Date 09/29/2003 12:14:19:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
RPRCLVL_CAMP_CODE RPRCLVL_CAMP_CODE VARCHAR2(3) Yes
RPRCLVL_LEVL_CODE RPRCLVL_LEVL_CODE VARCHAR2(2) No *
RPRCLVL_ACTIVITY_DATE RPRCLVL_ACTIVITY_DATE DATE No
RPRCLVL_USER_ID RPRCLVL_USER_ID VARCHAR2(30) No

Foreign Key information

Column name is Foreign Key For Column on Table
RPRCLVL_LEVL_CODE SGBSTDN_LEVL_CODE SGBSTDN

Index

No Result

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
check_levl_parm C/C++ Function [F:\BANNER\C\RPRELAP.PC] Use(select )
check_levl_parm C/C++ Function [F:\BANNER\C\RPRLORC.PC] Use(select )
get_hours C/C++ Function [F:\BANNER\C\RPRELAP.PC] Use(select )
get_hours C/C++ Function [F:\BANNER\C\RPRLORC.PC] Use(select )
RPRCLVL SYNONYM S4B70.PUBLIC Rely on ()
CHECK_DISB_REC_DELAY Forms Trigger BANNER7_FORMS_10G.RPAELAP.RPRLAPP Use(select )
CHECK_DISB_REC_DELAY Forms Trigger BANNER7_FORMS_10G.RPALORG.RPRLAPP Use(select )
CHECK_DISB_REC_DELAY Forms Trigger BANNER7_FORMS.RPAELAP.RPRLAPP Use(select )
CHECK_DISB_REC_DELAY Forms Trigger BANNER7_FORMS.RPALORG.RPRLAPP Use(select )
PRE-INSERT Forms Trigger BANNER7_FORMS.RPRCLVL.RPRCLVL Use(select )
PRE-INSERT Forms Trigger BANNER7_FORMS_10G.RPRCLVL.RPRCLVL Use(select )
PRE-UPDATE Forms Trigger BANNER7_FORMS.RPRCLVL.RPRCLVL Use(select )
PRE-UPDATE Forms Trigger BANNER7_FORMS_10G.RPRCLVL.RPRCLVL Use(select )
RPRCLVL Forms DataBlock BANNER7_FORMS.RPRCLVL Rely on () Use(insert,update,delete,select )
RPRCLVL Forms DataBlock BANNER7_FORMS_10G.RPRCLVL Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
SGBSTDN TABLE S4B70.SATURN Join

Comments

Source Code Comments

Campus Undergraduate Level Code Rules Table

Columns Comments for RPRCLVL_CAMP_CODE (1)

Source Code Comments

CAMPUS CODE: The campus code from STVCAMP for which the level codes will be defined.

Columns Comments for RPRCLVL_LEVL_CODE (2)

Source Code Comments

LEVEL CODE: The undergraduate level codes from STVLEVL associated with the campus code.

Columns Comments for RPRCLVL_ACTIVITY_DATE (3)

Source Code Comments

ACTIVITY DATE: The date that information in this record was created or last updated.

Columns Comments for RPRCLVL_USER_ID (4)

Source Code Comments

USER ID: The ID of the user who created or last updated this record.

Table SFRMHRS

Schema Name SATURN
Label SFRMHRS
Server name S4B70
Creation Date 09/29/2003 12:09:32:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SFRMHRS_TERM_CODE SFRMHRS_TERM_CODE VARCHAR2(6) No * *
SFRMHRS_LEVL_CODE SFRMHRS_LEVL_CODE VARCHAR2(2) No * *
SFRMHRS_MAX_HRS SFRMHRS_MAX_HRS NUMBER(9,3) No
SFRMHRS_ACTIVITY_DATE SFRMHRS_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
SFRMHRS_TERM_CODE SOBTERM_TERM_CODE SOBTERM
SFRMHRS_LEVL_CODE STVLEVL_CODE STVLEVL
SFRMHRS_TERM_CODE STVTERM_CODE STVTERM
SFRMHRS_LEVL_CODE SGBSTDN_LEVL_CODE SGBSTDN

Index

Index Name Index Type Column Name
PK_SFRMHRS Unique SFRMHRS_TERM_CODE
PK_SFRMHRS Unique SFRMHRS_LEVL_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
getmaxhrs C/C++ Function [F:\BANNER\C\SFPFREQ.PC] Use(select )
SFRMHRS SYNONYM S4B70.PUBLIC Rely on ()
GET_MHRS Forms Trigger BANNER7_FORMS.SFAREGS Use(select )
GET_MHRS Forms Trigger BANNER7_FORMS_10G.SFAREGS Use(select )
POST_QUERY Forms Trigger BANNER7_FORMS.SFAREGS.SGBSTDN Use(select )
POST_QUERY Forms Trigger BANNER7_FORMS_10G.SFAREGS.SGBSTDN Use(select )
MHRS_MAX_HRS Package variable S4B70.BANINST1.BWCKGENS Rely on ()
MHRS_MAX_HRS Package variable S4B70.BANINST1.BWCKREGS Rely on ()
P_REGSCHK Package procedure S4B70.BANINST1.BWCKREGS Use(select )
P_SEARCHCHK Package procedure S4B70.BANINST1.BWCKGENS Use(select )
P_VERIFY_ELIGIBLE_TO_REGISTER Package procedure S4B70.BANINST1.VRSKFORG Rely on ()
P_VR_CONFIRM_REG Package procedure S4B70.BANINST1.VRSKFORG Rely on ()
P_VR_REG_APPL_MENU_OPT Package procedure S4B70.BANINST1.VRSKFORG Rely on ()
P_VR_REG_TERM_ELIGIBLE Package procedure S4B70.BANINST1.VRSKFOLR Rely on ()
P_VR_WITHDRAW_FROM_TERM Package procedure S4B70.BANINST1.VRSKFORG Rely on ()
SFRMHRS_ROW_BY_TERM_LEVL_C Package cursor S4B70.BANINST1.SFKSELS Rely on ()
SFRMHRS_ROW_BY_TERM_LEVL_C Package cursor S4B70.BANINST1.SFKSELS Rely on () Use(select )
F_GET_MAX_HOURS Package function S4B70.BANINST1.SFKSELS Rely on ()
F_GET_MAX_HOURS Package function S4B70.BANINST1.SFKSELS Rely on ()
SFRMHRS Forms DataBlock BANNER7_FORMS.SFAMHRS Rely on () Use(insert,update,delete,select )
SFRMHRS Forms DataBlock BANNER7_FORMS_10G.SFAMHRS Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_SFRMHRS INDEX S4B70.SATURN Rely on ()
SGBSTDN TABLE S4B70.SATURN Join
SOBTERM TABLE S4B70.SATURN Refer( No Action )
STVLEVL TABLE S4B70.SATURN Refer( No Action )
STVTERM TABLE S4B70.SATURN Refer( No Action )

Comments

Source Code Comments

Registration Maximum Hours Table

Columns Comments for SFRMHRS_TERM_CODE (1)

Source Code Comments

This field identifies the term associated with the maximum hours allowable.

Columns Comments for SFRMHRS_LEVL_CODE (2)

Source Code Comments

This field identifies the level associated with the maximum hours allowable.

Columns Comments for SFRMHRS_MAX_HRS (3)

Source Code Comments

This field identifies the maximum hours allowable for the associated term and level.

Columns Comments for SFRMHRS_ACTIVITY_DATE (4)

Source Code Comments

This field specifies the most current date record was created or updated.

Table SGBSTDN

Schema Name SATURN
Label SGBSTDN
Server name S4B70
Creation Date 09/13/2004 13:13:51:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SGBSTDN_PIDM SGBSTDN_PIDM NUMBER(8,0) No * *
SGBSTDN_TERM_CODE_EFF SGBSTDN_TERM_CODE_EFF VARCHAR2(6) No * *
SGBSTDN_STST_CODE SGBSTDN_STST_CODE VARCHAR2(2) No *
SGBSTDN_LEVL_CODE SGBSTDN_LEVL_CODE VARCHAR2(2) Yes *
SGBSTDN_STYP_CODE SGBSTDN_STYP_CODE VARCHAR2(1) No *
SGBSTDN_TERM_CODE_MATRIC SGBSTDN_TERM_CODE_MATRIC VARCHAR2(6) Yes *
SGBSTDN_TERM_CODE_ADMIT SGBSTDN_TERM_CODE_ADMIT VARCHAR2(6) Yes *
SGBSTDN_EXP_GRAD_DATE SGBSTDN_EXP_GRAD_DATE DATE Yes
SGBSTDN_CAMP_CODE SGBSTDN_CAMP_CODE VARCHAR2(3) Yes *
SGBSTDN_FULL_PART_IND SGBSTDN_FULL_PART_IND VARCHAR2(1) Yes
SGBSTDN_SESS_CODE SGBSTDN_SESS_CODE VARCHAR2(1) Yes *
SGBSTDN_RESD_CODE SGBSTDN_RESD_CODE VARCHAR2(1) Yes *
SGBSTDN_COLL_CODE_1 SGBSTDN_COLL_CODE_1 VARCHAR2(2) Yes *
SGBSTDN_DEGC_CODE_1 SGBSTDN_DEGC_CODE_1 VARCHAR2(6) Yes *
SGBSTDN_MAJR_CODE_1 SGBSTDN_MAJR_CODE_1 VARCHAR2(4) Yes *
SGBSTDN_MAJR_CODE_MINR_1 SGBSTDN_MAJR_CODE_MINR_1 VARCHAR2(4) Yes *
SGBSTDN_MAJR_CODE_MINR_1_2 SGBSTDN_MAJR_CODE_MINR_1_2 VARCHAR2(4) Yes *
SGBSTDN_MAJR_CODE_CONC_1 SGBSTDN_MAJR_CODE_CONC_1 VARCHAR2(4) Yes *
SGBSTDN_MAJR_CODE_CONC_1_2 SGBSTDN_MAJR_CODE_CONC_1_2 VARCHAR2(4) Yes *
SGBSTDN_MAJR_CODE_CONC_1_3 SGBSTDN_MAJR_CODE_CONC_1_3 VARCHAR2(4) Yes *
SGBSTDN_COLL_CODE_2 SGBSTDN_COLL_CODE_2 VARCHAR2(2) Yes *
SGBSTDN_DEGC_CODE_2 SGBSTDN_DEGC_CODE_2 VARCHAR2(6) Yes *
SGBSTDN_MAJR_CODE_2 SGBSTDN_MAJR_CODE_2 VARCHAR2(4) Yes *
SGBSTDN_MAJR_CODE_MINR_2 SGBSTDN_MAJR_CODE_MINR_2 VARCHAR2(4) Yes *
SGBSTDN_MAJR_CODE_MINR_2_2 SGBSTDN_MAJR_CODE_MINR_2_2 VARCHAR2(4) Yes *
SGBSTDN_MAJR_CODE_CONC_2 SGBSTDN_MAJR_CODE_CONC_2 VARCHAR2(4) Yes *
SGBSTDN_MAJR_CODE_CONC_2_2 SGBSTDN_MAJR_CODE_CONC_2_2 VARCHAR2(4) Yes *
SGBSTDN_MAJR_CODE_CONC_2_3 SGBSTDN_MAJR_CODE_CONC_2_3 VARCHAR2(4) Yes *
SGBSTDN_ORSN_CODE SGBSTDN_ORSN_CODE VARCHAR2(1) Yes *
SGBSTDN_PRAC_CODE SGBSTDN_PRAC_CODE VARCHAR2(2) Yes *
SGBSTDN_ADVR_PIDM SGBSTDN_ADVR_PIDM NUMBER(8,0) Yes
SGBSTDN_GRAD_CREDIT_APPR_IND SGBSTDN_GRAD_CREDIT_APPR_IND VARCHAR2(1) Yes
SGBSTDN_CAPL_CODE SGBSTDN_CAPL_CODE VARCHAR2(2) Yes *
SGBSTDN_LEAV_CODE SGBSTDN_LEAV_CODE VARCHAR2(1) Yes *
SGBSTDN_LEAV_FROM_DATE SGBSTDN_LEAV_FROM_DATE DATE Yes
SGBSTDN_LEAV_TO_DATE SGBSTDN_LEAV_TO_DATE DATE Yes
SGBSTDN_ASTD_CODE SGBSTDN_ASTD_CODE VARCHAR2(2) Yes *
SGBSTDN_TERM_CODE_ASTD SGBSTDN_TERM_CODE_ASTD VARCHAR2(6) Yes *
SGBSTDN_RATE_CODE SGBSTDN_RATE_CODE VARCHAR2(5) Yes *
SGBSTDN_ACTIVITY_DATE SGBSTDN_ACTIVITY_DATE DATE No
SGBSTDN_MAJR_CODE_1_2 SGBSTDN_MAJR_CODE_1_2 VARCHAR2(4) Yes *
SGBSTDN_MAJR_CODE_2_2 SGBSTDN_MAJR_CODE_2_2 VARCHAR2(4) Yes *
SGBSTDN_EDLV_CODE SGBSTDN_EDLV_CODE VARCHAR2(3) Yes *
SGBSTDN_INCM_CODE SGBSTDN_INCM_CODE VARCHAR2(2) Yes *
SGBSTDN_ADMT_CODE SGBSTDN_ADMT_CODE VARCHAR2(2) Yes *
SGBSTDN_EMEX_CODE SGBSTDN_EMEX_CODE VARCHAR2(2) Yes *
SGBSTDN_APRN_CODE SGBSTDN_APRN_CODE VARCHAR2(2) Yes *
SGBSTDN_TRCN_CODE SGBSTDN_TRCN_CODE VARCHAR2(2) Yes *
SGBSTDN_GAIN_CODE SGBSTDN_GAIN_CODE VARCHAR2(2) Yes *
SGBSTDN_VOED_CODE SGBSTDN_VOED_CODE VARCHAR2(2) Yes *
SGBSTDN_BLCK_CODE SGBSTDN_BLCK_CODE VARCHAR2(10) Yes *
SGBSTDN_TERM_CODE_GRAD SGBSTDN_TERM_CODE_GRAD VARCHAR2(6) Yes *
SGBSTDN_ACYR_CODE SGBSTDN_ACYR_CODE VARCHAR2(4) Yes *
SGBSTDN_DEPT_CODE SGBSTDN_DEPT_CODE VARCHAR2(4) Yes *
SGBSTDN_SITE_CODE SGBSTDN_SITE_CODE VARCHAR2(3) Yes *
SGBSTDN_DEPT_CODE_2 SGBSTDN_DEPT_CODE_2 VARCHAR2(4) Yes *
SGBSTDN_EGOL_CODE SGBSTDN_EGOL_CODE VARCHAR2(2) Yes *
SGBSTDN_DEGC_CODE_DUAL SGBSTDN_DEGC_CODE_DUAL VARCHAR2(6) Yes *
SGBSTDN_LEVL_CODE_DUAL SGBSTDN_LEVL_CODE_DUAL VARCHAR2(2) Yes *
SGBSTDN_DEPT_CODE_DUAL SGBSTDN_DEPT_CODE_DUAL VARCHAR2(4) Yes *
SGBSTDN_COLL_CODE_DUAL SGBSTDN_COLL_CODE_DUAL VARCHAR2(2) Yes *
SGBSTDN_MAJR_CODE_DUAL SGBSTDN_MAJR_CODE_DUAL VARCHAR2(4) Yes *
SGBSTDN_BSKL_CODE SGBSTDN_BSKL_CODE VARCHAR2(2) Yes *
SGBSTDN_PRIM_ROLL_IND SGBSTDN_PRIM_ROLL_IND VARCHAR2(1) Yes
SGBSTDN_PROGRAM_1 SGBSTDN_PROGRAM_1 VARCHAR2(12) Yes *
SGBSTDN_TERM_CODE_CTLG_1 SGBSTDN_TERM_CODE_CTLG_1 VARCHAR2(6) Yes *
SGBSTDN_DEPT_CODE_1_2 SGBSTDN_DEPT_CODE_1_2 VARCHAR2(4) Yes *
SGBSTDN_MAJR_CODE_CONC_121 SGBSTDN_MAJR_CODE_CONC_121 VARCHAR2(4) Yes *
SGBSTDN_MAJR_CODE_CONC_122 SGBSTDN_MAJR_CODE_CONC_122 VARCHAR2(4) Yes *
SGBSTDN_MAJR_CODE_CONC_123 SGBSTDN_MAJR_CODE_CONC_123 VARCHAR2(4) Yes *
SGBSTDN_SECD_ROLL_IND SGBSTDN_SECD_ROLL_IND VARCHAR2(1) Yes
SGBSTDN_TERM_CODE_ADMIT_2 SGBSTDN_TERM_CODE_ADMIT_2 VARCHAR2(6) Yes *
SGBSTDN_ADMT_CODE_2 SGBSTDN_ADMT_CODE_2 VARCHAR2(2) Yes *
SGBSTDN_PROGRAM_2 SGBSTDN_PROGRAM_2 VARCHAR2(12) Yes *
SGBSTDN_TERM_CODE_CTLG_2 SGBSTDN_TERM_CODE_CTLG_2 VARCHAR2(6) Yes *
SGBSTDN_LEVL_CODE_2 SGBSTDN_LEVL_CODE_2 VARCHAR2(2) Yes *
SGBSTDN_CAMP_CODE_2 SGBSTDN_CAMP_CODE_2 VARCHAR2(3) Yes *
SGBSTDN_DEPT_CODE_2_2 SGBSTDN_DEPT_CODE_2_2 VARCHAR2(4) Yes *
SGBSTDN_MAJR_CODE_CONC_221 SGBSTDN_MAJR_CODE_CONC_221 VARCHAR2(4) Yes *
SGBSTDN_MAJR_CODE_CONC_222 SGBSTDN_MAJR_CODE_CONC_222 VARCHAR2(4) Yes *
SGBSTDN_MAJR_CODE_CONC_223 SGBSTDN_MAJR_CODE_CONC_223 VARCHAR2(4) Yes *
SGBSTDN_CURR_RULE_1 SGBSTDN_CURR_RULE_1 NUMBER(8,0) Yes *
SGBSTDN_CMJR_RULE_1_1 SGBSTDN_CMJR_RULE_1_1 NUMBER(8,0) Yes *
SGBSTDN_CCON_RULE_11_1 SGBSTDN_CCON_RULE_11_1 NUMBER(8,0) Yes *
SGBSTDN_CCON_RULE_11_2 SGBSTDN_CCON_RULE_11_2 NUMBER(8,0) Yes *
SGBSTDN_CCON_RULE_11_3 SGBSTDN_CCON_RULE_11_3 NUMBER(8,0) Yes *
SGBSTDN_CMJR_RULE_1_2 SGBSTDN_CMJR_RULE_1_2 NUMBER(8,0) Yes *
SGBSTDN_CCON_RULE_12_1 SGBSTDN_CCON_RULE_12_1 NUMBER(8,0) Yes *
SGBSTDN_CCON_RULE_12_2 SGBSTDN_CCON_RULE_12_2 NUMBER(8,0) Yes *
SGBSTDN_CCON_RULE_12_3 SGBSTDN_CCON_RULE_12_3 NUMBER(8,0) Yes *
SGBSTDN_CMNR_RULE_1_1 SGBSTDN_CMNR_RULE_1_1 NUMBER(8,0) Yes *
SGBSTDN_CMNR_RULE_1_2 SGBSTDN_CMNR_RULE_1_2 NUMBER(8,0) Yes *
SGBSTDN_CURR_RULE_2 SGBSTDN_CURR_RULE_2 NUMBER(8,0) Yes *
SGBSTDN_CMJR_RULE_2_1 SGBSTDN_CMJR_RULE_2_1 NUMBER(8,0) Yes *
SGBSTDN_CCON_RULE_21_1 SGBSTDN_CCON_RULE_21_1 NUMBER(8,0) Yes *
SGBSTDN_CCON_RULE_21_2 SGBSTDN_CCON_RULE_21_2 NUMBER(8,0) Yes *
SGBSTDN_CCON_RULE_21_3 SGBSTDN_CCON_RULE_21_3 NUMBER(8,0) Yes *
SGBSTDN_CMJR_RULE_2_2 SGBSTDN_CMJR_RULE_2_2 NUMBER(8,0) Yes *
SGBSTDN_CCON_RULE_22_1 SGBSTDN_CCON_RULE_22_1 NUMBER(8,0) Yes *
SGBSTDN_CCON_RULE_22_2 SGBSTDN_CCON_RULE_22_2 NUMBER(8,0) Yes *
SGBSTDN_CCON_RULE_22_3 SGBSTDN_CCON_RULE_22_3 NUMBER(8,0) Yes *
SGBSTDN_CMNR_RULE_2_1 SGBSTDN_CMNR_RULE_2_1 NUMBER(8,0) Yes *
SGBSTDN_CMNR_RULE_2_2 SGBSTDN_CMNR_RULE_2_2 NUMBER(8,0) Yes *
SGBSTDN_PREV_CODE SGBSTDN_PREV_CODE VARCHAR2(2) Yes *
SGBSTDN_TERM_CODE_PREV SGBSTDN_TERM_CODE_PREV VARCHAR2(6) Yes *
SGBSTDN_CAST_CODE SGBSTDN_CAST_CODE VARCHAR2(2) Yes *
SGBSTDN_TERM_CODE_CAST SGBSTDN_TERM_CODE_CAST VARCHAR2(6) Yes *
SGBSTDN_DATA_ORIGIN SGBSTDN_DATA_ORIGIN VARCHAR2(30) Yes
SGBSTDN_USER_ID SGBSTDN_USER_ID VARCHAR2(30) Yes

Foreign Key information

Column name is Foreign Key For Column on Table
SGBSTDN_EDLV_CODE STVEDLV_CODE STVEDLV
SGBSTDN_CMJR_RULE_1_2 SORCMJR_CMJR_RULE SORCMJR
SGBSTDN_CMJR_RULE_2_2 SORCMJR_CMJR_RULE SORCMJR
SGBSTDN_CMJR_RULE_2_1 SORCMJR_CMJR_RULE SORCMJR
SGBSTDN_CMJR_RULE_1_1 SORCMJR_CMJR_RULE SORCMJR
SGBSTDN_PROGRAM_2 SMRPRLE_PROGRAM SMRPRLE
SGBSTDN_PROGRAM_1 SMRPRLE_PROGRAM SMRPRLE
SGBSTDN_VOED_CODE STVVOED_CODE STVVOED
SGBSTDN_CMNR_RULE_1_1 SORCMNR_CMNR_RULE SORCMNR
SGBSTDN_CMNR_RULE_2_2 SORCMNR_CMNR_RULE SORCMNR
SGBSTDN_CMNR_RULE_2_1 SORCMNR_CMNR_RULE SORCMNR
SGBSTDN_CMNR_RULE_1_2 SORCMNR_CMNR_RULE SORCMNR
SGBSTDN_APRN_CODE STVAPRN_CODE STVAPRN
SGBSTDN_CAMP_CODE_2 STVCAMP_CODE STVCAMP
SGBSTDN_CAMP_CODE STVCAMP_CODE STVCAMP
SGBSTDN_CAPL_CODE STVCAPL_CODE STVCAPL
SGBSTDN_INCM_CODE STVINCM_CODE STVINCM
SGBSTDN_CAST_CODE STVCAST_CODE STVCAST
SGBSTDN_BLCK_CODE STVBLCK_CODE STVBLCK
SGBSTDN_LEVL_CODE_2 STVLEVL_CODE STVLEVL
SGBSTDN_LEVL_CODE_DUAL STVLEVL_CODE STVLEVL
SGBSTDN_LEVL_CODE STVLEVL_CODE STVLEVL
SGBSTDN_TERM_CODE_ASTD STVTERM_CODE STVTERM
SGBSTDN_TERM_CODE_CTLG_2 STVTERM_CODE STVTERM
SGBSTDN_TERM_CODE_ADMIT_2 STVTERM_CODE STVTERM
SGBSTDN_TERM_CODE_CTLG_1 STVTERM_CODE STVTERM
SGBSTDN_TERM_CODE_MATRIC STVTERM_CODE STVTERM
SGBSTDN_TERM_CODE_EFF STVTERM_CODE STVTERM
SGBSTDN_TERM_CODE_ADMIT STVTERM_CODE STVTERM
SGBSTDN_TERM_CODE_GRAD STVTERM_CODE STVTERM
SGBSTDN_TERM_CODE_PREV STVTERM_CODE STVTERM
SGBSTDN_TERM_CODE_CAST STVTERM_CODE STVTERM
SGBSTDN_CCON_RULE_22_1 SORCCON_CCON_RULE SORCCON
SGBSTDN_MAJR_CODE_MINR_2 STVMAJR_CODE STVMAJR
SGBSTDN_CCON_RULE_22_2 SORCCON_CCON_RULE SORCCON
SGBSTDN_MAJR_CODE_MINR_2_2 STVMAJR_CODE STVMAJR
SGBSTDN_CCON_RULE_22_3 SORCCON_CCON_RULE SORCCON
SGBSTDN_MAJR_CODE_CONC_2 STVMAJR_CODE STVMAJR
SGBSTDN_MAJR_CODE_CONC_2_2 STVMAJR_CODE STVMAJR
SGBSTDN_MAJR_CODE_CONC_2_3