Model Value Based Security

Model Label : Banner General Value Based Security
Path : BANNER DEV/General/ERD/Value Based Security

List of Objects

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

Comments

Model View

Table GOBBACR

Schema Name GENERAL
Label GOBBACR
Server name MALDEV8_B60
Creation Date 04/15/2002 18:04:26:000

Table Columns information

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

Foreign Key information

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

Index

Index Name	Index Type	Column Name
PK_GOBBACR	Unique	GOBBACR_SEQNO

Comments

Source Code Comments

Access Rule Base

Columns Comments for GOBBACR_SEQNO (1)

Source Code Comments

Access Rule Sequence Number

Columns Comments for GOBBACR_VOBJ_CODE (2)

Source Code Comments

VBS Object Code

Columns Comments for GOBBACR_ACTIVE_IND (3)

Source Code Comments

Access Rule Active Indicator

Columns Comments for GOBBACR_EFF_DATE (4)

Source Code Comments

Access Rule Effective Date

Columns Comments for GOBBACR_ACTIVITY_DATE (5)

Source Code Comments

Date of Insert or Last Update

Columns Comments for GOBBACR_PATTERN_CTRL (6)

Source Code Comments

Access Rule Secured Item Pattern Control

Columns Comments for GOBBACR_ACCESS_CNT (7)

Source Code Comments

Access Group Association Cummulative Count

Columns Comments for GOBBACR_EXPIRE_DATE (8)

Source Code Comments

Access Rule Expiration Date

Table GOBEACC

Schema Name GENERAL
Label GOBEACC
Server name MALDEV8_B60
Creation Date 04/15/2002 18:04:26:000

Table Columns information

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

Foreign Key information

No Foreign Key

Index

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

Comments

Source Code Comments

Enterprise Oracle Access Table

Columns Comments for GOBEACC_PIDM (1)

Source Code Comments

System generated unique PIDM associated with user.

Columns Comments for GOBEACC_USERNAME (2)

Source Code Comments

Oracle user ID.

Columns Comments for GOBEACC_USER_ID (3)

Source Code Comments

Current User, system updated.

Columns Comments for GOBEACC_ACTIVITY_DATE (4)

Source Code Comments

System date of insert or update.

Table GOBPCRL

Schema Name GENERAL
Label GOBPCRL
Server name MALDEV8_B60
Creation Date 04/15/2002 18:04:26:000

Table Columns information

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

Foreign Key information

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

Index

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

Comments

Source Code Comments

VBS Secured Item Pattern Control

Columns Comments for GOBPCRL_VOBJ_CODE (1)

Source Code Comments

VBS Object Code

Columns Comments for GOBPCRL_VAPP_CODE (2)

Source Code Comments

VBS Secured Item Code

Columns Comments for GOBPCRL_PATTERN_CTRL (3)

Source Code Comments

VBS Secured Item Pattern Control Seed Number

Columns Comments for GOBPCRL_ACTIVITY_DATE (4)

Source Code Comments

Date of Insert or Last Update

Columns Comments for GOBPCRL_TABLE_NAME (5)

Source Code Comments

Table to validate against

Table GOBSEGC

Schema Name GENERAL
Label GOBSEGC
Server name MALDEV8_B60
Creation Date 04/15/2002 18:04:26:000

Table Columns information

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

Foreign Key information

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

Index

Index Name	Index Type	Column Name
PK_GOBSEGC	Unique	GOBSEGC_SEGC_CODE

Comments

Source Code Comments

Access Group Base

Columns Comments for GOBSEGC_SEGC_CODE (1)

Source Code Comments

Access Group Code

Columns Comments for GOBSEGC_EFF_DATE (2)

Source Code Comments

Access Group Effective Date

Columns Comments for GOBSEGC_ACTIVE_IND (3)

Source Code Comments

Access Group Active Indicator

Columns Comments for GOBSEGC_ACTIVITY_DATE (4)

Source Code Comments

Date of Insert or Last Update

Table GOBVBSC

Schema Name GENERAL
Label GOBVBSC
Server name MALDEV8_B60
Creation Date 04/15/2002 18:04:27:000

Table Columns information

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

Foreign Key information

No Foreign Key

Index

No Result

Comments

Source Code Comments

VBS Application Control

Columns Comments for GOBVBSC_VBS_IND (1)

Source Code Comments

Indicates VBS is Active

Columns Comments for GOBVBSC_VBS_ON_DATE (2)

Source Code Comments

Date VBS State was Altered

Columns Comments for GOBVBSC_VBS_SUSPEND_IND (3)

Source Code Comments

Indicates VBS is Suspended

