GTVOBJT GTVSYSI GUBOBJS GURMENU GURTPRF GURUPRF GUVMMNU_PRODUCTS GUVPEMNU_PERSONAL GUVPSMNU_PROCESS

Model Menu, Object & Preference


Model Label : Banner General Object Maintenace, Menu / Preference Maintenance, and Main Menu
Path : BANNER DEV/General/ERD/Menu, Object & Preference

List of Objects

Object Name Object Type Layer Name
GTVOBJT TABLE Default
GTVSYSI TABLE Default
GUBOBJS TABLE Default
GURMENU TABLE Default
GURTPRF TABLE Default
GURUPRF TABLE Default
GUVMMNU_PRODUCTS VIEW Default
GUVPEMNU_PERSONAL VIEW Default
GUVPSMNU_PROCESS VIEW Default

Comments

Model View

''

Table GTVOBJT

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GTVOBJT_CODE GTVOBJT_CODE VARCHAR2(10) No *
GTVOBJT_DESC GTVOBJT_DESC VARCHAR2(80) No
GTVOBJT_ACTIVITY_DATE GTVOBJT_ACTIVITY_DATE DATE No

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_GTVOBJT Unique GTVOBJT_CODE

Comments

Source Code Comments

VBS Object Code Validation

Columns Comments for GTVOBJT_CODE (1)

Source Code Comments

This item identifies all valid object types within BANNER.

Columns Comments for GTVOBJT_DESC (2)

Source Code Comments

This item contains the description for the code.

Columns Comments for GTVOBJT_ACTIVITY_DATE (3)

Source Code Comments

This item contains the date when the item was created or last modified.

Table GTVSYSI

Schema Name GENERAL
Label GTVSYSI
Server name MALDEV8_B60
Creation Date 08/13/2002 15:20:19:000

Table Columns information

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

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_GTVSYSI Unique GTVSYSI_CODE

Comments

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 GUBOBJS

Schema Name GENERAL
Label GUBOBJS
Server name MALDEV8_B60
Creation Date 05/13/2003 10:03:52:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GUBOBJS_NAME GUBOBJS_NAME VARCHAR2(30) No * *
GUBOBJS_DESC GUBOBJS_DESC VARCHAR2(80) No
GUBOBJS_OBJT_CODE GUBOBJS_OBJT_CODE VARCHAR2(10) No *
GUBOBJS_SYSI_CODE GUBOBJS_SYSI_CODE VARCHAR2(2) No *
GUBOBJS_USER_ID GUBOBJS_USER_ID VARCHAR2(30) No
GUBOBJS_ACTIVITY_DATE GUBOBJS_ACTIVITY_DATE DATE No
GUBOBJS_HELP_IND GUBOBJS_HELP_IND VARCHAR2(1) No
GUBOBJS_EXTRACT_ENABLED_IND GUBOBJS_EXTRACT_ENABLED_IND VARCHAR2(1) No

Foreign Key information

Column name is Foreign Key For Column on Table
GUBOBJS_NAME GURMENU_OBJ_NAME GURMENU
GUBOBJS_SYSI_CODE GTVSYSI_CODE GTVSYSI
GUBOBJS_OBJT_CODE GTVOBJT_CODE GTVOBJT

Index

Index Name Index Type Column Name
GUBOBJS_OBJT_INDEX GUBOBJS_OBJT_CODE
PK_GUBOBJS Unique GUBOBJS_NAME

Comments

Source Code Comments

General Object Base Table

Columns Comments for GUBOBJS_NAME (1)

Source Code Comments

This item contains the name of the object.

Columns Comments for GUBOBJS_DESC (2)

Source Code Comments

This item contains the description of the object.

Columns Comments for GUBOBJS_OBJT_CODE (3)

Source Code Comments

This item contains the object type code.

Columns Comments for GUBOBJS_SYSI_CODE (4)

Source Code Comments

This item contains the value which identifies the Banner System to which this object belongs.

Columns Comments for GUBOBJS_USER_ID (5)

Source Code Comments

This item contains the name of the user who owns the object.

Columns Comments for GUBOBJS_ACTIVITY_DATE (6)

Source Code Comments

This item contains the date of creation or update.

