Model General Student*

Model Label : General Student SG% tables and some support tables

List of Objects

Object Name	Object Type	Layer Name
PK_SABAUDF	SQL Index	Default
PK_SGBEOPS	SQL Index	Default
PK_SGBSTDN	SQL Index	Default
PK_SGBUSER	SQL Index	Default
PK_SGRASSI	SQL Index	Default
PK_SGRCATT	SQL Index	Default
PK_SGRCOOP	SQL Index	Default
PK_SGRDISA	SQL Index	Default
PK_SGRDUTY	SQL Index	Default
PK_SGRSPRT	SQL Index	Default
PK_SGRVETN	SQL Index	Default
SABAUDF	SQL Table	Default
SGBEOPS	SQL Table	Default
SGBOEDU	SQL Table	Default
SGBSTDN	SQL Table	Default
SGBUSER	SQL Table	Default
SGRACMT	SQL Table	Default
SGRADVR	SQL Table	Default
SGRASSI	SQL Table	Default
SGRASST	SQL Table	Default
SGRCATT	SQL Table	Default
SGRCHRT	SQL Table	Default
SGRCLSR	SQL Table	Default
SGRCMNT	SQL Table	Default
SGRCOLR	SQL Table	Default
SGRCOOP	SQL Table	Default
SGRDISA	SQL Table	Default
SGRDSER	SQL Table	Default
SGRDUTY	SQL Table	Default
SGRESEL	SQL Table	Default
SGRSACT	SQL Table	Default
SGRSATT	SQL Table	Default
SGRSCMT	SQL Table	Default
SGRSPRT	SQL Table	Default
SGRVETN	SQL Table	Default

Model View

Index PK_SABAUDF

Server Name S10B80
Database Name SATURN
Index Label
Referenced Object name SABAUDF
Owner Name
Index Type UNIQUE

Index Columns information

Column Name	Column Type	Column Length	Column precision
SABAUDF_TERM_CODE_EFF	VARCHAR2	6	0

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SABAUDF	SQL Table	S10B80.SATURN	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SABAUDF

Object Dates

Creation Date	Analysis Date
04/02/2008 20:55:03:000	04/02/2008 20:55:03:000

Index PK_SGBEOPS

Server Name S10B80
Database Name SATURN
Index Label
Referenced Object name SGBEOPS
Owner Name
Index Type UNIQUE

Index Columns information

Column Name	Column Type	Column Length	Column precision
SGBEOPS_PIDM	NUMBER	8	8
SGBEOPS_TERM_CODE_EFF	VARCHAR2	6	0

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SGBEOPS	SQL Table	S10B80.SATURN	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SGBEOPS

Object Dates

Creation Date	Analysis Date
04/02/2008 20:52:19:000	04/02/2008 20:52:19:000

Index PK_SGBSTDN

Server Name S10B80
Database Name SATURN
Index Label
Referenced Object name SGBSTDN
Owner Name
Index Type UNIQUE

Index Columns information

Column Name	Column Type	Column Length	Column precision
SGBSTDN_PIDM	NUMBER	8	8
SGBSTDN_TERM_CODE_EFF	VARCHAR2	6	0

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SGBSTDN	SQL Table	S10B80.SATURN	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SGBSTDN

Object Dates

Creation Date	Analysis Date
04/02/2008 20:53:45:000	04/02/2008 20:53:45:000

Index PK_SGBUSER

Server Name S10B80
Database Name SATURN
Index Label
Referenced Object name SGBUSER
Owner Name
Index Type UNIQUE

Index Columns information

Column Name	Column Type	Column Length	Column precision
SGBUSER_PIDM	NUMBER	8	8
SGBUSER_TERM_CODE	VARCHAR2	6	0

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SGBUSER	SQL Table	S10B80.SATURN	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SGBUSER

Object Dates

Creation Date	Analysis Date
04/02/2008 20:41:48:000	04/02/2008 20:41:48:000

Index PK_SGRASSI

Server Name S10B80
Database Name SATURN
Index Label
Referenced Object name SGRASSI
Owner Name
Index Type UNIQUE

Index Columns information

Column Name	Column Type	Column Length	Column precision
SGRASSI_PIDM	NUMBER	8	8
SGRASSI_TERM_CODE_EFF	VARCHAR2	6	0
SGRASSI_CATEGORY	VARCHAR2	1	0
SGRASSI_GTYP_CODE	VARCHAR2	6	0

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SGRASSI	SQL Table	S10B80.SATURN	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SGRASSI

Object Dates

Creation Date	Analysis Date
04/02/2008 20:36:54:000	04/02/2008 20:36:54:000

Index PK_SGRCATT

Server Name S10B80
Database Name SATURN
Index Label
Referenced Object name SGRCATT
Owner Name
Index Type UNIQUE

Index Columns information

Column Name	Column Type	Column Length	Column precision
SGRCATT_SEQ_NO	NUMBER	3	3
SGRCATT_ATTS_CODE	VARCHAR2	4	0

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SGRCATT	SQL Table	S10B80.SATURN	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SGRCATT

Object Dates

Creation Date	Analysis Date
04/02/2008 20:49:02:000	04/02/2008 20:49:02:000

Index PK_SGRCOOP

Server Name S10B80
Database Name SATURN
Index Label
Referenced Object name SGRCOOP
Owner Name
Index Type UNIQUE

Index Columns information

Column Name	Column Type	Column Length	Column precision
SGRCOOP_PIDM	NUMBER	8	8
SGRCOOP_TERM_CODE	VARCHAR2	6	0
SGRCOOP_LEVL_CODE	VARCHAR2	2	0
SGRCOOP_SEQ_NO	NUMBER	4	4

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SGRCOOP	SQL Table	S10B80.SATURN	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SGRCOOP

Object Dates

Creation Date	Analysis Date
04/02/2008 20:44:05:000	04/02/2008 20:44:05:000

Index PK_SGRDISA

Server Name S10B80
Database Name SATURN
Index Label
Referenced Object name SGRDISA
Owner Name
Index Type UNIQUE

Index Columns information

Column Name	Column Type	Column Length	Column precision
SGRDISA_PIDM	NUMBER	8	8
SGRDISA_TERM_CODE	VARCHAR2	6	0
SGRDISA_DISA_CODE	VARCHAR2	2	0

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SGRDISA	SQL Table	S10B80.SATURN	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SGRDISA

Object Dates

Creation Date	Analysis Date
04/02/2008 21:05:02:000	04/02/2008 21:05:02:000

Index PK_SGRDUTY

Server Name S10B80
Database Name SATURN
Index Label
Referenced Object name SGRDUTY
Owner Name
Index Type UNIQUE

Index Columns information

Column Name	Column Type	Column Length	Column precision
SGRDUTY_PIDM	NUMBER	8	8
SGRDUTY_TERM_CODE	VARCHAR2	6	0
SGRDUTY_LEVL_CODE	VARCHAR2	2	0
SGRDUTY_COOP_SEQ_NO	NUMBER	4	4
SGRDUTY_EMPL_CODE	VARCHAR2	4	0
SGRDUTY_SEQ_NO	NUMBER	4	4

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SGRDUTY	SQL Table	S10B80.SATURN	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SGRDUTY

Object Dates

Creation Date	Analysis Date
04/02/2008 20:50:51:000	04/02/2008 20:50:51:000

Index PK_SGRSPRT

Server Name S10B80
Database Name SATURN
Index Label
Referenced Object name SGRSPRT
Owner Name
Index Type UNIQUE

Index Columns information

Column Name	Column Type	Column Length	Column precision
SGRSPRT_PIDM	NUMBER	8	8
SGRSPRT_TERM_CODE	VARCHAR2	6	0
SGRSPRT_ACTC_CODE	VARCHAR2	8	0

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SGRSPRT	SQL Table	S10B80.SATURN	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SGRSPRT

Object Dates

Creation Date	Analysis Date
04/02/2008 20:55:26:000	04/02/2008 20:55:26:000

Index PK_SGRVETN

Server Name S10B80
Database Name SATURN
Index Label
Referenced Object name SGRVETN
Owner Name
Index Type UNIQUE

Index Columns information

Column Name	Column Type	Column Length	Column precision
SGRVETN_PIDM	NUMBER	8	8
SGRVETN_TERM_CODE_VA	VARCHAR2	6	0

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SGRVETN	SQL Table	S10B80.SATURN	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SGRVETN

Object Dates

Creation Date	Analysis Date
04/02/2008 20:45:09:000	04/02/2008 20:45:09:000

Table SABAUDF

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

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

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_SABAUDF	SQL Index	S10B80.SATURN	Rely On
STVTERM	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SABAUDF

Object Dates

Creation Date	Analysis Date
04/02/2008 20:55:02:000	04/02/2008 21:18:16:000

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

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

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

Foreign Key information

Column name	is Foreign Key For Column	on Table
SGBEOPS_EOPS_CODE	STVEOPS_CODE	STVEOPS
SGBEOPS_SFAE_CODE	STVSFAE_CODE	STVSFAE
SGBEOPS_TERM_CODE_EFF	STVTERM_CODE	STVTERM
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)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_SGBEOPS	SQL Index	S10B80.SATURN	Rely On
STVEOPS	SQL Table	S10B80.SATURN	Refer (no action)
STVSFAE	SQL Table	S10B80.SATURN	Refer (no action)
STVTERM	SQL Table	S10B80.SATURN	Refer (no action)
STVWTHD	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SGBEOPS

Object Dates

Creation Date	Analysis Date
04/02/2008 20:52:19:000	04/02/2008 21:18:14:000

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

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

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

Foreign Key information

Column name	is Foreign Key For Column	on Table
SGBOEDU_EOPS_CODE	STVEOPS_CODE	STVEOPS
SGBOEDU_AFDC_CODE	STVAFDC_CODE	STVAFDC
SGBOEDU_MARS_CODE	STVMARS_CODE	STVMARS
SGBOEDU_DEPS_CODE	STVDEPS_CODE	STVDEPS
SGBOEDU_SFAE_CODE	STVSFAE_CODE	STVSFAE
SGBOEDU_TERM_CODE_EFF	STVTERM_CODE	STVTERM
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)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SGBOEDU_KEY_INDEX	SQL Index	S10B80.SATURN	Rely On
STVAFDC	SQL Table	S10B80.SATURN	Refer (no action)
STVDEPS	SQL Table	S10B80.SATURN	Refer (no action)
STVEOPS	SQL Table	S10B80.SATURN	Refer (no action)
STVMARS	SQL Table	S10B80.SATURN	Refer (no action)
STVSFAE	SQL Table	S10B80.SATURN	Refer (no action)
STVTERM	SQL Table	S10B80.SATURN	Refer (no action)
STVWTHD	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SGBOEDU

Object Dates

Creation Date	Analysis Date
04/02/2008 20:35:54:000	04/02/2008 21:18:00:000

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

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

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

Foreign Key information