Columns Comments for GOBVBSC_VBS_SUSPEND_DATE (4)

Source Code Comments

Date VBS Suspension State was Altered

Columns Comments for GOBVBSC_USER_ID (5)

Source Code Comments

User ID Last Modifying VBS State

Columns Comments for GOBVBSC_ACTIVITY_DATE (6)

Source Code Comments

Date of Insert or Last Update

Table GOBVCRL

Schema Name GENERAL
Label GOBVCRL
Server name MALDEV8_B60
Creation Date 04/15/2002 18:04:27:000

Table Columns information

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

Foreign Key information

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

Index

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

Comments

Source Code Comments

VBS Access Rule Control

Columns Comments for GOBVCRL_USER_ID (1)

Source Code Comments

ORACLE User ID

Columns Comments for GOBVCRL_BACR_SEQNO (2)

Source Code Comments

Access Rule Sequence Number

Columns Comments for GOBVCRL_VAPP_CODE_MODULE (3)

Source Code Comments

Module

Columns Comments for GOBVCRL_ACCESS_CNT (4)

Source Code Comments

Access count

Table GOBVUSR

Schema Name GENERAL
Label GOBVUSR
Server name MALDEV8_B60
Creation Date 04/15/2002 18:04:27:000

Table Columns information

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

Foreign Key information

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

Index

Index Name	Index Type	Column Name
PK_GOBVUSR	Unique	GOBVUSR_USER_ID

Comments

Source Code Comments

VBS User Profile Base

Columns Comments for GOBVUSR_USER_ID (1)

Source Code Comments

ORACLE User ID

Columns Comments for GOBVUSR_ACTIVE_IND (2)

Source Code Comments

Indicates VBS User Profile is Active

Columns Comments for GOBVUSR_EFF_DATE (3)

Source Code Comments

Indicates Effective Date of VBS User Profile

Columns Comments for GOBVUSR_ADMIN_IND (4)

Source Code Comments

Indicates the VBS User to be an Access Group Administrator

Columns Comments for GOBVUSR_MGR_IND (5)

Source Code Comments

Indicates the VBS User to be an Access Group Manager

Columns Comments for GOBVUSR_ACTIVITY_DATE (6)

Source Code Comments

Date of Insert or Last Update

Columns Comments for GOBVUSR_EXPIRE_DATE (7)

Source Code Comments

Indicates Expiration Date of VBS USer Profile

Table GORGMGR

Schema Name GENERAL
Label GORGMGR
Server name MALDEV8_B60
Creation Date 04/15/2002 18:04:29:000

Table Columns information

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

Foreign Key information

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

Index

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

Comments

Source Code Comments

Access Group Management Control

Columns Comments for GORGMGR_SEGC_CODE (1)

Source Code Comments

Access Group Code

Columns Comments for GORGMGR_USER_ID (2)

Source Code Comments

ORACLE User ID

Columns Comments for GORGMGR_EFF_DATE (3)

Source Code Comments

Effective Date of VBS User

Columns Comments for GORGMGR_ACTIVITY_DATE (4)

Source Code Comments

Date of Insert or Last Update

Table GORGMSK

Schema Name GENERAL
Label GORGMSK
Server name MALDEV8_B60
Creation Date 04/15/2002 18:04:29:000

Table Columns information

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

Foreign Key information

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

Index

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

Comments

Source Code Comments

Access Group Rule Assignment Mask

Columns Comments for GORGMSK_SEGC_CODE (1)

Source Code Comments

Access Group Code

Columns Comments for GORGMSK_VOBJ_CODE (2)

Source Code Comments

VBS Object Code

Columns Comments for GORGMSK_VAPP_CODE (3)

Source Code Comments

VBS Secured Item Code

Columns Comments for GORGMSK_ACTIVITY_DATE (4)

Source Code Comments

Date of Insert or Last Update

Columns Comments for GORGMSK_VAPP_VALUE (5)

Source Code Comments

Secured Item Mask Value

Table GORGRUL

Schema Name GENERAL
Label GORGRUL
Server name MALDEV8_B60
Creation Date 04/15/2002 18:04:29:000

Table Columns information

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

Foreign Key information

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

Index

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

Comments

Source Code Comments

Access Group Rule Association

Columns Comments for GORGRUL_SEGC_CODE (1)

Source Code Comments

Access Group Code

Columns Comments for GORGRUL_BACR_SEQNO (2)

Source Code Comments

Access Rule Sequence Number

Columns Comments for GORGRUL_ADD_DATE (3)

Source Code Comments

Rule Association Add Date

Columns Comments for GORGRUL_ACTIVITY_DATE (4)

Source Code Comments

Date of Insert or Last Update

