Model Value Based Security

Model Label : Banner General Value Based Security
Path : Default Folder/B70/General/Value_Based_Security

List of Objects

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

Comments

Model View

Table GOBBACR

Schema Name GENERAL
Label GOBBACR
Server name S4B70
Creation Date 06/23/2004 11:25:46:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
GOBBACR_SEQNO	GOBBACR_SEQNO	NUMBER(8,0)	No	*
GOBBACR_VOBJ_CODE	GOBBACR_VOBJ_CODE	VARCHAR2(15)	No		*
GOBBACR_ACTIVE_IND	GOBBACR_ACTIVE_IND	VARCHAR2(1)	No
GOBBACR_EFF_DATE	GOBBACR_EFF_DATE	DATE	No
GOBBACR_ACTIVITY_DATE	GOBBACR_ACTIVITY_DATE	DATE	No
GOBBACR_PATTERN_CTRL	GOBBACR_PATTERN_CTRL	NUMBER(4,0)	Yes
GOBBACR_ACCESS_CNT	GOBBACR_ACCESS_CNT	NUMBER(4,0)	Yes
GOBBACR_EXPIRE_DATE	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
GOBBACR	SYNONYM	S4B70.PUBLIC	Rely on ()
GOBVCRL	TABLE	S4B70."GENERAL"	Refer( No Action )
GORVRAC	TABLE	S4B70."GENERAL"	Refer( No Action )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS.GOASEGC.GORGRUL.GORGRUL_BACR_SEQNO	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS_10G.GOASEGC.GORGRUL.GORGRUL_BACR_SEQNO	Use(select )
POST-QUERY	Forms Trigger	BANNER7_FORMS.GOASEGC.GORGRUL	Use(select )
POST-QUERY	Forms Trigger	BANNER7_FORMS_10G.GOASEGC.GORGRUL	Use(select )
F_CHECKATTACHRULE	FUNCTION	S4B70.BANINST1	Use(select )

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GOBBACR	INDEX	S4B70."GENERAL"	Rely on ()
GT_GOBBACR_DELETE_ROW	TRIGGER	S4B70."GENERAL"	Fire(delete before each row )
GT_GOBBACR_UPDATE_ROW	TRIGGER	S4B70."GENERAL"	Fire(update before each row )
GTVVOBJ	TABLE	S4B70."GENERAL"	Refer( No Action )

Comments

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

Schema Name GENERAL
Label GOBEACC
Server name S4B70
Creation Date 09/09/2004 23:42:38:000

Table Columns information

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

Foreign Key information

