Model STVCAMP

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

List of Objects

Object Name	Object Type	Layer Name
APRADEG	TABLE	ERD
GTVPARS	TABLE	ERD
PEBEMPL	TABLE	ERD
RORCAMP	TABLE	ERD
RORWKST	TABLE	ERD
SARADAP	TABLE	ERD
SARCHKB	TABLE	ERD
SARDCSN	TABLE	ERD
SARQKER	TABLE	ERD
SARRRFT	TABLE	ERD
SARWAAD	TABLE	ERD
SARWADF	TABLE	ERD
SCRRCAM	TABLE	ERD
SCRRCMP	TABLE	ERD
SCRSECT	TABLE	ERD
SFRRGFE	TABLE	ERD
SFRSTCR	TABLE	ERD
SFRTMSL	TABLE	ERD
SFRTMST	TABLE	ERD
SGBSTDN	TABLE	ERD
SGRDSER	TABLE	ERD
SHBGSCH	TABLE	ERD
SHRCGDR	TABLE	ERD
SHRDGMR	TABLE	ERD
SHRGPAC	TABLE	ERD
SHRGPAL	TABLE	ERD
SHRPREV	TABLE	ERD
SHRTCKN	TABLE	ERD
SLBRMAP	TABLE	ERD
SLBRMPF	TABLE	ERD
SLRTASG	TABLE	ERD
SMRACAA	TABLE	ERD
SMRAQUA	TABLE	ERD
SMRAREX	TABLE	ERD
SMRARSA	TABLE	ERD
SMRARUL	TABLE	ERD
SMRGCAA	TABLE	ERD
SMRGREX	TABLE	ERD
SMRGRSA	TABLE	ERD
SMRGRUL	TABLE	ERD
SMRIECP	TABLE	ERD
SMRPCRS	TABLE	ERD
SMRPRLE	TABLE	ERD
SMRPRSA	TABLE	ERD
SMRRQCM	TABLE	ERD
SMRSACA	TABLE	ERD
SMRSARE	TABLE	ERD
SMRSARS	TABLE	ERD
SMRSARU	TABLE	ERD
SMRSGCA	TABLE	ERD
SMRSGRE	TABLE	ERD
SMRSGRS	TABLE	ERD
SMRSGRU	TABLE	ERD
SMRSPRS	TABLE	ERD
SOBCALD	TABLE	ERD
SOBCURR	TABLE	ERD
SOBODTE	TABLE	ERD
SOBPROF	TABLE	ERD
SORCCOL	TABLE	ERD
SORCOMM	TABLE	ERD
SOREXTN	TABLE	ERD
SORLCUR	TABLE	ERD
SORRFND	TABLE	ERD
SORRSTS	TABLE	ERD
SORT22A	TABLE	ERD
SRBPRED	TABLE	ERD
SRTPREL	TABLE	ERD
SSBDFEE	TABLE	ERD
SSBSECT	TABLE	ERD
SSRCTRL	TABLE	ERD
SSRRCMP	TABLE	ERD
SSTSCHW	TABLE	ERD
STVCAMP	TABLE	Tables
TBRIACM	TABLE	ERD

Comments

Model View

Table APRADEG