Column name	is Foreign Key For Column	on Table
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_CCON_RULE_22_1	SORCCON_CCON_RULE	SORCCON
SGBSTDN_CCON_RULE_22_2	SORCCON_CCON_RULE	SORCCON
SGBSTDN_CCON_RULE_22_3	SORCCON_CCON_RULE	SORCCON
SGBSTDN_CCON_RULE_11_1	SORCCON_CCON_RULE	SORCCON
SGBSTDN_CCON_RULE_11_2	SORCCON_CCON_RULE	SORCCON
SGBSTDN_CCON_RULE_11_3	SORCCON_CCON_RULE	SORCCON
SGBSTDN_CCON_RULE_12_1	SORCCON_CCON_RULE	SORCCON
SGBSTDN_CCON_RULE_12_2	SORCCON_CCON_RULE	SORCCON
SGBSTDN_CCON_RULE_12_3	SORCCON_CCON_RULE	SORCCON
SGBSTDN_CCON_RULE_21_1	SORCCON_CCON_RULE	SORCCON
SGBSTDN_CCON_RULE_21_2	SORCCON_CCON_RULE	SORCCON
SGBSTDN_CCON_RULE_21_3	SORCCON_CCON_RULE	SORCCON
SGBSTDN_MAJR_CODE_MINR_2	STVMAJR_CODE	STVMAJR
SGBSTDN_MAJR_CODE_MINR_2_2	STVMAJR_CODE	STVMAJR
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_MAJR_CODE_1_2	STVMAJR_CODE	STVMAJR
SGBSTDN_MAJR_CODE_CONC_222	STVMAJR_CODE	STVMAJR
SGBSTDN_MAJR_CODE_CONC_223	STVMAJR_CODE	STVMAJR
SGBSTDN_MAJR_CODE_2_2	STVMAJR_CODE	STVMAJR
SGBSTDN_MAJR_CODE_1	STVMAJR_CODE	STVMAJR
SGBSTDN_MAJR_CODE_MINR_1	STVMAJR_CODE	STVMAJR
SGBSTDN_MAJR_CODE_MINR_1_2	STVMAJR_CODE	STVMAJR
SGBSTDN_MAJR_CODE_CONC_1	STVMAJR_CODE	STVMAJR
SGBSTDN_MAJR_CODE_CONC_1_2	STVMAJR_CODE	STVMAJR
SGBSTDN_MAJR_CODE_CONC_1_3	STVMAJR_CODE	STVMAJR
SGBSTDN_MAJR_CODE_2	STVMAJR_CODE	STVMAJR
SGBSTDN_CURR_RULE_1	SOBCURR_CURR_RULE	SOBCURR
SGBSTDN_CURR_RULE_2	SOBCURR_CURR_RULE	SOBCURR
SGBSTDN_ACYR_CODE	STVACYR_CODE	STVACYR
SGBSTDN_ADMT_CODE	STVADMT_CODE	STVADMT
SGBSTDN_ADMT_CODE_2	STVADMT_CODE	STVADMT
SGBSTDN_ASTD_CODE	STVASTD_CODE	STVASTD
SGBSTDN_COLL_CODE_1	STVCOLL_CODE	STVCOLL
SGBSTDN_COLL_CODE_2	STVCOLL_CODE	STVCOLL
SGBSTDN_COLL_CODE_DUAL	STVCOLL_CODE	STVCOLL
SGBSTDN_DEGC_CODE_1	STVDEGC_CODE	STVDEGC
SGBSTDN_DEGC_CODE_2	STVDEGC_CODE	STVDEGC
SGBSTDN_DEGC_CODE_DUAL	STVDEGC_CODE	STVDEGC
SGBSTDN_EGOL_CODE	STVEGOL_CODE	STVEGOL
SGBSTDN_EMEX_CODE	STVEMEX_CODE	STVEMEX
SGBSTDN_GAIN_CODE	STVGAIN_CODE	STVGAIN
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_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_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_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_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_SITE_CODE	STVSITE_CODE	STVSITE
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_PRAC_CODE	STVPRAC_CODE	STVPRAC
SGBSTDN_PREV_CODE	STVPREV_CODE	STVPREV
SGBSTDN_PIDM	SHRTTRM_PIDM	SHRTTRM
SGBSTDN_PIDM	SFBETRM_PIDM	SFBETRM
SGBSTDN_PIDM	SORLCUR_PIDM	SORLCUR
SGBSTDN_PIDM	SFRSTCR_PIDM	SFRSTCR
SGBSTDN_PIDM	SFRAREG_PIDM	SFRAREG
SGBSTDN_DEGC_CODE_1	RPRDEGR_DEGC_CODE	RPRDEGR

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
RORVIEW	SQL Table	S10B80.FAISMGR	Join
SHRLGPA	SQL Table	S10B80.SATURN	Join
SORMSTY	SQL Table	S10B80.SATURN	Join
SPBPERS	SQL Table	S10B80.SATURN	Join
SPRIDEN	SQL Table	S10B80.SATURN	Join
ST_SGBSTDN_AR_LDI	SQL Trigger	S10B80.SATURN	Rely On
RCVAPL2	SQL View	S10B80.BANINST1	Use (select)
ROVST03	SQL View	S10B80.BANINST1	Use (select)
ROVST04	SQL View	S10B80.BANINST1	Use (select)
ROVST05	SQL View	S10B80.BANINST1	Use (select)
ROVST06	SQL View	S10B80.BANINST1	Use (select)
ROVST07	SQL View	S10B80.BANINST1	Use (select)
ROVST08	SQL View	S10B80.BANINST1	Use (select)
ROVST09	SQL View	S10B80.BANINST1	Use (select)
ROVSTDD	SQL View	S10B80.BANINST1	Use (select)
ROVSTDN	SQL View	S10B80.BANINST1	Use (select)
ROVSTU2	SQL View	S10B80.BANINST1	Use (select)
ROVSTXX	SQL View	S10B80.BANINST1	Use (select)
RPVAWT2	SQL View	S10B80.BANINST1	Use (select)
RPVAWY2	SQL View	S10B80.BANINST1	Use (select)
SFVETR2	SQL View	S10B80.BANINST1	Use (select)
SFVSTC2	SQL View	S10B80.BANINST1	Use (select)
SFVSTC2_LATEST	SQL View	S10B80.BANINST1	Use (select)
SFVSTDN	SQL View	S10B80.BANINST1	Use (select)
SFVTFAN	SQL View	S10B80.BANINST1	Use (select)
SGVACUR	SQL View	S10B80.BANINST1	Use (select)
SGVCCUR	SQL View	S10B80.BANINST1	Use (select)
SGVCLAS	SQL View	S10B80.BANINST1	Use (select)
SGVCLAS_EXP	SQL View	S10B80.BANINST1	Use (select)
SGVCLSR	SQL View	S10B80.BANINST1	Use (select)
SGVLEAV	SQL View	S10B80.BANINST1	Use (select)
SGVSTD2	SQL View	S10B80.BANINST1	Use (select)
SGVSTDN	SQL View	S10B80.BANINST1	Use (select)
SGVSTNE	SQL View	S10B80.BANINST1	Use (select)
SHVDEAN	SQL View	S10B80.BANINST1	Use (select)
SHVIPED	SQL View	S10B80.BANINST1	Use (select)
SHVIPED_OJ	SQL View	S10B80.BANINST1	Use (select)
SHVTER1	SQL View	S10B80.BANINST1	Use (select)
SHVYEA1	SQL View	S10B80.BANINST1	Use (select)
SHVYEA1_OJ	SQL View	S10B80.BANINST1	Use (select)
SLVRES2_M	SQL View	S10B80.BANINST1	Use (select)
SOVCFOS	SQL View	S10B80.BANINST1	Join
SOVCLAS	SQL View	S10B80.BANINST1	Use (select)
SOVCTA2	SQL View	S10B80.BANINST1	Use (select)
SOVSREC	SQL View	S10B80.BANINST1	Use (select)
SOVSTDN	SQL View	S10B80.BANINST1	Use (select)
SPVTER1	SQL View	S10B80.BANINST1	Use (select)
SPVYEA1	SQL View	S10B80.BANINST1	Use (select)
FN_SORFOLK_VALUE	SQL Function	S10B80.BANINST1	Rely On
F_CLASS_FNC	SQL Function	S10B80.BANINST1	Use (select)
F_CONCAT_PREV_TERM_GPA	SQL Function	S10B80.BANINST1	Use (select)
F_GET_CURRENT_SGBSTDN_ROWID	SQL Function	S10B80.BANINST1	Use (select)
F_GET_SGBSTDN_ROWID	SQL Function	S10B80.BANINST1	Use (select)
F_SGBSTDN_FIELDS	SQL Function	S10B80.BANINST1	Rely On
F_SGBSTDN_FIELDS	SQL Function	S10B80.BANINST1	Use (select)Rely On
F_SGBSTDN_TERM	SQL Function	S10B80.BANINST1	Use (select)
F_STUDENT_GEN_STUDENTS_IND	SQL Function	S10B80.BANINST1	Use (select)
LEARNER_REC	Oracle Package Type	S10B80.BANINST1.SB_LEARNER	Rely On
PRIMARY_CURR_REC	Oracle Package Type	S10B80.BANINST1.SOKLIBS	Rely On
PRIMARY_CURR_REC	Oracle Package Type	S10B80.BANINST1.SOKLIBS_OJ	Rely On
PRIMARY_CURR_REC	Oracle Package Type	S10B80.BANINST1.SOKFUNC	Rely On
T_STUDTLTYPE	Oracle Package Type	S10B80.BANINST1.BWCKGSTU	Rely On
CHECKSTUSTATUSC	Oracle Package Cursor	S10B80.BANINST1.BWLKOIDS	Use (select)
C_GETSTUDTLC	Oracle Package Cursor	S10B80.BANINST1.BWCKGSTU	Use (select)
SGBSTDNC	Oracle Package Cursor	S10B80.BANINST1.SGKWEVN	Use (select)
P_LOAD_BLOCK	Oracle Package Procedure	S10B80.BANINST1.SFKREGS	Rely On
SGBSTDN_TAB	Oracle Package Type	S10B80.BANINST1.SGKSELS	Rely On
SGBSTDN_TAB_TYPE	Oracle Package Type	S10B80.BANINST1.SOKTABS	Rely On
GV_CURRENT_TERM	Oracle Package Variable	S10B80.BANINST1.SAKDCSN	Rely On
SGBSTDN_REC	Oracle Package Variable	S10B80.BANINST1.BWCKCOMS	Rely On
SGBSTDN_REC	Oracle Package Variable	S10B80.BANINST1.SFKFEES	Rely On
ROLL_RECORD	Oracle Package Type	S10B80.BANINST1.SHKROLS	Rely On
SGBSTDN_DETAIL_TYPE	Oracle Package Type	S10B80.BANINST1.BWLKFCWL	Rely On
STUDENT_REC	Oracle Package Type	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Rely On
GETSTUGENRECC	Oracle Package Cursor	S10B80.BANINST1.BWLKFCWL	Use (select)
SGBSTDN_DISP_PRIM_C	Oracle Package Cursor	S10B80.BANINST1.BWCKCAPP	Use (select)
SGBSTDN_LISTC	Oracle Package Cursor	S10B80.BANINST1.BWSKWTRR	Use (select)
SGBSTDN_PRIM_C	Oracle Package Cursor	S10B80.BANINST1.BWCKCAPP	Use (select)
STUDENT_BY_TERM_C	Oracle Package Cursor	S10B80.BANINST1.ICSPKCOM	Rely On
STUDENT_BY_TERM_C	Oracle Package Cursor	S10B80.BANINST1.ICSPKCOM	Use (select)
P_ADMIT_APPLICATION	Oracle Package Procedure	S10B80.BANINST1.TS_SB_CURRICULUM	Rely On
P_ADMIT_APPLICATION	Oracle Package Procedure	S10B80.BANINST1.TS_SB_CURRICULUM	Use (select)Rely On
P_CAPPPREQCHK	Oracle Package Procedure	S10B80.BANINST1.SFKPREQ	Use (select)
P_CREATE_APPLICATION	Oracle Package Procedure	S10B80.BANINST1.TS_SB_FEEASSESSMENT_RBC	Rely On
P_CREATE_APPLICATION	Oracle Package Procedure	S10B80.BANINST1.TS_SB_FEEASSESSMENT_RBC	Use (select)Rely On
P_CREATE_APPLICATION	Oracle Package Procedure	S10B80.BANINST1.TS_SB_FEEASSESSMENT_RBT	Rely On
P_CREATE_APPLICATION	Oracle Package Procedure	S10B80.BANINST1.TS_SB_FEEASSESSMENT_RBT	Use (select)Rely On
P_CREATE_APPLICATION	Oracle Package Procedure	S10B80.BANINST1.TS_SB_FEEASSESSMENT_ASSMT	Rely On
P_CREATE_APPLICATION	Oracle Package Procedure	S10B80.BANINST1.TS_SB_FEEASSESSMENT_ASSMT	Use (select)Rely On
P_CREATE_APPLICATION	Oracle Package Procedure	S10B80.BANINST1.TS_SB_FEEASSESSMENT_RBCVAR	Rely On
P_CREATE_APPLICATION	Oracle Package Procedure	S10B80.BANINST1.TS_SB_FEEASSESSMENT_RBCVAR	Use (select)Rely On
P_CREATE_APPLICATION	Oracle Package Procedure	S10B80.BANINST1.TS_SB_GRADEROLL	Rely On
P_CREATE_APPLICATION	Oracle Package Procedure	S10B80.BANINST1.TS_SB_GRADEROLL	Use (select)Rely On
P_CREATE_APPLICATION	Oracle Package Procedure	S10B80.BANINST1.TS_SB_REGISTRATION	Rely On
P_CREATE_APPLICATION	Oracle Package Procedure	S10B80.BANINST1.TS_SB_REGISTRATION	Use (select)Rely On
P_CREATE_APPLICATION	Oracle Package Procedure	S10B80.BANINST1.TS_SB_FEEASSESSMENT_RULES	Rely On
P_CREATE_APPLICATION	Oracle Package Procedure	S10B80.BANINST1.TS_SB_FEEASSESSMENT_RULES	Use (select)Rely On
P_CREATE_APPLICATION	Oracle Package Procedure	S10B80.BANINST1.TS_SB_FEEASSESSMENT_DD	Rely On
P_CREATE_APPLICATION	Oracle Package Procedure	S10B80.BANINST1.TS_SB_FEEASSESSMENT_DD	Use (select)Rely On
P_CREATE_APPLICATION	Oracle Package Procedure	S10B80.BANINST1.TS_SB_FEEASSESSMENT_SWAPPING	Rely On
P_CREATE_APPLICATION	Oracle Package Procedure	S10B80.BANINST1.TS_SB_FEEASSESSMENT_SWAPPING	Use (select)Rely On
P_DEGHIST	Oracle Package Procedure	S10B80.BANINST1.TS_STUDENT_OAPERF	Use (select)
P_DELETE_STUDENT	Oracle Package Procedure	S10B80.BANINST1.UT_GRADEROLL	Use (delete)
P_DELETE_STUDENT	Oracle Package Procedure	S10B80.BANINST1.TS_SB_FEEASSESSMENT_RBCVAR	Use (delete,select)
P_ENROLL_STUD	Oracle Package Procedure	S10B80.BANINST1.TS_STUDENT_OAPERF	Use (select)
P_GETSGBSTDN	Oracle Package Procedure	S10B80.BANINST1.ROKWEXT	Use (select)
P_GETSGBSTDN	Oracle Package Procedure	S10B80.BANINST1.SOKWEXT	Use (select)
P_GETSTUDENTINFO	Oracle Package Procedure	S10B80.BANINST1.BWCKREGS	Use (select)
P_GETTERMEFFEND	Oracle Package Procedure	S10B80.BANINST1.BWCKGSTU	Use (select)
P_GETTERMFIRST	Oracle Package Procedure	S10B80.BANINST1.BWCKGSTU	Use (select)
P_GET_LOAD_FROM_HOURS	Oracle Package Procedure	S10B80.BANINST1.RPKLOAD	Rely On
P_GET_LOAD_FROM_HOURS	Oracle Package Procedure	S10B80.BANINST1.RPKLOAD	Use (select)
P_GET_SFBETRM	Oracle Package Procedure	S10B80.BANINST1.SFKMREG	Rely On
P_GET_STUDENT_COURSE	Oracle Package Procedure	S10B80.BANINST1.SHKROLS	Use (select)
P_LOAD_BLOCK	Oracle Package Procedure	S10B80.BANINST1.SFKMREG	Rely On
P_LOAD_BLOCK	Oracle Package Procedure	S10B80.BANINST1.SFKREGS	Rely On
P_MATERIAL_MATCHING	Oracle Package Procedure	S10B80.BANINST1.SOKCPLN	Use (select)
P_OVERLAY_VALIDATION_REC	Oracle Package Procedure	S10B80.BANINST1.SB_LEARNER	Rely On
P_PRINT_LEARNER	Oracle Package Procedure	S10B80.BANINST1.TS_SB_GRADEROLL	Rely On
P_PRINT_LEARNER	Oracle Package Procedure	S10B80.BANINST1.TS_SB_GRADEROLL	Use (select)Rely On
P_PRINT_LEARNER	Oracle Package Procedure	S10B80.BANINST1.TS_SB_CURRICULUM	Rely On
P_PRINT_LEARNER	Oracle Package Procedure	S10B80.BANINST1.TS_SB_CURRICULUM	Use (select)Rely On
TESTCASE55	Oracle Package Procedure	S10B80.BANINST1.TS_SB_FEEASSESSMENT_RBC	Use (update)
TESTSTYP	Oracle Package Procedure	S10B80.BANINST1.TS_SB_FEEASSESSMENT_RULES	Use (update)
UT_SB_ENROLLMENTCREATEAPI	Oracle Package Procedure	S10B80.BANINST1.UT_SB_ENROLLMENT	Use (Insert)
UT_SP_LDIPERSONPROCESSAPI	Oracle Package Procedure	S10B80.BANINST1.UT_SP_LDIPERSON	Use (Insert)
GV_FULL_PART_IND1	Oracle Package Variable	S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT	Rely On
HOLD_STU	Oracle Package Variable	S10B80.BANINST1.BWLKFCWL	Rely On
SGBSTDN_REC	Oracle Package Variable	S10B80.BANINST1.BWCKGENS	Rely On
SGBSTDN_REC	Oracle Package Variable	S10B80.BANINST1.BWCKSAMS	Rely On
SGBSTDN_REC	Oracle Package Variable	S10B80.BANINST1.BWSKFFEE	Rely On
SGBSTDN_REC	Oracle Package Variable	S10B80.BANINST1.BWSKRSTA	Rely On
SGBSTDN_ROW	Oracle Package Variable	S10B80.BANINST1.BWCKREGS	Rely On
STUD_TYPE	Oracle Package Variable	S10B80.BANINST1.BWCKREGS	Rely On
TO_TERM	Oracle Package Variable	S10B80.BANINST1.BWCKGSTU	Rely On
F_BUILD_SGBSTDN_REC	Oracle Package Function	S10B80.BANINST1.SB_LEARNER	Rely On
F_CHECK_STATUS_ACAD_STAND	Oracle Package Function	S10B80.BANINST1.SB_LEARNER	Rely On
F_CHECK_STATUS_ACAD_STAND	Oracle Package Function	S10B80.BANINST1.SB_LEARNER	Use (select)
F_CHECK_STATUS_COMB_ACAD_STAND	Oracle Package Function	S10B80.BANINST1.SB_LEARNER	Rely On
F_CHECK_STATUS_COMB_ACAD_STAND	Oracle Package Function	S10B80.BANINST1.SB_LEARNER	Use (select)
F_GET_BILL_TERM	Oracle Package Function	S10B80.BANINST1.BWSKWTRR	Use (select)
F_GET_FINAID_CLASS	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Rely On
F_GET_STUDENT_DATA	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Use (select)
F_GET_TERM	Oracle Package Function	S10B80.BANINST1.BWSKWTRR	Use (select)
F_HAS_ROLE	Oracle Package Function	S10B80.BANINST1.ICGOKROL	Use (select)
F_QUERY_LAST_TERM	Oracle Package Function	S10B80.BANINST1.SB_LEARNER	Rely On
F_QUERY_LAST_TERM	Oracle Package Function	S10B80.BANINST1.SB_LEARNER	Use (select)
F_VAL_DEGREE	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Use (select)
SGBSTDNC	Oracle Package Cursor	S10B80.BANINST1.SGKLIBS	Use (select)Rely On
SGBSTDN_LEVLC	Oracle Package Cursor	S10B80.BANINST1.SGKLIBS	Use (select)Rely On
SGBSTDN_NEXT_C	Oracle Package Cursor	S10B80.BANINST1.SGKLIBS	Rely On
SGBSTDN_NEXT_C	Oracle Package Cursor	S10B80.BANINST1.SGKLIBS	Use (select)Rely On
P_ADDCRSE	Oracle Package Procedure	S10B80.BANINST1.BWCKREGS	Rely On
P_ALLOW_REG_CAST	Oracle Package Procedure	S10B80.BANINST1.SHKPREV	Rely On
P_APPLYRULES	Oracle Package Procedure	S10B80.BANINST1.SFKFEES	Rely On
P_BACKLOAD_CURR	Oracle Package Procedure	S10B80.BANINST1.SOKLCUR	Rely On
P_BACKLOAD_CURR	Oracle Package Procedure	S10B80.BANINST1.SOKLCUR	Use (select)
P_CALCULATE_CAST_CODE	Oracle Package Procedure	S10B80.BANINST1.SHKPREV	Rely On
P_CALCULATE_PREV_CODE	Oracle Package Procedure	S10B80.BANINST1.SHKPREV	Rely On
P_CALC_LOAN_ENROLL_STATUS	Oracle Package Procedure	S10B80.BANINST1.RPKLOAN	Rely On
P_CONVERT_CURR	Oracle Package Procedure	S10B80.BANINST1.SOKLCUR	Rely On
P_CONVERT_CURR	Oracle Package Procedure	S10B80.BANINST1.SOKLCUR	Use (select)Rely On
P_COPY_LEARNER	Oracle Package Procedure	S10B80.BANINST1.SB_LEARNER	Rely On
P_COUNT_REPEAT_UNITS	Oracle Package Procedure	S10B80.BANINST1.SHKRPTS	Rely On
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.SB_LEARNER	Rely On
P_DEFAULT_STATUS	Oracle Package Procedure	S10B80.BANINST1.SOKLCUR	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.SB_LEARNER	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.SB_LEARNER	Use (select)Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.DML_SGBSTDN	Use (delete)
P_DISPCURSOURCESGBSTDN	Oracle Package Procedure	S10B80.BANINST1.BWCKCAPP	Rely On
P_FACSTUPIN	Oracle Package Procedure	S10B80.BANINST1.BWLKILIB	Rely On
P_FACVERIFYID	Oracle Package Procedure	S10B80.BANINST1.BWLKFTRN	Use (select)
P_GET_ACAD_STAND	Oracle Package Procedure	S10B80.BANINST1.SHKFUNC	Rely On
P_GET_CAST	Oracle Package Procedure	S10B80.BANINST1.SHKPREV	Rely On
P_GET_MIN_MAX_BY_CURRIC	Oracle Package Procedure	S10B80.BANINST1.SFKSELS	Use (select)
P_GET_PREV_CODE	Oracle Package Procedure	S10B80.BANINST1.SHKPREV	Rely On
P_GET_SSRRESV_ROW	Oracle Package Procedure	S10B80.BANINST1.SSKSELS	Rely On
P_GET_SSRRESV_ROW	Oracle Package Procedure	S10B80.BANINST1.SSKSELS	Use (select)
P_GET_STUDENT_CURRICULUM	Oracle Package Procedure	S10B80.BANINST1.BWSCJREF	Use (select)
P_GET_STUDENT_CURRICULUM	Oracle Package Procedure	S10B80.BANINST1.BWXCBREF	Use (select)
P_GET_STUDENT_FORMATS	Oracle Package Procedure	S10B80.BANINST1.SHKCGPA	Rely On
P_GET_STUDENT_FORMATS_OA	Oracle Package Procedure	S10B80.BANINST1.SHKCGPA	Rely On
P_GET_SUB_CODE	Oracle Package Procedure	S10B80.BANINST1.BWCKCPMT	Rely On
P_GET_SUB_CODE_1	Oracle Package Procedure	S10B80.BANINST1.BWSKWCCP	Rely On
P_GET_TERM_PELL_FUND	Oracle Package Procedure	S10B80.BANINST1.ROKPELL	Rely On
P_INSERT	Oracle Package Procedure	S10B80.BANINST1.DML_SGBSTDN	Use (Insert)Rely On
P_INSERT_SHRGPAC	Oracle Package Procedure	S10B80.BANINST1.SHKCGPA	Rely On
P_INSERT_SHRGPAC_PREBANNER	Oracle Package Procedure	S10B80.BANINST1.SHKCGPA	Rely On
P_INSERT_SHRTRAM	Oracle Package Procedure	S10B80.BANINST1.SHKTAEQ	Rely On
P_INSERT_SHRTRIT	Oracle Package Procedure	S10B80.BANINST1.SHKTAEQ	Rely On
P_INSERT_SMRRQCM	Oracle Package Procedure	S10B80.BANINST1.BWCKCMPL	Use (select)
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.SB_LEARNER	Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.SB_LEARNER	Use (select)
P_OPEN_STUDENT_LIST_C	Oracle Package Procedure	S10B80.BANINST1.BWLKOIDS	Use (select)
P_POPULATE_SEARCH	Oracle Package Procedure	S10B80.BANINST1.SOKMAUD	Rely On
P_POPULATE_SEARCH	Oracle Package Procedure	S10B80.BANINST1.SOKMAUD	Use (select)Rely On
P_PROCESSFEEASSESSMENT	Oracle Package Procedure	S10B80.BANINST1.SFKFEES	Use (select)
P_PROCESS_MASS_ENTRY	Oracle Package Procedure	S10B80.BANINST1.SOKMAUD	Use (select)
P_REGISTER_ENTITY	Oracle Package Procedure	S10B80.BANINST1.SB_LEARNER_RULES	Rely On
P_REGSCHK	Oracle Package Procedure	S10B80.BANINST1.BWCKREGS	Rely On
P_REGSRESULT	Oracle Package Procedure	S10B80.BANINST1.BWCKSAMS	Rely On
P_ROLL_MANUAL_DEGREE	Oracle Package Procedure	S10B80.BANINST1.SHKROLS	Rely On
P_ROLL_MANUAL_DEGREE	Oracle Package Procedure	S10B80.BANINST1.SHKROLS	Use (select)Rely On
P_SEARCHCHK	Oracle Package Procedure	S10B80.BANINST1.BWCKGENS	Rely On
P_SELECT_SGBSTDN_CAMPUS	Oracle Package Procedure	S10B80.BANINST1.ROKPELL	Rely On
P_SELECT_SGBSTDN_CAMPUS	Oracle Package Procedure	S10B80.BANINST1.ROKPELL	Use (select)
P_STUDENTTERMDATA	Oracle Package Procedure	S10B80.BANINST1.BWSKXMIS	Rely On
P_STUDENTTERMDATA	Oracle Package Procedure	S10B80.BANINST1.BWSKXMIS	Use (select)
P_STUINFO	Oracle Package Procedure	S10B80.BANINST1.BWCKGSTU	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.SB_LEARNER	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.DML_SGBSTDN	Use (update)Rely On
P_UPDATE_CURRICULUM	Oracle Package Procedure	S10B80.BANINST1.DML_SGBSTDN	Rely On
P_UPDATE_REGS	Oracle Package Procedure	S10B80.BANINST1.SFKEDIT	Rely On
P_UPDSTUDENTTERMDATA	Oracle Package Procedure	S10B80.BANINST1.BWSKXMIS	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.SB_LEARNER_RULES	Rely On
P_VALIDATE_INSERT	Oracle Package Procedure	S10B80.BANINST1.SB_CURRICULUM_RULES	Rely On
P_VERIFY_ELIGIBLE_TO_REGISTER	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
P_VIEWTRANSCRIPT	Oracle Package Procedure	S10B80.BANINST1.BWCKOTRN	Rely On
P_VIEWTRANSCRIPT	Oracle Package Procedure	S10B80.BANINST1.BWCKOTRN	Use (select)Rely On
P_VR_ADD_CLASS	Oracle Package Procedure	S10B80.BANINST1.VRSKFREG	Rely On
P_VR_ASSESS_FEES	Oracle Package Procedure	S10B80.BANINST1.VRGKOCTL	Rely On
P_VR_CONFIRM_REG	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
P_VR_CONFIRM_REG_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
P_VR_CONTINUE_CONFIRM	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
P_VR_CRN_LIST	Oracle Package Procedure	S10B80.BANINST1.VRSKFOLR	Rely On
P_VR_GET_PROGRESS_DATA	Oracle Package Procedure	S10B80.BANINST1.VRHKGRDS	Rely On
P_VR_LIST_GRADES	Oracle Package Procedure	S10B80.BANINST1.VRHKGRDS	Rely On
P_VR_PROCESS_ADMINDROPS	Oracle Package Procedure	S10B80.BANINST1.VRSKFREG	Rely On
P_VR_REG_APPL_MENU_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
P_VR_REG_TERM_ELIGIBLE	Oracle Package Procedure	S10B80.BANINST1.VRSKFOLR	Rely On
P_VR_VALIDATE_PIN	Oracle Package Procedure	S10B80.BANINST1.VRSKPVAL	Rely On
P_VR_WITHDRAW_FROM_TERM	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
P_WRITE_CRN_SELECTION	Oracle Package Procedure	S10B80.BANINST1.BWSKSMRK	Rely On
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_ENROLLMENT	Use (Insert)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_TRANSCRIPT_REQ_NAME	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_APPLICATION_DECISION	Use (Insert,select)
UT_TEARDOWN	Oracle Package Procedure	S10B80.BANINST1.UT_GB_SECTION	Use (delete)
F_CHECK_MGMT_CONTROL	Oracle Package Function	S10B80.BANINST1.SFKRCTL	Rely On
F_CHECK_PLAN	Oracle Package Function	S10B80.BANINST1.TSKAIST	Use (select)
F_CONVERT_LEARNER	Oracle Package Function	S10B80.BANINST1.SOKLCUR	Rely On
F_CONVERT_LEARNER	Oracle Package Function	S10B80.BANINST1.SOKLCUR	Use (select)
F_DELINQUENCIES	Oracle Package Function	S10B80.BANINST1.SB_PESCXML_ACADSUMMARY_EXP	Rely On
F_ELIGIBLE_TO_REGISTER	Oracle Package Function	S10B80.BANINST1.SB_LEARNER	Rely On
F_ELIGIBLE_TO_REGISTER	Oracle Package Function	S10B80.BANINST1.SB_LEARNER	Use (select)
F_EXISTS	Oracle Package Function	S10B80.BANINST1.SB_LEARNER	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.SB_LEARNER	Use (select)
F_FALLS_EXCEPTION	Oracle Package Function	S10B80.BANINST1.SFKWLAT	Use (select)
F_FIND_IF_STUDENT	Oracle Package Function	S10B80.BANINST1.SOKFGAC	Use (select)
F_FIND_IF_STUDENT_FINAID	Oracle Package Function	S10B80.BANINST1.SOKFGAC	Use (select)
F_FIRST_TIME_BORROWER	Oracle Package Function	S10B80.BANINST1.RPKLOAN	Rely On
F_FIRST_TIME_BORROWER	Oracle Package Function	S10B80.BANINST1.RPKLOAN	Use (select)
F_GET_ACADEMIC_STATUS	Oracle Package Function	S10B80.BANINST1.SOKPAPI	Rely On
F_GET_ACAD_PROFILE	Oracle Package Function	S10B80.BANINST1.BWSCXCHN	Rely On
F_GET_ACAD_PROFILE	Oracle Package Function	S10B80.BANINST1.BWSCXCHN	Use (select)
F_GET_ACAD_PROFILE	Oracle Package Function	S10B80.BANINST1.BWXCXCHN	Rely On
F_GET_ACAD_PROFILE	Oracle Package Function	S10B80.BANINST1.BWXCXCHN	Use (select)
F_GET_BRANCH	Oracle Package Function	S10B80.BANINST1.RSKMISC	Rely On
F_GET_BRANCH	Oracle Package Function	S10B80.BANINST1.RSKMISC	Use (select)
F_GET_CAMP_PELL_ID	Oracle Package Function	S10B80.BANINST1.REKORIG	Rely On
F_GET_CAMP_PELL_ID	Oracle Package Function	S10B80.BANINST1.REKORIG	Use (select)
F_GET_CIP_CODE_MAJR	Oracle Package Function	S10B80.BANINST1.REKORIG	Rely On
F_GET_CIP_CODE_MAJR	Oracle Package Function	S10B80.BANINST1.REKORIG	Use (select)
F_GET_CIP_CODE_MAJR2	Oracle Package Function	S10B80.BANINST1.REKORIG	Rely On
F_GET_CIP_CODE_MAJR2	Oracle Package Function	S10B80.BANINST1.REKORIG	Use (select)
F_GET_DL_SCHOOL_CODE	Oracle Package Function	S10B80.BANINST1.ROKDRCT	Rely On
F_GET_ENROLLMENT_DATE	Oracle Package Function	S10B80.BANINST1.REKORIG	Rely On
F_GET_EXCLUDE_LEVEL_IND	Oracle Package Function	S10B80.BANINST1.ROKVIEW	Rely On
F_GET_EXCLUDE_LEVEL_IND	Oracle Package Function	S10B80.BANINST1.ROKVIEW	Use (select)
F_GET_HOUSING_APPLICANT_PROF	Oracle Package Function	S10B80.BANINST1.SP_HOUSING_PROFILE	Rely On
F_GET_MAJORS	Oracle Package Function	S10B80.BANINST1.ICSPKCOM	Rely On
F_GET_PERSON_XML	Oracle Package Function	S10B80.BANINST1.XCHAPERS	Use (select)
F_GET_PRIMARY_CURR_DATA	Oracle Package Function	S10B80.BANINST1.SOKLIBS	Rely On
F_GET_PRIMARY_CURR_DATA	Oracle Package Function	S10B80.BANINST1.SOKLIBS_OJ	Rely On
F_GET_PRIMARY_CURR_DATA	Oracle Package Function	S10B80.BANINST1.SOKFUNC	Rely On
F_GET_RULE_PRIO_NUM	Oracle Package Function	S10B80.BANINST1.SFKWLAT	Use (select)
F_GET_SCHOOL_CODE	Oracle Package Function	S10B80.BANINST1.RSKMISC	Rely On
F_GET_SCHOOL_CODE	Oracle Package Function	S10B80.BANINST1.RSKMISC	Use (select)
F_GET_SGBSTDN_MAX_TERM_CODE	Oracle Package Function	S10B80.BANINST1.SGKSELS	Rely On
F_GET_SGBSTDN_MAX_TERM_CODE	Oracle Package Function	S10B80.BANINST1.SGKSELS	Use (select)
F_GET_SGBSTDN_ROW	Oracle Package Function	S10B80.BANINST1.SGKSELS	Rely On
F_GET_SGBSTDN_VALUE	Oracle Package Function	S10B80.BANINST1.SGKSELS	Use (select)
F_GET_STUDENT_BY_TERM	Oracle Package Function	S10B80.BANINST1.ICSPKCOM	Rely On
F_GET_TURN_OFF_PELL_IND	Oracle Package Function	S10B80.BANINST1.ROKFUNC	Rely On
F_GET_TURN_OFF_PELL_IND	Oracle Package Function	S10B80.BANINST1.ROKFUNC	Use (select)
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.SB_LEARNER	Rely On
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.SB_LEARNER	Use (select)
F_QUERY_BY_ROWID	Oracle Package Function	S10B80.BANINST1.SB_LEARNER	Use (select)
F_QUERY_CURRENT	Oracle Package Function	S10B80.BANINST1.SB_LEARNER	Rely On
F_QUERY_CURRENT	Oracle Package Function	S10B80.BANINST1.SB_LEARNER	Use (select)
F_QUERY_END	Oracle Package Function	S10B80.BANINST1.SB_LEARNER	Rely On
F_QUERY_END	Oracle Package Function	S10B80.BANINST1.SB_LEARNER	Use (select)
F_QUERY_EXISTING_SGBSTDN	Oracle Package Function	S10B80.BANINST1.SAKQADM	Rely On
F_QUERY_EXISTING_SGBSTDN	Oracle Package Function	S10B80.BANINST1.SAKQADM	Use (select)
F_QUERY_LAST_TERM	Oracle Package Function	S10B80.BANINST1.SFKSELS	Rely On
F_QUERY_LAST_TERM	Oracle Package Function	S10B80.BANINST1.SFKSELS	Use (select)
F_QUERY_MAX_SEQ	Oracle Package Function	S10B80.BANINST1.SB_CURRICULUM	Use (select)
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.SB_LEARNER	Rely On
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.SB_LEARNER	Use (select)
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.SB_LEARNER	Rely On
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.SB_LEARNER	Use (select)
F_SELECT_STUDENT_PROGRAMS	Oracle Package Function	S10B80.BANINST1.SB_PESCXML_ACADPROGRAM_EXP	Rely On
F_SELECT_STUDENT_PROGRAMS	Oracle Package Function	S10B80.BANINST1.SB_PESCXML_ACADPROGRAM_EXP	Use (select)
F_SORFOLK_VALUE	Oracle Package Function	S10B80.BANINST1.SOKLIBS	Rely On
F_SORFOLK_VALUE	Oracle Package Function	S10B80.BANINST1.SOKLIBS_OJ	Rely On
F_STUDENT_ID_TYPE	Oracle Package Function	S10B80.BANINST1.BWLCXCHN	Use (select)
F_TEST_SGBSTDN_EXIST	Oracle Package Function	S10B80.BANINST1.BWCKCAPP	Rely On
F_TEST_SGBSTDN_SECD	Oracle Package Function	S10B80.BANINST1.BWCKCMPL	Use (select)
F_TEST_SGBSTDN_SECD	Oracle Package Function	S10B80.BANINST1.BWCKCAPP	Use (select)
F_VALIDATEGRADE	Oracle Package Function	S10B80.BANINST1.SHKWEVN	Use (select)
GET_STDN_GRAD_DATE	Oracle Package Function	S10B80.BANINST1.BWCKSMLT	Rely On
GET_STDN_GRAD_DATE	Oracle Package Function	S10B80.BANINST1.BWCKSMLT	Use (select)
SGBSTDN	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_SGBSTDN	SQL Index	S10B80.SATURN	Rely On
RPRDEGR	SQL Table	S10B80.FAISMGR	Join
SFBETRM	SQL Table	S10B80.SATURN	Join
SFRAREG	SQL Table	S10B80.SATURN	Join
SFRSTCR	SQL Table	S10B80.SATURN	Join
SHRTTRM	SQL Table	S10B80.SATURN	Join
SMRPRLE	SQL Table	S10B80.SATURN	Refer (no action)
SOBCURR	SQL Table	S10B80.SATURN	Refer (no action)
SORCCON	SQL Table	S10B80.SATURN	Refer (no action)
SORCMJR	SQL Table	S10B80.SATURN	Refer (no action)
SORCMNR	SQL Table	S10B80.SATURN	Refer (no action)
SORLCUR	SQL Table	S10B80.SATURN	Join
STVACYR	SQL Table	S10B80.SATURN	Refer (no action)
STVADMT	SQL Table	S10B80.SATURN	Refer (no action)
STVAPRN	SQL Table	S10B80.SATURN	Refer (no action)
STVASTD	SQL Table	S10B80.SATURN	Refer (no action)
STVBLCK	SQL Table	S10B80.SATURN	Refer (no action)
STVBSKL	SQL Table	S10B80.SATURN	Refer (no action)
STVCAMP	SQL Table	S10B80.SATURN	Refer (no action)
STVCAPL	SQL Table	S10B80.SATURN	Refer (no action)
STVCAST	SQL Table	S10B80.SATURN	Refer (no action)
STVCOLL	SQL Table	S10B80.SATURN	Refer (no action)
STVDEGC	SQL Table	S10B80.SATURN	Refer (no action)
STVDEPT	SQL Table	S10B80.SATURN	Refer (no action)
STVEDLV	SQL Table	S10B80.SATURN	Refer (no action)
STVEGOL	SQL Table	S10B80.SATURN	Refer (no action)
STVEMEX	SQL Table	S10B80.SATURN	Refer (no action)
STVGAIN	SQL Table	S10B80.SATURN	Refer (no action)
STVINCM	SQL Table	S10B80.SATURN	Refer (no action)
STVLEAV	SQL Table	S10B80.SATURN	Refer (no action)
STVLEVL	SQL Table	S10B80.SATURN	Refer (no action)
STVMAJR	SQL Table	S10B80.SATURN	Refer (no action)
STVORSN	SQL Table	S10B80.SATURN	Refer (no action)
STVPRAC	SQL Table	S10B80.SATURN	Refer (no action)
STVPREV	SQL Table	S10B80.SATURN	Refer (no action)
STVRATE	SQL Table	S10B80.SATURN	Refer (no action)
STVRESD	SQL Table	S10B80.SATURN	Refer (no action)
STVSESS	SQL Table	S10B80.SATURN	Refer (no action)
STVSITE	SQL Table	S10B80.SATURN	Refer (no action)
STVSTST	SQL Table	S10B80.SATURN	Refer (no action)
STVSTYP	SQL Table	S10B80.SATURN	Refer (no action)
STVTERM	SQL Table	S10B80.SATURN	Refer (no action)
STVTRCN	SQL Table	S10B80.SATURN	Refer (no action)
STVVOED	SQL Table	S10B80.SATURN	Refer (no action)
ST_SGBSTDN_AIR	SQL Trigger	S10B80.SATURN	Fire (Insert,after,each row)
ST_SGBSTDN_AIS	SQL Trigger	S10B80.SATURN	Fire (Insert,after,all rows)
ST_SGBSTDN_AR_LDI	SQL Trigger	S10B80.SATURN	Fire (Insert,update,delete,after,each row)
ST_SGBSTDN_AS_LDI	SQL Trigger	S10B80.SATURN	Fire (Insert,update,delete,after,all rows)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SGBSTDN

