Model SSBSECT

Model Label : Banner SSBSECT ERD
Path : Default Folder/B70/Common/SSBSECT

List of Objects

Object Name	Object Type	Layer Name
GTVDUNT	TABLE	ERD
GTVINSM	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
SSBOVRR	TABLE	ERD
SSBSECT	TABLE	Tables
SSRATTR	TABLE	ERD
SSRBLCK	TABLE	ERD
SSRCORQ	TABLE	ERD
SSRFEES	TABLE	ERD
SSRLINK	TABLE	ERD
SSRMEET	TABLE	ERD
SSRRCLS	TABLE	ERD
SSRRCMP	TABLE	ERD
SSRRCOL	TABLE	ERD
SSRRESV	TABLE	ERD
SSRRLVL	TABLE	ERD
SSRRMAJ	TABLE	ERD
SSRRTST	TABLE	ERD
SSRSCCD	TABLE	ERD
SSRSPRT	TABLE	ERD
SSRSRDF	TABLE	ERD
SSRTEXT	TABLE	ERD
SSRXLST	TABLE	ERD
STVACCL	TABLE	ERD
STVACCT	TABLE	ERD
STVCAMP	TABLE	ERD
STVGMOD	TABLE	ERD
STVPTRM	TABLE	ERD
STVSAPR	TABLE	ERD
STVSCHD	TABLE	ERD
STVSESS	TABLE	ERD
STVSSTS	TABLE	ERD
STVSUBJ	TABLE	ERD
STVTERM	TABLE	ERD

Comments

