EXCEPTIONS SABAUDF SFRMHRS SGBEOPS SGBOEDU SGBSTDN SGBUSER SGRACMT SGRADVR SGRASSI SGRASST SGRCATT SGRCHRT SGRCLSR SGRCMNT SGRCOLR SGRCOOP SGRDISA SGRDSER SGRDUTY SGRESEL SGRSACT SGRSATT SGRSCMT SGRSPRT SGRVETN SHRLGPA SHRTTRM SMRPRLE SOBCURR SORCCON SORCMJR SORCMNR SPBPERS SPRIDEN STVACTC STVACYR STVADMT STVADVR STVAFDC STVAPRN STVASTD STVATTS STVBLCK STVBSKL STVCAMP STVCAPL STVCAST STVCHRT STVCLAS STVCOLL STVCOPC STVCREA STVDEPS STVDISA STVDLEV STVEDLV STVEGOL STVELIG STVEMEX STVEMPL STVEOPS STVESEL STVGAIN STVGSTA STVGTYP STVINCM STVLEAV STVLEVL STVMARS STVMEDI STVORIG STVORSN STVPRAC STVPREV STVRATE STVRESD STVSEPR STVSESS STVSFAE STVSITE STVSOFF STVSPRV STVSPSR STVSPST STVSSEP STVSSER STVSSRS STVSSST STVSTST STVSTYP STVSUDA STVSUDB STVSUDC STVSUDD STVSUDE STVSUDF STVSUDG STVSUDH STVSUDI STVSUDJ STVTASK STVTRCN STVVETC STVVOED STVWTHD

Model ERD General Student


Model Label : ERD for General Student

List of Objects

Object Name Object Type Layer Name
EXCEPTIONS TABLE Tables
SABAUDF TABLE Tables
SFRMHRS TABLE ERD
SGBEOPS TABLE Tables
SGBOEDU TABLE Tables
SGBSTDN TABLE Tables
SGBUSER TABLE Tables
SGRACMT TABLE Tables
SGRADVR TABLE Tables
SGRASSI TABLE Tables
SGRASST TABLE Tables
SGRCATT TABLE Tables
SGRCHRT TABLE Tables
SGRCLSR TABLE Tables
SGRCMNT TABLE Tables
SGRCOLR TABLE Tables
SGRCOOP TABLE Tables
SGRDISA TABLE Tables
SGRDSER TABLE Tables
SGRDUTY TABLE Tables
SGRESEL TABLE Tables
SGRSACT TABLE Tables
SGRSATT TABLE Tables
SGRSCMT TABLE Tables
SGRSPRT TABLE Tables
SGRVETN 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
STVACTC TABLE ERD
STVACYR TABLE ERD
STVADMT TABLE ERD
STVADVR TABLE ERD
STVAFDC TABLE ERD
STVAPRN TABLE ERD
STVASTD TABLE ERD
STVATTS TABLE ERD
STVBLCK TABLE ERD
STVBSKL TABLE ERD
STVCAMP TABLE ERD
STVCAPL TABLE ERD
STVCAST TABLE ERD
STVCHRT TABLE ERD
STVCLAS TABLE ERD
STVCOLL TABLE ERD
STVCOPC TABLE ERD
STVCREA TABLE ERD
STVDEPS TABLE ERD
STVDISA TABLE ERD
STVDLEV TABLE ERD
STVEDLV TABLE ERD
STVEGOL TABLE ERD
STVELIG TABLE ERD
STVEMEX TABLE ERD
STVEMPL TABLE ERD
STVEOPS TABLE ERD
STVESEL TABLE ERD
STVGAIN TABLE ERD
STVGSTA TABLE ERD
STVGTYP TABLE ERD
STVINCM TABLE ERD
STVLEAV TABLE ERD
STVLEVL TABLE ERD
STVMARS TABLE ERD
STVMEDI TABLE ERD
STVORIG TABLE ERD
STVORSN TABLE ERD
STVPRAC TABLE ERD
STVPREV TABLE ERD
STVRATE TABLE ERD
STVRESD TABLE ERD
STVSEPR TABLE ERD
STVSESS TABLE ERD
STVSFAE TABLE ERD
STVSITE TABLE ERD
STVSOFF TABLE ERD
STVSPRV TABLE ERD
STVSPSR TABLE ERD
STVSPST TABLE ERD
STVSSEP TABLE ERD
STVSSER TABLE ERD
STVSSRS TABLE ERD
STVSSST TABLE ERD
STVSTST TABLE ERD
STVSTYP TABLE ERD
STVSUDA TABLE ERD
STVSUDB TABLE ERD
STVSUDC TABLE ERD
STVSUDD TABLE ERD
STVSUDE TABLE ERD
STVSUDF TABLE ERD
STVSUDG TABLE ERD
STVSUDH TABLE ERD
STVSUDI TABLE ERD
STVSUDJ TABLE ERD
STVTASK TABLE ERD
STVTRCN TABLE ERD
STVVETC TABLE ERD
STVVOED TABLE ERD
STVWTHD TABLE ERD

Comments

Model View

''

Table EXCEPTIONS

Schema Name SATURN
Label EXCEPTIONS
Server name S4B70
Creation Date 07/21/2003 16:25:19:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
ROW_ID ROW_ID ROWID Yes
OWNER OWNER VARCHAR2(30) Yes
TABLE_NAME TABLE_NAME VARCHAR2(30) Yes
CONSTRAINT CONSTRAINT VARCHAR2(30) Yes

Foreign Key information

No Foreign Key

Index

No Result

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
accept_parms C/C++ Function [F:\BANNER\C\RORGRDE.PC] Use()
control_info C/C++ Function [F:\BANNER\C\FRRBEXC.PC] Use()
control_insert C/C++ Function [F:\BANNER\C\NBRPSTA.PC] Use()
control_insert2 C/C++ Function [F:\BANNER\C\NBRPSTA.PC] Use()
detail_foot C/C++ Function [F:\BANNER\C\TGRCLOS.PC] Use()
foot C/C++ Function [F:\BANNER\C\TGRCLOS.PC] Use()
get_parameters C/C++ Function [F:\BANNER\C\NBRPSTA.PC] Use()
header C/C++ Function [F:\BANNER\C\NBRPSTA.PC] Use()
print_exception_header C/C++ Function [F:\BANNER\C\FORCONV.PC] Use()
user_parms C/C++ Function [F:\BANNER\C\FOPARCP.PC] Use()

Comments

Table SABAUDF

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SABAUDF_TERM_CODE_EFF SABAUDF_TERM_CODE_EFF VARCHAR2(6) No * *
SABAUDF_FLAG1_DESC SABAUDF_FLAG1_DESC VARCHAR2(20) Yes
SABAUDF_FLAG2_DESC SABAUDF_FLAG2_DESC VARCHAR2(20) Yes
SABAUDF_FLAG3_DESC SABAUDF_FLAG3_DESC VARCHAR2(20) Yes
SABAUDF_FLAG4_DESC SABAUDF_FLAG4_DESC VARCHAR2(20) Yes
SABAUDF_FLAG5_DESC SABAUDF_FLAG5_DESC VARCHAR2(20) Yes
SABAUDF_FLAG6_DESC SABAUDF_FLAG6_DESC VARCHAR2(20) Yes
SABAUDF_FLAG7_DESC SABAUDF_FLAG7_DESC VARCHAR2(20) Yes
SABAUDF_FLAG8_DESC SABAUDF_FLAG8_DESC VARCHAR2(20) Yes
SABAUDF_FLAG9_DESC SABAUDF_FLAG9_DESC VARCHAR2(20) Yes
SABAUDF_FLAG10_DESC SABAUDF_FLAG10_DESC VARCHAR2(20) Yes
SABAUDF_DATA1_DESC SABAUDF_DATA1_DESC VARCHAR2(20) Yes
SABAUDF_DATA2_DESC SABAUDF_DATA2_DESC VARCHAR2(20) Yes
SABAUDF_DATA3_DESC SABAUDF_DATA3_DESC VARCHAR2(20) Yes
SABAUDF_DATA4_DESC SABAUDF_DATA4_DESC VARCHAR2(20) Yes
SABAUDF_DATA5_DESC SABAUDF_DATA5_DESC VARCHAR2(20) Yes
SABAUDF_DATA6_DESC SABAUDF_DATA6_DESC VARCHAR2(20) Yes
SABAUDF_DATA7_DESC SABAUDF_DATA7_DESC VARCHAR2(20) Yes
SABAUDF_DATA8_DESC SABAUDF_DATA8_DESC VARCHAR2(20) Yes
SABAUDF_DATA9_DESC SABAUDF_DATA9_DESC VARCHAR2(20) Yes
SABAUDF_DATA10_DESC SABAUDF_DATA10_DESC VARCHAR2(20) Yes
SABAUDF_DATA11_DESC SABAUDF_DATA11_DESC VARCHAR2(20) Yes
SABAUDF_DATA12_DESC SABAUDF_DATA12_DESC VARCHAR2(20) Yes
SABAUDF_DATA13_DESC SABAUDF_DATA13_DESC VARCHAR2(20) Yes
SABAUDF_DATA14_DESC SABAUDF_DATA14_DESC VARCHAR2(20) Yes
SABAUDF_DATA15_DESC SABAUDF_DATA15_DESC VARCHAR2(20) Yes
SABAUDF_DATA16_DESC SABAUDF_DATA16_DESC VARCHAR2(20) Yes
SABAUDF_DATA17_DESC SABAUDF_DATA17_DESC VARCHAR2(20) Yes
SABAUDF_DATA18_DESC SABAUDF_DATA18_DESC VARCHAR2(20) Yes
SABAUDF_DATA19_DESC SABAUDF_DATA19_DESC VARCHAR2(20) Yes
SABAUDF_DATA20_DESC SABAUDF_DATA20_DESC VARCHAR2(20) Yes
SABAUDF_ACTIVITY_DATE SABAUDF_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
SABAUDF_TERM_CODE_EFF STVTERM_CODE STVTERM

Index

Index Name Index Type Column Name
PK_SABAUDF Unique SABAUDF_TERM_CODE_EFF

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
SABAUDF SYNONYM S4B70.PUBLIC Rely on ()
POST-CHANGE Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA11 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA18 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA16 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA10 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA9 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA7 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA5 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA19 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA8 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA12 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA1 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA3 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA20 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA17 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA13 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA14 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA2 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA6 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA15 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA4 Use(select )
PRE-TEXT-ITEM Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA11 Use(select )
PRE-TEXT-ITEM Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA20 Use(select )
PRE-TEXT-ITEM Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA19 Use(select )
PRE-TEXT-ITEM Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA17 Use(select )
PRE-TEXT-ITEM Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA5 Use(select )
PRE-TEXT-ITEM Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA13 Use(select )
PRE-TEXT-ITEM Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA7 Use(select )
PRE-TEXT-ITEM Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA14 Use(select )
PRE-TEXT-ITEM Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA9 Use(select )
PRE-TEXT-ITEM Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA2 Use(select )
PRE-TEXT-ITEM Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA8 Use(select )
PRE-TEXT-ITEM Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA12 Use(select )
PRE-TEXT-ITEM Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA1 Use(select )
PRE-TEXT-ITEM Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA3 Use(select )
PRE-TEXT-ITEM Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA16 Use(select )
PRE-TEXT-ITEM Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA6 Use(select )
PRE-TEXT-ITEM Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA4 Use(select )
PRE-TEXT-ITEM Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA10 Use(select )
PRE-TEXT-ITEM Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.INST_DATA17_DESC Use(select )
PRE-TEXT-ITEM Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA15 Use(select )
PRE-TEXT-ITEM Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA18 Use(select )
WHEN-NEW-ITEM-INSTANCE Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_FLAG7 Use(select )
WHEN-NEW-ITEM-INSTANCE Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_FLAG6 Use(select )
WHEN-NEW-ITEM-INSTANCE Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_FLAG10 Use(select )
WHEN-NEW-ITEM-INSTANCE Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_FLAG5 Use(select )
WHEN-NEW-ITEM-INSTANCE Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_FLAG4 Use(select )
WHEN-NEW-ITEM-INSTANCE Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_FLAG3 Use(select )
WHEN-NEW-ITEM-INSTANCE Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_FLAG2 Use(select )
WHEN-NEW-ITEM-INSTANCE Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_FLAG1 Use(select )
WHEN-NEW-ITEM-INSTANCE Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_FLAG9 Use(select )
WHEN-NEW-ITEM-INSTANCE Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_FLAG8 Use(select )
STVTERM_EXISTS_RG Forms Record Group BANNER7_FORMS.SAAAUDF Use(select )
STVTERM_EXISTS_RG Forms Record Group BANNER7_FORMS_10G.SAAAUDF Use(select )
POPULATE_SABAUDF_FIELDS Forms Procedure BANNER7_FORMS.SOASUPL Use(select )
POPULATE_SABAUDF_FIELDS Forms Procedure BANNER7_FORMS_10G.SOASUPL Use(select )
SABAUDF Forms DataBlock BANNER7_FORMS.SAAAUDF Rely on () Use(insert,update,delete,select )
SABAUDF Forms DataBlock BANNER7_FORMS_10G.SAAAUDF Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_SABAUDF INDEX S4B70.SATURN Rely on ()
STVTERM TABLE S4B70.SATURN Refer( No Action )

Comments

Source Code Comments

Application User Defined Fields Table

Columns Comments for SABAUDF_TERM_CODE_EFF (1)

Source Code Comments

This is the effective term.

Columns Comments for SABAUDF_ACTIVITY_DATE (32)

Source Code Comments

This field identifies the most recent date a record was created or updated.

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 SGBEOPS

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SGBEOPS_PIDM SGBEOPS_PIDM NUMBER(8,0) No *
SGBEOPS_TERM_CODE_EFF SGBEOPS_TERM_CODE_EFF VARCHAR2(6) No * *
SGBEOPS_EOPS_CODE SGBEOPS_EOPS_CODE VARCHAR2(2) Yes *
SGBEOPS_ACCEPT_DATE SGBEOPS_ACCEPT_DATE DATE Yes
SGBEOPS_SFAE_CODE SGBEOPS_SFAE_CODE VARCHAR2(2) Yes *
SGBEOPS_ACTIVITY_DATE SGBEOPS_ACTIVITY_DATE DATE No
SGBEOPS_TRAC_CODE SGBEOPS_TRAC_CODE VARCHAR2(3) Yes
SGBEOPS_PLANNED_CREDITS SGBEOPS_PLANNED_CREDITS NUMBER(9,3) Yes
SGBEOPS_WTHD_CODE SGBEOPS_WTHD_CODE VARCHAR2(1) Yes *

Foreign Key information

Column name is Foreign Key For Column on Table
SGBEOPS_TERM_CODE_EFF STVTERM_CODE STVTERM
SGBEOPS_EOPS_CODE STVEOPS_CODE STVEOPS
SGBEOPS_SFAE_CODE STVSFAE_CODE STVSFAE
SGBEOPS_WTHD_CODE STVWTHD_CODE STVWTHD

Index

Index Name Index Type Column Name
PK_SGBEOPS Unique SGBEOPS_PIDM
PK_SGBEOPS Unique SGBEOPS_TERM_CODE_EFF

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
MAA3 Cobol Paragraph [F:\banner\cobol].SERSBREC.MAA-MAINLINE-SECT Use(select )
MAA3 Cobol Paragraph [F:\banner\cobol].SERSEREC.MAA-MAINLINE-SECT Use(select )
END_EOPS_TERM Forms Trigger BANNER7_FORMS_10G.SGAEOPS.SGBEOPS Use(insert )
END_EOPS_TERM Forms Trigger BANNER7_FORMS.SGAEOPS.SGBEOPS Use(insert )
INSERT_TRIG Forms Trigger BANNER7_FORMS_10G.SGAEOPS.SGBEOPS Use(insert,select )
INSERT_TRIG Forms Trigger BANNER7_FORMS.SGAEOPS.SGBEOPS Use(insert,select )
PRE-INSERT Forms Trigger BANNER7_FORMS_10G.SGAEOPS.SGBEOPS Use(delete )
PRE-INSERT Forms Trigger BANNER7_FORMS.SGAEOPS.SGBEOPS Use(delete )
PRE-QUERY Forms Trigger BANNER7_FORMS_10G.SGAEOPS.SGBEOPS Use(select )
PRE-QUERY Forms Trigger BANNER7_FORMS.SGAEOPS.SGBEOPS Use(select )
SGBEOPS SYNONYM S4B70.PUBLIC Rely on ()
SGBEOPS Forms DataBlock BANNER7_FORMS_10G.SGAEOPS Rely on () Use(insert,update,delete,select )
SGBEOPS Forms DataBlock BANNER7_FORMS.SGAEOPS Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_SGBEOPS INDEX S4B70.SATURN Rely on ()
STVEOPS TABLE S4B70.SATURN Refer( No Action )
STVSFAE TABLE S4B70.SATURN Refer( No Action )
STVTERM TABLE S4B70.SATURN Refer( No Action )
STVWTHD TABLE S4B70.SATURN Refer( No Action )

Comments

Source Code Comments

Education Opportunity Programs and Services Base Table

Columns Comments for SGBEOPS_PIDM (1)

Source Code Comments

The Pidm of the student

Columns Comments for SGBEOPS_TERM_CODE_EFF (2)

Source Code Comments

The Effective Term

Columns Comments for SGBEOPS_EOPS_CODE (3)

Source Code Comments

Education Opportunity Programs and Services Code

Columns Comments for SGBEOPS_ACCEPT_DATE (4)

Source Code Comments

The date the student was accepted into the EOPS program

Columns Comments for SGBEOPS_SFAE_CODE (5)

Source Code Comments

Represents the method which was used to determine that the student was eligible for the EOPS program

Columns Comments for SGBEOPS_ACTIVITY_DATE (6)

Source Code Comments

The Activity Date

Columns Comments for SGBEOPS_TRAC_CODE (7)

Source Code Comments

EOPS Acceptance Period Code

Columns Comments for SGBEOPS_PLANNED_CREDITS (8)

Source Code Comments

EOPS Number of units the student plans to enroll in for the reporting term.

Columns Comments for SGBEOPS_WTHD_CODE (9)

Source Code Comments

Withdrawal Reason.

Table SGBOEDU

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SGBOEDU_PIDM SGBOEDU_PIDM NUMBER(8,0) No
SGBOEDU_TERM_CODE_EFF SGBOEDU_TERM_CODE_EFF VARCHAR2(6) No *
SGBOEDU_EOPS_CODE SGBOEDU_EOPS_CODE VARCHAR2(2) Yes *
SGBOEDU_SFAE_CODE SGBOEDU_SFAE_CODE VARCHAR2(2) Yes *
SGBOEDU_ACCEPT_DATE SGBOEDU_ACCEPT_DATE DATE Yes
SGBOEDU_TRAC_CODE SGBOEDU_TRAC_CODE VARCHAR2(3) Yes
SGBOEDU_PLANNED_CREDITS SGBOEDU_PLANNED_CREDITS NUMBER(9,3) Yes
SGBOEDU_ACTIVITY_DATE SGBOEDU_ACTIVITY_DATE DATE No
SGBOEDU_MARS_CODE SGBOEDU_MARS_CODE VARCHAR2(1) Yes *
SGBOEDU_DEPS_CODE SGBOEDU_DEPS_CODE VARCHAR2(1) Yes *
SGBOEDU_AFDC_CODE SGBOEDU_AFDC_CODE VARCHAR2(1) Yes *
SGBOEDU_WTHD_CODE SGBOEDU_WTHD_CODE VARCHAR2(1) Yes *

Foreign Key information

Column name is Foreign Key For Column on Table
SGBOEDU_TERM_CODE_EFF STVTERM_CODE STVTERM
SGBOEDU_EOPS_CODE STVEOPS_CODE STVEOPS
SGBOEDU_SFAE_CODE STVSFAE_CODE STVSFAE
SGBOEDU_AFDC_CODE STVAFDC_CODE STVAFDC
SGBOEDU_MARS_CODE STVMARS_CODE STVMARS
SGBOEDU_DEPS_CODE STVDEPS_CODE STVDEPS
SGBOEDU_WTHD_CODE STVWTHD_CODE STVWTHD

Index

Index Name Index Type Column Name
SGBOEDU_KEY_INDEX Unique SGBOEDU_PIDM
SGBOEDU_KEY_INDEX Unique SGBOEDU_TERM_CODE_EFF
SGBOEDU_KEY_INDEX Unique SGBOEDU_EOPS_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
MAA6 Cobol Paragraph [F:\banner\cobol].SERSEREC.MAA-MAINLINE-SECT Use(select )
END_OEDU_TERM Forms Trigger BANNER7_FORMS_10G.SGAEOPS.SGBOEDU Use(insert )
END_OEDU_TERM Forms Trigger BANNER7_FORMS.SGAEOPS.SGBOEDU Use(insert )
INSERT_TRIG Forms Trigger BANNER7_FORMS_10G.SGAEOPS.SGBOEDU Use(insert,select )
INSERT_TRIG Forms Trigger BANNER7_FORMS.SGAEOPS.SGBOEDU Use(insert,select )
PRE-INSERT Forms Trigger BANNER7_FORMS_10G.SGAEOPS.SGBOEDU Use(delete )
PRE-INSERT Forms Trigger BANNER7_FORMS.SGAEOPS.SGBOEDU Use(delete )
PRE-QUERY Forms Trigger BANNER7_FORMS_10G.SGAEOPS.SGBOEDU Use(select )
PRE-QUERY Forms Trigger BANNER7_FORMS.SGAEOPS.SGBOEDU Use(select )
SGBOEDU SYNONYM S4B70.PUBLIC Rely on ()
SGBOEDU Forms DataBlock BANNER7_FORMS_10G.SGAEOPS Rely on () Use(insert,update,delete,select )
SGBOEDU Forms DataBlock BANNER7_FORMS.SGAEOPS Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
SGBOEDU_KEY_INDEX INDEX S4B70.SATURN Rely on ()
STVAFDC TABLE S4B70.SATURN Refer( No Action )
STVDEPS TABLE S4B70.SATURN Refer( No Action )
STVEOPS TABLE S4B70.SATURN Refer( No Action )
STVMARS TABLE S4B70.SATURN Refer( No Action )
STVSFAE TABLE S4B70.SATURN Refer( No Action )
STVTERM TABLE S4B70.SATURN Refer( No Action )
STVWTHD TABLE S4B70.SATURN Refer( No Action )

Comments

Source Code Comments

Student Other Educational Programs Table

Columns Comments for SGBOEDU_PIDM (1)

Source Code Comments

Person Internal Identification Number

Columns Comments for SGBOEDU_TERM_CODE_EFF (2)

Source Code Comments

Effective Term Code

Columns Comments for SGBOEDU_EOPS_CODE (3)

Source Code Comments

Educational Opportunity Program Code

Columns Comments for SGBOEDU_SFAE_CODE (4)

Source Code Comments

State Financial Aid Eligibility Code

Columns Comments for SGBOEDU_ACCEPT_DATE (5)

Source Code Comments

Acceptance Date

Columns Comments for SGBOEDU_TRAC_CODE (6)

Source Code Comments

Period of Acceptance Code.

Columns Comments for SGBOEDU_PLANNED_CREDITS (7)

Source Code Comments

Number of units the student plans to enroll in for the reporting term.

Columns Comments for SGBOEDU_ACTIVITY_DATE (8)

Source Code Comments

The Activity Date

Columns Comments for SGBOEDU_MARS_CODE (9)

Source Code Comments

CARE Student Marital Status.

Columns Comments for SGBOEDU_DEPS_CODE (10)

Source Code Comments

CARE Student Number of Dependents.

Columns Comments for SGBOEDU_AFDC_CODE (11)

Source Code Comments

CARE Student Time on AFDC.

Columns Comments for SGBOEDU_WTHD_CODE (12)

Source Code Comments

CARE Withdrawal Reason.

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 STVMAJR_CODE STVMAJR
SGBSTDN_MAJR_CODE_DUAL STVMAJR_CODE STVMAJR
SGBSTDN_MAJR_CODE_CONC_121 STVMAJR_CODE STVMAJR
SGBSTDN_MAJR_CODE_CONC_122 STVMAJR_CODE STVMAJR
SGBSTDN_MAJR_CODE_CONC_123 STVMAJR_CODE STVMAJR
SGBSTDN_MAJR_CODE_CONC_221 STVMAJR_CODE STVMAJR
SGBSTDN_CURR_RULE_1 SOBCURR_CURR_RULE SOBCURR
SGBSTDN_CCON_RULE_11_1 SORCCON_CCON_RULE SORCCON
SGBSTDN_ACYR_CODE STVACYR_CODE STVACYR
SGBSTDN_ADMT_CODE STVADMT_CODE STVADMT
SGBSTDN_ASTD_CODE STVASTD_CODE STVASTD
SGBSTDN_COLL_CODE_1 STVCOLL_CODE STVCOLL
SGBSTDN_DEGC_CODE_1 STVDEGC_CODE STVDEGC
SGBSTDN_EGOL_CODE STVEGOL_CODE STVEGOL
SGBSTDN_EMEX_CODE STVEMEX_CODE STVEMEX
SGBSTDN_GAIN_CODE STVGAIN_CODE STVGAIN
SGBSTDN_MAJR_CODE_1_2 STVMAJR_CODE STVMAJR
SGBSTDN_RATE_CODE STVRATE_CODE STVRATE
SGBSTDN_RESD_CODE STVRESD_CODE STVRESD
SGBSTDN_SESS_CODE STVSESS_CODE STVSESS
SGBSTDN_STST_CODE STVSTST_CODE STVSTST
SGBSTDN_STYP_CODE STVSTYP_CODE STVSTYP
SGBSTDN_TRCN_CODE STVTRCN_CODE STVTRCN
SGBSTDN_MAJR_CODE_CONC_222 STVMAJR_CODE STVMAJR
SGBSTDN_MAJR_CODE_CONC_223 STVMAJR_CODE STVMAJR
SGBSTDN_CURR_RULE_2 SOBCURR_CURR_RULE SOBCURR
SGBSTDN_CCON_RULE_11_2 SORCCON_CCON_RULE SORCCON
SGBSTDN_ADMT_CODE_2 STVADMT_CODE STVADMT
SGBSTDN_COLL_CODE_2 STVCOLL_CODE STVCOLL
SGBSTDN_DEGC_CODE_2 STVDEGC_CODE STVDEGC
SGBSTDN_MAJR_CODE_2_2 STVMAJR_CODE STVMAJR
SGBSTDN_CCON_RULE_11_3 SORCCON_CCON_RULE SORCCON
SGBSTDN_COLL_CODE_DUAL STVCOLL_CODE STVCOLL
SGBSTDN_DEGC_CODE_DUAL STVDEGC_CODE STVDEGC
SGBSTDN_MAJR_CODE_1 STVMAJR_CODE STVMAJR
SGBSTDN_CCON_RULE_12_1 SORCCON_CCON_RULE SORCCON
SGBSTDN_MAJR_CODE_MINR_1 STVMAJR_CODE STVMAJR
SGBSTDN_CCON_RULE_12_2 SORCCON_CCON_RULE SORCCON
SGBSTDN_MAJR_CODE_MINR_1_2 STVMAJR_CODE STVMAJR
SGBSTDN_CCON_RULE_12_3 SORCCON_CCON_RULE SORCCON
SGBSTDN_MAJR_CODE_CONC_1 STVMAJR_CODE STVMAJR
SGBSTDN_CCON_RULE_21_1 SORCCON_CCON_RULE SORCCON
SGBSTDN_MAJR_CODE_CONC_1_2 STVMAJR_CODE STVMAJR
SGBSTDN_CCON_RULE_21_2 SORCCON_CCON_RULE SORCCON
SGBSTDN_MAJR_CODE_CONC_1_3 STVMAJR_CODE STVMAJR
SGBSTDN_CCON_RULE_21_3 SORCCON_CCON_RULE SORCCON
SGBSTDN_MAJR_CODE_2 STVMAJR_CODE STVMAJR
SGBSTDN_DEPT_CODE_2_2 STVDEPT_CODE STVDEPT
SGBSTDN_DEPT_CODE_1_2 STVDEPT_CODE STVDEPT
SGBSTDN_DEPT_CODE STVDEPT_CODE STVDEPT
SGBSTDN_DEPT_CODE_2 STVDEPT_CODE STVDEPT
SGBSTDN_DEPT_CODE_DUAL STVDEPT_CODE STVDEPT
SGBSTDN_ORSN_CODE STVORSN_CODE STVORSN
SGBSTDN_LEAV_CODE STVLEAV_CODE STVLEAV
SGBSTDN_BSKL_CODE STVBSKL_CODE STVBSKL
SGBSTDN_PRAC_CODE STVPRAC_CODE STVPRAC
SGBSTDN_PREV_CODE STVPREV_CODE STVPREV
SGBSTDN_SITE_CODE STVSITE_CODE STVSITE
SGBSTDN_PIDM SHRLGPA_PIDM SHRLGPA
SGBSTDN_PIDM SHRTTRM_PIDM SHRTTRM

Index