Object Dates

Creation Date	Analysis Date
04/02/2008 20:53:42:000	04/02/2008 21:18:15:000

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

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

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

Foreign Key information

Column name	is Foreign Key For Column	on Table
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
SGBUSER_TERM_CODE	STVTERM_CODE	STVTERM

Index

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

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_SGBUSER	SQL Index	S10B80.SATURN	Rely On
STVSUDA	SQL Table	S10B80.SATURN	Refer (no action)
STVSUDB	SQL Table	S10B80.SATURN	Refer (no action)
STVSUDC	SQL Table	S10B80.SATURN	Refer (no action)
STVSUDD	SQL Table	S10B80.SATURN	Refer (no action)
STVSUDE	SQL Table	S10B80.SATURN	Refer (no action)
STVSUDF	SQL Table	S10B80.SATURN	Refer (no action)
STVSUDG	SQL Table	S10B80.SATURN	Refer (no action)
STVSUDH	SQL Table	S10B80.SATURN	Refer (no action)
STVSUDI	SQL Table	S10B80.SATURN	Refer (no action)
STVSUDJ	SQL Table	S10B80.SATURN	Refer (no action)
STVTERM	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SGBUSER

Object Dates

Creation Date	Analysis Date
04/02/2008 20:41:48:000	04/02/2008 21:18:05:000

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

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
SGRACMT_PIDM	NUMBER(8,0)	No
SGRACMT_TERM_CODE_EFF	VARCHAR2(6)	No	*
SGRACMT_CATEGORY	VARCHAR2(1)	No
SGRACMT_GTYP_CODE	VARCHAR2(6)	No	*
SGRACMT_SEQNO	NUMBER(23,20)	Yes
SGRACMT_TEXT	VARCHAR2(60)	Yes
SGRACMT_ORIG_CODE	VARCHAR2(4)	Yes	*
SGRACMT_ORIG_DATE	DATE	Yes
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)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SGRACMT_KEY_INDEX	SQL Index	S10B80.SATURN	Rely On
STVGTYP	SQL Table	S10B80.SATURN	Refer (no action)
STVORIG	SQL Table	S10B80.SATURN	Refer (no action)
STVTERM	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SGRACMT

