Model Security

Model Label :

List of Objects

Object Name	Object Type	Layer Name
GJRINVC	SQL Table	Default
GORIROL	SQL Table	Default
GTVCALN	SQL Table	Default
GTVCLAS	SQL Table	Default
GTVOWNG	SQL Table	Default
GTVSGRP	SQL Table	Default
GTVSYSI	SQL Table	Default
GTVVPDI	SQL Table	Default
GUBAROL	SQL Table	Default
GUBIPRF	SQL Table	Default
GUBROLE	SQL Table	Default
GURAAOB	SQL Table	Default
GURAATB	SQL Table	Default
GURABGP	SQL Table	Default
GURABPI	SQL Table	Default
GURABPR	SQL Table	Default
GURACAL	SQL Table	Default
GURACGP	SQL Table	Default
GURACLS	SQL Table	Default
GURADMN	SQL Table	Default
GURADPI	SQL Table	Default
GURADPL	SQL Table	Default
GURAEAC	SQL Table	Default
GURAEOB	SQL Table	Default
GURAGAC	SQL Table	Default
GURAGBP	SQL Table	Default
GURAGUS	SQL Table	Default
GURAINV	SQL Table	Default
GURAIPF	SQL Table	Default
GURALGN	SQL Table	Default
GURALOG	SQL Table	Default
GURAMSK	SQL Table	Default
GURAOBJ	SQL Table	Default
GURAOGP	SQL Table	Default
GURAOWG	SQL Table	Default
GURAOWN	SQL Table	Default
GURAPRD	SQL Table	Default
GURAPUD	SQL Table	Default
GURATAB	SQL Table	Default
GURAUGP	SQL Table	Default
GURAULG	SQL Table	Default
GURAUOB	SQL Table	Default
GURAUSI	SQL Table	Default
GURAUTB	SQL Table	Default
GURAVCL	SQL Table	Default
GURBGRP	SQL Table	Default
GURCALN	SQL Table	Default
GURCGRP	SQL Table	Default
GURLOGN	SQL Table	Default
GUROGRP	SQL Table	Default
GUROWNG	SQL Table	Default
GUROWNR	SQL Table	Default
GURSQLL	SQL Table	Default
GURUACC	SQL Table	Default
GURUCLS	SQL Table	Default
GURUGRP	SQL Table	Default
GURUOBJ	SQL Table	Default
GURUSRI	SQL Table	Default
GURUTAB	SQL Table	Default
GUVOWNR	SQL View	Default
GUVUOBJ	SQL View	Default

Model View

Table GJRINVC

Server Name S10B80
Database Name BANSECR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GJRINVC_PARM_TYPE	VARCHAR2(3)	No	*
GJRINVC_VALID_OR_INVALID	VARCHAR2(1)	No
GJRINVC_CHARACTERS	VARCHAR2(255)	Yes
GJRINVC_USER_ID	VARCHAR2(30)	No
GJRINVC_ACTIVITY_DATE	DATE	No
GJRINVC_DATA_ORIGIN	VARCHAR2(30)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GJRINVC	Unique	GJRINVC_PARM_TYPE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
F_VALID_JOBSUB_PARM	Oracle Package Function	S10B80.BANINST1.GOKPVAL	Rely On
F_VALID_JOBSUB_PARM	Oracle Package Function	S10B80.BANINST1.GOKPVAL	Use (select)
GJRINVC	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_GJRINVC	SQL Index	S10B80.BANSECR	Rely On
GT_GJRINVC_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.BANSECR.GJRINVC

Object Dates

Creation Date	Analysis Date
04/03/2008 10:44:20:000	04/03/2008 10:47:27:000

Source Code Comments

Job Submission Character Validation Table contains rows of characters which are either allowed or prohibited for use in various Job Submission parameters based on Type column.

