GTVDUNT GTVINSM GTVPARS SCBCDEP SCBCDTL SCBCRKY SCBCRSE SCBDESC SCBSUPP SCRATTR SCRCDTX SCRCORQ SCRCPRT SCRCRDF SCREQIV SCRFEES SCRGMOD SCRLEVL SCRRARE SCRRCAM SCRRCLS SCRRCMP SCRRCOL SCRRDEG SCRRLVL SCRRMAJ SCRRPRG SCRRTRM SCRRTST SCRSBGI SCRSCHD SCRSECT SCRSPRT SCRSRDF SCRSYLN SCRSYLO SCRSYRM SCRSYTR SCRTEXT SHBGSCH SHRTRTK SMRALIB SMRPRLE SSBSECT SSRMEET STVAPRV STVATTR STVCAMP STVCCSL STVCIPC STVCLAS STVCOLL STVCSTA STVCUDA STVCUDB STVCUDC STVCUDD STVCUDE STVCUDF STVDEGC STVDEPT STVDIVS STVFTYP STVGMOD STVLEVL STVMAJR STVOCCS STVPWAV STVRDEF STVREPS STVRTRM STVSBGI STVSCHD STVTESC STVTOPS TBBDETC

Model ERD Catalog


Model Label : ERD for Student Catalog Processing

List of Objects

Object Name Object Type Layer Name
GTVDUNT TABLE ERD
GTVINSM TABLE ERD
GTVPARS TABLE ERD
SCBCDEP TABLE Tables
SCBCDTL TABLE Tables
SCBCRKY TABLE Tables
SCBCRSE TABLE Tables
SCBDESC TABLE Tables
SCBSUPP TABLE Tables
SCRATTR TABLE Tables
SCRCDTX TABLE Tables
SCRCORQ TABLE Tables
SCRCPRT TABLE Tables
SCRCRDF TABLE Tables
SCREQIV TABLE Tables
SCRFEES TABLE Tables
SCRGMOD TABLE Tables
SCRLEVL TABLE Tables
SCRRARE TABLE Tables
SCRRCAM TABLE Tables
SCRRCLS TABLE Tables
SCRRCMP TABLE Tables
SCRRCOL TABLE Tables
SCRRDEG TABLE Tables
SCRRLVL TABLE Tables
SCRRMAJ TABLE Tables
SCRRPRG TABLE Tables
SCRRTRM TABLE Tables
SCRRTST TABLE Tables
SCRSBGI TABLE Tables
SCRSCHD TABLE Tables
SCRSECT TABLE Tables
SCRSPRT TABLE Tables
SCRSRDF TABLE Tables
SCRSYLN TABLE Tables
SCRSYLO TABLE Tables
SCRSYRM TABLE Tables
SCRSYTR TABLE Tables
SCRTEXT TABLE Tables
SHBGSCH TABLE ERD
SHRTRTK TABLE ERD
SMRALIB TABLE ERD
SMRPRLE TABLE ERD
SSBSECT TABLE ERD
SSRMEET TABLE ERD
STVAPRV TABLE ERD
STVATTR TABLE ERD
STVCAMP TABLE ERD
STVCCSL TABLE ERD
STVCIPC TABLE ERD
STVCLAS TABLE ERD
STVCOLL TABLE ERD
STVCSTA TABLE ERD
STVCUDA TABLE ERD
STVCUDB TABLE ERD
STVCUDC TABLE ERD
STVCUDD TABLE ERD
STVCUDE TABLE ERD
STVCUDF TABLE ERD
STVDEGC TABLE ERD
STVDEPT TABLE ERD
STVDIVS TABLE ERD
STVFTYP TABLE ERD
STVGMOD TABLE ERD
STVLEVL TABLE ERD
STVMAJR TABLE ERD
STVOCCS TABLE ERD
STVPWAV TABLE ERD
STVRDEF TABLE ERD
STVREPS TABLE ERD
STVRTRM TABLE ERD
STVSBGI TABLE ERD
STVSCHD TABLE ERD
STVTESC TABLE ERD
STVTOPS TABLE ERD
TBBDETC 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 FK
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
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 GTVPARS

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GTVPARS_CODE GTVPARS_CODE VARCHAR2(7) No *
GTVPARS_DESC GTVPARS_DESC VARCHAR2(30) No
GTVPARS_SCHEDULER_NUMBER GTVPARS_SCHEDULER_NUMBER NUMBER(2,0) No
GTVPARS_USER_ID GTVPARS_USER_ID VARCHAR2(30) No
GTVPARS_ACTIVITY_DATE GTVPARS_ACTIVITY_DATE DATE No
GTVPARS_CAMP_CODE GTVPARS_CAMP_CODE VARCHAR2(3) Yes *

