Model ERD General Student

Model Label : ERD for General Student

List of Objects

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

Comments

Model View

Table EXCEPTIONS

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

Table Columns information

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

Foreign Key information

No Foreign Key

Index

No Result

Calling objects (non escalated)

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

Comments

Table SABAUDF

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

Table Columns information

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

Foreign Key information

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

Index

Index Name	Index Type	Column Name
PK_SABAUDF	Unique	SABAUDF_TERM_CODE_EFF

Calling objects (non escalated)

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

Called objects (non escalated)

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

Comments

Source Code Comments

Application User Defined Fields Table

Columns Comments for SABAUDF_TERM_CODE_EFF (1)

Source Code Comments

This is the effective term.

Columns Comments for SABAUDF_ACTIVITY_DATE (32)

Source Code Comments

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

Table SFRMHRS

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

Table Columns information

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

Foreign Key information

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

Index

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

Calling objects (non escalated)

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

Called objects (non escalated)

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

Comments

Source Code Comments

Registration Maximum Hours Table

Columns Comments for SFRMHRS_TERM_CODE (1)

Source Code Comments

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

Columns Comments for SFRMHRS_LEVL_CODE (2)

Source Code Comments

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

Columns Comments for SFRMHRS_MAX_HRS (3)

Source Code Comments

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

Columns Comments for SFRMHRS_ACTIVITY_DATE (4)

Source Code Comments

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

Table SGBEOPS

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

Table Columns information

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

Foreign Key information

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

Index

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

Calling objects (non escalated)

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

Called objects (non escalated)

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

Comments

Source Code Comments

Education Opportunity Programs and Services Base Table

Columns Comments for SGBEOPS_PIDM (1)

Source Code Comments

The Pidm of the student

Columns Comments for SGBEOPS_TERM_CODE_EFF (2)

Source Code Comments

The Effective Term

Columns Comments for SGBEOPS_EOPS_CODE (3)

Source Code Comments

Education Opportunity Programs and Services Code

Columns Comments for SGBEOPS_ACCEPT_DATE (4)

Source Code Comments

The date the student was accepted into the EOPS program

Columns Comments for SGBEOPS_SFAE_CODE (5)

Source Code Comments

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

Columns Comments for SGBEOPS_ACTIVITY_DATE (6)

Source Code Comments

The Activity Date

Columns Comments for SGBEOPS_TRAC_CODE (7)

Source Code Comments

EOPS Acceptance Period Code

Columns Comments for SGBEOPS_PLANNED_CREDITS (8)

Source Code Comments

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

Columns Comments for SGBEOPS_WTHD_CODE (9)

Source Code Comments

Withdrawal Reason.

Table SGBOEDU

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	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