Model ERD Schedule

Model Label : ERD for Banner Student Schedule

List of Objects

Object Name	Object Type	Layer Name
GEBFUNC	TABLE	ERD
GTVDUNT	TABLE	ERD
GTVINSM	TABLE	ERD
GTVMTYP	TABLE	ERD
GTVPARS	TABLE	ERD
GTVSCHS	TABLE	ERD
RORSECT	TABLE	ERD
SCBCRKY	TABLE	ERD
SCBCRSE	TABLE	ERD
SCRSCHD	TABLE	ERD
SFRSTCA	TABLE	ERD
SFRSTCR	TABLE	ERD
SFTREGS	TABLE	ERD
SHBGSCH	TABLE	ERD
SIRASGN	TABLE	ERD
SIRLVAS	TABLE	ERD
SLBBLDG	TABLE	ERD
SMRALIB	TABLE	ERD
SMRPRLE	TABLE	ERD
SSBACRL	TABLE	Tables
SSBDESC	TABLE	Tables
SSBDFEE	TABLE	Tables
SSBFSEC	TABLE	Tables
SSBOVRR	TABLE	Tables
SSBSECT	TABLE	Tables
SSBSSEC	TABLE	Tables
SSBXLST	TABLE	Tables
SSRATTR	TABLE	Tables
SSRBLCK	TABLE	Tables
SSRCORQ	TABLE	Tables
SSRCTRL	TABLE	Tables
SSREVAL	TABLE	Tables
SSREXCL	TABLE	Tables
SSREXTN	TABLE	Tables
SSRFEES	TABLE	Tables
SSRLINK	TABLE	Tables
SSRMEET	TABLE	Tables
SSRMPRT	TABLE	Tables
SSRMRDF	TABLE	Tables
SSRRARE	TABLE	Tables
SSRRCLS	TABLE	Tables
SSRRCMP	TABLE	Tables
SSRRCOL	TABLE	Tables
SSRRDEG	TABLE	Tables
SSRRESV	TABLE	Tables
SSRRFND	TABLE	Tables
SSRRLVL	TABLE	Tables
SSRRMAJ	TABLE	Tables
SSRRPRG	TABLE	Tables
SSRRSTS	TABLE	Tables
SSRRTST	TABLE	Tables
SSRSCCD	TABLE	Tables
SSRSPRT	TABLE	Tables
SSRSRDF	TABLE	Tables
SSRSYLN	TABLE	Tables
SSRSYLO	TABLE	Tables
SSRSYRM	TABLE	Tables
SSRSYTR	TABLE	Tables
SSRTEXT	TABLE	Tables
SSRXLST	TABLE	Tables
SSTSCHW	TABLE	Tables
STVACCL	TABLE	ERD
STVACCT	TABLE	ERD
STVATTR	TABLE	ERD
STVBLCK	TABLE	ERD
STVBLDG	TABLE	ERD
STVCAMP	TABLE	ERD
STVCLAS	TABLE	ERD
STVCOLL	TABLE	ERD
STVCOMT	TABLE	ERD
STVDEGC	TABLE	ERD
STVDEPT	TABLE	ERD
STVDIVS	TABLE	ERD
STVEVAL	TABLE	ERD
STVFTYP	TABLE	ERD
STVGMOD	TABLE	ERD
STVLEVL	TABLE	ERD
STVMAJR	TABLE	ERD
STVPTRM	TABLE	ERD
STVRDEF	TABLE	ERD
STVRSTS	TABLE	ERD
STVSAPR	TABLE	ERD
STVSCCD	TABLE	ERD
STVSCHD	TABLE	ERD
STVSESS	TABLE	ERD
STVSSTS	TABLE	ERD
STVSUBJ	TABLE	ERD
STVTESC	TABLE	ERD
STVTOPS	TABLE	ERD
TBBDETC	TABLE	ERD

Comments

Model View

Table GEBFUNC