Index Name Index Type Column Name
PK_SGBSTDN Unique SGBSTDN_PIDM
PK_SGBSTDN Unique SGBSTDN_TERM_CODE_EFF

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
rorfs04.pc C/C++ File N/A Use(select )
sfrrgam.pc C/C++ File N/A Use(select )
smrbcmp.pc C/C++ File N/A Use(select )
main C/C++ Function [F:\BANNER\C\SAPADMS.PC] Use()
main C/C++ Function [F:\BANNER\C\SHRGRDE.PC] Use()
sel_from_ban_cnt_in_interface C/C++ Function [F:\BANNER\C\SLRBACS.PC] Use(select )
sel_grad_etrm C/C++ Function [F:\BANNER\C\TSP1098.PC] Use(select )
sel_grad_hist C/C++ Function [F:\BANNER\C\TSP1098.PC] Use(select )
select_current_major C/C++ Function [F:\BANNER\C\SHREDIY.PC] Use(select )
select_residency_status C/C++ Function [F:\BANNER\C\SHREDIY.PC] Use(select )
BAA4 Cobol Paragraph [F:\banner\cobol].SCTH1000.AAA Use(select )
MAA3 Cobol Paragraph [F:\banner\cobol].SERSBREC.MAA-MAINLINE-SECT Use(select )
MAA3 Cobol Paragraph [F:\banner\cobol].SERSDREC.MAA-MAINLINE-SECT Use(select )
MAA3 Cobol Paragraph [F:\banner\cobol].SERSEREC.MAA-MAINLINE-SECT Use(select )
MAA3 Cobol Paragraph [F:\banner\cobol].SERSMREC.MAA-MAINLINE-SECT Use(select )
MAA3 Cobol Paragraph [F:\banner\cobol].SERSAREC.MAA-MAINLINE-SECT Use(select )
SCA2 Cobol Paragraph [F:\banner\cobol].SADA3202.SCA2-SECT Use(select )
SCA2 Cobol Paragraph [F:\banner\cobol].SADA3204.SCA2-SECT Use(select )
SCA2 Cobol Paragraph [F:\banner\cobol].SADA3206.SCA2-SECT Use(select )
SCA2 Cobol Paragraph [F:\banner\cobol].SADA3205.SCA2-SECT Use(select )
SCA2 Cobol Paragraph [F:\banner\cobol].SADA3203.SCA2-SECT Use(select )
UCL-GET-LOAD-FROM-HOURS Cobol Paragraph [F:\banner\cobol].RPEDISB.UCL-CALCULATE-LOAD Use(select )
UCL-GET-LOAD-FROM-HOURS Cobol Paragraph [F:\banner\cobol].RPOVLDT.UCL-CALCULATE-LOAD Use(select )
UCL-GET-LOAD-FROM-HOURS Cobol Paragraph [F:\banner\cobol].RPEPCKG.UCL-CALCULATE-LOAD Use(select )
UCL-GET-LOAD-FROM-HOURS Cobol Paragraph [F:\banner\cobol].RPEPELL.UCL-CALCULATE-LOAD Use(select )
UCL-GET-LOAD-FROM-HOURS Cobol Paragraph [F:\banner\cobol].RPBVLDT.UCL-CALCULATE-LOAD Use(select )
UCL-GET-LOAD-FROM-HOURS Cobol Paragraph [F:\banner\cobol].RPEPINT.UCL-CALCULATE-LOAD Use(select )
UVD3 Cobol Paragraph [F:\banner\cobol].RPBVLDT.UVD-VALIDATE-DISBURSEMENTS Use(select )
UVD3 Cobol Paragraph [F:\banner\cobol].RPEDISB.UVD-VALIDATE-DISBURSEMENTS Use(select )
checkreadm C/C++ Function [F:\BANNER\C\SFPCREQ.PC] Use(select )
checkstatus C/C++ Function [F:\BANNER\C\SFPCREQ.PC] Use(select )
chk_enrl_hrs C/C++ Function [F:\BANNER\C\RRREXIT.PC] Use(select )
chk_for_rorcamp_school_code C/C++ Function [F:\BANNER\C\RPRELAP.PC] Use(select )
chk_school_code C/C++ Function [F:\BANNER\C\RPRHDRL.PC] Use(select )
chkcollege C/C++ Function [F:\BANNER\C\SHRTPOP.PC] Use(select )
chkmajor C/C++ Function [F:\BANNER\C\SHRTPOP.PC] Use(select )
det_stdn_delete C/C++ Function [F:\BANNER\C\SAPADMS.PC] Use(select )
find_candidate C/C++ Function [F:\BANNER\C\RRREXIT.PC] Use(select )
find_eff_term C/C++ Function [F:\BANNER\C\SHRDEGS.PC] Use(select )
findefft C/C++ Function [F:\BANNER\C\SHRTYPE.PC] Use(select )
findterm C/C++ Function [F:\BANNER\C\SHRTPOP.PC] Use(select )
get_btch_iden_by_id C/C++ Function [F:\BANNER\C\SFRFASC.PC] Use(select )
get_btch_iden_by_name C/C++ Function [F:\BANNER\C\SFRFASC.PC] Use(select )
get_ests_iden_by_id C/C++ Function [F:\BANNER\C\SFRFASC.PC] Use(select )
get_ests_iden_by_name C/C++ Function [F:\BANNER\C\SFRFASC.PC] Use(select )
get_expected_grad_date C/C++ Function [F:\BANNER\C\RPRELAP.PC] Use(select )
get_expected_grad_date C/C++ Function [F:\BANNER\C\RPRLORC.PC] Use(select )
get_header_info C/C++ Function [F:\BANNER\C\SMRCRLT.PC] Use(select )
get_header_info2 C/C++ Function [F:\BANNER\C\SMRCRLT.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 )
get_levl_code C/C++ Function [F:\BANNER\C\RPRELAP.PC] Use(select )
get_majors C/C++ Function [F:\BANNER\C\ICGORLDI.PC] Use(select )
get_new_students C/C++ Function [F:\BANNER\C\SFRSSCR.PC] Use(select )
get_rorcamp_school_cde C/C++ Function [F:\BANNER\C\RPRELAX.PC] Use(select )
get_section5 C/C++ Function [F:\BANNER\C\SHRIGRS.PC] Use(select )
get_status C/C++ Function [F:\BANNER\C\SGRKNOW.PC] Use(select )
get_stdn C/C++ Function [F:\BANNER\C\SFRSSCR.PC] Use(select )
get_stdn_data C/C++ Function [F:\BANNER\C\SERPSRC.PC] Use(select )
get_student C/C++ Function [F:\BANNER\C\SFPBLCK.PC] Use(select )
get_student C/C++ Function [F:\BANNER\C\SGPBLCK.PC] Use(select )
get_student C/C++ Function [F:\BANNER\C\SGRCHRT.PC] Use(select )
get_student_info C/C++ Function [F:\BANNER\C\IRRKAWD.PC] Use(select )
get_student_info C/C++ Function [F:\BANNER\C\ISRKGRD.PC] Use(select )
getdata C/C++ Function [F:\BANNER\C\SFRTMST.PC] Use(select )
print_summary C/C++ Function [F:\BANNER\C\SHRIGRS.PC] Use(select )
read_block_parms C/C++ Function [F:\BANNER\C\SFPBLCK.PC] Use(select )
sb_chk_pidm_campus C/C++ Function [F:\BANNER\C\TSRCBIL.PC] Use(select )
sb_get_collector_pidms C/C++ Function [F:\BANNER\C\TSRCBIL.PC] Use(select )
sb_get_etrm_pidms C/C++ Function [F:\BANNER\C\TSRCBIL.PC] Use(select )
sb_get_pop_pidms C/C++ Function [F:\BANNER\C\TSRCBIL.PC] Use(select )
selThisTermId C/C++ Function [F:\BANNER\C\RPRTIVC.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\RERPL04.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\RERPL03.PC] Use(select )
sel_fa_term_count C/C++ Function [F:\BANNER\C\RERPL02.PC] Use(select )
sel_grad_date_fha C/C++ Function [F:\BANNER\C\SFRNSLC.PC] Use(select )
sel_level C/C++ Function [F:\BANNER\C\SFRNSLC.PC] Use(select )
sel_sgbstdn C/C++ Function [F:\BANNER\C\SFRWDRL.PC] Use(select )
sel_spriden C/C++ Function [F:\BANNER\C\RORREGS.PC] Use(select )
sel_spriden C/C++ Function [F:\BANNER\C\RORGRDE.PC] Use(select )
sel_status C/C++ Function [F:\BANNER\C\SFRNSLC.PC] Use(select )
sel_updstdn C/C++ Function [F:\BANNER\C\SARBDSN.PC] Use(select )
selacyr C/C++ Function [F:\BANNER\C\SFRENRL.PC] Use(select )
selchld C/C++ Function [F:\BANNER\C\APPCLST.PC] Use(select )
selcont C/C++ Function [F:\BANNER\C\SAPADMS.PC] Use(select )
selcont C/C++ Function [F:\BANNER\C\SRRINQR.PC] Use(select )
selcont_stdn C/C++ Function [F:\BANNER\C\SGPSTDN.PC] Use(select )
selcurr C/C++ Function [F:\BANNER\C\APPSTDI.PC] Use(select )
selcurr C/C++ Function [F:\BANNER\C\SFRENRL.PC] Use(select )
selcurr2 C/C++ Function [F:\BANNER\C\SFRENRL.PC] Use(select )
seldel C/C++ Function [F:\BANNER\C\SGPSTDN.PC] Use(select )
select_enrollments C/C++ Function [F:\BANNER\C\RPBLMIE.PC] Use(select )
select_from_sgbstdn C/C++ Function [F:\BANNER\C\RPBLMID.PC] Use(select )
select_grad_data C/C++ Function [F:\BANNER\C\RPBLMIE.PC] Use(select )
selmacro C/C++ Function [F:\BANNER\C\SFPFREQ.PC] Use(select )
selmacro C/C++ Function [F:\BANNER\C\SERSVRC.PC] Use(select )
selmacro C/C++ Function [F:\BANNER\C\SHRTYPE.PC] Use(select )
selmacro C/C++ Function [F:\BANNER\C\SHRTPOP.PC] Use(select )
selmacro C/C++ Function [F:\BANNER\C\SERPSRC.PC] Use(select )
selmacro C/C++ Function [F:\BANNER\C\SHRASTD.PC] Use(select )
selmacro C/C++ Function [F:\BANNER\C\SHRCIPC.PC] Use(select )
selmacro C/C++ Function [F:\BANNER\C\SHRIPDS.PC] Use(select )
selmacro2 C/C++ Function [F:\BANNER\C\SFRSLST.PC] Use(select )
selmacro2 C/C++ Function [F:\BANNER\C\SHRTPOP.PC] Use(select )
selmacro2 C/C++ Function [F:\BANNER\C\SHRIACT.PC] Use(select )
selmacro2d C/C++ Function [F:\BANNER\C\SFRSLST.PC] Use(select )
selmacro2dx C/C++ Function [F:\BANNER\C\SFRSLST.PC] Use(select )
selmacro2x C/C++ Function [F:\BANNER\C\SFRSLST.PC] Use(select )
selmacro6 C/C++ Function [F:\BANNER\C\SHRIACT.PC] Use(select )
selmacro_nopop_level_id C/C++ Function [F:\BANNER\C\SFRWDRL.PC] Use(select )
selmacro_nopop_level_id_tiv C/C++ Function [F:\BANNER\C\SFRWDRL.PC] Use(select )
selmacro_nopop_level_name C/C++ Function [F:\BANNER\C\SFRWDRL.PC] Use(select )
selmacro_nopop_level_name_tiv C/C++ Function [F:\BANNER\C\SFRWDRL.PC] Use(select )
selmacro_pop_level_id C/C++ Function [F:\BANNER\C\SFRWDRL.PC] Use(select )
selmacro_pop_level_id_tiv C/C++ Function [F:\BANNER\C\SFRWDRL.PC] Use(select )
selmacro_pop_level_name C/C++ Function [F:\BANNER\C\SFRWDRL.PC] Use(select )
selmacro_pop_level_name_tiv C/C++ Function [F:\BANNER\C\SFRWDRL.PC] Use(select )
selmass C/C++ Function [F:\BANNER\C\SGRVETN.PC] Use(select )
selnon_curr C/C++ Function [F:\BANNER\C\APPSTDI.PC] Use(select )
selstdn C/C++ Function [F:\BANNER\C\ISRKTRN.PC] Use(select )
selstdn C/C++ Function [F:\BANNER\C\SORHSRP.PC] Use(select )
selstdn C/C++ Function [F:\BANNER\C\SRRENRH.PC] Use(select )
selstdn C/C++ Function [F:\BANNER\C\SRRENRL.PC] Use(select )
selstdn C/C++ Function [F:\BANNER\C\SPRPDIR.PC] Use(select )
selstdn C/C++ Function [F:\BANNER\C\SFRENRL.PC] Use(select )
selstdn C/C++ Function [F:\BANNER\C\SARBDSN.PC] Use(select )
selstdn1 C/C++ Function [F:\BANNER\C\SGPSTDN.PC] Use(select )
selstdn2 C/C++ Function [F:\BANNER\C\ISRKTRN.PC] Use(select )
selstdn3 C/C++ Function [F:\BANNER\C\ISRKTRN.PC] Use(select )
selstdn_admit_term C/C++ Function [F:\BANNER\C\SHRTRTC.PC] Use(select )
selstdn_bylevel C/C++ Function [F:\BANNER\C\SHRTRTC.PC] Use(select )
selstdn_byterm C/C++ Function [F:\BANNER\C\SHRTRTC.PC] Use(select )
selstdn_i C/C++ Function [F:\BANNER\C\SGRSTDN.PC] Use(select )
selstdn_i_nopop C/C++ Function [F:\BANNER\C\SGRSTDN.PC] Use(select )
selstdn_n C/C++ Function [F:\BANNER\C\SGRSTDN.PC] Use(select )
selstdn_n_nopop C/C++ Function [F:\BANNER\C\SGRSTDN.PC] Use(select )
selstdn_nopop C/C++ Function [F:\BANNER\C\SPRPDIR.PC] Use(select )
seltgpa2 C/C++ Function [F:\BANNER\C\SFRENRL.PC] Use(select )
sport_report C/C++ Function [F:\BANNER\C\SHRIGRS.PC] Use(select )
student_curr C/C++ Function [F:\BANNER\C\SORCPLN.PC] Use(select )
writeUser C/C++ Function [F:\BANNER\C\ICSORIMS.PC] Use(select )
write_major C/C++ Function [F:\BANNER\C\ICSORSPF.PC] Use(select )
write_user C/C++ Function [F:\BANNER\C\ICSORSPF.PC] Use(select )
sel1_part2 C/C++ Global Variable [F:\BANNER\C\SHRTRTC.PC] Use()
sel2_part2 C/C++ Global Variable [F:\BANNER\C\SHRTRTC.PC] Use()
sgbstdn_msg C/C++ Global Variable [F:\BANNER\C\SFRFASC.PC] Use()
ROBXREC Cobol Program F:\banner\cobol Use()
ST_SGBSTDN_AR_LDI TRIGGER S4B70.SATURN Rely on ()
RORCRHR TABLE S4B70.FAISMGR Join
RPRCLVL TABLE S4B70.FAISMGR Join
SFRMHRS TABLE S4B70.SATURN Join
SPBPERS TABLE S4B70.SATURN Join
SPRIDEN TABLE S4B70.SATURN Join
AS_ACADEMIC_STUDY VIEW S4B70.BANINST1 Use(select )
AS_ENROLLMENT VIEW S4B70.BANINST1 Use(select )
AS_STUDENT VIEW S4B70.BANINST1 Use(select )
RCVAPL2 VIEW S4B70.BANINST1 Use(select )
ROVST00 VIEW S4B70.BANINST1 Use(select )
ROVST01 VIEW S4B70.BANINST1 Use(select )
ROVST02 VIEW S4B70.BANINST1 Use(select )
ROVST03 VIEW S4B70.BANINST1 Use(select )
ROVST04 VIEW S4B70.BANINST1 Use(select )
ROVST05 VIEW S4B70.BANINST1 Use(select )
ROVST06 VIEW S4B70.BANINST1 Use(select )
ROVSTDD VIEW S4B70.BANINST1 Use(select )
ROVSTDN VIEW S4B70.BANINST1 Use(select )
ROVSTU2 VIEW S4B70.BANINST1 Use(select )
RPVAWT2 VIEW S4B70.BANINST1 Use(select )
RPVAWY2 VIEW S4B70.BANINST1 Use(select )
SFVETR2 VIEW S4B70.BANINST1 Use(select )
SFVSTC2 VIEW S4B70.BANINST1 Use(select )
SFVSTDN VIEW S4B70.BANINST1 Use(select )
SFVTFAN VIEW S4B70.BANINST1 Use(select )
SGVCLAS VIEW S4B70.BANINST1 Use(select )
SGVCLSR VIEW S4B70.BANINST1 Use(select )
SGVLEAV VIEW S4B70.BANINST1 Use(select )
SGVSTD2 VIEW S4B70.BANINST1 Use(select )
SGVSTDN VIEW S4B70.BANINST1 Use(select )
SGVSTNE VIEW S4B70.BANINST1 Use(select )
SHVACST VIEW S4B70.BANINST1 Use(select )
SHVDEAN VIEW S4B70.BANINST1 Use(select )
SHVIPED VIEW S4B70.BANINST1 Use(select )
SHVTER1 VIEW S4B70.BANINST1 Use(select )
SHVYEA1 VIEW S4B70.BANINST1 Use(select )
SLVRES2 VIEW S4B70.BANINST1 Use(select )
SLVRSM2 VIEW S4B70.BANINST1 Use(select )
SOVCLAS VIEW S4B70.BANINST1 Use(select )
SOVCTA2 VIEW S4B70.BANINST1 Use(select )
SOVSREC VIEW S4B70.BANINST1 Use(select )
SOVSTDN VIEW S4B70.BANINST1 Use(select )
SPVTER1 VIEW S4B70.BANINST1 Use(select )
SPVYEA1 VIEW S4B70.BANINST1 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SHATCKC.SHRTCKL.SHRTCKL_LEVL_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SGASTDN.SGRSACT.SGRSACT_TERM_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SGASTDN.SGBSTDN.SGBSTDN_STST_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SGASTDN.SGBSTDN.SGBSTDN_SITE_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SGASTDN.SGBSTDN.SGBSTDN_TERM_CODE_EFF Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SGASTDN.SGBSTDN.SGBSTDN_RESD_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SHATCKS.SHRTCKL.SHRTCKL_LEVL_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SHATCKP.SHRTCKL.SHRTCKL_LEVL_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SHATCKC.SHRTCKL.SHRTCKL_LEVL_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SGASTDN.SGBSTDN.SGBSTDN_STYP_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SGASTDN.SGBSTDN.SGBSTDN_RESD_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SGASTDN.SGBSTDN.SGBSTDN_RATE_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SGASTDN.SGRSACT.SGRSACT_TERM_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SHATCKS.SHRTCKL.SHRTCKL_LEVL_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SHATCKP.SHRTCKL.SHRTCKL_LEVL_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SHATCKN.SHRTCKL.SHRTCKL_LEVL_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SGASTDN.SGBSTDN.SGBSTDN_STST_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SGASTDN.SGBSTDN.SGBSTDN_TERM_CODE_EFF Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS.SMARQCM.SMRRQCM.SMRRQCM_DEPT_CODE_1_2 Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS_10G.SMARQCM.SMRRQCM.SMRRQCM_DEPT_CODE_1_2 Use(select )
CHECK_DELETE_BASE Forms Trigger BANNER7_FORMS.SOACURR Use(select )
CHECK_DELETE_BASE Forms Trigger BANNER7_FORMS_10G.SOACURR Use(select )
CHECK_FOR_GENL_STUDENT Forms Trigger BANNER7_FORMS.SHAINST Use(select )
CHECK_FOR_GENL_STUDENT Forms Trigger BANNER7_FORMS_10G.SGAUSDF Use(select )
CHECK_FOR_GENL_STUDENT Forms Trigger BANNER7_FORMS_10G.SHAINST Use(select )
CHECK_FOR_GENL_STUDENT Forms Trigger BANNER7_FORMS.SGAUSDF Use(select )
CHECK_FOR_NEW_SGBSTDN Forms Trigger BANNER7_FORMS_10G.SFAREGS Use(select )
CHECK_GENL_STUDENT Forms Trigger BANNER7_FORMS.SHARQTC Use(select )
CHECK_GENL_STUDENT Forms Trigger BANNER7_FORMS_10G.SHARQTC Use(select )
CHECK_ID Forms Trigger BANNER7_FORMS.SMARQCM Use(select )
CHECK_ID Forms Trigger BANNER7_FORMS_10G.SMARQCM Use(select )
CHECK_SGBSTDN_OTHERS Forms Trigger BANNER7_FORMS_10G.SAAQUIK Use(select )
CHECK_SGBSTDN_OTHERS Forms Trigger BANNER7_FORMS.SAAQUIK Use(select )
CHECK_SGBSTDN_TERM Forms Trigger BANNER7_FORMS_10G.SAAQUIK Use(select )
CHECK_SGBSTDN_TERM Forms Trigger BANNER7_FORMS.SAAQUIK Use(select )
CHECK_STUDENT Forms Trigger BANNER7_FORMS.SFASRPO Use(select )
CHECK_STUDENT Forms Trigger BANNER7_FORMS.SGADISA Use(select )
CHECK_STUDENT Forms Trigger BANNER7_FORMS_10G.SFARGRP Use(select )
CHECK_STUDENT Forms Trigger BANNER7_FORMS.SGASPRT Use(select )
CHECK_STUDENT Forms Trigger BANNER7_FORMS.SFARGRP Use(select )
CHECK_STUDENT Forms Trigger BANNER7_FORMS_10G.SFASRPO Use(select )
CHECK_STUDENT Forms Trigger BANNER7_FORMS_10G.SGADISA Use(select )
CHECK_STUDENT Forms Trigger BANNER7_FORMS_10G.SGASPRT Use(select )
CURR_STAT Forms Trigger BANNER7_FORMS_10G.RSIHIST Use(select )
CURR_STAT Forms Trigger BANNER7_FORMS.RSIHIST Use(select )
DISPLAY_INDICATORS Forms Trigger BANNER7_FORMS.SRAQUIK Use(select )
DISPLAY_INDICATORS Forms Trigger BANNER7_FORMS_10G.SRAQUIK Use(select )
GET_ACAD_STAND Forms Trigger BANNER7_FORMS.SHATERM Use(select )
GET_ACAD_STAND Forms Trigger BANNER7_FORMS.SHATRMC Use(select )
GET_ACAD_STAND Forms Trigger BANNER7_FORMS_10G.SHATRMC Use(select )
GET_ACAD_STAND Forms Trigger BANNER7_FORMS_10G.SHATERM Use(select )
GET_MHRS Forms Trigger BANNER7_FORMS.SFAREGS Use(select )
GET_MHRS Forms Trigger BANNER7_FORMS_10G.SFAREGS Use(select )
GET_OVERALL_INFO Forms Trigger BANNER7_FORMS.SHASUBJ Use(select )
GET_OVERALL_INFO Forms Trigger BANNER7_FORMS_10G.SHASUBJ Use(select )
MENU_TRIGGER3 Forms Trigger BANNER7_FORMS.SHAINST Use(select )
MENU_TRIGGER3 Forms Trigger BANNER7_FORMS_10G.SHAINST Use(select )
SET_SGASTDQ Forms Trigger BANNER7_FORMS.SMARQCM Use(select )
SET_SGASTDQ Forms Trigger BANNER7_FORMS_10G.SMARQCM Use(select )
UPDATE_STUDENT Forms Trigger BANNER7_FORMS_10G.SAADCRV Use(select )
UPDATE_STUDENT Forms Trigger BANNER7_FORMS.SAADCRV Use(select )
VALIDATE_KEY Forms Trigger BANNER7_FORMS_10G.SGASPRT Use(select )
VALIDATE_KEY Forms Trigger BANNER7_FORMS.SGASPRT Use(select )
WHEN_NEW_BLOCK_INSTANCE_TRG Forms Trigger BANNER7_FORMS.SGADISA Use(select )
WHEN_NEW_BLOCK_INSTANCE_TRG Forms Trigger BANNER7_FORMS_10G.SGAADVR Use(select )
WHEN_NEW_BLOCK_INSTANCE_TRG Forms Trigger BANNER7_FORMS_10G.SGADISA Use(select )
WHEN_NEW_BLOCK_INSTANCE_TRG Forms Trigger BANNER7_FORMS.SGAADVR Use(select )
STVTERM_SGBSTDN_RG Forms Record Group BANNER7_FORMS.SHADEGR Use(select )
STVTERM_SGBSTDN_RG Forms Record Group BANNER7_FORMS_10G.SHADEGR Use(select )
CHECK_DELETE_CONC Forms Trigger BANNER7_FORMS.SOACURR.SORCCON Use(select )
CHECK_DELETE_CONC Forms Trigger BANNER7_FORMS_10G.SOACURR.SORCCON Use(select )
CHECK_DELETE_MAJOR Forms Trigger BANNER7_FORMS.SOACURR.SORCMJR Use(select )
CHECK_DELETE_MAJOR Forms Trigger BANNER7_FORMS_10G.SOACURR.SORCMJR Use(select )
CHECK_DELETE_MINOR Forms Trigger BANNER7_FORMS.SOACURR.SORCMNR Use(select )
CHECK_DELETE_MINOR Forms Trigger BANNER7_FORMS_10G.SOACURR.SORCMNR Use(select )
CHECK_DISB_REC_DELAY Forms Trigger BANNER7_FORMS_10G.RPAELAP.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 )
CHECK_DISB_REC_DELAY Forms Trigger BANNER7_FORMS_10G.RPALORG.RPRLAPP Use(select )
CHECK_STUDENT Forms Trigger BANNER7_FORMS_10G.SGACOOP.KEY_BLOCK Use(select )
CHECK_STUDENT Forms Trigger BANNER7_FORMS.SGASTDQ.KEY_BLOCK Use(select )
CHECK_STUDENT Forms Trigger BANNER7_FORMS.SGAEOPS.KEY_BLOCK Use(select )
CHECK_STUDENT Forms Trigger BANNER7_FORMS.SGASTDN.KEY_BLOCK Use(select )
CHECK_STUDENT Forms Trigger BANNER7_FORMS.SFAREGQ.KEY_BLOCK Use(select )
CHECK_STUDENT Forms Trigger BANNER7_FORMS.SGACOOP.KEY_BLOCK Use(select )
CHECK_STUDENT Forms Trigger BANNER7_FORMS_10G.SFAREGQ.KEY_BLOCK Use(select )
CHECK_STUDENT Forms Trigger BANNER7_FORMS_10G.SGASTDQ.KEY_BLOCK Use(select )
CHECK_STUDENT Forms Trigger BANNER7_FORMS_10G.SGASTDN.KEY_BLOCK Use(select )
CHECK_STUDENT Forms Trigger BANNER7_FORMS_10G.SGAEOPS.KEY_BLOCK Use(select )
DISPLAY_INDICATORS Forms Trigger BANNER7_FORMS.SRARECR.SRBRECR Use(select )
DISPLAY_INDICATORS Forms Trigger BANNER7_FORMS_10G.SRARECR.SRBRECR Use(select )
EXIT_BLOCK Forms Trigger BANNER7_FORMS.SFAREGF.KEY_BLOCK Use(select )
EXIT_BLOCK Forms Trigger BANNER7_FORMS_10G.SFAREGS.KEY_BLOCK Use(select )
EXIT_BLOCK Forms Trigger BANNER7_FORMS_10G.SFAREGF.KEY_BLOCK Use(select )
EXIT_BLOCK Forms Trigger BANNER7_FORMS.SFAREGS.KEY_BLOCK Use(select )
GET_ACADEMIC_HISTORY_DATA Forms Trigger BANNER7_FORMS.RPQLELG.RPRLAPP Use(select )
GET_ACADEMIC_HISTORY_DATA Forms Trigger BANNER7_FORMS_10G.RPQLELG.RPRLAPP Use(select )
GET_BASIC_STUDENT_DATA Forms Trigger BANNER7_FORMS.RPQLELG.RPRLAPP Use(select )
GET_BASIC_STUDENT_DATA Forms Trigger BANNER7_FORMS_10G.RPQLELG.RPRLAPP Use(select )
GET_EXPECTED_GRAD_DATE Forms Trigger BANNER7_FORMS_10G.RPALAPP.RPRLCRT Use(select )
GET_EXPECTED_GRAD_DATE Forms Trigger BANNER7_FORMS.RPALAPP.RPRLCRT Use(select )
GET_EXPECTED_GRAD_DATE Forms Trigger BANNER7_FORMS.RPAELAP.RPRLCRT Use(select )
GET_EXPECTED_GRAD_DATE Forms Trigger BANNER7_FORMS_10G.RPAELAP.RPRLCRT Use(select )
GET_LEVEL Forms Trigger BANNER7_FORMS_10G.SFASLST.SFRSTCR Use(select )
GET_LEVEL Forms Trigger BANNER7_FORMS.SFAALST.SFRSTCR Use(select )
GET_LEVEL Forms Trigger BANNER7_FORMS.SFASLST.SFRSTCR Use(select )
GET_LEVEL Forms Trigger BANNER7_FORMS_10G.SFAALST.SFRSTCR Use(select )
KEY_COMMIT_CONT Forms Trigger BANNER7_FORMS.SFAREGS.SGBSTDN Use(select )
KEY_COMMIT_CONT Forms Trigger BANNER7_FORMS_10G.SFAREGS.SGBSTDN Use(select )
KEY_COMMIT_CONT Forms Trigger BANNER7_FORMS_10G.SFAREGS.SGBSTDN Rely on ()
KEY_DELREC Forms Trigger BANNER7_FORMS_10G.SGASTDN.SGBSTDN Use(select )
KEY_DELREC Forms Trigger BANNER7_FORMS.SGASTDN.SGBSTDN Use(select )
KEY_NXTBLK Forms Trigger BANNER7_FORMS.SGAUSDF.SGASTDN_KEY_BLOCK Use(select )
KEY_NXTBLK Forms Trigger BANNER7_FORMS_10G.SGAUSDF.SGASTDN_KEY_BLOCK Use(select )
POST-BLOCK Forms Trigger BANNER7_FORMS_10G.SFARGRP.KEY_BLOCK Use(select )
POST-BLOCK Forms Trigger BANNER7_FORMS.SFARGRP.KEY_BLOCK Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS.SHQTERM.SHRTTRM Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS_10G.SHQTERM.SHRTTRM Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS.SHARQTC.STVLEVL Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS_10G.SGASTDQ.SGBSTDN Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS_10G.SHARQTC.STVLEVL Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS.SGASTDQ.SGBSTDN Use(select )
POST_BLOCK_TERM_CHECK Forms Trigger BANNER7_FORMS_10G.SGASADD.SGASTDN_KEY_BLOCK Use(select )
POST_BLOCK_TERM_CHECK Forms Trigger BANNER7_FORMS_10G.SGACOOP.KEY_BLOCK Use(select )
POST_BLOCK_TERM_CHECK Forms Trigger BANNER7_FORMS.SGASADD.SGASTDN_KEY_BLOCK Use(select )
POST_BLOCK_TERM_CHECK Forms Trigger BANNER7_FORMS.SGACOOP.KEY_BLOCK Use(select )
PRE-DELETE Forms Trigger BANNER7_FORMS.SMAPRLE.SMRPRLE Use(select )
PRE-DELETE Forms Trigger BANNER7_FORMS_10G.SMAPRLE.SMRPRLE Use(select )
PRE-INSERT Forms Trigger BANNER7_FORMS.SHAINST.SHRTTRM Use(select )
PRE-INSERT Forms Trigger BANNER7_FORMS.SGASTDN.SGBSTDN Use(select )
PRE-INSERT Forms Trigger BANNER7_FORMS.SGACOOP.SGRCOOP Use(select )
PRE-INSERT Forms Trigger BANNER7_FORMS_10G.SHAINST.SHRTTRM Use(select )
PRE-INSERT Forms Trigger BANNER7_FORMS_10G.SGASTDN.SGBSTDN Use(select )
PRE-INSERT Forms Trigger BANNER7_FORMS_10G.SGACOOP.SGRCOOP Use(select )
PRE-QUERY Forms Trigger BANNER7_FORMS.SGAUSDF.SGSSTDN Use(select )
PRE-QUERY Forms Trigger BANNER7_FORMS_10G.SGAUSDF.SGSSTDN Use(select )
SFRBTCH Forms Trigger BANNER7_FORMS.SFAEFEE.SFREFEE Use(select )
SFRBTCH Forms Trigger BANNER7_FORMS_10G.SFAEFEE.SFREFEE Use(select )
UPDATE_APPL_STATUS Forms Trigger BANNER7_FORMS.SAADCBT.SARDSCL Use(select )
UPDATE_APPL_STATUS Forms Trigger BANNER7_FORMS_10G.SAADCBT.SARDSCL Use(select )
UPDBTCH Forms Trigger BANNER7_FORMS_10G.SFAMASS.SFRSTCR Use(select )
UPDBTCH Forms Trigger BANNER7_FORMS.SFAMASS.SFRSTCR Use(select )
ACPT_INDICATOR Forms Procedure BANNER7_FORMS.SOASRVW Use(select )
ACPT_INDICATOR Forms Procedure BANNER7_FORMS_10G.SOASRVW Use(select )
CHECK_FOR_STUDENT Forms Procedure BANNER7_FORMS.SAAADMS Use(select )
CHECK_FOR_STUDENT Forms Procedure BANNER7_FORMS_10G.SAAADMS Use(select )
CHECK_SGBSTDN_FOR_DUPS Forms Procedure BANNER7_FORMS_10G.SAAQUIK Use(select )
CHECK_SGBSTDN_FOR_DUPS Forms Procedure BANNER7_FORMS.SAAQUIK Use(select )
DEGREE_DATA Forms Procedure BANNER7_FORMS.SOASRVW Use(select )
DEGREE_DATA Forms Procedure BANNER7_FORMS_10G.SOASRVW Use(select )
GET_TERM_CODE Forms Procedure BANNER7_FORMS.SHARQTC Use(select )
GET_TERM_CODE Forms Procedure BANNER7_FORMS_10G.SHARQTC Use(select )
LOAD_COMM_FIELDS Forms Procedure BANNER7_FORMS_10G.SFAREGS Use(select )
LOAD_COMM_FIELDS Forms Procedure BANNER7_FORMS.SFAREGS Use(select )
MOD_COMM_PLAN Forms Procedure BANNER7_FORMS_10G.SFAREGS Use(select )
MOD_COMM_PLAN Forms Procedure BANNER7_FORMS.SGASTDN Use(select )
MOD_COMM_PLAN Forms Procedure BANNER7_FORMS_10G.SGASTDN Use(select )
MOD_COMM_PLAN Forms Procedure BANNER7_FORMS.SFAREGS Use(select )
NEW_RECORD_2A Forms Procedure BANNER7_FORMS.REAPV98 Use(select )
SELECT_SGBSTDN_2 Forms Procedure BANNER7_FORMS_10G.SFARQST Use(select )
SELECT_SGBSTDN_2 Forms Procedure BANNER7_FORMS.SFARQST Use(select )
SFRBTCH_UPDATE Forms Procedure BANNER7_FORMS.SSADETL Rely on ()
SFRBTCH_UPDATE Forms Procedure BANNER7_FORMS_10G.SSADETL Rely on ()
SFRBTCH_UPDATE Forms Procedure BANNER7_FORMS_10G.SSADETL Use(select )
SFRBTCH_UPDATE Forms Procedure BANNER7_FORMS.SSADETL Use(select )
F_CLASS_FNC FUNCTION S4B70.BANINST1 Use(select )
F_CONCAT_PREV_TERM_GPA FUNCTION S4B70.BANINST1 Use(select )
F_GET_CURRENT_SGBSTDN_ROWID FUNCTION S4B70.BANINST1 Use(select )
F_GET_SGBSTDN_ROWID FUNCTION S4B70.BANINST1 Use(select )
F_SGBSTDN_FIELDS FUNCTION S4B70.BANINST1 Rely on ()
F_SGBSTDN_FIELDS FUNCTION S4B70.BANINST1 Rely on () Use(select )
F_STUDENT_GEN_STUDENTS_IND FUNCTION S4B70.BANINST1 Use(select )
CHECK_DUP_LEVEL Forms Function BANNER7_FORMS_10G.SAAQUIK Use(select )
CHECK_DUP_LEVEL Forms Function BANNER7_FORMS.SAAQUIK Use(select )
SELECT_DUAL_4 Forms Function BANNER7_FORMS_10G.SGASTDN Use(select )
SELECT_DUAL_4 Forms Function BANNER7_FORMS.SGASTDN Use(select )
SELECT_SGBSTDN_2 Forms Function BANNER7_FORMS.SAADCRV Use(select )
SELECT_SGBSTDN_2 Forms Function BANNER7_FORMS_10G.SAADCRV Use(select )
SGBSTDN_RECORD_EXIST Forms Function BANNER7_FORMS.SAADCBT Use(select )
SGBSTDN_RECORD_EXIST Forms Function BANNER7_FORMS_10G.SAADCRV Use(select )
SGBSTDN_RECORD_EXIST Forms Function BANNER7_FORMS_10G.SAADCBT Use(select )
SGBSTDN_RECORD_EXIST Forms Function BANNER7_FORMS.SAADCRV Use(select )
LEARNER_REC Package Type S4B70.BANINST1.SB_LEARNER Rely on ()
T_STUDTLTYPE Package Type S4B70.BANINST1.BWCKGSTU Rely on ()
CHECKSTUSTATUSC Package cursor S4B70.BANINST1.BWLKOIDS Use(select )
C_GETSTUDTLC Package cursor S4B70.BANINST1.BWCKGSTU Use(select )
SGBSTDNC Package cursor S4B70.BANINST1.SGKWEVN Use(select )
SGBSTDN_TAB_TYPE Package Type S4B70.BANINST1.SOKTABS Rely on ()
SGBSTDN_REC Package variable S4B70.BANINST1.BWCKCOMS Rely on ()
SGBSTDN_REC Package variable S4B70.BANINST1.SFKFEES Rely on ()
SGBSTDN_REC Package variable S4B70.BANINST1.SFKFEES Rely on ()
SGBSTDN_REC Package variable S4B70.BANINST1.BWCKCOMS Rely on ()
ROLL_RECORD Package Type S4B70.BANINST1.SHKROLS Rely on ()
SGBSTDN_DETAIL_TYPE Package Type S4B70.BANINST1.BWLKFCWL Rely on ()
P_CAPPPREQCHK Package procedure S4B70.BANINST1.SFKPREQ Use(select )
P_GETSGBSTDN Package procedure S4B70.BANINST1.ROKWEXT Use(select )
P_GETSGBSTDN Package procedure S4B70.BANINST1.SOKWEXT Use(select )
P_GETSTUDENTINFO Package procedure S4B70.BANINST1.BWCKREGS Use(select )
P_GETTERMEFFEND Package procedure S4B70.BANINST1.BWCKGSTU Use(select )
P_GETTERMFIRST Package procedure S4B70.BANINST1.BWCKGSTU Use(select )
P_GET_STUDENT_COURSE Package procedure S4B70.BANINST1.SHKROLS Use(select )
P_MATERIAL_MATCHING Package procedure S4B70.BANINST1.SOKCPLN Use(select )
P_OVERLAY_VALIDATION_REC Package procedure S4B70.BANINST1.SB_LEARNER Rely on ()
UT_SB_ENROLLMENTCREATEAPI Package procedure S4B70.BANINST1.UT_SB_ENROLLMENT Use(insert )
GETEARNEDHRSC Package cursor S4B70.BANINST1.BWCKREGS Rely on ()
GETSTUDENTCLASC Package cursor S4B70.BANINST1.BWCKREGS Rely on ()
GETSTUGENRECC Package cursor S4B70.BANINST1.BWLKFCWL Use(select )
SGBSTDN_DISP_PRIM_C Package cursor S4B70.BANINST1.BWCKCAPP Use(select )
SGBSTDN_LISTC Package cursor S4B70.BANINST1.BWSKWTRR Use(select )
SGBSTDN_PRIM_C Package cursor S4B70.BANINST1.BWCKCAPP Use(select )
SGBSTDN_SECD_C Package cursor S4B70.BANINST1.BWCKCAPP Use(select )
STUDENT_BY_TERM_C Package cursor S4B70.BANINST1.ICSPKCOM Use(select )
STUDENT_BY_TERM_C Package cursor S4B70.BANINST1.ICSPKCOM Rely on ()
HOLD_STU Package variable S4B70.BANINST1.BWLKFCWL Rely on ()
SGBSTDN_REC Package variable S4B70.BANINST1.BWCKGENS Rely on ()
SGBSTDN_REC Package variable S4B70.BANINST1.BWCKSAMS Rely on ()
SGBSTDN_REC Package variable S4B70.BANINST1.BWSKFFEE Rely on ()
SGBSTDN_REC Package variable S4B70.BANINST1.BWCKSAMS Rely on ()
SGBSTDN_REC Package variable S4B70.BANINST1.BWSKFFEE Rely on ()
SGBSTDN_REC Package variable S4B70.BANINST1.BWCKGENS Rely on ()
SGBSTDN_REC Package variable S4B70.BANINST1.BWSKRSTA Rely on ()
SGBSTDN_REC Package variable S4B70.BANINST1.BWSKRSTA Rely on ()
SGBSTDN_ROW Package variable S4B70.BANINST1.BWCKREGS Rely on ()
SGBSTDN_ROW Package variable S4B70.BANINST1.BWCKREGS Rely on ()
STUD_CAMP Package variable S4B70.BANINST1.BWCKREGS Rely on ()
STUD_COLLEGE Package variable S4B70.BANINST1.BWCKREGS Rely on ()
STUD_DEGR Package variable S4B70.BANINST1.BWCKREGS Rely on ()
STUD_DEPT Package variable S4B70.BANINST1.BWCKREGS Rely on ()
STUD_LEVEL Package variable S4B70.BANINST1.BWCKREGS Rely on ()
STUD_MAJOR Package variable S4B70.BANINST1.BWCKREGS Rely on ()
STUD_TYPE Package variable S4B70.BANINST1.BWCKREGS Rely on ()
TO_TERM Package variable S4B70.BANINST1.BWCKGSTU Rely on ()
F_BUILD_SGBSTDN_REC Package function S4B70.BANINST1.SB_LEARNER Rely on ()
F_BUILD_SGBSTDN_REC Package function S4B70.BANINST1.SB_LEARNER Rely on ()
F_CHECK_STATUS_ACAD_STAND Package function S4B70.BANINST1.SB_LEARNER Use(select )
F_CHECK_STATUS_ACAD_STAND Package function S4B70.BANINST1.SB_LEARNER Rely on ()
F_CHECK_STATUS_COMB_ACAD_STAND Package function S4B70.BANINST1.SB_LEARNER Use(select )
F_CHECK_STATUS_COMB_ACAD_STAND Package function S4B70.BANINST1.SB_LEARNER Rely on ()
F_GET_TERM Package function S4B70.BANINST1.BWSKWTRR Use(select )
F_HAS_ROLE Package function S4B70.BANINST1.ICGOKROL Use(select )
F_QUERY_LAST_TERM Package function S4B70.BANINST1.SB_LEARNER Rely on ()
F_QUERY_LAST_TERM Package function S4B70.BANINST1.SB_LEARNER Use(select )
P_ADDCRSE Package procedure S4B70.BANINST1.BWCKREGS Rely on ()
P_ADDCRSE Package procedure S4B70.BANINST1.BWCKREGS Rely on ()
P_ALLOW_REG_CAST Package procedure S4B70.BANINST1.SHKPREV Rely on ()
P_ALLOW_REG_CAST Package procedure S4B70.BANINST1.SHKPREV Rely on ()
P_APPLYRULES Package procedure S4B70.BANINST1.SFKFEES Rely on ()
P_BACKLOAD_CURR Package procedure S4B70.BANINST1.SOKLCUR Rely on ()
P_CALCULATE_CAST_CODE Package procedure S4B70.BANINST1.SHKPREV Rely on ()
P_CALCULATE_CAST_CODE Package procedure S4B70.BANINST1.SHKPREV Rely on ()
P_CALCULATE_PREV_CODE Package procedure S4B70.BANINST1.SHKPREV Rely on ()
P_CALCULATE_PREV_CODE Package procedure S4B70.BANINST1.SHKPREV Rely on ()
P_CALC_LOAN_ENROLL_STATUS Package procedure S4B70.BANINST1.RPKLOAN Rely on ()
P_CHECK_CAMP Package procedure S4B70.BANINST1.SFKFUNC Rely on ()
P_CHECK_COLL Package procedure S4B70.BANINST1.SFKFUNC Rely on ()
P_CHECK_LEVL Package procedure S4B70.BANINST1.SFKFUNC Rely on ()
P_CHECK_MAJR Package procedure S4B70.BANINST1.SFKFUNC Rely on ()
P_CHECK_VOICE_AVAIL Package procedure S4B70.BANINST1.SFKFUNC Rely on ()
P_CHECK_VOICE_AVAIL Package procedure S4B70.BANINST1.SFKFUNC Rely on ()
P_CONVERT_CURR Package procedure S4B70.BANINST1.SOKLCUR Rely on ()
P_CONVERT_CURR Package procedure S4B70.BANINST1.SOKLCUR Rely on () Use(select )
P_COPY_LEARNER Package procedure S4B70.BANINST1.SB_LEARNER Rely on ()
P_COUNT_REPEAT_UNITS Package procedure S4B70.BANINST1.SHKRPTS Rely on ()
P_COUNT_REPEAT_UNITS Package procedure S4B70.BANINST1.SHKRPTS Rely on ()
P_CREATE Package procedure S4B70.BANINST1.SB_LEARNER Rely on ()
P_CREATE Package procedure S4B70.BANINST1.SB_LEARNER Rely on ()
P_DEFAULT_STATUS Package procedure S4B70.BANINST1.SOKLCUR Rely on ()
P_DEFAULT_STATUS Package procedure S4B70.BANINST1.SOKLCUR Rely on ()
P_DELETE Package procedure S4B70.BANINST1.SB_LEARNER Rely on ()
P_DELETE Package procedure S4B70.BANINST1.DML_SGBSTDN Use(delete )
P_DELETE Package procedure S4B70.BANINST1.SB_LEARNER Rely on () Use(select )
P_DISPCURSOURCESGBSTDN Package procedure S4B70.BANINST1.BWCKCAPP Rely on ()
P_DISPCURSOURCESGBSTDN Package procedure S4B70.BANINST1.BWCKCAPP Rely on ()
P_FACSTUINFO Package procedure S4B70.BANINST1.BWLKGSTU Rely on ()
P_FACSTUPIN Package procedure S4B70.BANINST1.BWLKILIB Rely on ()
P_FACVERIFYID Package procedure S4B70.BANINST1.BWLKFTRN Use(select )
P_GET_ACAD_STAND Package procedure S4B70.BANINST1.SHKFUNC Rely on ()
P_GET_ACAD_STAND Package procedure S4B70.BANINST1.SHKFUNC Rely on ()
P_GET_CAST Package procedure S4B70.BANINST1.SHKPREV Rely on ()
P_GET_CAST Package procedure S4B70.BANINST1.SHKPREV Rely on ()
P_GET_SCHOOL_CODE Package procedure S4B70.BANINST1.RSKMISC Use(select )
P_GET_SSRRESV_ROW Package procedure S4B70.BANINST1.SSKSELS Rely on ()
P_GET_STUDENT_CURRICULUM Package procedure S4B70.BANINST1.BWSCBREF Use(select )
P_GET_STUDENT_CURRICULUM Package procedure S4B70.BANINST1.BWSCJREF Use(select )
P_GET_STUDENT_FORMATS Package procedure S4B70.BANINST1.SHKCGPA Rely on ()
P_GET_SUB_CODE Package procedure S4B70.BANINST1.BWCKCPMT Rely on ()
P_GET_SUB_CODE Package procedure S4B70.BANINST1.BWCKCPMT Rely on ()
P_GET_SUB_CODE_1 Package procedure S4B70.BANINST1.BWSKWCCP Rely on ()
P_GET_SUB_CODE_1 Package procedure S4B70.BANINST1.BWSKWCCP Rely on ()
P_GET_TERM_PELL_FUND Package procedure S4B70.BANINST1.ROKPELL Rely on ()
P_INSERT Package procedure S4B70.BANINST1.DML_SGBSTDN Rely on () Use(insert )
P_INSERT_SHRGPAC Package procedure S4B70.BANINST1.SHKCGPA Rely on ()
P_INSERT_SHRGPAC_PREBANNER Package procedure S4B70.BANINST1.SHKCGPA Rely on ()
P_INSERT_SHRTRAM Package procedure S4B70.BANINST1.SHKTAEQ Rely on ()
P_INSERT_SHRTRIT Package procedure S4B70.BANINST1.SHKTAEQ Rely on ()
P_LOCK Package procedure S4B70.BANINST1.SB_LEARNER Rely on ()
P_LOCK Package procedure S4B70.BANINST1.SB_LEARNER Use(select )
P_OPEN_STUDENT_LIST_C Package procedure S4B70.BANINST1.BWLKOIDS Use(select )
P_PRE_EDIT Package procedure S4B70.BANINST1.SFKEDIT Rely on ()
P_PROCESSFEEASSESSMENT Package procedure S4B70.BANINST1.SFKFEES Use(select )
P_REGISTER_ENTITY Package procedure S4B70.BANINST1.SB_LEARNER_RULES Rely on ()
P_REGSCHK Package procedure S4B70.BANINST1.BWCKREGS Rely on ()
P_REGSCHK Package procedure S4B70.BANINST1.BWCKREGS Rely on ()
P_REGSRESULT Package procedure S4B70.BANINST1.BWCKSAMS Rely on ()
P_REGSRESULT Package procedure S4B70.BANINST1.BWCKSAMS Rely on ()
P_SAVE_ADD_NEW_FAC_USER Package procedure S4B70.BANINST1.ICSIKSEV Rely on ()
P_SAVE_ADD_NEW_STU_USER Package procedure S4B70.BANINST1.ICSGKSEV Rely on ()
P_SAVE_ADD_PERSON Package procedure S4B70.BANINST1.ICSPKEVN Rely on ()
P_SAVE_CHANGE_MAJOR Package procedure S4B70.BANINST1.ICSGKSEV Rely on ()
P_SAVE_UPD_PERSON_ADDRESS Package procedure S4B70.BANINST1.ICSPKEVN Rely on ()
P_SAVE_UPD_PERSON_EMAIL Package procedure S4B70.BANINST1.ICSPKEVN Rely on ()
P_SEARCHCHK Package procedure S4B70.BANINST1.BWCKGENS Rely on ()
P_SEARCHCHK Package procedure S4B70.BANINST1.BWCKGENS Rely on ()
P_SELECT_SGBSTDN_CAMPUS Package procedure S4B70.BANINST1.ROKPELL Rely on ()
P_SELECT_SGBSTDN_CAMPUS Package procedure S4B70.BANINST1.ROKPELL Use(select )
P_SEND_ADD_NEW_STU_USER Package procedure S4B70.BANINST1.ICSGKSEV Rely on ()
P_SEND_CHANGE_MAJOR Package procedure S4B70.BANINST1.ICSGKSEV Rely on ()
P_STUDENTTERMDATA Package procedure S4B70.BANINST1.BWSKXMIS Rely on ()
P_STUDENTTERMDATA Package procedure S4B70.BANINST1.BWSKXMIS Use(select )
P_STUINFO Package procedure S4B70.BANINST1.BWCKGSTU Rely on ()
P_UPDATE Package procedure S4B70.BANINST1.SB_LEARNER Rely on ()
P_UPDATE Package procedure S4B70.BANINST1.DML_SGBSTDN Rely on ()
P_UPDATE Package procedure S4B70.BANINST1.SB_LEARNER Rely on ()
P_UPDATE_CURRICULUM Package procedure S4B70.BANINST1.DML_SGBSTDN Rely on ()
P_UPDATE_REGS Package procedure S4B70.BANINST1.SFKEDIT Rely on ()
P_UPDSTUDENTTERMDATA Package procedure S4B70.BANINST1.BWSKXMIS Rely on ()
P_UPDTMST Package procedure S4B70.BANINST1.BWLKFSFK Rely on ()
P_VALIDATE Package procedure S4B70.BANINST1.SB_LEARNER_RULES Rely on ()
P_VALIDATE_INSERT Package procedure S4B70.BANINST1.SB_CURRICULUM_RULES Rely on ()
P_VERIFY_ELIGIBLE_TO_REGISTER Package procedure S4B70.BANINST1.VRSKFORG Rely on ()
P_VIEWGRDE Package procedure S4B70.BANINST1.BWSKOGRD Rely on ()
P_VIEWGRDE Package procedure S4B70.BANINST1.BWSKOGRD Rely on ()
P_VIEWTRANSCRIPT Package procedure S4B70.BANINST1.BWCKOTRN Rely on ()
P_VIEWTRANSCRIPT Package procedure S4B70.BANINST1.BWCKOTRN Rely on ()
P_VR_ADD_CLASS Package procedure S4B70.BANINST1.VRSKFREG Rely on ()
P_VR_ADD_CLASS Package procedure S4B70.BANINST1.VRSKFREG Rely on ()
P_VR_ASSESS_FEES Package procedure S4B70.BANINST1.VRGKOCTL Rely on ()
P_VR_ASSESS_FEES Package procedure S4B70.BANINST1.VRGKOCTL Rely on ()
P_VR_CONFIRM_REG Package procedure S4B70.BANINST1.VRSKFORG Rely on ()
P_VR_CONFIRM_REG Package procedure S4B70.BANINST1.VRSKFORG Rely on ()
P_VR_CONFIRM_REG_OPT Package procedure S4B70.BANINST1.VRSKFORG Rely on ()
P_VR_CONFIRM_REG_OPT Package procedure S4B70.BANINST1.VRSKFORG Rely on ()
P_VR_CONTINUE_CONFIRM Package procedure S4B70.BANINST1.VRSKFORG Rely on ()
P_VR_CONTINUE_CONFIRM Package procedure S4B70.BANINST1.VRSKFORG Rely on ()
P_VR_CRN_LIST Package procedure S4B70.BANINST1.VRSKFOLR Rely on ()
P_VR_CRN_LIST Package procedure S4B70.BANINST1.VRSKFOLR Rely on ()
P_VR_GET_PROGRESS_DATA Package procedure S4B70.BANINST1.VRHKGRDS Rely on ()
P_VR_GET_PROGRESS_DATA Package procedure S4B70.BANINST1.VRHKGRDS Rely on ()
P_VR_LIST_GRADES Package procedure S4B70.BANINST1.VRHKGRDS Rely on ()
P_VR_LIST_GRADES Package procedure S4B70.BANINST1.VRHKGRDS Rely on ()
P_VR_PROCESS_ADMINDROPS Package procedure S4B70.BANINST1.VRSKFREG Rely on ()
P_VR_PROCESS_ADMINDROPS Package procedure S4B70.BANINST1.VRSKFREG Rely on ()
P_VR_REG_APPL_MENU_OPT 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_REG_TERM_ELIGIBLE Package procedure S4B70.BANINST1.VRSKFOLR Rely on ()
P_VR_VALIDATE_PIN Package procedure S4B70.BANINST1.VRSKPVAL Rely on ()
P_VR_VALIDATE_PIN Package procedure S4B70.BANINST1.VRSKPVAL Rely on ()
P_VR_WITHDRAW_FROM_TERM Package procedure S4B70.BANINST1.VRSKFORG Rely on ()
P_VR_WITHDRAW_FROM_TERM Package procedure S4B70.BANINST1.VRSKFORG Rely on ()
P_WRITE_CRN_SELECTION Package procedure S4B70.BANINST1.BWSKSMRK Rely on ()
P_WRITE_CRN_SELECTION Package procedure S4B70.BANINST1.BWSKSMRK Rely on ()
P_WRITE_MIDTERM_GRADES Package procedure S4B70.BANINST1.BWSKMGRD Rely on ()
P_WRITE_MIDTERM_GRADES Package procedure S4B70.BANINST1.BWSKMGRD Rely on ()
UT_SETUP Package procedure S4B70.BANINST1.UT_SB_ENROLLMENT Use(insert )
UT_TEARDOWN Package procedure S4B70.BANINST1.UT_GB_SECTION Use(delete )
SGBSTDNC Package cursor S4B70.BANINST1.SGKLIBS Rely on () Use(select )
SGBSTDN_COUNT_C Package cursor S4B70.BANINST1.ICSGKLIB Rely on ()
SGBSTDN_NEXT_C Package cursor S4B70.BANINST1.SGKLIBS Rely on ()
SGBSTDN_NEXT_C Package cursor S4B70.BANINST1.SGKLIBS Rely on () Use(select )
F_CHECK_MGMT_CONTROL Package function S4B70.BANINST1.SFKRCTL Rely on ()
F_CHECK_MGMT_CONTROL Package function S4B70.BANINST1.SFKRCTL Rely on ()
F_CHECK_PLAN Package function S4B70.BANINST1.TSKAIST Use(select )
F_CHECK_SGBSTDN_EXISTS Package function S4B70.BANINST1.SAKDCSN Use(select )
F_CONVERT_LEARNER Package function S4B70.BANINST1.SOKLCUR Use(select )
F_DEGR_ENROLLED_IND Package function S4B70.BANINST1.SOKODSF Use(select )
F_ELIGIBLE_TO_REGISTER Package function S4B70.BANINST1.SB_LEARNER Use(select )
F_ELIGIBLE_TO_REGISTER Package function S4B70.BANINST1.SB_LEARNER Rely on ()
F_EXISTS Package function S4B70.BANINST1.SB_LEARNER Rely on ()
F_EXISTS Package function S4B70.BANINST1.SB_LEARNER Use(select )
F_FIND_IF_STUDENT Package function S4B70.BANINST1.SOKFGAC Use(select )
F_FIND_IF_STUDENT_FINAID Package function S4B70.BANINST1.SOKFGAC Use(select )
F_GET_ACAD_PROFILE Package function S4B70.BANINST1.BWSCXCHN Use(select )
F_GET_ACAD_PROFILE Package function S4B70.BANINST1.BWSCXCHN Rely on ()
F_GET_END_SGBSTDN_TERM Package function S4B70.BANINST1.SOKODSF Use(select )
F_GET_EXCLUDE_LEVEL_IND Package function S4B70.BANINST1.ROKVIEW Rely on ()
F_GET_EXCLUDE_LEVEL_IND Package function S4B70.BANINST1.ROKVIEW Use(select )
F_GET_MAJORS Package function S4B70.BANINST1.ICSPKCOM Rely on ()
F_GET_MAJORS Package function S4B70.BANINST1.ICSPKCOM Rely on ()
F_GET_PERSON_BL Package function S4B70.BANINST1.TESTCHNL Use(select )
F_GET_PERSON_XML Package function S4B70.BANINST1.XCHAPERS Use(select )
F_GET_SGBSTDN_ROW Package function S4B70.BANINST1.SGKSELS Rely on ()
F_GET_SGBSTDN_ROW Package function S4B70.BANINST1.SGKSELS Rely on ()
F_GET_STUDENT_BY_TERM Package function S4B70.BANINST1.ICSPKCOM Rely on ()
F_GET_STUDENT_BY_TERM Package function S4B70.BANINST1.ICSPKCOM Rely on ()
F_GET_TURN_OFF_PELL_IND Package function S4B70.BANINST1.ROKFUNC Rely on ()
F_GET_TURN_OFF_PELL_IND Package function S4B70.BANINST1.ROKFUNC Use(select )
F_QUERY_ALL Package function S4B70.BANINST1.SB_LEARNER Rely on ()
F_QUERY_ALL Package function S4B70.BANINST1.SB_LEARNER Use(select )
F_QUERY_BY_ROWID Package function S4B70.BANINST1.SB_LEARNER Use(select )
F_QUERY_CURRENT Package function S4B70.BANINST1.SB_LEARNER Rely on ()
F_QUERY_CURRENT Package function S4B70.BANINST1.SB_LEARNER Use(select )
F_QUERY_END Package function S4B70.BANINST1.SB_LEARNER Rely on ()
F_QUERY_END Package function S4B70.BANINST1.SB_LEARNER Use(select )
F_QUERY_ONE Package function S4B70.BANINST1.SB_LEARNER Rely on ()
F_QUERY_ONE Package function S4B70.BANINST1.SB_LEARNER Use(select )
F_QUERY_ONE_LOCK Package function S4B70.BANINST1.SB_LEARNER Rely on ()
F_QUERY_ONE_LOCK Package function S4B70.BANINST1.SB_LEARNER Use(select )
F_REG_CRITERIA_MET Package function S4B70.BANINST1.SFKSELS Rely on ()
F_STUDENT_ID_TYPE Package function S4B70.BANINST1.BWLCXCHN Use(select )
F_TEST_SGBSTDN_EXIST Package function S4B70.BANINST1.BWCKCAPP Use(select )
F_TEST_SGBSTDN_SECD Package function S4B70.BANINST1.BWCKCAPP Use(select )
F_VALIDATEGRADE Package function S4B70.BANINST1.SHKWEVN Use(select )
GET_STDN_GRAD_DATE Package function S4B70.BANINST1.BWCKSMLT Rely on ()
GET_STDN_GRAD_DATE Package function S4B70.BANINST1.BWCKSMLT Use(select )
SGBSTDN SYNONYM S4B70.PUBLIC Rely on ()
SGBSTDN Forms DataBlock BANNER7_FORMS.SFAREGS Rely on () Use(insert,update,delete,select )
SGBSTDN Forms DataBlock BANNER7_FORMS.SOASRVW Rely on () Use(select )
SGBSTDN Forms DataBlock BANNER7_FORMS_10G.SFARQST Rely on () Use(insert,update,delete,select )
SGBSTDN Forms DataBlock BANNER7_FORMS_10G.SGASTDN Rely on () Use(insert,update,delete,select )
SGBSTDN Forms DataBlock BANNER7_FORMS_10G.SFAREGS Rely on () Use(insert,update,delete,select )
SGBSTDN Forms DataBlock BANNER7_FORMS_10G.SOASRVW Rely on () Use(select )
SGBSTDN Forms DataBlock BANNER7_FORMS.SGASTDQ Rely on () Use(insert,update,delete,select )
SGBSTDN Forms DataBlock BANNER7_FORMS.SGASTDN Rely on () Use(insert,update,delete,select )
SGBSTDN Forms DataBlock BANNER7_FORMS.SAAQUIK Rely on () Use(insert,update,delete,select )
SGBSTDN Forms DataBlock BANNER7_FORMS.SFARQST Rely on () Use(insert,update,delete,select )
SGBSTDN Forms DataBlock BANNER7_FORMS_10G.SOAIDNS Rely on () Use(insert,update,delete,select )
SGBSTDN Forms DataBlock BANNER7_FORMS_10G.SGASTDQ Rely on () Use(insert,update,delete,select )
SGBSTDN Forms DataBlock BANNER7_FORMS_10G.SAAQUIK Rely on () Use(insert,update,delete,select )
SGBSTDN Forms DataBlock BANNER7_FORMS.SOAIDNS Rely on () Use(insert,update,delete,select )
SGSSTDN Forms DataBlock BANNER7_FORMS.SGAUSDF Rely on () Use(insert,update,delete,select )
SGSSTDN Forms DataBlock BANNER7_FORMS_10G.SGAUSDF Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_SGBSTDN INDEX S4B70.SATURN Rely on ()
ST_ICAIR_ADD_NEW_STU_USER TRIGGER S4B70.SATURN Fire(insert after each row )
ST_ICAIR_CHANGE_MAJOR TRIGGER S4B70.SATURN Fire(insert after each row )
ST_ICAIS_ADD_NEW_STU_USER TRIGGER S4B70.SATURN Fire(insert after all rows )
ST_ICAIS_CHANGE_MAJOR TRIGGER S4B70.SATURN Fire(insert after all rows )
ST_ICAUR_CHANGE_MAJOR TRIGGER S4B70.SATURN Fire(update after each row )
ST_ICAUS_CHANGE_MAJOR TRIGGER S4B70.SATURN Fire(update after all rows )
ST_ICBIS_ADD_NEW_STU_USER TRIGGER S4B70.SATURN Fire(insert before all rows )
ST_SGBSTDN_AIR TRIGGER S4B70.SATURN Fire(insert after each row )
ST_SGBSTDN_AIR_IC TRIGGER S4B70.SATURN Fire(insert after each row )
ST_SGBSTDN_AIS TRIGGER S4B70.SATURN Fire(insert after all rows )
ST_SGBSTDN_AIS_IC TRIGGER S4B70.SATURN Fire(insert after all rows )
ST_SGBSTDN_AR_LDI TRIGGER S4B70.SATURN Fire(insert,update,delete after each row )
ST_SGBSTDN_AS_LDI TRIGGER S4B70.SATURN Fire(insert,update,delete after all rows )
ST_SGBSTDN_BIS_IC TRIGGER S4B70.SATURN Fire(insert before all rows )
ST_SGBSTDN_DELETE_ROW TRIGGER S4B70.SATURN Fire(delete before each row )
ST_SGBSTDN_INSERT_ROW TRIGGER S4B70.SATURN Fire(insert before each row )
ST_SGBSTDN_UPDATE_ROW TRIGGER S4B70.SATURN Fire(update before each row )
ST_SIBINST_BIS_IC TRIGGER S4B70.SATURN Fire(insert before all rows )
SHRLGPA TABLE S4B70.SATURN Join
SHRTTRM TABLE S4B70.SATURN Join
SMRPRLE TABLE S4B70.SATURN Refer( No Action )
SOBCURR TABLE S4B70.SATURN Refer( No Action )
SORCCON TABLE S4B70.SATURN Refer( No Action )
SORCMJR TABLE S4B70.SATURN Refer( No Action )
SORCMNR TABLE S4B70.SATURN Refer( No Action )
STVACYR TABLE S4B70.SATURN Refer( No Action )
STVADMT TABLE S4B70.SATURN Refer( No Action )
STVAPRN TABLE S4B70.SATURN Refer( No Action )
STVASTD TABLE S4B70.SATURN Refer( No Action )
STVBLCK TABLE S4B70.SATURN Refer( No Action )
STVBSKL TABLE S4B70.SATURN Refer( No Action )
STVCAMP TABLE S4B70.SATURN Refer( No Action )
STVCAPL TABLE S4B70.SATURN Refer( No Action )
STVCAST 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 )
STVEDLV TABLE S4B70.SATURN Refer( No Action )
STVEGOL TABLE S4B70.SATURN Refer( No Action )
STVEMEX TABLE S4B70.SATURN Refer( No Action )
STVGAIN TABLE S4B70.SATURN Refer( No Action )
STVINCM TABLE S4B70.SATURN Refer( No Action )
STVLEAV TABLE S4B70.SATURN Refer( No Action )
STVLEVL TABLE S4B70.SATURN Refer( No Action )
STVMAJR TABLE S4B70.SATURN Refer( No Action )
STVORSN TABLE S4B70.SATURN Refer( No Action )
STVPRAC TABLE S4B70.SATURN Refer( No Action )
STVPREV TABLE S4B70.SATURN Refer( No Action )
STVRATE TABLE S4B70.SATURN Refer( No Action )
STVRESD TABLE S4B70.SATURN Refer( No Action )
STVSESS TABLE S4B70.SATURN Refer( No Action )
STVSITE TABLE S4B70.SATURN Refer( No Action )
STVSTST TABLE S4B70.SATURN Refer( No Action )
STVSTYP TABLE S4B70.SATURN Refer( No Action )
STVTERM TABLE S4B70.SATURN Refer( No Action )
STVTRCN TABLE S4B70.SATURN Refer( No Action )
STVVOED TABLE S4B70.SATURN Refer( No Action )