No Foreign Key

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
check_page	C/C++ Function	[F:\BANNER\C\FORCONV.PC]	Use()
ins_gobeacc_new	C/C++ Function	[F:\BANNER\C\FORCONV.PC]	Use(insert )
print_exception_a	C/C++ Function	[F:\BANNER\C\FORCONV.PC]	Use()
print_exception_c	C/C++ Function	[F:\BANNER\C\FORCONV.PC]	Use()
sel_fobprof_new	C/C++ Function	[F:\BANNER\C\FORCONV.PC]	Use(select )
summary_report	C/C++ Function	[F:\BANNER\C\FORCONV.PC]	Use()
validate_proxy_id	C/C++ Function	[F:\BANNER\C\NOPEAMA.PC]	Use(select )
GOBEACC	SYNONYM	S4B70.PUBLIC	Rely on ()
FT_FOBPROF_AR_LDI	TRIGGER	S4B70.FIMSMGR	Use(select )
FT_FOBPROF_AR_LDI	TRIGGER	S4B70.FIMSMGR	Rely on ()
FOBPROF	TABLE	S4B70.FIMSMGR	Join
GOBVUSR	TABLE	S4B70."GENERAL"	Join
NOBTRAN	TABLE	S4B70.POSNCTL	Join
SPRIDEN	TABLE	S4B70.SATURN	Join
PHVTIME	VIEW	S4B70.BANINST1	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS.GORWFDS.KEY_BLOCK.ID	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS_10G.GORWFDS.KEY_BLOCK.ID	Use(select )
CALL_FORM_EVENT	Forms Trigger	BANNER7_FORMS.FRAPROP	Rely on () Use(select )
CALL_FORM_EVENT	Forms Trigger	BANNER7_FORMS_10G.FRAPROP	Rely on () Use(select )
CALL_FORM_EVENT	Forms Trigger	BANNER7_FORMS_10G.FRAGRNT	Rely on () Use(select )
CALL_FORM_EVENT	Forms Trigger	BANNER7_FORMS.FRAGRNT	Rely on () Use(select )
DO_GOBEACC_LOGIC	Forms Trigger	BANNER7_FORMS.FOMPROF	Rely on () Use(insert,update,delete,select )
DO_GOBEACC_LOGIC	Forms Trigger	BANNER7_FORMS_10G.FOMPROF	Rely on () Use(insert,update,delete,select )
GET_GOBEACC_REC	Forms Trigger	BANNER7_FORMS.FOMPROF	Use(select )
GET_GOBEACC_REC	Forms Trigger	BANNER7_FORMS_10G.FOMPROF	Use(select )
POST_FORMS_COMMIT_TRG	Forms Trigger	BANNER7_FORMS.FOMPROF	Use(select )
POST_FORMS_COMMIT_TRG	Forms Trigger	BANNER7_FORMS_10G.FOMPROF	Use(select )
WHEN_NEW_BLOCK_INSTANCE_TRG	Forms Trigger	BANNER7_FORMS.SOAROLE	Use(select )
WHEN_NEW_BLOCK_INSTANCE_TRG	Forms Trigger	BANNER7_FORMS_10G.SOAROLE	Use(select )
GOBEACC_RG	Forms Record Group	BANNER7_FORMS.GORWFDS	Use(select )
GOBEACC_RG	Forms Record Group	BANNER7_FORMS_10G.GORWFDS	Use(select )
GOBVUSR_RG	Forms Record Group	BANNER7_FORMS.GOQOLIB	Use(select )
GOBVUSR_RG	Forms Record Group	BANNER7_FORMS_10G.GOASEGC	Use(select )
GOBVUSR_RG	Forms Record Group	BANNER7_FORMS_10G.GOAEACC	Use(select )
GOBVUSR_RG	Forms Record Group	BANNER7_FORMS_10G.GOQOLIB	Use(select )
GOBVUSR_RG	Forms Record Group	BANNER7_FORMS.GOAEACC	Use(select )
GOBVUSR_RG	Forms Record Group	BANNER7_FORMS.GOASEGC	Use(select )
NOBTRAN_RG	Forms Record Group	BANNER7_FORMS.NOIESUM	Use(select )
NOBTRAN_RG	Forms Record Group	BANNER7_FORMS_10G.NOIESUM	Use(select )
KEY-DELREC	Forms Trigger	BANNER7_FORMS.FOMPROF.FOBPROF	Use(delete )
KEY-DELREC	Forms Trigger	BANNER7_FORMS_10G.FOMPROF.FOBPROF	Use(delete )
GET_PIDM	Forms Procedure	BANNER7_FORMS.PHATIME	Use(select )
GET_PIDM	Forms Procedure	BANNER7_FORMS_10G.PHADSUM	Use(select )
GET_PIDM	Forms Procedure	BANNER7_FORMS_10G.PEATMVF	Use(select )
GET_PIDM	Forms Procedure	BANNER7_FORMS_10G.PHIETIM	Use(select )
GET_PIDM	Forms Procedure	BANNER7_FORMS_10G.PHATIME	Use(select )
GET_PIDM	Forms Procedure	BANNER7_FORMS.PHIETIM	Use(select )
GET_PIDM	Forms Procedure	BANNER7_FORMS.PEATMVF	Use(select )
GET_PIDM	Forms Procedure	BANNER7_FORMS.PHADSUM	Use(select )
F_FINANCE_USER_IC	FUNCTION	S4B70.BANINST1	Use(select )
F_FINANCE_USER_IND	FUNCTION	S4B70.BANINST1	Use(select )
F_CHECKUSERPIDM	Forms Function	BANNER7_FORMS.GOAEACC	Use(select )
F_CHECKUSERPIDM	Forms Function	BANNER7_FORMS_10G.GOAEACC	Use(select )
F_GET_PIDM_FROM_USERNAME	Forms Function	BANNER7_FORMS.PHATIME	Rely on () Use(select )
F_GET_PIDM_FROM_USERNAME	Forms Function	BANNER7_FORMS_10G.PHATIME	Rely on () Use(select )
GOBEACC_TYPE	Package Type	S4B70.BANINST1.BWAKLIBS	Rely on ()
USERRECORD	Package Type	S4B70.BANINST1.BWFKRPCU	Rely on ()
OVERRIDE_NSF	Package procedure	S4B70.BANINST1.BWFKUADI	Rely on ()
P_CHECK_SECURITY	Package procedure	S4B70.BANINST1.BWFKPURR	Rely on ()
P_CHECK_SECURITY	Package procedure	S4B70.BANINST1.BWFKREQN	Rely on ()
P_CHECK_SECURITY	Package procedure	S4B70.BANINST1.BWFKTRAN	Rely on ()
P_DISPLAYPROXY	Package procedure	S4B70.BANINST1.BWPKTAIS	Rely on ()
P_DISPLAYPROXY	Package procedure	S4B70.BANINST1.BWPKTAIS	Use(select )
P_DOAPPROVE	Package procedure	S4B70.BANINST1.BWFKUADI	Rely on ()
P_DODISAPPROVE	Package procedure	S4B70.BANINST1.BWFKUADI	Rely on ()
P_INSERTCOMMENT	Package procedure	S4B70.BANINST1.BWFKUADI	Rely on ()
P_NOTIFY_APPROVER	Package procedure	S4B70.BANINST1.PEKTEAP	Rely on ()
P_PERSONALINFO	Package procedure	S4B70.BANINST1.BWPKEBST	Rely on ()
P_SELECTAPPROVERACTION	Package procedure	S4B70.BANINST1.BWPKTAIS	Rely on ()
P_SELECTNJSUPERUSERACTION	Package procedure	S4B70.BANINST1.BWPKTAIS	Rely on ()
P_SELECTSUPERUSERACTION	Package procedure	S4B70.BANINST1.BWPKTAIS	Rely on ()
GETAMRPLANBYDATEC	Package cursor	S4B70.BANINST1.BWDKMOVE	Use(select )
GETAMRPLANDATEC	Package cursor	S4B70.BANINST1.BWDKMOVE	Use(select )
GETAMRPLANGEORC	Package cursor	S4B70.BANINST1.BWDKMOVE	Use(select )
GETAMRPLANNAMEC	Package cursor	S4B70.BANINST1.BWDKMOVE	Use(select )
GETAMRPLANPROJC	Package cursor	S4B70.BANINST1.BWDKMOVE	Use(select )
GETPASSEDAMRPLANC	Package cursor	S4B70.BANINST1.BWDKMOVE	Use(select )
GET_PROXY_NAME	Package cursor	S4B70.BANINST1.BWPKTAIS	Use(select )
GOBEACCC	Package cursor	S4B70.WTAILOR.TWBKAUSR	Use(select )
CURRUSERID	Package variable	S4B70.BANINST1.BWFKUAPP	Rely on ()
GLOBAL_USER	Package variable	S4B70.BANINST1.BWPKSORG	Rely on ()
GLOBAL_USER	Package variable	S4B70.BANINST1.BWPKSALA	Rely on ()
GLOBAL_USER	Package variable	S4B70.BANINST1.BWPKSJOB	Rely on ()
GLOBAL_USER	Package variable	S4B70.BANINST1.BWPKSFDT	Rely on ()
GLOBAL_USER	Package variable	S4B70.BANINST1.BWPKSTOT	Rely on ()
GLOBAL_USER	Package variable	S4B70.BANINST1.BWPKSMEX	Rely on ()
GLOBAL_USER	Package variable	S4B70.BANINST1.BWPKSDST	Rely on ()
MAPPED_PIDM	Package variable	S4B70.WTAILOR.TWBKAUSR	Rely on ()
PIDM	Package variable	S4B70.BANINST1.BWFKUADI	Rely on ()
PIDM	Package variable	S4B70.BANINST1.BWFKUAPP	Rely on ()
VAR_GOBEACC_USERNAME	Package variable	S4B70.BANINST1.BWPKSPOS	Rely on ()
F_GETUSERID	Package function	S4B70.BANINST1.BWFKUAPP	Rely on ()
F_GETUSERID	Package function	S4B70.BANINST1.BWFKUAPP	Use(select )
F_GET_GURIDEN_IDEN_CODE	Package function	S4B70.BANINST1.BWACXCHN	Use(select )
F_ISBENADMIN	Package function	S4B70.BANINST1.BWPKEBST	Use(select )
P_ADV_PROSPECT_COUNT	Package procedure	S4B70.BANINST1.BWACBREF	Use(select )
P_ADV_PROSPECT_ROWNUM	Package procedure	S4B70.BANINST1.BWACBREF	Use(select )
P_APPDISAPPDOC	Package procedure	S4B70.BANINST1.BWFKUADI	Rely on ()
P_APPROVEDOC	Package procedure	S4B70.BANINST1.BWFKUADI	Rely on ()
P_APPROVERSUMMARY	Package procedure	S4B70.BANINST1.BWPKTAIS	Rely on ()
P_COMMENTS	Package procedure	S4B70.BANINST1.BWPKTELC	Rely on ()
P_COMMENTS	Package procedure	S4B70.BANINST1.BWPKTALC	Rely on ()
P_CREATE_ROUTING_QUEUE	Package procedure	S4B70.BANINST1.PEKTECM	Rely on ()
P_DISAPPROVEDOC	Package procedure	S4B70.BANINST1.BWFKUADI	Rely on ()
P_DISPDATESELECT	Package procedure	S4B70.BANINST1.BWPKEBST	Rely on ()
P_DISPDATESELECT	Package procedure	S4B70.BANINST1.BWPKEBST	Use(select )
P_DISPLAYPROXYSETUP	Package procedure	S4B70.BANINST1.BWPKTAIS	Rely on ()
P_DISPLAYPROXYSETUP	Package procedure	S4B70.BANINST1.BWPKTAIS	Use(select )
P_GETGOBEACCINFO	Package procedure	S4B70.BANINST1.GOKEACC	Rely on ()
P_GETGOBEACCINFO	Package procedure	S4B70.BANINST1.GOKEACC	Use(select )
P_GETGRADECHANGEEDATA	Package procedure	S4B70.BANINST1.SHKWEVN	Rely on ()
P_GETWFUSERNAME	Package procedure	S4B70.BANINST1.GOKEACC	Rely on ()
P_GET_ADV_PROSPECT	Package procedure	S4B70.BANINST1.BWACBREF	Use(select )
P_GET_EPAF	Package procedure	S4B70.BANINST1.BWNCBREF	Rely on ()
P_GET_EPAF	Package procedure	S4B70.BANINST1.BWPCBREF	Rely on ()
P_GET_GIFT_INFO	Package procedure	S4B70.BANINST1.AOKWEVN	Rely on ()
P_GET_PAF_POSN_INFO	Package procedure	S4B70.BANINST1.POKWLIB	Use(select )
P_GET_TIME_APPROVAL	Package procedure	S4B70.BANINST1.BWPCBREF	Rely on ()
P_GET_USER_ID	Package procedure	S4B70.BANINST1.PEKTECM	Rely on ()
P_GET_USER_ID	Package procedure	S4B70.BANINST1.PEKTECM	Use(select )
P_LOGIN	Package procedure	S4B70.WTAILOR.TWBKLOGN	Use(select )
P_NEXT_APPROVER	Package procedure	S4B70.BANINST1.NOKMISC	Use(select )
P_PROCPROXYSETUP	Package procedure	S4B70.BANINST1.BWPKTAIS	Use(select )
P_PROCSELECTLEAVEREPORTROLL	Package procedure	S4B70.BANINST1.BWPKTAIS	Rely on ()
P_PROCSELECTLEAVEREQUESTROLL	Package procedure	S4B70.BANINST1.BWPKTAIS	Rely on ()
P_PROCSELECTSUPERUSERACTION	Package procedure	S4B70.BANINST1.BWPKTAIS	Rely on ()
P_PROCSELECTTIMESHEETROLL	Package procedure	S4B70.BANINST1.BWPKTAIS	Rely on ()
P_SECURELOGIN	Package procedure	S4B70.WTAILOR.TWBKLOGN	Use(select )
P_SELECTLEAVEREPORTROLL	Package procedure	S4B70.BANINST1.BWPKTAIS	Rely on ()
P_SELECTLEAVEREQUESTROLL	Package procedure	S4B70.BANINST1.BWPKTAIS	Rely on ()
P_SELECTTIMESHEETROLL	Package procedure	S4B70.BANINST1.BWPKTAIS	Rely on ()
P_UPDATESTUDENTGRADE	Package procedure	S4B70.BANINST1.SHKWEVN	Rely on ()
P_UPD_LEAVE_BALANCE	Package procedure	S4B70.BANINST1.PEKLEAV	Rely on ()
P_VALIDATE_ROUTING_QUEUE	Package procedure	S4B70.BANINST1.PEKTEVT	Rely on ()
P_VALIDATE_USER	Package procedure	S4B70.BANINST1.PEKTEVT	Rely on ()
P_WFEDEVNT	Package procedure	S4B70.BANINST1.GOKSEVN	Rely on ()
GETGOBEACCC	Package cursor	S4B70.BANINST1.BWAKLIBS	Use(select )
GETPROSPECTSC	Package cursor	S4B70.BANINST1.BWAKLIBS	Use(select )
GETUSERID	Package cursor	S4B70.BANINST1.BWFKRPCU	Use(select )
F_ADV_PROSPECT_COUNT	Package function	S4B70.BANINST1.BWACXALU	Use(select )
F_ADV_PROSPECT_ROWNUM	Package function	S4B70.BANINST1.BWACXALU	Use(select )
F_ALERT_XML	Package function	S4B70.BANINST1.BWFCXCHN	Rely on ()
F_ALERT_XML	Package function	S4B70.BANINST1.BWFCXCHN	Use(select )
F_FINALERT_SUM	Package function	S4B70.BANINST1.BWFCBREF	Rely on ()
F_FINALERT_SUM	Package function	S4B70.BANINST1.CHNLSKBL	Rely on ()
F_FINALERT_TOTAL	Package function	S4B70.BANINST1.BWFCBREF	Rely on ()
F_FIND_PII_DOMAIN	Package function	S4B70.BANINST1.GOKFGAC	Use(select )
F_FIND_PII_DOMAIN	Package function	S4B70.BANINST1.GOKFGAC	Rely on ()
F_FIN_ALERT	Package function	S4B70.BANINST1.CHNLSKXM	Rely on ()
F_FIN_ALERT	Package function	S4B70.BANINST1.CHNLSKXM	Use(select )
F_GETSPRIDENNAME	Package function	S4B70.BANINST1.GOKEDVD	Use(select )
F_GETUSER	Package function	S4B70.BANINST1.GOKEDVD	Rely on ()
F_GETUSER	Package function	S4B70.BANINST1.GOKEDVD	Use(select )
F_GETUSERNAME	Package function	S4B70.BANINST1.BWLKILIB	Use(select )
F_GETUSERNAME	Package function	S4B70.BANINST1.BWPCBREF	Rely on ()
F_GETUSERSPRIDENNAME	Package function	S4B70.BANINST1.GOKEDVD	Rely on ()
F_GETUSERSPRIDENNAME	Package function	S4B70.BANINST1.GOKEDVD	Use(select )
F_GET_EPAF	Package function	S4B70.BANINST1.BWNCXCHN	Rely on ()
F_GET_EPAF_DEFAULT	Package function	S4B70.BANINST1.BWPCXCHN	Rely on ()
F_GET_FINALERT	Package function	S4B70.BANINST1.CHNLSKBL	Rely on ()
F_GET_MOVES	Package function	S4B70.BANINST1.BWACBREF	Use(select )
F_GET_MOVES	Package function	S4B70.BANINST1.GSTAUB	Use(select )
F_GET_PROSPECTS_XML	Package function	S4B70.BANINST1.XCHAPERS	Use(select )
F_GET_TIME_APPROVAL	Package function	S4B70.BANINST1.BWPCXCHN	Rely on ()
F_GOBEACC_MAP	Package function	S4B70.BANINST1.GOKSSSO	Use(select )
F_GOBEACC_MAP	Package function	S4B70.BANINST1.GOKSSSO	Rely on ()
F_GOBEACC_MAP_ID	Package function	S4B70.BANINST1.GOKSSSO	Use(select )
F_GOBEACC_MAP_ID	Package function	S4B70.BANINST1.GOKSSSO	Rely on ()
F_GRANTS_XML	Package function	S4B70.BANINST1.BWFCXCHN	Rely on ()
F_USERNAME	Package function	S4B70.BANINST1.GOKEACC	Use(select )
F_VALIDATECRN	Package function	S4B70.BANINST1.SSKWEVN	Rely on ()
F_VALIDATECRN	Package function	S4B70.BANINST1.SSKWEVN	Use(select )
F_VALIDATESPRIDENID	Package function	S4B70.BANINST1.GOKEDVD	Rely on ()
F_VALIDATESPRIDENID	Package function	S4B70.BANINST1.GOKEDVD	Use(select )
F_VALIDATEUSER	Package function	S4B70.BANINST1.GOKEDVD	Rely on ()
F_VALIDATEUSER	Package function	S4B70.BANINST1.GOKEDVD	Use(select )
F_VALIDUSER	Package function	S4B70.WTAILOR.TWBKWBIS	Use(select )
GOBEACC	Forms DataBlock	BANNER7_FORMS.GOAEACC	Rely on () Use(insert,update,delete,select )
GOBEACC	Forms DataBlock	BANNER7_FORMS_10G.GOAEACC	Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

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