Object Dates

Creation Date	Analysis Date
04/02/2008 21:05:35:000	04/02/2008 21:18:24:000

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

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

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

Foreign Key information

Column name	is Foreign Key For Column	on Table
SGRADVR_ADVR_CODE	STVADVR_CODE	STVADVR
SGRADVR_TERM_CODE_EFF	STVTERM_CODE	STVTERM
SGRADVR_ADVR_PIDM	GOREMAL_PIDM	GOREMAL

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
SPRIDEN	SQL Table	S10B80.SATURN	Join
SGVSTDN	SQL View	S10B80.BANINST1	Use (select)
F_CONCAT_SGRADVR	SQL Function	S10B80.BANINST1	Use (select)
F_FACULTY_ADVISING_IND	SQL Function	S10B80.BANINST1	Use (select)
ADVR_REC	Oracle Package Type	S10B80.BANINST1.SOKLIBS	Rely On
ADVR_REC	Oracle Package Type	S10B80.BANINST1.SOKLIBS_OJ	Rely On
P_GETADVRINFO	Oracle Package Procedure	S10B80.BANINST1.BWCKGSTU	Use (select)
F_CHECKADVISORRELATION	Oracle Package Function	S10B80.BANINST1.BWLKILIB	Use (select)
F_VERIFYCRNADVRPROCESS	Oracle Package Function	S10B80.BANINST1.BWLKILIB	Use (select)
ADVISORC	Oracle Package Cursor	S10B80.BANINST1.SOKLIBS	Use (select)
ADVISORC	Oracle Package Cursor	S10B80.BANINST1.SOKLIBS_OJ	Use (select)
P_DISPADVISEES	Oracle Package Procedure	S10B80.BANINST1.BWLKADVR	Rely On
P_DISPADVISEES	Oracle Package Procedure	S10B80.BANINST1.BWLKADVR	Use (select)
P_FACADVRSECURITY	Oracle Package Procedure	S10B80.BANINST1.BWLKSECR	Use (select)
P_GET_STUDENT_ADVISORS	Oracle Package Procedure	S10B80.BANINST1.BWSCBREF	Use (select)
P_GET_STUDENT_ADVISORS	Oracle Package Procedure	S10B80.BANINST1.BWSCJREF	Use (select)
P_GET_STUDENT_ADVISORS	Oracle Package Procedure	S10B80.BANINST1.BWXCBREF	Use (select)
P_OPEN_STUDENT_LIST_C	Oracle Package Procedure	S10B80.BANINST1.BWLKOIDS	Use (select)
P_SEND_EMAIL	Oracle Package Procedure	S10B80.BANINST1.SFKWLAT	Rely On
P_SEND_EMAIL	Oracle Package Procedure	S10B80.BANINST1.SFKWLAT	Use (select)
F_GETADVRPIDM	Oracle Package Function	S10B80.BANINST1.BWCKSMLT	Rely On
F_GETADVRPIDM	Oracle Package Function	S10B80.BANINST1.BWCKSMLT	Use (select)
F_GETADVRPIDM	Oracle Package Function	S10B80.BANINST1.BWCKCAPP	Rely On
F_GETADVRPIDM	Oracle Package Function	S10B80.BANINST1.BWCKCAPP	Use (select)
F_STUDENT_ID_TYPE	Oracle Package Function	S10B80.BANINST1.BWLCXCHN	Use (select)
SGRADVR	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SGRADVR_ADVR_PIDM_INDEX	SQL Index	S10B80.SATURN	Rely On
SGRADVR_KEY_INDEX	SQL Index	S10B80.SATURN	Rely On
GOREMAL	SQL Table	S10B80.GENERAL	Join
STVADVR	SQL Table	S10B80.SATURN	Refer (no action)
STVTERM	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SGRADVR