Columns Comments for GUBOBJS_HELP_IND (7)

Source Code Comments

Indicator column to identify which objects have new help files.

Columns Comments for GUBOBJS_EXTRACT_ENABLED_IND (8)

Source Code Comments

This column indicates whether the data displayed on the form can be extracted into a csv (Comma Separated Value) file. Values are: D - data block only, B - Both key block and data block, N - not available.

Table GURMENU

Schema Name GENERAL
Label GURMENU
Server name MALDEV8_B60
Creation Date 05/14/2003 14:56:52:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GURMENU_NAME GURMENU_NAME VARCHAR2(30) No *
GURMENU_OBJ_NAME GURMENU_OBJ_NAME VARCHAR2(30) No *
GURMENU_SORT_SEQ GURMENU_SORT_SEQ NUMBER(0,0) No *
GURMENU_USER_ID GURMENU_USER_ID VARCHAR2(30) No *
GURMENU_ACTIVITY_DATE GURMENU_ACTIVITY_DATE DATE No
GURMENU_DESC GURMENU_DESC VARCHAR2(80) Yes

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
GURMENU_KEY_INDEX2 GURMENU_NAME
GURMENU_KEY_INDEX2 GURMENU_OBJ_NAME
GURMENU_OBJ_INDEX GURMENU_OBJ_NAME
GURMENU_OBJ_INDEX GURMENU_USER_ID
PK_GURMENU Unique GURMENU_NAME
PK_GURMENU Unique GURMENU_OBJ_NAME
PK_GURMENU Unique GURMENU_USER_ID
PK_GURMENU Unique GURMENU_SORT_SEQ

Comments

Source Code Comments

General Menu Repeating Table

Columns Comments for GURMENU_NAME (1)

Source Code Comments

This item contains the name of the menu.

Columns Comments for GURMENU_OBJ_NAME (2)

Source Code Comments

This item contains the name of the object on the menu.

Columns Comments for GURMENU_SORT_SEQ (3)

Source Code Comments

This item contains the sort sequence number for the menu.

Columns Comments for GURMENU_USER_ID (4)

Source Code Comments

This item contains the name of the user who owns the menu entry.

Columns Comments for GURMENU_ACTIVITY_DATE (5)

Source Code Comments

This item contains the date of creation or last update.

Columns Comments for GURMENU_DESC (6)

Source Code Comments

This item contains the description of a user specific menu.

Table GURTPRF

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GURTPRF_USER_ID GURTPRF_USER_ID VARCHAR2(30) No
GURTPRF_TLB_BTN GURTPRF_TLB_BTN LONG Yes
GURTPRF_DISP_HT_CB GURTPRF_DISP_HT_CB VARCHAR2(1) Yes
GURTPRF_DISP_VT_CB GURTPRF_DISP_VT_CB VARCHAR2(1) Yes
GURTPRF_DISP_HINT GURTPRF_DISP_HINT VARCHAR2(1) Yes
GURTPRF_FORMNAME_CB GURTPRF_FORMNAME_CB VARCHAR2(1) Yes
GURTPRF_RELEASE_CB GURTPRF_RELEASE_CB VARCHAR2(1) Yes
GURTPRF_DBASE_INST_CB GURTPRF_DBASE_INST_CB VARCHAR2(1) Yes
GURTPRF_DATE_TIME_CB GURTPRF_DATE_TIME_CB VARCHAR2(1) Yes
GURTPRF_REQ_ITEM_CB GURTPRF_REQ_ITEM_CB VARCHAR2(1) Yes
GURTPRF_LINESCRN_X_POS GURTPRF_LINESCRN_X_POS NUMBER(4,0) Yes
GURTPRF_LINEBTN_X_POS GURTPRF_LINEBTN_X_POS NUMBER(4,0) Yes
GURTPRF_FORMNAME_DISPLAY_IND GURTPRF_FORMNAME_DISPLAY_IND VARCHAR2(1) Yes

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
GURTPRF_KEY_INDEX Unique GURTPRF_USER_ID

Comments

Source Code Comments

PREFERENCE TABLE THAT STORES TOOLBAR AND MENU INFOG

Columns Comments for GURTPRF_USER_ID (1)

Source Code Comments