Schema Name GENERAL
Label GEBFUNC
Server name S4B70
Creation Date 09/29/2003 12:04:32:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
GEBFUNC_EVNT_CRN	GEBFUNC_EVNT_CRN	VARCHAR2(5)	No	*
GEBFUNC_FUNC_CODE	GEBFUNC_FUNC_CODE	VARCHAR2(12)	No	*	*
GEBFUNC_ACTIVITY_DATE	GEBFUNC_ACTIVITY_DATE	DATE	No
GEBFUNC_ETYP_CODE	GEBFUNC_ETYP_CODE	VARCHAR2(4)	No		*
GEBFUNC_FSTA_CODE	GEBFUNC_FSTA_CODE	VARCHAR2(1)	No		*
GEBFUNC_PURP_CODE	GEBFUNC_PURP_CODE	VARCHAR2(10)	Yes		*
GEBFUNC_PURP_DESC	GEBFUNC_PURP_DESC	VARCHAR2(60)	Yes
GEBFUNC_EMPH_CODE	GEBFUNC_EMPH_CODE	VARCHAR2(10)	Yes		*
GEBFUNC_INVITATION_DATE	GEBFUNC_INVITATION_DATE	DATE	Yes
GEBFUNC_LETR_CODE	GEBFUNC_LETR_CODE	VARCHAR2(15)	Yes		*
GEBFUNC_RSVP_CONFIRM_DATE	GEBFUNC_RSVP_CONFIRM_DATE	DATE	Yes
GEBFUNC_SPNSR_ORGN_PIDM	GEBFUNC_SPNSR_ORGN_PIDM	NUMBER(8,0)	Yes
GEBFUNC_COMMITTEE_NAME	GEBFUNC_COMMITTEE_NAME	VARCHAR2(60)	Yes
GEBFUNC_PLAN_ATTEND	GEBFUNC_PLAN_ATTEND	NUMBER(7,0)	Yes
GEBFUNC_BRK_EVEN_ATTEND	GEBFUNC_BRK_EVEN_ATTEND	NUMBER(7,0)	Yes
GEBFUNC_LOCATION	GEBFUNC_LOCATION	VARCHAR2(60)	Yes
GEBFUNC_LOCATION_DATE	GEBFUNC_LOCATION_DATE	DATE	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GEBFUNC_LETR_CODE	GTVLETR_CODE	GTVLETR
GEBFUNC_ETYP_CODE	STVETYP_CODE	STVETYP
GEBFUNC_EMPH_CODE	GTVEMPH_CODE	GTVEMPH
GEBFUNC_FSTA_CODE	GTVFSTA_CODE	GTVFSTA
GEBFUNC_PURP_CODE	GTVPURP_CODE	GTVPURP
GEBFUNC_FUNC_CODE	GTVFUNC_CODE	GTVFUNC

Index