Object Dates

Creation Date	Analysis Date
04/02/2008 20:37:45:000	04/02/2008 21:18:01:000

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

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

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

Foreign Key information

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

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
SPRIDEN	SQL Table	S10B80.SATURN	Join
SGVASSI	SQL View	S10B80.BANINST1	Use (select)
SGRASSI	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_SGRASSI	SQL Index	S10B80.SATURN	Rely On
STVCOLL	SQL Table	S10B80.SATURN	Refer (no action)
STVDEGC	SQL Table	S10B80.SATURN	Refer (no action)
STVDEPT	SQL Table	S10B80.SATURN	Refer (no action)
STVGSTA	SQL Table	S10B80.SATURN	Refer (no action)
STVGTYP	SQL Table	S10B80.SATURN	Refer (no action)
STVLEVL	SQL Table	S10B80.SATURN	Refer (no action)
STVMAJR	SQL Table	S10B80.SATURN	Refer (no action)
STVSOFF	SQL Table	S10B80.SATURN	Refer (no action)
STVTERM	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SGRASSI

Object Dates

Creation Date	Analysis Date
04/02/2008 20:36:53:000	04/02/2008 21:18:00:000

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

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

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

Foreign Key information

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

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)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SGRASST_KEY_INDEX	SQL Index	S10B80.SATURN	Rely On
STVGTYP	SQL Table	S10B80.SATURN	Refer (no action)
STVTASK	SQL Table	S10B80.SATURN	Refer (no action)
STVTERM	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SGRASST