Schema Name ALUMNI
Label APRADEG
Server name S4B70
Creation Date 09/29/2003 12:12:53:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
APRADEG_PIDM	APRADEG_PIDM	NUMBER(8,0)	No	*	*
APRADEG_SEQ_NO	APRADEG_SEQ_NO	NUMBER(5,0)	No	*
APRADEG_SBGI_CODE	APRADEG_SBGI_CODE	VARCHAR2(6)	Yes		*
APRADEG_DEGC_CODE	APRADEG_DEGC_CODE	VARCHAR2(6)	Yes		*
APRADEG_DATE	APRADEG_DATE	DATE	Yes
APRADEG_HONR_CODE	APRADEG_HONR_CODE	VARCHAR2(6)	Yes		*
APRADEG_COLL_CODE	APRADEG_COLL_CODE	VARCHAR2(2)	Yes		*
APRADEG_ACTIVITY_DATE	APRADEG_ACTIVITY_DATE	DATE	No
APRADEG_ACYR_CODE	APRADEG_ACYR_CODE	VARCHAR2(4)	Yes		*
APRADEG_ACYR_CODE_BULLETIN	APRADEG_ACYR_CODE_BULLETIN	VARCHAR2(4)	Yes		*
APRADEG_CAMP_CODE	APRADEG_CAMP_CODE	VARCHAR2(3)	Yes		*
APRADEG_DEPT_CODE	APRADEG_DEPT_CODE	VARCHAR2(4)	Yes		*
APRADEG_COMMENTS	APRADEG_COMMENTS	VARCHAR2(2000)	Yes
APRADEG_MAJR_CODE_MINR_1	APRADEG_MAJR_CODE_MINR_1	VARCHAR2(4)	Yes		*
APRADEG_MAJR_CODE_MINR_2	APRADEG_MAJR_CODE_MINR_2	VARCHAR2(4)	Yes		*
APRADEG_MAJR_CODE_CONC_1	APRADEG_MAJR_CODE_CONC_1	VARCHAR2(4)	Yes		*
APRADEG_MAJR_CODE_CONC_2	APRADEG_MAJR_CODE_CONC_2	VARCHAR2(4)	Yes		*
APRADEG_MAJR_CODE_CONC_3	APRADEG_MAJR_CODE_CONC_3	VARCHAR2(4)	Yes		*
APRADEG_MAJR_CODE_CONC_4	APRADEG_MAJR_CODE_CONC_4	VARCHAR2(4)	Yes		*
APRADEG_MAJR_CODE_CONC_5	APRADEG_MAJR_CODE_CONC_5	VARCHAR2(4)	Yes		*
APRADEG_MAJR_CODE_CONC_6	APRADEG_MAJR_CODE_CONC_6	VARCHAR2(4)	Yes		*
APRADEG_DEPT_CODE_2	APRADEG_DEPT_CODE_2	VARCHAR2(4)	Yes		*
APRADEG_HONR_CODE_2	APRADEG_HONR_CODE_2	VARCHAR2(6)	Yes		*
APRADEG_HONR_CODE_3	APRADEG_HONR_CODE_3	VARCHAR2(6)	Yes		*
APRADEG_HONR_CODE_4	APRADEG_HONR_CODE_4	VARCHAR2(6)	Yes		*
APRADEG_HONR_CODE_5	APRADEG_HONR_CODE_5	VARCHAR2(6)	Yes		*
APRADEG_HOND_CODE_1	APRADEG_HOND_CODE_1	VARCHAR2(6)	Yes		*
APRADEG_HOND_CODE_2	APRADEG_HOND_CODE_2	VARCHAR2(6)	Yes		*
APRADEG_HOND_CODE_3	APRADEG_HOND_CODE_3	VARCHAR2(6)	Yes		*
APRADEG_HOND_CODE_4	APRADEG_HOND_CODE_4	VARCHAR2(6)	Yes		*
APRADEG_HOND_CODE_5	APRADEG_HOND_CODE_5	VARCHAR2(6)	Yes		*
APRADEG_OK_FOR_NOTES_IND	APRADEG_OK_FOR_NOTES_IND	VARCHAR2(1)	Yes
APRADEG_DISP_NOTES_IND	APRADEG_DISP_NOTES_IND	VARCHAR2(1)	Yes
APRADEG_DISP_NOTES_DATE	APRADEG_DISP_NOTES_DATE	DATE	Yes
APRADEG_USER	APRADEG_USER	VARCHAR2(30)	No
APRADEG_REVIEWED_IND	APRADEG_REVIEWED_IND	VARCHAR2(1)	Yes
APRADEG_REVIEWED_USER	APRADEG_REVIEWED_USER	VARCHAR2(30)	Yes
APRADEG_MAJOR_COMMENT	APRADEG_MAJOR_COMMENT	VARCHAR2(60)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
APRADEG_PIDM	APBCONS_PIDM	APBCONS
APRADEG_ACYR_CODE	STVACYR_CODE	STVACYR
APRADEG_CAMP_CODE	STVCAMP_CODE	STVCAMP
APRADEG_COLL_CODE	STVCOLL_CODE	STVCOLL
APRADEG_DEGC_CODE	STVDEGC_CODE	STVDEGC
APRADEG_DEPT_CODE	STVDEPT_CODE	STVDEPT
APRADEG_HOND_CODE_1	STVHOND_CODE	STVHOND
APRADEG_HONR_CODE	STVHONR_CODE	STVHONR
APRADEG_MAJR_CODE_MINR_1	STVMAJR_CODE	STVMAJR
APRADEG_SBGI_CODE	STVSBGI_CODE	STVSBGI
APRADEG_ACYR_CODE_BULLETIN	STVACYR_CODE	STVACYR
APRADEG_DEPT_CODE_2	STVDEPT_CODE	STVDEPT
APRADEG_HOND_CODE_2	STVHOND_CODE	STVHOND
APRADEG_HONR_CODE_2	STVHONR_CODE	STVHONR
APRADEG_MAJR_CODE_MINR_2	STVMAJR_CODE	STVMAJR
APRADEG_HOND_CODE_3	STVHOND_CODE	STVHOND
APRADEG_HONR_CODE_3	STVHONR_CODE	STVHONR
APRADEG_MAJR_CODE_CONC_1	STVMAJR_CODE	STVMAJR
APRADEG_HOND_CODE_4	STVHOND_CODE	STVHOND
APRADEG_HONR_CODE_4	STVHONR_CODE	STVHONR
APRADEG_MAJR_CODE_CONC_2	STVMAJR_CODE	STVMAJR
APRADEG_HOND_CODE_5	STVHOND_CODE	STVHOND
APRADEG_HONR_CODE_5	STVHONR_CODE	STVHONR
APRADEG_MAJR_CODE_CONC_3	STVMAJR_CODE	STVMAJR
APRADEG_MAJR_CODE_CONC_4	STVMAJR_CODE	STVMAJR
APRADEG_MAJR_CODE_CONC_5	STVMAJR_CODE	STVMAJR
APRADEG_MAJR_CODE_CONC_6	STVMAJR_CODE	STVMAJR