Index Name	Index Type	Column Name
PK_GEBFUNC	Unique	GEBFUNC_EVNT_CRN
PK_GEBFUNC	Unique	GEBFUNC_FUNC_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GEBFUNC	SYNONYM	S4B70.PUBLIC	Rely on ()
GERATTD	TABLE	S4B70."GENERAL"	Refer( No Action )
GERFCOM	TABLE	S4B70."GENERAL"	Refer( No Action )
GERFCON	TABLE	S4B70."GENERAL"	Refer( No Action )
GERFCOR	TABLE	S4B70."GENERAL"	Refer( No Action )
GERFEXP	TABLE	S4B70."GENERAL"	Refer( No Action )
GERFFEE	TABLE	S4B70."GENERAL"	Refer( No Action )
GERFREV	TABLE	S4B70."GENERAL"	Refer( No Action )
GERMENU	TABLE	S4B70."GENERAL"	Refer( No Action )
GERPART	TABLE	S4B70."GENERAL"	Refer( No Action )
GERTASK	TABLE	S4B70."GENERAL"	Refer( No Action )
SPRIDEN	TABLE	S4B70.SATURN	Join
SSRMEET	TABLE	S4B70.SATURN	Join
AG_EVENT	VIEW	S4B70.BANINST1	Use(select )
GEVEVN2	VIEW	S4B70.BANINST1	Use(select )
KEY-EDIT	Forms Trigger	BANNER7_FORMS.GEAPART.GERPART.PARTICIPANT_ID	Use(select )
KEY-EDIT	Forms Trigger	BANNER7_FORMS_10G.GEAPART.GERPART.PARTICIPANT_ID	Use(select )
KEY-HELP	Forms Trigger	BANNER7_FORMS.GEAPART.GERPART.PARTICIPANT_ID	Use(select )
KEY-HELP	Forms Trigger	BANNER7_FORMS_10G.GEAPART.GERPART.PARTICIPANT_ID	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.GEAFUNC.GEBFUNC.GEBFUNC_FUNC_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.GEAFCOM.KEY_BLOCK.FUNCTION	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.GEAATTD.KEY_BLOCK.FUNCTION	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.GEATASK.KEY_BLOCK.FUNCTION	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.GEATASK.KEY_BLOCK.FUNCTION	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.GEAFCOM.KEY_BLOCK.FUNCTION	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.GEAPART.KEY_BLOCK.FUNCTION	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.GEAPART.KEY_BLOCK.FUNCTION	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.GEAFUNC.GEBFUNC.GEBFUNC_FUNC_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.GEAATTD.KEY_BLOCK.FUNCTION	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS.GEAATID.GERATTD.GERATTD_FUNC_CODE	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS.GEAATID.REGISTRATION_BLOCK.GERATTD_FUNC_CODE	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS_10G.GEIATTD.ATTENDEE_INQUIRY.QUERY_FUNCTION	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS_10G.GEAATID.REGISTRATION_BLOCK.GERATTD_FUNC_CODE	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS_10G.GEAATID.GERATTD.GERATTD_FUNC_CODE	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS.GEIATTD.ATTENDEE_INQUIRY.QUERY_FUNCTION	Use(select )
CHECK_KEYS	Forms Trigger	BANNER7_FORMS.GEAATTD	Use(select )
CHECK_KEYS	Forms Trigger	BANNER7_FORMS.GEAFCOM	Use(select )
CHECK_KEYS	Forms Trigger	BANNER7_FORMS_10G.GEAFCOM	Use(select )
CHECK_KEYS	Forms Trigger	BANNER7_FORMS_10G.GEAATTD	Use(select )
CHECK_KEYS	Forms Trigger	BANNER7_FORMS_10G.GEATASK	Use(select )
CHECK_KEYS	Forms Trigger	BANNER7_FORMS.GEATASK	Use(select )
GET_LETR_INFO	Forms Trigger	BANNER7_FORMS.GEAATID.GERATTD	Use(select )
GET_LETR_INFO	Forms Trigger	BANNER7_FORMS.GEAATTD.GERATTD	Use(select )
GET_LETR_INFO	Forms Trigger	BANNER7_FORMS_10G.GEAATTD.GERATTD	Use(select )
GET_LETR_INFO	Forms Trigger	BANNER7_FORMS_10G.GEAATID.GERATTD	Use(select )
INSERT_GEBFUNC	Forms Trigger	BANNER7_FORMS.GEAFUNC.SSRMEET	Use(insert )
INSERT_GEBFUNC	Forms Trigger	BANNER7_FORMS.SLAEVNT.SSRMEET	Use(insert,select )
INSERT_GEBFUNC	Forms Trigger	BANNER7_FORMS_10G.GEAFUNC.SSRMEET	Use(insert )
INSERT_GEBFUNC	Forms Trigger	BANNER7_FORMS_10G.SLAEVNT.SSRMEET	Use(insert,select )
POST-QUERY	Forms Trigger	BANNER7_FORMS.GEIFUNC.SSRMEET	Use(select )
POST-QUERY	Forms Trigger	BANNER7_FORMS_10G.GEIFUNC.SSRMEET	Use(select )
PRE-DELETE	Forms Trigger	BANNER7_FORMS.SLAEVNT.SLBEVNT	Use(select )
PRE-DELETE	Forms Trigger	BANNER7_FORMS_10G.SLAEVNT.SLBEVNT	Use(select )
UT_SETUP	Package procedure	S4B70.BANINST1.UT_GB_CLASSTIMES	Use(insert,select )
SELECT_GEBFUNC	Forms Sub Procedure	BANNER7_FORMS.GOQRPLS.G$_GOQOLIB_FUNC_INFO_BLOCK	Rely on () Use(select )
SELECT_GEBFUNC	Forms Sub Procedure	BANNER7_FORMS_10G.GOQRPLS.G$_GOQOLIB_FUNC_INFO_BLOCK	Rely on () Use(select )
GEBFUNC	Forms DataBlock	BANNER7_FORMS.GEAFUNC	Rely on () Use(insert,update,delete,select )
GEBFUNC	Forms DataBlock	BANNER7_FORMS_10G.GEAFUNC	Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GEBFUNC	INDEX	S4B70."GENERAL"	Rely on ()
GTVEMPH	TABLE	S4B70."GENERAL"	Refer( No Action )
GTVFSTA	TABLE	S4B70."GENERAL"	Refer( No Action )
GTVFUNC	TABLE	S4B70."GENERAL"	Refer( No Action )
GTVLETR	TABLE	S4B70."GENERAL"	Refer( No Action )
GTVPURP	TABLE	S4B70."GENERAL"	Refer( No Action )
STVETYP	TABLE	S4B70.SATURN	Refer( No Action )