Model View

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
GTVINSM_CODE	GTVINSM_CODE	VARCHAR2(5)	No	*
GTVINSM_DESC	GTVINSM_DESC	VARCHAR2(30)	No
GTVINSM_ACTIVITY_DATE	GTVINSM_ACTIVITY_DATE	DATE	No
GTVINSM_USER_ID	GTVINSM_USER_ID	VARCHAR2(30)	No
GTVINSM_VR_MSG_NO	GTVINSM_VR_MSG_NO	NUMBER(6,0)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GTVINSM	Unique	GTVINSM_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
selinstrmethod	C/C++ Function	[F:\BANNER\C\SFRSCHD.PC]	Use(select )
selinstrmethod	C/C++ Function	[F:\BANNER\C\SSPSCHD.PC]	Use(select )
selinstrmethod	C/C++ Function	[F:\BANNER\C\SSRTALY.PC]	Use(select )
selinstrmethod	C/C++ Function	[F:\BANNER\C\SSRSECT.PC]	Use(select )
val_im_code	C/C++ Function	[F:\BANNER\C\SFRSCHD.PC]	Use(select )
val_im_code	C/C++ Function	[F:\BANNER\C\SFRSLST.PC]	Use(select )
val_im_code	C/C++ Function	[F:\BANNER\C\SSRSECT.PC]	Use(select )
val_im_code	C/C++ Function	[F:\BANNER\C\SSRTALY.PC]	Use(select )
validate	C/C++ Function	[F:\BANNER\C\SFPAGRD.PC]	Use(select )
GTVINSM	SYNONYM	S4B70.PUBLIC	Rely on ()
SCRSCHD	TABLE	S4B70.SATURN	Refer( No Action )
SFRRGFE	TABLE	S4B70.SATURN	Refer( No Action )
SOBODTE	TABLE	S4B70.SATURN	Refer( No Action )
SOREXTN	TABLE	S4B70.SATURN	Refer( No Action )
SORRFND	TABLE	S4B70.SATURN	Refer( No Action )
SORRSTS	TABLE	S4B70.SATURN	Refer( No Action )
SSBDFEE	TABLE	S4B70.SATURN	Refer( No Action )
SSBSECT	TABLE	S4B70.SATURN	Refer( No Action )
STVSCHD	TABLE	S4B70.SATURN	Refer( No Action )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.SCACRSE.SCRSCHD.SCRSCHD_INSM_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.SOAORUL.SOBODTE.SOBODTE_INSM_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.SSADFEE.SSBDFEE.SSBDFEE_INSM_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.SSASECT.SSBSECT.SSBSECT_INSM_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.SSADFEE.SSBDFEE.SSBDFEE_INSM_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.SOAORUL.SOBODTE.SOBODTE_INSM_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.SCACRSE.SCRSCHD.SCRSCHD_INSM_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.SSASECT.SSBSECT.SSBSECT_INSM_CODE	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS.GTVINSM.GTVINSM.GTVINSM_CODE	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS_10G.GTVINSM.GTVINSM.GTVINSM_CODE	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS_10G.SFARGFE.SFRRGFE.SFRRGFE_INSM_CODE	Rely on ()
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS.SFARGFE.SFRRGFE.SFRRGFE_INSM_CODE	Rely on ()
GET_SCHD_INSM	Forms Trigger	BANNER7_FORMS.SSASYLB	Use(select )
GET_SCHD_INSM	Forms Trigger	BANNER7_FORMS_10G.SSASYLB	Use(select )
GTVINSM_RG	Forms Record Group	BANNER7_FORMS.GOQOLIB	Use(select )
GTVINSM_RG	Forms Record Group	BANNER7_FORMS.SCACRSE	Use(select )
GTVINSM_RG	Forms Record Group	BANNER7_FORMS.SFARGFE	Use(select )
GTVINSM_RG	Forms Record Group	BANNER7_FORMS.ROASECT	Use(select )
GTVINSM_RG	Forms Record Group	BANNER7_FORMS.SOAORUL	Use(select )
GTVINSM_RG	Forms Record Group	BANNER7_FORMS_10G.STVSCHD	Use(select )
GTVINSM_RG	Forms Record Group	BANNER7_FORMS_10G.GOQOLIB	Use(select )
GTVINSM_RG	Forms Record Group	BANNER7_FORMS.STVSCHD	Use(select )
GTVINSM_RG	Forms Record Group	BANNER7_FORMS_10G.SSADFEE	Use(select )
GTVINSM_RG	Forms Record Group	BANNER7_FORMS_10G.SSASECT	Use(select )
GTVINSM_RG	Forms Record Group	BANNER7_FORMS_10G.SSASECQ	Use(select )
GTVINSM_RG	Forms Record Group	BANNER7_FORMS_10G.SOAORUL	Use(select )
GTVINSM_RG	Forms Record Group	BANNER7_FORMS_10G.SFARGFE	Use(select )
GTVINSM_RG	Forms Record Group	BANNER7_FORMS_10G.SCACRSE	Use(select )
GTVINSM_RG	Forms Record Group	BANNER7_FORMS_10G.ROASECT	Use(select )
GTVINSM_RG	Forms Record Group	BANNER7_FORMS.SSADFEE	Use(select )
GTVINSM_RG	Forms Record Group	BANNER7_FORMS.SSASECT	Use(select )
GTVINSM_RG	Forms Record Group	BANNER7_FORMS.SSASECQ	Use(select )
RORINSM_RG	Forms Record Group	BANNER7_FORMS.ROASECT	Use(select )
RORINSM_RG	Forms Record Group	BANNER7_FORMS_10G.ROASECT	Use(select )
PRE-INSERT	Forms Trigger	BANNER7_FORMS.GTVINSM.GTVINSM	Use(select )
PRE-INSERT	Forms Trigger	BANNER7_FORMS_10G.GTVINSM.GTVINSM	Use(select )
CHK_INSM_CODE	Forms Function	BANNER7_FORMS.STVSCHD	Use(select )
CHK_INSM_CODE	Forms Function	BANNER7_FORMS_10G.STVSCHD	Use(select )
GTVINSM_ROW_BY_CODE_C	Package cursor	S4B70.BANINST1.VRSKFOLR	Rely on ()
GTVINSM_ROW_BY_CODE_C	Package cursor	S4B70.BANINST1.VRSKFOLR	Use(select )
CRN_SSBSECT_INSM_CODE	Package variable	S4B70.BANINST1.SFKFEES	Rely on ()
T_INSM_CODE	Package variable	S4B70.BANINST1.SFKFEES	Rely on ()
GTVINSM_C	Package cursor	S4B70.BANINST1.BWCKSCHD	Use(select )
REGCRSEC	Package cursor	S4B70.BANINST1.BWCKGENS	Use(select )
P_APPLYRULES	Package procedure	S4B70.BANINST1.SFKFEES	Rely on ()
P_CREATE_SECTION_DFT_RULES	Package procedure	S4B70.BANINST1.SSKOLRP	Rely on ()
P_DISP_ACTIVE_REGS	Package procedure	S4B70.BANINST1.BWCKGENS	Use(select )
P_FAC_SYLLABUS	Package procedure	S4B70.BANINST1.BWLKSYBS	Use(select )
P_GET_REGCRSEC	Package procedure	S4B70.BANINST1.BWSCBREF	Use(select )
P_LISTCRSE	Package procedure	S4B70.BANINST1.BWCKGENS	Use(select )
P_PROCESSCOURSE	Package procedure	S4B70.BANINST1.SFKFEES	Rely on ()
P_VR_CRN_LIST	Package procedure	S4B70.BANINST1.VRSKFOLR	Rely on ()
P_VR_CRN_LIST	Package procedure	S4B70.BANINST1.VRSKFOLR	Rely on ()
P_VR_CRN_LIST_MULTI_OPT	Package procedure	S4B70.BANINST1.VRSKFOLR	Rely on ()
P_VR_CRN_LIST_MULTI_OPT	Package procedure	S4B70.BANINST1.VRSKFOLR	Rely on ()
P_VR_LIST_CLASSES	Package procedure	S4B70.BANINST1.VRSKFORG	Rely on ()
P_VR_LIST_CLASSES	Package procedure	S4B70.BANINST1.VRSKFORG	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_CLASSTIMES	Use(insert,select )
UT_SETUP	Package procedure	S4B70.BANINST1.UT_SB_SECTION	Use(insert,select )
UT_SETUP	Package procedure	S4B70.BANINST1.UT_GB_SECTION	Use(insert,select )
UT_TEARDOWN	Package procedure	S4B70.BANINST1.UT_GB_SECTION	Use(delete )
GTVINSM_C	Package cursor	S4B70.BANINST1.GB_GTVINSM	Rely on ()
GTVINSM_C	Package cursor	S4B70.BANINST1.GB_GTVINSM	Rely on () Use(select )
GTVINSM_WDSP_C	Package cursor	S4B70.BANINST1.BWCKLIBS	Rely on () Use(select )
F_CODE_EXISTS	Package function	S4B70.BANINST1.GB_GTVINSM	Rely on ()
F_CODE_EXISTS	Package function	S4B70.BANINST1.GB_GTVINSM	Rely on ()
F_GET_DESCRIPTION	Package function	S4B70.BANINST1.GB_GTVINSM	Rely on ()
F_GET_DESCRIPTION	Package function	S4B70.BANINST1.GB_GTVINSM	Rely on ()
F_GET_GTVINSM_DESC	Package function	S4B70.BANINST1.BWLKASGN	Rely on ()
F_GET_GTVINSM_DESC	Package function	S4B70.BANINST1.BWLKASGN	Use(select )
GTVINSM	Forms DataBlock	BANNER7_FORMS.GTVINSM	Rely on () Use(insert,update,delete,select )
GTVINSM	Forms DataBlock	BANNER7_FORMS_10G.GTVINSM	Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

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