Index

Index Name	Index Type	Column Name
PK_APRADEG	Unique	APRADEG_PIDM
PK_APRADEG	Unique	APRADEG_SEQ_NO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
get_academic	C/C++ Function	[F:\BANNER\C\APPDEXT.PC]	Use(select )
get_degr_status	C/C++ Function	[F:\BANNER\C\ADPVSER.PC]	Use(select )
getdegc	C/C++ Function	[F:\BANNER\C\AFPTELF.PC]	Use(select )
insadeg	C/C++ Function	[F:\BANNER\C\APPSTDI.PC]	Use(insert,select )
insamaj	C/C++ Function	[F:\BANNER\C\APPSTDI.PC]	Use(select )
pcolmaj	C/C++ Function	[F:\BANNER\C\APPSTDI.PC]	Use(select )
sel_alum_grad	C/C++ Function	[F:\BANNER\C\ADPVSER.PC]	Use(select )
sel_alum_nodegr	C/C++ Function	[F:\BANNER\C\ADPVSER.PC]	Use(select )
sel_alum_under	C/C++ Function	[F:\BANNER\C\ADPVSER.PC]	Use(select )
selacaddegr	C/C++ Function	[F:\BANNER\C\APPDPRC.PC]	Use(select )
seladeg	C/C++ Function	[F:\BANNER\C\APPSTDI.PC]	Use(select )
selgrad	C/C++ Function	[F:\BANNER\C\AGPMATG.PC]	Use(select )
selmajors	C/C++ Function	[F:\BANNER\C\APPCLST.PC]	Use(select )
APRADEG	SYNONYM	S4B70.PUBLIC	Rely on ()
APRACYR	TABLE	S4B70.ALUMNI	Join
APRAMAJ	TABLE	S4B70.ALUMNI	Refer( No Action )
AA_DEGREE	VIEW	S4B70.BANINST1	Use(select )
PRE-DELETE	Forms Trigger	BANNER7_FORMS.APACONS.APBCONS	Use(select )
PRE-DELETE	Forms Trigger	BANNER7_FORMS_10G.APACONS.APBCONS	Use(select )
PRE-INSERT	Forms Trigger	BANNER7_FORMS_10G.APAADEG.APRADEG	Use(select )
PRE-INSERT	Forms Trigger	BANNER7_FORMS.APAADEG.APRADEG	Use(select )
F_CHECK_FOR_MORE	FUNCTION	S4B70.BANINST1	Use(select )
F_INST_DEGR	FUNCTION	S4B70.BANINST1	Use(select )
F_OTHER_INST_DEGR	FUNCTION	S4B70.BANINST1	Use(select )
DEGC_TYPE	Package Type	S4B70.BANINST1.BWAKADVS	Rely on ()
APRADEG_REC	Package variable	S4B70.BANINST1.BWDKCPRF	Rely on ()
APRADEG_REC	Package variable	S4B70.BANINST1.BWDKCPRF	Rely on ()
APRADEGVIEWC	Package cursor	S4B70.BANINST1.BWDKCPRF	Rely on () Use(select )
SEARCHVIEWC	Package cursor	S4B70.BANINST1.BWAKADVS	Use(select )
P_EVALUATE_MG_ELIGIBILITY	Package procedure	S4B70.BANINST1.AXKEXMG	Use(select )
P_LOAD_DEGREE	Package procedure	S4B70.BANINST1.APKLDRD	Rely on ()
P_LOAD_DEGREE	Package procedure	S4B70.BANINST1.APKLDRD	Rely on () Use(insert,update,select )
OK_LOAD	Forms Sub Procedure	BANNER7_FORMS_10G.APADRVW.UPLOAD_DEGREE	Use(insert,update,select )
OK_LOAD	Forms Sub Procedure	BANNER7_FORMS.APADRVW.UPLOAD_DEGREE	Use(insert,update,select )
F_GET_DEGREE_CHANGES_IND	Package function	S4B70.BANINST1.APKWIND	Use(select )
APRADEG	Forms DataBlock	BANNER7_FORMS_10G.APAADEG	Rely on () Use(insert,update,delete,select )
APRADEG	Forms DataBlock	BANNER7_FORMS_10G.APASBIO	Rely on () Use(select )
APRADEG	Forms DataBlock	BANNER7_FORMS.APASBIO	Rely on () Use(select )
APRADEG	Forms DataBlock	BANNER7_FORMS.APAADEG	Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_APRADEG	INDEX	S4B70.ALUMNI	Rely on ()
APBCONS	TABLE	S4B70.ALUMNI	Refer( No Action )
STVACYR	TABLE	S4B70.SATURN	Refer( No Action )
STVCAMP	TABLE	S4B70.SATURN	Refer( No Action )
STVCOLL	TABLE	S4B70.SATURN	Refer( No Action )
STVDEGC	TABLE	S4B70.SATURN	Refer( No Action )
STVDEPT	TABLE	S4B70.SATURN	Refer( No Action )
STVHOND	TABLE	S4B70.SATURN	Refer( No Action )
STVHONR	TABLE	S4B70.SATURN	Refer( No Action )
STVMAJR	TABLE	S4B70.SATURN	Refer( No Action )
STVSBGI	TABLE	S4B70.SATURN	Refer( No Action )

