Model General Student Tables

Model Label : Tables used for Banner Student General Student

List of Objects

Object Name	Object Type	Layer Name
EXCEPTIONS	TABLE	Default
SABAUDF	TABLE	Default
SGBEOPS	TABLE	Default
SGBOEDU	TABLE	Default
SGBSTDN	TABLE	Default
SGBUSER	TABLE	Default
SGRACMT	TABLE	Default
SGRADVR	TABLE	Default
SGRASSI	TABLE	Default
SGRASST	TABLE	Default
SGRCATT	TABLE	Default
SGRCHRT	TABLE	Default
SGRCLSR	TABLE	Default
SGRCMNT	TABLE	Default
SGRCOLR	TABLE	Default
SGRCOOP	TABLE	Default
SGRDISA	TABLE	Default
SGRDSER	TABLE	Default
SGRDUTY	TABLE	Default
SGRESEL	TABLE	Default
SGRSACT	TABLE	Default
SGRSATT	TABLE	Default
SGRSCMT	TABLE	Default
SGRSPRT	TABLE	Default
SGRVETN	TABLE	Default

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
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 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	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	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	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	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	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	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	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	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	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	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	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	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	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.

Link between SGRDUTY and SGRCOOP

Caller : SGRDUTY
Called : SGRCOOP

Link List

Link Type	Link	Project
Refer( No Action )	Link Foreign Key Between SGRDUTY and SGRCOOP	SATURN

Link Foreign Key Between SGRDUTY and SGRCOOP

Caller : SGRDUTY
Called : SGRCOOP
Link Type : Refer( No Action )
Link : Link Foreign Key Between SGRDUTY and SGRCOOP

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SGRDUTY	SGRDUTY_PIDM	SGRCOOP_PIDM	SGRCOOP	(1,1)-(0,n)
SGRDUTY	SGRDUTY_LEVL_CODE	SGRCOOP_LEVL_CODE	SGRCOOP	(1,1)-(0,n)
SGRDUTY	SGRDUTY_TERM_CODE	SGRCOOP_TERM_CODE	SGRCOOP	(1,1)-(0,n)
SGRDUTY	SGRDUTY_COOP_SEQ_NO	SGRCOOP_SEQ_NO	SGRCOOP	(1,1)-(0,n)

Comments

Link between SGRDSER and SGRDISA

Caller : SGRDSER
Called : SGRDISA

Link List

Link Type	Link	Project
Refer( No Action )	Link Foreign Key Between SGRDSER and SGRDISA	SATURN

Link Foreign Key Between SGRDSER and SGRDISA

Caller : SGRDSER
Called : SGRDISA
Link Type : Refer( No Action )
Link : Link Foreign Key Between SGRDSER and SGRDISA

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SGRDSER	SGRDSER_PIDM	SGRDISA_PIDM	SGRDISA	(1,1)-(0,n)
SGRDSER	SGRDSER_TERM_CODE	SGRDISA_TERM_CODE	SGRDISA	(1,1)-(0,n)
SGRDSER	SGRDSER_DISA_CODE	SGRDISA_DISA_CODE	SGRDISA	(1,1)-(0,n)