Comments

Source Code Comments

Instructional Method Code Validation Table

Columns Comments for GTVINSM_CODE (1)

Source Code Comments

Instructional Method Code: The Instructional Method Code

Columns Comments for GTVINSM_DESC (2)

Source Code Comments

Description: Description of the instructional method code

Columns Comments for GTVINSM_ACTIVITY_DATE (3)

Source Code Comments

Activity Date: Date this record entered or last updated

Columns Comments for GTVINSM_USER_ID (4)

Source Code Comments

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

Columns Comments for GTVINSM_VR_MSG_NO (5)

Source Code Comments

Voice Response Message Number

Table RORSECT

Schema Name FAISMGR
Label RORSECT
Server name S4B70
Creation Date 09/29/2003 12:14:18:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
RORSECT_TERM_CODE	RORSECT_TERM_CODE	VARCHAR2(6)	No	*
RORSECT_CRN	RORSECT_CRN	VARCHAR2(5)	No	*
RORSECT_ACTIVITY_DATE	RORSECT_ACTIVITY_DATE	DATE	No
RORSECT_USER_ID	RORSECT_USER_ID	VARCHAR2(30)	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_RORSECT	Unique	RORSECT_TERM_CODE
PK_RORSECT	Unique	RORSECT_CRN

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
RORSECT	SYNONYM	S4B70.PUBLIC	Rely on ()
SSBSECT	TABLE	S4B70.SATURN	Join
WHEN-CHECKBOX-CHANGED	Forms Trigger	BANNER7_FORMS_10G.ROASECT.SSBSECT.UNAVAIL_FOR_AID	Use(insert,delete )
WHEN-CHECKBOX-CHANGED	Forms Trigger	BANNER7_FORMS.ROASECT.SSBSECT.UNAVAIL_FOR_AID_OLD	Use(insert,delete )
WHEN-CHECKBOX-CHANGED	Forms Trigger	BANNER7_FORMS.ROASECT.SSBSECT.UNAVAIL_FOR_AID	Use(insert,delete )
WHEN-CHECKBOX-CHANGED	Forms Trigger	BANNER7_FORMS_10G.ROASECT.SSBSECT.UNAVAIL_FOR_AID_OLD	Use(insert,delete )
RCQSUBJ_RG	Forms Record Group	BANNER7_FORMS_10G.ROASECT	Use(select )
RCQSUBJ_RG	Forms Record Group	BANNER7_FORMS.ROASECT	Use(select )
RORCAMP_RG	Forms Record Group	BANNER7_FORMS_10G.ROASECT	Use(select )
RORCAMP_RG	Forms Record Group	BANNER7_FORMS.ROASECT	Use(select )
RORCRN_RG	Forms Record Group	BANNER7_FORMS_10G.ROASECT	Use(select )
RORCRN_RG	Forms Record Group	BANNER7_FORMS.ROASECT	Use(select )
RORDUNT_RG	Forms Record Group	BANNER7_FORMS_10G.ROASECT	Use(select )
RORDUNT_RG	Forms Record Group	BANNER7_FORMS.ROASECT	Use(select )
RORGMOD_RG	Forms Record Group	BANNER7_FORMS_10G.ROASECT	Use(select )
RORGMOD_RG	Forms Record Group	BANNER7_FORMS.ROASECT	Use(select )
RORINSM_RG	Forms Record Group	BANNER7_FORMS_10G.ROASECT	Use(select )
RORINSM_RG	Forms Record Group	BANNER7_FORMS.ROASECT	Use(select )
RORPRTM_RG	Forms Record Group	BANNER7_FORMS_10G.ROASECT	Use(select )
RORPRTM_RG	Forms Record Group	BANNER7_FORMS.ROASECT	Use(select )
RORSCHD_RG	Forms Record Group	BANNER7_FORMS_10G.ROASECT	Use(select )
RORSCHD_RG	Forms Record Group	BANNER7_FORMS.ROASECT	Use(select )
RORSECT_RG	Forms Record Group	BANNER7_FORMS_10G.ROASECT	Use(select )
RORSECT_RG	Forms Record Group	BANNER7_FORMS.ROASECT	Use(select )
RORSSTS_RG	Forms Record Group	BANNER7_FORMS_10G.ROASECT	Use(select )
RORSSTS_RG	Forms Record Group	BANNER7_FORMS.ROASECT	Use(select )
RORSUBJC_RG	Forms Record Group	BANNER7_FORMS_10G.ROASECT	Use(select )
RORSUBJC_RG	Forms Record Group	BANNER7_FORMS.ROASECT	Use(select )
RORSUBJ_RG	Forms Record Group	BANNER7_FORMS_10G.ROASECT	Use(select )
RORSUBJ_RG	Forms Record Group	BANNER7_FORMS.ROASECT	Use(select )
POST-QUERY	Forms Trigger	BANNER7_FORMS_10G.ROASECT.SSBSECT	Use(select )
POST-QUERY	Forms Trigger	BANNER7_FORMS.ROASECT.SSBSECT	Use(select )
RCRN_VALIDATE	Forms Trigger	BANNER7_FORMS_10G.ROASECT.RORSECT	Use(select )
RCRN_VALIDATE	Forms Trigger	BANNER7_FORMS.ROASECT.RORSECT	Use(select )
F_GET_EXCLUDE_SECTION_IND	Package function	S4B70.BANINST1.ROKVIEW	Use(select )
RORSECT	Forms DataBlock	BANNER7_FORMS_10G.ROASECT	Rely on () Use(insert,delete,select )
RORSECT	Forms DataBlock	BANNER7_FORMS.ROASECT	Rely on () Use(insert,delete,select )

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_RORSECT	INDEX	S4B70.FAISMGR	Rely on ()