Table GORGUSR

Schema Name GENERAL
Label GORGUSR
Server name MALDEV8_B60
Creation Date 04/15/2002 18:04:29:000

Table Columns information

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

Foreign Key information

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

Index

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

Comments

Source Code Comments

Access Group User Association

Columns Comments for GORGUSR_SEGC_CODE (1)

Source Code Comments

Access Group Code

Columns Comments for GORGUSR_USER_ID (2)

Source Code Comments

ORACLE User ID

Columns Comments for GORGUSR_ACTIVITY_DATE (3)

Source Code Comments

Date of Insert or Last Update

Table GORRAVL

Schema Name GENERAL
Label GORRAVL
Server name MALDEV8_B60
Creation Date 04/15/2002 18:04:30:000

Table Columns information

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

Foreign Key information

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

Index

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

Comments

Source Code Comments

VBS Access Rule Secured Values

Columns Comments for GORRAVL_VOBJ_CODE (1)

Source Code Comments

VBS Object Code

Columns Comments for GORRAVL_BACR_SEQNO (2)

Source Code Comments

Access Rule Sequence Number

Columns Comments for GORRAVL_VAPP_CODE (3)

Source Code Comments

VBS Secured Item Code

Columns Comments for GORRAVL_PATTERN_CTRL (4)

Source Code Comments

VBS PAttern Control Seed Number

Columns Comments for GORRAVL_ACTIVITY_DATE (5)

Source Code Comments

Date of Insert or Last Update

Columns Comments for GORRAVL_VAPP_VALUE (6)

Source Code Comments

VBS Secured Item Value

Table GORTCRL

Schema Name GENERAL
Label GORTCRL
Server name MALDEV8_B60
Creation Date 04/15/2002 18:04:30:000

Table Columns information

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

Foreign Key information

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

Index

No Result

Comments

Source Code Comments

User ID table

Columns Comments for GORTCRL_USER_ID (1)

Source Code Comments

User ID

Columns Comments for GORTCRL_VAPP_CODE_MODULE (2)

Source Code Comments

VBS Secured Item Code Model

Columns Comments for GORTCRL_ACTIVITY_DATE (3)

Source Code Comments

Date of Insert or Last Update

Table GORVGAC

Schema Name GENERAL
Label GORVGAC
Server name MALDEV8_B60
Creation Date 04/15/2002 18:04:30:000

Table Columns information

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

Foreign Key information

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

Index

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

Comments

Source Code Comments

Access Group Rule Control

Columns Comments for GORVGAC_SEGC_CODE (1)

Source Code Comments

Access Group Code

Columns Comments for GORVGAC_VOBJ_CODE (2)

Source Code Comments

VBS Object Code

Columns Comments for GORVGAC_BACR_SEQNO (3)

Source Code Comments

Access Rule Sequence Number

Columns Comments for GORVGAC_VBS_ITEM1 (4)

Source Code Comments

Program Item Value

Columns Comments for GORVGAC_VBS_ITEM2 (5)

Source Code Comments

Campus Item Value

Columns Comments for GORVGAC_VBS_ITEM3 (6)

Source Code Comments

College Item Value

Columns Comments for GORVGAC_VBS_ITEM4 (7)

Source Code Comments

Level Item Value

Columns Comments for GORVGAC_VBS_ITEM5 (8)

Source Code Comments

Department Item Value

Table GORVMAC

Schema Name GENERAL
Label GORVMAC
Server name MALDEV8_B60
Creation Date 04/15/2002 18:04:30:000

Table Columns information

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

Foreign Key information

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

Index

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

Comments

Source Code Comments

VBS User Module Access Control

Columns Comments for GORVMAC_USER_ID (1)

Source Code Comments

ORACLE User ID

Columns Comments for GORVMAC_VAPP_CODE (2)

Source Code Comments

VBS Module Code

Columns Comments for GORVMAC_PATTERN_CTRL (3)

Source Code Comments

Module Access Pattern Control Seed Number

Table GORVMGA

Schema Name GENERAL
Label GORVMGA
Server name MALDEV8_B60
Creation Date 04/15/2002 18:04:30:000

Table Columns information

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

Foreign Key information

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

Index

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

Comments

Source Code Comments

VBS Person Secured Items

Columns Comments for GORVMGA_PIDM (1)

Source Code Comments

Persons PIDM Value

Columns Comments for GORVMGA_VAPP_CODE (2)

Source Code Comments

VBS Module Code

Columns Comments for GORVMGA_TERM_CODE (3)

Source Code Comments

Persons Term Code

Columns Comments for GORVMGA_SEQNO (4)

Source Code Comments

Curriculum Record Sequence Number