Comments

Source Code Comments

Student Base Table

Columns Comments for SGBSTDN_PIDM (1)

Source Code Comments

This field identifies the internal identification number of student.

Columns Comments for SGBSTDN_TERM_CODE_EFF (2)

Source Code Comments

This field identifies the effective term associated with student record.

Columns Comments for SGBSTDN_STST_CODE (3)

Source Code Comments

This field identifies the students status for the effective term.

Columns Comments for SGBSTDN_LEVL_CODE (4)

Source Code Comments

This field identifies the level of the student for the effective term.

Columns Comments for SGBSTDN_STYP_CODE (5)

Source Code Comments

This field identifies the student type for the effective term.

Columns Comments for SGBSTDN_TERM_CODE_MATRIC (6)

Source Code Comments

This field identifies the effective term of matriculation.

Columns Comments for SGBSTDN_TERM_CODE_ADMIT (7)

Source Code Comments

This field identifies the term student was first admitted to institution.

Columns Comments for SGBSTDN_EXP_GRAD_DATE (8)

Source Code Comments

This field identifies expected graduation date.

Columns Comments for SGBSTDN_CAMP_CODE (9)

Source Code Comments

This field identifies the campus location associated with the student for the effective term.

Columns Comments for SGBSTDN_FULL_PART_IND (10)

Source Code Comments

This field identifies whether the student is a full or part-time student.

Columns Comments for SGBSTDN_SESS_CODE (11)

Source Code Comments

This field identifies the session student is attending for the effective term.

Columns Comments for SGBSTDN_RESD_CODE (12)

Source Code Comments

This field identifies the residency status of the student for the effective term.

Columns Comments for SGBSTDN_COLL_CODE_1 (13)

Source Code Comments

This field identifies the college associated with the primary curriculum for the effective term..

Columns Comments for SGBSTDN_DEGC_CODE_1 (14)

Source Code Comments

This field identifies the degree within the primary curriculum for the effective term.

Columns Comments for SGBSTDN_MAJR_CODE_1 (15)

Source Code Comments

This field identifies the primary major within the primary curriculum for the effective term.

Columns Comments for SGBSTDN_MAJR_CODE_MINR_1 (16)

Source Code Comments

This field identifies the primary minor within the primary curriculum for the effective term.

Columns Comments for SGBSTDN_MAJR_CODE_MINR_1_2 (17)

Source Code Comments

This field identifies the secondary minor of the student for the effective term.

Columns Comments for SGBSTDN_MAJR_CODE_CONC_1 (18)

Source Code Comments

This field identifies the primary concentration within the primary curriculum for the effective term.

Columns Comments for SGBSTDN_MAJR_CODE_CONC_1_2 (19)

Source Code Comments

This field identifies the secondary concentration within the primary curriculum for the effective term.

Columns Comments for SGBSTDN_MAJR_CODE_CONC_1_3 (20)

Source Code Comments

This field identifies the third concentration within the primary curriculum for the effective term.

Columns Comments for SGBSTDN_COLL_CODE_2 (21)

Source Code Comments

This field identifies the college within the secondary curriculum for the effective term.

Columns Comments for SGBSTDN_DEGC_CODE_2 (22)

Source Code Comments

This field identifies the degree within the secondary curriculum for the effective term.

Columns Comments for SGBSTDN_MAJR_CODE_2 (23)

Source Code Comments

This field identifies the primary major within the secondary curriculum for the effective term.

Columns Comments for SGBSTDN_MAJR_CODE_MINR_2 (24)

Source Code Comments

This field identifies the primary minor within the secondary curriculum for the effective term.

Columns Comments for SGBSTDN_MAJR_CODE_MINR_2_2 (25)

Source Code Comments

This field identifies the secondary minor within the secondary curriculum for the effective term.

Columns Comments for SGBSTDN_MAJR_CODE_CONC_2 (26)

Source Code Comments

This field identifies the primary concentration within the secondary curriculum for the effective term.

Columns Comments for SGBSTDN_MAJR_CODE_CONC_2_2 (27)

Source Code Comments

This field identifies the secondary concentration within the secondary curriculum for the effective term.

Columns Comments for SGBSTDN_MAJR_CODE_CONC_2_3 (28)

Source Code Comments

This field identifies the third concentration within the secondary curriculum for the effective term.

Columns Comments for SGBSTDN_ORSN_CODE (29)

Source Code Comments

This field identifies the orientation session assigned to the student for the effective term.

Columns Comments for SGBSTDN_PRAC_CODE (30)

Source Code Comments

This field identifies the practical training experience of the student for the effective term.

Columns Comments for SGBSTDN_ADVR_PIDM (31)

Source Code Comments

This field identifies the internal identification number for the advisor assigned to the student for the effective term.

Columns Comments for SGBSTDN_GRAD_CREDIT_APPR_IND (32)

Source Code Comments

This field identifies eligibility of student to take graduate courses for credit for the effective term. Valid values are Y or blank only.

Columns Comments for SGBSTDN_CAPL_CODE (33)

Source Code Comments

This field identifies career plan of the student for the effective term.

Columns Comments for SGBSTDN_LEAV_CODE (34)

Source Code Comments

This field identifies reason of leave of absence of student for the effective term.

