Model Value_Based_Security*

Model Label :

List of Objects

Object Name	Object Type	Layer Name
GOBBACR	SQL Table	Default
GOBEACC	SQL Table	Default
GOBPCRL	SQL Table	Default
GOBSEGC	SQL Table	Default
GOBVBSC	SQL Table	Default
GOBVCRL	SQL Table	Default
GOBVUSR	SQL Table	Default
GORGMGR	SQL Table	Default
GORGMSK	SQL Table	Default
GORGRUL	SQL Table	Default
GORGUSR	SQL Table	Default
GORRAVL	SQL Table	Default
GORTCRL	SQL Table	Default
GORVGAC	SQL Table	Default
GORVMAC	SQL Table	Default
GORVMGA	SQL Table	Default
GORVRAC	SQL Table	Default
GORVSVR	SQL Table	Default
GORVTBL	SQL Table	Default
GTVSEGC	SQL Table	Default
GTVVAPP	SQL Table	Default
GTVVBTY	SQL Table	Default
GTVVOBJ	SQL Table	Default

Model View

Table GOBBACR

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GOBBACR_SEQNO	NUMBER(8,0)	No	*
GOBBACR_VOBJ_CODE	VARCHAR2(15)	No		*
GOBBACR_ACTIVE_IND	VARCHAR2(1)	No
GOBBACR_EFF_DATE	DATE	No
GOBBACR_ACTIVITY_DATE	DATE	No
GOBBACR_PATTERN_CTRL	NUMBER(4,0)	Yes
GOBBACR_ACCESS_CNT	NUMBER(4,0)	Yes
GOBBACR_EXPIRE_DATE	DATE	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GOBBACR_VOBJ_CODE	GTVVOBJ_CODE	GTVVOBJ

Index

Index Name	Index Type	Column Name
PK_GOBBACR	Unique	GOBBACR_SEQNO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GOBVCRL	SQL Table	S10B80.GENERAL	Refer (no action)
GORVRAC	SQL Table	S10B80.GENERAL	Refer (no action)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GOBBACR	SQL Index	S10B80.GENERAL	Rely On
GTVVOBJ	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GOBBACR

Object Dates

Creation Date	Analysis Date
04/02/2008 20:31:22:000	04/02/2008 21:17:55:000

Source Code Comments

Access Rule Base