Columns Comments for GORVMGA_PROGRAM_1 (5)

Source Code Comments

Program 1 Code

Columns Comments for GORVMGA_CAMP_CODE_1 (6)

Source Code Comments

Campus 1 Code

Columns Comments for GORVMGA_COLL_CODE_1 (7)

Source Code Comments

College 1 Code

Columns Comments for GORVMGA_LEVL_CODE_1 (8)

Source Code Comments

Level 1 Code

Columns Comments for GORVMGA_DEPT_CODE_11 (9)

Source Code Comments

Department 1-1 Code

Columns Comments for GORVMGA_DEPT_CODE_12 (10)

Source Code Comments

Department 1-2 Code

Table GORVRAC

Schema Name GENERAL
Label GORVRAC
Server name MALDEV8_B60
Creation Date 04/15/2002 18:04:31:000

Table Columns information

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

Foreign Key information

Column name	is Foreign Key For Column	on Table
GORVRAC_VOBJ_CODE	GTVVOBJ_CODE	GTVVOBJ
GORVRAC_BACR_SEQNO	GOBBACR_SEQNO	GOBBACR
GORVRAC_VBS_ITEM1	SRBRECR_PROGRAM_1	SRBRECR
GORVRAC_VBS_ITEM2	SRBRECR_CAMP_CODE	SRBRECR
GORVRAC_VBS_ITEM3	SRBRECR_COLL_CODE	SRBRECR
GORVRAC_VBS_ITEM4	SRBRECR_LEVL_CODE	SRBRECR
GORVRAC_VBS_ITEM5	SRBRECR_DEPT_CODE	SRBRECR
GORVRAC_VBS_ITEM5	SRBRECR_DEPT_CODE_2	SRBRECR
GORVRAC_VBS_ITEM1	SARADAP_PROGRAM_1	SARADAP
GORVRAC_VBS_ITEM2	SARADAP_CAMP_CODE	SARADAP
GORVRAC_VBS_ITEM3	SARADAP_COLL_CODE_1	SARADAP
GORVRAC_VBS_ITEM4	SARADAP_LEVL_CODE	SARADAP
GORVRAC_VBS_ITEM5	SARADAP_DEPT_CODE	SARADAP
GORVRAC_VBS_ITEM5	SARADAP_DEPT_CODE_1_2	SARADAP
GORVRAC_VBS_ITEM1	SGBSTDN_PROGRAM_1	SGBSTDN
GORVRAC_VBS_ITEM2	SGBSTDN_CAMP_CODE	SGBSTDN
GORVRAC_VBS_ITEM3	SGBSTDN_COLL_CODE_1	SGBSTDN
GORVRAC_VBS_ITEM4	SGBSTDN_LEVL_CODE	SGBSTDN
GORVRAC_VBS_ITEM5	SGBSTDN_DEPT_CODE	SGBSTDN
GORVRAC_VBS_ITEM5	SGBSTDN_DEPT_CODE_1_2	SGBSTDN

Index

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

Comments

Source Code Comments

VBS User Access Rule Control

Columns Comments for GORVRAC_USER_ID (1)

Source Code Comments

ORACLE User ID

Columns Comments for GORVRAC_VOBJ_CODE (2)

Source Code Comments

VBS Object Code

Columns Comments for GORVRAC_BACR_SEQNO (3)

Source Code Comments

Access Rule Sequence Number

Columns Comments for GORVRAC_VAPP_CODE_MODULE (4)

Source Code Comments

VBS Module associated with User and Access Rule

Columns Comments for GORVRAC_ACTIVE_IND (5)

Source Code Comments

Indicates User is Active

Columns Comments for GORVRAC_EFF_DATE (6)

Source Code Comments

Effective Date of Access

Columns Comments for GORVRAC_ACTIVITY_DATE (7)

Source Code Comments

Date of Insert or Last Update

Columns Comments for GORVRAC_EXPIRE_DATE (8)

Source Code Comments

Expiration Date of Access

Columns Comments for GORVRAC_VBS_ITEM1 (9)

Source Code Comments

Program Value

Columns Comments for GORVRAC_VBS_ITEM2 (10)

Source Code Comments

Campus Value

Columns Comments for GORVRAC_VBS_ITEM3 (11)

Source Code Comments

College Value

Columns Comments for GORVRAC_VBS_ITEM4 (12)

Source Code Comments

Level Value

Columns Comments for GORVRAC_VBS_ITEM5 (13)

Source Code Comments

Department Value

Table GORVSVR

Schema Name GENERAL
Label GORVSVR
Server name MALDEV8_B60
Creation Date 04/15/2002 18:04:31:000

Table Columns information

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