Comments

Source Code Comments

Academic Degree Repeating Table

Columns Comments for APRADEG_PIDM (1)

Source Code Comments

This field specifies the internal system generated identification number.

Columns Comments for APRADEG_SEQ_NO (2)

Source Code Comments

This field specifies the internal sequence number.

Columns Comments for APRADEG_SBGI_CODE (3)

Source Code Comments

This field specifies the institution at which the constituent earned the degree.

Columns Comments for APRADEG_DEGC_CODE (4)

Source Code Comments

This field spsecifies the type of degree earned by the constituent.

Columns Comments for APRADEG_DATE (5)

Source Code Comments

This field specifies the date the degree was awarded to the constituent.

Columns Comments for APRADEG_HONR_CODE (6)

Source Code Comments

This field specifies the honors the constituent received with the associated degree.

Columns Comments for APRADEG_COLL_CODE (7)

Source Code Comments

This field specifies the college that awarded the associated degree to the constituent.

Columns Comments for APRADEG_ACTIVITY_DATE (8)

Source Code Comments

This system maintained field specifies the date this file was created or updated.

Columns Comments for APRADEG_ACYR_CODE (9)

Source Code Comments

The Academic Year Code associated with this degree.

Columns Comments for APRADEG_ACYR_CODE_BULLETIN (10)

Source Code Comments

The Academic Year Bulletin Code associated with this degree.

Columns Comments for APRADEG_CAMP_CODE (11)

Source Code Comments

The campus associated with this degree.

Columns Comments for APRADEG_DEPT_CODE (12)

Source Code Comments

The first department associated with this degree.

Columns Comments for APRADEG_COMMENTS (13)