User ID:The last user to update the record

Columns Comments for GURTPRF_TLB_BTN (2)

Source Code Comments

Tool bar button properties

Columns Comments for GURTPRF_DISP_HT_CB (3)

Source Code Comments

Display Horizontal toolbar on MDI window

Columns Comments for GURTPRF_DISP_VT_CB (4)

Source Code Comments

Display Vertical tool bar on MDI window

Columns Comments for GURTPRF_DISP_HINT (5)

Source Code Comments

Display hint on buttons

Columns Comments for GURTPRF_FORMNAME_CB (6)

Source Code Comments

Display Form name on window ba

Columns Comments for GURTPRF_RELEASE_CB (7)

Source Code Comments

Display release number on window bar

Columns Comments for GURTPRF_DBASE_INST_CB (8)

Source Code Comments

Display database instance on window bar

Columns Comments for GURTPRF_DATE_TIME_CB (9)

Source Code Comments

Display date and time on window bar

Columns Comments for GURTPRF_REQ_ITEM_CB (10)

Source Code Comments

Display required items with different color attribute

Columns Comments for GURTPRF_LINESCRN_X_POS (11)

Source Code Comments

Keep position of resizeable canvas in main menu form GUAGMNU

Columns Comments for GURTPRF_LINEBTN_X_POS (12)

Source Code Comments

Keep position of resizeable buttons in main menu form GUAGMNU

Columns Comments for GURTPRF_FORMNAME_DISPLAY_IND (13)

Source Code Comments

This indicator column determines whether the name of a form to be called is displayed in the M=Options Menu, F=Navigation Frame, B=both, N=neither.

Table GURUPRF

Schema Name GENERAL
Label GURUPRF
Server name MALDEV8_B60
Creation Date 02/03/2003 16:43:21:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GURUPRF_USER_ID GURUPRF_USER_ID VARCHAR2(30) No *
GURUPRF_GROUP GURUPRF_GROUP VARCHAR2(30) No *
GURUPRF_KEY GURUPRF_KEY VARCHAR2(30) No *
GURUPRF_STRING GURUPRF_STRING VARCHAR2(30) No *
GURUPRF_VALUE GURUPRF_VALUE VARCHAR2(200) Yes
GURUPRF_SYSTEM_REQ_IND GURUPRF_SYSTEM_REQ_IND VARCHAR2(1) Yes
GURUPRF_ACTIVITY_DATE GURUPRF_ACTIVITY_DATE DATE No

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_GURUPRF Unique GURUPRF_USER_ID
PK_GURUPRF Unique GURUPRF_GROUP
PK_GURUPRF Unique GURUPRF_KEY
PK_GURUPRF Unique GURUPRF_STRING

Comments

Source Code Comments

Personal Preference Table

Columns Comments for GURUPRF_USER_ID (1)

Source Code Comments

UserID

Columns Comments for GURUPRF_GROUP (2)

Source Code Comments

Group

Columns Comments for GURUPRF_KEY (3)

Source Code Comments

Key

Columns Comments for GURUPRF_STRING (4)

Source Code Comments

String

Columns Comments for GURUPRF_VALUE (5)

Source Code Comments

Value

Columns Comments for GURUPRF_SYSTEM_REQ_IND (6)

Source Code Comments

System Required Indicator

Columns Comments for GURUPRF_ACTIVITY_DATE (7)

Source Code Comments

Activity Date of the last change

View GUVMMNU_PRODUCTS

Schema Name BANINST1
Server Name MALDEV8_B60
Label GUVMMNU_PRODUCTS
Creation Date 02/27/2003 19:00:03:000

View Columns information

Column Name Label Column Type Allow NULL PK FK
GUVMMNU_STATE GUVMMNU_STATE NUMBER(0,0) Yes
GUVMMNU_LEVEL GUVMMNU_LEVEL NUMBER(0,0) Yes
GUVMMNU_LABEL GUVMMNU_LABEL VARCHAR2(80) Yes
GUVMMNU_ICON GUVMMNU_ICON CHAR(0) Yes
GUVMMNU_VALUE GUVMMNU_VALUE VARCHAR2(30) No

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
RG_GUVMMNU_PRODUCTS Forms Record Group FORMS_BANNER.GUAGMNU Use(select )
RG_GUVMMNU_PRODUCTS_LABEL Forms Record Group FORMS_BANNER.GUAGMNU Use(select )
GUVMMNU_PRODUCTS SYNONYM N/A Rely on ()

