GTVOBJT GTVSYSI GUBOBJS GURMENU GURTPRF GURUPRF GUVPSMNU_PROCESS

Model Menu_Preference_Maintenance


Model Label :

List of Objects

Object Name Object Type Layer Name
GTVOBJT SQL Table Default
GTVSYSI SQL Table Default
GUBOBJS SQL Table Default
GURMENU SQL Table Default
GURTPRF SQL Table Default
GURUPRF SQL Table Default
GUVPSMNU_PROCESS SQL View Default

Model View

Table GTVOBJT

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

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

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_GTVOBJT Unique GTVOBJT_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
GUBOBJS SQL Table S10B80.GENERAL Refer (no action)
GTVOBJTC Oracle Package Cursor S10B80.BANINST1.GTKOBJT Use (select)Rely On
GTVOBJT_C Oracle Package Cursor S10B80.BANINST1.GB_GTVOBJT Rely On
GTVOBJT_C Oracle Package Cursor S10B80.BANINST1.GB_GTVOBJT Use (select)Rely On
F_CODE_EXISTS Oracle Package Function S10B80.BANINST1.GB_GTVOBJT Rely On
F_GET_DESCRIPTION Oracle Package Function S10B80.BANINST1.GB_GTVOBJT Rely On
GTVOBJT 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_GTVOBJT SQL Index S10B80.GENERAL Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GTVOBJT

Object Dates

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

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

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
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 GUBOBJS

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

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

Foreign Key information

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

Index

Index Name Index Type Column Name
GUBOBJS_OBJT_INDEX   GUBOBJS_OBJT_CODE
PK_GUBOBJS Unique GUBOBJS_NAME

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
GURHMNU SQL Table S10B80.GENERAL Join
GURMENU SQL Table S10B80.GENERAL Join
GUBOBJS_C Oracle Package Cursor S10B80.BANINST1.GB_GUBOBJS Rely On
GUBOBJS_C Oracle Package Cursor S10B80.BANINST1.GB_GUBOBJS Use (select)Rely On
P_BLD_PERS_MENU Oracle Package Procedure S10B80.BANINST1.GUKMENU Use (select)
P_BLD_PROD_MENU Oracle Package Procedure S10B80.BANINST1.GUKMENU Use (select)
P_DELETE Oracle Package Procedure S10B80.BANINST1.DML_GUBOBJS Use (delete)
P_INSERT Oracle Package Procedure S10B80.BANINST1.DML_GUBOBJS Use (Insert)Rely On
P_REFRESH_MENU Oracle Package Procedure S10B80.BANINST1.GUKMENU Use (select)
P_UPDATE Oracle Package Procedure S10B80.BANINST1.DML_GUBOBJS Rely On
P_VALIDATE Oracle Package Procedure S10B80.BANINST1.GB_DISPLAYCOLUMNS_RULES Use (select)
P_VALIDATE Oracle Package Procedure S10B80.BANINST1.GB_CM_DISPLAY_OPTIONS_RULES Use (select)
P_VALIDATE Oracle Package Procedure S10B80.BANINST1.GB_DISPLAYMASK_RULES Use (select)
P_VALIDATE Oracle Package Procedure S10B80.BANINST1.GB_FGACEXCLUDEDOBJECTS_RULES Use (select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_GB_FGACEXCLUDEDOBJECTS Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_GB_DISPLAYMASK Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_GB_DISPLAYCOLUMNS Use (Insert,select)
F_CODE_EXISTS Oracle Package Function S10B80.BANINST1.GB_GUBOBJS Rely On
F_GET_DESCRIPTION Oracle Package Function S10B80.BANINST1.GB_GUBOBJS Rely On
F_PERS_BANNER Oracle Package Function S10B80.BANINST1.BWGCXCHN Rely On
F_PERS_BANNER Oracle Package Function S10B80.BANINST1.BWGCXCHN Use (select)
GUBOBJS 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
GUBOBJS_OBJT_INDEX SQL Index S10B80.GENERAL Rely On
PK_GUBOBJS SQL Index S10B80.GENERAL Rely On
GTVOBJT SQL Table S10B80.GENERAL Refer (no action)
GTVSYSI SQL Table S10B80.GENERAL Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GUBOBJS

Object Dates

Creation Date Analysis Date
04/02/2008 20:33:15:000 04/02/2008 21:17:57:000

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

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

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

Foreign Key information

Column name is Foreign Key For Column on Table
GURMENU_OBJ_NAME GUBOBJS_NAME GUBOBJS

Index

Index Name Index Type Column 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

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
GUVPSMNU_PROCESS SQL View S10B80.BANINST1 Use (select)
P_BLD_PERS_MENU Oracle Package Procedure S10B80.BANINST1.GUKMENU Rely On
P_BLD_PERS_MENU Oracle Package Procedure S10B80.BANINST1.GUKMENU Use (select)
P_REFRESH_MENU Oracle Package Procedure S10B80.BANINST1.GUKMENU Use (select)
GURMENU 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
GURMENU_OBJ_INDEX SQL Index S10B80.GENERAL Rely On
PK_GURMENU SQL Index S10B80.GENERAL Rely On
GUBOBJS SQL Table S10B80.GENERAL Join
GT_GURMENU_DEL_AUDIT SQL Trigger S10B80.GENERAL Fire (delete,before,each row)
GT_GURMENU_INS_AUDIT SQL Trigger S10B80.GENERAL Fire (Insert,before,each row)
GT_GURMENU_UPD_AUDIT SQL Trigger S10B80.GENERAL Fire (update,before,each row)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GURMENU

Object Dates

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

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

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GURTPRF_USER_ID   VARCHAR2(30) No    
GURTPRF_TLB_BTN   LONG Yes    
GURTPRF_DISP_HT_CB   VARCHAR2(1) Yes    
GURTPRF_DISP_VT_CB   VARCHAR2(1) Yes    
GURTPRF_DISP_HINT   VARCHAR2(1) Yes    
GURTPRF_FORMNAME_CB   VARCHAR2(1) Yes    
GURTPRF_RELEASE_CB   VARCHAR2(1) Yes    
GURTPRF_DBASE_INST_CB   VARCHAR2(1) Yes    
GURTPRF_DATE_TIME_CB   VARCHAR2(1) Yes    
GURTPRF_REQ_ITEM_CB   VARCHAR2(1) Yes    
GURTPRF_LINESCRN_X_POS   NUMBER(4,0) Yes    
GURTPRF_LINEBTN_X_POS   NUMBER(4,0) Yes    
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

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_GB_CM_USER_SETUP Use (Insert)
GURTPRF 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
GURTPRF_KEY_INDEX SQL Index S10B80.GENERAL Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GURTPRF

Object Dates

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

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

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GURUPRF_USER_ID   VARCHAR2(30) No *  
GURUPRF_GROUP   VARCHAR2(30) No *  
GURUPRF_KEY   VARCHAR2(30) No *  
GURUPRF_STRING   VARCHAR2(30) No *  
GURUPRF_VALUE   VARCHAR2(200) Yes    
GURUPRF_SYSTEM_REQ_IND   VARCHAR2(1) Yes    
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

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
F_GET_UPREF Oracle Package Function S10B80.BANINST1.GOKSSSO Use (select)
ADD_DEFAULTS Oracle Package Procedure S10B80.BANINST1.GENUTIL Use (Insert,select)
P_DISPLAY_PO Oracle Package Procedure S10B80.BANINST1.BWFKEAPI Use (select)
P_DISPLAY_REQ Oracle Package Procedure S10B80.BANINST1.BWFKEAPI Use (select)
F_GET_REPORTS_XML Oracle Package Function S10B80.BANINST1.BWGCXCHN Rely On
GURUPRF 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_GURUPRF SQL Index S10B80.GENERAL Rely On
GT_GURUPRF_PRE_UPDATE_ROW SQL Trigger S10B80.GENERAL Fire (update,before,each row)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GURUPRF

Object Dates

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

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 GUVPSMNU_PROCESS

Server Name S10B80
Database Name BANINST1
View Label

View Columns information

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

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
GURMENU SQL Table S10B80.GENERAL Use (select)
NUMBER Oracle Package Type S10B80.SYS.STANDARD Rely On
VARCHAR2 Oracle Package Type S10B80.SYS.STANDARD Rely On
GURMENU Oracle Synonym S10B80.PUBLIC Use (select)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.BANINST1.GUVPSMNU_PROCESS

Object Dates

Creation Date Analysis Date
04/04/2008 21:07:10:000 04/04/2008 21:57:37:000

Number of code lines

14

Number of heading comment lines

0

Number of inner comment lines

0

Link between GUVPSMNU_PROCESS and GURMENU


Link List

Link Type Link Project
Use (select) Link Between GUVPSMNU_PROCESS and GURMENU BANINST1

List of Real links

Link type Between And
Use (select) GUVPSMNU_PROCESS GURMENU

Link between GURMENU and GUBOBJS


Join Information

Objects list
scope-procedure : S10B80.BANINST1.GUKMENU.P_BLD_PERS_MENU
scope-procedure : S10B80.BANINST1.GUKMENU.P_REFRESH_MENU

Link List

Link Type Link Project
Join Link Between GURMENU and GUBOBJS GENERAL

List of Real links

Link type Between And
Join GURMENU GUBOBJS

Link between GUBOBJS and GTVOBJT


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between GUBOBJS and GTVOBJT (FK1_GUBOBJS_INV_GTVOBJT_CODE) GENERAL

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)

Link between GUBOBJS and GTVSYSI


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between GUBOBJS and GTVSYSI (FK1_GUBOBJS_INV_GTVSYSI_CODE) GENERAL

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)