Source Code Comments

Free form text comments about this degree.

Columns Comments for APRADEG_MAJR_CODE_MINR_1 (14)

Source Code Comments

The first Minor code associated with this degree.

Columns Comments for APRADEG_MAJR_CODE_MINR_2 (15)

Source Code Comments

The second Minor code associated with this degree.

Columns Comments for APRADEG_MAJR_CODE_CONC_1 (16)

Source Code Comments

The first Concentration Code assosiated with this degree.

Columns Comments for APRADEG_MAJR_CODE_CONC_2 (17)

Source Code Comments

The second Concentration Code assosiated with this degree.

Columns Comments for APRADEG_MAJR_CODE_CONC_3 (18)

Source Code Comments

The third Concentration Code assosiated with this degree.

Columns Comments for APRADEG_MAJR_CODE_CONC_4 (19)

Source Code Comments

The fourth Concentration Code assosiated with this degree.

Columns Comments for APRADEG_MAJR_CODE_CONC_5 (20)

Source Code Comments

The fifth Concentration Code assosiated with this degree.

Columns Comments for APRADEG_MAJR_CODE_CONC_6 (21)

Source Code Comments

The sixth Concentration Code assosiated with this degree.

Columns Comments for APRADEG_DEPT_CODE_2 (22)

Source Code Comments

The second department associated with this degree.

Columns Comments for APRADEG_HONR_CODE_2 (23)

Source Code Comments

This field specifies the honors the constituent received with the associated degree.

Columns Comments for APRADEG_HONR_CODE_3 (24)

Source Code Comments

This field specifies the honors the constituent received with the associated degree.

Columns Comments for APRADEG_HONR_CODE_4 (25)

Source Code Comments

This field specifies the honors the constituent received with the associated degree.

Columns Comments for APRADEG_HONR_CODE_5 (26)

Source Code Comments

This field specifies the honors the constituent received with the associated degree.

Columns Comments for APRADEG_HOND_CODE_1 (27)

Source Code Comments

This field specifies the departmental honors the constituent received with the associated degree.

Columns Comments for APRADEG_HOND_CODE_2 (28)

Source Code Comments

This field specifies the departmental honors the constituent received with the associated degree.

Columns Comments for APRADEG_HOND_CODE_3 (29)

Source Code Comments

This field specifies the departmental honors the constituent received with the associated degree.

Columns Comments for APRADEG_HOND_CODE_4 (30)

Source Code Comments

This field specifies the departmental honors the constituent received with the associated degree.

Columns Comments for APRADEG_HOND_CODE_5 (31)

Source Code Comments

This field specifies the departmental honors the constituent received with the associated degree.

Columns Comments for APRADEG_OK_FOR_NOTES_IND (32)

Source Code Comments

OK for Notes Indicator, Y indicates that this degree can be used in Class Notes.

Columns Comments for APRADEG_DISP_NOTES_IND (33)

Source Code Comments

Displayed in Notes Indicator, Y indicates that this degree was displaeyd in Class Notes.

Columns Comments for APRADEG_DISP_NOTES_DATE (34)

Source Code Comments

The date that this degree was displayed in Class Notes.

Columns Comments for APRADEG_USER (35)

Source Code Comments

The User ID of the person who created or last modified this degree record.

Columns Comments for APRADEG_REVIEWED_IND (36)

Source Code Comments

Reviewed Indicator, Y indicates that this degree has been reviewed and accepted.

Columns Comments for APRADEG_REVIEWED_USER (37)

Source Code Comments

The User ID of the person who reviewed and accepted this degree.

Columns Comments for APRADEG_MAJOR_COMMENT (38)

Source Code Comments