Object Dates

Creation Date	Analysis Date
04/02/2008 20:36:58:000	04/02/2008 21:18:00:000

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

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
SGRCATT_SEQ_NO	NUMBER(3,0)	No	*
SGRCATT_ATTS_CODE	VARCHAR2(4)	No	*	*
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
F_CLASS_CALC_FNC	SQL Function	S10B80.BANINST1	Use (select)
P_CLASS_CALC	Oracle Package Procedure	S10B80.BANINST1.SOKLIBS	Use (select)
P_CLASS_CALC	Oracle Package Procedure	S10B80.BANINST1.SOKLIBS_OJ	Use (select)
F_CLASS_CODE	Oracle Package Function	S10B80.BANINST1.SGKCLAS	Use (select)
SGRCATT	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_SGRCATT	SQL Index	S10B80.SATURN	Rely On
STVATTS	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SGRCATT

Object Dates

Creation Date	Analysis Date
04/02/2008 20:49:02:000	04/02/2008 21:18:11:000

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

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

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

Foreign Key information

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

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
SGVCHRT	SQL View	S10B80.BANINST1	Use (select)
SHVTER1	SQL View	S10B80.BANINST1	Use (select)
SHVYEA1	SQL View	S10B80.BANINST1	Use (select)
SHVYEA1_OJ	SQL View	S10B80.BANINST1	Use (select)
SOVCHRT	SQL View	S10B80.BANINST1	Use (select)
SPVTER1	SQL View	S10B80.BANINST1	Use (select)
SPVYEA1	SQL View	S10B80.BANINST1	Use (select)
F_CONCAT_SGRCHRT	SQL Function	S10B80.BANINST1	Use (select)
F_SGRCHRT_ROWID_FNC	SQL Function	S10B80.BANINST1	Use (select)
F_STUDENT_CHECK_FOR_MORE	SQL Function	S10B80.BANINST1	Use (select)
GT_SGRCHRT_TAB	Oracle Package Type	S10B80.BANINST1.SGKSELS	Rely On
P_CREATE_APPLICATION	Oracle Package Procedure	S10B80.BANINST1.TS_SB_REGISTRATION	Use (Insert)
P_GETSGRCHRT	Oracle Package Procedure	S10B80.BANINST1.SOKWEXT	Rely On
P_GETSGRCHRT	Oracle Package Procedure	S10B80.BANINST1.SOKWEXT	Use (select)
P_INSERT_SHRCHRT	Oracle Package Procedure	S10B80.BANINST1.SHKROLS	Rely On
P_INSERT_SHRCHRT	Oracle Package Procedure	S10B80.BANINST1.SHKROLS	Use (select)
P_QUERY_RESULTS	Oracle Package Procedure	S10B80.BANINST1.TS_SB_FEEASSESSMENT_ASSMT	Rely On
P_QUERY_RESULTS	Oracle Package Procedure	S10B80.BANINST1.TS_SB_FEEASSESSMENT_ASSMT	Use (select)Rely On
P_QUERY_RESULTS	Oracle Package Procedure	S10B80.BANINST1.TS_SB_REGISTRATION	Rely On
P_QUERY_RESULTS	Oracle Package Procedure	S10B80.BANINST1.TS_SB_REGISTRATION	Use (select)Rely On
P_QUERY_RESULTS	Oracle Package Procedure	S10B80.BANINST1.TS_SB_FEEASSESSMENT_RULES	Rely On
P_QUERY_RESULTS	Oracle Package Procedure	S10B80.BANINST1.TS_SB_FEEASSESSMENT_RULES	Use (select)Rely On
TESTCHRT	Oracle Package Procedure	S10B80.BANINST1.TS_SB_FEEASSESSMENT_RULES	Use (Insert,update,delete)
TESTRRES	Oracle Package Procedure	S10B80.BANINST1.TS_SB_REGISTRATION	Use (Insert)
SGRCHRT_ROW	Oracle Package Variable	S10B80.BANINST1.SHKROLS	Rely On
SGRCHRT_C	Oracle Package Cursor	S10B80.BANINST1.SGKSELS	Rely On
SGRCHRT_C	Oracle Package Cursor	S10B80.BANINST1.SGKSELS	Use (select)Rely On
P_CHECK_CHRT	Oracle Package Procedure	S10B80.BANINST1.SFKFUNC	Rely On
P_CHECK_CHRT	Oracle Package Procedure	S10B80.BANINST1.SFKFUNC	Use (select)
P_INSERT_COHORT	Oracle Package Procedure	S10B80.BANINST1.SAKMODS	Use (Insert,select)
P_PROCESS_MASS_ENTRY	Oracle Package Procedure	S10B80.BANINST1.SOKMAUD	Use (Insert,update,select)
F_IS_ELIGIBLE	Oracle Package Function	S10B80.BANINST1.SHKGAPP	Rely On
F_QUERY_SGRCHRT	Oracle Package Function	S10B80.BANINST1.SGKSELS	Use (select)
SGRCHRT	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SGRCHRT_KEY_INDEX	SQL Index	S10B80.SATURN	Rely On
SGRCHRT_KEY_INDEX2	SQL Index	S10B80.SATURN	Rely On
SFBETRM	SQL Table	S10B80.SATURN	Join
STVCHRT	SQL Table	S10B80.SATURN	Refer (no action)
STVCREA	SQL Table	S10B80.SATURN	Refer (no action)
STVTERM	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SGRCHRT

Object Dates