Calling objects (escalated)

Object Name Object Type Parent Name Link Type
GUAGMNU Forms Module N/A Escalated

Comments

View GUVPEMNU_PERSONAL

Schema Name BANINST1
Server Name MALDEV8_B60
Label GUVPEMNU_PERSONAL
Creation Date 04/14/2003 17:33:12:000

View Columns information

Column Name Label Column Type Allow NULL PK FK
GUVPEMNU_STATE GUVPEMNU_STATE NUMBER(0,0) Yes
GUVPEMNU_LEVEL GUVPEMNU_LEVEL NUMBER(0,0) Yes
GUVPEMNU_LABEL GUVPEMNU_LABEL VARCHAR2(80) Yes
GUVPEMNU_ICON GUVPEMNU_ICON VARCHAR2(30) No
GUVPEMNU_VALUE GUVPEMNU_VALUE VARCHAR2(30) No

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
GUVPEMNU_PERSONAL SYNONYM N/A Rely on ()

Comments

View GUVPSMNU_PROCESS

Schema Name BANINST1
Server Name MALDEV8_B60
Label GUVPSMNU_PROCESS
Creation Date 02/27/2003 19:00:03:000

View Columns information

Column Name Label Column Type Allow NULL PK FK
GUVPSMNU_STATE GUVPSMNU_STATE NUMBER(0,0) Yes
GUVPSMNU_LEVEL GUVPSMNU_LEVEL NUMBER(0,0) Yes
GUVPSMNU_LABEL GUVPSMNU_LABEL VARCHAR2(80) Yes
GUVPSMNU_ICON GUVPSMNU_ICON CHAR(0) Yes
GUVPSMNU_VALUE GUVPSMNU_VALUE VARCHAR2(30) No

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
GUVPSMNU_PROCESS SYNONYM N/A Rely on ()

Comments

Link between GUBOBJS and GURMENU

Caller : GUBOBJS
Called : GURMENU

Join Information

Objects list
schema-view : MALDEV8_B60.BANINST1.GUVMENU_PRODUCTS
schema-view : MALDEV8_B60.BANINST1.GUVMENU
schema-view : MALDEV8_B60.BANINST1.GUVMENU_PRODUCTS_LABEL
schema-view : MALDEV8_B60.BANINST1.GUVMENU_PERSONAL_LABEL
schema-view : MALDEV8_B60.BANINST1.GUVMENU_PERSONAL

Link List

Link Type Link Project
Join Link Between GUBOBJS and GURMENU GENERAL

Link Between GUBOBJS and GURMENU

Caller : GUBOBJS
Called : GURMENU
Link Type : Join
Link : Link Between GUBOBJS and GURMENU

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
GUBOBJS GUBOBJS_NAME GURMENU_OBJ_NAME GURMENU (0,1)-(0,1)

Comments

Link between GUBOBJS and GTVOBJT

Caller : GUBOBJS
Called : GTVOBJT

Link List

Link Type Link Project
Refer(No Action ) Link Foreign Key Between GUBOBJS and GTVOBJT GENERAL

Link Foreign Key Between GUBOBJS and GTVOBJT

Caller : GUBOBJS
Called : GTVOBJT
Link Type : Refer(No Action )
Link : Link Foreign Key Between GUBOBJS and GTVOBJT

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
GUBOBJS GUBOBJS_OBJT_CODE GTVOBJT_CODE GTVOBJT (1,1)-(0,n)

Comments

Link between GUBOBJS and GTVSYSI

Caller : GUBOBJS
Called : GTVSYSI

Link List

Link Type Link Project
Refer(No Action ) Link Foreign Key Between GUBOBJS and GTVSYSI GENERAL

Link Foreign Key Between GUBOBJS and GTVSYSI

Caller : GUBOBJS
Called : GTVSYSI
Link Type : Refer(No Action )
Link : Link Foreign Key Between GUBOBJS and GTVSYSI

Foreign Key information

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

Comments