Free form text comments about this degree.

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_FORMS.GTVPARS	Use(select )
CREATE_SCH_NUM	Forms Trigger	BANNER7_FORMS_10G.GTVPARS	Use(select )
OPT_SEQ_NOS	Forms Trigger	BANNER7_FORMS.GTVPARS	Use(update,select )
OPT_SEQ_NOS	Forms Trigger	BANNER7_FORMS_10G.GTVPARS	Use(update,select )
GTVPARS_RG	Forms Record Group	BANNER7_FORMS.SCACRSE	Use(select )
GTVPARS_RG	Forms Record Group	BANNER7_FORMS.SLARDEF	Use(select )
GTVPARS_RG	Forms Record Group	BANNER7_FORMS.SLABLDG	Use(select )
GTVPARS_RG	Forms Record Group	BANNER7_FORMS.SSASBSH	Use(select )
GTVPARS_RG	Forms Record Group	BANNER7_FORMS_10G.SSASBSH	Use(select )
GTVPARS_RG	Forms Record Group	BANNER7_FORMS_10G.SSASECT	Use(select )
GTVPARS_RG	Forms Record Group	BANNER7_FORMS_10G.SLABLDG	Use(select )
GTVPARS_RG	Forms Record Group	BANNER7_FORMS_10G.SLARDEF	Use(select )
GTVPARS_RG	Forms Record Group	BANNER7_FORMS_10G.SCACRSE	Use(select )
GTVPARS_RG	Forms Record Group	BANNER7_FORMS.SSASECT	Use(select )
POP_DESC	Forms Trigger	BANNER7_FORMS.SSASBSH.SCRSPRT	Use(select )
POP_DESC	Forms Trigger	BANNER7_FORMS_10G.SSASBSH.SCRSPRT	Use(select )
WHEN-NEW-RECORD-INSTANCE	Forms Trigger	BANNER7_FORMS.SLARDEF.SLBRDEF	Use(select )
WHEN-NEW-RECORD-INSTANCE	Forms Trigger	BANNER7_FORMS_10G.SLARDEF.SLBRDEF	Use(select )
UT_SETUP	Package procedure	S4B70.BANINST1.UT_GB_BLDGDEFINITION	Use(insert )
UT_SETUP	Package procedure	S4B70.BANINST1.UT_SB_BLDGDEFINITION	Use(insert,select )
UT_TEARDOWN	Package procedure	S4B70.BANINST1.UT_SB_BLDGDEFINITION	Use(delete )
GTVPARSC	Package cursor	S4B70.BANINST1.GTKPARS	Rely on () Use(select )
GTVPARS_C	Package cursor	S4B70.BANINST1.GB_GTVPARS	Rely on ()
GTVPARS_C	Package cursor	S4B70.BANINST1.GB_GTVPARS	Rely on () Use(select )
F_CODE_EXISTS	Package function	S4B70.BANINST1.GB_GTVPARS	Rely on ()
F_CODE_EXISTS	Package function	S4B70.BANINST1.GB_GTVPARS	Rely on ()
F_GET_DESCRIPTION	Package function	S4B70.BANINST1.GB_GTVPARS	Rely on ()
F_GET_DESCRIPTION	Package function	S4B70.BANINST1.GB_GTVPARS	Rely on ()
GTVPARS	Forms DataBlock	BANNER7_FORMS.GTVPARS	Rely on () Use(insert,update,delete,select )
GTVPARS	Forms DataBlock	BANNER7_FORMS_10G.GTVPARS	Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GTVPARS	INDEX	S4B70."GENERAL"	Rely on ()
STVCAMP	TABLE	S4B70.SATURN	Refer( No Action )

Comments

Source Code Comments

Validation entries for Partition codes. Partition Codes define campus zones, which are catagories or groupings of rooms.

Columns Comments for GTVPARS_CODE (1)

Source Code Comments

Partition code for campus zones for scheduling product.

Columns Comments for GTVPARS_DESC (2)

Source Code Comments

Description of partition code for scheduling product.

Columns Comments for GTVPARS_SCHEDULER_NUMBER (3)

Source Code Comments

Numeric identifying value for partition code for scheduling product.

Columns Comments for GTVPARS_USER_ID (4)

Source Code Comments

This field identifies the user wholast updated the record

Columns Comments for GTVPARS_ACTIVITY_DATE (5)

Source Code Comments

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

Columns Comments for GTVPARS_CAMP_CODE (6)

Source Code Comments

Campus code associated with partition for scheduling product.

Table PEBEMPL