Columns Comments for SGBSTDN_LEAV_FROM_DATE (35)

Source Code Comments

This field identifies the begin date of leave of absence of student for the effective term.

Columns Comments for SGBSTDN_LEAV_TO_DATE (36)

Source Code Comments

This field identifies the end date of leave of absence of student for the effective term.

Columns Comments for SGBSTDN_ASTD_CODE (37)

Source Code Comments

This field identifies the academic standing override for a student for the effective term.

Columns Comments for SGBSTDN_TERM_CODE_ASTD (38)

Source Code Comments

This field identifies the term associated with the academic standing override.

Columns Comments for SGBSTDN_RATE_CODE (39)

Source Code Comments

This field identifies a specific assessment rate of the student for the effective term.

Columns Comments for SGBSTDN_ACTIVITY_DATE (40)

Source Code Comments

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

Columns Comments for SGBSTDN_MAJR_CODE_1_2 (41)

Source Code Comments

This field identifies the secondary major within the primary curriculum for the effective term.

Columns Comments for SGBSTDN_MAJR_CODE_2_2 (42)

Source Code Comments

This field identifies the secondary major within the secondary curriculum for the effective term.

Columns Comments for SGBSTDN_EDLV_CODE (43)

Source Code Comments

A two position alphanumeric field which indicate the highest level of the education that the student completed

Columns Comments for SGBSTDN_INCM_CODE (44)

Source Code Comments

A two position alphanumeric field which indicate the income range of the student

Columns Comments for SGBSTDN_ADMT_CODE (45)

Source Code Comments

Admissions type from the admissions application

Columns Comments for SGBSTDN_EMEX_CODE (46)

Source Code Comments

General Student Employment Expectation Code

Columns Comments for SGBSTDN_APRN_CODE (47)

Source Code Comments

General Student Apprenticeship Code

Columns Comments for SGBSTDN_TRCN_CODE (48)

Source Code Comments

General Student Transfer Center Code

Columns Comments for SGBSTDN_GAIN_CODE (49)

Source Code Comments

This field identifies the employment and training code of the student for the effective term.

Columns Comments for SGBSTDN_VOED_CODE (50)

Source Code Comments

General Student Vocation Eduaction Status Code

Columns Comments for SGBSTDN_BLCK_CODE (51)

Source Code Comments

Block Schedule Code

Columns Comments for SGBSTDN_TERM_CODE_GRAD (52)

Source Code Comments

Term student intends to graduate.

Columns Comments for SGBSTDN_ACYR_CODE (53)

Source Code Comments

Year student intends to graduate.

Columns Comments for SGBSTDN_DEPT_CODE (54)

Source Code Comments

Department Code.

Columns Comments for SGBSTDN_SITE_CODE (55)

Source Code Comments

Site Code.

Columns Comments for SGBSTDN_DEPT_CODE_2 (56)

Source Code Comments

Department Code for second curriculum.

Columns Comments for SGBSTDN_EGOL_CODE (57)

Source Code Comments

Educational Goal code.

Columns Comments for SGBSTDN_BSKL_CODE (63)

Source Code Comments

Student Basic Skills Code

Columns Comments for SGBSTDN_PRIM_ROLL_IND (64)

Source Code Comments

Indicates whether the Primary Curriculum should be Rolled to Academic History

Columns Comments for SGBSTDN_PROGRAM_1 (65)

Source Code Comments

Curriculum 1 Program Code

Columns Comments for SGBSTDN_TERM_CODE_CTLG_1 (66)

Source Code Comments

Curriculum 1 Catalog Term Code

Columns Comments for SGBSTDN_DEPT_CODE_1_2 (67)

Source Code Comments

Curriculum 1 - Department 2

Columns Comments for SGBSTDN_MAJR_CODE_CONC_121 (68)

Source Code Comments

Concentration Code 1 on Second Major of First Curriculum

Columns Comments for SGBSTDN_MAJR_CODE_CONC_122 (69)

Source Code Comments

Concentration Code 2 on Second Major on First Curriculum

Columns Comments for SGBSTDN_MAJR_CODE_CONC_123 (70)

Source Code Comments

Concentration Code 3 on Second Major on First Curriculum

Columns Comments for SGBSTDN_SECD_ROLL_IND (71)

Source Code Comments

Indicates whether the Secondary Curriculum should be Rolled to Academic History

Columns Comments for SGBSTDN_TERM_CODE_ADMIT_2 (72)

Source Code Comments

Admission Term Code associated with the Secondary Curriculum

Columns Comments for SGBSTDN_ADMT_CODE_2 (73)

Source Code Comments

Admissions Type Code associated with the Secondary Curriculum

Columns Comments for SGBSTDN_PROGRAM_2 (74)

Source Code Comments

Curriculum 2 Program Code

Columns Comments for SGBSTDN_TERM_CODE_CTLG_2 (75)

Source Code Comments

Curriculum 2 Catalog Term Code

Columns Comments for SGBSTDN_LEVL_CODE_2 (76)

Source Code Comments

Curriculum 2 Level Code

Columns Comments for SGBSTDN_CAMP_CODE_2 (77)

Source Code Comments

Curriculum 2 Campus Code

Columns Comments for SGBSTDN_DEPT_CODE_2_2 (78)

Source Code Comments

Curriculum 2 - Department 2

Columns Comments for SGBSTDN_MAJR_CODE_CONC_221 (79)

Source Code Comments

Concentration 1 on Second Major of Second Curriculum

Columns Comments for SGBSTDN_MAJR_CODE_CONC_222 (80)

Source Code Comments

Concentration 2 on Second Major of Second Curriculum

Columns Comments for SGBSTDN_MAJR_CODE_CONC_223 (81)

Source Code Comments

Concentration 3 on Second Major of Second Curriculum

Columns Comments for SGBSTDN_CURR_RULE_1 (82)

Source Code Comments

Curriculum 1 Rule reference

Columns Comments for SGBSTDN_CMJR_RULE_1_1 (83)

Source Code Comments

Curriculum 1 Major 1 Rule Reference

Columns Comments for SGBSTDN_CCON_RULE_11_1 (84)

Source Code Comments

Concentration 1, Major 1, Curriculum 1 Rule Reference

Columns Comments for SGBSTDN_CCON_RULE_11_2 (85)

Source Code Comments

Concentration 2, Major 1, Curriculum 1 Rule Reference

Columns Comments for SGBSTDN_CCON_RULE_11_3 (86)

Source Code Comments

Concentration 3, Major 1, Curriculum 1 Rule Reference

Columns Comments for SGBSTDN_CMJR_RULE_1_2 (87)

Source Code Comments

Major 2, Curriculum Rule Reference

Columns Comments for SGBSTDN_CCON_RULE_12_1 (88)

Source Code Comments

Concentration 1, Major 2, Curriculum 1 Rule Reference

Columns Comments for SGBSTDN_CCON_RULE_12_2 (89)

Source Code Comments

Concentration 2, Major 2, Curriculum 1 Rule Reference

Columns Comments for SGBSTDN_CCON_RULE_12_3 (90)

Source Code Comments

Concentration 3, Major 2, Curriculum 1 Rule Reference

Columns Comments for SGBSTDN_CMNR_RULE_1_1 (91)

Source Code Comments

Minor 1, Curriculum 1 Rule Reference

Columns Comments for SGBSTDN_CMNR_RULE_1_2 (92)

Source Code Comments

Minor 2, Curriculum 1 Rule Reference

Columns Comments for SGBSTDN_CURR_RULE_2 (93)

Source Code Comments

Curriculum 2 Rule Reference

Columns Comments for SGBSTDN_CMJR_RULE_2_1 (94)

Source Code Comments

Major 1, Curriculum 2 Rule Reference

Columns Comments for SGBSTDN_CCON_RULE_21_1 (95)

Source Code Comments

Concentration 1, Major 1, Curriculum 2 Rule Reference

Columns Comments for SGBSTDN_CCON_RULE_21_2 (96)

Source Code Comments

Concentration 2, Major 1, Curriculum 2 Rule Reference

Columns Comments for SGBSTDN_CCON_RULE_21_3 (97)

Source Code Comments

Concentration 3, Major 1, Curriculum 2 Rule Reference

Columns Comments for SGBSTDN_CMJR_RULE_2_2 (98)

Source Code Comments

Major 2, Curriculum 2 Rule Reference

Columns Comments for SGBSTDN_CCON_RULE_22_1 (99)

Source Code Comments

Concentration 1, Major 2, Curriculum 2 Rule Reference

Columns Comments for SGBSTDN_CCON_RULE_22_2 (100)

Source Code Comments

Concentration 2, Major 2, Curriculum 2 Rule Reference

Columns Comments for SGBSTDN_CCON_RULE_22_3 (101)

Source Code Comments

Concentration 3, Major 2, Curriculum 2 Rule Reference

Columns Comments for SGBSTDN_CMNR_RULE_2_1 (102)

Source Code Comments

Minor 1, Curriculum 2 Rule Reference

Columns Comments for SGBSTDN_CMNR_RULE_2_2 (103)

Source Code Comments

Minor 2, Curriculum 2 Rule Reference

Columns Comments for SGBSTDN_PREV_CODE (104)

Source Code Comments

General Student record Progress Evaluation code. This code overrides the code in SHRTTRM.

Columns Comments for SGBSTDN_TERM_CODE_PREV (105)

Source Code Comments

General Student record Progress Evaluation term. This is the term for which the progress evaluation code override becomes effective.

Columns Comments for SGBSTDN_CAST_CODE (106)

Source Code Comments

General Student record Combined Academic Standing code. This code overrides the code in SHRTTRM.

Columns Comments for SGBSTDN_TERM_CODE_CAST (107)

Source Code Comments

General Student record Combined Academic Standing term. This is the term for which the combined academic standing code override becomes effective.

Columns Comments for SGBSTDN_DATA_ORIGIN (108)

Source Code Comments

DATA SOURCE: Source system that generated the data

Columns Comments for SGBSTDN_USER_ID (109)

Source Code Comments

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

Table SGBUSER

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SGBUSER_PIDM SGBUSER_PIDM NUMBER(8,0) No *
SGBUSER_TERM_CODE SGBUSER_TERM_CODE VARCHAR2(6) No * *
SGBUSER_SUDA_CODE SGBUSER_SUDA_CODE VARCHAR2(15) Yes *
SGBUSER_SUDB_CODE SGBUSER_SUDB_CODE VARCHAR2(15) Yes *
SGBUSER_SUDC_CODE SGBUSER_SUDC_CODE VARCHAR2(15) Yes *
SGBUSER_SUDD_CODE SGBUSER_SUDD_CODE VARCHAR2(15) Yes *
SGBUSER_SUDE_CODE SGBUSER_SUDE_CODE VARCHAR2(15) Yes *
SGBUSER_SUDF_CODE SGBUSER_SUDF_CODE VARCHAR2(15) Yes *
SGBUSER_SUDG_CODE SGBUSER_SUDG_CODE VARCHAR2(15) Yes *
SGBUSER_SUDH_CODE SGBUSER_SUDH_CODE VARCHAR2(15) Yes *
SGBUSER_SUDI_CODE SGBUSER_SUDI_CODE VARCHAR2(15) Yes *
SGBUSER_SUDJ_CODE SGBUSER_SUDJ_CODE VARCHAR2(15) Yes *
SGBUSER_ACTIVITY_DATE SGBUSER_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
SGBUSER_TERM_CODE STVTERM_CODE STVTERM
SGBUSER_SUDA_CODE STVSUDA_CODE STVSUDA
SGBUSER_SUDB_CODE STVSUDB_CODE STVSUDB
SGBUSER_SUDC_CODE STVSUDC_CODE STVSUDC
SGBUSER_SUDD_CODE STVSUDD_CODE STVSUDD
SGBUSER_SUDE_CODE STVSUDE_CODE STVSUDE
SGBUSER_SUDF_CODE STVSUDF_CODE STVSUDF
SGBUSER_SUDG_CODE STVSUDG_CODE STVSUDG
SGBUSER_SUDH_CODE STVSUDH_CODE STVSUDH
SGBUSER_SUDI_CODE STVSUDI_CODE STVSUDI
SGBUSER_SUDJ_CODE STVSUDJ_CODE STVSUDJ

Index

Index Name Index Type Column Name
PK_SGBUSER Unique SGBUSER_PIDM
PK_SGBUSER Unique SGBUSER_TERM_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
get_all_sud C/C++ Function [F:\BANNER\C\SERSVRC.PC] Use(select )
get_suda_data C/C++ Function [F:\BANNER\C\SERSVRC.PC] Use(select )
get_sudb_data C/C++ Function [F:\BANNER\C\SERSVRC.PC] Use(select )
get_sudc_data C/C++ Function [F:\BANNER\C\SERSVRC.PC] Use(select )
get_sudd_data C/C++ Function [F:\BANNER\C\SERSVRC.PC] Use(select )
get_sude_data C/C++ Function [F:\BANNER\C\SERSVRC.PC] Use(select )
get_sudf_data C/C++ Function [F:\BANNER\C\SERSVRC.PC] Use(select )
get_sudg_data C/C++ Function [F:\BANNER\C\SERSVRC.PC] Use(select )
get_sudh_data C/C++ Function [F:\BANNER\C\SERSVRC.PC] Use(select )
SGBUSER SYNONYM S4B70.PUBLIC Rely on ()
SGBUSER Forms DataBlock BANNER7_FORMS.SGAUSDF Rely on () Use(insert,update,delete,select )
SGBUSER Forms DataBlock BANNER7_FORMS_10G.SGAUSDF Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_SGBUSER INDEX S4B70.SATURN Rely on ()
STVSUDA TABLE S4B70.SATURN Refer( No Action )
STVSUDB TABLE S4B70.SATURN Refer( No Action )
STVSUDC TABLE S4B70.SATURN Refer( No Action )
STVSUDD TABLE S4B70.SATURN Refer( No Action )
STVSUDE TABLE S4B70.SATURN Refer( No Action )
STVSUDF TABLE S4B70.SATURN Refer( No Action )
STVSUDG TABLE S4B70.SATURN Refer( No Action )
STVSUDH TABLE S4B70.SATURN Refer( No Action )
STVSUDI TABLE S4B70.SATURN Refer( No Action )
STVSUDJ TABLE S4B70.SATURN Refer( No Action )
STVTERM TABLE S4B70.SATURN Refer( No Action )

Comments

Source Code Comments

Student Institutional Reporting Requirements Table

Columns Comments for SGBUSER_PIDM (1)

Source Code Comments

Person Internal Identification Number

Columns Comments for SGBUSER_TERM_CODE (2)

Source Code Comments

Term Code

Columns Comments for SGBUSER_SUDA_CODE (3)

Source Code Comments

Institution Defined Reporting Element One Code

Columns Comments for SGBUSER_SUDB_CODE (4)

Source Code Comments

Institution Defined Reporting Element Two Code

Columns Comments for SGBUSER_SUDC_CODE (5)

Source Code Comments

Institution Defined Reporting Element Three Code

Columns Comments for SGBUSER_SUDD_CODE (6)

Source Code Comments

Institution Defined Reporting Element Four Code

Columns Comments for SGBUSER_SUDE_CODE (7)

Source Code Comments

Institution Defined Reporting Element Five Code

Columns Comments for SGBUSER_SUDF_CODE (8)

Source Code Comments

Institution Defined Reporting Element Six Code

Columns Comments for SGBUSER_SUDG_CODE (9)

Source Code Comments

Institution Defined Reporting Element Seven Code

Columns Comments for SGBUSER_SUDH_CODE (10)

Source Code Comments

Institution Defined Reporting Element Eight Code

Columns Comments for SGBUSER_SUDI_CODE (11)

Source Code Comments

Institution Defined Reporting Element Nine Code

Columns Comments for SGBUSER_SUDJ_CODE (12)

Source Code Comments

Institution Defined Reporting Element Ten Code

Columns Comments for SGBUSER_ACTIVITY_DATE (13)

Source Code Comments

The Activity Date

Table SGRACMT

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SGRACMT_PIDM SGRACMT_PIDM NUMBER(8,0) No
SGRACMT_TERM_CODE_EFF SGRACMT_TERM_CODE_EFF VARCHAR2(6) No *
SGRACMT_CATEGORY SGRACMT_CATEGORY VARCHAR2(1) No
SGRACMT_GTYP_CODE SGRACMT_GTYP_CODE VARCHAR2(6) No *
SGRACMT_SEQNO SGRACMT_SEQNO NUMBER(23,20) Yes
SGRACMT_TEXT SGRACMT_TEXT VARCHAR2(60) Yes
SGRACMT_ORIG_CODE SGRACMT_ORIG_CODE VARCHAR2(4) Yes *
SGRACMT_ORIG_DATE SGRACMT_ORIG_DATE DATE Yes
SGRACMT_ACTIVITY_DATE SGRACMT_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
SGRACMT_GTYP_CODE STVGTYP_CODE STVGTYP
SGRACMT_ORIG_CODE STVORIG_CODE STVORIG
SGRACMT_TERM_CODE_EFF STVTERM_CODE STVTERM

Index

Index Name Index Type Column Name
SGRACMT_KEY_INDEX SGRACMT_PIDM
SGRACMT_KEY_INDEX SGRACMT_TERM_CODE_EFF
SGRACMT_KEY_INDEX SGRACMT_CATEGORY
SGRACMT_KEY_INDEX SGRACMT_GTYP_CODE
SGRACMT_KEY_INDEX SGRACMT_SEQNO

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
SGRACMT SYNONYM S4B70.PUBLIC Rely on ()
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SGAASST.SGRACMT.SGRACMT_ORIG_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SGAASST.SGRACMT.SGRACMT_ORIG_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SGAASST.SGRACMT.SGRACMT_TEXT Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SGAASST.SGRACMT.SGRACMT_TEXT Use(select )
END_ACMT_TERM Forms Trigger BANNER7_FORMS_10G.SGAASST.SGRACMT Use(insert )
END_ACMT_TERM Forms Trigger BANNER7_FORMS.SGAASST.SGRACMT Use(insert )
FILL_TERMS Forms Trigger BANNER7_FORMS_10G.SGAASST.SGRACMT Use(select )
FILL_TERMS Forms Trigger BANNER7_FORMS.SGAASST.SGRACMT Use(select )
INSERT_TRIG Forms Trigger BANNER7_FORMS_10G.SGAASST.SGRACMT Use(insert,select )
INSERT_TRIG Forms Trigger BANNER7_FORMS.SGAASST.SGRACMT Use(insert,select )
PRE-DELETE Forms Trigger BANNER7_FORMS_10G.SGAASST.SGRASSI Use(select )
PRE-DELETE Forms Trigger BANNER7_FORMS.SGAASST.SGRASSI Use(select )
PRE-INSERT Forms Trigger BANNER7_FORMS_10G.SGAASST.SGRACMT Use(select )
PRE-INSERT Forms Trigger BANNER7_FORMS.SGAASST.SGRACMT Use(select )
PRE-QUERY Forms Trigger BANNER7_FORMS_10G.SGAASST.SGRACMT Use(select )
PRE-QUERY Forms Trigger BANNER7_FORMS.SGAASST.SGRACMT Use(select )
SGRACMT Forms DataBlock BANNER7_FORMS_10G.SGAASST Rely on () Use(insert,update,delete,select )
SGRACMT Forms DataBlock BANNER7_FORMS.SGAASST Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
SGRACMT_KEY_INDEX INDEX S4B70.SATURN Rely on ()
STVGTYP TABLE S4B70.SATURN Refer( No Action )
STVORIG TABLE S4B70.SATURN Refer( No Action )
STVTERM TABLE S4B70.SATURN Refer( No Action )

Comments

Source Code Comments

Assistantship/Fellowship/Internship comment table.

Columns Comments for SGRACMT_PIDM (1)

Source Code Comments

Internal identification number of the person being assigned a comment in an assistantship, fellowship, or internship.

Columns Comments for SGRACMT_TERM_CODE_EFF (2)

Source Code Comments

This field defines the effective term associated with assistantship/fellowship/internship comments.

Columns Comments for SGRACMT_CATEGORY (3)

Source Code Comments

This field is used to determine whethor or not the comments are related to an assistantship, a fellowship, or an internship.

Columns Comments for SGRACMT_GTYP_CODE (4)

Source Code Comments

This field is used to specify the type of assistantship, fellowship, or internship being commented.

Columns Comments for SGRACMT_SEQNO (5)

Source Code Comments

This field identifies an internal sequence number associated with each lineof text. This field is not displayed.

Columns Comments for SGRACMT_TEXT (6)

Source Code Comments

Assistantship/Fellowship/Internship comments are maintained in these records. An unlimited numberof comment records can be maintained in this block.

Columns Comments for SGRACMT_ORIG_CODE (7)

Source Code Comments

This field is used to specify the comment originator code.

Columns Comments for SGRACMT_ORIG_DATE (8)

Source Code Comments

This field is used to specify the date comment was originated.

Columns Comments for SGRACMT_ACTIVITY_DATE (9)

Source Code Comments

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

Table SGRADVR

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SGRADVR_PIDM SGRADVR_PIDM NUMBER(8,0) No
SGRADVR_TERM_CODE_EFF SGRADVR_TERM_CODE_EFF VARCHAR2(6) No *
SGRADVR_ADVR_PIDM SGRADVR_ADVR_PIDM NUMBER(8,0) Yes *
SGRADVR_ADVR_CODE SGRADVR_ADVR_CODE VARCHAR2(4) Yes *
SGRADVR_PRIM_IND SGRADVR_PRIM_IND VARCHAR2(1) Yes
SGRADVR_ACTIVITY_DATE SGRADVR_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
SGRADVR_TERM_CODE_EFF STVTERM_CODE STVTERM
SGRADVR_ADVR_CODE STVADVR_CODE STVADVR
SGRADVR_ADVR_PIDM SPRIDEN_PIDM SPRIDEN

Index

Index Name Index Type Column Name
SGRADVR_ADVR_PIDM_INDEX SGRADVR_ADVR_PIDM
SGRADVR_KEY_INDEX SGRADVR_PIDM
SGRADVR_KEY_INDEX SGRADVR_TERM_CODE_EFF

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
smrbcmp.pc C/C++ File N/A Use(select )
chkadvisor C/C++ Function [F:\BANNER\C\SHRTPOP.PC] Use(select )
deladvr C/C++ Function [F:\BANNER\C\SGPSTDN.PC] Use(delete )
get_header_info C/C++ Function [F:\BANNER\C\SMRCRLT.PC] Use(select )
get_header_info2 C/C++ Function [F:\BANNER\C\SMRCRLT.PC] Use(select )
seladvr C/C++ Function [F:\BANNER\C\SGPSTDN.PC] Use(select )
seladvr1 C/C++ Function [F:\BANNER\C\SGPSTDN.PC] Use(select )
selmacro C/C++ Function [F:\BANNER\C\SHRTPOP.PC] Use(select )
selmacro1 C/C++ Function [F:\BANNER\C\SHRTPOP.PC] Use(select )
SGRADVR SYNONYM S4B70.PUBLIC Rely on ()
AS_ADVISOR VIEW S4B70.BANINST1 Use(select )
SGVSTDN VIEW S4B70.BANINST1 Use(select )
KEY-DUP-ITEM Forms Trigger BANNER7_FORMS.SGAADVR.SGRADVR_CTRL_BLOCK.SGRADVR_TERM_CODE_FROM Use(insert )
KEY-DUP-ITEM Forms Trigger BANNER7_FORMS_10G.SGAADVR.SGRADVR_CTRL_BLOCK.SGRADVR_TERM_CODE_FROM Use(insert )
KEY-DUPREC Forms Trigger BANNER7_FORMS.SGAADVR.SGRADVR_CTRL_BLOCK.SGRADVR_TERM_CODE_FROM Use(insert,select )
KEY-DUPREC Forms Trigger BANNER7_FORMS_10G.SGAADVR.SGRADVR_CTRL_BLOCK.SGRADVR_TERM_CODE_FROM Use(insert,select )
CHECK_DUPLICATE_UPDATE Forms Trigger BANNER7_FORMS.SGAADVR Use(select )
CHECK_DUPLICATE_UPDATE Forms Trigger BANNER7_FORMS_10G.SGAADVR Use(select )
CHECK_PRIMARY_FLAG Forms Trigger BANNER7_FORMS.SGAADVR Use(select )
CHECK_PRIMARY_FLAG Forms Trigger BANNER7_FORMS_10G.SGAADVR Use(select )
CHECK_DUPLICATE Forms Trigger BANNER7_FORMS.SGAADVR.SGRADVR Use(select )
CHECK_DUPLICATE Forms Trigger BANNER7_FORMS_10G.SGAADVR.SGRADVR Use(select )
KEY_DELREC Forms Trigger BANNER7_FORMS_10G.SGASTDN.SGBSTDN Use(select )
KEY_DELREC Forms Trigger BANNER7_FORMS.SGASTDN.SGBSTDN Use(select )
PRE-INSERT Forms Trigger BANNER7_FORMS.SGAADVR.SGRADVR Use(delete )
PRE-INSERT Forms Trigger BANNER7_FORMS_10G.SGAADVR.SGRADVR Use(delete )
PRE-QUERY Forms Trigger BANNER7_FORMS.SGAADVR.SGRADVR Use(select )
PRE-QUERY Forms Trigger BANNER7_FORMS_10G.SGAADVR.SGRADVR Use(select )
A_GET_ADVR Forms Procedure BANNER7_FORMS_10G.SFARQST Use(select )
A_GET_ADVR Forms Procedure BANNER7_FORMS.SFARQST Use(select )
A_GET_ADVR Forms Procedure BANNER7_FORMS.SFAREGS Use(select )
A_GET_ADVR Forms Procedure BANNER7_FORMS_10G.SFAREGS Use(select )
S$_GET_ADVR Forms Procedure BANNER7_FORMS.SOQRPLS Use(select )
S$_GET_ADVR Forms Procedure BANNER7_FORMS_10G.SOQRPLS Use(select )
F_CONCAT_SGRADVR FUNCTION S4B70.BANINST1 Use(select )
F_FACULTY_ADVISING_IND FUNCTION S4B70.BANINST1 Use(select )
ADVR_REC Package Type S4B70.BANINST1.SOKLIBS Rely on ()
P_GETADVRINFO Package procedure S4B70.BANINST1.BWCKGSTU Use(select )
F_CHECKADVISORRELATION Package function S4B70.BANINST1.BWLKILIB Use(select )
F_VERIFYCRNADVRPROCESS Package function S4B70.BANINST1.BWLKILIB Use(select )
P_DISPADVISEES Package procedure S4B70.BANINST1.BWLKADVR Rely on ()
P_DISPADVISEES Package procedure S4B70.BANINST1.BWLKADVR Use(select )
P_FACADVRSECURITY Package procedure S4B70.BANINST1.BWLKSECR Use(select )
P_GET_STUDENT_ADVISORS Package procedure S4B70.BANINST1.BWSCBREF Use(select )
P_GET_STUDENT_ADVISORS Package procedure S4B70.BANINST1.BWSCJREF Use(select )
P_OPEN_STUDENT_LIST_C Package procedure S4B70.BANINST1.BWLKOIDS Use(select )
ADVISORC Package cursor S4B70.BANINST1.SOKLIBS Use(select )
F_GETADVRPIDM Package function S4B70.BANINST1.BWCKSMLT Rely on ()
F_GETADVRPIDM Package function S4B70.BANINST1.BWCKCAPP Rely on ()
F_GETADVRPIDM Package function S4B70.BANINST1.BWCKSMLT Use(select )
F_GETADVRPIDM Package function S4B70.BANINST1.BWCKCAPP Use(select )
F_GET_END_SGRADVR_TERM Package function S4B70.BANINST1.SOKODSF Use(select )
F_GET_SGRADVR_ROWID Package function S4B70.BANINST1.SOKODSF Use(select )
F_STUDENT_ID_TYPE Package function S4B70.BANINST1.BWLCXCHN Use(select )
SGRADVR Forms DataBlock BANNER7_FORMS.SGAADVR Rely on () Use(insert,update,delete,select )
SGRADVR Forms DataBlock BANNER7_FORMS_10G.SGAADVR Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
SGRADVR_ADVR_PIDM_INDEX INDEX S4B70.SATURN Rely on ()
SGRADVR_KEY_INDEX INDEX S4B70.SATURN Rely on ()
SPRIDEN TABLE S4B70.SATURN Join
STVADVR TABLE S4B70.SATURN Refer( No Action )
STVTERM TABLE S4B70.SATURN Refer( No Action )

Comments

Source Code Comments

Multiple Advisors Repeating Table

Columns Comments for SGRADVR_PIDM (1)

Source Code Comments

Pidm for student

Columns Comments for SGRADVR_TERM_CODE_EFF (2)

Source Code Comments

The effective term code

Columns Comments for SGRADVR_ADVR_PIDM (3)

Source Code Comments

Pidm for advisor

Columns Comments for SGRADVR_ADVR_CODE (4)

Source Code Comments

Advisor type code

Columns Comments for SGRADVR_PRIM_IND (5)

Source Code Comments

Primary Indicator

Columns Comments for SGRADVR_ACTIVITY_DATE (6)

Source Code Comments

The date the record was created or last updated.

Table SGRASSI

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SGRASSI_PIDM SGRASSI_PIDM NUMBER(8,0) No *
SGRASSI_TERM_CODE_EFF SGRASSI_TERM_CODE_EFF VARCHAR2(6) No * *
SGRASSI_CATEGORY SGRASSI_CATEGORY VARCHAR2(1) No *
SGRASSI_GTYP_CODE SGRASSI_GTYP_CODE VARCHAR2(6) No * *
SGRASSI_SOFF_CODE SGRASSI_SOFF_CODE VARCHAR2(6) Yes *
SGRASSI_STIPEND SGRASSI_STIPEND NUMBER(7,2) Yes
SGRASSI_FTE_VALUE SGRASSI_FTE_VALUE NUMBER(5,2) Yes
SGRASSI_MIN_CRSE_LOAD SGRASSI_MIN_CRSE_LOAD NUMBER(9,3) Yes
SGRASSI_MAX_CRSE_LOAD SGRASSI_MAX_CRSE_LOAD NUMBER(9,3) Yes
SGRASSI_REQUIRED_HRS SGRASSI_REQUIRED_HRS NUMBER(11,3) Yes
SGRASSI_GSTA_CODE SGRASSI_GSTA_CODE VARCHAR2(2) Yes *
SGRASSI_GSTA_DATE SGRASSI_GSTA_DATE DATE Yes
SGRASSI_DEGC_CODE SGRASSI_DEGC_CODE VARCHAR2(6) Yes *
SGRASSI_LEVL_CODE SGRASSI_LEVL_CODE VARCHAR2(2) Yes *
SGRASSI_COLL_CODE SGRASSI_COLL_CODE VARCHAR2(2) Yes *
SGRASSI_DEPT_CODE SGRASSI_DEPT_CODE VARCHAR2(4) Yes *
SGRASSI_MAJR_CODE SGRASSI_MAJR_CODE VARCHAR2(4) Yes *
SGRASSI_PIDM_SUPERVISOR SGRASSI_PIDM_SUPERVISOR NUMBER(8,0) Yes
SGRASSI_ACTIVITY_DATE SGRASSI_ACTIVITY_DATE DATE No
SGRASSI_PROGRAM SGRASSI_PROGRAM VARCHAR2(12) Yes
SGRASSI_TERM_CODE_CTLG SGRASSI_TERM_CODE_CTLG VARCHAR2(6) Yes *

Foreign Key information

Column name is Foreign Key For Column on Table
SGRASSI_SOFF_CODE STVSOFF_CODE STVSOFF
SGRASSI_LEVL_CODE STVLEVL_CODE STVLEVL
SGRASSI_GTYP_CODE STVGTYP_CODE STVGTYP
SGRASSI_TERM_CODE_EFF STVTERM_CODE STVTERM
SGRASSI_TERM_CODE_CTLG STVTERM_CODE STVTERM
SGRASSI_COLL_CODE STVCOLL_CODE STVCOLL
SGRASSI_MAJR_CODE STVMAJR_CODE STVMAJR
SGRASSI_DEGC_CODE STVDEGC_CODE STVDEGC
SGRASSI_DEPT_CODE STVDEPT_CODE STVDEPT
SGRASSI_GSTA_CODE STVGSTA_CODE STVGSTA

Index