Comments

Source Code Comments

Course Sections Unavailable for Aid Table

Columns Comments for RORSECT_TERM_CODE (1)

Source Code Comments

TERM CODE: The term code associated with the course section to be excluded.

Columns Comments for RORSECT_CRN (2)

Source Code Comments

CRN: The Course Reference Number (CRN) assigned to the course section to be excluded.

Columns Comments for RORSECT_ACTIVITY_DATE (3)

Source Code Comments

ACTIVITY DATE: The date the course section to exclude was created.

Columns Comments for RORSECT_USER_ID (4)

Source Code Comments

USER ID: The logon ID of the user who entered or last updated the record in this table.

Table SCBCRKY

Schema Name SATURN
Label SCBCRKY
Server name S4B70
Creation Date 09/09/2004 23:42:30:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SCBCRKY_SUBJ_CODE	SCBCRKY_SUBJ_CODE	VARCHAR2(4)	No	*	*
SCBCRKY_CRSE_NUMB	SCBCRKY_CRSE_NUMB	VARCHAR2(5)	No	*
SCBCRKY_TERM_CODE_START	SCBCRKY_TERM_CODE_START	VARCHAR2(6)	No		*
SCBCRKY_TERM_CODE_END	SCBCRKY_TERM_CODE_END	VARCHAR2(6)	No		*
SCBCRKY_ACTIVITY_DATE	SCBCRKY_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SCBCRKY_SUBJ_CODE	STVSUBJ_CODE	STVSUBJ
SCBCRKY_TERM_CODE_END	STVTERM_CODE	STVTERM
SCBCRKY_TERM_CODE_START	STVTERM_CODE	STVTERM