Schema Name PAYROLL
Label PEBEMPL
Server name S4B70
Creation Date 09/09/2004 23:42:52:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
PEBEMPL_PIDM	PEBEMPL_PIDM	NUMBER(8,0)	No	*	*
PEBEMPL_EMPL_STATUS	PEBEMPL_EMPL_STATUS	VARCHAR2(1)	No
PEBEMPL_COAS_CODE_HOME	PEBEMPL_COAS_CODE_HOME	VARCHAR2(1)	Yes
PEBEMPL_ORGN_CODE_HOME	PEBEMPL_ORGN_CODE_HOME	VARCHAR2(6)	No		*
PEBEMPL_COAS_CODE_DIST	PEBEMPL_COAS_CODE_DIST	VARCHAR2(1)	Yes
PEBEMPL_ORGN_CODE_DIST	PEBEMPL_ORGN_CODE_DIST	VARCHAR2(6)	No		*
PEBEMPL_ECLS_CODE	PEBEMPL_ECLS_CODE	VARCHAR2(2)	No		*
PEBEMPL_LCAT_CODE	PEBEMPL_LCAT_CODE	VARCHAR2(2)	No		*
PEBEMPL_BCAT_CODE	PEBEMPL_BCAT_CODE	VARCHAR2(2)	No		*
PEBEMPL_FIRST_HIRE_DATE	PEBEMPL_FIRST_HIRE_DATE	DATE	No
PEBEMPL_CURRENT_HIRE_DATE	PEBEMPL_CURRENT_HIRE_DATE	DATE	No
PEBEMPL_ADJ_SERVICE_DATE	PEBEMPL_ADJ_SERVICE_DATE	DATE	No
PEBEMPL_SENIORITY_DATE	PEBEMPL_SENIORITY_DATE	DATE	No
PEBEMPL_LREA_CODE	PEBEMPL_LREA_CODE	VARCHAR2(2)	Yes
PEBEMPL_LOA_BEG_DATE	PEBEMPL_LOA_BEG_DATE	DATE	Yes
PEBEMPL_LOA_END_DATE	PEBEMPL_LOA_END_DATE	DATE	Yes
PEBEMPL_TREA_CODE	PEBEMPL_TREA_CODE	VARCHAR2(2)	Yes		*
PEBEMPL_TERM_DATE	PEBEMPL_TERM_DATE	DATE	Yes
PEBEMPL_I9_FORM_IND	PEBEMPL_I9_FORM_IND	VARCHAR2(1)	Yes
PEBEMPL_I9_DATE	PEBEMPL_I9_DATE	DATE	Yes
PEBEMPL_I9_EXPIRE_DATE	PEBEMPL_I9_EXPIRE_DATE	DATE	Yes
PEBEMPL_ACTIVITY_DATE	PEBEMPL_ACTIVITY_DATE	DATE	No
PEBEMPL_WKPR_CODE	PEBEMPL_WKPR_CODE	VARCHAR2(4)	Yes		*
PEBEMPL_FLSA_IND	PEBEMPL_FLSA_IND	VARCHAR2(1)	No
PEBEMPL_STGR_CODE	PEBEMPL_STGR_CODE	VARCHAR2(2)	Yes		*
PEBEMPL_DAYS_IN_CANADA	PEBEMPL_DAYS_IN_CANADA	NUMBER(3,0)	Yes
PEBEMPL_1042_RECIPIENT_CD	PEBEMPL_1042_RECIPIENT_CD	VARCHAR2(2)	Yes
PEBEMPL_INTERNAL_FT_PT_IND	PEBEMPL_INTERNAL_FT_PT_IND	VARCHAR2(1)	No
PEBEMPL_DICD_CODE	PEBEMPL_DICD_CODE	VARCHAR2(3)	Yes
PEBEMPL_EGRP_CODE	PEBEMPL_EGRP_CODE	VARCHAR2(4)	Yes
PEBEMPL_IPEDS_SOFT_MONEY_IND	PEBEMPL_IPEDS_SOFT_MONEY_IND	VARCHAR2(1)	No
PEBEMPL_FIRST_WORK_DATE	PEBEMPL_FIRST_WORK_DATE	DATE	Yes
PEBEMPL_LAST_WORK_DATE	PEBEMPL_LAST_WORK_DATE	DATE	Yes
PEBEMPL_CALIF_PENSION_IND	PEBEMPL_CALIF_PENSION_IND	VARCHAR2(1)	Yes
PEBEMPL_NRSI_CODE	PEBEMPL_NRSI_CODE	VARCHAR2(4)	Yes		*
PEBEMPL_SSN_LAST_NAME	PEBEMPL_SSN_LAST_NAME	VARCHAR2(20)	Yes
PEBEMPL_SSN_FIRST_NAME