Comments

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

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
GOBPCRL_VOBJ_CODE	GOBPCRL_VOBJ_CODE	VARCHAR2(15)	No	*	*
GOBPCRL_VAPP_CODE	GOBPCRL_VAPP_CODE	VARCHAR2(15)	No	*	*
GOBPCRL_PATTERN_CTRL	GOBPCRL_PATTERN_CTRL	NUMBER(4,0)	No	*
GOBPCRL_ACTIVITY_DATE	GOBPCRL_ACTIVITY_DATE	DATE	No
GOBPCRL_TABLE_NAME	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)

Object Name	Object Type	Parent Name	Link Type
GOBPCRL	SYNONYM	S4B70.PUBLIC	Rely on ()
GOVVRAC	VIEW	S4B70.BANINST1	Use(select )
GOBPCRL_VAPP_RG	Forms Record Group	BANNER7_FORMS.GOQOLIB	Use(select )
GOBPCRL_VAPP_RG	Forms Record Group	BANNER7_FORMS.GOASEGC	Use(select )
GOBPCRL_VAPP_RG	Forms Record Group	BANNER7_FORMS_10G.GOASEGC	Use(select )
GOBPCRL_VAPP_RG	Forms Record Group	BANNER7_FORMS_10G.GOQOLIB	Use(select )
GOBPCRL_VAPP_RG	Forms Record Group	BANNER7_FORMS.SOIVPAC	Use(select )
GOBPCRL_VAPP_RG	Forms Record Group	BANNER7_FORMS_10G.SOIVPAC	Use(select )

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GOBPCRL	INDEX	S4B70."GENERAL"	Rely on ()
GTVVAPP	TABLE	S4B70."GENERAL"	Refer( No Action )
GTVVOBJ	TABLE	S4B70."GENERAL"	Refer( No Action )