Foreign Key information

Column name is Foreign Key For Column on Table
GTVPARS_CAMP_CODE STVCAMP_CODE STVCAMP

Index

Index Name Index Type Column Name
PK_GTVPARS Unique GTVPARS_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
create_depts C/C++ Function [F:\BANNER\C\SSRSCRM.PC] Use(select )
create_partDatFile C/C++ Function [F:\BANNER\C\SSRSCRM.PC] Use(select )
create_roomsFile C/C++ Function [F:\BANNER\C\SSRSCRM.PC] Use(select )
write_datain C/C++ Function [F:\BANNER\C\SSRSCRM.PC] Use(select )
GTVPARS SYNONYM S4B70.PUBLIC Rely on ()
SCRCPRT TABLE S4B70.SATURN Refer( No Action )
SCRSPRT TABLE S4B70.SATURN Refer( No Action )
SLBBLDG TABLE S4B70.SATURN Refer( No Action )
SLBRDEF TABLE S4B70.SATURN Refer( No Action )
SSRMPRT TABLE S4B70.SATURN Refer( No Action )
SSRSPRT TABLE S4B70.SATURN Refer( No Action )
POST-CHANGE Forms Trigger BANNER7_FORMS.SCACRSE.SCRCPRT.SCRCPRT_PARS_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SCACRSE.SCRCPRT.SCRCPRT_PARS_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SSASECT.SSRSPRT.SSRSPRT_PARS_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SSASECT.SSRMPRT.SSRMPRT_PARS_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SLARDEF.SLBRDEF.SLBRDEF_PARS_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SSASECT.SSRSPRT.SSRSPRT_PARS_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SLABLDG.SLBBLDG.SLBBLDG_PARS_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SSASECT.SSRMPRT.SSRMPRT_PARS_CODE Use(select )
WHEN-BUTTON-PRESSED Forms Trigger BANNER7_FORMS.GTVPARS.BUTTON_CONTROL_BLOCK.SCHEDULER_MAINT_BTN Use(update,select )
WHEN-BUTTON-PRESSED Forms Trigger BANNER7_FORMS_10G.GTVPARS.BUTTON_CONTROL_BLOCK.SCHEDULER_MAINT_BTN Use(update,select )
WHEN-BUTTON-PRESSED Forms Trigger BANNER7_FORMS_10G.STVWSSO.BUTTON_CONTROL_BLOCK.SCHEDULER_MAINT_BTN Use(update,select )
WHEN-BUTTON-PRESSED Forms Trigger BANNER7_FORMS.STVWSSO.BUTTON_CONTROL_BLOCK.SCHEDULER_MAINT_BTN Use(update,select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS.GTVPARS.GTVPARS.GTVPARS_CODE Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS_10G.GTVPARS.GTVPARS.GTVPARS_CODE Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS_10G.GTVPARS.GTVPARS.GTVPARS_SCHEDULER_NUMBER Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS_10G.SLARDEF.SLBRDEF.PARTITION_CODE Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS.SLARDEF.SLBRDEF.PARTITION_CODE Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS.GTVPARS.GTVPARS.GTVPARS_SCHEDULER_NUMBER Use(select )
CREATE_SCH_NUM Forms Trigger BANNER7_FORM