Columns Comments for GJRINVC_PARM_TYPE (# 1)

Source Code Comments

PARAMETER TYPE: Type of Job Submission parameter for which characters are listed in column GJRINVC_CHARACTERS. Valid values are UID for User ID, PWD for password, and PRT for print command.

Columns Comments for GJRINVC_VALID_OR_INVALID (# 2)

Source Code Comments

VALID OR INVALID: Indicates if this rows list of characters are either Valid or Invalid for inclusion in a parameter for the associated Type column. Valid values are I or V.

Columns Comments for GJRINVC_CHARACTERS (# 3)

Source Code Comments

CHARACTERS: List of characters that are either allowed or prohibited for inclusion in a parameter for the associated Type column. If all characters are to be allowed for a particular parameter, this column should contain null value.

Columns Comments for GJRINVC_USER_ID (# 4)

Source Code Comments

USER ID: User ID of the User who created or last updated the row.

Columns Comments for GJRINVC_ACTIVITY_DATE (# 5)

Source Code Comments

ACTIVITY DATE: Date the row was created or last updated.

Columns Comments for GJRINVC_DATA_ORIGIN (# 6)

Source Code Comments

DATA ORIGIN: Source system that created or updated the row

Table GORIROL

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
GORIROL_PIDM	NUMBER(8,0)	No
GORIROL_ROLE_GROUP	VARCHAR2(30)	No	*
GORIROL_ROLE	VARCHAR2(30)	No	*
GORIROL_ACTIVITY_DATE	DATE	No
GORIROL_USER_ID	VARCHAR2(30)	No
GORIROL_VPDI_CODE	VARCHAR2(6)	Yes	*
GORIROL_DATA_ORIGIN	VARCHAR2(30)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GORIROL_ROLE_GROUP	GTVSQPR_CODE	GTVSQPR
GORIROL_ROLE	GTVSQRU_CODE	GTVSQRU
GORIROL_VPDI_CODE	GTVVPDI_CODE	GTVVPDI

Index

Index Name	Index Type	Column Name
UK_GORIROL	Unique	GORIROL_PIDM
UK_GORIROL	Unique	GORIROL_ROLE_GROUP
UK_GORIROL	Unique	GORIROL_ROLE
UK_GORIROL	Unique	GORIROL_VPDI_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
INSTITUTION_ROLE_REC	Oracle Package Type	S10B80.BANINST1.GB_INSTITUTION_ROLE	Rely On
P_DELETE_ROLES	Oracle Package Procedure	S10B80.BANINST1.GB_INSTITUTION_ROLE	Rely On
P_GET_ROLE_INSTITUTIONS	Oracle Package Procedure	S10B80.BANINST1.GB_INSTITUTION_ROLE	Rely On
P_INSERT_ROLES	Oracle Package Procedure	S10B80.BANINST1.GB_INSTITUTION_ROLE	Rely On
P_OVERLAY_VALIDATION_REC	Oracle Package Procedure	S10B80.BANINST1.GB_INSTITUTION_ROLE	Rely On
F_BUILD_GORIROL_REC	Oracle Package Function	S10B80.BANINST1.GB_INSTITUTION_ROLE	Rely On
F_ROLE_IS_VPD	Oracle Package Function	S10B80.BANINST1.GB_INSTITUTION_ROLE	Rely On
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.GB_INSTITUTION_ROLE	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.DML_GORIROL	Use (delete)
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.GB_INSTITUTION_ROLE	Rely On
P_INSERT	Oracle Package Procedure	S10B80.BANINST1.DML_GORIROL	Use (Insert)Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.GB_INSTITUTION_ROLE	Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.GB_INSTITUTION_ROLE	Use (select)
P_MAINTAIN_ROLES	Oracle Package Procedure	S10B80.BANINST1.GB_INSTITUTION_ROLE	Rely On
P_REGISTER_ENTITY	Oracle Package Procedure	S10B80.BANINST1.GB_INSTITUTION_ROLE_RULES	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.DML_GORIROL	Use (update)Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.GB_INSTITUTION_ROLE	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.GB_INSTITUTION_ROLE_RULES	Rely On
P_VALIDATE_MAINTAIN_REQUEST	Oracle Package Procedure	S10B80.BANINST1.GB_INSTITUTION_ROLE_RULES	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_INSTITUTION_ROLE	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_INSTITUTION_ROLE	Use (select)
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.GB_INSTITUTION_ROLE	Rely On
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.GB_INSTITUTION_ROLE	Use (select)
F_QUERY_BY_ROWID	Oracle Package Function	S10B80.BANINST1.GB_INSTITUTION_ROLE	Use (select)
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.GB_INSTITUTION_ROLE	Rely On
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.GB_INSTITUTION_ROLE	Use (select)
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.GB_INSTITUTION_ROLE	Rely On
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.GB_INSTITUTION_ROLE	Use (select)
GORIROL	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
UK_GORIROL	SQL Index	S10B80.GENERAL	Rely On
GTVSQPR	SQL Table	S10B80.GENERAL	Refer (no action)
GTVSQRU	SQL Table	S10B80.GENERAL	Refer (no action)
GTVVPDI	SQL Table	S10B80.BANSECR	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GORIROL

Object Dates

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

Source Code Comments

GORIROL: Institution Role Table.

Columns Comments for GORIROL_PIDM (# 1)

Source Code Comments

PIDM: Internal identification number of the person.

Columns Comments for GORIROL_ROLE_GROUP (# 2)

Source Code Comments

ROLE GROUP: Group a role belongs to.

Columns Comments for GORIROL_ROLE (# 3)

Source Code Comments

ROLE: Institution Role name.

Columns Comments for GORIROL_ACTIVITY_DATE (# 4)

Source Code Comments

ACTIVITY DATE: Date the record was created or last updated.

Columns Comments for GORIROL_USER_ID (# 5)

Source Code Comments

USER ID: The unique identification of the user.

Columns Comments for GORIROL_VPDI_CODE (# 6)

Source Code Comments

VPDI CODE: This field contains a VPD Institution Code.

Columns Comments for GORIROL_DATA_ORIGIN (# 7)

Source Code Comments

DATA ORIGIN: Source system that created or updated the row

Table GTVCALN

Server Name S10B80
Database Name BANSECR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GTVCALN_CODE	VARCHAR2(30)	No	*
GTVCALN_DESC	VARCHAR2(60)	No
GTVCALN_ACTIVITY_DATE	DATE	No
GTVCALN_USER_ID	VARCHAR2(30)	No
GTVCALN_DATA_ORIGIN	VARCHAR2(30)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GTVCALN	Unique	GTVCALN_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GURCALN	SQL Table	S10B80.BANSECR	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_GTVCALN	SQL Index	S10B80.BANSECR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.BANSECR.GTVCALN

Object Dates

Creation Date	Analysis Date
04/03/2008 10:43:55:000	04/03/2008 10:47:27:000

Source Code Comments

GTVCALN: Validation entries for calendars used in security logon validation.

Columns Comments for GTVCALN_CODE (# 1)

Source Code Comments

CALENDAR CODE: The name given to a calendar used for security logon validation.

Columns Comments for GTVCALN_DESC (# 2)

Source Code Comments

DESCRIPTION: Description of the calendar.

Columns Comments for GTVCALN_ACTIVITY_DATE (# 3)

Source Code Comments

ACTIVITY DATE: Date record was created or last updated.

Columns Comments for GTVCALN_USER_ID (# 4)

Source Code Comments

USER ID: User ID of the user who created or last updated the record.

Columns Comments for GTVCALN_DATA_ORIGIN (# 5)

Source Code Comments

DATA ORIGIN: Source system that created or updated the row.

Table GTVCLAS

Server Name S10B80
Database Name BANSECR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GTVCLAS_CLASS_CODE	VARCHAR2(30)	No	*	*
GTVCLAS_ACTIVITY_DATE	DATE	No
GTVCLAS_SYSI_CODE	VARCHAR2(2)	Yes
GTVCLAS_LAST_SYNC_DATE	DATE	Yes
GTVCLAS_USER_ID	VARCHAR2(30)	No
GTVCLAS_OWNER	VARCHAR2(30)	Yes
GTVCLAS_COMMENTS	VARCHAR2(4000)	Yes
GTVCLAS_DATA_ORIGIN	VARCHAR2(30)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GTVCLAS_CLASS_CODE	GUROWNR_OBJECT	GUROWNR

Index

Index Name	Index Type	Column Name
PK_GTVCLAS	Unique	GTVCLAS_CLASS_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GURUCLS	SQL Table	S10B80.BANSECR	Refer (no action)
GUVOWNR	SQL View	S10B80.BANSECR	Use (select)
TEST_GUVOWNR	SQL View	S10B80.BANSECR	Use (select)
G$_SYNC_CLASS_GRANTS_FNC	Oracle Package Function	S10B80.BANSECR.G$_AUTHORIZATION_PKG	Use (update,select)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GTVCLAS	SQL Index	S10B80.BANSECR	Rely On
GUROWNR	SQL Table	S10B80.BANSECR	Join
GT_GTVCLAS_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.BANSECR.GTVCLAS

Object Dates

Creation Date	Analysis Date
04/03/2008 10:44:18:000	04/03/2008 10:47:27:000

Source Code Comments

GTVCLASS: Validation table of user classes defined to the BANNER security system.

Columns Comments for GTVCLAS_CLASS_CODE (# 1)

Source Code Comments

CLASS CODE: The name of the class.

Columns Comments for GTVCLAS_ACTIVITY_DATE (# 2)

Source Code Comments

ACTIVITY DATE: Date record was created or last updated.

Columns Comments for GTVCLAS_SYSI_CODE (# 3)

Source Code Comments

SYSTEM INDICATOR: The system that the class is associated with.

Columns Comments for GTVCLAS_LAST_SYNC_DATE (# 4)

Source Code Comments

LAST SYNCRONIZATION DATE: The last time the user grants were synchronized with the class definition.

Columns Comments for GTVCLAS_USER_ID (# 5)

Source Code Comments

USER ID: User ID of the user who created or last updated the record.

Columns Comments for GTVCLAS_OWNER (# 6)

Source Code Comments

OWNER: The owner of the class for use by distributed security.

Columns Comments for GTVCLAS_COMMENTS (# 7)

Source Code Comments

COMMENTS: Comments related to this class.

Columns Comments for GTVCLAS_DATA_ORIGIN (# 8)

Source Code Comments

DATA ORIGIN: Source system that created or updated the row.

Table GTVOWNG

Server Name S10B80
Database Name BANSECR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GTVOWNG_CODE	VARCHAR2(30)	No	*
GTVOWNG_DESC	VARCHAR2(60)	No
GTVOWNG_ACTIVITY_DATE	DATE	No
GTVOWNG_USER_ID	VARCHAR2(30)	No
GTVOWNG_DATA_ORIGIN	VARCHAR2(30)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GTVOWNG	Unique	GTVOWNG_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GUROWNG	SQL Table	S10B80.BANSECR	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_GTVOWNG	SQL Index	S10B80.BANSECR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.BANSECR.GTVOWNG

Object Dates

Creation Date	Analysis Date
04/03/2008 10:44:28:000	04/03/2008 10:47:27:000

Source Code Comments

GTVOWNG: Validation entries for the security owner groups used in distributed security.

Columns Comments for GTVOWNG_CODE (# 1)

Source Code Comments

CODE: The name given to a group of security object owners. This name must NOT start with BANSECR nor equal to PUBLIC.

Columns Comments for GTVOWNG_DESC (# 2)

Source Code Comments

DESCRIPTION: Description of the distributed security owner group.

Columns Comments for GTVOWNG_ACTIVITY_DATE (# 3)

Source Code Comments

ACTIVITY DATE: Date record was created or last updated.

Columns Comments for GTVOWNG_USER_ID (# 4)

Source Code Comments

USER ID: User ID of the user who created or last updated the record.

Columns Comments for GTVOWNG_DATA_ORIGIN (# 5)

Source Code Comments

DATA ORIGIN: Source system that created or updated the row.

Table GTVSGRP

Server Name S10B80
Database Name BANSECR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GTVSGRP_CODE	VARCHAR2(30)	No	*
GTVSGRP_DESC	VARCHAR2(60)	No
GTVSGRP_ACTIVITY_DATE	DATE	No
GTVSGRP_USER_ID	VARCHAR2(30)	No
GTVSGRP_DATA_ORIGIN	VARCHAR2(30)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GTVSGRP	Unique	GTVSGRP_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GURBGRP	SQL Table	S10B80.BANSECR	Refer (no action)
GURCGRP	SQL Table	S10B80.BANSECR	Refer (no action)
GUROGRP	SQL Table	S10B80.BANSECR	Refer (no action)
GURUGRP	SQL Table	S10B80.BANSECR	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_GTVSGRP	SQL Index	S10B80.BANSECR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.BANSECR.GTVSGRP

Object Dates

Creation Date	Analysis Date
04/03/2008 10:43:57:000	04/03/2008 10:47:27:000

Source Code Comments

GTVSGRP: Validation entries for security groups.

Columns Comments for GTVSGRP_CODE (# 1)

Source Code Comments

SECURITY GROUP CODE: The name given to a security group.

Columns Comments for GTVSGRP_DESC (# 2)

Source Code Comments

DESCRIPTION: Description of the security group.

Columns Comments for GTVSGRP_ACTIVITY_DATE (# 3)

Source Code Comments

ACTIVITY DATE: Date record was created or last updated.

Columns Comments for GTVSGRP_USER_ID (# 4)

Source Code Comments

USER ID: User ID of the user who created or last updated the record.

Columns Comments for GTVSGRP_DATA_ORIGIN (# 5)

Source Code Comments

DATA ORIGIN: Source system that created or updated the row.

Table GTVSYSI

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GTVSYSI_CODE	VARCHAR2(2)	No	*
GTVSYSI_DESC	VARCHAR2(30)	No
GTVSYSI_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GTVSYSI	Unique	GTVSYSI_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
ETVAXAP	SQL Table	S10B80.BANIMGR	Refer (no action)
GJBJOBS	SQL Table	S10B80.GENERAL	Refer (no action)
GLBAPPL	SQL Table	S10B80.GENERAL	Refer (no action)
GORMERC	SQL Table	S10B80.GENERAL	Refer (no action)
GORSDAV	SQL Table	S10B80.GENERAL	Join
GUBOBJS	SQL Table	S10B80.GENERAL	Refer (no action)
GURAOBJ	SQL Table	S10B80.BANSECR	Refer (no action)
GTVSYSI_ADD	SQL View	S10B80.BANINST1	Use (select)
GTVSYSI_ADS	SQL View	S10B80.BANINST1	Use (select)
GTVSYSIC	Oracle Package Cursor	S10B80.BANINST1.GTKSYSI	Use (select)Rely On
GTVSYSI_C	Oracle Package Cursor	S10B80.BANINST1.GB_GTVSYSI	Rely On
GTVSYSI_C	Oracle Package Cursor	S10B80.BANINST1.GB_GTVSYSI	Use (select)Rely On
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT	Use (Insert)
F_CODE_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_GTVSYSI	Rely On
F_GET_DESCRIPTION	Oracle Package Function	S10B80.BANINST1.GB_GTVSYSI	Rely On
GTVSYSI	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_GTVSYSI	SQL Index	S10B80.GENERAL	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GTVSYSI

Object Dates

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

Source Code Comments

System Indicator Validation Table

Columns Comments for GTVSYSI_CODE (# 1)

Source Code Comments

CODE: System indicator which uniquely identifies this record.

Columns Comments for GTVSYSI_DESC (# 2)

Source Code Comments

DESCRIPTION: Description of this code.

Columns Comments for GTVSYSI_ACTIVITY_DATE (# 3)

Source Code Comments

ACTIVITY DATE: Date that record was created or last updated.

Table GTVVPDI

Server Name S10B80
Database Name BANSECR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GTVVPDI_CODE	VARCHAR2(6)	No	*
GTVVPDI_DESC	VARCHAR2(30)	No
GTVVPDI_TYPE_CDE	VARCHAR2(2)	No
GTVVPDI_SYS_DEF_INST_IND	VARCHAR2(1)	No
GTVVPDI_ACTIVITY_DATE	DATE	No
GTVVPDI_VR_MSG_NO	NUMBER(6,0)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GTVVPDI	Unique	GTVVPDI_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GORIROL	SQL Table	S10B80.GENERAL	Refer (no action)
GURUSRI	SQL Table	S10B80.BANSECR	Refer (no action)
SECURITY_RECORD_TYPE	Oracle Package Type	S10B80.BANSECR.G$_VPDI_SECURITY	Rely On
GTVVPDI_TAB_TYPE	Oracle Package Type	S10B80.BANINST1.GOKTABS	Rely On
P_GET_ROLE_INSTITUTIONS	Oracle Package Procedure	S10B80.BANINST1.GB_INSTITUTION_ROLE	Rely On
GTVVPDI_C	Oracle Package Cursor	S10B80.BANINST1.GB_GTVVPDI	Rely On
GTVVPDI_C	Oracle Package Cursor	S10B80.BANINST1.GB_GTVVPDI	Use (select)Rely On
GTVVPDI_ROW_C	Oracle Package Cursor	S10B80.BANINST1.GOKSELS	Use (select)Rely On
G$_VPDI_GET_MIF_CODES	Oracle Package Procedure	S10B80.BANSECR.G$_VPDI_SECURITY	Use (select)
G$_VPDI_GET_USER_INSTS	Oracle Package Procedure	S10B80.BANSECR.G$_VPDI_SECURITY	Use (select)
G$_VPDI_SET_HOME_CONTEXT	Oracle Package Procedure	S10B80.BANSECR.G$_VPDI_SECURITY	Use (select)
GET_MIF_CODES_FOR_USER	Oracle Package Procedure	S10B80.BANSECR.GSPVPDI	Use (select)
P_GET_GTVVPDI	Oracle Package Procedure	S10B80.BANINST1.GOKFUNC	Rely On
F_CODE_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_GTVVPDI	Rely On
F_GET_DESCRIPTION	Oracle Package Function	S10B80.BANINST1.GB_GTVVPDI	Rely On
F_IS_VPDI_CODE_VALID_ALL	Oracle Package Function	S10B80.BANINST1.GOKVPDA	Use (select)
GET_MIF_DEFAULT_CODE_FOR_USER	Oracle Package Function	S10B80.BANSECR.GSPVPDI	Use (select)Rely On
GTVVPDI	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_GTVVPDI	SQL Index	S10B80.BANSECR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.BANSECR.GTVVPDI

Object Dates

Creation Date	Analysis Date
04/03/2008 10:44:12:000	04/03/2008 10:47:27:000

Source Code Comments

VPD Institution Code Validation Table

Columns Comments for GTVVPDI_CODE (# 1)

Source Code Comments

INSTITUTION CODE: This field indicates the Institution Codes for the Banner System.

Columns Comments for GTVVPDI_DESC (# 2)

Source Code Comments

INSTITUTION DESCRIPTION: This field indicates the Institution cod description.

Columns Comments for GTVVPDI_TYPE_CDE (# 3)

Source Code Comments

INSTITUTION TYPE CODE: This field indicates the Institution type codes. Free format field and it is not validated against any other table. It is used to group access to certain institutions. Use this when a user can have access to multiple institutions in a table.

Columns Comments for GTVVPDI_SYS_DEF_INST_IND (# 4)

Source Code Comments

SYSTEM DEFAULT: This field indicates the default institution for the Banner system. This field will be used to associate an institution to a user that has not been assigned one on GSAVPDI. Valid values are Y and N.

Columns Comments for GTVVPDI_ACTIVITY_DATE (# 5)

Source Code Comments

ACTIVITY DATE: The date that the information for the row was inserted or updated in the GTVVPDI table.

Columns Comments for GTVVPDI_VR_MSG_NO (# 6)

Source Code Comments

VOICE RESPONSE MESSAGE NUMBER: This field indicates the Voice Response message number that is assigned to the recorded message describing the institution code.

Table GUBAROL

Server Name S10B80
Database Name BANSECR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GUBAROL_AUDIT_TIME	UNDEFINED	No	*
GUBAROL_AUDIT_ACTION	VARCHAR2(1)	Yes
GUBAROL_ROLE	VARCHAR2(30)	Yes
GUBAROL_PASSWORD	VARCHAR2(30)	Yes
GUBAROL_ACTIVITY_DATE	DATE	Yes
GUBAROL_USER_ID	VARCHAR2(30)	Yes
GUBAROL_OWNER	VARCHAR2(30)	Yes
GUBAROL_COMMENTS	VARCHAR2(4000)	Yes
GUBAROL_DATA_ORIGIN	VARCHAR2(30)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GUBAROL	Unique	GUBAROL_AUDIT_TIME

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GT_GUBROLE_AUDIT_ROW	SQL Trigger	S10B80.BANSECR	Use (Insert)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GUBAROL	SQL Index	S10B80.BANSECR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.BANSECR.GUBAROL

Object Dates

Creation Date	Analysis Date
04/03/2008 10:43:40:000	04/03/2008 10:47:26:000

Source Code Comments

GUBAROL: This table stores audit information for the GUBROLE table.

Columns Comments for GUBAROL_AUDIT_TIME (# 1)

Source Code Comments

AUDIT TIME: The time the change was made to GUBROLE.

Columns Comments for GUBAROL_AUDIT_ACTION (# 2)

Source Code Comments

AUDIT ACTION: The audit action taken (I)nsert, (U)pdate, or (D)elete.

Columns Comments for GUBAROL_ROLE (# 3)

Source Code Comments

ROLE: The Banner security role.

Columns Comments for GUBAROL_PASSWORD (# 4)

Source Code Comments

PASSWORD: Internally created password for this role.

Columns Comments for GUBAROL_ACTIVITY_DATE (# 5)

Source Code Comments

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

Columns Comments for GUBAROL_USER_ID (# 6)

Source Code Comments

USER ID: User ID of the user who created or last updated the record.

Columns Comments for GUBAROL_OWNER (# 7)

Source Code Comments

OWNER: The owner of the role for use by distributed security.

Columns Comments for GUBAROL_COMMENTS (# 8)

Source Code Comments

COMMENTS: Comments related to this role.

Columns Comments for GUBAROL_DATA_ORIGIN (# 9)

Source Code Comments

DATA ORIGIN: Source system that created or updated the row.

Table GUBIPRF

Server Name S10B80
Database Name BANSECR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL
GUBIPRF_INST_KEY	VARCHAR2(8)	No
GUBIPRF_SECURITY_ENABLED_IND	VARCHAR2(1)	No
GUBIPRF_SEED1	NUMBER(30,0)	No
GUBIPRF_SEED2	NUMBER(30,0)	No
GUBIPRF_SEED3	NUMBER(30,0)	No
GUBIPRF_LOG_ACCESS_IND	VARCHAR2(1)	Yes
GUBIPRF_LOG_FROM_TIME	VARCHAR2(4)	Yes
GUBIPRF_LOG_TO_TIME	VARCHAR2(4)	Yes
GUBIPRF_ACTIVITY_DATE	DATE	No
GUBIPRF_CHECK_VERSION_IND	VARCHAR2(1)	Yes
GUBIPRF_CALL_QUERY_IND	VARCHAR2(1)	Yes
GUBIPRF_USER_ID	VARCHAR2(30)	No
GUBIPRF_DATA_ORIGIN	VARCHAR2(30)	Yes

Foreign Key information

No Foreign Key

Index

No Result

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GLOBAL_SECURITY_TYPE_IND	Oracle Package Variable	S10B80.BANSECR.G$_AUTHORIZATION_PKG	Rely On
G$_VERIFY_PASSWORD2_PRD	Oracle Package Procedure	S10B80.BANSECR.G$_SECURITY_PKG	Use (select)
GET_ROLE_PASSWD	Oracle Package Procedure	S10B80.BANSECR.GSPPRXY	Use (select)Rely On
CALL_QUERY_IND	Oracle Package Variable	S10B80.BANSECR.G$_SECURITY_PKG	Rely On
CHECK_VERSION_IND	Oracle Package Variable	S10B80.BANSECR.G$_SECURITY_PKG	Rely On
SECURITY_IND	Oracle Package Variable	S10B80.BANSECR.G$_SECURITY_PKG	Rely On
SEED2	Oracle Package Variable	S10B80.BANSECR.G$_SECURITY_PKG	Rely On
SEED3	Oracle Package Variable	S10B80.BANSECR.G$_SECURITY_PKG	Rely On
G$_SET_ROLE_PASSWORD_FNC	Oracle Package Function	S10B80.BANSECR.G$_SECURITY_PKG	Use (select)
G$_OREPSECR	Oracle Package Procedure	S10B80.BANSECR.G$_OREP_SECR_PKG	Use (select)Rely On
G$_AUTHORIZATION_PKG	Oracle Package	S10B80.BANSECR	Use (select)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GT_GUBIPRF_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.BANSECR.GUBIPRF

Object Dates

Creation Date	Analysis Date
04/03/2008 10:44:25:000	04/03/2008 10:47:27:000

Source Code Comments

GUBIPRF: Site profile record. This table contains only one record. It defines what level of security is being used, seed numbers and if version number checking is active.

Columns Comments for GUBIPRF_INST_KEY (# 1)

Source Code Comments

INSTITUTION KEY: The key to this record and has a value of INST.

Columns Comments for GUBIPRF_SECURITY_ENABLED_IND (# 2)

Source Code Comments

SECURITY INDICATOR: The type of security that is enabled for this database.

Columns Comments for GUBIPRF_SEED1 (# 3)

Source Code Comments

SEED 1: First of three unique security seed numbers for this database.

Columns Comments for GUBIPRF_SEED2 (# 4)

Source Code Comments

SEED 2: Second of three unique security seed numbers for this database.

Columns Comments for GUBIPRF_SEED3 (# 5)

Source Code Comments

SEED 3: Third of three unique security seed numbers for this database.

Columns Comments for GUBIPRF_LOG_ACCESS_IND (# 6)

Source Code Comments

LOG ACCESS INDICATOR: Future Use.

Columns Comments for GUBIPRF_LOG_FROM_TIME (# 7)

Source Code Comments

LOG FROM TIME: Future Use.

Columns Comments for GUBIPRF_LOG_TO_TIME (# 8)

Source Code Comments

LOG TO TIME: Future Use.

Columns Comments for GUBIPRF_ACTIVITY_DATE (# 9)

Source Code Comments

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

Columns Comments for GUBIPRF_CHECK_VERSION_IND (# 10)

Source Code Comments

CHECK VERSION: Indicator that determines whether the version of the form should be checked before executing.

Columns Comments for GUBIPRF_CALL_QUERY_IND (# 11)

Source Code Comments

CALL QUERY: Indicator to determine whether forms ending in _Q should be called with the CALL_QUERY command.

Columns Comments for GUBIPRF_USER_ID (# 12)

Source Code Comments

USER ID: User ID of the User who created or last updated the record.

Columns Comments for GUBIPRF_DATA_ORIGIN (# 13)

Source Code Comments

ACTIVITY DATE: Date record was created or last updated.

Table GUBROLE

Server Name S10B80
Database Name BANSECR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GUBROLE_ROLE	VARCHAR2(30)	No	*	*
GUBROLE_PASSWORD	VARCHAR2(30)	No
GUBROLE_ACTIVITY_DATE	DATE	No
GUBROLE_USER_ID	VARCHAR2(30)	No
GUBROLE_OWNER	VARCHAR2(30)	Yes
GUBROLE_COMMENTS	VARCHAR2(4000)	Yes
GUBROLE_DATA_ORIGIN	VARCHAR2(30)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GUBROLE_ROLE	GUROWNR_OBJECT	GUROWNR

Index

Index Name	Index Type	Column Name
PK_GUBROLE	Unique	GUBROLE_ROLE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GUVOWNR	SQL View	S10B80.BANSECR	Use (select)
TEST_GUVOWNR	SQL View	S10B80.BANSECR	Use (select)
G$_VERIFY_PASSWORD2_PRD	Oracle Package Procedure	S10B80.BANSECR.G$_SECURITY_PKG	Use (select)
G$_VERIFY_PASSWORD3_PRD	Oracle Package Procedure	S10B80.BANSECR.G$_SECURITY_PKG	Use (select)Rely On
GET_ROLE_PASSWD	Oracle Package Procedure	S10B80.BANSECR.GSPPRXY	Use (select)
G$_SET_ROLE_PASSWORD_FNC	Oracle Package Function	S10B80.BANSECR.G$_SECURITY_PKG	Use (Insert,update,select)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GUBROLE	SQL Index	S10B80.BANSECR	Rely On
GUROWNR	SQL Table	S10B80.BANSECR	Join
GT_GUBROLE_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.BANSECR.GUBROLE

Object Dates

Creation Date	Analysis Date
04/03/2008 10:43:50:000	04/03/2008 10:47:26:000

Source Code Comments

GUBROLE: This table stores the encrypted passwords for the Banner roles. This table is automatically maintained when passwords are generated or regenerated for the Banner roles.

Columns Comments for GUBROLE_ROLE (# 1)

Source Code Comments

ROLE: The Banner security role.

Columns Comments for GUBROLE_PASSWORD (# 2)

Source Code Comments

PASSWORD: Internally created password for this role.

Columns Comments for GUBROLE_ACTIVITY_DATE (# 3)

Source Code Comments

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

Columns Comments for GUBROLE_USER_ID (# 4)

Source Code Comments

USER ID: User ID of the user who created or last updated the record.

Columns Comments for GUBROLE_OWNER (# 5)

Source Code Comments

OWNER: The owner of the role for use by distributed security.

Columns Comments for GUBROLE_COMMENTS (# 6)

Source Code Comments

COMMENTS: Comments related to this role.

Columns Comments for GUBROLE_DATA_ORIGIN (# 7)

Source Code Comments

DATA ORIGIN: Source system that created or updated the row.

Table GURAAOB

Server Name S10B80
Database Name BANSECR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GURAAOB_AUDIT_TIME	UNDEFINED	No	*
GURAAOB_AUDIT_ACTION	VARCHAR2(1)	Yes
GURAAOB_OBJECT	VARCHAR2(30)	Yes
GURAAOB_DEFAULT_ROLE	VARCHAR2(30)	Yes
GURAAOB_CURRENT_VERSION	VARCHAR2(10)	Yes
GURAAOB_SYSI_CODE	VARCHAR2(2)	Yes
GURAAOB_ACTIVITY_DATE	DATE	Yes
GURAAOB_CHECKSUM	VARCHAR2(30)	Yes
GURAAOB_USER_ID	VARCHAR2(30)	Yes
GURAAOB_OWNER	VARCHAR2(30)	Yes
GURAAOB_COMMENTS	VARCHAR2(4000)	Yes
GURAAOB_DATA_ORIGIN	VARCHAR2(30)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GURAAOB	Unique	GURAAOB_AUDIT_TIME

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GT_GURAOBJ_AUDIT_ROW	SQL Trigger	S10B80.BANSECR	Use (Insert)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GURAAOB	SQL Index	S10B80.BANSECR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.BANSECR.GURAAOB

Object Dates

Creation Date	Analysis Date
04/03/2008 10:43:51:000	04/03/2008 10:47:26:000

Source Code Comments

GURAAOB: This table stores audit information for the GURAOBJ table.

Columns Comments for GURAAOB_AUDIT_TIME (# 1)

Source Code Comments

AUDIT TIME: The time the change was made to GURAOBJ.

Columns Comments for GURAAOB_AUDIT_ACTION (# 2)

Source Code Comments

AUDIT ACTION: The audit action taken (I)nsert, (U)pdate, or (D)elete.

Columns Comments for GURAAOB_OBJECT (# 3)

Source Code Comments

OBJECT: The Banner object name.

Columns Comments for GURAAOB_DEFAULT_ROLE (# 4)

Source Code Comments

DEFAULT ROLE: The default role defined for the object.

Columns Comments for GURAAOB_CURRENT_VERSION (# 5)

Source Code Comments

CURRENT VERSION: The current version of the object. This is also used in version checking.

Columns Comments for GURAAOB_SYSI_CODE (# 6)

Source Code Comments

SYSTEM CODE: A code used to identify which Banner application the object belongs to.

Columns Comments for GURAAOB_ACTIVITY_DATE (# 7)

Source Code Comments

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

Columns Comments for GURAAOB_CHECKSUM (# 8)

Source Code Comments

CHECKSUM: This is the encrypted checksum for the object. This value is generated by the gurchks process and is currently used only for Oracle Report programs.

Columns Comments for GURAAOB_USER_ID (# 9)

Source Code Comments

USER ID: User ID of the user who created or last updated the record.

Columns Comments for GURAAOB_OWNER (# 10)

Source Code Comments

OWNER: The owner of the object for use by distributed security.

Columns Comments for GURAAOB_COMMENTS (# 11)

Source Code Comments

COMMENTS: Comments related to this object.

Columns Comments for GURAAOB_DATA_ORIGIN (# 12)

Source Code Comments

DATA ORIGIN: Source system that created or updated the row.

Table GURAATB

Server Name S10B80
Database Name BANSECR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GURAATB_AUDIT_TIME	UNDEFINED	No	*
GURAATB_AUDIT_ACTION	VARCHAR2(1)	Yes
GURAATB_FORM_NAME	VARCHAR2(30)	Yes
GURAATB_INTERNAL_TAB_NAME	VARCHAR2(30)	Yes
GURAATB_EXTERNAL_TAB_NAME	VARCHAR2(30)	Yes
GURAATB_RESTRICTIONS	VARCHAR2(1)	Yes
GURAATB_SYS_REQ_IND	VARCHAR2(1)	Yes
GURAATB_ACTIVITY_DATE	DATE	Yes
GURAATB_USER_ID	VARCHAR2(30)	Yes
GURAATB_DATA_ORIGIN	VARCHAR2(30)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GURAATB	Unique	GURAATB_AUDIT_TIME

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GT_GURATAB_AUDIT_ROW	SQL Trigger	S10B80.BANSECR	Use (Insert)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GURAATB	SQL Index	S10B80.BANSECR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.BANSECR.GURAATB

Object Dates

Creation Date	Analysis Date
04/03/2008 10:43:54:000	04/03/2008 10:47:27:000

Source Code Comments

GURAATB: This table stores audit information for the GURATAB table.

Columns Comments for GURAATB_AUDIT_TIME (# 1)

Source Code Comments

AUDIT TIME: The time the change was made to GURATAB.

Columns Comments for GURAATB_AUDIT_ACTION (# 2)

Source Code Comments

AUDIT ACTION: The audit action taken (I)nsert, (U)pdate, or (D)elete.

Columns Comments for GURAATB_FORM_NAME (# 3)

Source Code Comments

FORM NAME: The Banner form name.

Columns Comments for GURAATB_INTERNAL_TAB_NAME (# 4)

Source Code Comments

INTERNAL TAB NAME: The internal name of the tab as defined in the form via Forms Builder.

Columns Comments for GURAATB_EXTERNAL_TAB_NAME (# 5)

Source Code Comments

EXTERNAL TAB NAME: The tab name that displays on the tab on the form in Banner.

Columns Comments for GURAATB_RESTRICTIONS (# 6)

Source Code Comments

ACCESS RESTRICTIONS: An indicator defining restrictions for a tab. N-no restrictions, Q-the tab must be Query or Full Access (i.e. it must be present), F-the tab must have Full access (i.e. may not be set to invisible or Query).

Columns Comments for GURAATB_SYS_REQ_IND (# 7)

Source Code Comments

SYSTEM REQUIRED INDICATOR: This field denotes whether the Tab record is system required. Valid values are (Y)es and (N)o.

Columns Comments for GURAATB_ACTIVITY_DATE (# 8)

Source Code Comments

ACTIVITY DATE: Date record was created or last updated.

Columns Comments for GURAATB_USER_ID (# 9)

Source Code Comments

USER ID: User ID of the User who created or last updated the record.

Columns Comments for GURAATB_DATA_ORIGIN (# 10)

Source Code Comments

DATA ORIGIN: Source system that created or updated the row.

Table GURABGP

Server Name S10B80
Database Name BANSECR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GURABGP_AUDIT_TIME	UNDEFINED	No	*
GURABGP_AUDIT_ACTION	VARCHAR2(1)	Yes
GURABGP_SGRP_CODE	VARCHAR2(30)	Yes
GURABGP_BUSINESS_PROFILE	VARCHAR2(30)	Yes
GURABGP_USER_ID	VARCHAR2(30)	Yes
GURABGP_ACTIVITY_DATE	DATE	Yes
GURABGP_DATA_ORIGIN	VARCHAR2(30)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GURABGP	Unique	GURABGP_AUDIT_TIME

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GT_GURBGRP_AUDIT_ROW	SQL Trigger	S10B80.BANSECR	Use (Insert)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GURABGP	SQL Index	S10B80.BANSECR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.BANSECR.GURABGP

Object Dates

Creation Date	Analysis Date
04/03/2008 10:44:01:000	04/03/2008 10:47:27:000

Source Code Comments

GURABGP: This table stores audit information for the GURBGRP table.

Columns Comments for GURABGP_AUDIT_TIME (# 1)

Source Code Comments

AUDIT TIME: The time the change was made to GURBGRP.

Columns Comments for GURABGP_AUDIT_ACTION (# 2)

Source Code Comments

AUDIT ACTION: The audit action taken (I)nsert, (U)pdate, or (D)elete.

Columns Comments for GURABGP_SGRP_CODE (# 3)

Source Code Comments

SECURITY GROUP: The name of a group of a security group.

Columns Comments for GURABGP_BUSINESS_PROFILE (# 4)

Source Code Comments

BUSINESS PROFILE: Banner business profile that is part of this group.

Columns Comments for GURABGP_USER_ID (# 5)

Source Code Comments

USER ID: User ID of the user who created or last updated the record.

Columns Comments for GURABGP_ACTIVITY_DATE (# 6)

Source Code Comments

ACTIVITY DATE: Date record was created or last updated.

Columns Comments for GURABGP_DATA_ORIGIN (# 7)

Source Code Comments

DATA ORIGIN: Source system that created or updated the row.

Table GURABPI

Server Name S10B80
Database Name BANSECR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GURABPI_AUDIT_TIME	UNDEFINED	No	*
GURABPI_AUDIT_ACTION	VARCHAR2(1)	Yes
GURABPI_FBPR_CODE	VARCHAR2(30)	Yes
GURABPI_FDMN_CODE	VARCHAR2(30)	Yes
GURABPI_ACTIVITY_DATE	DATE	Yes
GURABPI_USER_ID	VARCHAR2(30)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GURABPI	Unique	GURABPI_AUDIT_TIME

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GT_GORFBPI_AUDIT_ROW	SQL Trigger	S10B80.BANSECR	Use (Insert)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GURABPI	SQL Index	S10B80.BANSECR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.BANSECR.GURABPI

Object Dates

Creation Date	Analysis Date
04/03/2008 10:44:02:000	04/03/2008 10:47:27:000

Source Code Comments

GURABPI: This table stores audit information for the GURABPI table.

Columns Comments for GURABPI_AUDIT_TIME (# 1)

Source Code Comments

AUDIT TIME: The time the change was made to GURABPI.

Columns Comments for GURABPI_AUDIT_ACTION (# 2)

Source Code Comments

AUDIT ACTION: The audit action taken (I)nsert, (U)pdate, or (D)elete.

Columns Comments for GURABPI_FBPR_CODE (# 3)

Source Code Comments

FGAC BUSINESS PROFILE CODE: FGAC business profile code.

Columns Comments for GURABPI_FDMN_CODE (# 4)

Source Code Comments

DOMAIN CODE: PII domain the business profile is assigned.

Columns Comments for GURABPI_ACTIVITY_DATE (# 5)

Source Code Comments

ACTIVITY DATE: The most recent date a record was created or updated.

Columns Comments for GURABPI_USER_ID (# 6)

Source Code Comments

USER ID: The most recent user to create or update a record.

Table GURABPR

Server Name S10B80
Database Name BANSECR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GURABPR_AUDIT_TIME	UNDEFINED	No	*
GURABPR_AUDIT_ACTION	VARCHAR2(1)	Yes
GURABPR_FGAC_USER_ID	VARCHAR2(30)	Yes
GURABPR_FBPR_CODE	VARCHAR2(30)	Yes
GURABPR_ACTIVITY_DATE	DATE	Yes
GURABPR_USER_ID	VARCHAR2(30)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GURABPR	Unique	GURABPR_AUDIT_TIME

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GT_GORFBPR_AUDIT_ROW	SQL Trigger	S10B80.BANSECR	Use (Insert)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GURABPR	SQL Index	S10B80.BANSECR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.BANSECR.GURABPR

Object Dates

Creation Date	Analysis Date
04/03/2008 10:44:03:000	04/03/2008 10:47:27:000

Source Code Comments

GURABPR: This table stores audit information for the GORPBPR table.

Columns Comments for GURABPR_AUDIT_TIME (# 1)

Source Code Comments

AUDIT TIME: The time the change was made to GORPBPR.

Columns Comments for GURABPR_AUDIT_ACTION (# 2)

Source Code Comments

AUDIT ACTION: The audit action taken (I)nsert, (U)pdate, or (D)elete.

Columns Comments for GURABPR_FGAC_USER_ID (# 3)

Source Code Comments

FGAC USER ID: User ID for whom the business profile applies.

Columns Comments for GURABPR_FBPR_CODE (# 4)

Source Code Comments

FGAC BUSINESS PROFILE CODE: FGAC business profile code.

Columns Comments for GURABPR_ACTIVITY_DATE (# 5)

Source Code Comments

ACTIVITY DATE: The most recent date a record was created or updated.

Columns Comments for GURABPR_USER_ID (# 6)

Source Code Comments

USER ID: The most recent user to create or update a record.

Table GURACAL

Server Name S10B80
Database Name BANSECR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GURACAL_AUDIT_TIME	UNDEFINED	No	*
GURACAL_AUDIT_ACTION	VARCHAR2(1)	Yes
GURACAL_CALN_CODE	VARCHAR2(30)	Yes
GURACAL_PRIORITY	NUMBER(0,0)	Yes
GURACAL_ALLOW_IND	VARCHAR2(1)	Yes
GURACAL_START_DATE	DATE	Yes
GURACAL_END_DATE	DATE	Yes
GURACAL_START_TIME	VARCHAR2(4)	Yes
GURACAL_END_TIME	VARCHAR2(4)	Yes
GURACAL_DAY_1	VARCHAR2(1)	Yes
GURACAL_DAY_2	VARCHAR2(1)	Yes
GURACAL_DAY_3	VARCHAR2(1)	Yes
GURACAL_DAY_4	VARCHAR2(1)	Yes
GURACAL_DAY_5	VARCHAR2(1)	Yes
GURACAL_DAY_6	VARCHAR2(1)	Yes
GURACAL_DAY_7	VARCHAR2(1)	Yes
GURACAL_USER_ID	VARCHAR2(30)	Yes
GURACAL_ACTIVITY_DATE	DATE	Yes
GURACAL_COMMENTS	VARCHAR2(4000)	Yes
GURACAL_DATA_ORIGIN	VARCHAR2(30)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GURACAL	Unique	GURACAL_AUDIT_TIME

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GT_GURCALN_AUDIT_ROW	SQL Trigger	S10B80.BANSECR	Use (Insert)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GURACAL	SQL Index	S10B80.BANSECR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.BANSECR.GURACAL

Object Dates

Creation Date	Analysis Date
04/03/2008 10:44:06:000	04/03/2008 10:47:27:000

Source Code Comments

GURACAL: This table stores audit information for the GURCALN table.

Columns Comments for GURACAL_AUDIT_TIME (# 1)

Source Code Comments

AUDIT TIME: The time the change was made to GURCALN.

Columns Comments for GURACAL_AUDIT_ACTION (# 2)

Source Code Comments

AUDIT ACTION: The audit action taken (I)nsert, (U)pdate, or (D)elete.

Columns Comments for GURACAL_CALN_CODE (# 3)

Source Code Comments

CALENDAR: The name of the calendar used for logon verification.

Columns Comments for GURACAL_PRIORITY (# 4)

Source Code Comments

PRIORITY: The priority order in which calendar entries should be matched. A priority of 001 will be processed before a priority 002. The first entry that matches will be used.

Columns Comments for GURACAL_ALLOW_IND (# 5)

Source Code Comments

ALLOW INDICATOR: A value of "Y" indicates logons will be permitted during the days specified.

Columns Comments for GURACAL_START_DATE (# 6)

Source Code Comments

START DATE: The starting date of this calendar entry.

Columns Comments for GURACAL_END_DATE (# 7)

Source Code Comments

END DATE: The ending date of this calendar entry.

Columns Comments for GURACAL_START_TIME (# 8)

Source Code Comments

START TIME: The starting time of day that this entry refers to.

Columns Comments for GURACAL_END_TIME (# 9)

Source Code Comments

END TIME: The ending time of day that this entry refers to.

Columns Comments for GURACAL_DAY_1 (# 10)

Source Code Comments

DAY 1: The first day of the week (typically Sunday) that this entry refers to.

Columns Comments for GURACAL_DAY_2 (# 11)

Source Code Comments

DAY 2: The second day of the week that this entry refers to.

Columns Comments for GURACAL_DAY_3 (# 12)

Source Code Comments

DAY 3: The third day of the week that this entry refers to.

Columns Comments for GURACAL_DAY_4 (# 13)

Source Code Comments

DAY 4: The fourth day of the week that this entry refers to.

Columns Comments for GURACAL_DAY_5 (# 14)

Source Code Comments

DAY 5: The fifth day of the week that this entry refers to.

Columns Comments for GURACAL_DAY_6 (# 15)

Source Code Comments

DAY 6: The sixth day of the week that this entry refers to.

Columns Comments for GURACAL_DAY_7 (# 16)

Source Code Comments

DAY 7: The seventh day of the week that this entry refers to.

Columns Comments for GURACAL_USER_ID (# 17)

Source Code Comments

USER ID: User ID of the user who created or last updated the record.

Columns Comments for GURACAL_ACTIVITY_DATE (# 18)

Source Code Comments

ACTIVITY DATE: Date record was created or last updated.

Columns Comments for GURACAL_COMMENTS (# 19)

Source Code Comments

COMMENTS: Comments related to this class.

Columns Comments for GURACAL_DATA_ORIGIN (# 20)

Source Code Comments

DATA ORIGIN: Source system that created or updated the row.

Table GURACGP

Server Name S10B80
Database Name BANSECR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GURACGP_AUDIT_TIME	UNDEFINED	No	*
GURACGP_AUDIT_ACTION	VARCHAR2(1)	Yes
GURACGP_SGRP_CODE	VARCHAR2(30)	Yes
GURACGP_CLASS	VARCHAR2(30)	Yes
GURACGP_USER_ID	VARCHAR2(30)	Yes
GURACGP_ACTIVITY_DATE	DATE	Yes
GURACGP_DATA_ORIGIN	VARCHAR2(30)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GURACGP	Unique	GURACGP_AUDIT_TIME

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GT_GURCGRP_AUDIT_ROW	SQL Trigger	S10B80.BANSECR	Use (Insert)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GURACGP	SQL Index	S10B80.BANSECR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.BANSECR.GURACGP

Object Dates

Creation Date	Analysis Date
04/03/2008 10:44:09:000	04/03/2008 10:47:27:000

Source Code Comments

GURACGP: This table stores audit information for the GURCGRP table.

Columns Comments for GURACGP_AUDIT_TIME (# 1)

Source Code Comments

AUDIT TIME: The time the change was made to GURCGRP.

Columns Comments for GURACGP_AUDIT_ACTION (# 2)

Source Code Comments

AUDIT ACTION: The audit action taken (I)nsert, (U)pdate, or (D)elete.

Columns Comments for GURACGP_SGRP_CODE (# 3)

Source Code Comments

SECURITY GROUP: The name of a security group.

Columns Comments for GURACGP_CLASS (# 4)

Source Code Comments

CLASS: Banner class that is part of this group.

Columns Comments for GURACGP_USER_ID (# 5)

Source Code Comments

USER ID: User ID of the user who created or last updated the record.

Columns Comments for GURACGP_ACTIVITY_DATE (# 6)

Source Code Comments

ACTIVITY DATE: Date record was created or last updated.

Columns Comments for GURACGP_DATA_ORIGIN (# 7)

Source Code Comments

DATA ORIGIN: Source system that created or updated the row.

Table GURACLS

Server Name S10B80
Database Name BANSECR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GURACLS_AUDIT_TIME	UNDEFINED	No	*
GURACLS_AUDIT_ACTION	VARCHAR2(1)	Yes
GURACLS_USERID	VARCHAR2(30)	Yes
GURACLS_CLASS_CODE	VARCHAR2(30)	Yes
GURACLS_ACTIVITY_DATE	DATE	Yes
GURACLS_USER_ID	VARCHAR2(30)	Yes
GURACLS_COMMENTS	VARCHAR2(4000)	Yes
GURACLS_DATA_ORIGIN	VARCHAR2(30)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GURACLS	Unique	GURACLS_AUDIT_TIME

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GT_GURUCLS_AUDIT_ROW	SQL Trigger	S10B80.BANSECR	Use (Insert)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GURACLS	SQL Index	S10B80.BANSECR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.BANSECR.GURACLS

Object Dates

Creation Date	Analysis Date
04/03/2008 10:44:10:000	04/03/2008 10:47:27:000

Source Code Comments

GURACLS: This table stores audit information for the GURACLS table.

Columns Comments for GURACLS_AUDIT_TIME (# 1)

Source Code Comments

AUDIT TIME: The time the change was made to GURACLS.

Columns Comments for GURACLS_AUDIT_ACTION (# 2)

Source Code Comments

AUDIT ACTION: The audit action taken (I)nsert, (U)pdate, or (D)elete.

Columns Comments for GURACLS_USERID (# 3)

Source Code Comments

USERID: The Oracle User ID associated with the class code.

Columns Comments for GURACLS_CLASS_CODE (# 4)

Source Code Comments

CLASS CODE: The class code assigned to the userid.

Columns Comments for GURACLS_ACTIVITY_DATE (# 5)

Source Code Comments

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

Columns Comments for GURACLS_USER_ID (# 6)

Source Code Comments

USER ID: User ID of the user who created or last updated the record.

Columns Comments for GURACLS_COMMENTS (# 7)

Source Code Comments

COMMENTS: Comments related to this class.

Columns Comments for GURACLS_DATA_ORIGIN (# 8)

Source Code Comments

DATA ORIGIN: Source system that created or updated the row.

Table GURADMN

Server Name S10B80
Database Name BANSECR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GURADMN_AUDIT_TIME	UNDEFINED	No	*
GURADMN_AUDIT_ACTION	VARCHAR2(1)	Yes
GURADMN_FDMN_CODE	VARCHAR2(30)	Yes
GURADMN_TABLE_NAME	VARCHAR2(30)	Yes
GURADMN_FDTP_CODE	VARCHAR2(5)	Yes
GURADMN_SYS_REQ_IND	VARCHAR2(1)	Yes
GURADMN_ENABLE_PII_IND	VARCHAR2(1)	Yes
GURADMN_ACTIVITY_DATE	DATE	Yes
GURADMN_USER_ID	VARCHAR2(30)	Yes
GURADMN_PII_COLUMN_NAME	VARCHAR2(30)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GURADMN	Unique	GURADMN_AUDIT_TIME

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GT_GOBFDMN_AUDIT_ROW	SQL Trigger	S10B80.BANSECR	Use (Insert)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GURADMN	SQL Index	S10B80.BANSECR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.BANSECR.GURADMN

Object Dates

Creation Date	Analysis Date
04/03/2008 10:44:13:000	04/03/2008 10:47:27:000

Source Code Comments

GURADMN: This table stores audit information for the GOBFDMN table.

Columns Comments for GURADMN_AUDIT_TIME (# 1)

Source Code Comments

AUDIT TIME: The time the change was made to GOBFDMN.

Columns Comments for GURADMN_AUDIT_ACTION (# 2)

Source Code Comments

AUDIT ACTION: The audit action taken (I)nsert, (U)pdate, or (D)elete.

Columns Comments for GURADMN_FDMN_CODE (# 3)

Source Code Comments

DOMAIN CODE: FGAC Domain code.

Columns Comments for GURADMN_TABLE_NAME (# 4)

Source Code Comments

TABLE NAME: Table name that is the driver for the FGAC domain.

Columns Comments for GURADMN_FDTP_CODE (# 5)

Source Code Comments

DOMAIN TYPE CODE: FGAC Domain type code.

Columns Comments for GURADMN_SYS_REQ_IND (# 6)

Source Code Comments

SYSTEM REQUIRED INDICATOR: Indicates whether or not this domain is system required.

Columns Comments for GURADMN_ENABLE_PII_IND (# 7)

Source Code Comments

PII ENABLE IND: Y/N indicator to enable the PII domain.

Columns Comments for GURADMN_ACTIVITY_DATE (# 8)

Source Code Comments

ACTIVITY DATE: The most recent date a record was created or updated.

Columns Comments for GURADMN_USER_ID (# 9)

Source Code Comments

USER ID: The most recent user to create or update a record.

Columns Comments for GURADMN_PII_COLUMN_NAME (# 10)

Source Code Comments

PII COLUMN NAME: Column name PII process will use to match PIDM values to driver table.

Table GURADPI

Server Name S10B80
Database Name BANSECR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GURADPI_AUDIT_TIME	UNDEFINED	No	*
GURADPI_AUDIT_ACTION	VARCHAR2(1)	Yes
GURADPI_TABLE_NAME	VARCHAR2(30)	Yes
GURADPI_COLUMN_NAME	VARCHAR2(30)	Yes
GURADPI_SYS_REQ_IND	VARCHAR2(1)	Yes
GURADPI_ACTIVE_IND	VARCHAR2(1)	Yes
GURADPI_USER_ID	VARCHAR2(30)	Yes
GURADPI_ACTIVITY_DATE	DATE	Yes
GURADPI_DRIVER_SQL	VARCHAR2(2000)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GURADPI	Unique	GURADPI_AUDIT_TIME

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GT_GORFDPI_AUDIT_ROW	SQL Trigger	S10B80.BANSECR	Use (Insert)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GURADPI	SQL Index	S10B80.BANSECR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.BANSECR.GURADPI

Object Dates

Creation Date	Analysis Date
04/03/2008 10:44:14:000	04/03/2008 10:47:27:000

Source Code Comments

GURADPI: This table stores audit information for the GORFDPI table.

Columns Comments for GURADPI_AUDIT_TIME (# 1)

Source Code Comments

AUDIT TIME: The time the change was made to GORFDPI.

Columns Comments for GURADPI_AUDIT_ACTION (# 2)

Source Code Comments

AUDIT ACTION: The audit action taken (I)nsert, (U)pdate, or (D)elete.

Columns Comments for GURADPI_TABLE_NAME (# 3)

Source Code Comments

TABLE NAME: Table name that the policy covers.

Columns Comments for GURADPI_COLUMN_NAME (# 4)

Source Code Comments

COLUMN NAME: Column name in table that all PII Columns are compared to.

Columns Comments for GURADPI_SYS_REQ_IND (# 5)

Source Code Comments

SYSTEM REQUIRED INDICATOR: Indicates whether or not this domain is system required.

Columns Comments for GURADPI_ACTIVE_IND (# 6)

Source Code Comments

ACTIVE INDICATOR: Indicates whether or not this domain table is active. The GOKFGAC predicate functions will not select rules if this indicator is inactive.

Columns Comments for GURADPI_USER_ID (# 7)

Source Code Comments

USER ID: The most recent user to create or update a record.

Columns Comments for GURADPI_ACTIVITY_DATE (# 8)

Source Code Comments

ACTIVITY DATE: The most recent date a record was created or updated.

Columns Comments for GURADPI_DRIVER_SQL (# 9)

Source Code Comments

DRIVER SQL: SQL statement that contains the SQL statement to execute the PII procedure.

Table GURADPL

Server Name S10B80
Database Name BANSECR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GURADPL_AUDIT_TIME	UNDEFINED	No	*
GURADPL_AUDIT_ACTION	VARCHAR2(1)	Yes
GURADPL_FDMN_CODE	VARCHAR2(30)	Yes
GURADPL_TABLE_NAME	VARCHAR2(30)	Yes
GURADPL_SYS_REQ_IND	VARCHAR2(1)	Yes
GURADPL_ACTIVE_IND	VARCHAR2(1)	Yes
GURADPL_USER_ID	VARCHAR2(30)	Yes
GURADPL_ACTIVITY_DATE	DATE	Yes
GURADPL_DRIVER_SQL	VARCHAR2(2000)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GURADPL	Unique	GURADPL_AUDIT_TIME

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GT_GORFDPL_AUDIT_ROW	SQL Trigger	S10B80.BANSECR	Use (Insert)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GURADPL	SQL Index	S10B80.BANSECR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.BANSECR.GURADPL

Object Dates

Creation Date	Analysis Date
04/03/2008 10:44:15:000	04/03/2008 10:47:27:000

Source Code Comments

GURADPL: This table stores audit information for the GORFDPL table.

Columns Comments for GURADPL_AUDIT_TIME (# 1)

Source Code Comments

AUDIT TIME: The time the change was made to GORFDPL.

Columns Comments for GURADPL_AUDIT_ACTION (# 2)

Source Code Comments

AUDIT ACTION: The audit action taken (I)nsert, (U)pdate, or (D)elete.

Columns Comments for GURADPL_FDMN_CODE (# 3)

Source Code Comments

DOMAIN CODE: FGAC Domain code.

Columns Comments for GURADPL_TABLE_NAME (# 4)

Source Code Comments

TABLE NAME: Table name that the policy covers.

Columns Comments for GURADPL_SYS_REQ_IND (# 5)

Source Code Comments

SYSTEM REQUIRED INDICATOR: Indicates whether or not this domain is system required.

Columns Comments for GURADPL_ACTIVE_IND (# 6)

Source Code Comments

ACTIVE INDICATOR: Indicates whether or not this table for the domain is active. The GOKFGAC predicate functions will not select rules if the table is inactive.

Columns Comments for GURADPL_USER_ID (# 7)

Source Code Comments

USER ID: The most recent user to create or update a record.

Columns Comments for GURADPL_ACTIVITY_DATE (# 8)

Source Code Comments

ACTIVITY DATE: The most recent date a record was created or updated.

Columns Comments for GURADPL_DRIVER_SQL (# 9)

Source Code Comments

DRIVER SQL: SQL statement that links the table to the FDMN driver table.

Table GURAEAC

Server Name S10B80
Database Name BANSECR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GURAEAC_AUDIT_TIME	UNDEFINED	No	*
GURAEAC_AUDIT_ACTION	VARCHAR2(1)	Yes
GURAEAC_PIDM	NUMBER(8,0)	Yes
GURAEAC_USERNAME	VARCHAR2(30)	Yes
GURAEAC_USER_ID	VARCHAR2(30)	Yes
GURAEAC_ACTIVITY_DATE	DATE	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GURAEAC	Unique	GURAEAC_AUDIT_TIME

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GT_GOBEACC_AUDIT_ROW	SQL Trigger	S10B80.BANSECR	Use (Insert)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GURAEAC	SQL Index	S10B80.BANSECR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.BANSECR.GURAEAC

Object Dates

Creation Date	Analysis Date
04/03/2008 10:44:21:000	04/03/2008 10:47:27:000

Source Code Comments

GURAEAC: This table stores audit information for the GOBEACC table.

Columns Comments for GURAEAC_AUDIT_TIME (# 1)

Source Code Comments

AUDIT TIME: The time the change was made to GOBEACC.

Columns Comments for GURAEAC_AUDIT_ACTION (# 2)

Source Code Comments

AUDIT ACTION: The audit action taken (I)nsert, (U)pdate, or (D)elete.

Columns Comments for GURAEAC_PIDM (# 3)

Source Code Comments

PIDM: System generated unique PIDM associated with user.

Columns Comments for GURAEAC_USERNAME (# 4)

Source Code Comments

USERNAME: Oracle user ID.

Columns Comments for GURAEAC_USER_ID (# 5)

Source Code Comments

USER ID: Current user, system updated.

Columns Comments for GURAEAC_ACTIVITY_DATE (# 6)

Source Code Comments

ACTIVITY DATE: System date of insert or update.

Table GURAEOB

Server Name S10B80
Database Name BANSECR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GURAEOB_AUDIT_TIME	UNDEFINED	No	*
GURAEOB_AUDIT_ACTION	VARCHAR2(1)	Yes
GURAEOB_OBJECT	VARCHAR2(30)	Yes
GURAEOB_ACTIVITY_DATE	DATE	Yes
GURAEOB_USER_ID	VARCHAR2(30)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GURAEOB	Unique	GURAEOB_AUDIT_TIME

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GT_GOBFEOB_AUDIT_ROW	SQL Trigger	S10B80.BANSECR	Use (Insert)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GURAEOB	SQL Index	S10B80.BANSECR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.BANSECR.GURAEOB

Object Dates

Creation Date	Analysis Date
04/03/2008 10:44:22:000	04/03/2008 10:47:27:000

Source Code Comments

GURAEOB: This table stores audit information for the GOBFEOB table.

Columns Comments for GURAEOB_AUDIT_TIME (# 1)

Source Code Comments

AUDIT TIME: The time the change was made to GOBFEOB.

Columns Comments for GURAEOB_AUDIT_ACTION (# 2)

Source Code Comments

AUDIT ACTION: The audit action taken (I)nsert, (U)pdate, or (D)elete.

Columns Comments for GURAEOB_OBJECT (# 3)

Source Code Comments

OBJECT: Object excluded from FGAC processing.

Columns Comments for GURAEOB_ACTIVITY_DATE (# 4)

Source Code Comments

ACTIVITY DATE: The most recent date a record was created or updated.

Columns Comments for GURAEOB_USER_ID (# 5)

Source Code Comments

USER ID: The most recent user to create or update a record.

Table GURAGAC

Server Name S10B80
Database Name BANSECR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GURAGAC_AUDIT_TIME	UNDEFINED	No	*
GURAGAC_AUDIT_ACTION	VARCHAR2(1)	Yes
GURAGAC_FGAC_CODE	VARCHAR2(30)	Yes
GURAGAC_ACTIVE_IND	VARCHAR2(1)	Yes
GURAGAC_EFF_DATE	DATE	Yes
GURAGAC_ACTIVITY_DATE	DATE	Yes
GURAGAC_USER_ID	VARCHAR2(30)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GURAGAC	Unique	GURAGAC_AUDIT_TIME

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GT_GOBFGAC_AUDIT_ROW	SQL Trigger	S10B80.BANSECR	Use (Insert)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GURAGAC	SQL Index	S10B80.BANSECR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.BANSECR.GURAGAC

Object Dates

Creation Date	Analysis Date
04/03/2008 10:43:41:000	04/03/2008 10:47:26:000

Source Code Comments

GURAGAC: This table stores audit information for the GOBFGAC table.

Columns Comments for GURAGAC_AUDIT_TIME (# 1)

Source Code Comments

AUDIT TIME: The time the change was made to GOBFGAC.

Columns Comments for GURAGAC_AUDIT_ACTION (# 2)

Source Code Comments

AUDIT ACTION: The audit action taken (I)nsert, (U)pdate, or (D)elete.

Columns Comments for GURAGAC_FGAC_CODE (# 3)

Source Code Comments

FGAC CODE: FGAC group code.

Columns Comments for GURAGAC_ACTIVE_IND (# 4)

Source Code Comments

ACTIVE IND: Y/N indicator if the FGAC rule is active.

Columns Comments for GURAGAC_EFF_DATE (# 5)

Source Code Comments

EFF DATE: Date when the FGAC rule is active.

Columns Comments for GURAGAC_ACTIVITY_DATE (# 6)

Source Code Comments

ACTIVITY DATE: The most recent date a record was created or updated.

Columns Comments for GURAGAC_USER_ID (# 7)

Source Code Comments

USER ID: The most recent user to create or update a record.

Table GURAGBP

Server Name S10B80
Database Name BANSECR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GURAGBP_AUDIT_TIME	UNDEFINED	No	*
GURAGBP_AUDIT_ACTION	VARCHAR2(1)	Yes
GURAGBP_FGAC_CODE	VARCHAR2(30)	Yes
GURAGBP_FDMN_CODE	VARCHAR2(30)	Yes
GURAGBP_FPRD_SEQNO	NUMBER(4,0)	Yes
GURAGBP_FBPR_CODE	VARCHAR2(30)	Yes
GURAGBP_SELECT_IND	VARCHAR2(1)	Yes
GURAGBP_INSERT_IND	VARCHAR2(1)	Yes
GURAGBP_UPDATE_IND	VARCHAR2(1)	Yes
GURAGBP_DELETE_IND	VARCHAR2(1)	Yes
GURAGBP_ACTIVITY_DATE	DATE	Yes
GURAGBP_USER_ID	VARCHAR2(30)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GURAGBP	Unique	GURAGBP_AUDIT_TIME

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GT_GORFGBP_AUDIT_ROW	SQL Trigger	S10B80.BANSECR	Use (Insert)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GURAGBP	SQL Index	S10B80.BANSECR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.BANSECR.GURAGBP

Object Dates

Creation Date	Analysis Date
04/03/2008 10:43:43:000	04/03/2008 10:47:26:000

Source Code Comments

GURAGBP: This table stores audit information for the GORFGBP table.

Columns Comments for GURAGBP_AUDIT_TIME (# 1)

Source Code Comments

AUDIT TIME: The time the change was made to GORFGBP.

Columns Comments for GURAGBP_AUDIT_ACTION (# 2)

Source Code Comments

AUDIT ACTION: The audit action taken (I)nsert, (U)pdate, or (D)elete.

Columns Comments for GURAGBP_FGAC_CODE (# 3)

Source Code Comments

FGAC CODE: FGAC group code.

Columns Comments for GURAGBP_FDMN_CODE (# 4)

Source Code Comments

FGAC DOMAIN CODE: FGAC domain code.

Columns Comments for GURAGBP_FPRD_SEQNO (# 5)

Source Code Comments

PREDICATE SEQNO: One up number per predicate and domain to allow multiple predicates per domain.

Columns Comments for GURAGBP_FBPR_CODE (# 6)

Source Code Comments

FGAC BUSINESS PROFILE CODE: FGAC business profile code.

Columns Comments for GURAGBP_SELECT_IND (# 7)

Source Code Comments

SELECT IND: Y/N indicator if the business profile is for select access.

Columns Comments for GURAGBP_INSERT_IND (# 8)

Source Code Comments

INSERT IND: Y/N indicator if the business profile is for insert access.

Columns Comments for GURAGBP_UPDATE_IND (# 9)

Source Code Comments

UPDATE IND: Y/N indicator if the business profile is for update access.

Columns Comments for GURAGBP_DELETE_IND (# 10)

Source Code Comments

DELETE IND: Y/N indicator if the business profile is for delete access.

Columns Comments for GURAGBP_ACTIVITY_DATE (# 11)

Source Code Comments

ACTIVITY DATE: The most recent date a record was created or updated.

Columns Comments for GURAGBP_USER_ID (# 12)

Source Code Comments

USER ID: The most recent user to create or update a record.

Table GURAGUS

Server Name S10B80
Database Name BANSECR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GURAGUS_AUDIT_TIME	UNDEFINED	No	*
GURAGUS_AUDIT_ACTION	VARCHAR2(1)	Yes
GURAGUS_FGAC_CODE	VARCHAR2(30)	Yes
GURAGUS_FDMN_CODE	VARCHAR2(30)	Yes
GURAGUS_FPRD_SEQNO	NUMBER(4,0)	Yes
GURAGUS_FGAC_USER_ID	VARCHAR2(30)	Yes
GURAGUS_SELECT_IND	VARCHAR2(1)	Yes
GURAGUS_INSERT_IND	VARCHAR2(1)	Yes
GURAGUS_UPDATE_IND	VARCHAR2(1)	Yes
GURAGUS_DELETE_IND	VARCHAR2(1)	Yes
GURAGUS_ACTIVITY_DATE	DATE	Yes
GURAGUS_USER_ID	VARCHAR2(30)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GURAGUS	Unique	GURAGUS_AUDIT_TIME

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GT_GORFGUS_AUDIT_ROW	SQL Trigger	S10B80.BANSECR	Use (Insert)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GURAGUS	SQL Index	S10B80.BANSECR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.BANSECR.GURAGUS

Object Dates

Creation Date	Analysis Date
04/03/2008 10:43:46:000	04/03/2008 10:47:26:000

Source Code Comments

GURAGUS: This table stores audit information for the GORFGUS table.

Columns Comments for GURAGUS_AUDIT_TIME (# 1)

Source Code Comments

AUDIT TIME: The time the change was made to GORFGUS.

Columns Comments for GURAGUS_AUDIT_ACTION (# 2)

Source Code Comments

AUDIT ACTION: The audit action taken (I)nsert, (U)pdate, or (D)elete.

Columns Comments for GURAGUS_FGAC_CODE (# 3)

Source Code Comments

FGAC CODE: FGAC group code.

Columns Comments for GURAGUS_FDMN_CODE (# 4)

Source Code Comments

FGAC DOMAIN CODE: FGAC domain code.

Columns Comments for GURAGUS_FPRD_SEQNO (# 5)

Source Code Comments

PREDICATE SEQNO: One up number per predicate and domain to allow multiple predicates per domain.

Columns Comments for GURAGUS_FGAC_USER_ID (# 6)

Source Code Comments

FGAC USER ID: User ID that is being assigned to the FGAC group and domain.

Columns Comments for GURAGUS_SELECT_IND (# 7)

Source Code Comments

SELECT IND: Y/N indicator if the FGAC user has select access.

Columns Comments for GURAGUS_INSERT_IND (# 8)

Source Code Comments

INSERT IND: Y/N indicator if the FGAC user has insert access.

Columns Comments for GURAGUS_UPDATE_IND (# 9)

Source Code Comments

UPDATE IND: Y/N indicator if the FGAC user has update access.

Columns Comments for GURAGUS_DELETE_IND (# 10)

Source Code Comments

DELETE IND: Y/N indicator if the FGAC user has delete access.

Columns Comments for GURAGUS_ACTIVITY_DATE (# 11)

Source Code Comments

ACTIVITY DATE: The most recent date a record was created or updated.

Columns Comments for GURAGUS_USER_ID (# 12)

Source Code Comments

USER ID: The most recent user to create or update a record.

Table GURAINV

Server Name S10B80
Database Name BANSECR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GURAINV_AUDIT_TIME	UNDEFINED	No	*
GURAINV_AUDIT_ACTION	VARCHAR2(1)	Yes
GURAINV_PARM_TYPE	VARCHAR2(3)	Yes
GURAINV_VALID_OR_INVALID	VARCHAR2(1)	Yes
GURAINV_CHARACTERS	VARCHAR2(255)	Yes
GURAINV_USER_ID	VARCHAR2(30)	Yes
GURAINV_ACTIVITY_DATE	DATE	Yes
GURAINV_DATA_ORIGIN	VARCHAR2(30)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GURAINV	Unique	GURAINV_AUDIT_TIME

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GT_GJRINVC_AUDIT_ROW	SQL Trigger	S10B80.BANSECR	Use (Insert)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GURAINV	SQL Index	S10B80.BANSECR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.BANSECR.GURAINV

Object Dates

Creation Date	Analysis Date
04/03/2008 10:43:56:000	04/03/2008 10:47:27:000

Source Code Comments

GURAINV: This table stores audit information for the GJRINVC table.

Columns Comments for GURAINV_AUDIT_TIME (# 1)

Source Code Comments

AUDIT TIME: The time the change was made to GJRINVC.

Columns Comments for GURAINV_AUDIT_ACTION (# 2)

Source Code Comments

AUDIT ACTION: The audit action taken (I)nsert, (U)pdate, or (D)elete.

Columns Comments for GURAINV_PARM_TYPE (# 3)

Source Code Comments

PARAMETER TYPE: Type of Job Submission parameter for which characters are listed in column GURAINV_CHARACTERS. Valid values are UID for User ID, PWD for password, and PRT for print command.

Columns Comments for GURAINV_VALID_OR_INVALID (# 4)

Source Code Comments

VALID OR INVALID: Indicates if this rows list of characters are either Valid or Invalid for inclusion in a parameter for the associated Type column. Valid values are I or V.

Columns Comments for GURAINV_CHARACTERS (# 5)

Source Code Comments

Columns Comments for GURAINV_USER_ID (# 6)

Source Code Comments

USER ID: User ID of the User who created or last updated the row.

Columns Comments for GURAINV_ACTIVITY_DATE (# 7)

Source Code Comments

ACTIVITY DATE: Date the row was created or last updated.

Columns Comments for GURAINV_DATA_ORIGIN (# 8)

Source Code Comments

DATA ORIGIN: Source system that created or updated the row.

Table GURAIPF

Server Name S10B80
Database Name BANSECR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GURAIPF_AUDIT_TIME	UNDEFINED	No	*
GURAIPF_AUDIT_ACTION	VARCHAR2(1)	Yes
GURAIPF_INST_KEY	VARCHAR2(8)	Yes
GURAIPF_SECURITY_ENABLED_IND	VARCHAR2(1)	Yes
GURAIPF_SEED1	NUMBER(30,0)	Yes
GURAIPF_SEED2	NUMBER(30,0)	Yes
GURAIPF_SEED3	NUMBER(30,0)	Yes
GURAIPF_LOG_ACCESS_IND	VARCHAR2(1)	Yes
GURAIPF_LOG_FROM_TIME	VARCHAR2(4)	Yes
GURAIPF_LOG_TO_TIME	VARCHAR2(4)	Yes
GURAIPF_ACTIVITY_DATE	DATE	Yes
GURAIPF_CHECK_VERSION_IND	VARCHAR2(1)	Yes
GURAIPF_CALL_QUERY_IND	VARCHAR2(1)	Yes
GURAIPF_USER_ID	VARCHAR2(30)	Yes
GURAIPF_DATA_ORIGIN	VARCHAR2(30)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GURAIPF	Unique	GURAIPF_AUDIT_TIME

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GT_GUBIPRF_AUDIT_ROW	SQL Trigger	S10B80.BANSECR	Use (Insert)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GURAIPF	SQL Index	S10B80.BANSECR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.BANSECR.GURAIPF

Object Dates

Creation Date	Analysis Date
04/03/2008 10:43:58:000	04/03/2008 10:47:27:000

Source Code Comments

GURAIPF: This table stores audit information for the GUBIPRF table.

Columns Comments for GURAIPF_AUDIT_TIME (# 1)

Source Code Comments

AUDIT TIME: The time the change was made to GUBIPRF.

Columns Comments for GURAIPF_AUDIT_ACTION (# 2)

Source Code Comments

AUDIT ACTION: The audit action taken (I)nsert, (U)pdate, or (D)elete.

Columns Comments for GURAIPF_INST_KEY (# 3)

Source Code Comments

INSTITUITION KEY: The key to this record and has a value of INST.

Columns Comments for GURAIPF_SECURITY_ENABLED_IND (# 4)

Source Code Comments

SECURITY INDICATOR: The type of security that is enabled for this database.

Columns Comments for GURAIPF_SEED1 (# 5)

Source Code Comments

SEED 1: First of three unique security seed numbers for this database.

Columns Comments for GURAIPF_SEED2 (# 6)

Source Code Comments

SEED 2: Second of three unique security seed numbers for this database.

Columns Comments for GURAIPF_SEED3 (# 7)

Source Code Comments

SEED 3: Third of three unique security seed numbers for this database.

Columns Comments for GURAIPF_LOG_ACCESS_IND (# 8)

Source Code Comments

LOG ACCESS INDICATOR: Future Use.

Columns Comments for GURAIPF_LOG_FROM_TIME (# 9)

Source Code Comments

LOG FROM TIME: Future Use.

Columns Comments for GURAIPF_LOG_TO_TIME (# 10)

Source Code Comments

LOG TO TIME: Future Use.

Columns Comments for GURAIPF_ACTIVITY_DATE (# 11)

Source Code Comments

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

Columns Comments for GURAIPF_CHECK_VERSION_IND (# 12)

Source Code Comments

CHECK VERSION: Indicator that determines whether the version of the form should be checked before executing.

Columns Comments for GURAIPF_CALL_QUERY_IND (# 13)

Source Code Comments

CALL QUERY: Indicator to determine whether forms ending in _Q should be called with the CALL_QUERY command.

Columns Comments for GURAIPF_USER_ID (# 14)

Source Code Comments

USER ID: User ID of the User who created or last updated the record.

Columns Comments for GURAIPF_DATA_ORIGIN (# 15)

Source Code Comments

ACTIVITY DATE: Date record was created or last updated.

Table GURALGN

Server Name S10B80
Database Name BANSECR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GURALGN_SADDR	RAW(8)	No
GURALGN_SID	NUMBER(0,0)	No
GURALGN_SERIAL	NUMBER(0,0)	No
GURALGN_AUDSID	NUMBER(0,0)	No	*
GURALGN_USERNAME	VARCHAR2(30)	No	*
GURALGN_PROCESS	VARCHAR2(12)	No
GURALGN_MACHINE	VARCHAR2(64)	No
GURALGN_LOGON_TIME	DATE	No
GURALGN_IPADDR	VARCHAR2(15)	Yes
GURALGN_OSUSER	VARCHAR2(30)	Yes
GURALGN_TERMINAL	VARCHAR2(30)	Yes
GURALGN_PROGRAM	VARCHAR2(64)	Yes
GURALGN_MODULE	VARCHAR2(48)	Yes
GURALGN_SERVICE_NAME	VARCHAR2(64)	Yes
GURALGN_LOGOFF_TIME	DATE	Yes
GURALGN_TOTAL_TIME	VARCHAR2(12)	Yes
GURALGN_LOGON_COMMENT	VARCHAR2(100)	Yes
GURALGN_LOGOFF_COMMENT	VARCHAR2(100)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GURALGN	Unique	GURALGN_USERNAME
PK_GURALGN	Unique	GURALGN_AUDSID

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
G$_AUDIT_BANNER_LOGOFF	Oracle Package Procedure	S10B80.BANSECR.G$_SECURITY_PKG	Use (Insert,update,select)
G$_AUDIT_BANNER_LOGON	Oracle Package Procedure	S10B80.BANSECR.G$_SECURITY_PKG	Use (Insert,delete,select)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GURALGN	SQL Index	S10B80.BANSECR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.BANSECR.GURALGN

Object Dates

Creation Date	Analysis Date
04/03/2008 10:44:16:000	04/03/2008 10:47:27:000

Source Code Comments

GURALGN: This table stores information related to logins to Oracle by users of Banner as defined in GURUCLS.

Columns Comments for GURALGN_SADDR (# 1)

Source Code Comments

SESSION ADDR: Session address.

Columns Comments for GURALGN_SID (# 2)

Source Code Comments

SESSION ID: Session identifier.

Columns Comments for GURALGN_SERIAL (# 3)

Source Code Comments

SERIAL NUMBER: Session serial number. Used to uniquely identify the object in a session. Guarantees that session-level commands are applied to the correct session objects if the session ends and another session begins with the same session ID.

Columns Comments for GURALGN_AUDSID (# 4)

Source Code Comments

AUDIT SESSION ID: Auditing session ID.

Columns Comments for GURALGN_USERNAME (# 5)

Source Code Comments

USERNAME: Oracle username.

Columns Comments for GURALGN_PROCESS (# 6)

Source Code Comments

PROCESS: Operating system client process ID.

Columns Comments for GURALGN_MACHINE (# 7)

Source Code Comments

MACHINE: Operating system machine name.

Columns Comments for GURALGN_LOGON_TIME (# 8)

Source Code Comments

LOGON TIME: Time of logon.

Columns Comments for GURALGN_IPADDR (# 9)

Source Code Comments

IP ADDRESS: The IP address of the user logging on.

Columns Comments for GURALGN_OSUSER (# 10)

Source Code Comments

OS USER: Operating system client user name.

Columns Comments for GURALGN_TERMINAL (# 11)

Source Code Comments

TERMINAL: Operating system terminal name.

Columns Comments for GURALGN_PROGRAM (# 12)

Source Code Comments

PROGRAM: Operating system program name executing during login.

Columns Comments for GURALGN_MODULE (# 13)

Source Code Comments

MODULE: Name of the currently executing module as set by calling the DBMS_APPLICATION_INFO.SET_MODULE procedure during logon.

Columns Comments for GURALGN_SERVICE_NAME (# 14)

Source Code Comments

SERVICE NAME: Service name of the session.

Columns Comments for GURALGN_LOGOFF_TIME (# 15)

Source Code Comments

LOGOFF TIME: Time of logoff. Value will be NULL if session is not logged off normally.

Columns Comments for GURALGN_TOTAL_TIME (# 16)

Source Code Comments

TOTAL TIME: The length of time logged on. If the either the logon on logoff time are null, then this value will be null.

Columns Comments for GURALGN_LOGON_COMMENT (# 17)

Source Code Comments

LOGON COMMENT: An optional comment recorded at logon time.

Columns Comments for GURALGN_LOGOFF_COMMENT (# 18)

Source Code Comments

LOGOFF COMMENT: An optional comment recorded at logoff time.

Table GURALOG

Server Name S10B80
Database Name BANSECR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL
GURALOG_OBJECT	VARCHAR2(30)	No
GURALOG_USERID	VARCHAR2(30)	No
GURALOG_REASON	VARCHAR2(240)	No
GURALOG_SEVERITY_LEVEL	NUMBER(1,0)	No
GURALOG_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
GURALOG_INDEX		GURALOG_OBJECT
GURALOG_INDEX		GURALOG_USERID

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
G$_VERIFY_PASSWORD2_PRD	Oracle Package Procedure	S10B80.BANSECR.G$_SECURITY_PKG	Use (Insert)
G$_VERIFY_PASSWORD3_PRD	Oracle Package Procedure	S10B80.BANSECR.G$_SECURITY_PKG	Use (Insert)
GET_ROLE_PASSWD	Oracle Package Procedure	S10B80.BANSECR.GSPPRXY	Use (Insert)
G$_CREATE_LOG_RECORD	Oracle Package Procedure	S10B80.BANSECR.G$_SECURITY_PKG	Use (Insert)
G$_GET_PROXY_INFO	Oracle Package Procedure	S10B80.BANSECR.GSPPRXY	Use (Insert)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GURALOG_INDEX	SQL Index	S10B80.BANSECR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.BANSECR.GURALOG

Object Dates

Creation Date	Analysis Date
04/03/2008 10:44:17:000	04/03/2008 10:47:27:000

Source Code Comments

Banner Security Violation Log. This table contains a record of several types of Banner Security violations that have occurred.

Columns Comments for GURALOG_OBJECT (# 1)

Source Code Comments

OBJECT: The object being used when the security violation occurred.

Columns Comments for GURALOG_USERID (# 2)

Source Code Comments

USERID: The Oracle User ID that was active at the time of the security violation.

Columns Comments for GURALOG_REASON (# 3)

Source Code Comments

REASON: The reason that the security violation occurred.

Columns Comments for GURALOG_SEVERITY_LEVEL (# 4)

Source Code Comments

SEVERITY LEVEL: The estimated level of the security violation with 1 being the most important to review.

Columns Comments for GURALOG_ACTIVITY_DATE (# 5)

Source Code Comments

ACTIVITY DATE: The date the violation occurred.

Table GURAMSK

Server Name S10B80
Database Name BANSECR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GURAMSK_AUDIT_TIME	UNDEFINED	No	*
GURAMSK_AUDIT_ACTION	VARCHAR2(1)	Yes
GURAMSK_OBJS_CODE	VARCHAR2(30)	Yes
GURAMSK_BLOCK_NAME	VARCHAR2(30)	Yes
GURAMSK_COLUMN_NAME	VARCHAR2(30)	Yes
GURAMSK_SEQNO	NUMBER(8,0)	Yes
GURAMSK_DISPLAY_IND	VARCHAR2(1)	Yes
GURAMSK_CONCEAL_IND	VARCHAR2(1)	Yes
GURAMSK_ALL_USER_IND	VARCHAR2(1)	Yes
GURAMSK_ACTIVITY_DATE	DATE	Yes
GURAMSK_USER_ID	VARCHAR2(30)	Yes
GURAMSK_DATA_MASK	VARCHAR2(60)	Yes
GURAMSK_FGAC_USER_ID	VARCHAR2(30)	Yes
GURAMSK_FBPR_CODE	VARCHAR2(30)	Yes
GURAMSK_MASK_DIRECTION	VARCHAR2(1)	Yes
GURAMSK_MASK_LENGTH	NUMBER(4,0)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GURAMSK	Unique	GURAMSK_AUDIT_TIME

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GT_GORDMSK_AUDIT_ROW	SQL Trigger	S10B80.BANSECR	Use (Insert)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GURAMSK	SQL Index	S10B80.BANSECR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.BANSECR.GURAMSK

Object Dates

Creation Date	Analysis Date
04/03/2008 10:44:27:000	04/03/2008 10:47:27:000

Source Code Comments

GURAMSK: This table stores audit information for the GORDMSK table.

Columns Comments for GURAMSK_AUDIT_TIME (# 1)

Source Code Comments

AUDIT TIME: The time the change was made to GORDMSK.

Columns Comments for GURAMSK_AUDIT_ACTION (# 2)

Source Code Comments

AUDIT ACTION: The audit action taken (I)nsert, (U)pdate, or (D)elete.

Columns Comments for GURAMSK_OBJS_CODE (# 3)

Source Code Comments

DISPLAY OBJECT: Object which the display rules will be applied to.

Columns Comments for GURAMSK_BLOCK_NAME (# 4)

Source Code Comments

BLOCK NAME: Block Name.

Columns Comments for GURAMSK_COLUMN_NAME (# 5)

Source Code Comments

COLUMN NAME: Column Name.

Columns Comments for GURAMSK_SEQNO (# 6)

Source Code Comments

SEQUENCE NUMBER: Sequence number to make a unique key.

Columns Comments for GURAMSK_DISPLAY_IND (# 7)

Source Code Comments

DISPLAY IND: Y/N indicator that the column should be displayed on the form. Default value is N.

Columns Comments for GURAMSK_CONCEAL_IND (# 8)

Source Code Comments

CONCEAL IND: Y/N indicator that the column should be displayed, yet the value concealed on the form. Default value is N.

Columns Comments for GURAMSK_ALL_USER_IND (# 9)

Source Code Comments

APPLY TO ALL USERS IND: Y/N indicator that the masking applies to all users of the system. Default value is Y.

Columns Comments for GURAMSK_ACTIVITY_DATE (# 10)

Source Code Comments

ACTIVITY DATE: The most recent date a record was created or updated.

Columns Comments for GURAMSK_USER_ID (# 11)

Source Code Comments

USER ID: The most recent user to create or update a record.

Columns Comments for GURAMSK_DATA_MASK (# 12)

Source Code Comments

DATA MASK: display format for string text. Use S value for display, and * to subsitute for the character to hide it.

Columns Comments for GURAMSK_FGAC_USER_ID (# 13)

Source Code Comments

FGAC USER ID: User ID the masking applies too. Must be blank if All Users is checked on.

Columns Comments for GURAMSK_FBPR_CODE (# 14)

Source Code Comments

BUSINESS PROFILE CODE: Business Profile list the masking applies too. Must be left blank if All Users is checked on.

Columns Comments for GURAMSK_MASK_DIRECTION (# 15)

Source Code Comments

Mask Direction: For partial character masking only with GORDMCL_DATA_TYPE_CDE of C. L, R or null. Indicates the direction of the mask on a field as starting at the left(L) or right(R) most part of field being masked.

Columns Comments for GURAMSK_MASK_LENGTH (# 16)

Source Code Comments

Mask Length: For partial character masking only with GORDMCL_DATATYPE_CDE of C. Indicates the number of characters the mask will be applied to a field beginning at the left or right most part of the field.

Table GURAOBJ

Server Name S10B80
Database Name BANSECR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GURAOBJ_OBJECT	VARCHAR2(30)	No	*	*
GURAOBJ_DEFAULT_ROLE	VARCHAR2(30)	No
GURAOBJ_CURRENT_VERSION	VARCHAR2(10)	No
GURAOBJ_SYSI_CODE	VARCHAR2(2)	No		*
GURAOBJ_ACTIVITY_DATE	DATE	No
GURAOBJ_CHECKSUM	VARCHAR2(30)	Yes
GURAOBJ_USER_ID	VARCHAR2(30)	No
GURAOBJ_OWNER	VARCHAR2(30)	Yes
GURAOBJ_COMMENTS	VARCHAR2(4000)	Yes
GURAOBJ_DATA_ORIGIN	VARCHAR2(30)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GURAOBJ_SYSI_CODE	GTVSYSI_CODE	GTVSYSI
GURAOBJ_OBJECT	GUROWNR_OBJECT	GUROWNR

Index

Index Name	Index Type	Column Name
PK_GURAOBJ	Unique	GURAOBJ_OBJECT

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GURATAB	SQL Table	S10B80.BANSECR	Refer (no action)
GUVOWNR	SQL View	S10B80.BANSECR	Use (select)
TEST_GUVOWNR	SQL View	S10B80.BANSECR	Use (select)
G$_VERIFY_PASSWORD2_PRD	Oracle Package Procedure	S10B80.BANSECR.G$_SECURITY_PKG	Use (select)Rely On
G$_OREPSECR	Oracle Package Procedure	S10B80.BANSECR.G$_OREP_SECR_PKG	Use (select)Rely On
G$_CHECK_VALID_OBJ_FNC	Oracle Package Function	S10B80.BANSECR.G$_AUTHORIZATION_PKG	Use (select)Rely On
G$_GET_OBJ_RELEASE_FNC	Oracle Package Function	S10B80.BANSECR.G$_AUTHORIZATION_PKG	Use (select)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_GURAOBJ	SQL Index	S10B80.BANSECR	Rely On
GTVSYSI	SQL Table	S10B80.GENERAL	Refer (no action)
GUROWNR	SQL Table	S10B80.BANSECR	Join
GT_GURAOBJ_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.BANSECR.GURAOBJ

Object Dates

Creation Date	Analysis Date
04/03/2008 10:43:45:000	04/03/2008 10:47:26:000

Source Code Comments

GURAOBJ: This table defines all valid Banner objects and what the current version number is. This table also defines the default role to be used when the object is first granted to the user or a class.

Columns Comments for GURAOBJ_OBJECT (# 1)

Source Code Comments

OBJECT: The Banner object name.

Columns Comments for GURAOBJ_DEFAULT_ROLE (# 2)

Source Code Comments

DEFAULT ROLE: The default role defined for the object.

Columns Comments for GURAOBJ_CURRENT_VERSION (# 3)

Source Code Comments

CURRENT VERSION: The current version of the object. This is also used in version checking.

Columns Comments for GURAOBJ_SYSI_CODE (# 4)

Source Code Comments

SYSTEM CODE: A code used to identify which Banner application the object belongs to.

Columns Comments for GURAOBJ_ACTIVITY_DATE (# 5)

Source Code Comments

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

Columns Comments for GURAOBJ_CHECKSUM (# 6)

Source Code Comments

CHECKSUM: This is the encrypted checksum for the object. This value is generated by the gurchks process and is currently used only for Oracle Report programs.

Columns Comments for GURAOBJ_USER_ID (# 7)

Source Code Comments

USER ID: User ID of the user who created or last updated the record.

Columns Comments for GURAOBJ_OWNER (# 8)

Source Code Comments

OWNER: The owner of the object for use by distributed security.

Columns Comments for GURAOBJ_COMMENTS (# 9)

Source Code Comments

COMMENTS: Comments related to this object.

Columns Comments for GURAOBJ_DATA_ORIGIN (# 10)

Source Code Comments

DATA ORIGIN: Source system that created or updated the row.

Table GURAOGP

Server Name S10B80
Database Name BANSECR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GURAOGP_AUDIT_TIME	UNDEFINED	No	*
GURAOGP_AUDIT_ACTION	VARCHAR2(1)	Yes
GURAOGP_SGRP_CODE	VARCHAR2(30)	Yes
GURAOGP_OBJECT	VARCHAR2(30)	Yes
GURAOGP_ROLE	VARCHAR2(30)	Yes
GURAOGP_USER_ID	VARCHAR2(30)	Yes
GURAOGP_ACTIVITY_DATE	DATE	Yes
GURAOGP_DATA_ORIGIN	VARCHAR2(30)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GURAOGP	Unique	GURAOGP_AUDIT_TIME

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GT_GUROGRP_AUDIT_ROW	SQL Trigger	S10B80.BANSECR	Use (Insert)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GURAOGP	SQL Index	S10B80.BANSECR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.BANSECR.GURAOGP

Object Dates

Creation Date	Analysis Date
04/03/2008 10:43:47:000	04/03/2008 10:47:26:000

Source Code Comments

GURAOGP: This table stores audit information for the GUROGRP table.

Columns Comments for GURAOGP_AUDIT_TIME (# 1)

Source Code Comments

AUDIT TIME: The time the change was made to GUROGRP.

Columns Comments for GURAOGP_AUDIT_ACTION (# 2)

Source Code Comments

AUDIT ACTION: The audit action taken (I)nsert, (U)pdate, or (D)elete.

Columns Comments for GURAOGP_SGRP_CODE (# 3)

Source Code Comments

SECURITY GROUP: The name of a security group.

Columns Comments for GURAOGP_OBJECT (# 4)

Source Code Comments

OBJECT: Banner object that is part of this group.

Columns Comments for GURAOGP_ROLE (# 5)

Source Code Comments

ROLE: Role assigned to the object that is part of this group.

Columns Comments for GURAOGP_USER_ID (# 6)

Source Code Comments

USER ID: User ID of the user who created or last updated the record.

Columns Comments for GURAOGP_ACTIVITY_DATE (# 7)

Source Code Comments

ACTIVITY DATE: Date record was created or last updated.

Columns Comments for GURAOGP_DATA_ORIGIN (# 8)

Source Code Comments

DATA ORIGIN: Source system that created or updated the row.

Table GURAOWG

Server Name S10B80
Database Name BANSECR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GURAOWG_AUDIT_TIME	UNDEFINED	No	*
GURAOWG_AUDIT_ACTION	VARCHAR2(1)	Yes
GURAOWG_OWNG_CODE	VARCHAR2(30)	No
GURAOWG_USER	VARCHAR2(30)	No
GURAOWG_USER_ID	VARCHAR2(30)	No
GURAOWG_ACTIVITY_DATE	DATE	No
GURAOWG_OWNER	VARCHAR2(30)	Yes
GURAOWG_COMMENTS	VARCHAR2(4000)	Yes
GURAOWG_DATA_ORIGIN	VARCHAR2(30)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GURAOWG	Unique	GURAOWG_AUDIT_TIME

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GT_GUROWNG_AUDIT_ROW	SQL Trigger	S10B80.BANSECR	Use (Insert)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GURAOWG	SQL Index	S10B80.BANSECR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.BANSECR.GURAOWG

Object Dates

Creation Date	Analysis Date
04/03/2008 10:43:48:000	04/03/2008 10:47:26:000

Source Code Comments

GURAOWG: This table stores audit information for the GUROWNG table.

Columns Comments for GURAOWG_AUDIT_TIME (# 1)

Source Code Comments

AUDIT TIME: The time the change was made to GUROWNG.

Columns Comments for GURAOWG_AUDIT_ACTION (# 2)

Source Code Comments

AUDIT ACTION: The audit action taken (I)nsert, (U)pdate, or (D)elete.

Columns Comments for GURAOWG_OWNG_CODE (# 3)

Source Code Comments

GROUP CODE: The name of a group of distributed users. This name may not be PUBLIC or start with BANSECR.

Columns Comments for GURAOWG_USER (# 4)

Source Code Comments

USER: Oracle username of a distributed user. This user name must be PUBLIC or start with BANSECR.

Columns Comments for GURAOWG_USER_ID (# 5)

Source Code Comments

USER ID: User ID of the user who created or last updated the record.

Columns Comments for GURAOWG_ACTIVITY_DATE (# 6)

Source Code Comments

ACTIVITY DATE: Date record was created or last updated.

Columns Comments for GURAOWG_OWNER (# 7)

Source Code Comments

OWNER: The owner of the group for use by distributed security.

Columns Comments for GURAOWG_COMMENTS (# 8)

Source Code Comments

COMMENTS: Comments related to this class.

Columns Comments for GURAOWG_DATA_ORIGIN (# 9)

Source Code Comments

DATA ORIGIN: Source system that created or updated the row.

Table GURAOWN

Server Name S10B80
Database Name BANSECR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GURAOWN_AUDIT_TIME	UNDEFINED	No	*
GURAOWN_AUDIT_ACTION	VARCHAR2(1)	Yes
GURAOWN_OWNER	VARCHAR2(30)	No
GURAOWN_OBJECT	VARCHAR2(30)	No
GURAOWN_OBJECT_TYPE	VARCHAR2(1)	No
GURAOWN_GRANTOR	VARCHAR2(30)	No
GURAOWN_PRIV_GRANT	VARCHAR2(1)	No
GURAOWN_PRIV_GRANT_ASSIGN	VARCHAR2(1)	No
GURAOWN_PRIV_REVOKE	VARCHAR2(1)	No
GURAOWN_PRIV_REVOKE_ASSIGN	VARCHAR2(1)	No
GURAOWN_PRIV_DELETE	VARCHAR2(1)	No
GURAOWN_PRIV_DELETE_ASSIGN	VARCHAR2(1)	No
GURAOWN_PRIV_MODIFY	VARCHAR2(1)	No
GURAOWN_PRIV_MODIFY_ASSIGN	VARCHAR2(1)	No
GURAOWN_USER_ID	VARCHAR2(30)	No
GURAOWN_ACTIVITY_DATE	DATE	No
GURAOWN_COMMENTS	VARCHAR2(4000)	Yes
GURAOWN_DATA_ORIGIN	VARCHAR2(30)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GURAOWN	Unique	GURAOWN_AUDIT_TIME

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GT_GUROWNR_AUDIT_ROW	SQL Trigger	S10B80.BANSECR	Use (Insert)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GURAOWN	SQL Index	S10B80.BANSECR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.BANSECR.GURAOWN

Object Dates

Creation Date	Analysis Date
04/03/2008 10:43:49:000	04/03/2008 10:47:26:000

Source Code Comments

GURAOWN: This table stores audit information for the GUROWNR table.

Columns Comments for GURAOWN_AUDIT_TIME (# 1)

Source Code Comments

AUDIT TIME: The time the change was made to GUROWNR.

Columns Comments for GURAOWN_AUDIT_ACTION (# 2)

Source Code Comments

AUDIT ACTION: The audit action taken (I)nsert, (U)pdate, or (D)elete.

Columns Comments for GURAOWN_OWNER (# 3)

Source Code Comments

OWNER: The distributed security user of the object.

Columns Comments for GURAOWN_OBJECT (# 4)

Source Code Comments

OBJECT: The owned object for which access is being defined.

Columns Comments for GURAOWN_OBJECT_TYPE (# 5)

Source Code Comments

OBJECT TYPE: The type of object. C-Class, O-Object, R-Role, P-Profile.

Columns Comments for GURAOWN_GRANTOR (# 6)

Source Code Comments

GRANTOR: The distributed user that granted the permissions.

Columns Comments for GURAOWN_PRIV_GRANT (# 7)

Source Code Comments

PRIVILEGE GRANT: Ability to grant or add this object to an end user / class / profile / role.

Columns Comments for GURAOWN_PRIV_GRANT_ASSIGN (# 8)

Source Code Comments

PRIVILEGE ASSIGN GRANT: Ability to assign the granting privilege of this object to another distributed user.

Columns Comments for GURAOWN_PRIV_REVOKE (# 9)

Source Code Comments

PRIVILEGE REVOKE: Ability to revoke or remove access to this object to an end user / class / profile / role.

Columns Comments for GURAOWN_PRIV_REVOKE_ASSIGN (# 10)

Source Code Comments

PRIVILEGE ASSIGN REVOKE: Ability to revoke the granting privilege of this object from another distributed user.

Columns Comments for GURAOWN_PRIV_DELETE (# 11)

Source Code Comments

PRIVILEGE DELETE: Ability to delete this object.

Columns Comments for GURAOWN_PRIV_DELETE_ASSIGN (# 12)

Source Code Comments

PRIVILEGE ASSIGN DELETE: Ability to assign the delete privilege of this object to another distributed user.

Columns Comments for GURAOWN_PRIV_MODIFY (# 13)

Source Code Comments

PRIVILEGE MODIFY: Ability to modify this object.

Columns Comments for GURAOWN_PRIV_MODIFY_ASSIGN (# 14)

Source Code Comments

PRIVILEGE ASSIGN MODIFY: Ability to assign the modify privilege of this object to another distributed user.

Columns Comments for GURAOWN_USER_ID (# 15)

Source Code Comments

USER ID: User ID of the user who created or last updated the record.

Columns Comments for GURAOWN_ACTIVITY_DATE (# 16)

Source Code Comments

ACTIVITY DATE: Date record was created or last updated.

Columns Comments for GURAOWN_COMMENTS (# 17)

Source Code Comments

COMMENTS: Comments related to this ownership relationship.

Columns Comments for GURAOWN_DATA_ORIGIN (# 18)

Source Code Comments

DATA ORIGIN: Source system that created or updated the row.

Table GURAPRD

Server Name S10B80
Database Name BANSECR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GURAPRD_AUDIT_TIME	UNDEFINED	No	*
GURAPRD_AUDIT_ACTION	VARCHAR2(1)	Yes
GURAPRD_FGAC_CODE	VARCHAR2(30)	Yes
GURAPRD_FDMN_CODE	VARCHAR2(30)	Yes
GURAPRD_SEQNO	NUMBER(4,0)	Yes
GURAPRD_ACTIVITY_DATE	DATE	Yes
GURAPRD_USER_ID	VARCHAR2(30)	Yes
GURAPRD_PREDICATE	VARCHAR2(4000)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GURAPRD	Unique	GURAPRD_AUDIT_TIME

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GT_GORFPRD_AUDIT_ROW	SQL Trigger	S10B80.BANSECR	Use (Insert)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GURAPRD	SQL Index	S10B80.BANSECR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.BANSECR.GURAPRD

Object Dates

Creation Date	Analysis Date
04/03/2008 10:43:53:000	04/03/2008 10:47:26:000

Source Code Comments

GURAPRD: This table stores audit information for the GORFPRD table.

Columns Comments for GURAPRD_AUDIT_TIME (# 1)

Source Code Comments

AUDIT TIME: The time the change was made to GORFPRD.

Columns Comments for GURAPRD_AUDIT_ACTION (# 2)

Source Code Comments

AUDIT ACTION: The audit action taken (I)nsert, (U)pdate, or (D)elete.

Columns Comments for GURAPRD_FGAC_CODE (# 3)

Source Code Comments

FGAC CODE: FGAC group code.

Columns Comments for GURAPRD_FDMN_CODE (# 4)

Source Code Comments

FGAC DOMAIN CODE: FGAC domain code.

Columns Comments for GURAPRD_SEQNO (# 5)

Source Code Comments

PREDICATE SEQNO: One up number to allow multiple predicates per domain and rule.

Columns Comments for GURAPRD_ACTIVITY_DATE (# 6)

Source Code Comments

ACTIVITY DATE: The most recent date a record was created or updated.

Columns Comments for GURAPRD_USER_ID (# 7)

Source Code Comments

USER ID: The most recent user to create or update a record.

Columns Comments for GURAPRD_PREDICATE (# 8)

Source Code Comments

PREDICATE: SQL statement appended to originating SQL to restrict row level access. The predicate is processed by ORACLE FGAC and appended appropriately.

Table GURAPUD

Server Name S10B80
Database Name BANSECR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GURAPUD_AUDIT_TIME	UNDEFINED	No	*
GURAPUD_AUDIT_ACTION	VARCHAR2(1)	Yes
GURAPUD_FGAC_USER_ID	VARCHAR2(30)	Yes
GURAPUD_EXEMPT_IND	VARCHAR2(1)	Yes
GURAPUD_CROSS_DOMAIN_IND	VARCHAR2(1)	Yes
GURAPUD_ACTIVITY_DATE	DATE	Yes
GURAPUD_USER_ID	VARCHAR2(30)	Yes
GURAPUD_FDMN_CODE	VARCHAR2(30)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GURAPUD	Unique	GURAPUD_AUDIT_TIME

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GT_GOBFPUD_AUDIT_ROW	SQL Trigger	S10B80.BANSECR	Use (Insert)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GURAPUD	SQL Index	S10B80.BANSECR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.BANSECR.GURAPUD

Object Dates

Creation Date	Analysis Date
04/03/2008 10:43:53:000	04/03/2008 10:47:27:000

Source Code Comments

GURAPUD: This table stores audit information for the GOBFPUD table.

Columns Comments for GURAPUD_AUDIT_TIME (# 1)

Source Code Comments

AUDIT TIME: The time the change was made to GOBFPUD.

Columns Comments for GURAPUD_AUDIT_ACTION (# 2)

Source Code Comments

AUDIT ACTION: The audit action taken (I)nsert, (U)pdate, or (D)elete.

Columns Comments for GURAPUD_FGAC_USER_ID (# 3)

Source Code Comments

FGAC USER ID: User ID for whom the default settings applies.

Columns Comments for GURAPUD_EXEMPT_IND (# 4)

Source Code Comments

EXEMPT IND: Y/N indicator if user is exempt from all PII processing.

Columns Comments for GURAPUD_CROSS_DOMAIN_IND (# 5)

Source Code Comments

CROSS DOMAIN IND: Y/N indicator if user is able to search thru multiple domains on the PII Restricted Search form.

Columns Comments for GURAPUD_ACTIVITY_DATE (# 6)

Source Code Comments

ACTIVITY DATE: The most recent date a record was created or updated.

Columns Comments for GURAPUD_USER_ID (# 7)

Source Code Comments

USER ID: The most recent user to create or update a record.

Columns Comments for GURAPUD_FDMN_CODE (# 8)

Source Code Comments

DOMAIN CODE: Home domain code for individual. These include PII domain types.

Table GURATAB

Server Name S10B80
Database Name BANSECR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GURATAB_FORM_NAME	VARCHAR2(30)	No	*	*
GURATAB_INTERNAL_TAB_NAME	VARCHAR2(30)	No	*
GURATAB_EXTERNAL_TAB_NAME	VARCHAR2(30)	No
GURATAB_RESTRICTIONS	VARCHAR2(1)	No
GURATAB_SYS_REQ_IND	VARCHAR2(1)	No
GURATAB_ACTIVITY_DATE	DATE	No
GURATAB_USER_ID	VARCHAR2(30)	No
GURATAB_DATA_ORIGIN	VARCHAR2(30)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GURATAB_FORM_NAME	GURAOBJ_OBJECT	GURAOBJ

Index

Index Name	Index Type	Column Name
PK_GURATAB	Unique	GURATAB_FORM_NAME
PK_GURATAB	Unique	GURATAB_INTERNAL_TAB_NAME

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GURUTAB	SQL Table	S10B80.BANSECR	Refer (no action)
G$_GET_TAB_DESC_FNC	Oracle Package Function	S10B80.BANSECR.G$_SECURITY_PKG	Use (select)Rely On
G$_GET_TAB_SECURITY_FNC	Oracle Package Function	S10B80.BANSECR.G$_SECURITY_PKG	Use (select)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GURATAB	SQL Index	S10B80.BANSECR	Rely On
GURAOBJ	SQL Table	S10B80.BANSECR	Refer (no action)
GT_GURATAB_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.BANSECR.GURATAB

Object Dates

Creation Date	Analysis Date
04/03/2008 10:44:19:000	04/03/2008 10:47:27:000

Source Code Comments

GURATAB: This table defines all the forms and their related tabs that can be used for tab based security.

Columns Comments for GURATAB_FORM_NAME (# 1)

Source Code Comments

FORM NAME: The Banner form name.

Columns Comments for GURATAB_INTERNAL_TAB_NAME (# 2)

Source Code Comments

INTERNAL TAB NAME: The internal name of the tab as defined in the form via Forms Builder.

Columns Comments for GURATAB_EXTERNAL_TAB_NAME (# 3)

Source Code Comments

EXTERNAL TAB NAME: The tab name that displays on the tab on the form in Banner.

Columns Comments for GURATAB_RESTRICTIONS (# 4)

Source Code Comments

Columns Comments for GURATAB_SYS_REQ_IND (# 5)

Source Code Comments

SYSTEM REQUIRED INDICATOR: This field denotes whether the Tab record is system required. Valid values are (Y)es and (N)o.

Columns Comments for GURATAB_ACTIVITY_DATE (# 6)

Source Code Comments

ACTIVITY DATE: Date record was created or last updated.

Columns Comments for GURATAB_USER_ID (# 7)

Source Code Comments

USER ID: User ID of the user who created or last updated the record.

Columns Comments for GURATAB_DATA_ORIGIN (# 8)

Source Code Comments

DATA ORIGIN: Source system that created or updated the row

Table GURAUGP

Server Name S10B80
Database Name BANSECR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GURAUGP_AUDIT_TIME	UNDEFINED	No	*
GURAUGP_AUDIT_ACTION	VARCHAR2(1)	Yes
GURAUGP_SGRP_CODE	VARCHAR2(30)	Yes
GURAUGP_USER	VARCHAR2(30)	Yes
GURAUGP_USER_ID	VARCHAR2(30)	Yes
GURAUGP_ACTIVITY_DATE	DATE	Yes
GURAUGP_DATA_ORIGIN	VARCHAR2(30)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GURAUGP	Unique	GURAUGP_AUDIT_TIME

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GT_GURUGRP_AUDIT_ROW	SQL Trigger	S10B80.BANSECR	Use (Insert)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GURAUGP	SQL Index	S10B80.BANSECR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.BANSECR.GURAUGP

Object Dates

Creation Date	Analysis Date
04/03/2008 10:44:29:000	04/03/2008 10:47:27:000

Source Code Comments

GURAUGP: This table stores audit information for the GURUGRP table.

Columns Comments for GURAUGP_AUDIT_TIME (# 1)

Source Code Comments

AUDIT TIME: The time the change was made to GURUGRP.

Columns Comments for GURAUGP_AUDIT_ACTION (# 2)

Source Code Comments

AUDIT ACTION: The audit action taken (I)nsert, (U)pdate, or (D)elete.

Columns Comments for GURAUGP_SGRP_CODE (# 3)

Source Code Comments

SECURITY GROUP: The name of a security group.

Columns Comments for GURAUGP_USER (# 4)

Source Code Comments

USER: Banner user that is part of this group.

Columns Comments for GURAUGP_USER_ID (# 5)

Source Code Comments

USER ID: User ID of the user who created or last updated the record.

Columns Comments for GURAUGP_ACTIVITY_DATE (# 6)

Source Code Comments

ACTIVITY DATE: Date record was created or last updated.

Columns Comments for GURAUGP_DATA_ORIGIN (# 7)

Source Code Comments

DATA ORIGIN: Source system that created or updated the row.

Table GURAULG

Server Name S10B80
Database Name BANSECR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GURAULG_AUDIT_TIME	UNDEFINED	No	*
GURAULG_AUDIT_ACTION	VARCHAR2(1)	Yes
GURAULG_USER	VARCHAR2(30)	Yes
GURAULG_PIDM	NUMBER(8,0)	Yes
GURAULG_LAST_NAME	VARCHAR2(60)	Yes
GURAULG_FIRST_NAME	VARCHAR2(60)	Yes
GURAULG_INB_LOGON_COUNT	NUMBER(0,0)	Yes
GURAULG_INB_LAST_LOGON_DATE	DATE	Yes
GURAULG_INB_FIRST_LOGON_DATE	DATE	Yes
GURAULG_INB_LOGIN_CALENDAR	VARCHAR2(30)	Yes
GURAULG_INB_ACTIVE_FROM	DATE	Yes
GURAULG_INB_ACTIVE_TO	DATE	Yes
GURAULG_LOGON_COUNT	NUMBER(0,0)	Yes
GURAULG_LAST_LOGON_DATE	DATE	Yes
GURAULG_FIRST_LOGON_DATE	DATE	Yes
GURAULG_LOGIN_CALENDAR	VARCHAR2(30)	Yes
GURAULG_ACTIVE_FROM	DATE	Yes
GURAULG_ACTIVE_TO	DATE	Yes
GURAULG_AUTHORIZATION_BY	VARCHAR2(100)	Yes
GURAULG_AUTHORIZATION_DATE	DATE	Yes
GURAULG_AUTHORIZATION_DOCUMENT	VARCHAR2(50)	Yes
GURAULG_COMMENTS	VARCHAR2(4000)	Yes
GURAULG_USER_ID	VARCHAR2(30)	Yes
GURAULG_ACTIVITY_DATE	DATE	Yes
GURAULG_DATA_ORIGIN	VARCHAR2(30)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GURAULG	Unique	GURAULG_AUDIT_TIME

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GT_GURLOGN_AUDIT_ROW	SQL Trigger	S10B80.BANSECR	Use (Insert)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GURAULG	SQL Index	S10B80.BANSECR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.BANSECR.GURAULG

Object Dates

Creation Date	Analysis Date
04/03/2008 10:43:35:000	04/03/2008 10:47:26:000

Source Code Comments

GURAULG: This table stores information related to logins to Oracle by users of Banner. A Banner user is defined as a user having an entry in GURUCLS or GURUOBJ.

Columns Comments for GURAULG_AUDIT_TIME (# 1)

Source Code Comments

AUDIT TIME: The time the change was made to GURLOGN.

Columns Comments for GURAULG_AUDIT_ACTION (# 2)

Source Code Comments

AUDIT ACTION: The audit action taken (I)nsert, (U)pdate, or (D)elete.

Columns Comments for GURAULG_USER (# 3)

Source Code Comments

USERNAME: Oracle username.

Columns Comments for GURAULG_PIDM (# 4)

Source Code Comments

PIDM: A PIDM for a non-primary identification of the user. The primary identification is stored in GOBEACC.

Columns Comments for GURAULG_LAST_NAME (# 5)

Source Code Comments

LAST NAME: The last name of the user if they do not have a related PIDM.

Columns Comments for GURAULG_FIRST_NAME (# 6)

Source Code Comments

FIRST NAME: The first name of the user if they do not have a related PIDM.

Columns Comments for GURAULG_INB_LOGON_COUNT (# 7)

Source Code Comments

INB LOGON COUNT: The number of times this user has logged into Banner INB.

Columns Comments for GURAULG_INB_LAST_LOGON_DATE (# 8)

Source Code Comments

INB LAST LOGON DATE: The date of the last time this user has logged on to Banner INB.

Columns Comments for GURAULG_INB_FIRST_LOGON_DATE (# 9)

Source Code Comments

INB FIRST LOGON DATE: The date of the first time this user has logged on to Banner INB.

Columns Comments for GURAULG_INB_LOGIN_CALENDAR (# 10)

Source Code Comments

INB LOGIN CALENDAR: An optional calendar that can be used to restrict when this user may log on to Banner INB.

Columns Comments for GURAULG_INB_ACTIVE_FROM (# 11)

Source Code Comments

INB ACTIVE FROM: The first date that this user may log on to Banner INB.

Columns Comments for GURAULG_INB_ACTIVE_TO (# 12)

Source Code Comments

INB ACTIVE TO: The last date that this user may log on to Banner INB.

Columns Comments for GURAULG_LOGON_COUNT (# 13)

Source Code Comments

LOGON COUNT: The number of times this user has logged into Oracle. This is only incremented if the database logon trigger GT_GURALGN_AUDIT_LOGON is enabled.

Columns Comments for GURAULG_LAST_LOGON_DATE (# 14)

Source Code Comments

LAST LOGON DATE: The last time this user logged into Oracle. This is only incremented if the database logon trigger GT_GURALGN_AUDIT_LOGON is enabled.

Columns Comments for GURAULG_FIRST_LOGON_DATE (# 15)

Source Code Comments

FIRST LOGON DATE: The first time this user logged into Oracle. This is only incremented if the database logon trigger GT_GURALGN_AUDIT_LOGON is enabled.

Columns Comments for GURAULG_LOGIN_CALENDAR (# 16)

Source Code Comments

Columns Comments for GURAULG_ACTIVE_FROM (# 17)

Source Code Comments

ACTIVE FROM: For future use.

Columns Comments for GURAULG_ACTIVE_TO (# 18)

Source Code Comments

ACTIVE TO: For future use.

Columns Comments for GURAULG_AUTHORIZATION_BY (# 19)

Source Code Comments

AUTHORIZATION BY: Optional information indicating who authorized this account.

Columns Comments for GURAULG_AUTHORIZATION_DATE (# 20)

Source Code Comments

AUTHORIZATION DATE: Optional information indicating that date of account authorization.

Columns Comments for GURAULG_AUTHORIZATION_DOCUMENT (# 21)

Source Code Comments

AUTHORIZATION DOCUMENT: Optional information referencing the document authorizing this account.

Columns Comments for GURAULG_COMMENTS (# 22)

Source Code Comments

COMMENTS: Comments related to this user.

Columns Comments for GURAULG_USER_ID (# 23)

Source Code Comments

USER ID: User ID of the user who created or last updated the record.

Columns Comments for GURAULG_ACTIVITY_DATE (# 24)

Source Code Comments

ACTIVITY DATE: Date record was created or last updated.

Columns Comments for GURAULG_DATA_ORIGIN (# 25)

Source Code Comments

DATA ORIGIN: Source system that created or updated the row.

Table GURAUOB

Server Name S10B80
Database Name BANSECR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GURAUOB_AUDIT_TIME	UNDEFINED	No	*
GURAUOB_AUDIT_ACTION	VARCHAR2(1)	Yes
GURAUOB_OBJECT	VARCHAR2(30)	Yes
GURAUOB_ROLE	VARCHAR2(30)	Yes
GURAUOB_USERID	VARCHAR2(30)	Yes
GURAUOB_ACTIVITY_DATE	DATE	Yes
GURAUOB_USER_ID	VARCHAR2(30)	Yes
GURAUOB_COMMENTS	VARCHAR2(4000)	Yes
GURAUOB_DATA_ORIGIN	VARCHAR2(30)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GURAUOB	Unique	GURAUOB_AUDIT_TIME

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GT_GURUOBJ_AUDIT_ROW	SQL Trigger	S10B80.BANSECR	Use (Insert)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GURAUOB	SQL Index	S10B80.BANSECR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.BANSECR.GURAUOB

Object Dates

Creation Date	Analysis Date
04/03/2008 10:43:37:000	04/03/2008 10:47:26:000

Source Code Comments

GURAUOB: This table stores audit information for the GURUOBJ table.

Columns Comments for GURAUOB_AUDIT_TIME (# 1)

Source Code Comments

AUDIT TIME: The time the change was made to GURUOBJ.

Columns Comments for GURAUOB_AUDIT_ACTION (# 2)

Source Code Comments

AUDIT ACTION: The audit action taken (I)nsert, (U)pdate, or (D)elete.

Columns Comments for GURAUOB_OBJECT (# 3)

Source Code Comments

OBJECT: The Banner object name.

Columns Comments for GURAUOB_ROLE (# 4)

Source Code Comments

ROLE: The Banner Role associated with the object.

Columns Comments for GURAUOB_USERID (# 5)

Source Code Comments

USERID: The Oracle User ID associated with the role and object.

Columns Comments for GURAUOB_ACTIVITY_DATE (# 6)

Source Code Comments

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

Columns Comments for GURAUOB_USER_ID (# 7)

Source Code Comments

USER ID: User ID of the user who created or last updated the record.

Columns Comments for GURAUOB_COMMENTS (# 8)

Source Code Comments

COMMENTS: Comments related to this object.

Columns Comments for GURAUOB_DATA_ORIGIN (# 9)

Source Code Comments

DATA ORIGIN: Source system that created or updated the row.

Table GURAUSI

Server Name S10B80
Database Name BANSECR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GURAUSI_AUDIT_TIME	UNDEFINED	No	*
GURAUSI_AUDIT_ACTION	VARCHAR2(1)	Yes
GURAUSI_VPDI_USER_ID	VARCHAR2(30)	Yes
GURAUSI_VPDI_CODE	VARCHAR2(6)	Yes
GURAUSI_USER_DEF_INST_IND	VARCHAR2(1)	Yes
GURAUSI_ACTIVITY_DATE	DATE	Yes
GURAUSI_USER_ID	VARCHAR2(30)	Yes
GURAUSI_DATA_ORIGIN	VARCHAR2(30)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GURAUSI	Unique	GURAUSI_AUDIT_TIME

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GT_GURUSRI_AUDIT_ROW	SQL Trigger	S10B80.BANSECR	Use (Insert)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GURAUSI	SQL Index	S10B80.BANSECR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.BANSECR.GURAUSI

Object Dates

Creation Date	Analysis Date
04/03/2008 10:43:38:000	04/03/2008 10:47:26:000

Source Code Comments

GURAUSI: This table stores audit information for the GURUSRI table.

Columns Comments for GURAUSI_AUDIT_TIME (# 1)

Source Code Comments

AUDIT TIME: The time the change was made to GURUSRI.

Columns Comments for GURAUSI_AUDIT_ACTION (# 2)

Source Code Comments

AUDIT ACTION: The audit action taken (I)nsert, (U)pdate, or (D)elete.

Columns Comments for GURAUSI_VPDI_USER_ID (# 3)

Source Code Comments

VPDI USER ID: The userid of the individual being setup on the GSAVPDI form.

Columns Comments for GURAUSI_VPDI_CODE (# 4)

Source Code Comments

VPDI CODE: The Institution code from GTVVPDI.

Columns Comments for GURAUSI_USER_DEF_INST_IND (# 5)

Source Code Comments

USER DEFAULT: Each user must have a default institution. Valid values are Y and N.

Columns Comments for GURAUSI_ACTIVITY_DATE (# 6)

Source Code Comments

ACTIVITY DATE: The date that the information for the row was inserted or updated in the GURAUSI table.

Columns Comments for GURAUSI_USER_ID (# 7)

Source Code Comments

USER ID: User ID of the user who created or last updated the record.

Columns Comments for GURAUSI_DATA_ORIGIN (# 8)

Source Code Comments

DATA ORIGIN: Source system that created or updated the row.

Table GURAUTB

Server Name S10B80
Database Name BANSECR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GURAUTB_AUDIT_TIME	UNDEFINED	No	*
GURAUTB_AUDIT_ACTION	VARCHAR2(1)	Yes
GURAUTB_FORM_NAME	VARCHAR2(30)	Yes
GURAUTB_INTERNAL_TAB_NAME	VARCHAR2(30)	Yes
GURAUTB_ACCESS	VARCHAR2(1)	Yes
GURAUTB_CLASS_OR_USER	VARCHAR2(30)	Yes
GURAUTB_ACTIVITY_DATE	DATE	Yes
GURAUTB_USER_ID	VARCHAR2(30)	Yes
GURAUTB_DATA_ORIGIN	VARCHAR2(30)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GURAUTB	Unique	GURAUTB_AUDIT_TIME

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GT_GURUTAB_AUDIT_ROW	SQL Trigger	S10B80.BANSECR	Use (Insert)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GURAUTB	SQL Index	S10B80.BANSECR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.BANSECR.GURAUTB

Object Dates

Creation Date	Analysis Date
04/03/2008 10:43:38:000	04/03/2008 10:47:26:000

Source Code Comments

GURAUTB: This table stores audit information for the GURUTAB table.

Columns Comments for GURAUTB_AUDIT_TIME (# 1)

Source Code Comments

AUDIT TIME: The time the change was made to GURUTAB.

Columns Comments for GURAUTB_AUDIT_ACTION (# 2)

Source Code Comments

AUDIT ACTION: The audit action taken (I)nsert, (U)pdate, or (D)elete.

Columns Comments for GURAUTB_FORM_NAME (# 3)

Source Code Comments

FORM NAME: The Banner form name.

Columns Comments for GURAUTB_INTERNAL_TAB_NAME (# 4)

Source Code Comments

INTERNAL TAB NAME: The internal name of the tab as defined in the form via Forms Designer.

Columns Comments for GURAUTB_ACCESS (# 5)

Source Code Comments

ACCESS: The type of access being defined for the tab. Valid values are F-Full Access, Q-Query access, N-Not Visible.

Columns Comments for GURAUTB_CLASS_OR_USER (# 6)

Source Code Comments

CLASS: The class or userid for which tab access is being defined.

Columns Comments for GURAUTB_ACTIVITY_DATE (# 7)

Source Code Comments

ACTIVITY DATE: Date record was created or last updated.

Columns Comments for GURAUTB_USER_ID (# 8)

Source Code Comments

USER ID: User ID of the user who created or last updated the record.

Columns Comments for GURAUTB_DATA_ORIGIN (# 9)

Source Code Comments

DATA ORIGIN: Source system that created or updated the row.

Table GURAVCL

Server Name S10B80
Database Name BANSECR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GURAVCL_AUDIT_TIME	UNDEFINED	No	*
GURAVCL_AUDIT_ACTION	VARCHAR2(1)	Yes
GURAVCL_CLASS_CODE	VARCHAR2(30)	Yes
GURAVCL_ACTIVITY_DATE	DATE	Yes
GURAVCL_SYSI_CODE	VARCHAR2(2)	Yes
GURAVCL_LAST_SYNC_DATE	DATE	Yes
GURAVCL_USER_ID	VARCHAR2(30)	Yes
GURAVCL_OWNER	VARCHAR2(30)	Yes
GURAVCL_COMMENTS	VARCHAR2(4000)	Yes
GURAVCL_DATA_ORIGIN	VARCHAR2(30)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GURAVCL	Unique	GURAVCL_AUDIT_TIME

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GT_GTVCLAS_AUDIT_ROW	SQL Trigger	S10B80.BANSECR	Use (Insert)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GURAVCL	SQL Index	S10B80.BANSECR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.BANSECR.GURAVCL

Object Dates

Creation Date	Analysis Date
04/03/2008 10:43:42:000	04/03/2008 10:47:26:000

Source Code Comments

GURAVCL: This table stores audit information for the GTVCLAS table.

Columns Comments for GURAVCL_AUDIT_TIME (# 1)

Source Code Comments

AUDIT TIME: The time the change was made to GTVCLAS.

Columns Comments for GURAVCL_AUDIT_ACTION (# 2)

Source Code Comments

AUDIT ACTION: The audit action taken (I)nsert, (U)pdate, or (D)elete.

Columns Comments for GURAVCL_CLASS_CODE (# 3)

Source Code Comments

CLASS CODE: The name of the class.

Columns Comments for GURAVCL_ACTIVITY_DATE (# 4)

Source Code Comments

ACTIVITY DATE: Date record was created or last updated.

Columns Comments for GURAVCL_SYSI_CODE (# 5)

Source Code Comments

SYSTEM INDICATOR: The system that the class is associated with.

Columns Comments for GURAVCL_LAST_SYNC_DATE (# 6)

Source Code Comments

LAST SYNCHRONIZATION DATE: The last time the user grants were synchronized with the class definition.

Columns Comments for GURAVCL_USER_ID (# 7)

Source Code Comments

USER ID: User ID of the User who created or last updated the record.

Columns Comments for GURAVCL_OWNER (# 8)

Source Code Comments

OWNER: The owner of the class for use by distributed security.

Columns Comments for GURAVCL_COMMENTS (# 9)

Source Code Comments

COMMENTS: Comments related to this class.

Columns Comments for GURAVCL_DATA_ORIGIN (# 10)

Source Code Comments

DATA ORIGIN: Source system that created or updated the row.

Table GURBGRP

Server Name S10B80
Database Name BANSECR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GURBGRP_SGRP_CODE	VARCHAR2(30)	No	*	*
GURBGRP_BUSINESS_PROFILE	VARCHAR2(30)	No	*
GURBGRP_USER_ID	VARCHAR2(30)	No
GURBGRP_ACTIVITY_DATE	DATE	No
GURBGRP_DATA_ORIGIN	VARCHAR2(30)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GURBGRP_SGRP_CODE	GTVSGRP_CODE	GTVSGRP

Index

Index Name	Index Type	Column Name
PK_GURBGRP	Unique	GURBGRP_SGRP_CODE
PK_GURBGRP	Unique	GURBGRP_BUSINESS_PROFILE

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_GURBGRP	SQL Index	S10B80.BANSECR	Rely On
GTVSGRP	SQL Table	S10B80.BANSECR	Refer (no action)
GT_GURBGRP_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.BANSECR.GURBGRP

Object Dates

Creation Date	Analysis Date
04/03/2008 10:44:05:000	04/03/2008 10:47:27:000

Source Code Comments

GURBGRP: This table defines business profiles belonging to a security group.

Columns Comments for GURBGRP_SGRP_CODE (# 1)

Source Code Comments

SECURITY GROUP: The name of a security group.

Columns Comments for GURBGRP_BUSINESS_PROFILE (# 2)

Source Code Comments

BUSINESS PROFILE: Banner business profile that is part of this group.

Columns Comments for GURBGRP_USER_ID (# 3)

Source Code Comments

USER ID: User ID of the user who created or last updated the record.

Columns Comments for GURBGRP_ACTIVITY_DATE (# 4)

Source Code Comments

ACTIVITY DATE: Date record was created or last updated.

Columns Comments for GURBGRP_DATA_ORIGIN (# 5)

Source Code Comments

DATA ORIGIN: Source system that created or updated the row.

Table GURCALN

Server Name S10B80
Database Name BANSECR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GURCALN_CALN_CODE	VARCHAR2(30)	No	*	*
GURCALN_PRIORITY	NUMBER(0,0)	No	*
GURCALN_ALLOW_IND	VARCHAR2(1)	No
GURCALN_START_DATE	DATE	No
GURCALN_END_DATE	DATE	Yes
GURCALN_START_TIME	VARCHAR2(4)	Yes
GURCALN_END_TIME	VARCHAR2(4)	Yes
GURCALN_DAY_1	VARCHAR2(1)	No
GURCALN_DAY_2	VARCHAR2(1)	No
GURCALN_DAY_3	VARCHAR2(1)	No
GURCALN_DAY_4	VARCHAR2(1)	No
GURCALN_DAY_5	VARCHAR2(1)	No
GURCALN_DAY_6	VARCHAR2(1)	No
GURCALN_DAY_7	VARCHAR2(1)	No
GURCALN_USER_ID	VARCHAR2(30)	No
GURCALN_ACTIVITY_DATE	DATE	No
GURCALN_COMMENTS	VARCHAR2(4000)	Yes
GURCALN_DATA_ORIGIN	VARCHAR2(30)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GURCALN_CALN_CODE	GTVCALN_CODE	GTVCALN

Index

Index Name	Index Type	Column Name
PK_GURCALN	Unique	GURCALN_CALN_CODE
PK_GURCALN	Unique	GURCALN_PRIORITY

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
G$_CHECK_LOGON_TIMES	Oracle Package Function	S10B80.BANSECR.G$_SECURITY_PKG	Use (select)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GURCALN	SQL Index	S10B80.BANSECR	Rely On
GTVCALN	SQL Table	S10B80.BANSECR	Refer (no action)
GT_GURCALN_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.BANSECR.GURCALN

Object Dates

Creation Date	Analysis Date
04/03/2008 10:43:44:000	04/03/2008 10:47:26:000

Source Code Comments

GURCALN: This table defines calendars used for logon verification.

Columns Comments for GURCALN_CALN_CODE (# 1)

Source Code Comments

CALENDAR: The name of the calendar used for logon verification.

Columns Comments for GURCALN_PRIORITY (# 2)

Source Code Comments

PRIORITY: The priority order in which calendar entries should be matched. A priority of 001 will be processed before a priority 002. The first entry that matches date, time, and day of the week will be used.

Columns Comments for GURCALN_ALLOW_IND (# 3)

Source Code Comments

ALLOW INDICATOR: A value of "Y" indicates logons will be permitted during the dates and times specified, if the DAY_n column also has a "Y".

Columns Comments for GURCALN_START_DATE (# 4)

Source Code Comments

START DATE: The starting date of this calendar entry.

Columns Comments for GURCALN_END_DATE (# 5)

Source Code Comments

END DATE: The ending date of this calendar entry.

Columns Comments for GURCALN_START_TIME (# 6)

Source Code Comments

START TIME: The starting time of day that this entry refers to.

Columns Comments for GURCALN_END_TIME (# 7)

Source Code Comments

END TIME: The ending time of day that this entry refers to.

Columns Comments for GURCALN_DAY_1 (# 8)

Source Code Comments

DAY 1: The first day of the week (typically Sunday) that this entry refers to.

Columns Comments for GURCALN_DAY_2 (# 9)

Source Code Comments

DAY 2: The second day of the week that this entry refers to.

Columns Comments for GURCALN_DAY_3 (# 10)

Source Code Comments

DAY 3: The third day of the week that this entry refers to.

Columns Comments for GURCALN_DAY_4 (# 11)

Source Code Comments

DAY 4: The fourth day of the week that this entry refers to.

Columns Comments for GURCALN_DAY_5 (# 12)

Source Code Comments

DAY 5: The fifth day of the week that this entry refers to.

Columns Comments for GURCALN_DAY_6 (# 13)

Source Code Comments

DAY 6: The sixth day of the week that this entry refers to.

Columns Comments for GURCALN_DAY_7 (# 14)

Source Code Comments

DAY 7: The seventh day of the week that this entry refers to.

Columns Comments for GURCALN_USER_ID (# 15)

Source Code Comments

USER ID: User ID of the user who created or last updated the record.

Columns Comments for GURCALN_ACTIVITY_DATE (# 16)

Source Code Comments

ACTIVITY DATE: Date record was created or last updated.

Columns Comments for GURCALN_COMMENTS (# 17)

Source Code Comments

COMMENTS: Comments related to this class.

Columns Comments for GURCALN_DATA_ORIGIN (# 18)

Source Code Comments

DATA ORIGIN: Source system that created or updated the row.

Table GURCGRP

Server Name S10B80
Database Name BANSECR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GURCGRP_SGRP_CODE	VARCHAR2(30)	No	*	*
GURCGRP_CLASS	VARCHAR2(30)	No	*
GURCGRP_USER_ID	VARCHAR2(30)	No
GURCGRP_ACTIVITY_DATE	DATE	No
GURCGRP_DATA_ORIGIN	VARCHAR2(30)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GURCGRP_SGRP_CODE	GTVSGRP_CODE	GTVSGRP

Index

Index Name	Index Type	Column Name
PK_GURCGRP	Unique	GURCGRP_SGRP_CODE
PK_GURCGRP	Unique	GURCGRP_CLASS

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GURUGRP	SQL Table	S10B80.BANSECR	Join
GURUOBJ	SQL Table	S10B80.BANSECR	Join
GUVUOBJ	SQL View	S10B80.BANSECR	Use (select)
G$_CHECK_AUTHORIZATION_FNC	Oracle Package Function	S10B80.BANSECR.G$_AUTHORIZATION_PKG	Use (select)
G$_GET_ROLE_FOR_OBJECT_FNC	Oracle Package Function	S10B80.BANSECR.G$_SECURITY_PKG	Use (select)
G$_GET_TAB_SECURITY_FNC	Oracle Package Function	S10B80.BANSECR.G$_SECURITY_PKG	Use (select)
G$_SYNC_CLASS_GRANTS_FNC	Oracle Package Function	S10B80.BANSECR.G$_AUTHORIZATION_PKG	Use (select)
G$_SYNC_USER_GRANTS_FNC	Oracle Package Function	S10B80.BANSECR.G$_AUTHORIZATION_PKG	Use (select)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GURCGRP	SQL Index	S10B80.BANSECR	Rely On
GTVSGRP	SQL Table	S10B80.BANSECR	Refer (no action)
GT_GURCGRP_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.BANSECR.GURCGRP

Object Dates

Creation Date	Analysis Date
04/03/2008 10:44:26:000	04/03/2008 10:47:27:000

Source Code Comments

GURCGRP: This table defines classes belonging to a security group.

Columns Comments for GURCGRP_SGRP_CODE (# 1)

Source Code Comments

SECURITY GROUP: The name of a security group.

Columns Comments for GURCGRP_CLASS (# 2)

Source Code Comments

CLASS: Banner class that is part of this group.

Columns Comments for GURCGRP_USER_ID (# 3)

Source Code Comments

USER ID: User ID of the user who created or last updated the record.

Columns Comments for GURCGRP_ACTIVITY_DATE (# 4)

Source Code Comments

ACTIVITY DATE: Date record was created or last updated.

Columns Comments for GURCGRP_DATA_ORIGIN (# 5)

Source Code Comments

DATA ORIGIN: Source system that created or updated the row.

Table GURLOGN

Server Name S10B80
Database Name BANSECR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GURLOGN_USER	VARCHAR2(30)	No	*
GURLOGN_PIDM	NUMBER(8,0)	Yes
GURLOGN_LAST_NAME	VARCHAR2(60)	Yes
GURLOGN_FIRST_NAME	VARCHAR2(60)	Yes
GURLOGN_INB_LOGON_COUNT	NUMBER(0,0)	Yes
GURLOGN_INB_LAST_LOGON_DATE	DATE	Yes
GURLOGN_INB_FIRST_LOGON_DATE	DATE	Yes
GURLOGN_INB_LOGIN_CALENDAR	VARCHAR2(30)	Yes
GURLOGN_INB_ACTIVE_FROM	DATE	Yes
GURLOGN_INB_ACTIVE_TO	DATE	Yes
GURLOGN_LOGON_COUNT	NUMBER(0,0)	Yes
GURLOGN_LAST_LOGON_DATE	DATE	Yes
GURLOGN_FIRST_LOGON_DATE	DATE	Yes
GURLOGN_LOGIN_CALENDAR	VARCHAR2(30)	Yes
GURLOGN_ACTIVE_FROM	DATE	Yes
GURLOGN_ACTIVE_TO	DATE	Yes
GURLOGN_AUTHORIZATION_BY	VARCHAR2(100)	Yes
GURLOGN_AUTHORIZATION_DATE	DATE	Yes
GURLOGN_AUTHORIZATION_DOCUMENT	VARCHAR2(50)	Yes
GURLOGN_COMMENTS	VARCHAR2(4000)	Yes
GURLOGN_USER_ID	VARCHAR2(30)	Yes
GURLOGN_ACTIVITY_DATE	DATE	Yes
GURLOGN_DATA_ORIGIN	VARCHAR2(30)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GURLOGN	Unique	GURLOGN_USER

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
G$_CHECK_LOGON_RULES	Oracle Package Procedure	S10B80.BANSECR.G$_SECURITY_PKG	Use (select)Rely On
G$_GET_LAST_LOGIN_TIME	Oracle Package Function	S10B80.BANSECR.G$_SECURITY_PKG	Use (select)
G$_GET_USERNAME_NAME	Oracle Package Function	S10B80.BANSECR.G$_SECURITY_PKG	Use (select)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GURLOGN	SQL Index	S10B80.BANSECR	Rely On
GT_GURLOGN_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.BANSECR.GURLOGN

Object Dates

Creation Date	Analysis Date
04/03/2008 10:44:00:000	04/03/2008 10:47:27:000

Source Code Comments

GURLOGN: This table stores information related to logins to Oracle by users of Banner as defined in GURUCLS.

Columns Comments for GURLOGN_USER (# 1)

Source Code Comments

USERNAME: Oracle username.

Columns Comments for GURLOGN_PIDM (# 2)

Source Code Comments

PIDM: A PIDM for a non-primary identification of the user. The primary identification is stored in GOBEACC.

Columns Comments for GURLOGN_LAST_NAME (# 3)

Source Code Comments

LAST NAME: The last name of the user if they do not have a related PIDM.

Columns Comments for GURLOGN_FIRST_NAME (# 4)

Source Code Comments

FIRST NAME: The first name of the user if they do not have a related PIDM.

Columns Comments for GURLOGN_INB_LOGON_COUNT (# 5)

Source Code Comments

INB LOGON COUNT: The number of times this user has logged into Banner INB.

Columns Comments for GURLOGN_INB_LAST_LOGON_DATE (# 6)

Source Code Comments

INB LAST LOGON DATE: The date of the last time this user has logged on to Banner INB.

Columns Comments for GURLOGN_INB_FIRST_LOGON_DATE (# 7)

Source Code Comments

INB FIRST LOGON DATE: The date of the first time this user has logged on to Banner INB.

Columns Comments for GURLOGN_INB_LOGIN_CALENDAR (# 8)

Source Code Comments

INB LOGIN CALENDAR: An optional calendar that can be used to restrict when this user may log on to Banner INB.

Columns Comments for GURLOGN_INB_ACTIVE_FROM (# 9)

Source Code Comments

INB ACTIVE FROM: The first date that this user may log on to Banner INB.

Columns Comments for GURLOGN_INB_ACTIVE_TO (# 10)

Source Code Comments

INB ACTIVE TO: The last date that this user may log on to Banner INB.

Columns Comments for GURLOGN_LOGON_COUNT (# 11)

Source Code Comments

LOGON COUNT: The number of times this user has logged into Oracle. This is only incremented if the database logon trigger GT_GURALGN_AUDIT_LOGON is enabled.

Columns Comments for GURLOGN_LAST_LOGON_DATE (# 12)

Source Code Comments

LAST LOGON DATE: The last time this user logged into Oracle. This is only incremented if the database logon trigger GT_GURALGN_AUDIT_LOGON is enabled.

Columns Comments for GURLOGN_FIRST_LOGON_DATE (# 13)

Source Code Comments

FIRST LOGON DATE: The first time this user logged into Oracle. This is only incremented if the database logon trigger GT_GURALGN_AUDIT_LOGON is enabled.

Columns Comments for GURLOGN_LOGIN_CALENDAR (# 14)

Source Code Comments

Columns Comments for GURLOGN_ACTIVE_FROM (# 15)

Source Code Comments

ACTIVE FROM: For future use.

Columns Comments for GURLOGN_ACTIVE_TO (# 16)

Source Code Comments

ACTIVE TO: For future use.

Columns Comments for GURLOGN_AUTHORIZATION_BY (# 17)

Source Code Comments

AUTHORIZATION BY: Optional information indicating who authorized this account.

Columns Comments for GURLOGN_AUTHORIZATION_DATE (# 18)

Source Code Comments

AUTHORIZATION DATE: Optional information indicating that date of account authorization.

Columns Comments for GURLOGN_AUTHORIZATION_DOCUMENT (# 19)

Source Code Comments

AUTHORIZATION DOCUMENT: Optional information referencing the document authorizing this account.

Columns Comments for GURLOGN_COMMENTS (# 20)

Source Code Comments

COMMENTS: Comments related to this user.

Columns Comments for GURLOGN_USER_ID (# 21)

Source Code Comments

USER ID: User ID of the user who created or last updated the record.

Columns Comments for GURLOGN_ACTIVITY_DATE (# 22)

Source Code Comments

ACTIVITY DATE: Date record was created or last updated.

Columns Comments for GURLOGN_DATA_ORIGIN (# 23)

Source Code Comments

DATA ORIGIN: Source system that created or updated the row.

Table GUROGRP

Server Name S10B80
Database Name BANSECR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GUROGRP_SGRP_CODE	VARCHAR2(30)	No	*	*
GUROGRP_OBJECT	VARCHAR2(30)	No	*
GUROGRP_ROLE	VARCHAR2(30)	No
GUROGRP_USER_ID	VARCHAR2(30)	No
GUROGRP_ACTIVITY_DATE	DATE	No
GUROGRP_DATA_ORIGIN	VARCHAR2(30)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GUROGRP_SGRP_CODE	GTVSGRP_CODE	GTVSGRP

Index

Index Name	Index Type	Column Name
PK_GUROGRP	Unique	GUROGRP_SGRP_CODE
PK_GUROGRP	Unique	GUROGRP_OBJECT

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GURUGRP	SQL Table	S10B80.BANSECR	Join
GUVUOBJ	SQL View	S10B80.BANSECR	Use (select)
G$_CHECK_AUTHORIZATION_FNC	Oracle Package Function	S10B80.BANSECR.G$_AUTHORIZATION_PKG	Use (select)
G$_GET_ROLE_FOR_OBJECT_FNC	Oracle Package Function	S10B80.BANSECR.G$_SECURITY_PKG	Use (select)
G$_SYNC_USER_GRANTS_FNC	Oracle Package Function	S10B80.BANSECR.G$_AUTHORIZATION_PKG	Use (select)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GUROGRP	SQL Index	S10B80.BANSECR	Rely On
GTVSGRP	SQL Table	S10B80.BANSECR	Refer (no action)
GT_GUROGRP_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.BANSECR.GUROGRP

Object Dates

Creation Date	Analysis Date
04/03/2008 10:44:08:000	04/03/2008 10:47:27:000

Source Code Comments

GUROGRP: This table defines individual objects belonging to a security group.

Columns Comments for GUROGRP_SGRP_CODE (# 1)

Source Code Comments

SECURITY GROUP: The name of a security group.

Columns Comments for GUROGRP_OBJECT (# 2)

Source Code Comments

OBJECT: Banner object that is part of this group.

Columns Comments for GUROGRP_ROLE (# 3)

Source Code Comments

ROLE: Role assigned to the object that is part of this group.

Columns Comments for GUROGRP_USER_ID (# 4)

Source Code Comments

USER ID: User ID of the user who created or last updated the record.

Columns Comments for GUROGRP_ACTIVITY_DATE (# 5)

Source Code Comments

ACTIVITY DATE: Date record was created or last updated.

Columns Comments for GUROGRP_DATA_ORIGIN (# 6)

Source Code Comments

DATA ORIGIN: Source system that created or updated the row.

Table GUROWNG

Server Name S10B80
Database Name BANSECR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GUROWNG_OWNG_CODE	VARCHAR2(30)	No	*	*
GUROWNG_USER	VARCHAR2(30)	No	*
GUROWNG_USER_ID	VARCHAR2(30)	No
GUROWNG_ACTIVITY_DATE	DATE	No
GUROWNG_OWNER	VARCHAR2(30)	Yes
GUROWNG_COMMENTS	VARCHAR2(4000)	Yes
GUROWNG_DATA_ORIGIN	VARCHAR2(30)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GUROWNG_OWNG_CODE	GTVOWNG_CODE	GTVOWNG

Index

Index Name	Index Type	Column Name
PK_GUROWNG	Unique	GUROWNG_OWNG_CODE
PK_GUROWNG	Unique	GUROWNG_USER

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GUROWNR	SQL Table	S10B80.BANSECR	Join
GUVOWNR	SQL View	S10B80.BANSECR	Use (select)
TEST_GUVOWNR	SQL View	S10B80.BANSECR	Use (select)
G$_GET_DIST_USER_OBJ_PRIVS	Oracle Package Procedure	S10B80.BANSECR.G$_SECURITY_PKG	Use (select)
G$_ALLOW_DIST_USER_ACCESS	Oracle Package Function	S10B80.BANSECR.G$_SECURITY_PKG	Use (select)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GUROWNG	SQL Index	S10B80.BANSECR	Rely On
GTVOWNG	SQL Table	S10B80.BANSECR	Refer (no action)
GT_GUROWNG_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.BANSECR.GUROWNG

Object Dates

Creation Date	Analysis Date
04/03/2008 10:44:10:000	04/03/2008 10:47:27:000

Source Code Comments

GUROWNG: This table defines groups of users for distributed security.

Columns Comments for GUROWNG_OWNG_CODE (# 1)

Source Code Comments

GROUP CODE: The name of a group of distributed users. This name may not be PUBLIC or start with BANSECR.

Columns Comments for GUROWNG_USER (# 2)

Source Code Comments

USER: Oracle user identified as a distributed user. This user must be PUBLIC or start with BANSECR.

Columns Comments for GUROWNG_USER_ID (# 3)

Source Code Comments

USER ID: User ID of the user who created or last updated the record.

Columns Comments for GUROWNG_ACTIVITY_DATE (# 4)

Source Code Comments

ACTIVITY DATE: Date record was created or last updated.

Columns Comments for GUROWNG_OWNER (# 5)

Source Code Comments

OWNER: The owner of the group for use by distributed security.

Columns Comments for GUROWNG_COMMENTS (# 6)

Source Code Comments

COMMENTS: Comments related to this class.

Columns Comments for GUROWNG_DATA_ORIGIN (# 7)

Source Code Comments

DATA ORIGIN: Source system that created or updated the row.

Table GUROWNR

Server Name S10B80
Database Name BANSECR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GUROWNR_OWNER	VARCHAR2(30)	No	*	*
GUROWNR_OBJECT	VARCHAR2(30)	No	*
GUROWNR_OBJECT_TYPE	VARCHAR2(1)	No	*
GUROWNR_GRANTOR	VARCHAR2(30)	No
GUROWNR_PRIV_GRANT	VARCHAR2(1)	No
GUROWNR_PRIV_GRANT_ASSIGN	VARCHAR2(1)	No
GUROWNR_PRIV_REVOKE	VARCHAR2(1)	No
GUROWNR_PRIV_REVOKE_ASSIGN	VARCHAR2(1)	No
GUROWNR_PRIV_DELETE	VARCHAR2(1)	No
GUROWNR_PRIV_DELETE_ASSIGN	VARCHAR2(1)	No
GUROWNR_PRIV_MODIFY	VARCHAR2(1)	No
GUROWNR_PRIV_MODIFY_ASSIGN	VARCHAR2(1)	No
GUROWNR_USER_ID	VARCHAR2(30)	No
GUROWNR_ACTIVITY_DATE	DATE	No
GUROWNR_COMMENTS	VARCHAR2(4000)	Yes
GUROWNR_DATA_ORIGIN	VARCHAR2(30)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GUROWNR_OWNER	GUROWNG_OWNG_CODE	GUROWNG

Index

Index Name	Index Type	Column Name
PK_GUROWNR	Unique	GUROWNR_OWNER
PK_GUROWNR	Unique	GUROWNR_OBJECT
PK_GUROWNR	Unique	GUROWNR_OBJECT_TYPE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GTVCLAS	SQL Table	S10B80.BANSECR	Join
GUBROLE	SQL Table	S10B80.BANSECR	Join
GURAOBJ	SQL Table	S10B80.BANSECR	Join
GUVOWNR	SQL View	S10B80.BANSECR	Use (select)
TEST_GUVOWNR	SQL View	S10B80.BANSECR	Use (select)
G$_GET_DIST_USER_OBJ_PRIVS	Oracle Package Procedure	S10B80.BANSECR.G$_SECURITY_PKG	Use (select)
G$_ALLOW_DIST_USER_ACCESS	Oracle Package Function	S10B80.BANSECR.G$_SECURITY_PKG	Use (select)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GUROWNR	SQL Index	S10B80.BANSECR	Rely On
GUROWNG	SQL Table	S10B80.BANSECR	Join
GT_GUROWNR_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.BANSECR.GUROWNR

Object Dates

Creation Date	Analysis Date
04/03/2008 10:44:11:000	04/03/2008 10:47:27:000

Source Code Comments

GUROWNR: This table defines the objects owned by distributed security users and their access for each object.

Columns Comments for GUROWNR_OWNER (# 1)

Source Code Comments

OWNER: The distributed security user of the object.

Columns Comments for GUROWNR_OBJECT (# 2)

Source Code Comments

OBJECT: The owned object for which access is being defined.

Columns Comments for GUROWNR_OBJECT_TYPE (# 3)

Source Code Comments

OBJECT TYPE: The type of object. C-Class, O-Object, R-Role, P-Profile.

Columns Comments for GUROWNR_GRANTOR (# 4)

Source Code Comments

GRANTOR: The distributed user that granted the permissions.

Columns Comments for GUROWNR_PRIV_GRANT (# 5)

Source Code Comments

PRIVILEGE GRANT: Ability to grant or add this object to an end user / class / profile / role.

Columns Comments for GUROWNR_PRIV_GRANT_ASSIGN (# 6)

Source Code Comments

PRIVILEGE ASSIGN GRANT: Ability to assign the granting privilege of this object to another distributed user.

Columns Comments for GUROWNR_PRIV_REVOKE (# 7)

Source Code Comments

PRIVILEGE REVOKE: Ability to revoke or remove access to this object to an end user / class / profile / role.

Columns Comments for GUROWNR_PRIV_REVOKE_ASSIGN (# 8)

Source Code Comments

PRIVILEGE ASSIGN REVOKE: Ability to revoke the granting privilege of this object from another distributed user.

Columns Comments for GUROWNR_PRIV_DELETE (# 9)

Source Code Comments

PRIVILEGE DELETE: Ability to delete this object.

Columns Comments for GUROWNR_PRIV_DELETE_ASSIGN (# 10)

Source Code Comments

PRIVILEGE ASSIGN DELETE: Ability to assign the delete privilege of this object to another distributed user.

Columns Comments for GUROWNR_PRIV_MODIFY (# 11)

Source Code Comments

PRIVILEGE MODIFY: Ability to modify this object.

Columns Comments for GUROWNR_PRIV_MODIFY_ASSIGN (# 12)

Source Code Comments

PRIVILEGE ASSIGN MODIFY: Ability to assign the modify privilege of this object to another distributed user.

Columns Comments for GUROWNR_USER_ID (# 13)

Source Code Comments

USER ID: User ID of the user who created or last updated the record.

Columns Comments for GUROWNR_ACTIVITY_DATE (# 14)

Source Code Comments

ACTIVITY DATE: Date record was created or last updated.

Columns Comments for GUROWNR_COMMENTS (# 15)

Source Code Comments

COMMENTS: Comments related to this ownership relationship.

Columns Comments for GUROWNR_DATA_ORIGIN (# 16)

Source Code Comments

DATA ORIGIN: Source system that created or updated the row.

Table GURSQLL

Server Name S10B80
Database Name BANSECR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL
GURSQLL_SEQ	NUMBER(0,0)	Yes
GURSQLL_ACTIVITY_DATE	DATE	Yes
GURSQLL_CMD	CLOB	Yes
GURSQLL_USER_ID	VARCHAR2(30)	No
GURSQLL_DATA_ORIGIN	VARCHAR2(30)	Yes

Foreign Key information

No Foreign Key

Index

No Result

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
LOG_THE_COMMAND	Oracle Package Procedure	S10B80.BANSECR.GP_UDC_ORACLE_ID	Use (Insert)

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.BANSECR.GURSQLL

Object Dates

Creation Date	Analysis Date
04/03/2008 10:43:59:000	04/03/2008 10:47:27:000

Source Code Comments

GURSQLL: Log of SQL commands that are dynamically generated and executed by the security system front end.

Columns Comments for GURSQLL_SEQ (# 1)

Source Code Comments

SEQUENCE: A one up number derived from the sequence column GUBOSEQ.

Columns Comments for GURSQLL_ACTIVITY_DATE (# 2)

Source Code Comments

ACTIVITY DATE: Date record was created or last updated.

Columns Comments for GURSQLL_CMD (# 3)

Source Code Comments

COMMAND: The dynamic SQL command that was executed.

Columns Comments for GURSQLL_USER_ID (# 4)

Source Code Comments

USER ID: User ID of the user who created or last updated the record.

Columns Comments for GURSQLL_DATA_ORIGIN (# 5)

Source Code Comments

DATA ORIGIN: Source system that created or updated the row.

Table GURUACC

Server Name S10B80
Database Name BANSECR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL
GURUACC_TYPE	VARCHAR2(12)	Yes
GURUACC_USER	VARCHAR2(30)	Yes
GURUACC_OBJECT	VARCHAR2(30)	Yes
GURUACC_ROLE	VARCHAR2(30)	Yes
GURUACC_CLASS	VARCHAR2(30)	Yes
GURUACC_GROUP	VARCHAR2(30)	Yes
GURUACC_RANK	NUMBER(0,0)	Yes

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.BANSECR.GURUACC

Object Dates

Creation Date	Analysis Date
04/03/2008 10:43:39:000	04/03/2008 10:47:26:000

Source Code Comments

Object Access by User

Columns Comments for GURUACC_TYPE (# 1)

Source Code Comments

TYPE: How access was defined: via a Class (Class), via a Direct grant (Direct), via a class defined in a group (Group Class), or via a direct grant to a group (Group Direct).

Columns Comments for GURUACC_USER (# 2)

Source Code Comments

USER: The Oracle Id for which access is being defined.

Columns Comments for GURUACC_OBJECT (# 3)

Source Code Comments

OBJECT: The Banner object for which access is being defined.

Columns Comments for GURUACC_ROLE (# 4)

Source Code Comments

ROLE: The default role of the object being accessed.

Columns Comments for GURUACC_CLASS (# 5)

Source Code Comments

CLASS: The Banner Class where this object access was defined. If access was via a direct grant, this will be NULL.

Columns Comments for GURUACC_GROUP (# 6)

Source Code Comments

GROUP: The Security Group where access was defined. If access was defined either directly or via a class this will be NULL.

Columns Comments for GURUACC_RANK (# 7)

Source Code Comments

RANK: The order in which the roles will be used.

Table GURUCLS

Server Name S10B80
Database Name BANSECR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GURUCLS_USERID	VARCHAR2(30)	No	*
GURUCLS_CLASS_CODE	VARCHAR2(30)	No	*	*
GURUCLS_ACTIVITY_DATE	DATE	Yes
GURUCLS_USER_ID	VARCHAR2(30)	No
GURUCLS_COMMENTS	VARCHAR2(4000)	Yes
GURUCLS_DATA_ORIGIN	VARCHAR2(30)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GURUCLS_CLASS_CODE	GTVCLAS_CLASS_CODE	GTVCLAS

Index

Index Name	Index Type	Column Name
PK_GURUCLS	Unique	GURUCLS_USERID
PK_GURUCLS	Unique	GURUCLS_CLASS_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GURUOBJ	SQL Table	S10B80.BANSECR	Join
GUVUOBJ	SQL View	S10B80.BANSECR	Use (select)
TEST_GUVBUSR	SQL View	S10B80.BANSECR	Use (select)
DUPLICATE_BANNER_PERMISSIONS	Oracle Package Procedure	S10B80.BANSECR.GP_UDC_ORACLE_ID	Use (Insert,select)
G$_AUDIT_BANNER_LOGOFF	Oracle Package Procedure	S10B80.BANSECR.G$_SECURITY_PKG	Use (select)
G$_AUDIT_BANNER_LOGON	Oracle Package Procedure	S10B80.BANSECR.G$_SECURITY_PKG	Use (select)
G$_GET_PROXY_INFO	Oracle Package Procedure	S10B80.BANSECR.GSPPRXY	Use (select)Rely On
P_REMOVE_BANNER_PERMISSIONS	Oracle Package Procedure	S10B80.BANSECR.GP_UDC_ORACLE_ID	Use (delete)
G$_CHECK_AUTHORIZATION_FNC	Oracle Package Function	S10B80.BANSECR.G$_AUTHORIZATION_PKG	Use (select)
G$_CHECK_USER_CLASS_FNC	Oracle Package Function	S10B80.BANSECR.G$_AUTHORIZATION_PKG	Use (select)
G$_GET_ROLE_FOR_OBJECT_FNC	Oracle Package Function	S10B80.BANSECR.G$_SECURITY_PKG	Use (select)
G$_GET_TAB_SECURITY_FNC	Oracle Package Function	S10B80.BANSECR.G$_SECURITY_PKG	Use (select)Rely On
G$_SYNC_CLASS_GRANTS_FNC	Oracle Package Function	S10B80.BANSECR.G$_AUTHORIZATION_PKG	Use (select)
G$_SYNC_USER_GRANTS_FNC	Oracle Package Function	S10B80.BANSECR.G$_AUTHORIZATION_PKG	Use (delete,select)
PREDICATE_FNC	Oracle Package Function	S10B80.BANSECR.G$_OBJECT_SECURITY	Use (select)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GURUCLS	SQL Index	S10B80.BANSECR	Rely On
GTVCLAS	SQL Table	S10B80.BANSECR	Refer (no action)
GT_GURUCLS_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.BANSECR.GURUCLS

Object Dates

Creation Date	Analysis Date
04/03/2008 10:43:52:000	04/03/2008 10:47:26:000

Source Code Comments

GURUCLS: Table to track what BANNER security classes a user is authorized to access.

Columns Comments for GURUCLS_USERID (# 1)

Source Code Comments

USERID: The Oracle User ID associated with the class code.

Columns Comments for GURUCLS_CLASS_CODE (# 2)

Source Code Comments

CLASS CODE: The class code assigned to the userid.

Columns Comments for GURUCLS_ACTIVITY_DATE (# 3)

Source Code Comments

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

Columns Comments for GURUCLS_USER_ID (# 4)

Source Code Comments

USER ID: User ID of the user who created or last updated the record.

Columns Comments for GURUCLS_COMMENTS (# 5)

Source Code Comments

COMMENTS: Comments related to this class.

Columns Comments for GURUCLS_DATA_ORIGIN (# 6)

Source Code Comments

DATA ORIGIN: Source system that created or updated the row.

Table GURUGRP

Server Name S10B80
Database Name BANSECR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GURUGRP_SGRP_CODE	VARCHAR2(30)	No	*	*
GURUGRP_USER	VARCHAR2(30)	No	*
GURUGRP_USER_ID	VARCHAR2(30)	No
GURUGRP_ACTIVITY_DATE	DATE	No
GURUGRP_DATA_ORIGIN	VARCHAR2(30)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GURUGRP_SGRP_CODE	GTVSGRP_CODE	GTVSGRP
GURUGRP_SGRP_CODE	GURCGRP_SGRP_CODE	GURCGRP
GURUGRP_SGRP_CODE	GUROGRP_SGRP_CODE	GUROGRP

Index

Index Name	Index Type	Column Name
PK_GURUGRP	Unique	GURUGRP_SGRP_CODE
PK_GURUGRP	Unique	GURUGRP_USER

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GUVUOBJ	SQL View	S10B80.BANSECR	Use (select)
TEST_GUVBUSR	SQL View	S10B80.BANSECR	Use (select)
G$_AUDIT_BANNER_LOGOFF	Oracle Package Procedure	S10B80.BANSECR.G$_SECURITY_PKG	Use (select)
G$_AUDIT_BANNER_LOGON	Oracle Package Procedure	S10B80.BANSECR.G$_SECURITY_PKG	Use (select)
G$_CHECK_AUTHORIZATION_FNC	Oracle Package Function	S10B80.BANSECR.G$_AUTHORIZATION_PKG	Use (select)
G$_GET_ROLE_FOR_OBJECT_FNC	Oracle Package Function	S10B80.BANSECR.G$_SECURITY_PKG	Use (select)
G$_GET_TAB_SECURITY_FNC	Oracle Package Function	S10B80.BANSECR.G$_SECURITY_PKG	Use (select)
G$_SYNC_CLASS_GRANTS_FNC	Oracle Package Function	S10B80.BANSECR.G$_AUTHORIZATION_PKG	Use (select)
G$_SYNC_USER_GRANTS_FNC	Oracle Package Function	S10B80.BANSECR.G$_AUTHORIZATION_PKG	Use (delete,select)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GURUGRP	SQL Index	S10B80.BANSECR	Rely On
GTVSGRP	SQL Table	S10B80.BANSECR	Refer (no action)
GURCGRP	SQL Table	S10B80.BANSECR	Join
GUROGRP	SQL Table	S10B80.BANSECR	Join
GT_GURUGRP_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.BANSECR.GURUGRP

Object Dates

Creation Date	Analysis Date
04/03/2008 10:44:24:000	04/03/2008 10:47:27:000

Source Code Comments

GURUGRP: This table defines users belonging to a security group.

Columns Comments for GURUGRP_SGRP_CODE (# 1)

Source Code Comments

SECURITY GROUP: The name of a security group.

Columns Comments for GURUGRP_USER (# 2)

Source Code Comments

USER: Banner user that is part of this group.

Columns Comments for GURUGRP_USER_ID (# 3)

Source Code Comments

USER ID: User ID of the user who created or last updated the record.

Columns Comments for GURUGRP_ACTIVITY_DATE (# 4)

Source Code Comments

ACTIVITY DATE: Date record was created or last updated.

Columns Comments for GURUGRP_DATA_ORIGIN (# 5)

Source Code Comments

DATA ORIGIN: Source system that created or updated the row.

Table GURUOBJ

Server Name S10B80
Database Name BANSECR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GURUOBJ_OBJECT	VARCHAR2(30)	No	*
GURUOBJ_ROLE	VARCHAR2(30)	No
GURUOBJ_USERID	VARCHAR2(30)	No	*	*
GURUOBJ_ACTIVITY_DATE	DATE	No
GURUOBJ_USER_ID	VARCHAR2(30)	No
GURUOBJ_COMMENTS	VARCHAR2(4000)	Yes
GURUOBJ_DATA_ORIGIN	VARCHAR2(30)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GURUOBJ_USERID	GURUCLS_CLASS_CODE	GURUCLS
GURUOBJ_USERID	GURCGRP_CLASS	GURCGRP

Index

Index Name	Index Type	Column Name
GURUOBJ_INDEX		GURUOBJ_OBJECT
GURUOBJ_INDEX		GURUOBJ_USERID
PK_GURUOBJ	Unique	GURUOBJ_USERID
PK_GURUOBJ	Unique	GURUOBJ_OBJECT

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GURUTAB	SQL Table	S10B80.BANSECR	Refer (no action)
GUVUOBJ	SQL View	S10B80.BANSECR	Use (select)
TEST_GUVBUSR	SQL View	S10B80.BANSECR	Use (select)
DUPLICATE_BANNER_PERMISSIONS	Oracle Package Procedure	S10B80.BANSECR.GP_UDC_ORACLE_ID	Use (Insert,select)
ROLE_NAME	Oracle Package Variable	S10B80.BANSECR.G$_SECURITY_PKG	Rely On
G$_AUDIT_BANNER_LOGOFF	Oracle Package Procedure	S10B80.BANSECR.G$_SECURITY_PKG	Use (select)
G$_AUDIT_BANNER_LOGON	Oracle Package Procedure	S10B80.BANSECR.G$_SECURITY_PKG	Use (select)
P_REMOVE_BANNER_PERMISSIONS	Oracle Package Procedure	S10B80.BANSECR.GP_UDC_ORACLE_ID	Use (delete)
G$_CHECK_AUTHORIZATION_FNC	Oracle Package Function	S10B80.BANSECR.G$_AUTHORIZATION_PKG	Use (select)
G$_GET_ROLE_FOR_OBJECT_FNC	Oracle Package Function	S10B80.BANSECR.G$_SECURITY_PKG	Use (select)
G$_GET_TAB_SECURITY_FNC	Oracle Package Function	S10B80.BANSECR.G$_SECURITY_PKG	Use (select)Rely On
G$_SYNC_USER_GRANTS_FNC	Oracle Package Function	S10B80.BANSECR.G$_AUTHORIZATION_PKG	Use (delete,select)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GURUOBJ_INDEX	SQL Index	S10B80.BANSECR	Rely On
PK_GURUOBJ	SQL Index	S10B80.BANSECR	Rely On
GURCGRP	SQL Table	S10B80.BANSECR	Join
GURUCLS	SQL Table	S10B80.BANSECR	Join
GT_GURUOBJ_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.BANSECR.GURUOBJ

Object Dates

Creation Date	Analysis Date
04/03/2008 10:44:23:000	04/03/2008 10:47:27:000

Source Code Comments

GURUOBJ: This table defines the type of access, by userid, for each Banner object.

Columns Comments for GURUOBJ_OBJECT (# 1)

Source Code Comments

OBJECT: The Banner object name.

Columns Comments for GURUOBJ_ROLE (# 2)

Source Code Comments

ROLE: The Banner Role associated with the object.

Columns Comments for GURUOBJ_USERID (# 3)

Source Code Comments

USERID: The Oracle User ID associated with the role and object.

Columns Comments for GURUOBJ_ACTIVITY_DATE (# 4)

Source Code Comments

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

Columns Comments for GURUOBJ_USER_ID (# 5)

Source Code Comments

USER ID: User ID of the user who created or last updated the record.

Columns Comments for GURUOBJ_COMMENTS (# 6)

Source Code Comments

COMMENTS: Comments related to this object.

Columns Comments for GURUOBJ_DATA_ORIGIN (# 7)

Source Code Comments

DATA ORIGIN: Source system that created or updated the row.

Table GURUSRI

Server Name S10B80
Database Name BANSECR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GURUSRI_VPDI_USER_ID	VARCHAR2(30)	No	*
GURUSRI_VPDI_CODE	VARCHAR2(6)	No	*	*
GURUSRI_USER_DEF_INST_IND	VARCHAR2(1)	No
GURUSRI_ACTIVITY_DATE	DATE	No
GURUSRI_USER_ID	VARCHAR2(30)	No
GURUSRI_DATA_ORIGIN	VARCHAR2(30)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GURUSRI_VPDI_CODE	GTVVPDI_CODE	GTVVPDI

Index

Index Name	Index Type	Column Name
PK_GURUSRI	Unique	GURUSRI_VPDI_USER_ID
PK_GURUSRI	Unique	GURUSRI_VPDI_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SECURITY_RECORD_TYPE	Oracle Package Type	S10B80.BANSECR.G$_VPDI_SECURITY	Rely On
G$_VPDI_GET_USER_INSTS	Oracle Package Procedure	S10B80.BANSECR.G$_VPDI_SECURITY	Use (select)
G$_VPDI_GET_USER_INST_COUNT	Oracle Package Procedure	S10B80.BANSECR.G$_VPDI_SECURITY	Use (select)
G$_VPDI_SET_HOME_CONTEXT	Oracle Package Procedure	S10B80.BANSECR.G$_VPDI_SECURITY	Use (select)
G$_VPDI_SET_USER_DEFAULT	Oracle Package Procedure	S10B80.BANSECR.G$_VPDI_SECURITY	Use (update)
GET_MIF_CODES_FOR_USER	Oracle Package Procedure	S10B80.BANSECR.GSPVPDI	Use (select)
GET_MIF_DEFAULT_CODE_FOR_USER	Oracle Package Function	S10B80.BANSECR.GSPVPDI	Use (select)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GURUSRI	SQL Index	S10B80.BANSECR	Rely On
GTVVPDI	SQL Table	S10B80.BANSECR	Refer (no action)
GT_GURUSRI_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.BANSECR.GURUSRI

Object Dates

Creation Date	Analysis Date
04/03/2008 10:44:04:000	04/03/2008 10:47:27:000

Source Code Comments

GURUSRI: VPD Institution/Banner User Table.

Columns Comments for GURUSRI_VPDI_USER_ID (# 1)

Source Code Comments

VPDI User ID: The userid of the individual being setup on the GSAVPDI form.

Columns Comments for GURUSRI_VPDI_CODE (# 2)

Source Code Comments

INSTITUTION CODE: The Institution code from GTVVPDI.

Columns Comments for GURUSRI_USER_DEF_INST_IND (# 3)

Source Code Comments

USER DEFAULT: Each user must have a default institution. Valid values are Y and N.

Columns Comments for GURUSRI_ACTIVITY_DATE (# 4)

Source Code Comments

ACTIVITY DATE: The date that the information for the row was inserted or updated in the GURUSRI table.

Columns Comments for GURUSRI_USER_ID (# 5)

Source Code Comments

USER ID: User ID of the user who created or last updated the record.

Columns Comments for GURUSRI_DATA_ORIGIN (# 6)

Source Code Comments

DATA ORIGIN: Source system that created or updated the row.

Table GURUTAB

Server Name S10B80
Database Name BANSECR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GURUTAB_FORM_NAME	VARCHAR2(30)	No	*	*
GURUTAB_INTERNAL_TAB_NAME	VARCHAR2(30)	No	*	*
GURUTAB_ACCESS	VARCHAR2(1)	No
GURUTAB_CLASS_OR_USER	VARCHAR2(30)	No	*	*
GURUTAB_ACTIVITY_DATE	DATE	No
GURUTAB_USER_ID	VARCHAR2(30)	No
GURUTAB_DATA_ORIGIN	VARCHAR2(30)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GURUTAB_FORM_NAME	GURATAB_FORM_NAME	GURATAB
GURUTAB_INTERNAL_TAB_NAME	GURATAB_INTERNAL_TAB_NAME	GURATAB
GURUTAB_CLASS_OR_USER	GURUOBJ_USERID	GURUOBJ
GURUTAB_FORM_NAME	GURUOBJ_OBJECT	GURUOBJ

Index

Index Name	Index Type	Column Name
PK_GURUTAB	Unique	GURUTAB_FORM_NAME
PK_GURUTAB	Unique	GURUTAB_INTERNAL_TAB_NAME
PK_GURUTAB	Unique	GURUTAB_CLASS_OR_USER

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
DUPLICATE_BANNER_PERMISSIONS	Oracle Package Procedure	S10B80.BANSECR.GP_UDC_ORACLE_ID	Use (Insert,select)
P_REMOVE_BANNER_PERMISSIONS	Oracle Package Procedure	S10B80.BANSECR.GP_UDC_ORACLE_ID	Use (delete)
G$_GET_TAB_SECURITY_FNC	Oracle Package Function	S10B80.BANSECR.G$_SECURITY_PKG	Use (select)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_GURUTAB	SQL Index	S10B80.BANSECR	Rely On
GURATAB	SQL Table	S10B80.BANSECR	Refer (no action)
GURUOBJ	SQL Table	S10B80.BANSECR	Refer (no action)
GT_GURUTAB_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.BANSECR.GURUTAB

Object Dates

Creation Date	Analysis Date
04/03/2008 10:44:07:000	04/03/2008 10:47:27:000

Source Code Comments

GURUTAB: This table defines all the forms and their related tabs that are in use for tab based security for a user or a class.

Columns Comments for GURUTAB_FORM_NAME (# 1)

Source Code Comments

FORM NAME: The Banner form name.

Columns Comments for GURUTAB_INTERNAL_TAB_NAME (# 2)

Source Code Comments

INTERNAL TAB NAME: The internal name of the tab as defined in the form via Forms Builder.

Columns Comments for GURUTAB_ACCESS (# 3)

Source Code Comments

ACCESS: The type of access being defined for the tab. Valid values are F-Full Access, Q-Query access, N-Not Visible.

Columns Comments for GURUTAB_CLASS_OR_USER (# 4)

Source Code Comments

CLASS: The class or userid for which tab access is being defined.

Columns Comments for GURUTAB_ACTIVITY_DATE (# 5)

Source Code Comments

ACTIVITY DATE: Date record was created or last updated.

Columns Comments for GURUTAB_USER_ID (# 6)

Source Code Comments

USER ID: User ID of the user who created or last updated the record.

Columns Comments for GURUTAB_DATA_ORIGIN (# 7)

Source Code Comments

DATA ORIGIN: Source system that created or updated the row

View GUVOWNR

Server Name S10B80
Database Name BANSECR
View Label

View Columns information

Column Name	Column Type	Allow NULL
GUVOWNR_OBJECT_TYPE	CHAR(1)	Yes
GUVOWNR_OBJECT	VARCHAR2(30)	Yes
GUVOWNR_OWNER	VARCHAR2(30)	Yes
GUVOWNR_OWNER_TYPE	VARCHAR2(11)	Yes
GUVOWNR_GROUP	VARCHAR2(30)	Yes
GUVOWNR_GRANT	VARCHAR2(1)	Yes
GUVOWNR_REVOKE	VARCHAR2(1)	Yes
GUVOWNR_DELETE	VARCHAR2(1)	Yes
GUVOWNR_MODIFY	VARCHAR2(1)	Yes
GUVOWNR_GRANT_ASSIGN	VARCHAR2(1)	Yes
GUVOWNR_GRANT_REVOKE	VARCHAR2(1)	Yes
GUVOWNR_GRANT_DELETE	VARCHAR2(1)	Yes
GUVOWNR_GRANT_MODIFY	VARCHAR2(1)	Yes

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
GTVCLAS	SQL Table	S10B80.BANSECR	Use (select)
GUBROLE	SQL Table	S10B80.BANSECR	Use (select)
GURAOBJ	SQL Table	S10B80.BANSECR	Use (select)
GUROWNG	SQL Table	S10B80.BANSECR	Use (select)
GUROWNR	SQL Table	S10B80.BANSECR	Use (select)
VARCHAR2	Oracle Package Type	S10B80.SYS.STANDARD	Rely On
COALESCE	Oracle Package Function	S10B80.SYS.STANDARD	Call
DECODE	Oracle Package Function	S10B80.SYS.STANDARD	Call

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.BANSECR.GUVOWNR

Object Dates

Creation Date	Analysis Date
04/03/2008 10:45:08:000	04/03/2008 10:48:16:000

Source Code Comments

--
--
--
--
--**************************************************************
--
--
--
--
--**************************************************************
--
--
--
--

Number of code lines

Number of heading comment lines

Number of inner comment lines

Columns Comments for GUVOWNR_OBJECT_TYPE (# 1)

Source Code Comments

OBJECT TYPE: The type of object for which ownership is defined. (C)lass, (O)bject, or (R)ole.

Columns Comments for GUVOWNR_OBJECT (# 2)

Source Code Comments

OBJECT: The name of the object for which ownership is defined.

Columns Comments for GUVOWNR_OWNER (# 3)

Source Code Comments

OWNER: The distributed security owner of the object. Values are limited to BANSECR% accounts and PUBLIC.

Columns Comments for GUVOWNR_OWNER_TYPE (# 4)

Source Code Comments

OWNER TYPE: The ownership will be defined as Owner or Proxy. If the ownership is granted via a group, then the ownership will be identified as Owner Group or Proxy Group.

Columns Comments for GUVOWNR_GROUP (# 5)

Source Code Comments

GROUP: The security group that the user belongs to if the ownership is defined as Group Owner or Group Proxy. If the owner is not part of a group then this will be NULL.

Columns Comments for GUVOWNR_GRANT (# 6)

Source Code Comments

GRANT: Ability to grant or add this object to an end user / class / role.

Columns Comments for GUVOWNR_REVOKE (# 7)

Source Code Comments

REVOKE: Ability to revoke or remove access to this object to an end user / class / role.

Columns Comments for GUVOWNR_DELETE (# 8)

Source Code Comments

DELETE: Ability to delete this object.

Columns Comments for GUVOWNR_MODIFY (# 9)

Source Code Comments

MODIFY: Ability to modify this object.

Columns Comments for GUVOWNR_GRANT_ASSIGN (# 10)

Source Code Comments

GRANT ASSIGN: Ability to assign the granting privilege of this object to another distributed user.

Columns Comments for GUVOWNR_GRANT_REVOKE (# 11)

Source Code Comments

GRANT REVOKE: Ability to revoke the granting privilege of this object from another distributed user.

Columns Comments for GUVOWNR_GRANT_DELETE (# 12)

Source Code Comments

GRANT DELETE: Ability to assign the delete privilege of this object to another distributed user.

Columns Comments for GUVOWNR_GRANT_MODIFY (# 13)

Source Code Comments

GRANT MODIFY: Ability to assign the modify privilege of this object to another distributed user.

View GUVUOBJ

Server Name S10B80
Database Name BANSECR
View Label

View Columns information

Column Name	Column Type	Allow NULL
GUVUOBJ_USER_CLASS	VARCHAR2(30)	Yes
GUVUOBJ_OBJECT	VARCHAR2(30)	Yes
GUVUOBJ_ROLE	VARCHAR2(30)	Yes
GUVUOBJ_CLASS	VARCHAR2(30)	Yes
GUVUOBJ_DIRECT	VARCHAR2(30)	Yes
GUVUOBJ_TYPE	VARCHAR2(12)	Yes
GUVUOBJ_GROUP	VARCHAR2(30)	Yes
GUVUOBJ_GROUP_CLASS	VARCHAR2(30)	Yes

Index

No Result

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GUVUACC	SQL View	S10B80.BANSECR	Use (select)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GURCGRP	SQL Table	S10B80.BANSECR	Use (select)
GUROGRP	SQL Table	S10B80.BANSECR	Use (select)
GURUCLS	SQL Table	S10B80.BANSECR	Use (select)
GURUGRP	SQL Table	S10B80.BANSECR	Use (select)
GURUOBJ	SQL Table	S10B80.BANSECR	Use (select)
VARCHAR2	Oracle Package Type	S10B80.SYS.STANDARD	Rely On
ALL_USERS	Oracle Synonym	S10B80.PUBLIC	Use (select)
ALL_USERS	SQL View	S10B80.SYS	Use (select)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.BANSECR.GUVUOBJ

Object Dates

Creation Date	Analysis Date
04/03/2008 10:45:04:000	04/03/2008 10:48:16:000

Source Code Comments

--
--

Number of code lines

Number of heading comment lines

Number of inner comment lines

Link between GURAOBJ and GTVSYSI

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GURAOBJ and GTVSYSI (FK1_GURAOBJ_INV_GTVSYSI_CODE)	BANSECR

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GURAOBJ	GURAOBJ_SYSI_CODE	GTVSYSI_CODE	GTVSYSI	(1,1)-(0,n)

Link between GURCALN and GTVCALN

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GURCALN and GTVCALN (FK1_GURCALN_INV_GTVCALN_CODE)	BANSECR

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GURCALN	GURCALN_CALN_CODE	GTVCALN_CODE	GTVCALN	(1,1)-(0,n)

Link between GURBGRP and GTVSGRP

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GURBGRP and GTVSGRP (FK1_GURBGRP_INV_GTVSGRP_CODE)	BANSECR

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GURBGRP	GURBGRP_SGRP_CODE	GTVSGRP_CODE	GTVSGRP	(1,1)-(0,n)

Link between GUROGRP and GTVSGRP

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GUROGRP and GTVSGRP (FK1_GUROGRP_INV_GTVSGRP_CODE)	BANSECR

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GUROGRP	GUROGRP_SGRP_CODE	GTVSGRP_CODE	GTVSGRP	(1,1)-(0,n)

Link between GURUSRI and GTVVPDI

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GURUSRI and GTVVPDI (FK1_GURUSRI_INV_GTVVPDI_CODE)	BANSECR

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GURUSRI	GURUSRI_VPDI_CODE	GTVVPDI_CODE	GTVVPDI	(1,1)-(0,n)

Link between GORIROL and GTVVPDI

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GORIROL and GTVVPDI (FK1_GORIROL_INV_GTVVPDI_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GORIROL	GORIROL_VPDI_CODE	GTVVPDI_CODE	GTVVPDI	(0,1)-(0,n)

Link between GURUCLS and GTVCLAS

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GURUCLS and GTVCLAS (FK1_GURUCLS_INV_GTVCLAS_CODE)	BANSECR

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GURUCLS	GURUCLS_CLASS_CODE	GTVCLAS_CLASS_CODE	GTVCLAS	(1,1)-(0,n)

Link between GURUTAB and GURATAB

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GURUTAB and GURATAB (FK1_GURUTAB_INV_GURATAB_KEY)	BANSECR

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GURUTAB	GURUTAB_FORM_NAME	GURATAB_FORM_NAME	GURATAB	(1,1)-(0,n)
GURUTAB	GURUTAB_INTERNAL_TAB_NAME	GURATAB_INTERNAL_TAB_NAME	GURATAB	(1,1)-(0,n)

Link between GURATAB and GURAOBJ

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GURATAB and GURAOBJ (FK1_GURATAB_INV_GURAOBJ_KEY)	BANSECR

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GURATAB	GURATAB_FORM_NAME	GURAOBJ_OBJECT	GURAOBJ	(1,1)-(0,n)

Link between GURUTAB and GURUOBJ

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GURUTAB and GURUOBJ (FK1_GURUTAB_INV_GURUOBJ_KEY)	BANSECR

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GURUTAB	GURUTAB_FORM_NAME	GURUOBJ_OBJECT	GURUOBJ	(1,1)-(0,n)
GURUTAB	GURUTAB_CLASS_OR_USER	GURUOBJ_USERID	GURUOBJ	(1,1)-(0,n)

Link between GURUGRP and GTVSGRP

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GURUGRP and GTVSGRP (FK1_GURUGRP_INV_GTVSGRP_CODE)	BANSECR

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GURUGRP	GURUGRP_SGRP_CODE	GTVSGRP_CODE	GTVSGRP	(1,1)-(0,n)

Link between GURCGRP and GTVSGRP

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GURCGRP and GTVSGRP (FK1_GURCGRP_INV_GTVSGRP_CODE)	BANSECR

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GURCGRP	GURCGRP_SGRP_CODE	GTVSGRP_CODE	GTVSGRP	(1,1)-(0,n)

Link between GUROWNG and GTVOWNG

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GUROWNG and GTVOWNG (FK1_GUROWNG_INV_GTVOWNG_CODE)	BANSECR

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GUROWNG	GUROWNG_OWNG_CODE	GTVOWNG_CODE	GTVOWNG	(1,1)-(0,n)

Link between GURUOBJ and GURUCLS

Join Information

Objects list
schema-view : S10B80.BANSECR.GUVUOBJ scope-function : S10B80.BANSECR.G$_AUTHORIZATION_PKG.G$_CHECK_AUTHORIZATION_FNC scope-function : S10B80.BANSECR.G$_AUTHORIZATION_PKG.G$_SYNC_USER_GRANTS_FNC scope-function : S10B80.BANSECR.G$_SECURITY_PKG.G$_GET_ROLE_FOR_OBJECT_FNC scope-function : S10B80.BANSECR.G$_SECURITY_PKG.G$_GET_TAB_SECURITY_FNC

Link List

Link Type	Link	Project
Join	Link Between GURUOBJ and GURUCLS	BANSECR

List of Real links

Link type	Between	And
Join	GURUOBJ	GURUCLS

Link between GURUGRP and GURCGRP

Join Information

Objects list

schema-view : S10B80.BANSECR.GUVUOBJ
scope-function : S10B80.BANSECR.G$_AUTHORIZATION_PKG.G$_CHECK_AUTHORIZATION_FNC
scope-function : S10B80.BANSECR.G$_AUTHORIZATION_PKG.G$_SYNC_USER_GRANTS_FNC
scope-function : S10B80.BANSECR.G$_AUTHORIZATION_PKG.G$_SYNC_CLASS_GRANTS_FNC
scope-function : S10B80.BANSECR.G$_SECURITY_PKG.G$_GET_ROLE_FOR_OBJECT_FNC
scope-function : S10B80.BANSECR.G$_SECURITY_PKG.G$_GET_TAB_SECURITY_FNC

Link List

Link Type	Link	Project
Join	Link Between GURUGRP and GURCGRP	BANSECR

List of Real links

Link type	Between	And
Join	GURUGRP	GURCGRP

Link between GURUOBJ and GURCGRP

Join Information

Objects list
schema-view : S10B80.BANSECR.GUVUOBJ scope-function : S10B80.BANSECR.G$_AUTHORIZATION_PKG.G$_CHECK_AUTHORIZATION_FNC scope-function : S10B80.BANSECR.G$_AUTHORIZATION_PKG.G$_SYNC_USER_GRANTS_FNC scope-function : S10B80.BANSECR.G$_SECURITY_PKG.G$_GET_ROLE_FOR_OBJECT_FNC scope-function : S10B80.BANSECR.G$_SECURITY_PKG.G$_GET_TAB_SECURITY_FNC

Link List

Link Type	Link	Project
Join	Link Between GURUOBJ and GURCGRP	BANSECR

List of Real links

Link type	Between	And
Join	GURUOBJ	GURCGRP

Link between GURUGRP and GUROGRP

Join Information

Objects list
schema-view : S10B80.BANSECR.GUVUOBJ scope-function : S10B80.BANSECR.G$_AUTHORIZATION_PKG.G$_CHECK_AUTHORIZATION_FNC scope-function : S10B80.BANSECR.G$_AUTHORIZATION_PKG.G$_SYNC_USER_GRANTS_FNC scope-function : S10B80.BANSECR.G$_SECURITY_PKG.G$_GET_ROLE_FOR_OBJECT_FNC

Link List

Link Type	Link	Project
Join	Link Between GURUGRP and GUROGRP	BANSECR

List of Real links

Link type	Between	And
Join	GURUGRP	GUROGRP

Link between GUROWNR and GUROWNG

Join Information

Objects list
schema-view : S10B80.BANSECR.TEST_GUVOWNR schema-view : S10B80.BANSECR.GUVOWNR

Link List

Link Type	Link	Project
Join	Link Between GUROWNR and GUROWNG	BANSECR

List of Real links

Link type	Between	And
Join	GUROWNR	GUROWNG

Link between GTVCLAS and GUROWNR

Join Information

Objects list
schema-view : S10B80.BANSECR.TEST_GUVOWNR schema-view : S10B80.BANSECR.GUVOWNR

Link List

Link Type	Link	Project
Join	Link Between GTVCLAS and GUROWNR	BANSECR

List of Real links

Link type	Between	And
Join	GTVCLAS	GUROWNR

Link between GUBROLE and GUROWNR

Join Information

Objects list
schema-view : S10B80.BANSECR.TEST_GUVOWNR schema-view : S10B80.BANSECR.GUVOWNR

Link List

Link Type	Link	Project
Join	Link Between GUBROLE and GUROWNR	BANSECR

List of Real links

Link type	Between	And
Join	GUBROLE	GUROWNR

Link between GURAOBJ and GUROWNR

Join Information

Objects list
schema-view : S10B80.BANSECR.TEST_GUVOWNR schema-view : S10B80.BANSECR.GUVOWNR

Link List

Link Type	Link	Project
Join	Link Between GURAOBJ and GUROWNR	BANSECR

List of Real links

Link type	Between	And
Join	GURAOBJ	GUROWNR

Link between GUVUOBJ and GURUCLS

Link List

Link Type	Link	Project
Use (select)	Link Between GUVUOBJ and GURUCLS	BANSECR

List of Real links

Link type	Between	And
Use (select)	GUVUOBJ	GURUCLS

Link between GUVUOBJ and GUROGRP

Link List

Link Type	Link	Project
Use (select)	Link Between GUVUOBJ and GUROGRP	BANSECR

List of Real links

Link type	Between	And
Use (select)	GUVUOBJ	GUROGRP

Link between GUVUOBJ and GURUOBJ

Link List

Link Type	Link	Project
Use (select)	Link Between GUVUOBJ and GURUOBJ	BANSECR

List of Real links

Link type	Between	And
Use (select)	GUVUOBJ	GURUOBJ

Link between GUVUOBJ and GURUGRP

Link List

Link Type	Link	Project
Use (select)	Link Between GUVUOBJ and GURUGRP	BANSECR

List of Real links

Link type	Between	And
Use (select)	GUVUOBJ	GURUGRP

Link between GUVUOBJ and GURCGRP

Link List

Link Type	Link	Project
Use (select)	Link Between GUVUOBJ and GURCGRP	BANSECR

List of Real links

Link type	Between	And
Use (select)	GUVUOBJ	GURCGRP

Link between GUVOWNR and GURAOBJ

Link List

Link Type	Link	Project
Use (select)	Link Between GUVOWNR and GURAOBJ	BANSECR

List of Real links

Link type	Between	And
Use (select)	GUVOWNR	GURAOBJ

Link between GUVOWNR and GUBROLE

Link List

Link Type	Link	Project
Use (select)	Link Between GUVOWNR and GUBROLE	BANSECR

List of Real links

Link type	Between	And
Use (select)	GUVOWNR	GUBROLE

Link between GUVOWNR and GUROWNG

Link List

Link Type	Link	Project
Use (select)	Link Between GUVOWNR and GUROWNG	BANSECR

List of Real links

Link type	Between	And
Use (select)	GUVOWNR	GUROWNG

Link between GUVOWNR and GUROWNR

Link List

Link Type	Link	Project
Use (select)	Link Between GUVOWNR and GUROWNR	BANSECR

List of Real links

Link type	Between	And
Use (select)	GUVOWNR	GUROWNR

Link between GUVOWNR and GTVCLAS

Link List

Link Type	Link	Project
Use (select)	Link Between GUVOWNR and GTVCLAS	BANSECR

List of Real links

Link type	Between	And
Use (select)	GUVOWNR	GTVCLAS