Comments

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

Schema Name GENERAL
Label GOBSEGC
Server name S4B70
Creation Date 08/11/2004 10:33:29:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
GOBSEGC_SEGC_CODE	GOBSEGC_SEGC_CODE	VARCHAR2(15)	No	*	*
GOBSEGC_EFF_DATE	GOBSEGC_EFF_DATE	DATE	No
GOBSEGC_ACTIVE_IND	GOBSEGC_ACTIVE_IND	VARCHAR2(1)	No
GOBSEGC_ACTIVITY_DATE	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)

Object Name	Object Type	Parent Name	Link Type
GOBSEGC	SYNONYM	S4B70.PUBLIC	Rely on ()
GOBSEGC_RG	Forms Record Group	BANNER7_FORMS.GOQOLIB	Use(select )
GOBSEGC_RG	Forms Record Group	BANNER7_FORMS.GOASEGC	Use(select )
GOBSEGC_RG	Forms Record Group	BANNER7_FORMS_10G.GOASEGC	Use(select )
GOBSEGC_RG	Forms Record Group	BANNER7_FORMS_10G.GOQOLIB	Use(select )
GOBSEGC	Forms DataBlock	BANNER7_FORMS.GOASEGC	Rely on () Use(insert,update,delete,select )
GOBSEGC	Forms DataBlock	BANNER7_FORMS_10G.GOASEGC	Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GOBSEGC	INDEX	S4B70."GENERAL"	Rely on ()
GT_GOBSEGC_DELETE_ROW	TRIGGER	S4B70."GENERAL"	Fire(delete before each row )
GT_GOBSEGC_INSERT_ROW	TRIGGER	S4B70.BANINST1	Fire(insert before each row )
GT_GOBSEGC_INSERT_ROW	TRIGGER	S4B70."GENERAL"	Fire(insert before each row )
GT_GOBSEGC_UPDATE_ROW	TRIGGER	S4B70."GENERAL"	Fire(update before each row )
GTVSEGC	TABLE	S4B70."GENERAL"	Refer( No Action )