Index Name Index Type Column Name
PK_SGRASSI Unique SGRASSI_PIDM
PK_SGRASSI Unique SGRASSI_TERM_CODE_EFF
PK_SGRASSI Unique SGRASSI_CATEGORY
PK_SGRASSI Unique SGRASSI_GTYP_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
SGRASSI SYNONYM S4B70.PUBLIC Rely on ()
SPRIDEN TABLE S4B70.SATURN Join
SGVASSI VIEW S4B70.BANINST1 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SGAASST.SGRASSI.SGRASSI_PROGRAM Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SGAASST.SGRASSI.SGRASSI_SOFF_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SGAASST.SGRASSI.SGRASSI_COLL_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SGAASST.SGRASSI.SGRASSI_GSTA_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SGAASST.SGRASSI.SGRASSI_DEPT_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SGAASST.SGRASSI.SGRASSI_DEGC_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SGAASST.SGRASSI.SGRASSI_TERM_CODE_CTLG Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SGAASST.SGRASSI.SGRASSI_LEVL_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SGAASST.SGRASSI.SGRASSI_SOFF_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SGAASST.SGRASSI.SGRASSI_PROGRAM Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SGAASST.SGRASSI.SGRASSI_MAJR_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SGAASST.SGRASSI.SGRASSI_LEVL_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SGAASST.SGRASSI.SGRASSI_GSTA_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SGAASST.SGRASSI.SGRASSI_DEPT_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SGAASST.SGRASSI.SGRASSI_DEGC_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SGAASST.SGRASSI.SGRASSI_COLL_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SGAASST.SGRASSI.SGRASSI_MAJR_CODE Use(select )
END_ASSI_TERM Forms Trigger BANNER7_FORMS_10G.SGAASST.SGRASSI Use(insert )
END_ASSI_TERM Forms Trigger BANNER7_FORMS.SGAASST.SGRASSI Use(insert )
FILL_TERMS Forms Trigger BANNER7_FORMS_10G.SGAASST.SGRASSI Use(select )
FILL_TERMS Forms Trigger BANNER7_FORMS.SGAASST.SGRASSI Use(select )
INSERT_TRIG Forms Trigger BANNER7_FORMS_10G.SGAASST.SGRASSI Use(insert,select )
INSERT_TRIG Forms Trigger BANNER7_FORMS.SGAASST.SGRASSI Use(insert,select )
PRE-INSERT Forms Trigger BANNER7_FORMS_10G.SGAASST.SGRACMT Use(select )
PRE-INSERT Forms Trigger BANNER7_FORMS_10G.SGAASST.SGRASST Use(select )
PRE-INSERT Forms Trigger BANNER7_FORMS.SGAASST.SGRACMT Use(select )
PRE-INSERT Forms Trigger BANNER7_FORMS.SGAASST.SGRASST Use(select )
PRE-QUERY Forms Trigger BANNER7_FORMS_10G.SGAASST.SGRASSI Use(select )
PRE-QUERY Forms Trigger BANNER7_FORMS.SGAASST.SGRASSI Use(select )
SGRASSI Forms DataBlock BANNER7_FORMS_10G.SGAASST Rely on () Use(insert,update,delete,select )
SGRASSI Forms DataBlock BANNER7_FORMS.SGAASST Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_SGRASSI INDEX S4B70.SATURN Rely on ()
STVCOLL TABLE S4B70.SATURN Refer( No Action )
STVDEGC TABLE S4B70.SATURN Refer( No Action )
STVDEPT TABLE S4B70.SATURN Refer( No Action )
STVGSTA TABLE S4B70.SATURN Refer( No Action )
STVGTYP TABLE S4B70.SATURN Refer( No Action )
STVLEVL TABLE S4B70.SATURN Refer( No Action )
STVMAJR TABLE S4B70.SATURN Refer( No Action )
STVSOFF TABLE S4B70.SATURN Refer( No Action )
STVTERM TABLE S4B70.SATURN Refer( No Action )

Comments

Source Code Comments

Assistantship/Fellowship/Internship information table.

Columns Comments for SGRASSI_PIDM (1)

Source Code Comments

Internal identification number of the person being assigned an assistantship, fellowship, or internship.

Columns Comments for SGRASSI_TERM_CODE_EFF (2)

Source Code Comments

This field defines the effective term associated with assistantship/fellowship/internship information.

Columns Comments for SGRASSI_CATEGORY (3)

Source Code Comments

This field is used to determine whethor or not the information is related to an assistantship, a fellowship, or an internship.

Columns Comments for SGRASSI_GTYP_CODE (4)

Source Code Comments

This field is used to specify the type of assistantship, fellowship, or internship being tracked.

Columns Comments for SGRASSI_SOFF_CODE (5)

Source Code Comments

This field contains the source of funds code used for the assistantship, fellowship, or internship.

Columns Comments for SGRASSI_STIPEND (6)

Source Code Comments

This field contains the amount of money the person receives from his/her assistantship, fellowship, or internship.

Columns Comments for SGRASSI_FTE_VALUE (7)

Source Code Comments

This field contains the FTE for the assistantship, fellowship, or internship.

Columns Comments for SGRASSI_MIN_CRSE_LOAD (8)

Source Code Comments

This field contains the minimum course load for the assistantship, fellowship, or internship.

Columns Comments for SGRASSI_MAX_CRSE_LOAD (9)

Source Code Comments

This field contains the maximum course load for the assistantship, fellowship, or internship.

Columns Comments for SGRASSI_REQUIRED_HRS (10)

Source Code Comments

This field contains the reqquired credit hours for the assistantship, fellowship, or internship.

Columns Comments for SGRASSI_GSTA_CODE (11)

Source Code Comments

This field contains the status of the type of the assistantship, fellowship, or internship being tracked.

Columns Comments for SGRASSI_GSTA_DATE (12)

Source Code Comments

This field contains the status date of the type of the assistantship, fellowship, or internship being tracked.

Columns Comments for SGRASSI_DEGC_CODE (13)

Source Code Comments

This field contains the degree code associated with the type of assistantship, fellowship, or internship.

Columns Comments for SGRASSI_LEVL_CODE (14)

Source Code Comments

This field contains the level code associated with the type of assistantship, fellowship, or internship.

Columns Comments for SGRASSI_COLL_CODE (15)

Source Code Comments

This field contains the college code associated with the type of assistantship, fellowship, or internship.

Columns Comments for SGRASSI_DEPT_CODE (16)

Source Code Comments

This field contains the department code associated with the type of assistantship, fellowship, or internship.

Columns Comments for SGRASSI_MAJR_CODE (17)

Source Code Comments

This field contains the major code associated with the type of assistantship, fellowship, or internship.

Columns Comments for SGRASSI_PIDM_SUPERVISOR (18)

Source Code Comments

Internal identification number of the person supervising anassistantship, fellowship, or internship type.

Columns Comments for SGRASSI_ACTIVITY_DATE (19)

Source Code Comments

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

Columns Comments for SGRASSI_PROGRAM (20)

Source Code Comments

Curriculum Program Code

Columns Comments for SGRASSI_TERM_CODE_CTLG (21)

Source Code Comments

Curriculum Catalog Term

Table SGRASST

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SGRASST_PIDM SGRASST_PIDM NUMBER(8,0) No
SGRASST_TERM_CODE_EFF SGRASST_TERM_CODE_EFF VARCHAR2(6) No *
SGRASST_CATEGORY SGRASST_CATEGORY VARCHAR2(1) No
SGRASST_GTYP_CODE SGRASST_GTYP_CODE VARCHAR2(6) No *
SGRASST_TASK_CODE SGRASST_TASK_CODE VARCHAR2(6) Yes *
SGRASST_PIDM_COORDINATOR SGRASST_PIDM_COORDINATOR NUMBER(8,0) Yes
SGRASST_ACTIVITY_DATE SGRASST_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
SGRASST_GTYP_CODE STVGTYP_CODE STVGTYP
SGRASST_TERM_CODE_EFF STVTERM_CODE STVTERM
SGRASST_TASK_CODE STVTASK_CODE STVTASK

Index

Index Name Index Type Column Name
SGRASST_KEY_INDEX Unique SGRASST_PIDM
SGRASST_KEY_INDEX Unique SGRASST_TERM_CODE_EFF
SGRASST_KEY_INDEX Unique SGRASST_CATEGORY
SGRASST_KEY_INDEX Unique SGRASST_GTYP_CODE
SGRASST_KEY_INDEX Unique SGRASST_TASK_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
SGRASST SYNONYM S4B70.PUBLIC Rely on ()
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SGAASST.SGRASST.SGRASST_TASK_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SGAASST.SGRASST.SGRASST_TASK_CODE Use(select )
END_ASST_TERM Forms Trigger BANNER7_FORMS_10G.SGAASST.SGRASST Use(insert )
END_ASST_TERM Forms Trigger BANNER7_FORMS.SGAASST.SGRASST Use(insert )
FILL_TERMS Forms Trigger BANNER7_FORMS_10G.SGAASST.SGRASST Use(select )
FILL_TERMS Forms Trigger BANNER7_FORMS.SGAASST.SGRASST Use(select )
INSERT_TRIG Forms Trigger BANNER7_FORMS_10G.SGAASST.SGRASST Use(insert,select )
INSERT_TRIG Forms Trigger BANNER7_FORMS.SGAASST.SGRASST Use(insert,select )
PRE-DELETE Forms Trigger BANNER7_FORMS_10G.SGAASST.SGRASSI Use(select )
PRE-DELETE Forms Trigger BANNER7_FORMS.SGAASST.SGRASSI Use(select )
PRE-QUERY Forms Trigger BANNER7_FORMS_10G.SGAASST.SGRASST Use(select )
PRE-QUERY Forms Trigger BANNER7_FORMS.SGAASST.SGRASST Use(select )
SGRASST Forms DataBlock BANNER7_FORMS_10G.SGAASST Rely on () Use(insert,update,delete,select )
SGRASST Forms DataBlock BANNER7_FORMS.SGAASST Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
SGRASST_KEY_INDEX INDEX S4B70.SATURN Rely on ()
STVGTYP TABLE S4B70.SATURN Refer( No Action )
STVTASK TABLE S4B70.SATURN Refer( No Action )
STVTERM TABLE S4B70.SATURN Refer( No Action )

Comments

Source Code Comments

Assistantship/Fellowship/Internship task/duties table.

Columns Comments for SGRASST_PIDM (1)

Source Code Comments

Internal identification number of the person being assigned a task/duty in an assistantship, fellowship, or internship.

Columns Comments for SGRASST_TERM_CODE_EFF (2)

Source Code Comments

This field defines the effective term associated with assistantship/fellowship/internship information.

Columns Comments for SGRASST_CATEGORY (3)

Source Code Comments

This field is used to determine whethor or not the task/duty is related to an assistantship, a fellowship, or an internship.

Columns Comments for SGRASST_GTYP_CODE (4)

Source Code Comments

This field is used to specify the type of assistantship, fellowship, or internship being tracked.

Columns Comments for SGRASST_TASK_CODE (5)

Source Code Comments

This field contains the task code associated with the type of assistantship, fellowship, or internship.

Columns Comments for SGRASST_PIDM_COORDINATOR (6)

Source Code Comments

Internal identification number of the person coordinating a task/duty for an assistantship, fellowship, or internship.

Columns Comments for SGRASST_ACTIVITY_DATE (7)

Source Code Comments

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

Table SGRCATT

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SGRCATT_SEQ_NO SGRCATT_SEQ_NO NUMBER(3,0) No *
SGRCATT_ATTS_CODE SGRCATT_ATTS_CODE VARCHAR2(4) No * *
SGRCATT_ACTIVITY_DATE SGRCATT_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
SGRCATT_ATTS_CODE STVATTS_CODE STVATTS

Index

Index Name Index Type Column Name
PK_SGRCATT Unique SGRCATT_SEQ_NO
PK_SGRCATT Unique SGRCATT_ATTS_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
select_student_class C/C++ Function [F:\BANNER\C\SHREDIY.PC] Use(select )
select_student_class2 C/C++ Function [F:\BANNER\C\SHREDIY.PC] Use(select )
CAA10 Cobol Paragraph [F:\banner\cobol].SCTH1000.AAA Use(select )
CAA9 Cobol Paragraph [F:\banner\cobol].SCTH1000.AAA Use(select )
PRE-DELETE Forms Trigger BANNER7_FORMS.SGACLSR.SGRCLSR Use(delete )
PRE-DELETE Forms Trigger BANNER7_FORMS_10G.SGACLSR.SGRCLSR Use(delete )
S$_CLASS_CALC Forms Procedure BANNER7_FORMS.SOQRPLS Use(select )
S$_CLASS_CALC Forms Procedure BANNER7_FORMS_10G.SOQRPLS Use(select )
F_CLASS_CALC_FNC FUNCTION S4B70.BANINST1 Use(select )
P_CLASS_CALC Package procedure S4B70.BANINST1.SOKLIBS Use(select )
F_CLASS_CODE Package function S4B70.BANINST1.SGKCLAS Use(select )
SGRCATT SYNONYM S4B70.PUBLIC Rely on ()
SGRCATT Forms DataBlock BANNER7_FORMS.SGACLSR Rely on () Use(insert,update,delete,select )
SGRCATT Forms DataBlock BANNER7_FORMS_10G.SGACLSR Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_SGRCATT INDEX S4B70.SATURN Rely on ()
STVATTS TABLE S4B70.SATURN Refer( No Action )

Comments

Source Code Comments

Class Attribute Repeating Table.

Columns Comments for SGRCATT_SEQ_NO (1)

Source Code Comments

The classification rule attribute sequence number.

Columns Comments for SGRCATT_ATTS_CODE (2)

Source Code Comments

The attributes for the class and level.

Columns Comments for SGRCATT_ACTIVITY_DATE (3)

Source Code Comments

The date the record was last updated.

Table SGRCHRT

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SGRCHRT_PIDM SGRCHRT_PIDM NUMBER(8,0) No
SGRCHRT_TERM_CODE_EFF SGRCHRT_TERM_CODE_EFF VARCHAR2(6) No *
SGRCHRT_CHRT_CODE SGRCHRT_CHRT_CODE VARCHAR2(10) Yes *
SGRCHRT_ACTIVE_IND SGRCHRT_ACTIVE_IND VARCHAR2(1) Yes
SGRCHRT_CREA_CODE SGRCHRT_CREA_CODE VARCHAR2(4) Yes *
SGRCHRT_ACTIVITY_DATE SGRCHRT_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
SGRCHRT_CREA_CODE STVCREA_CODE STVCREA
SGRCHRT_TERM_CODE_EFF STVTERM_CODE STVTERM
SGRCHRT_CHRT_CODE STVCHRT_CODE STVCHRT

Index

Index Name Index Type Column Name
SGRCHRT_KEY_INDEX Unique SGRCHRT_PIDM
SGRCHRT_KEY_INDEX Unique SGRCHRT_TERM_CODE_EFF
SGRCHRT_KEY_INDEX Unique SGRCHRT_CHRT_CODE
SGRCHRT_KEY_INDEX2 SGRCHRT_TERM_CODE_EFF
SGRCHRT_KEY_INDEX2 SGRCHRT_CHRT_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
main C/C++ Function [F:\BANNER\C\SGRCHRT.PC] Use()
check_all_chrts C/C++ Function [F:\BANNER\C\SGRKNOW.PC] Use(select )
check_student_cohort C/C++ Function [F:\BANNER\C\SGRCHRT.PC] Use(select )
create_student_cohort C/C++ Function [F:\BANNER\C\SGRCHRT.PC] Use(insert )
delchrt C/C++ Function [F:\BANNER\C\SGPSTDN.PC] Use(delete )
get_cohort C/C++ Function [F:\BANNER\C\SHRIGRS.PC] Use(select )
get_inactive C/C++ Function [F:\BANNER\C\SHRIGRS.PC] Use(select )
get_student C/C++ Function [F:\BANNER\C\SGRKNOW.PC] Use(select )
get_student_sport C/C++ Function [F:\BANNER\C\SGRKNOW.PC] Use(select )
get_student_sport_aid C/C++ Function [F:\BANNER\C\SGRKNOW.PC] Use(select )
selchrt C/C++ Function [F:\BANNER\C\SGPSTDN.PC] Use(select )
selchrt1 C/C++ Function [F:\BANNER\C\SGPSTDN.PC] Use(select )
SGRCHRT SYNONYM S4B70.PUBLIC Rely on ()
AS_STUDENT_COHORT VIEW S4B70.BANINST1 Use(select )
SGVCHRT VIEW S4B70.BANINST1 Use(select )
SHVTER1 VIEW S4B70.BANINST1 Use(select )
SHVYEA1 VIEW S4B70.BANINST1 Use(select )
SOVCHRT VIEW S4B70.BANINST1 Use(select )
SPVTER1 VIEW S4B70.BANINST1 Use(select )
SPVYEA1 VIEW S4B70.BANINST1 Use(select )
SGRCHRT_RG Forms Record Group BANNER7_FORMS.SHAINST Use(select )
SGRCHRT_RG Forms Record Group BANNER7_FORMS_10G.SHAINST Use(select )
END_CHRT_TERM Forms Trigger BANNER7_FORMS_10G.SGASADD.SGRCHRT Use(insert )
END_CHRT_TERM Forms Trigger BANNER7_FORMS.SGASADD.SGRCHRT Use(insert )
INSERT_TRIG Forms Trigger BANNER7_FORMS_10G.SGASADD.SGRCHRT Lock
INSERT_TRIG Forms Trigger BANNER7_FORMS.SGASADD.SGRCHRT Lock
KEY-DELREC Forms Trigger BANNER7_FORMS_10G.SGASADD.SGRCHRT Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS.SGASADD.SGRCHRT Use(select )
KEY_DELREC Forms Trigger BANNER7_FORMS_10G.SGASTDN.SGBSTDN Use(select )
KEY_DELREC Forms Trigger BANNER7_FORMS.SGASTDN.SGBSTDN Use(select )
POST-INSERT Forms Trigger BANNER7_FORMS.SHAINST.SHRTTRM Use(select )
POST-INSERT Forms Trigger BANNER7_FORMS_10G.SHAINST.SHRTTRM Use(select )
PRE-INSERT Forms Trigger BANNER7_FORMS_10G.SGASADD.SGRCHRT Use(delete )
PRE-INSERT Forms Trigger BANNER7_FORMS.SGASADD.SGRCHRT Use(delete )
PRE-QUERY Forms Trigger BANNER7_FORMS_10G.SGASADD.SGRCHRT Use(select )
PRE-QUERY Forms Trigger BANNER7_FORMS.SGASADD.SGRCHRT Use(select )
F_CONCAT_SGRCHRT FUNCTION S4B70.BANINST1 Use(select )
F_SGRCHRT_ROWID_FNC FUNCTION S4B70.BANINST1 Use(select )
F_STUDENT_CHECK_FOR_MORE FUNCTION S4B70.BANINST1 Use(select )
P_GETSGRCHRT Package procedure S4B70.BANINST1.SOKWEXT Rely on ()
P_GETSGRCHRT Package procedure S4B70.BANINST1.SOKWEXT Use(select )
P_INSERT_SHRCHRT Package procedure S4B70.BANINST1.SHKROLS Use(select )
SGRCHRT_ROW Package variable S4B70.BANINST1.SHKROLS Rely on ()
SGRCHRT_ROW Package variable S4B70.BANINST1.SHKROLS Rely on ()
P_INSERT_COHORT Package procedure S4B70.BANINST1.SAKMODS Use(insert,select )
F_GET_END_COHORT_TERM Package function S4B70.BANINST1.SOKODSF Use(select )
SGRCHRT Forms DataBlock BANNER7_FORMS_10G.SGASADD Rely on () Use(insert,update,delete,select )
SGRCHRT Forms DataBlock BANNER7_FORMS.SGASADD Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
SGRCHRT_KEY_INDEX INDEX S4B70.SATURN Rely on ()
SGRCHRT_KEY_INDEX2 INDEX S4B70.SATURN Rely on ()
STVCHRT TABLE S4B70.SATURN Refer( No Action )
STVCREA TABLE S4B70.SATURN Refer( No Action )
STVTERM TABLE S4B70.SATURN Refer( No Action )

Comments

Source Code Comments

Student Cohort Table.

Columns Comments for SGRCHRT_PIDM (1)

Source Code Comments

Internal Identification Number of the person.

Columns Comments for SGRCHRT_TERM_CODE_EFF (2)

Source Code Comments

Identifies the term this cohort becomes effective.

Columns Comments for SGRCHRT_CHRT_CODE (3)

Source Code Comments

Cohort Code.

Columns Comments for SGRCHRT_ACTIVE_IND (4)

Source Code Comments

Cohort active indicator. Null means Active, Y means Inactive.

Columns Comments for SGRCHRT_CREA_CODE (5)

Source Code Comments

Cohort Reason Code. Reason for inactivity.

Columns Comments for SGRCHRT_ACTIVITY_DATE (6)

Source Code Comments

Date of last update or insert.

Table SGRCLSR

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SGRCLSR_LEVL_CODE SGRCLSR_LEVL_CODE VARCHAR2(2) No *
SGRCLSR_CLAS_CODE SGRCLSR_CLAS_CODE VARCHAR2(2) No *
SGRCLSR_FROM_HOURS SGRCLSR_FROM_HOURS NUMBER(11,3) No
SGRCLSR_TO_HOURS SGRCLSR_TO_HOURS NUMBER(11,3) No
SGRCLSR_ACTIVITY_DATE SGRCLSR_ACTIVITY_DATE DATE No
SGRCLSR_SEQ_NO SGRCLSR_SEQ_NO NUMBER(3,0) No

Foreign Key information

Column name is Foreign Key For Column on Table
SGRCLSR_CLAS_CODE STVCLAS_CODE STVCLAS
SGRCLSR_LEVL_CODE STVLEVL_CODE STVLEVL

Index

Index Name Index Type Column Name
SGRCLSR_KEY_INDEX SGRCLSR_LEVL_CODE
SGRCLSR_KEY_INDEX SGRCLSR_CLAS_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
select_student_class C/C++ Function [F:\BANNER\C\SHREDIY.PC] Use(select )
select_student_class2 C/C++ Function [F:\BANNER\C\SHREDIY.PC] Use(select )
CAA10 Cobol Paragraph [F:\banner\cobol].SCTH1000.AAA Use(select )
CAA9 Cobol Paragraph [F:\banner\cobol].SCTH1000.AAA Use(select )
select_lms_classcode C/C++ Function [F:\BANNER\C\RPBLMID.PC] Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SHAMDIP.KEY_BLOCK.SHAMDIP_CLAS_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SHAMCAT.KEY_BLOCK.SHAMCAT_CLAS_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SHAMDEG.KEY_BLOCK.SHAMDEG_CLAS_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SHAMCAT.KEY_BLOCK.SHAMCAT_CLAS_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SHAMDEG.KEY_BLOCK.SHAMDEG_CLAS_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SHAMDIP.KEY_BLOCK.SHAMDIP_CLAS_CODE Use(select )
PRE-INSERT Forms Trigger BANNER7_FORMS.SGACLSR.SGRCLSR Use(select )
PRE-INSERT Forms Trigger BANNER7_FORMS_10G.SGACLSR.SGRCLSR Use(select )
S$_CLASS_CALC Forms Procedure BANNER7_FORMS.SOQRPLS Rely on ()
S$_CLASS_CALC Forms Procedure BANNER7_FORMS.SOQRPLS Use(select )
S$_CLASS_CALC Forms Procedure BANNER7_FORMS_10G.SOQRPLS Rely on ()
S$_CLASS_CALC Forms Procedure BANNER7_FORMS_10G.SOQRPLS Use(select )
F_CLASS_CALC_FNC FUNCTION S4B70.BANINST1 Rely on ()
F_CLASS_CALC_FNC FUNCTION S4B70.BANINST1 Use(select )
GETSTUDENTCLASC Package cursor S4B70.BANINST1.BWCKREGS Use(select )
CLAS_CODE Package variable S4B70.BANINST1.BWSKRSTA Rely on ()
STUD_CLASS Package variable S4B70.BANINST1.BWCKREGS Rely on ()
STUD_EARNED_HRS_CLASS Package variable S4B70.BANINST1.BWCKREGS Rely on ()
F_GETEARNEDHRSCLAS Package function S4B70.BANINST1.BWCKREGS Rely on ()
F_GETEARNEDHRSCLAS Package function S4B70.BANINST1.BWCKREGS Rely on ()
P_ADD_SFTREGS Package procedure S4B70.BANINST1.BWCKLIBS Rely on ()
P_CHECK_CLAS Package procedure S4B70.BANINST1.SFKFUNC Rely on ()
P_CHECK_VOICE_AVAIL Package procedure S4B70.BANINST1.SFKFUNC Rely on ()
P_CHECK_VOICE_AVAIL Package procedure S4B70.BANINST1.SFKFUNC Rely on ()
P_CLASS_CALC Package procedure S4B70.BANINST1.SOKLIBS Rely on ()
P_CLASS_CALC Package procedure S4B70.BANINST1.SOKLIBS Use(select )
P_DEL_SFTREGS Package procedure S4B70.BANINST1.BWCKLIBS Rely on ()
P_FINAL_UPDATES Package procedure S4B70.BANINST1.BWCKREGS Rely on ()
P_GET_SSRRESV_ROW Package procedure S4B70.BANINST1.SSKSELS Rely on ()
P_GROUP_EDITS Package procedure S4B70.BANINST1.BWCKCOMS Rely on ()
P_PRE_EDIT Package procedure S4B70.BANINST1.SFKEDIT Rely on ()
P_REGS Package procedure S4B70.BANINST1.BWCKCOMS Rely on ()
P_REGSUPD Package procedure S4B70.BANINST1.BWCKGENS Rely on ()
P_REGS_ETRM_CHK Package procedure S4B70.BANINST1.BWCKCOMS Rely on ()
P_UPDATE_REGS Package procedure S4B70.BANINST1.SFKEDIT Rely on ()
P_UPDVARDATA_SFTREGS Package procedure S4B70.BANINST1.BWCKLIBS Rely on ()
P_UPD_SFTREGS Package procedure S4B70.BANINST1.BWCKLIBS Rely on ()
P_VERIFY_ELIGIBLE_TO_REGISTER Package procedure S4B70.BANINST1.VRSKFORG Rely on ()
P_VR_ADD_CLASS Package procedure S4B70.BANINST1.VRSKFREG Rely on ()
P_VR_DROP_CLASS_OPT Package procedure S4B70.BANINST1.VRSKFREG Rely on ()
P_VR_PROCESS_ADMINDROPS Package procedure S4B70.BANINST1.VRSKFREG 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 ()
SGRCLSR_ROW_BY_LEVL_HRS_C Package cursor S4B70.BANINST1.SGKSELS Rely on ()
SGRCLSR_ROW_BY_LEVL_HRS_C Package cursor S4B70.BANINST1.SGKSELS Rely on () Use(select )
F_CHECK_MGMT_CONTROL Package function S4B70.BANINST1.SFKRCTL Rely on ()
F_CHECK_MGMT_CONTROL Package function S4B70.BANINST1.SFKRCTL Rely on ()
F_CLASS_CODE Package function S4B70.BANINST1.SGKCLAS Use(select )
F_REG_CRITERIA_MET Package function S4B70.BANINST1.SFKSELS Rely on ()
F_REG_CRITERIA_MET Package function S4B70.BANINST1.SFKSELS Rely on ()
SGRCLSR SYNONYM S4B70.PUBLIC Rely on ()
SGRCLSR Forms DataBlock BANNER7_FORMS.SGACLSR Rely on () Use(insert,update,delete,select )
SGRCLSR Forms DataBlock BANNER7_FORMS_10G.SGACLSR Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
SGRCLSR_KEY_INDEX INDEX S4B70.SATURN Rely on ()
STVCLAS TABLE S4B70.SATURN Refer( No Action )
STVLEVL TABLE S4B70.SATURN Refer( No Action )

Comments

Source Code Comments

Student Classification Table

Columns Comments for SGRCLSR_LEVL_CODE (1)

Source Code Comments

This field identifies the level of the student associated with the classification rule.

Columns Comments for SGRCLSR_CLAS_CODE (2)

Source Code Comments

This field identifies the class(i.e. freshman, sophmore etc) associated with the level of the student for which the classification rule applies.

Columns Comments for SGRCLSR_FROM_HOURS (3)

Source Code Comments

This field identifies the minimum number of credit hours for the class within the level.

Columns Comments for SGRCLSR_TO_HOURS (4)

Source Code Comments

This field identifies the maximum number of credits for the class within the level.

Columns Comments for SGRCLSR_ACTIVITY_DATE (5)

Source Code Comments

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

Columns Comments for SGRCLSR_SEQ_NO (6)

Source Code Comments

The classification rule sequence number.

Table SGRCMNT

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SGRCMNT_PIDM SGRCMNT_PIDM NUMBER(8,0) No
SGRCMNT_TERM_CODE SGRCMNT_TERM_CODE VARCHAR2(6) No *
SGRCMNT_ACTC_CODE SGRCMNT_ACTC_CODE VARCHAR2(8) No *
SGRCMNT_SEQ_NO SGRCMNT_SEQ_NO NUMBER(23,20) Yes
SGRCMNT_COMMENT_TEXT SGRCMNT_COMMENT_TEXT VARCHAR2(4000) No
SGRCMNT_ACTIVITY_DATE SGRCMNT_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
SGRCMNT_TERM_CODE STVTERM_CODE STVTERM
SGRCMNT_ACTC_CODE STVACTC_CODE STVACTC

Index

Index Name Index Type Column Name
SGRCMNT_KEY_INDEX SGRCMNT_PIDM
SGRCMNT_KEY_INDEX SGRCMNT_TERM_CODE
SGRCMNT_KEY_INDEX SGRCMNT_ACTC_CODE
SGRCMNT_KEY_INDEX SGRCMNT_SEQ_NO

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
SGRCMNT SYNONYM S4B70.PUBLIC Rely on ()
KEY-DELREC Forms Trigger BANNER7_FORMS_10G.SGASPRT.SGRSPRT Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS.SGASPRT.SGRSPRT Use(select )
KEY_DELREC Forms Trigger BANNER7_FORMS_10G.SGASTDN.SGBSTDN Use(select )
KEY_DELREC Forms Trigger BANNER7_FORMS.SGASTDN.SGBSTDN Use(select )
PRE-DELETE Forms Trigger BANNER7_FORMS_10G.SGASPRT.SGRSPRT Use(delete )
PRE-DELETE Forms Trigger BANNER7_FORMS.SGASPRT.SGRSPRT Use(delete )
PRE-INSERT Forms Trigger BANNER7_FORMS_10G.SGASPRT.SGRCMNT Use(select )
PRE-INSERT Forms Trigger BANNER7_FORMS.SGASPRT.SGRCMNT Use(select )
SGRCMNT Forms DataBlock BANNER7_FORMS_10G.SGASPRT Rely on () Use(insert,update,delete,select )
SGRCMNT Forms DataBlock BANNER7_FORMS.SGASPRT Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
SGRCMNT_KEY_INDEX INDEX S4B70.SATURN Rely on ()
STVACTC TABLE S4B70.SATURN Refer( No Action )
STVTERM TABLE S4B70.SATURN Refer( No Action )

Comments

Source Code Comments

General Student Sport Comments Table

Columns Comments for SGRCMNT_PIDM (1)

Source Code Comments

Internal Person Identification Number

Columns Comments for SGRCMNT_TERM_CODE (2)

Source Code Comments

Term Code

Columns Comments for SGRCMNT_ACTC_CODE (3)

Source Code Comments

Activity Code

Columns Comments for SGRCMNT_SEQ_NO (4)

Source Code Comments

Sequence Number

Columns Comments for SGRCMNT_COMMENT_TEXT (5)

Source Code Comments

Comment Text

Columns Comments for SGRCMNT_ACTIVITY_DATE (6)

Source Code Comments

The Activity Date

Table SGRCOLR

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SGRCOLR_SESSIONID SGRCOLR_SESSIONID VARCHAR2(30) No
SGRCOLR_CHRT_CODE SGRCOLR_CHRT_CODE VARCHAR2(10) No *
SGRCOLR_TERM_CODE_START SGRCOLR_TERM_CODE_START VARCHAR2(6) No *
SGRCOLR_TERM_CODE_END SGRCOLR_TERM_CODE_END VARCHAR2(6) No *
SGRCOLR_ACTC_CODE SGRCOLR_ACTC_CODE VARCHAR2(8) Yes *
SGRCOLR_DLEV_CODE SGRCOLR_DLEV_CODE VARCHAR2(2) Yes *
SGRCOLR_PRINT_IND SGRCOLR_PRINT_IND VARCHAR2(1) No
SGRCOLR_PIDM SGRCOLR_PIDM NUMBER(8,0) No
SGRCOLR_ID SGRCOLR_ID VARCHAR2(9) No
SGRCOLR_SEX SGRCOLR_SEX VARCHAR2(1) Yes
SGRCOLR_IPEDS_CATEGORY SGRCOLR_IPEDS_CATEGORY VARCHAR2(1) Yes
SGRCOLR_CREA_CODE SGRCOLR_CREA_CODE VARCHAR2(4) Yes *
SGRCOLR_TERM_CODE_INACTIVE SGRCOLR_TERM_CODE_INACTIVE VARCHAR2(6) Yes *
SGRCOLR_DEGC_CODE SGRCOLR_DEGC_CODE VARCHAR2(6) Yes *
SGRCOLR_MAJR_CODE SGRCOLR_MAJR_CODE VARCHAR2(4) Yes *
SGRCOLR_AWARDED_DATE SGRCOLR_AWARDED_DATE DATE Yes
SGRCOLR_CRHRS SGRCOLR_CRHRS NUMBER(11,3) Yes
SGRCOLR_CEU SGRCOLR_CEU NUMBER(11,3) Yes
SGRCOLR_ACTIVITY_DATE SGRCOLR_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
SGRCOLR_CREA_CODE STVCREA_CODE STVCREA
SGRCOLR_TERM_CODE_END STVTERM_CODE STVTERM
SGRCOLR_TERM_CODE_START STVTERM_CODE STVTERM
SGRCOLR_TERM_CODE_INACTIVE STVTERM_CODE STVTERM
SGRCOLR_ACTC_CODE STVACTC_CODE STVACTC
SGRCOLR_DLEV_CODE STVDLEV_CODE STVDLEV
SGRCOLR_MAJR_CODE STVMAJR_CODE STVMAJR
SGRCOLR_DEGC_CODE STVDEGC_CODE STVDEGC
SGRCOLR_CHRT_CODE STVCHRT_CODE STVCHRT

Index

Index Name Index Type Column Name
SGRCOLR_KEY_INDEX SGRCOLR_SESSIONID
SGRCOLR_KEY_INDEX SGRCOLR_CHRT_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
collect_detail C/C++ Function [F:\BANNER\C\SHRIGRS.PC] Use(insert )
delete_detail_collector C/C++ Function [F:\BANNER\C\SGRKNOW.PC] Use(delete )
delete_detail_collector C/C++ Function [F:\BANNER\C\SHRIGRS.PC] Use(delete )
insert_print_detail C/C++ Function [F:\BANNER\C\SGRKNOW.PC] Use(insert )
print_summary C/C++ Function [F:\BANNER\C\SHRIGRS.PC] Use(select )
read_print_detail_chrt C/C++ Function [F:\BANNER\C\SGRKNOW.PC] Use(select )
read_print_detail_sprt C/C++ Function [F:\BANNER\C\SGRKNOW.PC] Use(select )
sport_report C/C++ Function [F:\BANNER\C\SHRIGRS.PC] Use(select )
SGRCOLR SYNONYM S4B70.PUBLIC Rely on ()

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
SGRCOLR_KEY_INDEX INDEX S4B70.SATURN Rely on ()
STVACTC TABLE S4B70.SATURN Refer( No Action )
STVCHRT TABLE S4B70.SATURN Refer( No Action )
STVCREA TABLE S4B70.SATURN Refer( No Action )
STVDEGC TABLE S4B70.SATURN Refer( No Action )
STVDLEV TABLE S4B70.SATURN Refer( No Action )
STVMAJR TABLE S4B70.SATURN Refer( No Action )
STVTERM TABLE S4B70.SATURN Refer( No Action )