Index

Index Name	Index Type	Column Name
PK_SCBCRKY	Unique	SCBCRKY_SUBJ_CODE
PK_SCBCRKY	Unique	SCBCRKY_CRSE_NUMB

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
writeCourse	C/C++ Function	[F:\BANNER\C\SCRRFUN.PC]	Use(select )
MAA3	Cobol Paragraph	[F:\banner\cobol].SERCBREC.MAA-MAINLINE-SECT	Use(select )
checkend	C/C++ Function	[F:\BANNER\C\SSRROLL.PC]	Use(select )
selmacro	C/C++ Function	[F:\BANNER\C\SCRBULT.PC]	Use(select )
write_course	C/C++ Function	[F:\BANNER\C\ICGORLDI.PC]	Use(select )
ST_SCBCRKY_AR_LDI	TRIGGER	S4B70.SATURN	Rely on ()
SCBCRSE	TABLE	S4B70.SATURN	Join
SCBSUPP	TABLE	S4B70.SATURN	Refer( No Action )
SCRATTR	TABLE	S4B70.SATURN	Refer( No Action )
SCRCORQ	TABLE	S4B70.SATURN	Refer( No Action )
SCREQIV	TABLE	S4B70.SATURN	Refer( No Action )
SCRFEES	TABLE	S4B70.SATURN	Refer( No Action )
SCRRCAM	TABLE	S4B70.SATURN	Refer( No Action )
SCRRCLS	TABLE	S4B70.SATURN	Refer( No Action )
SCRRCMP	TABLE	S4B70.SATURN	Refer( No Action )
SCRRCOL	TABLE	S4B70.SATURN	Refer( No Action )
SCRRLVL	TABLE	S4B70.SATURN	Refer( No Action )
SCRRMAJ	TABLE	S4B70.SATURN	Refer( No Action )
SCRRTRM