Creation Date	Analysis Date
04/02/2008 20:46:14:000	04/02/2008 21:18:09:000

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

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
SGRCLSR_LEVL_CODE	VARCHAR2(2)	No	*
SGRCLSR_CLAS_CODE	VARCHAR2(2)	No	*
SGRCLSR_FROM_HOURS	NUMBER(11,3)	No
SGRCLSR_TO_HOURS	NUMBER(11,3)	No
SGRCLSR_ACTIVITY_DATE	DATE	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
F_CLASS_CALC_FNC	SQL Function	S10B80.BANINST1	Rely On
F_CLASS_CALC_FNC	SQL Function	S10B80.BANINST1	Use (select)
GETSTUDENTCLASC	Oracle Package Cursor	S10B80.BANINST1.BWCKREGS	Use (select)
CLAS_CODE	Oracle Package Variable	S10B80.BANINST1.BWSKRSTA	Rely On
STUD_CLASS	Oracle Package Variable	S10B80.BANINST1.BWCKREGS	Rely On
STUD_EARNED_HRS_CLASS	Oracle Package Variable	S10B80.BANINST1.BWCKREGS	Rely On
F_GETEARNEDHRSCLAS	Oracle Package Function	S10B80.BANINST1.BWCKREGS	Rely On
SGRCLSR_ROW_BY_LEVL_HRS_C	Oracle Package Cursor	S10B80.BANINST1.SGKSELS	Rely On
SGRCLSR_ROW_BY_LEVL_HRS_C	Oracle Package Cursor	S10B80.BANINST1.SGKSELS	Use (select)Rely On
P_ADD_SFTREGS	Oracle Package Procedure	S10B80.BANINST1.BWCKLIBS	Rely On
P_CHECK_CLAS	Oracle Package Procedure	S10B80.BANINST1.SFKFUNC	Rely On
P_CLASS_CALC	Oracle Package Procedure	S10B80.BANINST1.SOKLIBS	Rely On
P_CLASS_CALC	Oracle Package Procedure	S10B80.BANINST1.SOKLIBS	Use (select)
P_CLASS_CALC	Oracle Package Procedure	S10B80.BANINST1.SOKLIBS_OJ	Rely On
P_CLASS_CALC	Oracle Package Procedure	S10B80.BANINST1.SOKLIBS_OJ	Use (select)
P_DEL_SFTREGS	Oracle Package Procedure	S10B80.BANINST1.BWCKLIBS	Rely On
P_FINAL_UPDATES	Oracle Package Procedure	S10B80.BANINST1.BWCKREGS	Rely On
P_GROUP_EDITS	Oracle Package Procedure	S10B80.BANINST1.BWCKCOMS	Rely On
P_PRE_EDIT	Oracle Package Procedure	S10B80.BANINST1.SFKEDIT	Rely On
P_REGS	Oracle Package Procedure	S10B80.BANINST1.BWCKCOMS	Rely On
P_REGSUPD	Oracle Package Procedure	S10B80.BANINST1.BWCKGENS	Rely On
P_REGS_ETRM_CHK	Oracle Package Procedure	S10B80.BANINST1.BWCKCOMS	Rely On
P_UPDATE_REGS	Oracle Package Procedure	S10B80.BANINST1.SFKEDIT	Rely On
P_UPDVARDATA_SFTREGS	Oracle Package Procedure	S10B80.BANINST1.BWCKLIBS	Rely On
P_UPD_SFTREGS	Oracle Package Procedure	S10B80.BANINST1.BWCKLIBS	Rely On
P_VERIFY_ELIGIBLE_TO_REGISTER	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
P_VR_ADD_CLASS	Oracle Package Procedure	S10B80.BANINST1.VRSKFREG	Rely On
P_VR_DROP_CLASS_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFREG	Rely On
P_VR_PROCESS_ADMINDROPS	Oracle Package Procedure	S10B80.BANINST1.VRSKFREG	Rely On
P_VR_REG_APPL_MENU_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
P_VR_REG_TERM_ELIGIBLE	Oracle Package Procedure	S10B80.BANINST1.VRSKFOLR	Rely On
P_VR_WITHDRAW_FROM_TERM	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
F_CHECK_MGMT_CONTROL	Oracle Package Function	S10B80.BANINST1.SFKRCTL	Rely On
F_CLASS_CODE	Oracle Package Function	S10B80.BANINST1.SGKCLAS	Use (select)
SGRCLSR	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SGRCLSR_KEY_INDEX	SQL Index	S10B80.SATURN	Rely On
STVCLAS	SQL Table	S10B80.SATURN	Refer (no action)
STVLEVL	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SGRCLSR

Object Dates

Creation Date	Analysis Date
04/02/2008 21:05:29:000	04/02/2008 21:18:24:000

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

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

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

Foreign Key information

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

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)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SGRCMNT_KEY_INDEX	SQL Index	S10B80.SATURN	Rely On
STVACTC	SQL Table	S10B80.SATURN	Refer (no action)
STVTERM	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SGRCMNT

Object Dates

Creation Date	Analysis Date
04/02/2008 20:35:19:000	04/02/2008 21:17:59:000

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

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

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

Foreign Key information

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

Index

Index Name	Index Type	Column Name
SGRCOLR_KEY_INDEX		SGRCOLR_SESSIONID
SGRCOLR_KEY_INDEX		SGRCOLR_CHRT_CODE

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SGRCOLR_KEY_INDEX	SQL Index	S10B80.SATURN	Rely On
STVACTC	SQL Table	S10B80.SATURN	Refer (no action)
STVCHRT	SQL Table	S10B80.SATURN	Refer (no action)
STVCREA	SQL Table	S10B80.SATURN	Refer (no action)
STVDEGC	SQL Table	S10B80.SATURN	Refer (no action)
STVDLEV	SQL Table	S10B80.SATURN	Refer (no action)
STVMAJR	SQL Table	S10B80.SATURN	Refer (no action)
STVTERM	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SGRCOLR

Object Dates

Creation Date	Analysis Date
04/02/2008 20:43:42:000	04/02/2008 21:18:07:000

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

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

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

Foreign Key information

Column name	is Foreign Key For Column	on Table
SGRCOOP_EMPL_CODE	STVEMPL_CODE	STVEMPL
SGRCOOP_COPC_CODE	STVCOPC_CODE	STVCOPC
SGRCOOP_LEVL_CODE	STVLEVL_CODE	STVLEVL
SGRCOOP_TERM_CODE	STVTERM_CODE	STVTERM
SGRCOOP_PIDM	SFRSTCR_PIDM	SFRSTCR
SGRCOOP_TERM_CODE	SFRSTCR_TERM_CODE	SFRSTCR
SGRCOOP_CRN	SFRSTCR_CRN	SFRSTCR
SGRCOOP_PIDM	SFRAREG_PIDM	SFRAREG
SGRCOOP_TERM_CODE	SFRAREG_TERM_CODE	SFRAREG
SGRCOOP_CRN	SFRAREG_CRN	SFRAREG

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
SGRDUTY	SQL Table	S10B80.SATURN	Refer (no action)
P_GET_STUDENT_COURSE	Oracle Package Procedure	S10B80.BANINST1.SHKROLS	Use (select)
SGRCOOP	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_SGRCOOP	SQL Index	S10B80.SATURN	Rely On
SFRAREG	SQL Table	S10B80.SATURN	Join
SFRSTCR	SQL Table	S10B80.SATURN	Join
STVCOPC	SQL Table	S10B80.SATURN	Refer (no action)
STVEMPL	SQL Table	S10B80.SATURN	Refer (no action)
STVLEVL	SQL Table	S10B80.SATURN	Refer (no action)
STVTERM	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SGRCOOP

Object Dates

Creation Date	Analysis Date
04/02/2008 20:44:04:000	04/02/2008 21:18:07:000

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.

Columns Comments for SGRCOOP_CTRY_CODE_PHONE (# 20)

Source Code Comments

TELEPHONE COUNTRY CODE: Code designating the region or country.

Table SGRDISA

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
SGRDISA_PIDM	NUMBER(8,0)	No	*
SGRDISA_TERM_CODE	VARCHAR2(6)	No	*	*
SGRDISA_DISA_CODE	VARCHAR2(2)	No	*	*
SGRDISA_MEDI_CODE	VARCHAR2(10)	Yes		*
SGRDISA_SPSR_CODE	VARCHAR2(2)	Yes		*
SGRDISA_PRIMARY_IND	VARCHAR2(1)	Yes
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
SGRDSER	SQL Table	S10B80.SATURN	Refer (no action)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_SGRDISA	SQL Index	S10B80.SATURN	Rely On
STVDISA	SQL Table	S10B80.SATURN	Refer (no action)
STVMEDI	SQL Table	S10B80.SATURN	Refer (no action)
STVSPSR	SQL Table	S10B80.SATURN	Refer (no action)
STVTERM	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SGRDISA

Object Dates

Creation Date	Analysis Date
04/02/2008 21:05:02:000	04/02/2008 21:18:24:000

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

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

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

Foreign Key information

Column name	is Foreign Key For Column	on Table
SGRDSER_SEPR_CODE	STVSEPR_CODE	STVSEPR
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_ORIG_CODE	STVORIG_CODE	STVORIG
SGRDSER_CAMP_CODE	STVCAMP_CODE	STVCAMP
SGRDSER_TERM_CODE	STVTERM_CODE	STVTERM
SGRDSER_SPRV_CODE	STVSPRV_CODE	STVSPRV
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)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SGRDSER_KEY_INDEX	SQL Index	S10B80.SATURN	Rely On
SGRDISA	SQL Table	S10B80.SATURN	Refer (no action)
STVCAMP	SQL Table	S10B80.SATURN	Refer (no action)
STVDISA	SQL Table	S10B80.SATURN	Refer (no action)
STVORIG	SQL Table	S10B80.SATURN	Refer (no action)
STVSEPR	SQL Table	S10B80.SATURN	Refer (no action)
STVSPRV	SQL Table	S10B80.SATURN	Refer (no action)
STVSSEP	SQL Table	S10B80.SATURN	Refer (no action)
STVSSER	SQL Table	S10B80.SATURN	Refer (no action)
STVSSRS	SQL Table	S10B80.SATURN	Refer (no action)
STVSSST	SQL Table	S10B80.SATURN	Refer (no action)
STVTERM	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SGRDSER

Object Dates

Creation Date	Analysis Date
04/02/2008 20:40:29:000	04/02/2008 21:18:04:000

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

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

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

Foreign Key information

Column name	is Foreign Key For Column	on Table
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
SGRDUTY_LEVL_CODE	STVLEVL_CODE	STVLEVL
SGRDUTY_TERM_CODE	STVTERM_CODE	STVTERM

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)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_SGRDUTY	SQL Index	S10B80.SATURN	Rely On
SGRCOOP	SQL Table	S10B80.SATURN	Refer (no action)
STVEMPL	SQL Table	S10B80.SATURN	Refer (no action)
STVLEVL	SQL Table	S10B80.SATURN	Refer (no action)
STVTERM	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SGRDUTY

Object Dates

Creation Date	Analysis Date
04/02/2008 20:50:51:000	04/02/2008 21:18:13:000

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

This field is the Coop Assignment Sequence Number. The SGRDUTY_COOP_SEQ_NO corresponds to the SGRCOOP_SEQ_NO.

Table SGRESEL

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
SGRESEL_PIDM	NUMBER(8,0)	No
SGRESEL_TERM_CODE_EFF	VARCHAR2(6)	No	*
SGRESEL_ESEL_CODE	VARCHAR2(2)	Yes	*
SGRESEL_PRIMARY_IND	VARCHAR2(1)	Yes
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)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SGRESEL_KEY_INDEX	SQL Index	S10B80.SATURN	Rely On
STVESEL	SQL Table	S10B80.SATURN	Refer (no action)
STVTERM	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SGRESEL

Object Dates

Creation Date	Analysis Date
04/02/2008 20:53:15:000	04/02/2008 21:18:15:000

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

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

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

Foreign Key information

Column name	is Foreign Key For Column	on Table
SGRSACT_ACTC_CODE	STVACTC_CODE	STVACTC
SGRSACT_TERM_CODE	STVTERM_CODE	STVTERM
SGRSACT_PIDM	SFBETRM_PIDM	SFBETRM
SGRSACT_TERM_CODE	SFBETRM_TERM_CODE	SFBETRM

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
SGVSACT	SQL View	S10B80.BANINST1	Use (select)
SOVSACT	SQL View	S10B80.BANINST1	Use (select)
SOVSACT_OJ	SQL View	S10B80.BANINST1	Use (select)
GT_EXTRACURR_REC	Oracle Package Type	S10B80.BANINST1.SP_HOUSING_PROFILE	Rely On
UT_SP_HOUSING_PROFILEP_API	Oracle Package Procedure	S10B80.BANINST1.UT_SP_HOUSING_PROFILE	Use (Insert)
F_LOAD_EXTRACURR_TAB	Oracle Package Function	S10B80.BANINST1.SP_HOUSING_PROFILE	Rely On
F_LOAD_EXTRACURR_TAB	Oracle Package Function	S10B80.BANINST1.SP_HOUSING_PROFILE	Use (select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SP_HOUSING_PROFILE	Use (Insert)
SGRSACT	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SGRSACT_KEY_INDEX	SQL Index	S10B80.SATURN	Rely On
SFBETRM	SQL Table	S10B80.SATURN	Join
STVACTC	SQL Table	S10B80.SATURN	Refer (no action)
STVTERM	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SGRSACT

Object Dates

Creation Date	Analysis Date
04/02/2008 20:54:01:000	04/02/2008 21:18:15:000

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

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
SGRSATT_PIDM	NUMBER(8,0)	No	*
SGRSATT_TERM_CODE_EFF	VARCHAR2(6)	No	*
SGRSATT_ATTS_CODE	VARCHAR2(4)	Yes	*
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
SGRSATT_PIDM	SFBETRM_PIDM	SFBETRM
SGRSATT_ATTS_CODE	SORMATT_ATTR_CODE	SORMATT

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
SGVSATT	SQL View	S10B80.BANINST1	Use (select)
SOVSATT	SQL View	S10B80.BANINST1	Use (select)
SOVSATT_OJ	SQL View	S10B80.BANINST1	Use (select)
F_CLASS_CALC_FNC	SQL Function	S10B80.BANINST1	Use (select)
GT_SGRSATT_TAB	Oracle Package Type	S10B80.BANINST1.SGKSELS	Rely On
P_CREATE_APPLICATION	Oracle Package Procedure	S10B80.BANINST1.TS_SB_REGISTRATION	Use (Insert)
P_MATERIAL_MATCHING	Oracle Package Procedure	S10B80.BANINST1.SOKCPLN	Use (select)
P_QUERY_RESULTS	Oracle Package Procedure	S10B80.BANINST1.TS_SB_FEEASSESSMENT_ASSMT	Rely On
P_QUERY_RESULTS	Oracle Package Procedure	S10B80.BANINST1.TS_SB_FEEASSESSMENT_ASSMT	Use (select)Rely On
P_QUERY_RESULTS	Oracle Package Procedure	S10B80.BANINST1.TS_SB_REGISTRATION	Rely On
P_QUERY_RESULTS	Oracle Package Procedure	S10B80.BANINST1.TS_SB_REGISTRATION	Use (select)Rely On
P_QUERY_RESULTS	Oracle Package Procedure	S10B80.BANINST1.TS_SB_FEEASSESSMENT_RULES	Rely On
P_QUERY_RESULTS	Oracle Package Procedure	S10B80.BANINST1.TS_SB_FEEASSESSMENT_RULES	Use (select)Rely On
TESTATTS	Oracle Package Procedure	S10B80.BANINST1.TS_SB_FEEASSESSMENT_RULES	Use (Insert,delete)
TESTRRES	Oracle Package Procedure	S10B80.BANINST1.TS_SB_REGISTRATION	Use (Insert)
SGRSATT_C	Oracle Package Cursor	S10B80.BANINST1.SGKSELS	Rely On
SGRSATT_C	Oracle Package Cursor	S10B80.BANINST1.SGKSELS	Use (select)Rely On
P_CHECK_ATTS	Oracle Package Procedure	S10B80.BANINST1.SFKFUNC	Rely On
P_CHECK_ATTS	Oracle Package Procedure	S10B80.BANINST1.SFKFUNC	Use (select)
P_CLASS_CALC	Oracle Package Procedure	S10B80.BANINST1.SOKLIBS	Use (select)
P_CLASS_CALC	Oracle Package Procedure	S10B80.BANINST1.SOKLIBS_OJ	Use (select)
P_GET_MIN_MAX_BY_CURRIC	Oracle Package Procedure	S10B80.BANINST1.SFKSELS	Use (select)
P_INSERT_ATTRIBUTE	Oracle Package Procedure	S10B80.BANINST1.SAKMODS	Use (Insert,select)
P_PROCESS_MASS_ENTRY	Oracle Package Procedure	S10B80.BANINST1.SOKMAUD	Use (Insert,update,select)
F_CLASS_CODE	Oracle Package Function	S10B80.BANINST1.SGKCLAS	Use (select)
F_IS_ELIGIBLE	Oracle Package Function	S10B80.BANINST1.SHKGAPP	Rely On
F_QUERY_SGRSATT	Oracle Package Function	S10B80.BANINST1.SGKSELS	Use (select)
SGRSATT	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SGRSATT_KEY_INDEX	SQL Index	S10B80.SATURN	Rely On
SFBETRM	SQL Table	S10B80.SATURN	Join
SORMATT	SQL Table	S10B80.SATURN	Join
STVATTS	SQL Table	S10B80.SATURN	Refer (no action)
STVTERM	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SGRSATT

Object Dates

Creation Date	Analysis Date
04/02/2008 20:55:57:000	04/02/2008 21:18:17:000

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

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
SGRSCMT_PIDM	NUMBER(8,0)	No
SGRSCMT_SEQ_NO	NUMBER(3,0)	No
SGRSCMT_TERM_CODE	VARCHAR2(6)	Yes	*
SGRSCMT_COMMENT_TEXT	VARCHAR2(4000)	Yes
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)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SGRSCMT_KEY_INDEX	SQL Index	S10B80.SATURN	Rely On
STVTERM	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SGRSCMT

Object Dates

Creation Date	Analysis Date
04/02/2008 21:04:38:000	04/02/2008 21:18:23:000

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

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

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

Foreign Key information

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

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
F_CONCAT_SGRSPRT	SQL Function	S10B80.BANINST1	Use (select)
F_STUDENT_CHECK_FOR_MORE	SQL Function	S10B80.BANINST1	Use (select)
GT_SGRSPRT_TAB	Oracle Package Type	S10B80.BANINST1.SGKSELS	Rely On
GT_SPORT_REC	Oracle Package Type	S10B80.BANINST1.SP_HOUSING_PROFILE	Rely On
UT_SP_HOUSING_PROFILEP_API	Oracle Package Procedure	S10B80.BANINST1.UT_SP_HOUSING_PROFILE	Use (Insert)
F_LOAD_SPORT_TAB	Oracle Package Function	S10B80.BANINST1.SP_HOUSING_PROFILE	Rely On
F_LOAD_SPORT_TAB	Oracle Package Function	S10B80.BANINST1.SP_HOUSING_PROFILE	Use (select)
SGRSPRT_C	Oracle Package Cursor	S10B80.BANINST1.SGKSELS	Rely On
SGRSPRT_C	Oracle Package Cursor	S10B80.BANINST1.SGKSELS	Use (select)Rely On
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SP_HOUSING_PROFILE	Use (Insert)
F_QUERY_SGRSPRT	Oracle Package Function	S10B80.BANINST1.SGKSELS	Use (select)
SGRSPRT	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_SGRSPRT	SQL Index	S10B80.SATURN	Rely On
STVACTC	SQL Table	S10B80.SATURN	Refer (no action)
STVELIG	SQL Table	S10B80.SATURN	Refer (no action)
STVSPST	SQL Table	S10B80.SATURN	Refer (no action)
STVTERM	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SGRSPRT

Object Dates

Creation Date	Analysis Date
04/02/2008 20:55:26:000	04/02/2008 21:18:16:000

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

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

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

Foreign Key information

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

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
ROVVETN	SQL View	S10B80.BANINST1	Use (select)
F_VETERANSTUDENT	Oracle Package Function	S10B80.BANINST1.SGKWEVN	Use (select)
SGRVETN	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_SGRVETN	SQL Index	S10B80.SATURN	Rely On
STVTERM	SQL Table	S10B80.SATURN	Refer (no action)
STVVETC	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SGRVETN

Object Dates

Creation Date	Analysis Date
04/02/2008 20:45:09:000	04/02/2008 21:18:08:000

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 SGRASSI and PK_SGRASSI

Link List

Link Type	Link	Project
Rely On	Link Between SGRASSI and PK_SGRASSI	SATURN

List of Real links

Link type	Between	And
Rely On	SGRASSI	PK_SGRASSI

Link between SGBUSER and PK_SGBUSER

Link List

Link Type	Link	Project
Rely On	Link Between SGBUSER and PK_SGBUSER	SATURN

List of Real links

Link type	Between	And
Rely On	SGBUSER	PK_SGBUSER

Link between SGRCOOP and PK_SGRCOOP

Link List

Link Type	Link	Project
Rely On	Link Between SGRCOOP and PK_SGRCOOP	SATURN

List of Real links

Link type	Between	And
Rely On	SGRCOOP	PK_SGRCOOP

Link between SGRVETN and PK_SGRVETN

Link List

Link Type	Link	Project
Rely On	Link Between SGRVETN and PK_SGRVETN	SATURN

List of Real links

Link type	Between	And
Rely On	SGRVETN	PK_SGRVETN

Link between SGRCATT and PK_SGRCATT

Link List

Link Type	Link	Project
Rely On	Link Between SGRCATT and PK_SGRCATT	SATURN

List of Real links

Link type	Between	And
Rely On	SGRCATT	PK_SGRCATT

Link between SGRDUTY and PK_SGRDUTY

Link List

Link Type	Link	Project
Rely On	Link Between SGRDUTY and PK_SGRDUTY	SATURN

List of Real links

Link type	Between	And
Rely On	SGRDUTY	PK_SGRDUTY

Link between SGRDUTY and SGRCOOP

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SGRDUTY and SGRCOOP (FK1_SGRDUTY_INV_SGRCOOP_KEY)	SATURN

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)

Link between SGBEOPS and PK_SGBEOPS

Link List

Link Type	Link	Project
Rely On	Link Between SGBEOPS and PK_SGBEOPS	SATURN

List of Real links

Link type	Between	And
Rely On	SGBEOPS	PK_SGBEOPS

Link between SGBSTDN and PK_SGBSTDN

Link List

Link Type	Link	Project
Rely On	Link Between SGBSTDN and PK_SGBSTDN	SATURN

List of Real links

Link type	Between	And
Rely On	SGBSTDN	PK_SGBSTDN

Link between SABAUDF and PK_SABAUDF

Link List

Link Type	Link	Project
Rely On	Link Between SABAUDF and PK_SABAUDF	SATURN

List of Real links

Link type	Between	And
Rely On	SABAUDF	PK_SABAUDF

Link between SGRSPRT and PK_SGRSPRT

Link List

Link Type	Link	Project
Rely On	Link Between SGRSPRT and PK_SGRSPRT	SATURN

List of Real links

Link type	Between	And
Rely On	SGRSPRT	PK_SGRSPRT

Link between SGRDISA and PK_SGRDISA

Link List

Link Type	Link	Project
Rely On	Link Between SGRDISA and PK_SGRDISA	SATURN

List of Real links

Link type	Between	And
Rely On	SGRDISA	PK_SGRDISA

Link between SGRDSER and SGRDISA

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SGRDSER and SGRDISA (FK1_SGRDSER_INV_SGRDISA_KEY)	SATURN

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)