Comments

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

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

Table Columns information

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

Foreign Key information

No Foreign Key

Index

No Result

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GOBVBSC	SYNONYM	S4B70.PUBLIC	Rely on ()
KEY-DELREC	Forms Trigger	BANNER7_FORMS.SCABASE.SCBCRKY	Use(select )
CHECK_VBS_SUSPEND	Forms Procedure	BANNER7_FORMS.GOASEGC	Use(select )
CHECK_VBS_SUSPEND	Forms Procedure	BANNER7_FORMS_10G.GOASEGC	Use(select )

Comments

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

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
GOBVCRL_USER_ID	GOBVCRL_USER_ID	VARCHAR2(30)	No	*
GOBVCRL_BACR_SEQNO	GOBVCRL_BACR_SEQNO	NUMBER(8,0)	No	*	*
GOBVCRL_VAPP_CODE_MODULE	GOBVCRL_VAPP_CODE_MODULE	VARCHAR2(15)	No	*
GOBVCRL_ACCESS_CNT	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)

Object Name	Object Type	Parent Name	Link Type
GOBVCRL	SYNONYM	S4B70.PUBLIC	Rely on ()

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GOBVCRL	INDEX	S4B70."GENERAL"	Rely on ()
GOBBACR	TABLE	S4B70."GENERAL"	Refer( No Action )

Comments

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

Schema Name GENERAL
Label GOBVUSR
Server name S4B70
Creation Date 06/23/2004 11:25:46:000

Table Columns information

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

Foreign Key information

Column name	is Foreign Key For Column	on Table
GOBVUSR_USER_ID	GOBEACC_USERNAME	GOBEACC

Index

Index Name	Index Type	Column Name
PK_GOBVUSR	Unique	GOBVUSR_USER_ID

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GOBVUSR	SYNONYM	S4B70.PUBLIC	Rely on ()
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS.GOASEGC.GORGMGR.GORGMGR_USER_ID	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS.GOASEGC.GORGUSR.GORGUSR_USER_ID	Use(select )
WHEN-VALIDATE-ITEM</