Model General Student Tables

Model Label : Tables used for Banner Student General Student

List of Objects

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

Comments

Model View

Table EXCEPTIONS

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

Table Columns information

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

Foreign Key information

No Foreign Key

Index

No Result

Calling objects (non escalated)

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

Comments

Table SABAUDF

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

Table Columns information

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

Foreign Key information

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

Index

Index Name	Index Type	Column Name
PK_SABAUDF	Unique	SABAUDF_TERM_CODE_EFF

Calling objects (non escalated)

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

Called objects (non escalated)

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

Comments

Source Code Comments

Application User Defined Fields Table

Columns Comments for SABAUDF_TERM_CODE_EFF (1)

Source Code Comments

This is the effective term.

Columns Comments for SABAUDF_ACTIVITY_DATE (32)

Source Code Comments

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

Table SGBEOPS

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

Table Columns information

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

Foreign Key information

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

Index

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

Calling objects (non escalated)

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

Called objects (non escalated)

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

Comments

Source Code Comments

Education Opportunity Programs and Services Base Table

Columns Comments for SGBEOPS_PIDM (1)

Source Code Comments

The Pidm of the student

Columns Comments for SGBEOPS_TERM_CODE_EFF (2)

Source Code Comments

The Effective Term

Columns Comments for SGBEOPS_EOPS_CODE (3)

Source Code Comments

Education Opportunity Programs and Services Code

Columns Comments for SGBEOPS_ACCEPT_DATE (4)

Source Code Comments

The date the student was accepted into the EOPS program

Columns Comments for SGBEOPS_SFAE_CODE (5)

Source Code Comments

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

Columns Comments for SGBEOPS_ACTIVITY_DATE (6)

Source Code Comments

The Activity Date

Columns Comments for SGBEOPS_TRAC_CODE (7)

Source Code Comments

EOPS Acceptance Period Code

Columns Comments for SGBEOPS_PLANNED_CREDITS (8)

Source Code Comments

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

Columns Comments for SGBEOPS_WTHD_CODE (9)

Source Code Comments

Withdrawal Reason.

Table SGBOEDU

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

Table Columns information

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

Foreign Key information

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

Index

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

Calling objects (non escalated)

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

Called objects (non escalated)

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

Comments

Source Code Comments

Student Other Educational Programs Table

Columns Comments for SGBOEDU_PIDM (1)

Source Code Comments

Person Internal Identification Number

Columns Comments for SGBOEDU_TERM_CODE_EFF (2)

Source Code Comments

Effective Term Code

Columns Comments for SGBOEDU_EOPS_CODE (3)

Source Code Comments

Educational Opportunity Program Code

Columns Comments for SGBOEDU_SFAE_CODE (4)

Source Code Comments

State Financial Aid Eligibility Code

Columns Comments for SGBOEDU_ACCEPT_DATE (5)

Source Code Comments

Acceptance Date

Columns Comments for SGBOEDU_TRAC_CODE (6)

Source Code Comments

Period of Acceptance Code.

Columns Comments for SGBOEDU_PLANNED_CREDITS (7)

Source Code Comments

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

Columns Comments for SGBOEDU_ACTIVITY_DATE (8)

Source Code Comments

The Activity Date

Columns Comments for SGBOEDU_MARS_CODE (9)

Source Code Comments

CARE Student Marital Status.

Columns Comments for SGBOEDU_DEPS_CODE (10)

Source Code Comments

CARE Student Number of Dependents.

Columns Comments for SGBOEDU_AFDC_CODE (11)

Source Code Comments

CARE Student Time on AFDC.

Columns Comments for SGBOEDU_WTHD_CODE (12)

Source Code Comments

CARE Withdrawal Reason.

Table SGBSTDN

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

Table Columns information

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