Comments

Source Code Comments

Function Header Table

Columns Comments for GEBFUNC_EVNT_CRN (1)

Source Code Comments

Event associated with the function.

Columns Comments for GEBFUNC_FUNC_CODE (2)

Source Code Comments

Code for the Function.

Columns Comments for GEBFUNC_ACTIVITY_DATE (3)

Source Code Comments

Date on which the Function was added or last changed.

Columns Comments for GEBFUNC_ETYP_CODE (4)

Source Code Comments

Function Type Code.

Columns Comments for GEBFUNC_FSTA_CODE (5)

Source Code Comments

Function Status Code.

Columns Comments for GEBFUNC_PURP_CODE (6)

Source Code Comments

Purpose Code for the Function.

Columns Comments for GEBFUNC_PURP_DESC (7)

Source Code Comments

Purpose Code Description for the Function.

Columns Comments for GEBFUNC_EMPH_CODE (8)

Source Code Comments

Emphasis Code for the Function.

Columns Comments for GEBFUNC_INVITATION_DATE (9)

Source Code Comments

Date of the Invitations to the Function.

Columns Comments for GEBFUNC_LETR_CODE (10)

Source Code Comments

Letter Code of the letter accompanying the invitation.

Columns Comments for GEBFUNC_RSVP_CONFIRM_DATE (11)

Source Code Comments

Latest date the RSVP should be received.

Columns Comments for GEBFUNC_SPNSR_ORGN_PIDM (12)

Source Code Comments

PIDM of the Sponsoring Organization of the Function.

Columns Comments for GEBFUNC_COMMITTEE_NAME (13)

Source Code Comments

Name of the Committee associated with the Function.

Columns Comments for GEBFUNC_PLAN_ATTEND (14)

Source Code Comments

Planned Attendance number.

Columns Comments for GEBFUNC_BRK_EVEN_ATTEND (15)

Source Code Comments

attendance required for the Function to break even.

Columns Comments for GEBFUNC_LOCATION (16)

Source Code Comments

Location of the Function if the Function is not associated with an Event.

Columns Comments for GEBFUNC_LOCATION_DATE (17)

Source Code Comments

Date of the Function if the Function is not associated with an Event.

Table GTVDUNT