Columns Comments for GOBBACR_SEQNO (# 1)

Source Code Comments

Access Rule Sequence Number

Columns Comments for GOBBACR_VOBJ_CODE (# 2)

Source Code Comments

VBS Object Code

Columns Comments for GOBBACR_ACTIVE_IND (# 3)

Source Code Comments

Access Rule Active Indicator

Columns Comments for GOBBACR_EFF_DATE (# 4)

Source Code Comments

Access Rule Effective Date

Columns Comments for GOBBACR_ACTIVITY_DATE (# 5)

Source Code Comments

Date of Insert or Last Update

Columns Comments for GOBBACR_PATTERN_CTRL (# 6)

Source Code Comments

Access Rule Secured Item Pattern Control

Columns Comments for GOBBACR_ACCESS_CNT (# 7)

Source Code Comments

Access Group Association Cummulative Count

Columns Comments for GOBBACR_EXPIRE_DATE (# 8)

Source Code Comments

Access Rule Expiration Date

Table GOBEACC

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GOBEACC_PIDM	NUMBER(8,0)	No	*
GOBEACC_USERNAME	VARCHAR2(30)	No		*
GOBEACC_USER_ID	VARCHAR2(30)	No
GOBEACC_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
GOBEACC_USERNAME	NTRPROX_PROXY_USER_ID	NTRPROX
GOBEACC_USERNAME	NTRPROX_USER_ID	NTRPROX

Index

Index Name	Index Type	Column Name
GOBEACC_KEY_INDEX	Unique	GOBEACC_USERNAME
PK_GOBEACC	Unique	GOBEACC_PIDM

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GOBUMAP	SQL Table	S10B80.GENERAL	Join
GURIDEN	SQL Table	S10B80.GENERAL	Join
NTRLVID	SQL Table	S10B80.POSNCTL	Join
NTRTPRX	SQL Table	S10B80.POSNCTL	Join
PTRUSER	SQL Table	S10B80.PAYROLL	Join
SPRIDEN	SQL Table	S10B80.SATURN	Join
PHVTIME	SQL View	S10B80.BANINST1	Use (select)
F_FINANCE_USER_IC	SQL Function	S10B80.BANINST1	Use (select)
F_FINANCE_USER_IND	SQL Function	S10B80.BANINST1	Use (select)
GOBAPID_REC	Oracle Package Type	S10B80.BANINST1.GB_GOBAPID	Rely On
GOBEACC_TYPE	Oracle Package Type	S10B80.BANINST1.BWAKLIBS	Rely On
USERRECORD	Oracle Package Type	S10B80.BANINST1.BWFKRPCU	Rely On
FILTERED_JOBS_C	Oracle Package Cursor	S10B80.BANINST1.BWPKFSEM	Rely On
GETAMRPLANBYDATEC	Oracle Package Cursor	S10B80.BANINST1.BWDKMOVE	Use (select)
GETAMRPLANDATEC	Oracle Package Cursor	S10B80.BANINST1.BWDKMOVE	Use (select)
GETAMRPLANGEORC	Oracle Package Cursor	S10B80.BANINST1.BWDKMOVE	Use (select)
GETAMRPLANNAMEC	Oracle Package Cursor	S10B80.BANINST1.BWDKMOVE	Use (select)
GETAMRPLANPROJC	Oracle Package Cursor	S10B80.BANINST1.BWDKMOVE	Use (select)
GETPASSEDAMRPLANC	Oracle Package Cursor	S10B80.BANINST1.BWDKMOVE	Use (select)
GET_GURIDEN_IDEN_CODE_C	Oracle Package Cursor	S10B80.BANINST1.BWACBREF	Rely On
GET_GURIDEN_IDEN_CODE_C	Oracle Package Cursor	S10B80.BANINST1.BWACBREF	Use (select)
GET_PROXY_NAME	Oracle Package Cursor	S10B80.BANINST1.BWPKTAIS	Use (select)
GET_PROXY_NAME	Oracle Package Cursor	S10B80.BANINST1.BWPKLRED	Use (select)
GOBEACCC	Oracle Package Cursor	S10B80.WTAILOR.TWBKAUSR	Use (select)
ORGN_C	Oracle Package Cursor	S10B80.BANINST1.BWPKFSEM	Rely On
PERFASG_C	Oracle Package Cursor	S10B80.BANINST1.BWPKFSEM	Rely On
PERFJOB_NBTJOBF_CUR	Oracle Package Cursor	S10B80.BANINST1.BWPKFCFT	Rely On
PERFNIS_C	Oracle Package Cursor	S10B80.BANINST1.BWPKFSEM	Rely On
RECS_COUNT_C	Oracle Package Cursor	S10B80.BANINST1.BWPKFSEM	Rely On
OVERRIDE_NSF	Oracle Package Procedure	S10B80.BANINST1.BWFKUADI	Rely On
P_APPR_SUMMARY_LIST	Oracle Package Procedure	S10B80.BANINST1.BWPKEPSM	Rely On
P_BUILD_PROXY_LIST	Oracle Package Procedure	S10B80.BANINST1.BWPKEPSM	Rely On
P_BUILD_PROXY_LIST	Oracle Package Procedure	S10B80.BANINST1.BWPKEPSM	Use (select)
P_BUILD_QUEUE_STATUS_LIST	Oracle Package Procedure	S10B80.BANINST1.BWPKEPSM	Rely On
P_BUILD_TRANS_STATUS_LIST	Oracle Package Procedure	S10B80.BANINST1.BWPKEPSM	Rely On
P_CHECK_SECURITY	Oracle Package Procedure	S10B80.BANINST1.BWFKPURR	Rely On
P_CHECK_SECURITY	Oracle Package Procedure	S10B80.BANINST1.BWFKTRAN	Rely On
P_CHECK_SECURITY	Oracle Package Procedure	S10B80.BANINST1.BWFKREQN	Rely On
P_CHK_WAIVED_DEDUCTION	Oracle Package Procedure	S10B80.BANINST1.BWPKDOEN	Rely On
P_COPYJOBTOPOSN	Oracle Package Procedure	S10B80.BANINST1.BWPKSDST	Rely On
P_COPYPOSNTOJOB	Oracle Package Procedure	S10B80.BANINST1.BWPKSDST	Rely On
P_COPYPOSNTOJOBBYJOB	Oracle Package Procedure	S10B80.BANINST1.BWPKSDST	Rely On
P_DISPLAYPROXY	Oracle Package Procedure	S10B80.BANINST1.BWPKTAIS	Rely On
P_DISPLAYPROXY	Oracle Package Procedure	S10B80.BANINST1.BWPKTAIS	Use (select)
P_DISPLAYPROXY	Oracle Package Procedure	S10B80.BANINST1.BWPKLRED	Rely On
P_DISPLAYPROXY	Oracle Package Procedure	S10B80.BANINST1.BWPKLRED	Use (select)
P_GET_PREV_NEXT_TRANS_NO	Oracle Package Procedure	S10B80.BANINST1.BWPKEPSM	Rely On
P_INSERTCOMMENT	Oracle Package Procedure	S10B80.BANINST1.BWFKUADI	Rely On
P_INSERT_NBTEMPF	Oracle Package Procedure	S10B80.BANINST1.BWPKFLTR	Rely On
P_NOTIFY_APPROVER	Oracle Package Procedure	S10B80.BANINST1.PEKTEAP	Rely On
P_PERSONALINFO	Oracle Package Procedure	S10B80.BANINST1.BWPKEBST	Rely On
P_PREVIEW_BUTTONS	Oracle Package Procedure	S10B80.BANINST1.BWPKEPSM	Rely On
P_PRINT_COAS_ORGS	Oracle Package Procedure	S10B80.BANINST1.BWPKFLTR	Rely On
P_PRINT_EMPLOYEES	Oracle Package Procedure	S10B80.BANINST1.BWPKFSEM	Rely On
P_PRINT_ESUM_HEADER	Oracle Package Procedure	S10B80.BANINST1.BWPKFSEM	Rely On
P_PRINT_PERS_IDNAME	Oracle Package Procedure	S10B80.BANINST1.BWPKEPCR	Rely On
P_PRINT_POSN_ITEMS	Oracle Package Procedure	S10B80.BANINST1.BWPKEPCR	Rely On
P_PRINT_PREVIOUS_COMMENTS	Oracle Package Procedure	S10B80.BANINST1.BWPKFMSC	Rely On
P_SELECTAPPROVERACTION	Oracle Package Procedure	S10B80.BANINST1.BWPKTAIS	Rely On
P_SELECTAPPROVERACTION	Oracle Package Procedure	S10B80.BANINST1.BWPKLRED	Rely On
P_SELECTNJSUPERUSERACTION	Oracle Package Procedure	S10B80.BANINST1.BWPKTAIS	Rely On
P_SELECTNJSUPERUSERACTION	Oracle Package Procedure	S10B80.BANINST1.BWPKLRED	Rely On
P_SELECTSUPERUSERACTION	Oracle Package Procedure	S10B80.BANINST1.BWPKTAIS	Rely On
P_SELECTSUPERUSERACTION	Oracle Package Procedure	S10B80.BANINST1.BWPKLRED	Rely On
P_SUMMARY_LINKS	Oracle Package Procedure	S10B80.BANINST1.BWPKEPSM	Rely On
CURRUSERID	Oracle Package Variable	S10B80.BANINST1.BWFKUAPP	Rely On
GLOBAL_PIDM	Oracle Package Variable	S10B80.BANINST1.BWPKFACT	Rely On
GLOBAL_PIDM	Oracle Package Variable	S10B80.BANINST1.BWPKTEST	Rely On
GLOBAL_PIDM	Oracle Package Variable	S10B80.BANINST1.BWPKFJDT	Rely On
GLOBAL_PIDM	Oracle Package Variable	S10B80.BANINST1.BWPKFJLD	Rely On
GLOBAL_PIDM	Oracle Package Variable	S10B80.BANINST1.BWPKFJOB	Rely On
GLOBAL_PIDM	Oracle Package Variable	S10B80.BANINST1.BWPKFCAL	Rely On
GLOBAL_PIDM	Oracle Package Variable	S10B80.BANINST1.BWPKFCFT	Rely On
GLOBAL_PIDM	Oracle Package Variable	S10B80.BANINST1.BWPKFCMT	Rely On
GLOBAL_PIDM	Oracle Package Variable	S10B80.BANINST1.BWPKFCPT	Rely On
GLOBAL_PIDM	Oracle Package Variable	S10B80.BANINST1.BWPKFCRN	Rely On
GLOBAL_PIDM	Oracle Package Variable	S10B80.BANINST1.BWPKFSEM	Rely On
GLOBAL_PIDM	Oracle Package Variable	S10B80.BANINST1.BWPKFSOR	Rely On
GLOBAL_PIDM	Oracle Package Variable	S10B80.BANINST1.BWPKFLAC	Rely On
GLOBAL_PIDM	Oracle Package Variable	S10B80.BANINST1.TEST_SSB_BXS	Rely On
GLOBAL_PIDM	Oracle Package Variable	S10B80.BANINST1.BWPKFLSM	Rely On
GLOBAL_PIDM	Oracle Package Variable	S10B80.BANINST1.BWPKFLTR	Rely On
GLOBAL_PIDM	Oracle Package Variable	S10B80.BANINST1.BWPKEPAF	Rely On
GLOBAL_PIDM	Oracle Package Variable	S10B80.BANINST1.BWPKEPCR	Rely On
GLOBAL_PIDM	Oracle Package Variable	S10B80.BANINST1.BWPKEPDT	Rely On
GLOBAL_PIDM	Oracle Package Variable	S10B80.BANINST1.BWPKFMSC	Rely On
GLOBAL_USER	Oracle Package Variable	S10B80.BANINST1.BWPKSORG	Rely On
GLOBAL_USER	Oracle Package Variable	S10B80.BANINST1.BWPKFACT	Rely On
GLOBAL_USER	Oracle Package Variable	S10B80.BANINST1.BWPKTEST	Rely On
GLOBAL_USER	Oracle Package Variable	S10B80.BANINST1.BWPKSALA	Rely On
GLOBAL_USER	Oracle Package Variable	S10B80.BANINST1.BWPKFJDT	Rely On
GLOBAL_USER	Oracle Package Variable	S10B80.BANINST1.BWPKFJOB	Rely On
GLOBAL_USER	Oracle Package Variable	S10B80.BANINST1.BWPKFCAL	Rely On
GLOBAL_USER	Oracle Package Variable	S10B80.BANINST1.BWPKFCFT	Rely On
GLOBAL_USER	Oracle Package Variable	S10B80.BANINST1.BWPKSJOB	Rely On
GLOBAL_USER	Oracle Package Variable	S10B80.BANINST1.BWPKFCMT	Rely On
GLOBAL_USER	Oracle Package Variable	S10B80.BANINST1.BWPKFCRN	Rely On
GLOBAL_USER	Oracle Package Variable	S10B80.BANINST1.BWPKFSEM	Rely On
GLOBAL_USER	Oracle Package Variable	S10B80.BANINST1.BWPKFLAC	Rely On
GLOBAL_USER	Oracle Package Variable	S10B80.BANINST1.BWPKSDST	Rely On
GLOBAL_USER	Oracle Package Variable	S10B80.BANINST1.TEST_SSB_BXS	Rely On
GLOBAL_USER	Oracle Package Variable	S10B80.BANINST1.BWPKFLSM	Rely On
GLOBAL_USER	Oracle Package Variable	S10B80.BANINST1.BWPKFLTR	Rely On
GLOBAL_USER	Oracle Package Variable	S10B80.BANINST1.BWPKEPAF	Rely On
GLOBAL_USER	Oracle Package Variable	S10B80.BANINST1.BWPKEPCR	Rely On
GLOBAL_USER	Oracle Package Variable	S10B80.BANINST1.BWPKSTOT	Rely On
GLOBAL_USER	Oracle Package Variable	S10B80.BANINST1.BWPKEPDT	Rely On
GLOBAL_USER	Oracle Package Variable	S10B80.BANINST1.BWPKEPID	Rely On
GLOBAL_USER	Oracle Package Variable	S10B80.BANINST1.BWPKSMEX	Rely On
GLOBAL_USER	Oracle Package Variable	S10B80.BANINST1.BWPKEPLK	Rely On
GLOBAL_USER	Oracle Package Variable	S10B80.BANINST1.BWPKFMSC	Rely On
GLOBAL_USER	Oracle Package Variable	S10B80.BANINST1.BWPKSFDT	Rely On
MAPPED_PIDM	Oracle Package Variable	S10B80.WTAILOR.TWBKAUSR	Rely On
PIDM	Oracle Package Variable	S10B80.BANINST1.BWFKUADI	Rely On
PIDM	Oracle Package Variable	S10B80.BANINST1.BWFKUAPP	Rely On
VAR_GOBEACC_USERNAME	Oracle Package Variable	S10B80.BANINST1.BWPKSPOS	Rely On
F_FORMAT_ROUTUSER_NAME	Oracle Package Function	S10B80.BANINST1.BWPKEPID	Rely On
F_FORMAT_ROUTUSER_NAME	Oracle Package Function	S10B80.BANINST1.BWPKEPID	Use (select)
F_GETUSERID	Oracle Package Function	S10B80.BANINST1.BWFKTDEL	Rely On
F_GETUSERID	Oracle Package Function	S10B80.BANINST1.BWFKTDEL	Use (select)
F_GET_GURIDEN_IDEN_CODE	Oracle Package Function	S10B80.BANINST1.BWACXCHN	Use (select)
F_ISBENADMIN	Oracle Package Function	S10B80.BANINST1.BWPKEBST	Use (select)
F_OPEN_ROUTUSER_RC	Oracle Package Function	S10B80.BANINST1.BWPKEPID	Use (select)
F_ROLE_ACCESS_IND	Oracle Package Function	S10B80.BANINST1.BWPKEPAF	Rely On
GETGOBEACCC	Oracle Package Cursor	S10B80.BANINST1.BWAKLIBS	Use (select)
GETPROSPECTSC	Oracle Package Cursor	S10B80.BANINST1.BWAKLIBS	Use (select)
GETUSERID	Oracle Package Cursor	S10B80.BANINST1.BWFKRPCU	Use (select)
GOBEACCVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKLIBS	Use (select)
GET_MIF_CODES_BY_PIDM	Oracle Package Procedure	S10B80.BANSECR.GSPVPDI	Use (select)
GET_REQUESTOR	Oracle Package Procedure	S10B80.BANINST1.FOKWFLW	Use (select)
P_ADMIN_LOGIN	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Use (select)
P_APPROVERSUMMARY	Oracle Package Procedure	S10B80.BANINST1.BWPKTAIS	Rely On
P_APPROVERSUMMARY	Oracle Package Procedure	S10B80.BANINST1.BWPKLRED	Rely On
P_CHK_SECURITY	Oracle Package Procedure	S10B80.BANINST1.BWPKEPDT	Rely On
P_COMMENTS	Oracle Package Procedure	S10B80.BANINST1.BWPKTELC	Rely On
P_COMMENTS	Oracle Package Procedure	S10B80.BANINST1.BWPKTALC	Rely On
P_COMMENTS_ADMIN_BODY	Oracle Package Procedure	S10B80.BANINST1.BWPKFMSC	Rely On
P_COMMENTS_BODY	Oracle Package Procedure	S10B80.BANINST1.BWPKFMSC	Rely On
P_CREATE_ROUTING_QUEUE	Oracle Package Procedure	S10B80.BANINST1.PEKTECM	Rely On
P_DISPAPPROVERFILTERSBODY	Oracle Package Procedure	S10B80.BANINST1.BWPKEPSM	Rely On
P_DISPAPPROVERSUMMARY	Oracle Package Procedure	S10B80.BANINST1.BWPKEPAF	Rely On
P_DISPAPPROVERSUMMARYBODY	Oracle Package Procedure	S10B80.BANINST1.BWPKEPSM	Rely On
P_DISPCOMMENTS	Oracle Package Procedure	S10B80.BANINST1.BWPKEPAF	Rely On
P_DISPDATESELECT	Oracle Package Procedure	S10B80.BANINST1.BWPKEBST	Rely On
P_DISPDATESELECT	Oracle Package Procedure	S10B80.BANINST1.BWPKEBST	Use (select)
P_DISPEMPSUMMARY	Oracle Package Procedure	S10B80.BANINST1.BWPKFLSM	Rely On
P_DISPEPAFPREVIEW	Oracle Package Procedure	S10B80.BANINST1.BWPKEPAF	Rely On
P_DISPEPAFPREVIEWBODY	Oracle Package Procedure	S10B80.BANINST1.BWPKEPSM	Rely On
P_DISPFILTER	Oracle Package Procedure	S10B80.BANINST1.BWPKLRED	Rely On
P_DISPLAYPROXYSETUP	Oracle Package Procedure	S10B80.BANINST1.BWPKTAIS	Rely On
P_DISPLAYPROXYSETUP	Oracle Package Procedure	S10B80.BANINST1.BWPKTAIS	Use (select)
P_DISPLAYPROXYSETUP	Oracle Package Procedure	S10B80.BANINST1.BWPKLRED	Rely On
P_DISPLAYPROXYSETUP	Oracle Package Procedure	S10B80.BANINST1.BWPKLRED	Use (select)
P_DISPORIGINATORFILTERS	Oracle Package Procedure	S10B80.BANINST1.BWPKEPAF	Rely On
P_DISPORIGINATORSUMMARY	Oracle Package Procedure	S10B80.BANINST1.BWPKEPAF	Rely On
P_DISPORIGINATORSUMMARYBODY	Oracle Package Procedure	S10B80.BANINST1.BWPKEPSM	Rely On
P_DISPPROXYSETUP	Oracle Package Procedure	S10B80.BANINST1.BWPKEPAF	Rely On
P_DISP_COMMENTS	Oracle Package Procedure	S10B80.BANINST1.BWPKEPUT	Rely On
P_DISP_EMP_SUMMARY_BODY	Oracle Package Procedure	S10B80.BANINST1.BWPKFSEM	Rely On
P_DISP_JOB_DETL_BODY	Oracle Package Procedure	S10B80.BANINST1.BWPKFJDT	Rely On
P_DISP_JOB_EARNINGS_BODY	Oracle Package Procedure	S10B80.BANINST1.BWPKFJDT	Rely On
P_DISP_ROUTUSER_LOOKUP	Oracle Package Procedure	S10B80.BANINST1.BWPKEPID	Rely On
P_DISP_SELECTED_FILTERS	Oracle Package Procedure	S10B80.BANINST1.BWPKFSEM	Rely On
P_DOWNLOAD	Oracle Package Procedure	S10B80.BANINST1.BWPKFSEM	Rely On
P_GETACCESSIBLECOLLDEPT	Oracle Package Procedure	S10B80.BANINST1.SOKEPRT	Rely On
P_GETGOBEACCINFO	Oracle Package Procedure	S10B80.BANINST1.GOKEACC	Rely On
P_GETGOBEACCINFO	Oracle Package Procedure	S10B80.BANINST1.GOKEACC	Use (select)
P_GETGRADECHANGEEDATA	Oracle Package Procedure	S10B80.BANINST1.SHKWEVN	Rely On
P_GETWFUSERNAME	Oracle Package Procedure	S10B80.BANINST1.GOKEACC	Rely On
P_GET_EPAF	Oracle Package Procedure	S10B80.BANINST1.BWPCBREF	Rely On
P_GET_GIFT_INFO	Oracle Package Procedure	S10B80.BANINST1.AOKWEVN	Rely On
P_GET_PAF_POSN_INFO	Oracle Package Procedure	S10B80.BANINST1.POKWLIB	Use (select)
P_GET_TIME_APPROVAL	Oracle Package Procedure	S10B80.BANINST1.BWPCBREF	Rely On
P_GET_USER_ID	Oracle Package Procedure	S10B80.BANINST1.PEKTECM	Rely On
P_GET_USER_ID	Oracle Package Procedure	S10B80.BANINST1.PEKTECM	Use (select)
P_INSERT_FILTERED_DATA	Oracle Package Procedure	S10B80.BANINST1.BWPKFLTR	Rely On
P_INSERT_NBTFPRM	Oracle Package Procedure	S10B80.BANINST1.BWPKFLTR	Rely On
P_INSERT_NBTFPRM_MULTIPLE	Oracle Package Procedure	S10B80.BANINST1.BWPKFLTR	Rely On
P_INSERT_NBTORSF	Oracle Package Procedure	S10B80.BANINST1.BWPKFLTR	Rely On
P_INSERT_NBTORSF_EMPSRCH	Oracle Package Procedure	S10B80.BANINST1.BWPKFLTR	Rely On
P_INSERT_SELECTED_ORGNS	Oracle Package Procedure	S10B80.BANINST1.BWPKFLTR	Rely On
P_JSCRIPT_FILL_USRNAME_ARRAY	Oracle Package Procedure	S10B80.BANINST1.BWPKOJSR	Use (select)
P_MODIFY_USER	Oracle Package Procedure	S10B80.BANINST1.GP_UDC_USER_PROVISIONING	Use (delete)
P_NEXT_APPROVER	Oracle Package Procedure	S10B80.BANINST1.NOKMISC	Use (select)
P_OPEN_APPROVAL_RC	Oracle Package Procedure	S10B80.BANINST1.BWPKEPLK	Rely On
P_OPEN_APPROVAL_RC	Oracle Package Procedure	S10B80.BANINST1.NOKEPAF	Rely On
P_OPEN_ORIGINATOR_RC	Oracle Package Procedure	S10B80.BANINST1.BWPKEPLK	Rely On
P_OPEN_ORIGINATOR_RC	Oracle Package Procedure	S10B80.BANINST1.NOKEPAF	Rely On
P_PRINT_APPR_LEVL	Oracle Package Procedure	S10B80.BANINST1.BWPKEPID	Rely On
P_PRINT_CONTRACT_NOTES	Oracle Package Procedure	S10B80.BANINST1.BWPKFMSC	Rely On
P_PRINT_CRSE_CALC_DETL	Oracle Package Procedure	S10B80.BANINST1.BWPKFCPT	Rely On
P_PRINT_EMP_ERRORS	Oracle Package Procedure	S10B80.BANINST1.BWPKFMSC	Rely On
P_PRINT_EMP_SEARCH_RESULTS	Oracle Package Procedure	S10B80.BANINST1.BWPKFLTR	Rely On
P_PRINT_EPAF_DETL	Oracle Package Procedure	S10B80.BANINST1.BWPKEPDT	Rely On
P_PRINT_EPAF_ENTRIES	Oracle Package Procedure	S10B80.BANINST1.BWPKEPDT	Rely On
P_PRINT_FILTERS	Oracle Package Procedure	S10B80.BANINST1.BWPKFLTR	Rely On
P_PRINT_JOBLABORDIST	Oracle Package Procedure	S10B80.BANINST1.BWPKFJLD	Rely On
P_PRINT_ORGANIZATIONS	Oracle Package Procedure	S10B80.BANINST1.BWPKFSOR	Rely On
P_PRINT_PROXY_SETUP	Oracle Package Procedure	S10B80.BANINST1.BWPKEPID	Rely On
P_PRINT_PROXY_SETUP	Oracle Package Procedure	S10B80.BANINST1.BWPKEPID	Use (select)
P_PRINT_TRANS_HIST	Oracle Package Procedure	S10B80.BANINST1.BWPKEPUT	Rely On
P_PROCPROXYSETUP	Oracle Package Procedure	S10B80.BANINST1.BWPKTAIS	Use (select)
P_PROCPROXYSETUP	Oracle Package Procedure	S10B80.BANINST1.BWPKLRED	Use (select)
P_PROCSELECTLEAVEREPORTROLL	Oracle Package Procedure	S10B80.BANINST1.BWPKTAIS	Rely On
P_PROCSELECTLEAVEREPORTROLL	Oracle Package Procedure	S10B80.BANINST1.BWPKLRED	Rely On
P_PROCSELECTLEAVEREQUESTROLL	Oracle Package Procedure	S10B80.BANINST1.BWPKTAIS	Rely On
P_PROCSELECTLEAVEREQUESTROLL	Oracle Package Procedure	S10B80.BANINST1.BWPKLRED	Rely On
P_PROCSELECTSUPERUSERACTION	Oracle Package Procedure	S10B80.BANINST1.BWPKTAIS	Rely On
P_PROCSELECTSUPERUSERACTION	Oracle Package Procedure	S10B80.BANINST1.BWPKLRED	Rely On
P_PROCSELECTTIMESHEETROLL	Oracle Package Procedure	S10B80.BANINST1.BWPKTAIS	Rely On
P_PROCSELECTTIMESHEETROLL	Oracle Package Procedure	S10B80.BANINST1.BWPKLRED	Rely On
P_RESTART	Oracle Package Procedure	S10B80.BANINST1.BWPKFSEM	Rely On
P_SAVE_COMMENTS	Oracle Package Procedure	S10B80.BANINST1.BWPKFMSC	Rely On
P_SECURELOGIN	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Use (select)
P_SELECTAPPROVERFILTERSBODY	Oracle Package Procedure	S10B80.BANINST1.BWPKEPSM	Rely On
P_SELECTAPPROVERSUMMARY	Oracle Package Procedure	S10B80.BANINST1.BWPKEPAF	Rely On
P_SELECTAPPROVERSUMMARYBODY	Oracle Package Procedure	S10B80.BANINST1.BWPKEPSM	Rely On
P_SELECTLEAVEREPORTROLL	Oracle Package Procedure	S10B80.BANINST1.BWPKTAIS	Rely On
P_SELECTLEAVEREPORTROLL	Oracle Package Procedure	S10B80.BANINST1.BWPKLRED	Rely On
P_SELECTLEAVEREQUESTROLL	Oracle Package Procedure	S10B80.BANINST1.BWPKTAIS	Rely On
P_SELECTLEAVEREQUESTROLL	Oracle Package Procedure	S10B80.BANINST1.BWPKLRED	Rely On
P_SELECTORIGINATORFILTERS	Oracle Package Procedure	S10B80.BANINST1.BWPKEPAF	Rely On
P_SELECTORIGINATORFILTERSBODY	Oracle Package Procedure	S10B80.BANINST1.BWPKEPSM	Rely On
P_SELECTORIGINATORSUMMARY	Oracle Package Procedure	S10B80.BANINST1.BWPKEPAF	Rely On
P_SELECTORIGINATORSUMMARYBODY	Oracle Package Procedure	S10B80.BANINST1.BWPKEPSM	Rely On
P_SELECTTIMESHEETROLL	Oracle Package Procedure	S10B80.BANINST1.BWPKTAIS	Rely On
P_SELECTTIMESHEETROLL	Oracle Package Procedure	S10B80.BANINST1.BWPKLRED	Rely On
P_SUBMIT_TRANSACTION	Oracle Package Procedure	S10B80.BANINST1.BWPKEPDT	Rely On
P_UPDATEEPAFPREVIEW	Oracle Package Procedure	S10B80.BANINST1.BWPKEPAF	Rely On
P_UPDATEEPAFPREVIEWBODY	Oracle Package Procedure	S10B80.BANINST1.BWPKEPSM	Rely On
P_UPDATESTUDENTGRADE	Oracle Package Procedure	S10B80.BANINST1.SHKWEVN	Rely On
P_UPDATE_COMMENTS	Oracle Package Procedure	S10B80.BANINST1.BWPKEPID	Rely On
P_UPDATE_JOBLABORDIST	Oracle Package Procedure	S10B80.BANINST1.BWPKFJLD	Rely On
P_UPDT_CRSE_CALC_DETL	Oracle Package Procedure	S10B80.BANINST1.BWPKFCPT	Rely On
P_UPD_LEAVE_BALANCE	Oracle Package Procedure	S10B80.BANINST1.PEKLEAV	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.NB_PROXY_RULES	Use (select)
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.NB_EFFCERT_ADDL_QUEUE_RULES	Use (select)
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.NB_QUEUE_GROUP_RULES	Use (select)
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.NB_EA_GROUP_USER_RULES	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.NB_EA_GROUP_USER_RULES	Use (select)Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.NB_REDISTR_ADDL_QUEUE_RULES	Use (select)
P_VALIDATE_DUPLICATECHECK	Oracle Package Procedure	S10B80.BANINST1.BWPKEPCR	Rely On
P_VALIDATE_ORIG_ACTION_IND	Oracle Package Procedure	S10B80.BANINST1.NOKEPAF	Rely On
P_VALIDATE_ROUTING_QUEUE	Oracle Package Procedure	S10B80.BANINST1.PEKTEVT	Rely On
P_VALIDATE_USER	Oracle Package Procedure	S10B80.BANINST1.PEKTEVT	Rely On
P_WFEDEVNT	Oracle Package Procedure	S10B80.BANINST1.GOKSEVN	Rely On
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_NB_EA_GROUP_USER	Use (select)
F_ADV_PROSPECT_COUNT	Oracle Package Function	S10B80.BANINST1.BWACXALU	Use (select)
F_ADV_PROSPECT_ROWNUM	Oracle Package Function	S10B80.BANINST1.BWACXALU	Use (select)
F_ALERT_XML	Oracle Package Function	S10B80.BANINST1.BWFCXCHN	Rely On
F_ALERT_XML	Oracle Package Function	S10B80.BANINST1.BWFCXCHN	Use (select)
F_CHECK_ASSIGN_CHANGES	Oracle Package Function	S10B80.BANINST1.BWPKFSEM	Rely On
F_CHECK_MORE_ASSGN_EXISTS	Oracle Package Function	S10B80.BANINST1.BWPKFSEM	Rely On
F_CREATE_USER	Oracle Package Function	S10B80.BANINST1.GP_UDC_USER_PROVISIONING	Use (Insert)
F_FINALERT_SUM	Oracle Package Function	S10B80.BANINST1.BWFCBREF	Rely On
F_FINALERT_SUM	Oracle Package Function	S10B80.BANINST1.CHNLSKBL	Rely On
F_FINALERT_TOTAL	Oracle Package Function	S10B80.BANINST1.BWFCBREF	Rely On
F_FIND_PII_DOMAIN	Oracle Package Function	S10B80.BANINST1.GOKFGAC	Rely On
F_FIND_PII_DOMAIN	Oracle Package Function	S10B80.BANINST1.GOKFGAC	Use (select)
F_FIN_ALERT	Oracle Package Function	S10B80.BANINST1.CHNLSKXM	Rely On
F_FIN_ALERT	Oracle Package Function	S10B80.BANINST1.CHNLSKXM	Use (select)
F_GETPIDM	Oracle Package Function	S10B80.BANINST1.SOKEPRT	Use (select)
F_GETSPRIDENNAME	Oracle Package Function	S10B80.BANINST1.GOKEDVD	Use (select)
F_GETUSER	Oracle Package Function	S10B80.BANINST1.GOKEDVD	Rely On
F_GETUSER	Oracle Package Function	S10B80.BANINST1.GOKEDVD	Use (select)
F_GETUSERID	Oracle Package Function	S10B80.BANINST1.BWFKUAPP	Rely On
F_GETUSERID	Oracle Package Function	S10B80.BANINST1.BWFKUAPP	Use (select)
F_GETUSERNAME	Oracle Package Function	S10B80.BANINST1.BWLKILIB	Use (select)
F_GETUSERNAME	Oracle Package Function	S10B80.BANINST1.BWPCBREF	Rely On
F_GETUSERSPRIDENNAME	Oracle Package Function	S10B80.BANINST1.GOKEDVD	Rely On
F_GETUSERSPRIDENNAME	Oracle Package Function	S10B80.BANINST1.GOKEDVD	Use (select)
F_GET_APID_LIST	Oracle Package Function	S10B80.BANINST1.GB_GOBAPID	Use (select)
F_GET_APID_MAP	Oracle Package Function	S10B80.BANINST1.GB_GOBAPID	Use (select)
F_GET_EPAF_DEFAULT	Oracle Package Function	S10B80.BANINST1.BWPCXCHN	Rely On
F_GET_FINALERT	Oracle Package Function	S10B80.BANINST1.CHNLSKBL	Rely On
F_GET_MOVES	Oracle Package Function	S10B80.BANINST1.BWACBREF	Use (select)
F_GET_PROSPECTS_XML	Oracle Package Function	S10B80.BANINST1.XCHAPERS	Use (select)
F_GET_TIME_APPROVAL	Oracle Package Function	S10B80.BANINST1.BWPCXCHN	Rely On
F_GOBEACC_MAP	Oracle Package Function	S10B80.BANINST1.GOKSSSO	Rely On
F_GOBEACC_MAP	Oracle Package Function	S10B80.BANINST1.GOKSSSO	Use (select)
F_GOBEACC_MAP_ID	Oracle Package Function	S10B80.BANINST1.GOKSSSO	Rely On
F_GOBEACC_MAP_ID	Oracle Package Function	S10B80.BANINST1.GOKSSSO	Use (select)
F_GRANTS_XML	Oracle Package Function	S10B80.BANINST1.BWFCXCHN	Rely On
F_OPEN_NTRPROX	Oracle Package Function	S10B80.BANINST1.NOKEPCR	Use (select)
F_ORIG_ACTION_ALLOWED_IND	Oracle Package Function	S10B80.BANINST1.NOKEPAF	Rely On
F_ROUTING_ACTION_IND	Oracle Package Function	S10B80.BANINST1.NOKEPAF	Rely On
F_ROUTING_REC	Oracle Package Function	S10B80.BANINST1.NOKEPAF	Rely On
F_ROUT_ROWID	Oracle Package Function	S10B80.BANINST1.BWPCBREF	Rely On
F_SELECT_NBTFPRM	Oracle Package Function	S10B80.BANINST1.PEKFLAC	Rely On
F_SELECT_NBTFPRM	Oracle Package Function	S10B80.BANINST1.BWPKFLTR	Rely On
F_USERHASSIRDPCLREC	Oracle Package Function	S10B80.BANINST1.SOKEPRT	Rely On
F_USERNAME	Oracle Package Function	S10B80.BANINST1.GOKEACC	Use (select)
F_VALIDATECRN	Oracle Package Function	S10B80.BANINST1.SSKWEVN	Rely On
F_VALIDATECRN	Oracle Package Function	S10B80.BANINST1.SSKWEVN	Use (select)
F_VALIDATESPRIDENID	Oracle Package Function	S10B80.BANINST1.GOKEDVD	Rely On
F_VALIDATESPRIDENID	Oracle Package Function	S10B80.BANINST1.GOKEDVD	Use (select)
F_VALIDATEUSER	Oracle Package Function	S10B80.BANINST1.GOKEDVD	Rely On
F_VALIDATEUSER	Oracle Package Function	S10B80.BANINST1.GOKEDVD	Use (select)
F_VALIDUSER	Oracle Package Function	S10B80.WTAILOR.TWBKWBIS	Rely On
F_VALIDUSER	Oracle Package Function	S10B80.WTAILOR.TWBKWBIS	Use (select)
G$_GET_USERNAME_NAME	Oracle Package Function	S10B80.BANSECR.G$_SECURITY_PKG	Use (select)
GOBEACC	Oracle Synonym	S10B80.PUBLIC	Rely On
FOBPROF	SQL Table	S10B80.FIMSMGR	Join

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GOBEACC_KEY_INDEX	SQL Index	S10B80.GENERAL	Rely On
PK_GOBEACC	SQL Index	S10B80.GENERAL	Rely On
NTRPROX	SQL Table	S10B80.POSNCTL	Join
GT_GOBEACC_AUDIT_ROW	SQL Trigger	S10B80.BANSECR	Fire (Insert,update,delete,after,each row)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GOBEACC

Object Dates

Creation Date	Analysis Date
04/02/2008 20:32:08:000	04/02/2008 21:17:56:000

Source Code Comments

Enterprise Oracle Access Table

Columns Comments for GOBEACC_PIDM (# 1)

Source Code Comments

System generated unique PIDM associated with user.

Columns Comments for GOBEACC_USERNAME (# 2)

Source Code Comments

Oracle user ID.

Columns Comments for GOBEACC_USER_ID (# 3)

Source Code Comments

Current User, system updated.

Columns Comments for GOBEACC_ACTIVITY_DATE (# 4)

Source Code Comments

System date of insert or update.

Table GOBPCRL

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GOBPCRL_VOBJ_CODE	VARCHAR2(15)	No	*	*
GOBPCRL_VAPP_CODE	VARCHAR2(15)	No	*	*
GOBPCRL_PATTERN_CTRL	NUMBER(4,0)	No	*
GOBPCRL_ACTIVITY_DATE	DATE	No
GOBPCRL_TABLE_NAME	VARCHAR2(30)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GOBPCRL_VAPP_CODE	GTVVAPP_CODE	GTVVAPP
GOBPCRL_VOBJ_CODE	GTVVOBJ_CODE	GTVVOBJ

Index

Index Name	Index Type	Column Name
PK_GOBPCRL	Unique	GOBPCRL_VOBJ_CODE
PK_GOBPCRL	Unique	GOBPCRL_VAPP_CODE
PK_GOBPCRL	Unique	GOBPCRL_PATTERN_CTRL

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GOBPCRL	SQL Index	S10B80.GENERAL	Rely On
GTVVAPP	SQL Table	S10B80.GENERAL	Refer (no action)
GTVVOBJ	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GOBPCRL

Object Dates

Creation Date	Analysis Date
04/02/2008 20:29:43:000	04/02/2008 21:17:53:000

Source Code Comments

VBS Secured Item Pattern Control

Columns Comments for GOBPCRL_VOBJ_CODE (# 1)

Source Code Comments

VBS Object Code

Columns Comments for GOBPCRL_VAPP_CODE (# 2)

Source Code Comments

VBS Secured Item Code

Columns Comments for GOBPCRL_PATTERN_CTRL (# 3)

Source Code Comments

VBS Secured Item Pattern Control Seed Number

Columns Comments for GOBPCRL_ACTIVITY_DATE (# 4)

Source Code Comments

Date of Insert or Last Update

Columns Comments for GOBPCRL_TABLE_NAME (# 5)

Source Code Comments

Table to validate against

Table GOBSEGC

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GOBSEGC_SEGC_CODE	VARCHAR2(15)	No	*	*
GOBSEGC_EFF_DATE	DATE	No
GOBSEGC_ACTIVE_IND	VARCHAR2(1)	No
GOBSEGC_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
GOBSEGC_SEGC_CODE	GTVSEGC_CODE	GTVSEGC

Index

Index Name	Index Type	Column Name
PK_GOBSEGC	Unique	GOBSEGC_SEGC_CODE

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GOBSEGC	SQL Index	S10B80.GENERAL	Rely On
GTVSEGC	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GOBSEGC

Object Dates

Creation Date	Analysis Date
04/02/2008 20:32:04:000	04/02/2008 21:17:56:000

Source Code Comments

Access Group Base

Columns Comments for GOBSEGC_SEGC_CODE (# 1)

Source Code Comments

Access Group Code

Columns Comments for GOBSEGC_EFF_DATE (# 2)

Source Code Comments

Access Group Effective Date

Columns Comments for GOBSEGC_ACTIVE_IND (# 3)

Source Code Comments

Access Group Active Indicator

Columns Comments for GOBSEGC_ACTIVITY_DATE (# 4)

Source Code Comments

Date of Insert or Last Update

Table GOBVBSC

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL
GOBVBSC_VBS_IND	VARCHAR2(1)	No
GOBVBSC_VBS_ON_DATE	DATE	No
GOBVBSC_VBS_SUSPEND_IND	VARCHAR2(1)	No
GOBVBSC_VBS_SUSPEND_DATE	DATE	No
GOBVBSC_USER_ID	VARCHAR2(30)	No
GOBVBSC_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

No Result

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GOBVBSC

Object Dates

Creation Date	Analysis Date
04/02/2008 20:31:01:000	04/02/2008 21:17:54:000

Source Code Comments

VBS Application Control

Columns Comments for GOBVBSC_VBS_IND (# 1)

Source Code Comments

Indicates VBS is Active

Columns Comments for GOBVBSC_VBS_ON_DATE (# 2)

Source Code Comments

Date VBS State was Altered

Columns Comments for GOBVBSC_VBS_SUSPEND_IND (# 3)

Source Code Comments

Indicates VBS is Suspended

Columns Comments for GOBVBSC_VBS_SUSPEND_DATE (# 4)

Source Code Comments

Date VBS Suspension State was Altered

Columns Comments for GOBVBSC_USER_ID (# 5)

Source Code Comments

User ID Last Modifying VBS State

Columns Comments for GOBVBSC_ACTIVITY_DATE (# 6)

Source Code Comments

Date of Insert or Last Update

Table GOBVCRL

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GOBVCRL_USER_ID	VARCHAR2(30)	No	*
GOBVCRL_BACR_SEQNO	NUMBER(8,0)	No	*	*
GOBVCRL_VAPP_CODE_MODULE	VARCHAR2(15)	No	*
GOBVCRL_ACCESS_CNT	NUMBER(4,0)	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
GOBVCRL_BACR_SEQNO	GOBBACR_SEQNO	GOBBACR

Index

Index Name	Index Type	Column Name
PK_GOBVCRL	Unique	GOBVCRL_USER_ID
PK_GOBVCRL	Unique	GOBVCRL_BACR_SEQNO
PK_GOBVCRL	Unique	GOBVCRL_VAPP_CODE_MODULE

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GOBVCRL	SQL Index	S10B80.GENERAL	Rely On
GOBBACR	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GOBVCRL

Object Dates

Creation Date	Analysis Date
04/02/2008 20:31:48:000	04/02/2008 21:17:55:000

Source Code Comments

VBS Access Rule Control

Columns Comments for GOBVCRL_USER_ID (# 1)

Source Code Comments

ORACLE User ID

Columns Comments for GOBVCRL_BACR_SEQNO (# 2)

Source Code Comments

Access Rule Sequence Number

Columns Comments for GOBVCRL_VAPP_CODE_MODULE (# 3)

Source Code Comments

Module

Columns Comments for GOBVCRL_ACCESS_CNT (# 4)

Source Code Comments

Access count

Table GOBVUSR

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GOBVUSR_USER_ID	VARCHAR2(30)	No	*
GOBVUSR_ACTIVE_IND	VARCHAR2(1)	No
GOBVUSR_EFF_DATE	DATE	No
GOBVUSR_ADMIN_IND	VARCHAR2(1)	No
GOBVUSR_MGR_IND	VARCHAR2(1)	No
GOBVUSR_ACTIVITY_DATE	DATE	No
GOBVUSR_EXPIRE_DATE	DATE	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GOBVUSR	Unique	GOBVUSR_USER_ID

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GOBVUSR	SQL Index	S10B80.GENERAL	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GOBVUSR

Object Dates

Creation Date	Analysis Date
04/02/2008 20:28:12:000	04/02/2008 21:17:51:000

Source Code Comments

VBS User Profile Base

Columns Comments for GOBVUSR_USER_ID (# 1)

Source Code Comments

ORACLE User ID

Columns Comments for GOBVUSR_ACTIVE_IND (# 2)

Source Code Comments

Indicates VBS User Profile is Active

Columns Comments for GOBVUSR_EFF_DATE (# 3)

Source Code Comments

Indicates Effective Date of VBS User Profile

Columns Comments for GOBVUSR_ADMIN_IND (# 4)

Source Code Comments

Indicates the VBS User to be an Access Group Administrator

Columns Comments for GOBVUSR_MGR_IND (# 5)

Source Code Comments

Indicates the VBS User to be an Access Group Manager

Columns Comments for GOBVUSR_ACTIVITY_DATE (# 6)

Source Code Comments

Date of Insert or Last Update

Columns Comments for GOBVUSR_EXPIRE_DATE (# 7)

Source Code Comments

Indicates Expiration Date of VBS USer Profile

Table GORGMGR

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GORGMGR_SEGC_CODE	VARCHAR2(15)	No	*	*
GORGMGR_USER_ID	VARCHAR2(30)	No	*
GORGMGR_EFF_DATE	DATE	No
GORGMGR_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
GORGMGR_SEGC_CODE	GTVSEGC_CODE	GTVSEGC

Index

Index Name	Index Type	Column Name
PK_GORGMGR	Unique	GORGMGR_SEGC_CODE
PK_GORGMGR	Unique	GORGMGR_USER_ID

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GORGMGR	SQL Index	S10B80.GENERAL	Rely On
GTVSEGC	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GORGMGR

Object Dates

Creation Date	Analysis Date
04/02/2008 20:31:51:000	04/02/2008 21:17:55:000

Source Code Comments

Access Group Management Control

Columns Comments for GORGMGR_SEGC_CODE (# 1)

Source Code Comments

Access Group Code

Columns Comments for GORGMGR_USER_ID (# 2)

Source Code Comments

ORACLE User ID

Columns Comments for GORGMGR_EFF_DATE (# 3)

Source Code Comments

Effective Date of VBS User

Columns Comments for GORGMGR_ACTIVITY_DATE (# 4)

Source Code Comments

Date of Insert or Last Update

Table GORGMSK

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GORGMSK_SEGC_CODE	VARCHAR2(15)	No	*	*
GORGMSK_VOBJ_CODE	VARCHAR2(15)	No	*	*
GORGMSK_VAPP_CODE	VARCHAR2(15)	No	*	*
GORGMSK_ACTIVITY_DATE	DATE	No
GORGMSK_VAPP_VALUE	VARCHAR2(15)	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
GORGMSK_SEGC_CODE	GTVSEGC_CODE	GTVSEGC
GORGMSK_VAPP_CODE	GTVVAPP_CODE	GTVVAPP
GORGMSK_VOBJ_CODE	GTVVOBJ_CODE	GTVVOBJ

Index

Index Name	Index Type	Column Name
PK_GORGMSK	Unique	GORGMSK_SEGC_CODE
PK_GORGMSK	Unique	GORGMSK_VOBJ_CODE
PK_GORGMSK	Unique	GORGMSK_VAPP_CODE

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GORGMSK	SQL Index	S10B80.GENERAL	Rely On
GTVSEGC	SQL Table	S10B80.GENERAL	Refer (no action)
GTVVAPP	SQL Table	S10B80.GENERAL	Refer (no action)
GTVVOBJ	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GORGMSK

Object Dates

Creation Date	Analysis Date
04/02/2008 20:32:03:000	04/02/2008 21:17:56:000

Source Code Comments

Access Group Rule Assignment Mask

Columns Comments for GORGMSK_SEGC_CODE (# 1)

Source Code Comments

Access Group Code

Columns Comments for GORGMSK_VOBJ_CODE (# 2)

Source Code Comments

VBS Object Code

Columns Comments for GORGMSK_VAPP_CODE (# 3)

Source Code Comments

VBS Secured Item Code

Columns Comments for GORGMSK_ACTIVITY_DATE (# 4)

Source Code Comments

Date of Insert or Last Update

Columns Comments for GORGMSK_VAPP_VALUE (# 5)

Source Code Comments

Secured Item Mask Value

Table GORGRUL

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GORGRUL_SEGC_CODE	VARCHAR2(15)	No	*	*
GORGRUL_BACR_SEQNO	NUMBER(8,0)	No	*
GORGRUL_ADD_DATE	DATE	No
GORGRUL_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
GORGRUL_SEGC_CODE	GTVSEGC_CODE	GTVSEGC

Index

Index Name	Index Type	Column Name
PK_GORGRUL	Unique	GORGRUL_SEGC_CODE
PK_GORGRUL	Unique	GORGRUL_BACR_SEQNO

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GORGRUL	SQL Index	S10B80.GENERAL	Rely On
GTVSEGC	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GORGRUL

Object Dates

Creation Date	Analysis Date
04/02/2008 20:30:03:000	04/02/2008 21:17:53:000

Source Code Comments

Access Group Rule Association

Columns Comments for GORGRUL_SEGC_CODE (# 1)

Source Code Comments

Access Group Code

Columns Comments for GORGRUL_BACR_SEQNO (# 2)

Source Code Comments

Access Rule Sequence Number

Columns Comments for GORGRUL_ADD_DATE (# 3)

Source Code Comments

Rule Association Add Date

Columns Comments for GORGRUL_ACTIVITY_DATE (# 4)

Source Code Comments

Date of Insert or Last Update

Table GORGUSR

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GORGUSR_SEGC_CODE	VARCHAR2(15)	No	*	*
GORGUSR_USER_ID	VARCHAR2(30)	No	*
GORGUSR_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
GORGUSR_SEGC_CODE	GTVSEGC_CODE	GTVSEGC

Index

Index Name	Index Type	Column Name
PK_GORGUSR	Unique	GORGUSR_SEGC_CODE
PK_GORGUSR	Unique	GORGUSR_USER_ID

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GORGUSR	SQL Index	S10B80.GENERAL	Rely On
GTVSEGC	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GORGUSR

Object Dates

Creation Date	Analysis Date
04/02/2008 20:32:31:000	04/02/2008 21:17:56:000

Source Code Comments

Access Group User Association

Columns Comments for GORGUSR_SEGC_CODE (# 1)

Source Code Comments

Access Group Code

Columns Comments for GORGUSR_USER_ID (# 2)

Source Code Comments

ORACLE User ID

Columns Comments for GORGUSR_ACTIVITY_DATE (# 3)

Source Code Comments

Date of Insert or Last Update

Table GORRAVL

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GORRAVL_VOBJ_CODE	VARCHAR2(15)	No	*	*
GORRAVL_BACR_SEQNO	NUMBER(8,0)	No	*
GORRAVL_VAPP_CODE	VARCHAR2(15)	No	*	*
GORRAVL_PATTERN_CTRL	NUMBER(4,0)	No
GORRAVL_ACTIVITY_DATE	DATE	No
GORRAVL_VAPP_VALUE	VARCHAR2(15)	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
GORRAVL_VAPP_CODE	GTVVAPP_CODE	GTVVAPP
GORRAVL_VOBJ_CODE	GTVVOBJ_CODE	GTVVOBJ

Index

Index Name	Index Type	Column Name
PK_GORRAVL	Unique	GORRAVL_VOBJ_CODE
PK_GORRAVL	Unique	GORRAVL_BACR_SEQNO
PK_GORRAVL	Unique	GORRAVL_VAPP_CODE

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GORRAVL	SQL Index	S10B80.GENERAL	Rely On
GTVVAPP	SQL Table	S10B80.GENERAL	Refer (no action)
GTVVOBJ	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GORRAVL

Object Dates

Creation Date	Analysis Date
04/02/2008 20:30:06:000	04/02/2008 21:17:53:000

Source Code Comments

VBS Access Rule Secured Values

Columns Comments for GORRAVL_VOBJ_CODE (# 1)

Source Code Comments

VBS Object Code

Columns Comments for GORRAVL_BACR_SEQNO (# 2)

Source Code Comments

Access Rule Sequence Number

Columns Comments for GORRAVL_VAPP_CODE (# 3)

Source Code Comments

VBS Secured Item Code

Columns Comments for GORRAVL_PATTERN_CTRL (# 4)

Source Code Comments

VBS PAttern Control Seed Number

Columns Comments for GORRAVL_ACTIVITY_DATE (# 5)

Source Code Comments

Date of Insert or Last Update

Columns Comments for GORRAVL_VAPP_VALUE (# 6)

Source Code Comments

VBS Secured Item Value

Table GORTCRL

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
GORTCRL_USER_ID	VARCHAR2(30)	No
GORTCRL_VAPP_CODE_MODULE	VARCHAR2(15)	No	*
GORTCRL_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
GORTCRL_VAPP_CODE_MODULE	GTVVAPP_CODE	GTVVAPP

Index

No Result

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GTVVAPP	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GORTCRL

Object Dates

Creation Date	Analysis Date
04/02/2008 20:30:11:000	04/02/2008 21:17:53:000

Source Code Comments

User ID table

Columns Comments for GORTCRL_USER_ID (# 1)

Source Code Comments

User ID

Columns Comments for GORTCRL_VAPP_CODE_MODULE (# 2)

Source Code Comments

VBS Secured Item Code Model

Columns Comments for GORTCRL_ACTIVITY_DATE (# 3)

Source Code Comments

Date of Insert or Last Update

Table GORVGAC

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GORVGAC_SEGC_CODE	VARCHAR2(15)	No	*	*
GORVGAC_VOBJ_CODE	VARCHAR2(15)	No	*	*
GORVGAC_BACR_SEQNO	NUMBER(8,0)	No	*
GORVGAC_VBS_ITEM1	VARCHAR2(15)	Yes
GORVGAC_VBS_ITEM2	VARCHAR2(15)	Yes
GORVGAC_VBS_ITEM3	VARCHAR2(15)	Yes
GORVGAC_VBS_ITEM4	VARCHAR2(15)	Yes
GORVGAC_VBS_ITEM5	VARCHAR2(15)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GORVGAC_SEGC_CODE	GTVSEGC_CODE	GTVSEGC
GORVGAC_VOBJ_CODE	GTVVOBJ_CODE	GTVVOBJ

Index

Index Name	Index Type	Column Name
PK_GORVGAC	Unique	GORVGAC_SEGC_CODE
PK_GORVGAC	Unique	GORVGAC_VOBJ_CODE
PK_GORVGAC	Unique	GORVGAC_BACR_SEQNO

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GORVGAC	SQL Index	S10B80.GENERAL	Rely On
GTVSEGC	SQL Table	S10B80.GENERAL	Refer (no action)
GTVVOBJ	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GORVGAC

Object Dates

Creation Date	Analysis Date
04/02/2008 20:31:47:000	04/02/2008 21:17:55:000

Source Code Comments

Access Group Rule Control

Columns Comments for GORVGAC_SEGC_CODE (# 1)

Source Code Comments

Access Group Code

Columns Comments for GORVGAC_VOBJ_CODE (# 2)

Source Code Comments

VBS Object Code

Columns Comments for GORVGAC_BACR_SEQNO (# 3)

Source Code Comments

Access Rule Sequence Number

Columns Comments for GORVGAC_VBS_ITEM1 (# 4)

Source Code Comments

Program Item Value

Columns Comments for GORVGAC_VBS_ITEM2 (# 5)

Source Code Comments

Campus Item Value

Columns Comments for GORVGAC_VBS_ITEM3 (# 6)

Source Code Comments

College Item Value

Columns Comments for GORVGAC_VBS_ITEM4 (# 7)

Source Code Comments

Level Item Value

Columns Comments for GORVGAC_VBS_ITEM5 (# 8)

Source Code Comments

Department Item Value

Table GORVMAC

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GORVMAC_USER_ID	VARCHAR2(30)	No	*
GORVMAC_VAPP_CODE	VARCHAR2(15)	No	*	*
GORVMAC_PATTERN_CTRL	NUMBER(4,0)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GORVMAC_VAPP_CODE	GTVVAPP_CODE	GTVVAPP

Index

Index Name	Index Type	Column Name
PK_GORVMAC	Unique	GORVMAC_USER_ID
PK_GORVMAC	Unique	GORVMAC_VAPP_CODE

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GORVMAC	SQL Index	S10B80.GENERAL	Rely On
GTVVAPP	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GORVMAC

Object Dates

Creation Date	Analysis Date
04/02/2008 20:30:24:000	04/02/2008 21:17:53:000

Source Code Comments

VBS User Module Access Control

Columns Comments for GORVMAC_USER_ID (# 1)

Source Code Comments

ORACLE User ID

Columns Comments for GORVMAC_VAPP_CODE (# 2)

Source Code Comments

VBS Module Code

Columns Comments for GORVMAC_PATTERN_CTRL (# 3)

Source Code Comments

Module Access Pattern Control Seed Number

Table GORVMGA

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
GORVMGA_PIDM	NUMBER(8,0)	No
GORVMGA_VAPP_CODE	VARCHAR2(15)	No	*
GORVMGA_TERM_CODE	VARCHAR2(6)	Yes
GORVMGA_SEQNO	NUMBER(4,0)	Yes
GORVMGA_PROGRAM_1	VARCHAR2(12)	Yes
GORVMGA_CAMP_CODE_1	VARCHAR2(3)	Yes
GORVMGA_COLL_CODE_1	VARCHAR2(2)	Yes
GORVMGA_LEVL_CODE_1	VARCHAR2(2)	Yes
GORVMGA_DEPT_CODE_11	VARCHAR2(4)	Yes
GORVMGA_DEPT_CODE_12	VARCHAR2(4)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GORVMGA_VAPP_CODE	GTVVAPP_CODE	GTVVAPP

Index

Index Name	Index Type	Column Name
GORVMGA_KEY_INDEX	Unique	GORVMGA_PIDM
GORVMGA_KEY_INDEX	Unique	GORVMGA_VAPP_CODE
GORVMGA_KEY_INDEX	Unique	GORVMGA_TERM_CODE
GORVMGA_KEY_INDEX	Unique	GORVMGA_SEQNO

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GORVMGA_KEY_INDEX	SQL Index	S10B80.GENERAL	Rely On
GTVVAPP	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GORVMGA

Object Dates

Creation Date	Analysis Date
04/02/2008 20:30:39:000	04/02/2008 21:17:54:000

Source Code Comments

VBS Person Secured Items

Columns Comments for GORVMGA_PIDM (# 1)

Source Code Comments

Persons PIDM Value

Columns Comments for GORVMGA_VAPP_CODE (# 2)

Source Code Comments

VBS Module Code

Columns Comments for GORVMGA_TERM_CODE (# 3)

Source Code Comments

Persons Term Code

Columns Comments for GORVMGA_SEQNO (# 4)

Source Code Comments

Curriculum Record Sequence Number

Columns Comments for GORVMGA_PROGRAM_1 (# 5)

Source Code Comments

Program 1 Code

Columns Comments for GORVMGA_CAMP_CODE_1 (# 6)

Source Code Comments

Campus 1 Code

Columns Comments for GORVMGA_COLL_CODE_1 (# 7)

Source Code Comments

College 1 Code

Columns Comments for GORVMGA_LEVL_CODE_1 (# 8)

Source Code Comments

Level 1 Code

Columns Comments for GORVMGA_DEPT_CODE_11 (# 9)

Source Code Comments

Department 1-1 Code

Columns Comments for GORVMGA_DEPT_CODE_12 (# 10)

Source Code Comments

Department 1-2 Code

Table GORVRAC

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GORVRAC_USER_ID	VARCHAR2(30)	No	*
GORVRAC_VOBJ_CODE	VARCHAR2(15)	No	*	*
GORVRAC_BACR_SEQNO	NUMBER(8,0)	No	*	*
GORVRAC_VAPP_CODE_MODULE	VARCHAR2(15)	No	*
GORVRAC_ACTIVE_IND	VARCHAR2(1)	No
GORVRAC_EFF_DATE	DATE	No
GORVRAC_ACTIVITY_DATE	DATE	No
GORVRAC_EXPIRE_DATE	DATE	Yes
GORVRAC_VBS_ITEM1	VARCHAR2(15)	Yes
GORVRAC_VBS_ITEM2	VARCHAR2(15)	Yes
GORVRAC_VBS_ITEM3	VARCHAR2(15)	Yes
GORVRAC_VBS_ITEM4	VARCHAR2(15)	Yes
GORVRAC_VBS_ITEM5	VARCHAR2(15)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GORVRAC_BACR_SEQNO	GOBBACR_SEQNO	GOBBACR
GORVRAC_VOBJ_CODE	GTVVOBJ_CODE	GTVVOBJ

Index

Index Name	Index Type	Column Name
PK_GORVRAC	Unique	GORVRAC_USER_ID
PK_GORVRAC	Unique	GORVRAC_VOBJ_CODE
PK_GORVRAC	Unique	GORVRAC_BACR_SEQNO
PK_GORVRAC	Unique	GORVRAC_VAPP_CODE_MODULE

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GORVRAC	SQL Index	S10B80.GENERAL	Rely On
GOBBACR	SQL Table	S10B80.GENERAL	Refer (no action)
GTVVOBJ	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GORVRAC

Object Dates

Creation Date	Analysis Date
04/02/2008 20:28:35:000	04/02/2008 21:17:51:000

Source Code Comments

VBS User Access Rule Control

Columns Comments for GORVRAC_USER_ID (# 1)

Source Code Comments

ORACLE User ID

Columns Comments for GORVRAC_VOBJ_CODE (# 2)

Source Code Comments

VBS Object Code

Columns Comments for GORVRAC_BACR_SEQNO (# 3)

Source Code Comments

Access Rule Sequence Number

Columns Comments for GORVRAC_VAPP_CODE_MODULE (# 4)

Source Code Comments

VBS Module associated with User and Access Rule

Columns Comments for GORVRAC_ACTIVE_IND (# 5)

Source Code Comments

Indicates User is Active

Columns Comments for GORVRAC_EFF_DATE (# 6)

Source Code Comments

Effective Date of Access

Columns Comments for GORVRAC_ACTIVITY_DATE (# 7)

Source Code Comments

Date of Insert or Last Update

Columns Comments for GORVRAC_EXPIRE_DATE (# 8)

Source Code Comments

Expiration Date of Access

Columns Comments for GORVRAC_VBS_ITEM1 (# 9)

Source Code Comments

Program Value

Columns Comments for GORVRAC_VBS_ITEM2 (# 10)

Source Code Comments

Campus Value

Columns Comments for GORVRAC_VBS_ITEM3 (# 11)

Source Code Comments

College Value

Columns Comments for GORVRAC_VBS_ITEM4 (# 12)

Source Code Comments

Level Value

Columns Comments for GORVRAC_VBS_ITEM5 (# 13)

Source Code Comments

Department Value

Table GORVSVR

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GORVSVR_SEGC_CODE	VARCHAR2(15)	No	*	*
GORVSVR_VTBL_CODE	VARCHAR2(8)	No	*	*
GORVSVR_VTBL_VALUE	VARCHAR2(20)	No	*
GORVSVR_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
GORVSVR_SEGC_CODE	GTVSEGC_CODE	GTVSEGC
GORVSVR_VTBL_CODE	GORVTBL_CODE	GORVTBL

Index

Index Name	Index Type	Column Name
PK_GORVSVR	Unique	GORVSVR_SEGC_CODE
PK_GORVSVR	Unique	GORVSVR_VTBL_CODE
PK_GORVSVR	Unique	GORVSVR_VTBL_VALUE

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GORVSVR	SQL Index	S10B80.GENERAL	Rely On
GORVTBL	SQL Table	S10B80.GENERAL	Refer (no action)
GTVSEGC	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GORVSVR

Object Dates

Creation Date	Analysis Date
04/02/2008 20:29:45:000	04/02/2008 21:17:53:000

Source Code Comments

Validation Table VBS Control

Columns Comments for GORVSVR_SEGC_CODE (# 1)

Source Code Comments

Access Group Code

Columns Comments for GORVSVR_VTBL_CODE (# 2)

Source Code Comments

Validation Table Code

Columns Comments for GORVSVR_VTBL_VALUE (# 3)

Source Code Comments

Validation Table Value

Columns Comments for GORVSVR_ACTIVITY_DATE (# 4)

Source Code Comments

Date of Insert or Last Update

Table GORVTBL

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GORVTBL_CODE	VARCHAR2(8)	No	*
GORVTBL_DESC	VARCHAR2(30)	No
GORVTBL_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GORVTBL	Unique	GORVTBL_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GORVSVR	SQL Table	S10B80.GENERAL	Refer (no action)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GORVTBL	SQL Index	S10B80.GENERAL	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GORVTBL

Object Dates

Creation Date	Analysis Date
04/02/2008 20:30:02:000	04/02/2008 21:17:53:000

Source Code Comments

Secured Validation Table Codes

Columns Comments for GORVTBL_CODE (# 1)

Source Code Comments

Validation Table Literal

Columns Comments for GORVTBL_DESC (# 2)

Source Code Comments

Validation Table Description

Columns Comments for GORVTBL_ACTIVITY_DATE (# 3)

Source Code Comments

Date of Insert or Last Update

Table GTVSEGC

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GTVSEGC_CODE	VARCHAR2(15)	No	*
GTVSEGC_DESC	VARCHAR2(30)	No
GTVSEGC_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GTVSEGC	Unique	GTVSEGC_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GOBSEGC	SQL Table	S10B80.GENERAL	Refer (no action)
GORGMGR	SQL Table	S10B80.GENERAL	Refer (no action)
GORGMSK	SQL Table	S10B80.GENERAL	Refer (no action)
GORGRUL	SQL Table	S10B80.GENERAL	Refer (no action)
GORGUSR	SQL Table	S10B80.GENERAL	Refer (no action)
GORVGAC	SQL Table	S10B80.GENERAL	Refer (no action)
GORVSVR	SQL Table	S10B80.GENERAL	Refer (no action)
GTVSEGCC	Oracle Package Cursor	S10B80.BANINST1.GTKSEGC	Use (select)Rely On
GTVSEGC_C	Oracle Package Cursor	S10B80.BANINST1.GB_GTVSEGC	Rely On
GTVSEGC_C	Oracle Package Cursor	S10B80.BANINST1.GB_GTVSEGC	Use (select)Rely On
F_CODE_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_GTVSEGC	Rely On
F_GETGROUPDESCRIPTION	Oracle Package Function	S10B80.BANINST1.GOKEDVD	Rely On
F_GETGROUPDESCRIPTION	Oracle Package Function	S10B80.BANINST1.GOKEDVD	Use (select)
F_GET_DESCRIPTION	Oracle Package Function	S10B80.BANINST1.GB_GTVSEGC	Rely On
GTVSEGC	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GTVSEGC	SQL Index	S10B80.GENERAL	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GTVSEGC

Object Dates

Creation Date	Analysis Date
04/02/2008 20:31:41:000	04/02/2008 21:17:55:000

Source Code Comments

Access Group Validation

Columns Comments for GTVSEGC_CODE (# 1)

Source Code Comments

Access Group Code

Columns Comments for GTVSEGC_DESC (# 2)

Source Code Comments

Access Group Description

Columns Comments for GTVSEGC_ACTIVITY_DATE (# 3)

Source Code Comments

Date or Insert or Last Update

Table GTVVAPP

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GTVVAPP_CODE	VARCHAR2(15)	No	*
GTVVAPP_DESC	VARCHAR2(30)	No
GTVVAPP_VBTY_CODE	VARCHAR2(1)	No
GTVVAPP_PATTERN_CTRL	NUMBER(4,0)	No
GTVVAPP_SYS_REQ_IND	VARCHAR2(1)	No
GTVVAPP_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GTVVAPP	Unique	GTVVAPP_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GOBPCRL	SQL Table	S10B80.GENERAL	Refer (no action)
GORGMSK	SQL Table	S10B80.GENERAL	Refer (no action)
GORRAVL	SQL Table	S10B80.GENERAL	Refer (no action)
GORTCRL	SQL Table	S10B80.GENERAL	Refer (no action)
GORVMAC	SQL Table	S10B80.GENERAL	Refer (no action)
GORVMGA	SQL Table	S10B80.GENERAL	Refer (no action)
GTVVAPPC	Oracle Package Cursor	S10B80.BANINST1.GTKVAPP	Use (select)Rely On
F_GETMODULEDESCRIPTION	Oracle Package Function	S10B80.BANINST1.GOKEDVD	Rely On
F_GETMODULEDESCRIPTION	Oracle Package Function	S10B80.BANINST1.GOKEDVD	Use (select)
GTVVAPP	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GTVVAPP	SQL Index	S10B80.GENERAL	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GTVVAPP

Object Dates

Creation Date	Analysis Date
04/02/2008 20:29:21:000	04/02/2008 21:17:52:000

Source Code Comments

VBS Application Code Values

Columns Comments for GTVVAPP_CODE (# 1)

Source Code Comments

VBS Application Code

Columns Comments for GTVVAPP_DESC (# 2)

Source Code Comments

Application Description

Columns Comments for GTVVAPP_VBTY_CODE (# 3)

Source Code Comments

VBS Application Type Code

Columns Comments for GTVVAPP_PATTERN_CTRL (# 4)

Source Code Comments

Application Pattern Control

Columns Comments for GTVVAPP_SYS_REQ_IND (# 5)

Source Code Comments

System Required Indicator

Columns Comments for GTVVAPP_ACTIVITY_DATE (# 6)

Source Code Comments

Date of Insert or Last Update

Table GTVVBTY

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GTVVBTY_CODE	VARCHAR2(1)	No	*
GTVVBTY_DESC	VARCHAR2(30)	No
GTVVBTY_SYS_REQ_IND	VARCHAR2(1)	No
GTVVBTY_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GTVVBTY	Unique	GTVVBTY_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GTVVBTYC	Oracle Package Cursor	S10B80.BANINST1.GTKVBTY	Use (select)Rely On
GTVVBTY	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GTVVBTY	SQL Index	S10B80.GENERAL	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GTVVBTY

Object Dates

Creation Date	Analysis Date
04/02/2008 20:30:32:000	04/02/2008 21:17:54:000

Source Code Comments

VBS Application Type Code

Columns Comments for GTVVBTY_CODE (# 1)

Source Code Comments

VBS Type Code

Columns Comments for GTVVBTY_DESC (# 2)

Source Code Comments

VBS Type Description

Columns Comments for GTVVBTY_SYS_REQ_IND (# 3)

Source Code Comments

System Required Indicator

Columns Comments for GTVVBTY_ACTIVITY_DATE (# 4)

Source Code Comments

Date of Insert or Last Update

Table GTVVOBJ

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GTVVOBJ_CODE	VARCHAR2(15)	No	*
GTVVOBJ_DESC	VARCHAR2(30)	No
GTVVOBJ_PATTERN_CTRL	NUMBER(4,0)	No
GTVVOBJ_SYS_REQ_IND	VARCHAR2(1)	No
GTVVOBJ_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GTVVOBJ	Unique	GTVVOBJ_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GOBBACR	SQL Table	S10B80.GENERAL	Refer (no action)
GOBPCRL	SQL Table	S10B80.GENERAL	Refer (no action)
GORGMSK	SQL Table	S10B80.GENERAL	Refer (no action)
GORRAVL	SQL Table	S10B80.GENERAL	Refer (no action)
GORVGAC	SQL Table	S10B80.GENERAL	Refer (no action)
GORVRAC	SQL Table	S10B80.GENERAL	Refer (no action)
GTVVOBJC	Oracle Package Cursor	S10B80.BANINST1.GTKVOBJ	Use (select)Rely On
GTVVOBJ	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GTVVOBJ	SQL Index	S10B80.GENERAL	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GTVVOBJ

Object Dates

Creation Date	Analysis Date
04/02/2008 20:28:33:000	04/02/2008 21:17:51:000

Source Code Comments

This table defines Value-Based Security (VBS) objects.

Columns Comments for GTVVOBJ_CODE (# 1)

Source Code Comments

CODE: VBS Object Code.

Columns Comments for GTVVOBJ_DESC (# 2)

Source Code Comments

DESCRIPTION: VBS Object Description.

Columns Comments for GTVVOBJ_PATTERN_CTRL (# 3)

Source Code Comments

PATTERN CONTROL: VBS Object Pattern Control Number.

Columns Comments for GTVVOBJ_SYS_REQ_IND (# 4)

Source Code Comments

SYSTEM REQUIRED: System Required Indicator.

Columns Comments for GTVVOBJ_ACTIVITY_DATE (# 5)

Source Code Comments

ACTIVITY DATE: The date that this record was created or last updated.

Link between GORVRAC and GTVVOBJ

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GORVRAC and GTVVOBJ (FK1_GORVRAC_INV_GTVVOBJ_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GORVRAC	GORVRAC_VOBJ_CODE	GTVVOBJ_CODE	GTVVOBJ	(1,1)-(0,n)

Link between GOBPCRL and GTVVAPP

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GOBPCRL and GTVVAPP (FK1_GOBPCRL_INV_GTVVAPP_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GOBPCRL	GOBPCRL_VAPP_CODE	GTVVAPP_CODE	GTVVAPP	(1,1)-(0,n)

Link between GOBPCRL and GTVVOBJ

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GOBPCRL and GTVVOBJ (FK1_GOBPCRL_INV_GTVVOBJ_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GOBPCRL	GOBPCRL_VOBJ_CODE	GTVVOBJ_CODE	GTVVOBJ	(1,1)-(0,n)

Link between GORVSVR and GORVTBL

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GORVSVR and GORVTBL (FK1_GORVSVR_INV_GORVTBL_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GORVSVR	GORVSVR_VTBL_CODE	GORVTBL_CODE	GORVTBL	(1,1)-(0,n)

Link between GORRAVL and GTVVAPP

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GORRAVL and GTVVAPP (FK1_GORRAVL_INV_GTVVAPP_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GORRAVL	GORRAVL_VAPP_CODE	GTVVAPP_CODE	GTVVAPP	(1,1)-(0,n)

Link between GORRAVL and GTVVOBJ

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GORRAVL and GTVVOBJ (FK1_GORRAVL_INV_GTVVOBJ_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GORRAVL	GORRAVL_VOBJ_CODE	GTVVOBJ_CODE	GTVVOBJ	(1,1)-(0,n)

Link between GORTCRL and GTVVAPP

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GORTCRL and GTVVAPP (FK1_GORTCRL_INV_GTVVAPP_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GORTCRL	GORTCRL_VAPP_CODE_MODULE	GTVVAPP_CODE	GTVVAPP	(1,1)-(0,n)

Link between GORVMAC and GTVVAPP

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GORVMAC and GTVVAPP (FK1_GORVMAC_INV_GTVVAPP_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GORVMAC	GORVMAC_VAPP_CODE	GTVVAPP_CODE	GTVVAPP	(1,1)-(0,n)

Link between GORVMGA and GTVVAPP

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GORVMGA and GTVVAPP (FK1_GORVMGA_INV_GTVVAPP_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GORVMGA	GORVMGA_VAPP_CODE	GTVVAPP_CODE	GTVVAPP	(1,1)-(0,n)

Link between GORVRAC and GOBBACR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GORVRAC and GOBBACR (FK1_GORVRAC_INV_GOBBACR_KEY)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GORVRAC	GORVRAC_BACR_SEQNO	GOBBACR_SEQNO	GOBBACR	(1,1)-(0,n)

Link between GOBBACR and GTVVOBJ

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GOBBACR and GTVVOBJ (FK1_GOBBACR_INV_GTVVOBJ_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GOBBACR	GOBBACR_VOBJ_CODE	GTVVOBJ_CODE	GTVVOBJ	(1,1)-(0,n)

Link between GORGRUL and GTVSEGC

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GORGRUL and GTVSEGC (FK1_GORGRUL_INV_GTVSEGC_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GORGRUL	GORGRUL_SEGC_CODE	GTVSEGC_CODE	GTVSEGC	(1,1)-(0,n)

Link between GORVSVR and GTVSEGC

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GORVSVR and GTVSEGC (FK1_GORVSVR_INV_GTVSEGC_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GORVSVR	GORVSVR_SEGC_CODE	GTVSEGC_CODE	GTVSEGC	(1,1)-(0,n)

Link between GORVGAC and GTVSEGC

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GORVGAC and GTVSEGC (FK1_GORVGAC_INV_GTVSEGC_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GORVGAC	GORVGAC_SEGC_CODE	GTVSEGC_CODE	GTVSEGC	(1,1)-(0,n)

Link between GORVGAC and GTVVOBJ

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GORVGAC and GTVVOBJ (FK1_GORVGAC_INV_GTVVOBJ_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GORVGAC	GORVGAC_VOBJ_CODE	GTVVOBJ_CODE	GTVVOBJ	(1,1)-(0,n)

Link between GOBVCRL and GOBBACR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GOBVCRL and GOBBACR (FK1_GOBVCRL_INV_GOBBACR_KEY)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GOBVCRL	GOBVCRL_BACR_SEQNO	GOBBACR_SEQNO	GOBBACR	(1,1)-(0,n)

Link between GORGMGR and GTVSEGC

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GORGMGR and GTVSEGC (FK1_GORGMGR_INV_GTVSEGC_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GORGMGR	GORGMGR_SEGC_CODE	GTVSEGC_CODE	GTVSEGC	(1,1)-(0,n)

Link between GORGMSK and GTVSEGC

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GORGMSK and GTVSEGC (FK1_GORGMSK_INV_GTVSEGC_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GORGMSK	GORGMSK_SEGC_CODE	GTVSEGC_CODE	GTVSEGC	(1,1)-(0,n)

Link between GORGMSK and GTVVAPP

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GORGMSK and GTVVAPP (FK1_GORGMSK_INV_GTVVAPP_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GORGMSK	GORGMSK_VAPP_CODE	GTVVAPP_CODE	GTVVAPP	(1,1)-(0,n)

Link between GORGMSK and GTVVOBJ

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GORGMSK and GTVVOBJ (FK1_GORGMSK_INV_GTVVOBJ_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GORGMSK	GORGMSK_VOBJ_CODE	GTVVOBJ_CODE	GTVVOBJ	(1,1)-(0,n)

Link between GOBSEGC and GTVSEGC

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GOBSEGC and GTVSEGC (FK1_GOBSEGC_INV_GTVSEGC_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GOBSEGC	GOBSEGC_SEGC_CODE	GTVSEGC_CODE	GTVSEGC	(1,1)-(0,1)

Link between GORGUSR and GTVSEGC

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GORGUSR and GTVSEGC (FK1_GORGUSR_INV_GTVSEGC_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GORGUSR	GORGUSR_SEGC_CODE	GTVSEGC_CODE	GTVSEGC	(1,1)-(0,n)