Comments

Source Code Comments

Student Right to Know Detail Reporting Table

Columns Comments for SGRCOLR_SESSIONID (1)

Source Code Comments

Session Identification Number

Columns Comments for SGRCOLR_CHRT_CODE (2)

Source Code Comments

Cohort Code

Columns Comments for SGRCOLR_TERM_CODE_START (3)

Source Code Comments

Cohort Start Term

Columns Comments for SGRCOLR_TERM_CODE_END (4)

Source Code Comments

Cohort End Term

Columns Comments for SGRCOLR_ACTC_CODE (5)

Source Code Comments

Activity Code

Columns Comments for SGRCOLR_DLEV_CODE (6)

Source Code Comments

Cohort Degree Level Code

Columns Comments for SGRCOLR_PRINT_IND (7)

Source Code Comments

Detail record print type

Columns Comments for SGRCOLR_PIDM (8)

Source Code Comments

Person Internal Identification Number

Columns Comments for SGRCOLR_ID (9)

Source Code Comments

Person Identification Number

Columns Comments for SGRCOLR_SEX (10)

Source Code Comments

Person Sex

Columns Comments for SGRCOLR_IPEDS_CATEGORY (11)

Source Code Comments

IPEDS Reporting Category

Columns Comments for SGRCOLR_CREA_CODE (12)

Source Code Comments

Cohort Reason Code

Columns Comments for SGRCOLR_TERM_CODE_INACTIVE (13)

Source Code Comments

Effective term of Inactivation

Columns Comments for SGRCOLR_DEGC_CODE (14)

Source Code Comments

Degree Code

Columns Comments for SGRCOLR_MAJR_CODE (15)

Source Code Comments

Major Code

Columns Comments for SGRCOLR_AWARDED_DATE (16)

Source Code Comments

Degree Awarded Date

Columns Comments for SGRCOLR_CRHRS (17)

Source Code Comments

Enrolled Credit Hours

Columns Comments for SGRCOLR_CEU (18)

Source Code Comments

Enrolled CEU Hours

Columns Comments for SGRCOLR_ACTIVITY_DATE (19)

Source Code Comments

The Activity Date

Table SGRCOOP

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SGRCOOP_PIDM SGRCOOP_PIDM NUMBER(8,0) No *
SGRCOOP_TERM_CODE SGRCOOP_TERM_CODE VARCHAR2(6) No * *
SGRCOOP_LEVL_CODE SGRCOOP_LEVL_CODE VARCHAR2(2) No * *
SGRCOOP_EMPL_CODE SGRCOOP_EMPL_CODE VARCHAR2(4) Yes *
SGRCOOP_COPC_CODE SGRCOOP_COPC_CODE VARCHAR2(6) Yes *
SGRCOOP_END_DATE SGRCOOP_END_DATE DATE Yes
SGRCOOP_BEGIN_DATE SGRCOOP_BEGIN_DATE DATE Yes
SGRCOOP_INTEREST_IND SGRCOOP_INTEREST_IND VARCHAR2(1) Yes
SGRCOOP_EMPL_CONTACT_NAME SGRCOOP_EMPL_CONTACT_NAME VARCHAR2(30) Yes
SGRCOOP_EMPL_CONTACT_TITLE SGRCOOP_EMPL_CONTACT_TITLE VARCHAR2(30) Yes
SGRCOOP_ACTIVITY_DATE SGRCOOP_ACTIVITY_DATE DATE No
SGRCOOP_PHONE_AREA SGRCOOP_PHONE_AREA VARCHAR2(3) Yes
SGRCOOP_PHONE_NUMBER SGRCOOP_PHONE_NUMBER VARCHAR2(7) Yes
SGRCOOP_PHONE_EXT SGRCOOP_PHONE_EXT VARCHAR2(4) Yes
SGRCOOP_SEQ_NO SGRCOOP_SEQ_NO NUMBER(4,0) No *
SGRCOOP_CRN SGRCOOP_CRN VARCHAR2(5) Yes
SGRCOOP_EVAL_PREPARED_DATE SGRCOOP_EVAL_PREPARED_DATE DATE Yes
SGRCOOP_EVAL_RECEIVED_DATE SGRCOOP_EVAL_RECEIVED_DATE DATE Yes
SGRCOOP_OVERRIDE_IND SGRCOOP_OVERRIDE_IND VARCHAR2(1) Yes

Foreign Key information

Column name is Foreign Key For Column on Table
SGRCOOP_LEVL_CODE STVLEVL_CODE STVLEVL
SGRCOOP_TERM_CODE STVTERM_CODE STVTERM
SGRCOOP_EMPL_CODE STVEMPL_CODE STVEMPL
SGRCOOP_COPC_CODE STVCOPC_CODE STVCOPC

Index

Index Name Index Type Column Name
PK_SGRCOOP Unique SGRCOOP_PIDM
PK_SGRCOOP Unique SGRCOOP_TERM_CODE
PK_SGRCOOP Unique SGRCOOP_LEVL_CODE
PK_SGRCOOP Unique SGRCOOP_SEQ_NO

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
delcoed C/C++ Function [F:\BANNER\C\SGPCOOP.PC] Use(delete )
delcoop C/C++ Function [F:\BANNER\C\SGPSTDN.PC] Use(delete )
selcoop C/C++ Function [F:\BANNER\C\APPSTDI.PC] Use(select )
selcoop C/C++ Function [F:\BANNER\C\SGPSTDN.PC] Use(select )
selcoop1 C/C++ Function [F:\BANNER\C\SGPSTDN.PC] Use(select )
seldel C/C++ Function [F:\BANNER\C\SGPCOOP.PC] Use(select )
SGRCOOP SYNONYM S4B70.PUBLIC Rely on ()
SGRDUTY TABLE S4B70.SATURN Refer( No Action )
OPTM_SGACOOP Forms Trigger BANNER7_FORMS.SHATCKC Use(select )
OPTM_SGACOOP Forms Trigger BANNER7_FORMS.SHATCKS Use(select )
OPTM_SGACOOP Forms Trigger BANNER7_FORMS_10G.SHATCKN Use(select )
OPTM_SGACOOP Forms Trigger BANNER7_FORMS.SHATCKP Use(select )
OPTM_SGACOOP Forms Trigger BANNER7_FORMS.SFAREGQ Use(select )
OPTM_SGACOOP Forms Trigger BANNER7_FORMS_10G.SHATCKS Use(select )
OPTM_SGACOOP Forms Trigger BANNER7_FORMS_10G.SHATCKP Use(select )
OPTM_SGACOOP Forms Trigger BANNER7_FORMS_10G.SFAREGQ Use(select )
OPTM_SGACOOP Forms Trigger BANNER7_FORMS_10G.SHATCKC Use(select )
CHECK_COOP_COUNT Forms Trigger BANNER7_FORMS_10G.SGACOOP.SGRCOOP Use(select )
CHECK_COOP_COUNT Forms Trigger BANNER7_FORMS.SGACOOP.SGRCOOP Use(select )
GET_MAX_SEQ_NO Forms Trigger BANNER7_FORMS_10G.SGACOOP.SGRCOOP Use(select )
GET_MAX_SEQ_NO Forms Trigger BANNER7_FORMS.SGACOOP.SGRCOOP Use(select )
KEY_DELREC Forms Trigger BANNER7_FORMS_10G.SGASTDN.SGBSTDN Use(select )
KEY_DELREC Forms Trigger BANNER7_FORMS.SGASTDN.SGBSTDN Use(select )
WHEN-NEW-RECORD-INSTANCE Forms Trigger BANNER7_FORMS.SHATCKC.SHRTCKN Use(select )
WHEN-NEW-RECORD-INSTANCE Forms Trigger BANNER7_FORMS.SHATCKS.SHRTCKN Use(select )
WHEN-NEW-RECORD-INSTANCE Forms Trigger BANNER7_FORMS.SFAREGQ.SFVSTMS Use(select )
WHEN-NEW-RECORD-INSTANCE Forms Trigger BANNER7_FORMS_10G.SHATCKS.SHRTCKN Use(select )
WHEN-NEW-RECORD-INSTANCE Forms Trigger BANNER7_FORMS_10G.SHATCKP.SHRTCKN Use(select )
WHEN-NEW-RECORD-INSTANCE Forms Trigger BANNER7_FORMS_10G.SFAREGQ.SFVSTMS Use(select )
WHEN-NEW-RECORD-INSTANCE Forms Trigger BANNER7_FORMS_10G.SHATCKC.SHRTCKN Use(select )
WHEN-NEW-RECORD-INSTANCE Forms Trigger BANNER7_FORMS_10G.SHATCKN.SHRTCKN Use(select )
WHEN-NEW-RECORD-INSTANCE Forms Trigger BANNER7_FORMS.SHATCKP.SHRTCKN Use(select )
SELECT_SGRCOOP_1 Forms Function BANNER7_FORMS_10G.SGACOOP Use(select )
SELECT_SGRCOOP_1 Forms Function BANNER7_FORMS.SGACOOP Use(select )
P_GET_STUDENT_COURSE Package procedure S4B70.BANINST1.SHKROLS Use(select )
COOPS Forms DataBlock BANNER7_FORMS_10G.SGACOOP Rely on () Use(insert,update,delete,select )
COOPS Forms DataBlock BANNER7_FORMS.SGACOOP Rely on () Use(insert,update,delete,select )
SGRCOOP Forms DataBlock BANNER7_FORMS_10G.SGACOOP Rely on () Use(insert,update,delete,select )
SGRCOOP Forms DataBlock BANNER7_FORMS.SGACOOP Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_SGRCOOP INDEX S4B70.SATURN Rely on ()
STVCOPC TABLE S4B70.SATURN Refer( No Action )
STVEMPL TABLE S4B70.SATURN Refer( No Action )
STVLEVL TABLE S4B70.SATURN Refer( No Action )
STVTERM TABLE S4B70.SATURN Refer( No Action )

Comments

Source Code Comments

Cooperative Education Repeating Table

Columns Comments for SGRCOOP_PIDM (1)

Source Code Comments

This field identifies the student internal identification number.

Columns Comments for SGRCOOP_TERM_CODE (2)

Source Code Comments

This field identifies the effective term to create or display information.

Columns Comments for SGRCOOP_LEVL_CODE (3)

Source Code Comments

This field identifies the level of the student for which the record is being created or displayed.

Columns Comments for SGRCOOP_EMPL_CODE (4)

Source Code Comments

This field identifies the cooperative education employer.

Columns Comments for SGRCOOP_COPC_CODE (5)

Source Code Comments

This field identifies the type of cooperative education experience.

Columns Comments for SGRCOOP_END_DATE (6)

Source Code Comments

This field identifies the effective end date of the cooperative education experience.

Columns Comments for SGRCOOP_BEGIN_DATE (7)

Source Code Comments

This field identifies the effective start date of the cooperative education experience.

Columns Comments for SGRCOOP_INTEREST_IND (8)

Source Code Comments

This field indicates if the cooperative education experience is a field of interest to the student. Value is Y or blank only.

Columns Comments for SGRCOOP_EMPL_CONTACT_NAME (9)

Source Code Comments

This field identifies the contact person of the cooperative education employer.

Columns Comments for SGRCOOP_EMPL_CONTACT_TITLE (10)

Source Code Comments

This field identifies the title of the contact person of the cooperative education employer.

Columns Comments for SGRCOOP_ACTIVITY_DATE (11)

Source Code Comments

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

Columns Comments for SGRCOOP_PHONE_AREA (12)

Source Code Comments

This field maintains the telephone area code of the employer contact.

Columns Comments for SGRCOOP_PHONE_NUMBER (13)

Source Code Comments

This field maintains the telephone exchange and number of the employer contact.

Columns Comments for SGRCOOP_PHONE_EXT (14)

Source Code Comments

This field maintains the telephone extension of the employer contact.

Columns Comments for SGRCOOP_SEQ_NO (15)

Source Code Comments

The Coop Assignment Sequence Number.

Columns Comments for SGRCOOP_CRN (16)

Source Code Comments

The Coop Assignment CRN.

Columns Comments for SGRCOOP_EVAL_PREPARED_DATE (17)

Source Code Comments

The Coop Assignment Evaluation Prepared Date.

Columns Comments for SGRCOOP_EVAL_RECEIVED_DATE (18)

Source Code Comments

The Coop Assignment Evaluation Received Date.

Columns Comments for SGRCOOP_OVERRIDE_IND (19)

Source Code Comments

The Coop Assignment Override Indicator.

Table SGRDISA

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SGRDISA_PIDM SGRDISA_PIDM NUMBER(8,0) No *
SGRDISA_TERM_CODE SGRDISA_TERM_CODE VARCHAR2(6) No * *
SGRDISA_DISA_CODE SGRDISA_DISA_CODE VARCHAR2(2) No * *
SGRDISA_MEDI_CODE SGRDISA_MEDI_CODE VARCHAR2(2) Yes *
SGRDISA_SPSR_CODE SGRDISA_SPSR_CODE VARCHAR2(2) Yes *
SGRDISA_PRIMARY_IND SGRDISA_PRIMARY_IND VARCHAR2(1) Yes
SGRDISA_ACTIVITY_DATE SGRDISA_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
SGRDISA_DISA_CODE STVDISA_CODE STVDISA
SGRDISA_MEDI_CODE STVMEDI_CODE STVMEDI
SGRDISA_SPSR_CODE STVSPSR_CODE STVSPSR
SGRDISA_TERM_CODE STVTERM_CODE STVTERM

Index

Index Name Index Type Column Name
PK_SGRDISA Unique SGRDISA_PIDM
PK_SGRDISA Unique SGRDISA_TERM_CODE
PK_SGRDISA Unique SGRDISA_DISA_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
MAA3 Cobol Paragraph [F:\banner\cobol].SERSDREC.MAA-MAINLINE-SECT Use(select )
MAA6 Cobol Paragraph [F:\banner\cobol].SERSDREC.MAA-MAINLINE-SECT Use(select )
get_disa_data C/C++ Function [F:\BANNER\C\SERPSRC.PC] Use(select )
SGRDSER TABLE S4B70.SATURN Refer( No Action )
CHECK_WARN_PRIM_IND Forms Trigger BANNER7_FORMS.SGADISA Use(select )
CHECK_WARN_PRIM_IND Forms Trigger BANNER7_FORMS_10G.SGADISA Use(select )
CHECK_DUP_PRIM_IND Forms Trigger BANNER7_FORMS.SGADISA.SGRDISA Use(select )
CHECK_DUP_PRIM_IND Forms Trigger BANNER7_FORMS_10G.SGADISA.SGRDISA Use(select )
KEY-NXTBLK Forms Trigger BANNER7_FORMS.SGADISA.SGRDISA Use(select )
KEY-NXTBLK Forms Trigger BANNER7_FORMS_10G.SGADISA.SGRDISA Use(select )
WHEN-NEW-BLOCK-INSTANCE Forms Trigger BANNER7_FORMS.SGADISA.SGRDSER Use(select )
WHEN-NEW-BLOCK-INSTANCE Forms Trigger BANNER7_FORMS_10G.SGADISA.SGRDSER Use(select )
SGRDISA SYNONYM S4B70.PUBLIC Rely on ()
SGRDISA Forms DataBlock BANNER7_FORMS.SGADISA Rely on () Use(insert,update,delete,select )
SGRDISA Forms DataBlock BANNER7_FORMS_10G.SGADISA Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_SGRDISA INDEX S4B70.SATURN Rely on ()
STVDISA TABLE S4B70.SATURN Refer( No Action )
STVMEDI TABLE S4B70.SATURN Refer( No Action )
STVSPSR TABLE S4B70.SATURN Refer( No Action )
STVTERM TABLE S4B70.SATURN Refer( No Action )

Comments

Source Code Comments

Student Disability Services Table

Columns Comments for SGRDISA_PIDM (1)

Source Code Comments

Person Internal Identification Number

Columns Comments for SGRDISA_TERM_CODE (2)

Source Code Comments

Disability Term Code

Columns Comments for SGRDISA_DISA_CODE (3)

Source Code Comments

Disability Code

Columns Comments for SGRDISA_MEDI_CODE (4)

Source Code Comments

Medical Code

Columns Comments for SGRDISA_SPSR_CODE (5)

Source Code Comments

Disablity Service Code

Columns Comments for SGRDISA_PRIMARY_IND (6)

Source Code Comments

Primary Disability Indicator

Columns Comments for SGRDISA_ACTIVITY_DATE (7)

Source Code Comments

The Activity Date

Table SGRDSER

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SGRDSER_PIDM SGRDSER_PIDM NUMBER(8,0) No *
SGRDSER_TERM_CODE SGRDSER_TERM_CODE VARCHAR2(6) No *
SGRDSER_DISA_CODE SGRDSER_DISA_CODE VARCHAR2(2) No *
SGRDSER_SSER_CODE SGRDSER_SSER_CODE VARCHAR2(4) No *
SGRDSER_NBR_CONTACTS SGRDSER_NBR_CONTACTS NUMBER(3,0) Yes
SGRDSER_SSST_CODE SGRDSER_SSST_CODE VARCHAR2(2) Yes *
SGRDSER_SEPR_CODE SGRDSER_SEPR_CODE VARCHAR2(2) Yes *
SGRDSER_SPRV_CODE SGRDSER_SPRV_CODE VARCHAR2(6) Yes *
SGRDSER_SSEP_CODE SGRDSER_SSEP_CODE VARCHAR2(4) Yes *
SGRDSER_BEGIN_DATE SGRDSER_BEGIN_DATE DATE Yes
SGRDSER_END_DATE SGRDSER_END_DATE DATE Yes
SGRDSER_SSRS_CODE SGRDSER_SSRS_CODE VARCHAR2(2) Yes *
SGRDSER_ORIG_CODE SGRDSER_ORIG_CODE VARCHAR2(4) Yes *
SGRDSER_CAMP_CODE SGRDSER_CAMP_CODE VARCHAR2(3) Yes *
SGRDSER_ACTIVITY_DATE SGRDSER_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
SGRDSER_SPRV_CODE STVSPRV_CODE STVSPRV
SGRDSER_CAMP_CODE STVCAMP_CODE STVCAMP
SGRDSER_TERM_CODE STVTERM_CODE STVTERM
SGRDSER_DISA_CODE STVDISA_CODE STVDISA
SGRDSER_SSEP_CODE STVSSEP_CODE STVSSEP
SGRDSER_SSER_CODE STVSSER_CODE STVSSER
SGRDSER_SSRS_CODE STVSSRS_CODE STVSSRS
SGRDSER_SSST_CODE STVSSST_CODE STVSSST
SGRDSER_SEPR_CODE STVSEPR_CODE STVSEPR
SGRDSER_ORIG_CODE STVORIG_CODE STVORIG
SGRDSER_PIDM SGRDISA_PIDM SGRDISA
SGRDSER_TERM_CODE SGRDISA_TERM_CODE SGRDISA
SGRDSER_DISA_CODE SGRDISA_DISA_CODE SGRDISA

Index

Index Name Index Type Column Name
SGRDSER_KEY_INDEX SGRDSER_PIDM
SGRDSER_KEY_INDEX SGRDSER_TERM_CODE
SGRDSER_KEY_INDEX SGRDSER_DISA_CODE
SGRDSER_KEY_INDEX SGRDSER_SSER_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
MAA6 Cobol Paragraph [F:\banner\cobol].SERSDREC.MAA-MAINLINE-SECT Use(select )
PRE-DELETE Forms Trigger BANNER7_FORMS.SGADISA.SGRDISA Use(delete )
PRE-DELETE Forms Trigger BANNER7_FORMS_10G.SGADISA.SGRDISA Use(delete )
XKEY_DELREC Forms Trigger BANNER7_FORMS.SGADISA.SGRDISA Use(select )
XKEY_DELREC Forms Trigger BANNER7_FORMS_10G.SGADISA.SGRDISA Use(select )
SGRDSER SYNONYM S4B70.PUBLIC Rely on ()
SGRDSER Forms DataBlock BANNER7_FORMS.SGADISA Rely on () Use(insert,update,delete,select )
SGRDSER Forms DataBlock BANNER7_FORMS_10G.SGADISA Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
SGRDSER_KEY_INDEX INDEX S4B70.SATURN Rely on ()
SGRDISA TABLE S4B70.SATURN Refer( No Action )
STVCAMP TABLE S4B70.SATURN Refer( No Action )
STVDISA TABLE S4B70.SATURN Refer( No Action )
STVORIG TABLE S4B70.SATURN Refer( No Action )
STVSEPR TABLE S4B70.SATURN Refer( No Action )
STVSPRV TABLE S4B70.SATURN Refer( No Action )
STVSSEP TABLE S4B70.SATURN Refer( No Action )
STVSSER TABLE S4B70.SATURN Refer( No Action )
STVSSRS TABLE S4B70.SATURN Refer( No Action )
STVSSST TABLE S4B70.SATURN Refer( No Action )
STVTERM TABLE S4B70.SATURN Refer( No Action )

Comments

Source Code Comments

Student Disability Service Support Table

Columns Comments for SGRDSER_PIDM (1)

Source Code Comments

Person Internal Identification Number

Columns Comments for SGRDSER_TERM_CODE (2)

Source Code Comments

Disability Term Code

Columns Comments for SGRDSER_DISA_CODE (3)

Source Code Comments

Disability Code

Columns Comments for SGRDSER_SSER_CODE (4)

Source Code Comments

Service Type Code

Columns Comments for SGRDSER_NBR_CONTACTS (5)

Source Code Comments

Number of Contacts for service

Columns Comments for SGRDSER_SSST_CODE (6)

Source Code Comments

Service Status Code

Columns Comments for SGRDSER_SEPR_CODE (7)

Source Code Comments

Service Provided Code

Columns Comments for SGRDSER_SPRV_CODE (8)

Source Code Comments

Service Provider Code

Columns Comments for SGRDSER_SSEP_CODE (9)

Source Code Comments

Service Exemption Code

Columns Comments for SGRDSER_BEGIN_DATE (10)

Source Code Comments

Service Begin Date

Columns Comments for SGRDSER_END_DATE (11)

Source Code Comments

Service End Date

Columns Comments for SGRDSER_SSRS_CODE (12)

Source Code Comments

Service Result Code

Columns Comments for SGRDSER_ORIG_CODE (13)

Source Code Comments

Originator Code

Columns Comments for SGRDSER_CAMP_CODE (14)

Source Code Comments

Campus Code

Columns Comments for SGRDSER_ACTIVITY_DATE (15)

Source Code Comments

The Activity Date

Table SGRDUTY

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SGRDUTY_PIDM SGRDUTY_PIDM NUMBER(8,0) No * *
SGRDUTY_LEVL_CODE SGRDUTY_LEVL_CODE VARCHAR2(2) No * *
SGRDUTY_TERM_CODE SGRDUTY_TERM_CODE VARCHAR2(6) No * *
SGRDUTY_EMPL_CODE SGRDUTY_EMPL_CODE VARCHAR2(4) No * *
SGRDUTY_SEQ_NO SGRDUTY_SEQ_NO NUMBER(4,0) No *
SGRDUTY_DESC SGRDUTY_DESC VARCHAR2(60) Yes
SGRDUTY_ACTIVITY_DATE SGRDUTY_ACTIVITY_DATE DATE No
SGRDUTY_COOP_SEQ_NO SGRDUTY_COOP_SEQ_NO NUMBER(4,0) No * *

Foreign Key information

Column name is Foreign Key For Column on Table
SGRDUTY_LEVL_CODE STVLEVL_CODE STVLEVL
SGRDUTY_TERM_CODE STVTERM_CODE STVTERM
SGRDUTY_PIDM SGRCOOP_PIDM SGRCOOP
SGRDUTY_TERM_CODE SGRCOOP_TERM_CODE SGRCOOP
SGRDUTY_LEVL_CODE SGRCOOP_LEVL_CODE SGRCOOP
SGRDUTY_COOP_SEQ_NO SGRCOOP_SEQ_NO SGRCOOP
SGRDUTY_EMPL_CODE STVEMPL_CODE STVEMPL

Index

Index Name Index Type Column Name
PK_SGRDUTY Unique SGRDUTY_PIDM
PK_SGRDUTY Unique SGRDUTY_TERM_CODE
PK_SGRDUTY Unique SGRDUTY_LEVL_CODE
PK_SGRDUTY Unique SGRDUTY_COOP_SEQ_NO
PK_SGRDUTY Unique SGRDUTY_EMPL_CODE
PK_SGRDUTY Unique SGRDUTY_SEQ_NO

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
delduty C/C++ Function [F:\BANNER\C\SGPSTDN.PC] Use(delete )
delduty C/C++ Function [F:\BANNER\C\SGPCOOP.PC] Use(delete )
seldut C/C++ Function [F:\BANNER\C\SGPCOOP.PC] Use(select )
seldut C/C++ Function [F:\BANNER\C\SGPSTDN.PC] Use(select )
SGRDUTY SYNONYM S4B70.PUBLIC Rely on ()
PRE-DELETE Forms Trigger BANNER7_FORMS_10G.SGACOOP.SGRCOOP Use(delete,select )
PRE-DELETE Forms Trigger BANNER7_FORMS.SGACOOP.SGRCOOP Use(delete,select )
PRE-INSERT Forms Trigger BANNER7_FORMS_10G.SGACOOP.SGRDUTY Use(select )
PRE-INSERT Forms Trigger BANNER7_FORMS.SGACOOP.SGRDUTY Use(select )
SGRDUTY Forms DataBlock BANNER7_FORMS_10G.SGACOOP Rely on () Use(insert,update,delete,select )
SGRDUTY Forms DataBlock BANNER7_FORMS.SGACOOP Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_SGRDUTY INDEX S4B70.SATURN Rely on ()
SGRCOOP TABLE S4B70.SATURN Refer( No Action )
STVEMPL TABLE S4B70.SATURN Refer( No Action )
STVLEVL TABLE S4B70.SATURN Refer( No Action )
STVTERM TABLE S4B70.SATURN Refer( No Action )

Comments

Source Code Comments

Cooperative Education Duties Repeating Table

Columns Comments for SGRDUTY_PIDM (1)

Source Code Comments

This field identifies the student internal identification number.

Columns Comments for SGRDUTY_LEVL_CODE (2)

Source Code Comments

This field identifies the level of the student for which the cooperative education duties are being created.

Columns Comments for SGRDUTY_TERM_CODE (3)

Source Code Comments

This field identifies the effective term for which the cooperative education duties are being created.

Columns Comments for SGRDUTY_EMPL_CODE (4)

Source Code Comments

This field identifies the cooperative education employer.

Columns Comments for SGRDUTY_SEQ_NO (5)

Source Code Comments

This field assigns an internal sequence number associated with each cooperative education duties being created.

Columns Comments for SGRDUTY_DESC (6)

Source Code Comments

This field identifies the description of the cooperative education duties being created.

Columns Comments for SGRDUTY_ACTIVITY_DATE (7)

Source Code Comments

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

Columns Comments for SGRDUTY_COOP_SEQ_NO (8)

Source Code Comments

The Coop Assignment Sequence N
umber. This SGRDUTY_COOP_SEQ_NO corresponds to the SGRCOOP_SEQ_NO.

Table SGRESEL

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SGRESEL_PIDM SGRESEL_PIDM NUMBER(8,0) No
SGRESEL_TERM_CODE_EFF SGRESEL_TERM_CODE_EFF VARCHAR2(6) No *
SGRESEL_ESEL_CODE SGRESEL_ESEL_CODE VARCHAR2(2) Yes *
SGRESEL_PRIMARY_IND SGRESEL_PRIMARY_IND VARCHAR2(1) Yes
SGRESEL_ACTIVITY_DATE SGRESEL_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
SGRESEL_ESEL_CODE STVESEL_CODE STVESEL
SGRESEL_TERM_CODE_EFF STVTERM_CODE STVTERM

Index

Index Name Index Type Column Name
SGRESEL_KEY_INDEX Unique SGRESEL_PIDM
SGRESEL_KEY_INDEX Unique SGRESEL_TERM_CODE_EFF
SGRESEL_KEY_INDEX Unique SGRESEL_ESEL_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
MAA3 Cobol Paragraph [F:\banner\cobol].SERSEREC.MAA-MAINLINE-SECT Use(select )
END_ESEL_TERM Forms Trigger BANNER7_FORMS_10G.SGAEOPS.SGRESEL Use(insert )
END_ESEL_TERM Forms Trigger BANNER7_FORMS.SGAEOPS.SGRESEL Use(insert )
INSERT_TRIG Forms Trigger BANNER7_FORMS_10G.SGAEOPS.SGRESEL Use(insert,select )
INSERT_TRIG Forms Trigger BANNER7_FORMS.SGAEOPS.SGRESEL Use(insert,select )
PRE-INSERT Forms Trigger BANNER7_FORMS_10G.SGAEOPS.SGRESEL Use(delete )
PRE-INSERT Forms Trigger BANNER7_FORMS.SGAEOPS.SGRESEL Use(delete )
PRE-QUERY Forms Trigger BANNER7_FORMS_10G.SGAEOPS.SGRESEL Use(select )
PRE-QUERY Forms Trigger BANNER7_FORMS.SGAEOPS.SGRESEL Use(select )
SGRESEL SYNONYM S4B70.PUBLIC Rely on ()
SGRESEL Forms DataBlock BANNER7_FORMS_10G.SGAEOPS Rely on () Use(insert,update,delete,select )
SGRESEL Forms DataBlock BANNER7_FORMS.SGAEOPS Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
SGRESEL_KEY_INDEX INDEX S4B70.SATURN Rely on ()
STVESEL TABLE S4B70.SATURN Refer( No Action )
STVTERM TABLE S4B70.SATURN Refer( No Action )

Comments

Source Code Comments

Eligibility Factor table

Columns Comments for SGRESEL_PIDM (1)

Source Code Comments

Person id number

Columns Comments for SGRESEL_TERM_CODE_EFF (2)

Source Code Comments

Effective term

Columns Comments for SGRESEL_ESEL_CODE (3)

Source Code Comments

Eligibility factor code

Columns Comments for SGRESEL_PRIMARY_IND (4)

Source Code Comments

Primary use indicator

Columns Comments for SGRESEL_ACTIVITY_DATE (5)

Source Code Comments

The Activity Date

Table SGRSACT

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SGRSACT_PIDM SGRSACT_PIDM NUMBER(8,0) No
SGRSACT_ACTC_CODE SGRSACT_ACTC_CODE VARCHAR2(8) No *
SGRSACT_TERM_CODE SGRSACT_TERM_CODE VARCHAR2(6) Yes *
SGRSACT_ACTIVITY_DATE SGRSACT_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
SGRSACT_TERM_CODE STVTERM_CODE STVTERM
SGRSACT_ACTC_CODE STVACTC_CODE STVACTC

Index

Index Name Index Type Column Name
SGRSACT_KEY_INDEX SGRSACT_PIDM
SGRSACT_KEY_INDEX SGRSACT_ACTC_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
MAA6 Cobol Paragraph [F:\banner\cobol].SERSBREC.MAA-MAINLINE-SECT Use(select )
delsact C/C++ Function [F:\BANNER\C\SGPSTDN.PC] Use(delete )
insacty C/C++ Function [F:\BANNER\C\APPSTDI.PC] Use(select )
insacyr C/C++ Function [F:\BANNER\C\APPSTDI.PC] Use(select )
selsact C/C++ Function [F:\BANNER\C\APPSTDI.PC] Use(select )
selsact C/C++ Function [F:\BANNER\C\SGPSTDN.PC] Use(select )
selsact C/C++ Function [F:\BANNER\C\SGRSTDN.PC] Use(select )
selsact1 C/C++ Function [F:\BANNER\C\SGPSTDN.PC] Use(select )
AS_STUDENT_ACTIVITY VIEW S4B70.BANINST1 Use(select )
SGVSACT VIEW S4B70.BANINST1 Use(select )
SOVSACT VIEW S4B70.BANINST1 Use(select )
KEY_DELREC Forms Trigger BANNER7_FORMS_10G.SGASTDN.SGBSTDN Use(select )
KEY_DELREC Forms Trigger BANNER7_FORMS.SGASTDN.SGBSTDN Use(select )
CHK_DUP Forms Function BANNER7_FORMS_10G.SGASTDN Use(select )
CHK_DUP Forms Function BANNER7_FORMS.SGASTDN Use(select )
SGRSACT SYNONYM S4B70.PUBLIC Rely on ()
SGRSACT Forms DataBlock BANNER7_FORMS_10G.SGASTDN Rely on () Use(insert,update,delete,select )
SGRSACT Forms DataBlock BANNER7_FORMS.SGASTDN Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
SGRSACT_KEY_INDEX INDEX S4B70.SATURN Rely on ()
STVACTC TABLE S4B70.SATURN Refer( No Action )
STVTERM TABLE S4B70.SATURN Refer( No Action )

Comments

Source Code Comments

Student Activity Repeating Table

Columns Comments for SGRSACT_PIDM (1)

Source Code Comments

This field identifies the student internal identification number.

Columns Comments for SGRSACT_ACTC_CODE (2)

Source Code Comments

This field identifies the type of activity to be recorded on the student record.

Columns Comments for SGRSACT_TERM_CODE (3)

Source Code Comments

This field identifies the effective date of the student activity to be recorded on the student record.

Columns Comments for SGRSACT_ACTIVITY_DATE (4)

Source Code Comments

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

Table SGRSATT

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SGRSATT_PIDM SGRSATT_PIDM NUMBER(8,0) No
SGRSATT_TERM_CODE_EFF SGRSATT_TERM_CODE_EFF VARCHAR2(6) No *
SGRSATT_ATTS_CODE SGRSATT_ATTS_CODE VARCHAR2(4) Yes *
SGRSATT_ACTIVITY_DATE SGRSATT_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
SGRSATT_ATTS_CODE STVATTS_CODE STVATTS
SGRSATT_TERM_CODE_EFF STVTERM_CODE STVTERM

Index

Index Name Index Type Column Name
SGRSATT_KEY_INDEX Unique SGRSATT_PIDM
SGRSATT_KEY_INDEX Unique SGRSATT_TERM_CODE_EFF
SGRSATT_KEY_INDEX Unique SGRSATT_ATTS_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
select_student_class C/C++ Function [F:\BANNER\C\SHREDIY.PC] Use(select )
CAA9 Cobol Paragraph [F:\banner\cobol].SCTH1000.AAA Use(select )
delsatt C/C++ Function [F:\BANNER\C\SGPSTDN.PC] Use(delete )
get_stu_attributes C/C++ Function [F:\BANNER\C\SMRJOBS.PC] Use(select )
getdata C/C++ Function [F:\BANNER\C\SFRNSLC.PC] Use(select )
process_prog_attr C/C++ Function [F:\BANNER\C\SMRGEVL.PC] Use(select )
selsatt C/C++ Function [F:\BANNER\C\SGPSTDN.PC] Use(select )
selsatt1 C/C++ Function [F:\BANNER\C\SGPSTDN.PC] Use(select )
AS_STUDENT_ATTRIBUTE VIEW S4B70.BANINST1 Use(select )
SGVSATT VIEW S4B70.BANINST1 Use(select )
SOVSATT VIEW S4B70.BANINST1 Use(select )
END_SATT_TERM Forms Trigger BANNER7_FORMS_10G.SGASADD.SGRSATT Use(insert )
END_SATT_TERM Forms Trigger BANNER7_FORMS.SGASADD.SGRSATT Lock
INSERT_TRIG Forms Trigger BANNER7_FORMS_10G.SGASADD.SGRSATT Lock
INSERT_TRIG Forms Trigger BANNER7_FORMS.SGASADD.SGRSATT Lock
KEY-DELREC Forms Trigger BANNER7_FORMS_10G.SGASADD.SGRSATT Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS.SGASADD.SGRSATT Use(select )
KEY_DELREC Forms Trigger BANNER7_FORMS_10G.SGASTDN.SGBSTDN Use(select )
KEY_DELREC Forms Trigger BANNER7_FORMS.SGASTDN.SGBSTDN Use(select )
PRE-INSERT Forms Trigger BANNER7_FORMS_10G.SGASADD.SGRSATT Use(delete )
PRE-INSERT Forms Trigger BANNER7_FORMS.SGASADD.SGRSATT Use(delete )
PRE-QUERY Forms Trigger BANNER7_FORMS_10G.SGASADD.SGRSATT Use(select )
PRE-QUERY Forms Trigger BANNER7_FORMS.SGASADD.SGRSATT Use(select )
S$_CLASS_CALC Forms Procedure BANNER7_FORMS.SOQRPLS Use(select )
S$_CLASS_CALC Forms Procedure BANNER7_FORMS_10G.SOQRPLS Use(select )
F_CLASS_CALC_FNC FUNCTION S4B70.BANINST1 Use(select )
P_MATERIAL_MATCHING Package procedure S4B70.BANINST1.SOKCPLN Use(select )
P_CLASS_CALC Package procedure S4B70.BANINST1.SOKLIBS Use(select )
P_INSERT_ATTRIBUTE Package procedure S4B70.BANINST1.SAKMODS Use(insert,select )
F_CLASS_CODE Package function S4B70.BANINST1.SGKCLAS Use(select )
F_GET_END_SGRSATT_TERM Package function S4B70.BANINST1.SOKODSF Use(select )
F_SGRSATT_EXISTS Package function S4B70.BANINST1.SFKFEES Use(select )
SGRSATT SYNONYM S4B70.PUBLIC Rely on ()
SGRSATT Forms DataBlock BANNER7_FORMS_10G.SGASADD Rely on () Use(insert,update,delete,select )
SGRSATT Forms DataBlock BANNER7_FORMS.SGASADD Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
SGRSATT_KEY_INDEX INDEX S4B70.SATURN Rely on ()
STVATTS TABLE S4B70.SATURN Refer( No Action )
STVTERM TABLE S4B70.SATURN Refer( No Action )

Comments

Source Code Comments

Student Attribute Repeating Table.

Columns Comments for SGRSATT_PIDM (1)

Source Code Comments

Internal identification number for whom the attributes are associated with.

Columns Comments for SGRSATT_TERM_CODE_EFF (2)

Source Code Comments

The effective term associated with the attributes.

Columns Comments for SGRSATT_ATTS_CODE (3)

Source Code Comments

The student attributes for the person and term.

Columns Comments for SGRSATT_ACTIVITY_DATE (4)

Source Code Comments

The date the record was last updated.

Table SGRSCMT

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SGRSCMT_PIDM SGRSCMT_PIDM NUMBER(8,0) No
SGRSCMT_SEQ_NO SGRSCMT_SEQ_NO NUMBER(3,0) No
SGRSCMT_TERM_CODE SGRSCMT_TERM_CODE VARCHAR2(6) Yes *
SGRSCMT_COMMENT_TEXT SGRSCMT_COMMENT_TEXT VARCHAR2(4000) Yes
SGRSCMT_ACTIVITY_DATE SGRSCMT_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
SGRSCMT_TERM_CODE STVTERM_CODE STVTERM

Index

Index Name Index Type Column Name
SGRSCMT_KEY_INDEX SGRSCMT_PIDM

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
delscmt C/C++ Function [F:\BANNER\C\SGPSTDN.PC] Use(delete )
selscmt C/C++ Function [F:\BANNER\C\SGPSTDN.PC] Use(select )
selscmt C/C++ Function [F:\BANNER\C\SGRSTDN.PC] Use(select )
selscmt1 C/C++ Function [F:\BANNER\C\SGPSTDN.PC] Use(select )
SGRSCMT SYNONYM S4B70.PUBLIC Rely on ()
KEY_DELREC Forms Trigger BANNER7_FORMS_10G.SGASTDN.SGBSTDN Use(select )
KEY_DELREC Forms Trigger BANNER7_FORMS.SGASTDN.SGBSTDN Use(select )
PRE-INSERT Forms Trigger BANNER7_FORMS_10G.SGASTDN.SGRSCMT Use(select )
PRE-INSERT Forms Trigger BANNER7_FORMS.SGASTDN.SGRSCMT Use(select )
SGRSCMT Forms DataBlock BANNER7_FORMS_10G.SGASTDN Rely on () Use(insert,update,delete,select )
SGRSCMT Forms DataBlock BANNER7_FORMS.SGASTDN Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
SGRSCMT_KEY_INDEX INDEX S4B70.SATURN Rely on ()
STVTERM TABLE S4B70.SATURN Refer( No Action )

Comments

Source Code Comments

Student Comment Table

Columns Comments for SGRSCMT_PIDM (1)

Source Code Comments

This field identifies the student internal identification number.

Columns Comments for SGRSCMT_SEQ_NO (2)

Source Code Comments

This field assigns an internal sequence number to each comment record created. This field does not display on the form.

Columns Comments for SGRSCMT_TERM_CODE (3)

Source Code Comments

This field identifies the term associated with each comment associated with the student.

Columns Comments for SGRSCMT_COMMENT_TEXT (4)

Source Code Comments

This field identifies the comment text associated with the student.

Columns Comments for SGRSCMT_ACTIVITY_DATE (5)

Source Code Comments

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

Table SGRSPRT

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SGRSPRT_PIDM SGRSPRT_PIDM NUMBER(8,0) No *
SGRSPRT_TERM_CODE SGRSPRT_TERM_CODE VARCHAR2(6) No * *
SGRSPRT_ACTC_CODE SGRSPRT_ACTC_CODE VARCHAR2(8) No * *
SGRSPRT_SPST_CODE SGRSPRT_SPST_CODE VARCHAR2(2) Yes *
SGRSPRT_ELIG_CODE SGRSPRT_ELIG_CODE VARCHAR2(2) Yes *
SGRSPRT_ACTIVITY_DATE SGRSPRT_ACTIVITY_DATE DATE No
SGRSPRT_ATHL_AID_IND SGRSPRT_ATHL_AID_IND VARCHAR2(1) Yes

Foreign Key information

Column name is Foreign Key For Column on Table
SGRSPRT_SPST_CODE STVSPST_CODE STVSPST
SGRSPRT_ELIG_CODE STVELIG_CODE STVELIG
SGRSPRT_TERM_CODE STVTERM_CODE STVTERM
SGRSPRT_ACTC_CODE STVACTC_CODE STVACTC

Index

Index Name Index Type Column Name
PK_SGRSPRT Unique SGRSPRT_PIDM
PK_SGRSPRT Unique SGRSPRT_TERM_CODE
PK_SGRSPRT Unique SGRSPRT_ACTC_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
delsprt C/C++ Function [F:\BANNER\C\SGPSTDN.PC] Use(delete )
get_sport C/C++ Function [F:\BANNER\C\SHRIGRS.PC] Use(select )
get_sport_parm C/C++ Function [F:\BANNER\C\SHRIGRS.PC] Use(select )
get_student_sport C/C++ Function [F:\BANNER\C\SGRKNOW.PC] Use(select )
get_student_sport_aid C/C++ Function [F:\BANNER\C\SGRKNOW.PC] Use(select )
ins_sprt_acty C/C++ Function [F:\BANNER\C\APPSTDI.PC] Use(select )
ins_sprt_acyr C/C++ Function [F:\BANNER\C\APPSTDI.PC] Use(select )
selsprt C/C++ Function [F:\BANNER\C\APPSTDI.PC] Use(select )
selsprt C/C++ Function [F:\BANNER\C\SGPSTDN.PC] Use(select )
selsprt1 C/C++ Function [F:\BANNER\C\SGPSTDN.PC] Use(select )
SGRSPRT SYNONYM S4B70.PUBLIC Rely on ()
AS_SPORT VIEW S4B70.BANINST1 Use(select )
KEY-NXTBLK Forms Trigger BANNER7_FORMS_10G.SGASPRT.SGRSPRT Use(select )
KEY-NXTBLK Forms Trigger BANNER7_FORMS.SGASPRT.SGRSPRT Use(select )
KEY_DELREC Forms Trigger BANNER7_FORMS_10G.SGASTDN.SGBSTDN Use(select )
KEY_DELREC Forms Trigger BANNER7_FORMS.SGASTDN.SGBSTDN Use(select )
F_CONCAT_SGRSPRT FUNCTION S4B70.BANINST1 Use(select )
F_STUDENT_CHECK_FOR_MORE FUNCTION S4B70.BANINST1 Use(select )
SGRSPRT Forms DataBlock BANNER7_FORMS_10G.SGASPRT Rely on () Use(insert,update,delete,select )
SGRSPRT Forms DataBlock BANNER7_FORMS.SGASPRT Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_SGRSPRT INDEX S4B70.SATURN Rely on ()
STVACTC TABLE S4B70.SATURN Refer( No Action )
STVELIG TABLE S4B70.SATURN Refer( No Action )
STVSPST TABLE S4B70.SATURN Refer( No Action )
STVTERM TABLE S4B70.SATURN Refer( No Action )

Comments

Source Code Comments

Sport Table

Columns Comments for SGRSPRT_PIDM (1)

Source Code Comments

Internal Person Identification

Columns Comments for SGRSPRT_TERM_CODE (2)

Source Code Comments

Term Code

Columns Comments for SGRSPRT_ACTC_CODE (3)

Source Code Comments

Activity Code

Columns Comments for SGRSPRT_SPST_CODE (4)

Source Code Comments

Sport Status Code

Columns Comments for SGRSPRT_ELIG_CODE (5)

Source Code Comments

Eligibility Code

Columns Comments for SGRSPRT_ACTIVITY_DATE (6)

Source Code Comments

The Activity Date

Columns Comments for SGRSPRT_ATHL_AID_IND (7)

Source Code Comments

Sport Athletic Aid Indicator

Table SGRVETN

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SGRVETN_PIDM SGRVETN_PIDM NUMBER(8,0) No *
SGRVETN_TERM_CODE_VA SGRVETN_TERM_CODE_VA VARCHAR2(6) No * *
SGRVETN_VETC_CODE SGRVETN_VETC_CODE VARCHAR2(1) No *
SGRVETN_CERT_HOURS SGRVETN_CERT_HOURS NUMBER(9,3) No
SGRVETN_CERT_DATE SGRVETN_CERT_DATE DATE No
SGRVETN_ACTIVITY_DATE SGRVETN_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
SGRVETN_TERM_CODE_VA STVTERM_CODE STVTERM
SGRVETN_VETC_CODE STVVETC_CODE STVVETC

Index

Index Name Index Type Column Name
PK_SGRVETN Unique SGRVETN_PIDM
PK_SGRVETN Unique SGRVETN_TERM_CODE_VA

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
main C/C++ Function [F:\BANNER\C\SGRVETN.PC] Use()
selmass C/C++ Function [F:\BANNER\C\SGRVETN.PC] Use(select )
selvetn C/C++ Function [F:\BANNER\C\SGRSTDN.PC] Use(select )
SGRVETN SYNONYM S4B70.PUBLIC Rely on ()
ROVVETN VIEW S4B70.BANINST1 Use(select )
KEY_DELREC Forms Trigger BANNER7_FORMS_10G.SGASTDN.SGBSTDN Use(select )
KEY_DELREC Forms Trigger BANNER7_FORMS.SGASTDN.SGBSTDN Use(select )
F_GET_CURR_VETC_CODE Package function S4B70.BANINST1.SOKODSF Use(select )
F_VETERANSTUDENT Package function S4B70.BANINST1.SGKWEVN Use(select )
SGRVETN Forms DataBlock BANNER7_FORMS_10G.SGASTDN Rely on () Use(insert,update,delete,select )
SGRVETN Forms DataBlock BANNER7_FORMS.SGASTDN Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_SGRVETN INDEX S4B70.SATURN Rely on ()
STVTERM TABLE S4B70.SATURN Refer( No Action )
STVVETC TABLE S4B70.SATURN Refer( No Action )

Comments

Source Code Comments

Veteran Repeating Table

Columns Comments for SGRVETN_PIDM (1)

Source Code Comments

This field identifies the internal identification number of student.

Columns Comments for SGRVETN_TERM_CODE_VA (2)

Source Code Comments

This field identifies the effective term student is eligible for certification.

Columns Comments for SGRVETN_VETC_CODE (3)

Source Code Comments

This field identifies the specific veteran type associated with the student record.

Columns Comments for SGRVETN_CERT_HOURS (4)

Source Code Comments

This field identifies the number of credit hours student is certified for for the effective term.

Columns Comments for SGRVETN_CERT_DATE (5)

Source Code Comments

This field identifies the date student was certified to be eligible.

Columns Comments for SGRVETN_ACTIVITY_DATE (6)

Source Code Comments

This field identifies the date record was created or changed. This field does not display on this form.

Table SHRLGPA

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SHRLGPA_PIDM SHRLGPA_PIDM NUMBER(8,0) No *
SHRLGPA_LEVL_CODE SHRLGPA_LEVL_CODE VARCHAR2(2) No * *
SHRLGPA_GPA_TYPE_IND SHRLGPA_GPA_TYPE_IND VARCHAR2(1) No *
SHRLGPA_HOURS_ATTEMPTED SHRLGPA_HOURS_ATTEMPTED NUMBER(11,3) No
SHRLGPA_HOURS_EARNED SHRLGPA_HOURS_EARNED NUMBER(11,3) No
SHRLGPA_GPA_HOURS SHRLGPA_GPA_HOURS NUMBER(11,3) No
SHRLGPA_QUALITY_POINTS SHRLGPA_QUALITY_POINTS NUMBER(17,6) No
SHRLGPA_GPA SHRLGPA_GPA NUMBER(23,9) No
SHRLGPA_ACTIVITY_DATE SHRLGPA_ACTIVITY_DATE DATE No
SHRLGPA_HOURS_PASSED SHRLGPA_HOURS_PASSED NUMBER(11,3) No
SHRLGPA_GPA_CALC SHRLGPA_GPA_CALC VARCHAR2(1) No

Foreign Key information

Column name is Foreign Key For Column on Table
SHRLGPA_LEVL_CODE STVLEVL_CODE STVLEVL

Index

Index Name Index Type Column Name
PK_SHRLGPA Unique SHRLGPA_PIDM
PK_SHRLGPA Unique SHRLGPA_LEVL_CODE
PK_SHRLGPA Unique SHRLGPA_GPA_TYPE_IND

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
select_campus_gpa_overall C/C++ Function [F:\BANNER\C\SHREDIY.PC] Use(select )
select_gpa_totals C/C++ Function [F:\BANNER\C\SHREDIY.PC] Use(select )
select_level C/C++ Function [F:\BANNER\C\SHREDIY.PC] Use(select )
SAA2C Cobol Paragraph [F:\banner\cobol].SERSBREC.SAA-FETCH-SECT 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 )
segpal_o_totals C/C++ Function [F:\BANNER\C\ISRKTRN.PC] Use(select )
segpal_o_totals C/C++ Function [F:\BANNER\C\SHRTRTC.PC] Use(select )
sel_level_gpa C/C++ Function [F:\BANNER\C\ISRKGRD.PC] Use(select )
sel_overall C/C++ Function [F:\BANNER\C\ISRKGRD.PC] Use(select )
sel_trans_gpa C/C++ Function [F:\BANNER\C\ISRKGRD.PC] Use(select )
selcgpa C/C++ Function [F:\BANNER\C\SFRENRL.PC] Use(select )
selgpa_totals C/C++ Function [F:\BANNER\C\ISRKTRN.PC] Use(select )
selgpa_totals C/C++ Function [F:\BANNER\C\SHRTRTC.PC] Use(select )
sellevel C/C++ Function [F:\BANNER\C\ISRKTRN.PC] Use(select )
sellevel C/C++ Function [F:\BANNER\C\SHRTRTC.PC] Use(select )
sellevel C/C++ Function [F:\BANNER\C\SHRTPOP.PC] Use(select )
sellgpa C/C++ Function [F:\BANNER\C\SHRGRDE.PC] Use(select )
selmacro C/C++ Function [F:\BANNER\C\SHRTPOP.PC] Use(select )
selmacro1 C/C++ Function [F:\BANNER\C\SHRTPOP.PC] Use(select )
selmacro_levels C/C++ Function [F:\BANNER\C\SHRGPAC.PC] Use(select )
selover C/C++ Function [F:\BANNER\C\SHRGRDE.PC] Use(select )
seltran C/C++ Function [F:\BANNER\C\SHRGRDE.PC] Use(select )
SGBSTDN TABLE S4B70.SATURN Join
AS_GPA_LEVEL VIEW S4B70.BANINST1 Use(select )
SGVCLAS VIEW S4B70.BANINST1 Use(select )
SGVCLSR VIEW S4B70.BANINST1 Use(select )
SGVSTDN VIEW S4B70.BANINST1 Use(select )
SHVSUM2 VIEW S4B70.BANINST1 Use(select )
SOVCLAS VIEW S4B70.BANINST1 Use(select )
OLD_WHEN_VALIDATE_ITEM Forms Trigger BANNER7_FORMS.SHASUBJ.KEY_BLOCK.KEYBLCK_LEVL_CODE Use(select )
OLD_WHEN_VALIDATE_ITEM Forms Trigger BANNER7_FORMS_10G.SHASUBJ.KEY_BLOCK.KEYBLCK_LEVL_CODE Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS.SHATERM.KEY_BLOCK.KEYBLCK_LEVL_CODE Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS.SHARQTC.SHTTRAN.SHTTRAN_LEVL_CODE Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS_10G.SHATERM.KEY_BLOCK.KEYBLCK_LEVL_CODE Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS_10G.SHARQTC.SHTTRAN.SHTTRAN_TERM_CODE_IN_PRG Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS_10G.SHARQTC.SHTTRAN.SHTTRAN_LEVL_CODE Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS.SHARQTC.SHTTRAN.SHTTRAN_TERM_CODE_IN_PRG Use(select )
CHECK_OTHERS Forms Trigger BANNER7_FORMS.SHARQTC Use(select )
CHECK_OTHERS Forms Trigger BANNER7_FORMS_10G.SHARQTC Use(select )
CHECK_VALID_KEYS Forms Trigger BANNER7_FORMS.SHASUBJ Use(select )
CHECK_VALID_KEYS Forms Trigger BANNER7_FORMS_10G.SHASUBJ Use(select )
SHRLGPA_RG Forms Record Group BANNER7_FORMS.SHATERM Use(select )
SHRLGPA_RG Forms Record Group BANNER7_FORMS_10G.SHATCMT Use(select )
SHRLGPA_RG Forms Record Group BANNER7_FORMS_10G.SHASUBJ Use(select )
SHRLGPA_RG Forms Record Group BANNER7_FORMS.SHATCMT Use(select )
SHRLGPA_RG Forms Record Group BANNER7_FORMS_10G.SHATERM Use(select )
SHRLGPA_RG Forms Record Group BANNER7_FORMS.SHASUBJ Use(select )
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 )
DELETE_TGPA Forms Trigger BANNER7_FORMS.SHATRNS.SHRTRAM Use(select )
DELETE_TGPA Forms Trigger BANNER7_FORMS_10G.SHATRNS.SHRTRAM Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS.SHAPCMP.SHRTGPA Use(delete )
KEY-DELREC Forms Trigger BANNER7_FORMS_10G.SHAPCMP.SHRTGPA Use(delete )
NEW_KEY_DELREC Forms Trigger BANNER7_FORMS.SHAPCMP.SHRTGPA Use(delete )
NEW_KEY_DELREC Forms Trigger BANNER7_FORMS_10G.SHAPCMP.SHRTGPA Use(delete )
OLD_CALC_GPA Forms Trigger BANNER7_FORMS.SHATAEQ.ROLL_BLOCK Use(insert,update,select )
OLD_CALC_GPA Forms Trigger BANNER7_FORMS_10G.SHATAEQ.ROLL_BLOCK Use(insert,update,select )
SHRLGPA_CALC Forms Trigger BANNER7_FORMS.SHATRNS.SHRTRAM Use(update )
SHRLGPA_CALC Forms Trigger BANNER7_FORMS_10G.SHATRNS.SHRTRAM Use(update )
DELETE_SHRLGPA_6 Forms Procedure BANNER7_FORMS.SHATRNS Use(delete )
DELETE_SHRLGPA_6 Forms Procedure BANNER7_FORMS_10G.SHATRNS Use(delete )
INSERT_SHRLGPA_1 Forms Procedure BANNER7_FORMS.SHATRNS Use(insert )
INSERT_SHRLGPA_1 Forms Procedure BANNER7_FORMS_10G.SHATRNS Use(insert )
F_CONCAT_AS_OF_CUM_GPA FUNCTION S4B70.BANINST1 Rely on ()
F_CONCAT_TERM_GPA FUNCTION S4B70.BANINST1 Rely on ()
SELECT_SHRLGPA_1 Forms Function BANNER7_FORMS.SHASUBJ Use(select )
SELECT_SHRLGPA_1 Forms Function BANNER7_FORMS_10G.RPQLELG Use(select )
SELECT_SHRLGPA_1 Forms Function BANNER7_FORMS.RPQLELG Use(select )
SELECT_SHRLGPA_1 Forms Function BANNER7_FORMS_10G.SHATERM Use(select )
SELECT_SHRLGPA_1 Forms Function BANNER7_FORMS_10G.SHARQTC Use(select )
SELECT_SHRLGPA_1 Forms Function BANNER7_FORMS_10G.SHASUBJ Use(select )
SELECT_SHRLGPA_1 Forms Function BANNER7_FORMS.SHARQTC Use(select )
SELECT_SHRLGPA_1 Forms Function BANNER7_FORMS.SHATERM Use(select )
SELECT_SHRLGPA_10 Forms Function BANNER7_FORMS.SHATRNS Use(select )
SELECT_SHRLGPA_10 Forms Function BANNER7_FORMS_10G.SHATRNS Use(select )
SELECT_SHRLGPA_2 Forms Function BANNER7_FORMS.SHATRNS Use(select )
SELECT_SHRLGPA_2 Forms Function BANNER7_FORMS_10G.SHATRNS Use(select )
SELECT_SHRLGPA_2 Forms Function BANNER7_FORMS.RSIHIST Use(select )
SELECT_SHRLGPA_2 Forms Function BANNER7_FORMS_10G.RSIHIST Use(select )
SELECT_SHRLGPA_3 Forms Function BANNER7_FORMS.SHASUBJ Use(select )
SELECT_SHRLGPA_3 Forms Function BANNER7_FORMS.SHATERM Use(select )
SELECT_SHRLGPA_3 Forms Function BANNER7_FORMS_10G.SHASUBJ Use(select )
SELECT_SHRLGPA_3 Forms Function BANNER7_FORMS_10G.SHATERM Use(select )
SELECT_SHRLGPA_4 Forms Function BANNER7_FORMS.SHARQTC Use(select )
SELECT_SHRLGPA_4 Forms Function BANNER7_FORMS_10G.SHAINST Use(select )
SELECT_SHRLGPA_4 Forms Function BANNER7_FORMS.RPQLELG Use(select )
SELECT_SHRLGPA_4 Forms Function BANNER7_FORMS.SHAINST Use(select )
SELECT_SHRLGPA_4 Forms Function BANNER7_FORMS_10G.RPQLELG Use(select )
SELECT_SHRLGPA_4 Forms Function BANNER7_FORMS_10G.SHARQTC Use(select )
SELECT_SHRLGPA_5 Forms Function BANNER7_FORMS.SHARQTC Use(select )
SELECT_SHRLGPA_5 Forms Function BANNER7_FORMS.RSIHIST Use(select )
SELECT_SHRLGPA_5 Forms Function BANNER7_FORMS_10G.RSIHIST Use(select )
SELECT_SHRLGPA_5 Forms Function BANNER7_FORMS_10G.SHARQTC Use(select )
SELECT_SHRLGPA_7 Forms Function BANNER7_FORMS.SHARQTC Use(select )
SELECT_SHRLGPA_7 Forms Function BANNER7_FORMS_10G.SHARQTC Use(select )
CLEANUP_GPA Package procedure S4B70.BANINST1.SHKCGPA Use(delete,select )
INSERT_SHRLGPA Package procedure S4B70.BANINST1.SHKCGPA Use(insert )
SUM_SHRLGPA Package procedure S4B70.BANINST1.SHKCGPA Use(select )
UPDATE_SHRLGPA Package procedure S4B70.BANINST1.SHKCGPA Use(update )
GETEARNEDHRSC Package cursor S4B70.BANINST1.BWCKREGS Use(select )
INSTGPAC Package cursor S4B70.BANINST1.BWSKOGRD Use(select )
TOTGPAC Package cursor S4B70.BANINST1.BWCKOTRN Rely on ()
TOTGPAC Package cursor S4B70.BANINST1.BWCKOTRN Use(select )
GPA_HRS Package variable S4B70.BANINST1.BWCKOTRN Rely on ()
HOLD_CGPA_GPA Package variable S4B70.BANINST1.SHKCGPA Rely on ()
HOLD_CGPA_GPA_HOURS Package variable S4B70.BANINST1.SHKCGPA Rely on ()
HOLD_CGPA_HOURS_ATTEMPTED Package variable S4B70.BANINST1.SHKCGPA Rely on ()
HOLD_CGPA_HOURS_EARNED Package variable S4B70.BANINST1.SHKCGPA Rely on ()
HOLD_CGPA_HOURS_PASSED Package variable S4B70.BANINST1.SHKCGPA Rely on ()
HOLD_CGPA_QUALITY_POINTS Package variable S4B70.BANINST1.SHKCGPA Rely on ()
QUAL_PTS Package variable S4B70.BANINST1.BWCKOTRN Rely on ()
SHRLGPA_I_ROW Package variable S4B70.BANINST1.SHKROLS Rely on ()
SHRLGPA_I_ROW Package variable S4B70.BANINST1.SHKROLS Rely on ()
SHRLGPA_O_ROW Package variable S4B70.BANINST1.SHKROLS Rely on ()
SHRLGPA_O_ROW Package variable S4B70.BANINST1.SHKROLS Rely on ()
STUD_HRS Package variable S4B70.BANINST1.BWCKREGS Rely on ()
F_GET_TERM_GPA Package function S4B70.BANINST1.BWSCXCHN Rely on ()
SHRLGPA_EXISTS Package function S4B70.BANINST1.SHKCGPA Use(select )
P_CALCULATE_PREV_CODE Package procedure S4B70.BANINST1.SHKPREV Rely on ()
P_CHECK_VOICE_AVAIL Package procedure S4B70.BANINST1.SFKFUNC Rely on ()
P_CUM_TERM_GPA Package procedure S4B70.BANINST1.SHKCGPA Rely on ()
P_DEGR_GPA Package procedure S4B70.BANINST1.SHKCGPA Rely on ()
P_GET_TERM_CUM_GPA Package procedure S4B70.BANINST1.SHKFUNC Rely on ()
P_INSERT_SHRLGPA Package procedure S4B70.BANINST1.SHKMODS Rely on () Use(insert )
P_SELECT_SHRLGPA_BY_MULTI Package procedure S4B70.BANINST1.SHKSELS Rely on ()
P_SELECT_SHRLGPA_BY_MULTI Package procedure S4B70.BANINST1.SHKSELS Rely on ()
P_SUBJ_GPA Package procedure S4B70.BANINST1.SHKCGPA Rely on ()
P_UPDATE_SHRLGPA Package procedure S4B70.BANINST1.SHKMODS Rely on () Use(update )
P_VIEWGRDE Package procedure S4B70.BANINST1.BWSKOGRD Rely on ()
P_VIEWTRANSCRIPT Package procedure S4B70.BANINST1.BWCKOTRN Rely on ()
P_VR_GIVE_DECISION Package procedure S4B70.BANINST1.VRSKAADM Rely on ()
P_VR_LIST_GRADES Package procedure S4B70.BANINST1.VRHKGRDS Rely on ()
SHRLGPA_ROW_BY_MULTI_C Package cursor S4B70.BANINST1.SHKSELS Rely on ()
SHRLGPA_ROW_BY_MULTI_C Package cursor S4B70.BANINST1.SHKSELS Rely on () Use(select )
F_CHECK_MGMT_CONTROL Package function S4B70.BANINST1.SFKRCTL Rely on ()
F_GET_CREDIT_HOURS Package function S4B70.BANINST1.SHKSELS Rely on ()
F_GET_CREDIT_HOURS Package function S4B70.BANINST1.SHKSELS Rely on ()
F_GET_LEVL_GPA Package function S4B70.BANINST1.SHKSELS Rely on ()
F_GET_LEVL_GPA Package function S4B70.BANINST1.SHKSELS Use(select )
F_GET_TERM_GPA Package function S4B70.BANINST1.SHKSELS Rely on ()
F_GET_TERM_GPA Package function S4B70.BANINST1.LMARINCH Rely on ()
F_REG_CRITERIA_MET Package function S4B70.BANINST1.SFKSELS Rely on ()
SHRLGPA SYNONYM S4B70.PUBLIC Rely on ()

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_SHRLGPA INDEX S4B70.SATURN Rely on ()
STVLEVL TABLE S4B70.SATURN Refer( No Action )

Comments

Source Code Comments

Level GPA Table

Columns Comments for SHRLGPA_PIDM (1)

Source Code Comments

Internal Identification Number of Student.

Columns Comments for SHRLGPA_LEVL_CODE (2)

Source Code Comments

Level Code associated with GPA hours and calculations.

Columns Comments for SHRLGPA_GPA_TYPE_IND (3)

Source Code Comments

GPA Type Indicator. Valid values are: I - Institutional Course GPA, T - Transfer Course GPA, and O - Overall Course GPA.

Columns Comments for SHRLGPA_HOURS_ATTEMPTED (4)

Source Code Comments

Hours Attempted for the level.

Columns Comments for SHRLGPA_HOURS_EARNED (5)

Source Code Comments

Hours Earned for the level.

Columns Comments for SHRLGPA_GPA_HOURS (6)

Source Code Comments

Hours Used for GPA calculation for the level.

Columns Comments for SHRLGPA_QUALITY_POINTS (7)

Source Code Comments

Quality Points for the level. Calculated by multiplying credit hours of the course by quality points associated with the grade.

Columns Comments for SHRLGPA_GPA (8)

Source Code Comments

GPA for the level. Calculated by dividing GPA hours for the level into Quality points for the level.

Columns Comments for SHRLGPA_ACTIVITY_DATE (9)

Source Code Comments

Activtity Date. Specifies the date record was created or updated.

Columns Comments for SHRLGPA_HOURS_PASSED (10)

Source Code Comments

Hours Passed for the level.

Columns Comments for SHRLGPA_GPA_CALC (11)

Source Code Comments

This field is used to determine whether the gpa for a student needs to be recalculated or not. Y means the gpa is up to date and N means the student has had courses rolled to history and the gpa needs to be recalulated for them

Table SHRTTRM

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SHRTTRM_PIDM SHRTTRM_PIDM NUMBER(8,0) No * *
SHRTTRM_TERM_CODE SHRTTRM_TERM_CODE VARCHAR2(6) No * *
SHRTTRM_UPDATE_SOURCE_IND SHRTTRM_UPDATE_SOURCE_IND VARCHAR2(1) No
SHRTTRM_PRE_CATALOG_IND SHRTTRM_PRE_CATALOG_IND VARCHAR2(1) Yes
SHRTTRM_RECORD_STATUS_IND SHRTTRM_RECORD_STATUS_IND VARCHAR2(1) No
SHRTTRM_RECORD_STATUS_DATE SHRTTRM_RECORD_STATUS_DATE DATE No
SHRTTRM_GRADE_MAILING_DATE SHRTTRM_GRADE_MAILING_DATE DATE Yes
SHRTTRM_GRADE_MAILER_CHG_DATE SHRTTRM_GRADE_MAILER_CHG_DATE DATE Yes
SHRTTRM_GRADE_MAILER_DUP SHRTTRM_GRADE_MAILER_DUP VARCHAR2(1) Yes
SHRTTRM_GRADE_MAILER_DUP_DATE SHRTTRM_GRADE_MAILER_DUP_DATE DATE Yes
SHRTTRM_EXAM_CODE SHRTTRM_EXAM_CODE VARCHAR2(2) Yes *
SHRTTRM_CODE_TRANSCRIPT_DIST SHRTTRM_CODE_TRANSCRIPT_DIST VARCHAR2(2) Yes
SHRTTRM_ASTD_CODE_END_OF_TERM SHRTTRM_ASTD_CODE_END_OF_TERM VARCHAR2(2) Yes *
SHRTTRM_ASTD_DATE_END_OF_TERM SHRTTRM_ASTD_DATE_END_OF_TERM DATE Yes
SHRTTRM_ACTIVITY_DATE SHRTTRM_ACTIVITY_DATE DATE No
SHRTTRM_ASTD_CODE_DL SHRTTRM_ASTD_CODE_DL VARCHAR2(2) Yes *
SHRTTRM_ASTD_DATE_DL SHRTTRM_ASTD_DATE_DL DATE Yes
SHRTTRM_WRSN_CODE SHRTTRM_WRSN_CODE VARCHAR2(2) Yes *
SHRTTRM_SBGI_CODE_TRANS SHRTTRM_SBGI_CODE_TRANS VARCHAR2(6) Yes *
SHRTTRM_PREV_CODE SHRTTRM_PREV_CODE VARCHAR2(2) Yes *
SHRTTRM_PREV_DATE SHRTTRM_PREV_DATE DATE Yes
SHRTTRM_CAST_CODE SHRTTRM_CAST_CODE VARCHAR2(2) Yes *
SHRTTRM_CAST_DATE SHRTTRM_CAST_DATE DATE Yes

Foreign Key information

Column name is Foreign Key For Column on Table
SHRTTRM_CAST_CODE STVCAST_CODE STVCAST
SHRTTRM_WRSN_CODE STVWRSN_CODE STVWRSN
SHRTTRM_TERM_CODE STVTERM_CODE STVTERM
SHRTTRM_ASTD_CODE_END_OF_TERM STVASTD_CODE STVASTD
SHRTTRM_ASTD_CODE_DL STVASTD_CODE STVASTD
SHRTTRM_EXAM_CODE STVEXAM_CODE STVEXAM
SHRTTRM_PREV_CODE STVPREV_CODE STVPREV
SHRTTRM_SBGI_CODE_TRANS STVSBGI_CODE STVSBGI
SHRTTRM_PIDM SFRENRL_PIDM SFRENRL
SHRTTRM_TERM_CODE SFRENRL_TERM_CODE SFRENRL

Index

Index Name Index Type Column Name
PK_SHRTTRM Unique SHRTTRM_PIDM
PK_SHRTTRM Unique SHRTTRM_TERM_CODE
SHRTTRM_KEY_INDEX2 SHRTTRM_TERM_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
sel_grad_hist C/C++ Function [F:\BANNER\C\TSP1098.PC] Use(select )
select_term_header C/C++ Function [F:\BANNER\C\SHREDIY.PC] Use(select )
MAA3 Cobol Paragraph [F:\banner\cobol].SERSBREC.MAA-MAINLINE-SECT Use(select )
checkreadm C/C++ Function [F:\BANNER\C\SFPCREQ.PC] Use(select )
findterm C/C++ Function [F:\BANNER\C\SHRTPOP.PC] Use(select )
get_allStuIDs C/C++ Function [F:\BANNER\C\SHRPREV.PC] Use(select )
get_employment C/C++ Function [F:\BANNER\C\SHRIGRS.PC] Use(select )
get_good_standing C/C++ Function [F:\BANNER\C\SHRIGRS.PC] Use(select )
get_history C/C++ Function [F:\BANNER\C\SGRCHRT.PC] Use(select )
get_transfer C/C++ Function [F:\BANNER\C\SHRIGRS.PC] Use(select )
print_summary C/C++ Function [F:\BANNER\C\SHRIGRS.PC] Use(select )
sel_deans_list_desc C/C++ Function [F:\BANNER\C\ISRKGRD.PC] Use(select )
sel_orig_astd_and_dl C/C++ Function [F:\BANNER\C\SHRASTD.PC] Use(select )
sel_term_astd C/C++ Function [F:\BANNER\C\ISRKGRD.PC] Use(select )
selah C/C++ Function [F:\BANNER\C\SAPADMS.PC] Use(select )
selalum_chld_sps C/C++ Function [F:\BANNER\C\AGPMATG.PC] Use(select )
selastd C/C++ Function [F:\BANNER\C\SHRTRTC.PC] Use(select )
selastd2 C/C++ Function [F:\BANNER\C\SHRTRTC.PC] Use(select )
selattend C/C++ Function [F:\BANNER\C\AGPMATG.PC] Use(select )
selcurr C/C++ Function [F:\BANNER\C\APPSTDI.PC] Use(select )
seldel C/C++ Function [F:\BANNER\C\SGPSTDN.PC] Use(select )
select_all_terms C/C++ Function [F:\BANNER\C\SHRTRTC.PC] Use(select )
selltrm C/C++ Function [F:\BANNER\C\SFRENRL.PC] Use(select )
selmacro C/C++ Function [F:\BANNER\C\APPSTDI.PC] Use(select )
selmacro C/C++ Function [F:\BANNER\C\SHRASTD.PC] Use(select )
selmacro C/C++ Function [F:\BANNER\C\SHRTYPE.PC] Use(select )
selmacro C/C++ Function [F:\BANNER\C\SHRCONV.PC] Use(select )
selmacro3 C/C++ Function [F:\BANNER\C\SERPSRC.PC] Use(select )
selnon_curr C/C++ Function [F:\BANNER\C\APPSTDI.PC] Use(select )
selterm C/C++ Function [F:\BANNER\C\SFRENRL.PC] Use(select )
selttrm C/C++ Function [F:\BANNER\C\ISRKTRN.PC] Use(select )
selttrm C/C++ Function [F:\BANNER\C\SORHSRP.PC] Use(select )
selttrm C/C++ Function [F:\BANNER\C\SFRENRL.PC] Use(select )
selttrm_curr_astd C/C++ Function [F:\BANNER\C\SHRGRDE.PC] Use(select )
selttrm_curr_dastd C/C++ Function [F:\BANNER\C\SHRGRDE.PC] Use(select )
sport_report C/C++ Function [F:\BANNER\C\SHRIGRS.PC] Use(select )
update_ttrm C/C++ Function [F:\BANNER\C\SHRASTD.PC] Use(update )
update_ttrm_orig C/C++ Function [F:\BANNER\C\SHRGRDE.PC] Use(update )
update_ttrm_other C/C++ Function [F:\BANNER\C\SHRGRDE.PC] Use(update )
SGBSTDN TABLE S4B70.SATURN Join
SHRCHRT TABLE S4B70.SATURN Refer( No Action )
SHRTCKN TABLE S4B70.SATURN Refer( No Action )
AS_ENROLLMENT VIEW S4B70.BANINST1 Use(select )
SFVENRL VIEW S4B70.BANINST1 Use(select )
SFVETR2 VIEW S4B70.BANINST1 Use(select )
SFVSTC2 VIEW S4B70.BANINST1 Use(select )
SGVSTDN VIEW S4B70.BANINST1 Use(select )
SHVACST VIEW S4B70.BANINST1 Use(select )
SHVDEAN VIEW S4B70.BANINST1 Use(select )
SHVDTL2 VIEW S4B70.BANINST1 Use(select )
SHVSUM2 VIEW S4B70.BANINST1 Use(select )
SHVTER1 VIEW S4B70.BANINST1 Use(select )
SHVYEA0 VIEW S4B70.BANINST1 Use(select )
SHVYEA1 VIEW S4B70.BANINST1 Use(select )
SOVTTRM VIEW S4B70.BANINST1 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.RSISTDN.ROVSTDN.ROVSTDN_TERM_CODE_EFF Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.RSISTDN.ROVSTDN.ROVSTDN_TERM_CODE_EFF Use(select )
CHECK_FOR_PRECATALOG Forms Trigger BANNER7_FORMS.SHAINST Use(select )
CHECK_FOR_PRECATALOG Forms Trigger BANNER7_FORMS.SHACRSE Use(select )
CHECK_FOR_PRECATALOG Forms Trigger BANNER7_FORMS_10G.SHACRSE Use(select )
CHECK_FOR_PRECATALOG Forms Trigger BANNER7_FORMS_10G.SHAINST Use(select )
CURR_STAT Forms Trigger BANNER7_FORMS_10G.RSIHIST Use(select )
CURR_STAT Forms Trigger BANNER7_FORMS.RSIHIST Use(select )
GET_ACAD_STAND Forms Trigger BANNER7_FORMS.SHATERM Use(select )
GET_ACAD_STAND Forms Trigger BANNER7_FORMS.SHATRMC Use(select )
GET_ACAD_STAND Forms Trigger BANNER7_FORMS_10G.SHATERM Use(select )
GET_ACAD_STAND Forms Trigger BANNER7_FORMS_10G.SHATRMC Use(select )
GET_MHRS Forms Trigger BANNER7_FORMS.SFAREGS Use(select )
GET_MHRS Forms Trigger BANNER7_FORMS_10G.SFAREGS Use(select )
GET_OVERALL_INFO Forms Trigger BANNER7_FORMS.SHASUBJ Use(select )
GET_OVERALL_INFO Forms Trigger BANNER7_FORMS_10G.SHASUBJ Use(select )
INSERT_SHRGCOL Forms Trigger BANNER7_FORMS.SHATCKC Use(select )
INSERT_SHRGCOL Forms Trigger BANNER7_FORMS_10G.SHATCKS Use(select )
INSERT_SHRGCOL Forms Trigger BANNER7_FORMS_10G.SHATCKP Use(select )
INSERT_SHRGCOL Forms Trigger BANNER7_FORMS_10G.SHATCKC Use(select )
INSERT_SHRGCOL Forms Trigger BANNER7_FORMS_10G.SHATCKN Use(select )
INSERT_SHRGCOL Forms Trigger BANNER7_FORMS.SHATCKS Use(select )
INSERT_SHRGCOL Forms Trigger BANNER7_FORMS.SHATCKP Use(select )
UPDATE_SHRTTRM Forms Trigger BANNER7_FORMS.SHATCKC Use(update,select )
UPDATE_SHRTTRM Forms Trigger BANNER7_FORMS.SHATCKP Use(update )
UPDATE_SHRTTRM Forms Trigger BANNER7_FORMS_10G.SHATCKN Use(update,select )
UPDATE_SHRTTRM Forms Trigger BANNER7_FORMS_10G.SHATCKC Use(update,select )
UPDATE_SHRTTRM Forms Trigger BANNER7_FORMS_10G.SHATCKS Use(update,select )
UPDATE_SHRTTRM Forms Trigger BANNER7_FORMS_10G.SHATCKP Use(update )
UPDATE_SHRTTRM Forms Trigger BANNER7_FORMS.SHATCKS Use(update,select )
WHERE_TO_GO Forms Trigger BANNER7_FORMS_10G.SHACRSE Use(select )
WHERE_TO_GO Forms Trigger BANNER7_FORMS.SHACRSE Use(select )
GET_ACADEMIC_HISTORY_DATA Forms Trigger BANNER7_FORMS.RPQLELG.RPRLAPP Use(select )
GET_ACADEMIC_HISTORY_DATA Forms Trigger BANNER7_FORMS_10G.RPQLELG.RPRLAPP Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS_10G.SAAQUIK.SGBSTDN Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS_10G.SHAGRDE.SHRGRDE Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS.SAAQUIK.SGBSTDN Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS.SHAGRDE.SHRGRDE Use(select )
KEY_DELREC Forms Trigger BANNER7_FORMS_10G.SGASTDN.SGBSTDN Use(select )
KEY_DELREC Forms Trigger BANNER7_FORMS.SGASTDN.SGBSTDN Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS.SHAINST.SHRTGPA Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS_10G.RSIHIST.SHRTGPA Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS.SGASTDN.SGBSTDN Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS.SGASTDQ.SGBSTDN Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS.RSIHIST.SHRTGPA Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS.SFARQST.SGBSTDN Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS_10G.SHARQTC.STVLEVL Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS_10G.SHAINST.SHRTGPA Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS_10G.SGASTDQ.SGBSTDN Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS_10G.SGASTDN.SGBSTDN Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS_10G.SFARQST.SGBSTDN Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS.SHARQTC.STVLEVL Use(select )
POST_QUERY Forms Trigger BANNER7_FORMS.SFAREGS.SGBSTDN Use(select )
POST_QUERY Forms Trigger BANNER7_FORMS_10G.SFAREGS.SGBSTDN Use(select )
PRE-DELETE Forms Trigger BANNER7_FORMS_10G.SAAQUIK.SGBSTDN Use(select )
PRE-DELETE Forms Trigger BANNER7_FORMS.SAAQUIK.SGBSTDN Use(select )
PRE-INSERT Forms Trigger BANNER7_FORMS.SHATCKC.SHRTCKN Use(select )
PRE-INSERT Forms Trigger BANNER7_FORMS.SHATCKS.SHRTCKN Use(select )
PRE-INSERT Forms Trigger BANNER7_FORMS_10G.SHATCKS.SHRTCKN Use(select )
PRE-INSERT Forms Trigger BANNER7_FORMS_10G.SHATCKP.SHRTCKN Use(select )
PRE-INSERT Forms Trigger BANNER7_FORMS_10G.SHATCKC.SHRTCKN Use(select )
PRE-INSERT Forms Trigger BANNER7_FORMS_10G.SHATCKN.SHRTCKN Use(select )
PRE-INSERT Forms Trigger BANNER7_FORMS.SHATCKP.SHRTCKN Use(select )
GET_TERM_CODE Forms Procedure BANNER7_FORMS.SHARQTC Rely on ()
GET_TERM_CODE Forms Procedure BANNER7_FORMS_10G.SHARQTC Use(select )
GET_TERM_CODE Forms Procedure BANNER7_FORMS_10G.SHARQTC Rely on ()
GET_TERM_CODE Forms Procedure BANNER7_FORMS.SHARQTC Use(select )
F_ASTD_END_OF_TERM FUNCTION S4B70.BANINST1 Use(select )
F_CONCAT_PREV_TERM_GPA FUNCTION S4B70.BANINST1 Use(select )
F_GET_SHRTTRM_ROWID FUNCTION S4B70.BANINST1 Use(select )
F_LATEST_TERM_FNC FUNCTION S4B70.BANINST1 Use(select )
SELECT_SHRTTRM_3 Forms Function BANNER7_FORMS_10G.SFARQST Use(select )
SELECT_SHRTTRM_3 Forms Function BANNER7_FORMS.SFARQST Use(select )
SELECT_SHRTTRM_4 Forms Function BANNER7_FORMS.SHATCKS Use(select )
SELECT_SHRTTRM_4 Forms Function BANNER7_FORMS_10G.SHATCKN Use(select )
SELECT_SHRTTRM_4 Forms Function BANNER7_FORMS_10G.SHATCKS Use(select )
SELECT_SHRTTRM_6 Forms Function BANNER7_FORMS_10G.SHAINST Use(select )
SELECT_SHRTTRM_6 Forms Function BANNER7_FORMS.SHAINST Use(select )
FINAL_GRADES_DISPLAY_C Package cursor S4B70.BANINST1.SFKCURS Use(select )
SHRTTRM_TAB_TYPE Package Type S4B70.BANINST1.SOKTABS Rely on ()
P_BUILDSOTWENR Package procedure S4B70.BANINST1.SOKWEXT Use(select )
P_GETACADINFO Package procedure S4B70.BANINST1.BWCKGSTU Use(select )
P_PROC_SET_INFO Package procedure S4B70.BANINST1.BWSKWTRR Rely on ()
UT_SB_ENROLLMENTCREATEAPI Package procedure S4B70.BANINST1.UT_SB_ENROLLMENT Use(insert )
CURASTDC Package cursor S4B70.BANINST1.BWCKOTRN Rely on ()
CURASTDC Package cursor S4B70.BANINST1.BWCKOTRN Use(select )
CURASTDC Package cursor S4B70.BANINST1.BWSKOGRD Use(select )
DEANSLISTC Package cursor S4B70.BANINST1.BWCKOTRN Use(select )
SFRSTCR_LISTC Package cursor S4B70.BANINST1.BWSKWTRR Use(select )
SHRTTRM_ROW Package variable S4B70.BANINST1.SHKROLS Rely on ()
SHRTTRM_ROW Package variable S4B70.BANINST1.SHKROLS Rely on ()
F_CHECK_STATUS_ACAD_STAND Package function S4B70.BANINST1.SB_LEARNER Use(select )
F_CHECK_STATUS_COMB_ACAD_STAND Package function S4B70.BANINST1.SB_LEARNER Use(select )
F_GET_TERM Package function S4B70.BANINST1.BWSKWTRR Use(select )
P_ALLOW_REG_CAST Package procedure S4B70.BANINST1.SHKPREV Rely on ()
P_ALLOW_REG_CAST Package procedure S4B70.BANINST1.SHKPREV Rely on ()
P_CALCULATE_CAST_CODE Package procedure S4B70.BANINST1.SHKPREV Rely on ()
P_CALCULATE_CAST_CODE Package procedure S4B70.BANINST1.SHKPREV Rely on () Use(select )
P_CALCULATE_PREV_CODE Package procedure S4B70.BANINST1.SHKPREV Rely on ()
P_CALCULATE_PREV_CODE Package procedure S4B70.BANINST1.SHKPREV Rely on () Use(select )
P_DISP_CONFIRM Package procedure S4B70.BANINST1.BWSKWTRR Rely on ()
P_DISP_PAYMENT_TYPE Package procedure S4B70.BANINST1.BWSKWTRR Rely on ()
P_DISP_TRANSCRIPT_REQUEST_DATA Package procedure S4B70.BANINST1.BWSKWTRR Rely on ()
P_DISP_TRANS_REQUEST_CHARGES Package procedure S4B70.BANINST1.BWSKWTRR Rely on ()
P_GET_ACAD_STAND Package procedure S4B70.BANINST1.SHKFUNC Rely on ()
P_GET_ACAD_STAND Package procedure S4B70.BANINST1.SHKFUNC Rely on ()
P_GET_CAST Package procedure S4B70.BANINST1.SHKPREV Rely on ()
P_GET_CAST Package procedure S4B70.BANINST1.SHKPREV Rely on () Use(select )
P_GET_DEANSLIST_REFCURSOR Package procedure S4B70.BANINST1.SREFCUR Use(select )
P_INSERTSHRGCOL Package procedure S4B70.BANINST1.SHKWEVN Use(select )
P_INSERT_SHRTTRM Package procedure S4B70.BANINST1.SHKMODS Rely on () Use(insert )
P_SELECT_SHRTTRM_BY_PIDM_TERM Package procedure S4B70.BANINST1.SHKSELS Rely on ()
P_SELECT_SHRTTRM_BY_PIDM_TERM Package procedure S4B70.BANINST1.SHKSELS Rely on ()
P_UPDATE_PREV_CAST_CODES Package procedure S4B70.BANINST1.SHKPREV Rely on ()
P_UPDATE_PREV_CAST_CODES Package procedure S4B70.BANINST1.SHKPREV Use(update )
P_UPDATE_SHRTTRM Package procedure S4B70.BANINST1.SHKMODS Rely on () Use(update )
P_VERIFY_ELIGIBLE_TO_REGISTER Package procedure S4B70.BANINST1.VRSKFORG Rely on ()
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_GET_PROGRESS_DATA Package procedure S4B70.BANINST1.VRHKGRDS Rely on ()
P_VR_GET_PROGRESS_DATA Package procedure S4B70.BANINST1.VRHKGRDS Rely on ()
P_VR_LIST_GRADES Package procedure S4B70.BANINST1.VRHKGRDS Rely on ()
P_VR_LIST_GRADES Package procedure S4B70.BANINST1.VRHKGRDS 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 ()
SHRTTRMC Package cursor S4B70.BANINST1.SHKLIBS Rely on () Use(select )
SHRTTRM_BY_PIDM_TERM_C Package cursor S4B70.BANINST1.SHKSELS Rely on ()
SHRTTRM_BY_PIDM_TERM_C Package cursor S4B70.BANINST1.SHKSELS Rely on () Use(select )
SHRTTRM_ROW_BY_PIDM_TERM_C Package cursor S4B70.BANINST1.SHKSELS Rely on ()
SHRTTRM_ROW_BY_PIDM_TERM_C Package cursor S4B70.BANINST1.SHKSELS Rely on () Use(select )
F_CHECK_SGBSTDN_EXISTS Package function S4B70.BANINST1.SAKDCSN Use(select )
F_GET_MAX_SHRTTRM_REC Package function S4B70.BANINST1.SHKSELS Rely on ()
F_GET_MAX_SHRTTRM_REC Package function S4B70.BANINST1.SHKSELS Rely on ()
SHRTTRM SYNONYM S4B70.PUBLIC Rely on ()
SHRTTRM Forms DataBlock BANNER7_FORMS.SHAINST Rely on () Use(insert,update,delete,select )
SHRTTRM Forms DataBlock BANNER7_FORMS_10G.SHAINST Rely on () Use(insert,update,delete,select )
SHRTTRM Forms DataBlock BANNER7_FORMS.SHQTERM Rely on () Use(insert,update,delete,select )
SHRTTRM Forms DataBlock BANNER7_FORMS_10G.SHQTERM Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_SHRTTRM INDEX S4B70.SATURN Rely on ()
SHRTTRM_KEY_INDEX2 INDEX S4B70.SATURN Rely on ()
ST_WFAIR_WITHDRAW_STUDENT TRIGGER S4B70.SATURN Fire(insert after each row )
ST_WFAUR_WITHDRAW_STUDENT TRIGGER S4B70.SATURN Fire(update after each row )
SFRENRL TABLE S4B70.SATURN Join
STVASTD TABLE S4B70.SATURN Refer( No Action )
STVCAST TABLE S4B70.SATURN Refer( No Action )
STVEXAM TABLE S4B70.SATURN Refer( No Action )
STVPREV TABLE S4B70.SATURN Refer( No Action )
STVSBGI TABLE S4B70.SATURN Refer( No Action )
STVTERM TABLE S4B70.SATURN Refer( No Action )
STVWRSN TABLE S4B70.SATURN Refer( No Action )

Comments

Source Code Comments

Institutional Course Maintenance Term Header Repeating Table

Columns Comments for SHRTTRM_PIDM (1)

Source Code Comments

Internal Identification Number of Student.

Columns Comments for SHRTTRM_TERM_CODE (2)

Source Code Comments

Term Code. Term of student institutional course record.

Columns Comments for SHRTTRM_UPDATE_SOURCE_IND (3)

Source Code Comments

Source Indicator. Indicates sourse of how record was created. Valid values are: S - System created during grade roll process, and U - User created.

Columns Comments for SHRTTRM_PRE_CATALOG_IND (4)

Source Code Comments

Pre-Catalog Indicator. Specifies if the term course information if based on he existing Banner catalog or is conversion data being entered prior to the Banner catalog. Valid values are: Y - Pre-catalog
, and N - Current Catalog.

Columns Comments for SHRTTRM_RECORD_STATUS_IND (5)

Source Code Comments

Status Indicator. Specifies the status of the term record. Valid values are: G - Grade Mailer Pending, C - Grade Mailer processing complete, R - Revised Grade Mailer Pending, N - New Record.

Columns Comments for SHRTTRM_RECORD_STATUS_DATE (6)

Source Code Comments

Status Date. Date associated with the status of the record.

Columns Comments for SHRTTRM_GRADE_MAILING_DATE (7)

Source Code Comments

Grade Mailer Date. Indicates the date grade mailer was sent to the student.

Columns Comments for SHRTTRM_GRADE_MAILER_CHG_DATE (8)

Source Code Comments

Grade Mailer Change Date. Indicates the date a revised or duplicate grade mailer was sent to the student.

Columns Comments for SHRTTRM_GRADE_MAILER_DUP (9)

Source Code Comments

Grade Mailer Duplicate Indicator. Specifies that duplicate grade mailer should be sent to the student. Valid value is Y - Send duplicate mailer.

Columns Comments for SHRTTRM_GRADE_MAILER_DUP_DATE (10)

Source Code Comments

Duplicate Grade Mailer Date. Indicates date duplicate grade mailer was sent.

Columns Comments for SHRTTRM_EXAM_CODE (11)

Source Code Comments

Examination Code. Identifies a special examination the student took during the term.

Columns Comments for SHRTTRM_CODE_TRANSCRIPT_DIST (12)

Source Code Comments

This field is not currently used.

Columns Comments for SHRTTRM_ASTD_CODE_END_OF_TERM (13)

Source Code Comments

End of Term Academic Standing Code. Identifies student academic standing for the term (probation, good standing, etc.). Calculated based on the academic standing rules during the grade mailer pro
cess or may be directly entered.

Columns Comments for SHRTTRM_ASTD_DATE_END_OF_TERM (14)

Source Code Comments

Date Academic Standing was entered.

Columns Comments for SHRTTRM_ACTIVITY_DATE (15)

Source Code Comments

Activity Date. Specifies the date record was created or updated.

Columns Comments for SHRTTRM_ASTD_CODE_DL (16)

Source Code Comments

Deans List Code. Identifies if student qualified for deans list for the term. Calculated based on academic standing deans list rules or may be directly entered.

Columns Comments for SHRTTRM_ASTD_DATE_DL (17)

Source Code Comments

Date Deans List Status was entered.

Columns Comments for SHRTTRM_WRSN_CODE (18)

Source Code Comments

Reason for withdrawal from this institution.

Columns Comments for SHRTTRM_SBGI_CODE_TRANS (19)

Source Code Comments

Institution to which the student will transfer

Columns Comments for SHRTTRM_PREV_CODE (20)

Source Code Comments

Academic History Term record Progress Evaluation code. This code is populated by SHRPREV.

Columns Comments for SHRTTRM_PREV_DATE (21)

Source Code Comments

Academic History Term record Progress Evaluation date. This is the date progress evaluation code was updated.

Columns Comments for SHRTTRM_CAST_CODE (22)

Source Code Comments

Academic History Term record Combined Academic Standing code. This code is populated by SHRPREV.

Columns Comments for SHRTTRM_CAST_DATE (23)

Source Code Comments

Academic History Term record Combined Academic Standing date. This is the date combined academic standing code was updated.

Table SMRPRLE

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SMRPRLE_PROGRAM SMRPRLE_PROGRAM VARCHAR2(12) No *
SMRPRLE_PROGRAM_DESC SMRPRLE_PROGRAM_DESC VARCHAR2(30) No
SMRPRLE_ACTIVITY_DATE SMRPRLE_ACTIVITY_DATE DATE No
SMRPRLE_LEVL_CODE SMRPRLE_LEVL_CODE VARCHAR2(2) No *
SMRPRLE_CURR_IND SMRPRLE_CURR_IND VARCHAR2(1) No
SMRPRLE_LOCKED_IND SMRPRLE_LOCKED_IND VARCHAR2(1) No
SMRPRLE_CURR_RULE_IND SMRPRLE_CURR_RULE_IND VARCHAR2(1) No
SMRPRLE_CAMP_CODE SMRPRLE_CAMP_CODE VARCHAR2(3) Yes *
SMRPRLE_COLL_CODE SMRPRLE_COLL_CODE VARCHAR2(2) Yes *
SMRPRLE_DEGC_CODE SMRPRLE_DEGC_CODE VARCHAR2(6) Yes *
SMRPRLE_PIDM SMRPRLE_PIDM NUMBER(8,0) Yes
SMRPRLE_LEVL_CODE_STU SMRPRLE_LEVL_CODE_STU VARCHAR2(2) No *
SMRPRLE_WEB_IND SMRPRLE_WEB_IND VARCHAR2(1) No

Foreign Key information

Column name is Foreign Key For Column on Table
SMRPRLE_CAMP_CODE STVCAMP_CODE STVCAMP
SMRPRLE_COLL_CODE STVCOLL_CODE STVCOLL
SMRPRLE_DEGC_CODE STVDEGC_CODE STVDEGC
SMRPRLE_LEVL_CODE STVLEVL_CODE STVLEVL
SMRPRLE_LEVL_CODE_STU STVLEVL_CODE STVLEVL

Index

Index Name Index Type Column Name
PK_SMRPRLE Unique SMRPRLE_PROGRAM

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
val_program_code C/C++ Function [F:\BANNER\C\SARDCBT.PC] Use(select )
chk_active_prog C/C++ Function [F:\BANNER\C\SMRJOBS.PC] Use(select )
get_header_info C/C++ Function [F:\BANNER\C\SMRCRLT.PC] Use(select )
get_header_info2 C/C++ Function [F:\BANNER\C\SMRCRLT.PC] Use(select )
get_prog C/C++ Function [F:\BANNER\C\SHRTECA.PC] Use(select )
get_program_output_results C/C++ Function [F:\BANNER\C\SMRCRLT.PC] Use(select )
selprogr C/C++ Function [F:\BANNER\C\SCRBULT.PC] Use(select )
validate_prog C/C++ Function [F:\BANNER\C\SAPAMAL.PC] Use(select )
SMRPRLE SYNONYM S4B70.PUBLIC Rely on ()
SARADAP TABLE S4B70.SATURN Refer( No Action )
SARDCSN TABLE S4B70.SATURN Refer( No Action )
SARRRFT TABLE S4B70.SATURN Refer( No Action )
SARWADF TABLE S4B70.SATURN Refer( No Action )
SCRRPRG TABLE S4B70.SATURN Refer( No Action )
SFRRGFE TABLE S4B70.SATURN Refer( No Action )
SGBSTDN TABLE S4B70.SATURN Refer( No Action )
SHRDGMR TABLE S4B70.SATURN Refer( No Action )
SHRPREV TABLE S4B70.SATURN Refer( No Action )
SMBPGEN TABLE S4B70.SATURN Refer( No Action )
SMBPVPR TABLE S4B70.SATURN Refer( No Action )
SMRAUSE TABLE S4B70.SATURN Refer( No Action )
SMRPAAP TABLE S4B70.SATURN Refer( No Action )
SMRPATR TABLE S4B70.SATURN Refer( No Action )
SMRPCMT TABLE S4B70.SATURN Refer( No Action )
SMRPLVL TABLE S4B70.SATURN Refer( No Action )
SMRPNCR TABLE S4B70.SATURN Refer( No Action )
SMRPRGC TABLE S4B70.SATURN Refer( No Action )
SMRPRGD TABLE S4B70.SATURN Refer( No Action )
SMRPRSA TABLE S4B70.SATURN Refer( No Action )
SMRPRSC TABLE S4B70.SATURN Refer( No Action )
SOBCURR TABLE S4B70.SATURN Refer( No Action )
SORCOMM TABLE S4B70.SATURN Refer( No Action )
SOREQUI TABLE S4B70.SATURN Refer( No Action )
SRBPRED TABLE S4B70.SATURN Refer( No Action )
SRBRECR TABLE S4B70.SATURN Refer( No Action )
SRTPREL TABLE S4B70.SATURN Refer( No Action )
SSRRPRG TABLE S4B70.SATURN Refer( No Action )
SOVDATA VIEW S4B70.BANINST1 Use(select )
CHECK_PROGRAM Forms Trigger BANNER7_FORMS_10G.SAARRFT.SARRRFT.SARRRFT_PROGRAM Use(select )
CHECK_PROGRAM Forms Trigger BANNER7_FORMS_10G.SAARRFT.KEY_BLOCK.KEYBLOCK_PROGRAM Use(select )
CHECK_PROGRAM Forms Trigger BANNER7_FORMS.SFARGFE.SFRRGFE.SFRRGFE_PROGRAM Use(select )
CHECK_PROGRAM Forms Trigger BANNER7_FORMS.SAARRFT.SARRRFT.SARRRFT_PROGRAM Use(select )
CHECK_PROGRAM Forms Trigger BANNER7_FORMS.SAARRFT.KEY_BLOCK.KEYBLOCK_PROGRAM Use(select )
CHECK_PROGRAM Forms Trigger BANNER7_FORMS_10G.SFARGFE.SFRRGFE.SFRRGFE_PROGRAM Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SOAEQUI.KEY_BLOCK.PROGRAM_1 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SOAEQUI.KEY_BLOCK.PROGRAM_2 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SOAEQUI.SOREQUI.SOREQUI_PROGRAM_1 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SOAADAS.SORADDA.SORADDA_TO_VALUE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SOAADAS.SORADDA.SORADDA_FROM_VALUE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SOAEQUI.SOREQUI.SOREQUI_PROGRAM_2 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SHATATC.KEY_BLOCK.KEYBLOC_PROGRAM Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SOACURR.SOBCURR.SOBCURR_PROGRAM Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SSARRES.SSRRPRG.SSRRPRG_PROGRAM Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SCARRES.SCRRPRG.SCRRPRG_PROGRAM Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SHADGMQ.SHRDGMR.SHRDGMR_PROGRAM Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SHADIPL.KEY_BLOCK.DGMR_SEQ_NO Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SGAASST.SGRASSI.SGRASSI_PROGRAM Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SFARQST.SGBSTDN.SGBSTDN_PROGRAM_1 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SRAPRED.SRBPRED.SRBPRED_PROGRAM Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SOACURR.SOBCURR.SOBCURR_PROGRAM Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SOACOMM.SORCOMM.SORCOMM_PROGRAM Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SOAEQUI.KEY_BLOCK.PROGRAM_2 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SOAEQUI.KEY_BLOCK.PROGRAM_1 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SOAEQUI.SOREQUI.SOREQUI_PROGRAM_2 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SOAEQUI.SOREQUI.SOREQUI_PROGRAM_1 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SOAADAS.SORADDA.SORADDA_TO_VALUE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SOAADAS.SORADDA.SORADDA_FROM_VALUE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SHATRTA.KEY_BLOCK.KEYBLOC_PROGRAM Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SHATATR.KEY_BLOCK.KEYBLOC_PROGRAM Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SHATAEQ.KEY_BLOCK.KEYBLOC_PROGRAM Use(select )
POST-CHANGE