Schema Name GENERAL
Label GTVDUNT
Server name S4B70
Creation Date 09/29/2003 12:04:34:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
GTVDUNT_CODE	GTVDUNT_CODE	VARCHAR2(4)	No	*
GTVDUNT_DESC	GTVDUNT_DESC	VARCHAR2(30)	No
GTVDUNT_NUMBER_OF_DAYS	GTVDUNT_NUMBER_OF_DAYS	NUMBER(7,2)	No
GTVDUNT_ACTIVITY_DATE	GTVDUNT_ACTIVITY_DATE	DATE	No
GTVDUNT_USER_ID	GTVDUNT_USER_ID	VARCHAR2(30)	No
GTVDUNT_VR_MSG_NO	GTVDUNT_VR_MSG_NO	NUMBER(6,0)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GTVDUNT	Unique	GTVDUNT_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
selmacro	C/C++ Function	[F:\BANNER\C\SCRBULT.PC]	Use(select )
GTVDUNT	SYNONYM	S4B70.PUBLIC	Rely on ()
SCBCRSE	TABLE	S4B70.SATURN	Refer( No Action )
SFRAREG	TABLE	S4B70.SATURN	Refer( No Action )
SFTREGS	TABLE	S4B70.SATURN	Refer( No Action )
SSBSECT	TABLE	S4B70.SATURN	Refer( No Action )
GET_PCT_DUR_COMPLETE	Forms Trigger	BANNER7_FORMS.SFAREGS.SFTREGS.SFTREGS_RSTS_CODE	Use(select )
GET_PCT_DUR_COMPLETE	Forms Trigger	BANNER7_FORMS_10G.SFAREGS.SFTREGS.SFTREGS_RSTS_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.SCACRSE.SCBCRSE.SCBCRSE_DUNT_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.SSASECT.SSBSECT.SSBSECT_DUNT_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.SCACRSE.SCBCRSE.SCBCRSE_DUNT_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.SSASECT.SSBSECT.SSBSECT_DUNT_CODE	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS.GTVDUNT.GTVDUNT.GTVDUNT_CODE	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS_10G.GTVDUNT.GTVDUNT.GTVDUNT_CODE	Use(select )
CALC_OLR_MEET_END	Forms Trigger	BANNER7_FORMS.SSASECT	Rely on () Use(select )
CALC_OLR_MEET_END	Forms Trigger	BANNER7_FORMS_10G.SSASECT	Rely on () Use(select )
GTVDUNT_RG	Forms Record Group	BANNER7_FORMS.GOQOLIB	Use(select )
GTVDUNT_RG	Forms Record Group	BANNER7_FORMS.SFARHST	Use(select )
GTVDUNT_RG	Forms Record Group	BANNER7_FORMS.SCACRSE	Use(select )
GTVDUNT_RG	Forms Record Group	BANNER7_FORMS_10G.GOQOLIB	Use(select )
GTVDUNT_RG	Forms Record Group	BANNER7_FORMS_10G.SSASECT	Use(select )
GTVDUNT_RG	Forms Record Group	BANNER7_FORMS_10G.SSASECQ	Use(select )
GTVDUNT_RG	Forms Record Group	BANNER7_FORMS_10G.SFARHST	Use(select )
GTVDUNT_RG	Forms Record Group	BANNER7_FORMS_10G.SCACRSE	Use(select )
GTVDUNT_RG	Forms Record Group	BANNER7_FORMS_10G.ROASECT	Use(select )
GTVDUNT_RG	Forms Record Group	BANNER7_FORMS.SSASECT	Use(select )
GTVDUNT_RG	Forms Record Group	BANNER7_FORMS.SSASECQ	Use(select )
GTVDUNT_RG	Forms Record Group	BANNER7_FORMS.ROASECT	Use(select )
RORDUNT_RG	Forms Record Group	BANNER7_FORMS.ROASECT	Use(select )
RORDUNT_RG	Forms Record Group	BANNER7_FORMS_10G.ROASECT	Use(select )
CHECK_COMMIT	Forms Trigger	BANNER7_FORMS.SSASECT.SSBSECT	Rely on () Use(select )
CHECK_COMMIT	Forms Trigger	BANNER7_FORMS_10G.SSASECT.SSBSECT	Rely on () Use(select )
GETCRN	Forms Trigger	BANNER7_FORMS.SFAREGS.SFTREGS	Use(select )
GETCRN	Forms Trigger	BANNER7_FORMS_10G.SFAREGS.SFTREGS	Use(select )
KEY-COMMIT	Forms Trigger	BANNER7_FORMS.SSASECT.SSBSECT	Rely on () Use(select )
KEY-COMMIT	Forms Trigger	BANNER7_FORMS_10G.SSASECT.SSBSECT	Rely on () Use(select )
LOAD_BLOCK	Forms Trigger	BANNER7_FORMS.SFAREGS.SFTREGS	Use(select )
LOAD_BLOCK	Forms Trigger	BANNER7_FORMS_10G.SFAREGS.SFTREGS	Use(select )
POST-QUERY	Forms Trigger	BANNER7_FORMS.SFARHST.SFRAREG	Use(select )
POST-QUERY	Forms Trigger	BANNER7_FORMS_10G.SFARHST.SFRAREG	Use(select )
POST-QUERY	Forms Trigger	BANNER7_FORMS_10G.SFAREGS.SFTREGS	Use(select )
POST-QUERY	Forms Trigger	BANNER7_FORMS.SFAREGS.SFTREGS	Use(select )
PRE-INSERT	Forms Trigger	BANNER7_FORMS.GTVDUNT.GTVDUNT	Use(select )
PRE-INSERT	Forms Trigger	BANNER7_FORMS_10G.GTVDUNT.GTVDUNT	Use(select )
RECALCULATE_DATE_AMOUNT	Forms Trigger	BANNER7_FORMS.SFARHST.SFRAREG	Rely on () Use(select )
RECALCULATE_DATE_AMOUNT	Forms Trigger	BANNER7_FORMS_10G.SFARHST.SFRAREG	Rely on () Use(select )
SET_SFRAREG_DFLT_CONTINUE	Forms Trigger	BANNER7_FORMS.SFARHST.SFRAREG	Rely on () Use(select )
SET_SFRAREG_DFLT_CONTINUE	Forms Trigger	BANNER7_FORMS_10G.SFARHST.SFRAREG	Rely on () Use(select )
SET_SFRAREG_DFLT_VALUES	Forms Trigger	BANNER7_FORMS.SFARHST.SFRAREG	Rely on ()
SET_SFRAREG_DFLT_VALUES	Forms Trigger	BANNER7_FORMS_10G.SFARHST.SFRAREG	Rely on ()
VALIDATE_CRN	Forms Trigger	BANNER7_FORMS.SSARULE.KEY_BLOCK	Use(select )
VALIDATE_CRN	Forms Trigger	BANNER7_FORMS_10G.SSARULE.KEY_BLOCK	Use(select )
GTVDUNT_ROW_BY_CODE_C	Package cursor	S4B70.BANINST1.VRSKFOLR	Rely on ()
GTVDUNT_ROW_BY_CODE_C	Package cursor	S4B70.BANINST1.VRSKFOLR	Use(select )
GTVDUNT_C	Package cursor	S4B70.BANINST1.BWCKSCHD	Use(select )
GTVDUNT_C	Package cursor	S4B70.BANINST1.ICSSKCOM	Use(select )
F_GET_OPEN_LEARNING_END_DATE	Package function	S4B70.BANINST1.ICSSKCOM	Rely on ()
P_FACCWCRNHDR	Package procedure	S4B70.BANINST1.BWLKFCWL	Rely on ()
P_FACCWCRNHDR	Package procedure	S4B70.BANINST1.BWLKFCWL	Use(select )
P_FACDAYSCHED	Package procedure	S4B70.BANINST1.BWLKIFAC	Use(select )
P_FACSCHED	Package procedure	S4B70.BANINST1.BWLKIFAC	Rely on ()
P_FACSCHED	Package procedure	S4B70.BANINST1.BWLKIFAC	Use(select )
P_FAC_SYLLABUS	Package procedure	S4B70.BANINST1.BWLKSYBS	Use(select )
P_LISTCRSE	Package procedure	S4B70.BANINST1.BWCKGENS	Rely on ()
P_LISTCRSE	Package procedure	S4B70.BANINST1.BWCKGENS	Use(select )
P_LOAD_TEMPLATE	Package procedure	S4B70.BANINST1.BWCKWEEK	Use(select )
P_SEARCH	Package procedure	S4B70.BANINST1.BWCKGENS	Rely on ()
P_SEARCH	Package procedure	S4B70.BANINST1.BWCKGENS	Rely on () Use(select )
P_UPDATE	Package procedure	S4B70.BANINST1.GB_SECTION	Rely on ()
P_UPDATE	Package procedure	S4B70.BANINST1.SB_SECTION	Rely on ()
P_VR_ADD_CLASS	Package procedure	S4B70.BANINST1.VRSKFREG	Rely on ()
P_VR_ADD_CLASS	Package procedure	S4B70.BANINST1.VRSKFREG	Rely on ()
P_VR_CREDIT_HOURS_OPT	Package procedure	S4B70.BANINST1.VRSKFREG	Rely on ()
P_VR_CREDIT_HOURS_OPT	Package procedure	S4B70.BANINST1.VRSKFREG	Rely on ()
P_VR_GRADE_MODE_OPT	Package procedure	S4B70.BANINST1.VRSKFREG	Rely on ()
P_VR_GRADE_MODE_OPT	Package procedure	S4B70.BANINST1.VRSKFREG	Rely on ()
P_VR_START_DATE_OPT	Package procedure	S4B70.BANINST1.VRSKFOLR	Rely on ()
P_VR_START_DATE_OPT	Package procedure	S4B70.BANINST1.VRSKFOLR	Rely on ()
UT_SETUP	Package procedure	S4B70.BANINST1.UT_SB_FACASSIGNMENT	Use(insert,select )
UT_SETUP	Package procedure	S4B70.BANINST1.UT_SB_COURSE	Use(insert,select )
UT_SETUP	Package procedure	S4B70.BANINST1.UT_GB_SECTION	Use(insert,select )
UT_SETUP	Package procedure	S4B70.BANINST1.UT_GB_CLASSTIMES	Use(insert,select )
UT_SETUP	Package procedure	S4B70.BANINST1.UT_SB_SECTION	Use(insert,select )
UT_TEARDOWN	Package procedure	S4B70.BANINST1.UT_GB_SECTION	Use(delete )
GTVDUNT_C	Package cursor	S4B70.BANINST1.GB_GTVDUNT	Rely on ()
GTVDUNT_C	Package cursor	S4B70.BANINST1.GB_GTVDUNT	Rely on () Use(select )
F_CALCULATE_DURATION_COMPLETE	Package function	S4B70.BANINST1.SFKOLRL	Use(select )
F_CODE_EXISTS	Package function	S4B70.BANINST1.GB_GTVDUNT	Rely on ()
F_CODE_EXISTS	Package function	S4B70.BANINST1.GB_GTVDUNT	Rely on ()
F_GET_DESCRIPTION	Package function	S4B70.BANINST1.GB_GTVDUNT	Rely on ()
F_GET_DESCRIPTION	Package function	S4B70.BANINST1.GB_GTVDUNT	Rely on ()
F_GET_FACDTRANGE	Package function	S4B70.BANINST1.BWLCBREF	Use(select )
F_GET_FACUNSCH	Package function	S4B70.BANINST1.BWLCBREF	Use(select )
F_GET_OPEN_LEARNING_END_DATE	Package function	S4B70.BANINST1.ICSSKFUN	Rely on ()
F_OLR_DATE	Package function	S4B70.BANINST1.SFKFUNC	Rely on ()
F_OLR_DATE	Package function	S4B70.BANINST1.BWCKLIBS	Use(select )
GTVDUNT	Forms DataBlock	BANNER7_FORMS.GTVDUNT	Rely on () Use(insert,update,delete,select )
GTVDUNT	Forms DataBlock	BANNER7_FORMS_10G.GTVDUNT	Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GTVDUNT	INDEX	S4B70."GENERAL"	Rely on ()

Comments

Source Code Comments

Duration Unit Code Validation Table

Columns Comments for GTVDUNT_CODE (1)

Source Code Comments

Duration Unit Code: The Duration Unit Code

Columns Comments for GTVDUNT_DESC (2)

Source Code Comments

Description: Description of the duration unit code

Columns Comments for GTVDUNT_NUMBER_OF_DAYS (3)

Source Code Comments

Number of Days per duration unit: Represents the number of days that one duration unit would equate to (ie 1 week equals 7 days)

Columns Comments for GTVDUNT_ACTIVITY_DATE (4)

Source Code Comments

Activity Date: Date this record entered or last updated

Columns Comments for GTVDUNT_USER_ID (5)

Source Code Comments

User ID: The username of the person who entered or last updated this record

Columns Comments for GTVDUNT_VR_MSG_NO (6)

Source Code Comments

Voice Response Message Number

Table GTVINSM

Schema Name GENERAL
Label GTVINSM
Server name S4B70
Creation Date 09/29/2003 12:04:35:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK