Model QuickFlow_Process

Model Label :

List of Objects

Object Name	Object Type	Layer Name
GOBWFDD	SQL Table	Default
GORWFDD	SQL Table	Default
GORWFMP	SQL Table	Default
GTVCALL	SQL Table	Default
GTVOBJT	SQL Table	Default
GTVSYSI	SQL Table	Default
GUBOBJS	SQL Table	Default
GURCALL	SQL Table	Default
GURMENU	SQL Table	Default

Model View

Table GOBWFDD

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GOBWFDD_ID	NUMBER(8,0)	No	*
GOBWFDD_PRODUCT_TYPE	VARCHAR2(20)	No
GOBWFDD_APPL_NAME	VARCHAR2(20)	No
GOBWFDD_USER_ID	VARCHAR2(30)	No
GOBWFDD_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GOBWFDD	Unique	GOBWFDD_ID

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GORWFDD	SQL Table	S10B80.GENERAL	Refer (delete,cascade)
GORWFMP	SQL Table	S10B80.GENERAL	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_GOBWFDD	SQL Index	S10B80.GENERAL	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GOBWFDD

Object Dates

Creation Date	Analysis Date
04/02/2008 20:30:01:000	04/02/2008 21:17:53:000

Source Code Comments

Workflow Electronic Documents Dictionary Base table

Columns Comments for GOBWFDD_ID (# 1)

Source Code Comments

ID: Application Id

Columns Comments for GOBWFDD_PRODUCT_TYPE (# 2)

Source Code Comments

PRODUCT TYPE: Banner available Product Types

Columns Comments for GOBWFDD_APPL_NAME (# 3)

Source Code Comments

APPLICATION NAME: Banner Application Name (Oracle Forms Name)

Table GORWFDD

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GORWFDD_ID	NUMBER(8,0)	No	*	*
GORWFDD_ELEMENT_NAME	VARCHAR2(100)	No	*
GORWFDD_ELEMENT_TYPE	VARCHAR2(20)	No
GORWFDD_ELEMENT_DTYPE	VARCHAR2(20)	No
GORWFDD_LENGTH	NUMBER(6,0)	No
GORWFDD_REQUIRED_IND	VARCHAR2(1)	No
GORWFDD_MULTI_LINE_IND	VARCHAR2(1)	No
GORWFDD_USER_ID	VARCHAR2(30)	No
GORWFDD_ACTIVITY_DATE	DATE	No
GORWFDD_DATABASE_ELEMENT	VARCHAR2(61)	Yes
GORWFDD_ELEMENT_HINT	VARCHAR2(2000)	Yes
GORWFDD_LOW_RANGE	VARCHAR2(60)	Yes
GORWFDD_HIGH_RANGE	VARCHAR2(60)	Yes
GORWFDD_FORMAT_MASK	VARCHAR2(30)	Yes
GORWFDD_CASE	VARCHAR2(9)	Yes
GORWFDD_ALIGNMENT	VARCHAR2(6)	Yes
GORWFDD_LIST_APPL_NAME	VARCHAR2(10)	Yes
GORWFDD_LIST_TABLE_NAME	VARCHAR2(30)	Yes
GORWFDD_LIST_COLUMN_NAME	VARCHAR2(30)	Yes
GORWFDD_LIST_DESC_COLUMN_NAME	VARCHAR2(30)	Yes
GORWFDD_LIST_WHERE_CLAUSE	VARCHAR2(2000)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GORWFDD_ID	GOBWFDD_ID	GOBWFDD

Index

Index Name	Index Type	Column Name
PK_GORWFDD	Unique	GORWFDD_ID
PK_GORWFDD	Unique	GORWFDD_ELEMENT_NAME

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GORWFDD_ADS	SQL View	S10B80.BANINST1	Use (select)
GORWFDD_SUB	SQL View	S10B80.BANINST1	Use (select)
GORWFDD	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_GORWFDD	SQL Index	S10B80.GENERAL	Rely On
GOBWFDD	SQL Table	S10B80.GENERAL	Refer (delete,cascade)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GORWFDD

Object Dates

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

Source Code Comments

Workflow Electronic Documents Dictionary Repeating Table

Columns Comments for GORWFDD_ID (# 1)

Source Code Comments

ID: Banner Application Id

Columns Comments for GORWFDD_ELEMENT_NAME (# 2)

Source Code Comments

ELEMENT NAME: Banner Element Name. For Oracle Forms Product Type an element name is <Block_Name.Field_Name> construct.

Columns Comments for GORWFDD_ELEMENT_TYPE (# 3)

Source Code Comments

ELEMENT TYPE: Type of the element in the Application: Text Item, Check Box, Pull-Down List

Columns Comments for GORWFDD_ELEMENT_DTYPE (# 4)

Source Code Comments

DATATYPE: Datatype of the field, valid values are: C -Char, N - Number, D - Date

Columns Comments for GORWFDD_LENGTH (# 5)

Source Code Comments

LENGTH: Length of the field

Columns Comments for GORWFDD_REQUIRED_IND (# 6)

Source Code Comments

REQUIRED INDICATOR: Required Indicator for the field.This field defines if data must be entered in the field

Columns Comments for GORWFDD_MULTI_LINE_IND (# 7)

Source Code Comments

MULTI LINE INDICATOR: This field defines if data can be presented in multirecord format in the Application

Columns Comments for GORWFDD_DATABASE_ELEMENT (# 10)

Source Code Comments

DATABASE ELEMENT: This field defines the Database target in a form of <Table_Name.Column_Name>

Columns Comments for GORWFDD_ELEMENT_HINT (# 11)

Source Code Comments

HINT: Banner Defined Hint Text for fields

Columns Comments for GORWFDD_LOW_RANGE (# 12)

Source Code Comments

LOW RANGE: Field minimum value

Columns Comments for GORWFDD_HIGH_RANGE (# 13)

Source Code Comments

HIGH RANGE: Field maximum value

Columns Comments for GORWFDD_FORMAT_MASK (# 14)

Source Code Comments

FORMAT MASK: Field Display Format

Columns Comments for GORWFDD_CASE (# 15)

Source Code Comments

CASE: Field Case, valid values are U - Upper, L - Lower, M - Mixed

Columns Comments for GORWFDD_ALIGNMENT (# 16)

Source Code Comments

ALIGNMENT: Field Alignment; valid values are : L -Left, R - Right, C - Centered

Columns Comments for GORWFDD_LIST_APPL_NAME (# 17)

Source Code Comments

LIST: Validation Banner Form Name for the field

Columns Comments for GORWFDD_LIST_TABLE_NAME (# 18)

Source Code Comments

TABLE NAME: Table Name for Code/Desc functionality

Columns Comments for GORWFDD_LIST_COLUMN_NAME (# 19)

Source Code Comments

COLUMN NAME: Code Column Name for Code/Desc functionality

Columns Comments for GORWFDD_LIST_DESC_COLUMN_NAME (# 20)

Source Code Comments

DESCRIPTION COLUMN NAME: Description Column Name for Code/Desc functionality

Columns Comments for GORWFDD_LIST_WHERE_CLAUSE (# 21)

Source Code Comments

WHERE CLAUSE: Where Clause for Code/Desc Functionality

Table GORWFMP

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GORWFMP_WFED_CODE	VARCHAR2(20)	No	*	*
GORWFMP_PAGE	NUMBER(2,0)	No	*
GORWFMP_X_VALUE	VARCHAR2(2)	No	*
GORWFMP_Y_VALUE	NUMBER(2,0)	No	*
GORWFMP_CELL_TYPE	VARCHAR2(20)	No
GORWFMP_REQUIRED_IND	VARCHAR2(1)	No
GORWFMP_DEFAULT_OVERRIDE_IND	VARCHAR2(1)	No
GORWFMP_USER_ID	VARCHAR2(30)	No
GORWFMP_ACTIVITY_DATE	DATE	No
GORWFMP_APPL_ID	NUMBER(8,0)	Yes		*
GORWFMP_APPL_TARGET_NAME	VARCHAR2(100)	Yes
GORWFMP_DATABASE_TARGET_NAME	VARCHAR2(100)	Yes
GORWFMP_DEFAULT	VARCHAR2(60)	Yes
GORWFMP_LOW_RANGE	VARCHAR2(30)	Yes
GORWFMP_HIGH_RANGE	VARCHAR2(30)	Yes
GORWFMP_LIST	VARCHAR2(20)	Yes
GORWFMP_EVENT_TYPE	VARCHAR2(20)	Yes
GORWFMP_CELL_DTYPE	VARCHAR2(9)	Yes
GORWFMP_LENGTH	NUMBER(3,0)	Yes
GORWFMP_ENTER_HINT	VARCHAR2(2000)	Yes
GORWFMP_APPLY_HINT	VARCHAR2(2000)	Yes
GORWFMP_CASE	VARCHAR2(1)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GORWFMP_APPL_ID	GOBWFDD_ID	GOBWFDD
GORWFMP_WFED_CODE	GTVWFED_CODE	GTVWFED

Index

Index Name	Index Type	Column Name
PK_GORWFMP	Unique	GORWFMP_WFED_CODE
PK_GORWFMP	Unique	GORWFMP_PAGE
PK_GORWFMP	Unique	GORWFMP_X_VALUE
PK_GORWFMP	Unique	GORWFMP_Y_VALUE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
F_GET_DEFAULT_VALUE	Oracle Package Function	S10B80.BANINST1.GOKWFED	Rely On
F_GET_DEFAULT_VALUE	Oracle Package Function	S10B80.BANINST1.GOKWFED	Use (select)
GORWFMP	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_GORWFMP	SQL Index	S10B80.GENERAL	Rely On
GOBWFDD	SQL Table	S10B80.GENERAL	Refer (no action)
GTVWFED	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GORWFMP

Object Dates

Creation Date	Analysis Date
04/02/2008 20:33:51:000	04/02/2008 21:17:58:000

Source Code Comments

Electronic Documents Mapping Table

Columns Comments for GORWFMP_WFED_CODE (# 1)

Source Code Comments

ELECTRONIC DOCUMENT: Workflow Electronic Document Type Code

Columns Comments for GORWFMP_PAGE (# 2)

Source Code Comments

PAGE: Page number for the mapping

Columns Comments for GORWFMP_X_VALUE (# 3)

Source Code Comments

X_VALUE: X coordinate of the cell for mapping

Columns Comments for GORWFMP_Y_VALUE (# 4)

Source Code Comments

Y_VALUE: Y coordinate of the cell for mapping

Columns Comments for GORWFMP_CELL_TYPE (# 5)

Source Code Comments

CELL TYPE: Valid values are: T - Text Item, D - Display Item, L - Label

Columns Comments for GORWFMP_REQUIRED_IND (# 6)

Source Code Comments

REQUIRED INDICATOR: Required Indicator for the Cell

Columns Comments for GORWFMP_DEFAULT_OVERRIDE_IND (# 7)

Source Code Comments

DEFAULT OVERRIDE INDICATOR: This field defines if the Default Value for the cell may be overriden

Columns Comments for GORWFMP_APPL_ID (# 10)

Source Code Comments

APPLICATION ID: Banner Application Id

Columns Comments for GORWFMP_APPL_TARGET_NAME (# 11)

Source Code Comments

APPLICATION TARGET NAME: Banner Element Name. For Oracle Forms Product Type an element name is <Block_Name.Field_Name> construct.

Columns Comments for GORWFMP_DATABASE_TARGET_NAME (# 12)

Source Code Comments

DATABASE TARGET NAME: This field defines the Database target in a form of <Table_Name.Column_Name>

Columns Comments for GORWFMP_DEFAULT (# 13)

Source Code Comments

DEFAULT: Default Value for the cell

Columns Comments for GORWFMP_LOW_RANGE (# 14)

Source Code Comments

LOW RANGE: Field minimum value

Columns Comments for GORWFMP_HIGH_RANGE (# 15)

Source Code Comments

HIGH RANGE: Field maximum value

Columns Comments for GORWFMP_LIST (# 16)

Source Code Comments

LIST: Validation Banner Form Name for the field

Columns Comments for GORWFMP_EVENT_TYPE (# 17)

Source Code Comments

EVENT TYPE: Event Type for the cell: Valid Values are : V - Validation, C - Calculation, S - Security

Columns Comments for GORWFMP_CELL_DTYPE (# 18)

Source Code Comments

CELL DATATYPE: Cell Datatype, Valid Value are : C - Character, D - Date, N - Number

Columns Comments for GORWFMP_LENGTH (# 19)

Source Code Comments

LENGTH: Length of the field

Columns Comments for GORWFMP_ENTER_HINT (# 20)

Source Code Comments

ENTER HINT: Hint Text in Enter Mode

Columns Comments for GORWFMP_APPLY_HINT (# 21)

Source Code Comments

APPLY HINT: Hint Text in Apply Mode

Columns Comments for GORWFMP_CASE (# 22)

Source Code Comments

CASE: Field Case, valid values are U - Upper, L - Lower, M - Mixed

Table GTVCALL

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GTVCALL_CODE	VARCHAR2(10)	No	*
GTVCALL_DESC	VARCHAR2(30)	No
GTVCALL_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GTVCALL	Unique	GTVCALL_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GURCALL	SQL Table	S10B80.GENERAL	Refer (no action)
GTVCALLC	Oracle Package Cursor	S10B80.BANINST1.GTKCALL	Use (select)Rely On
GTVCALL_C	Oracle Package Cursor	S10B80.BANINST1.GB_GTVCALL	Rely On
GTVCALL_C	Oracle Package Cursor	S10B80.BANINST1.GB_GTVCALL	Use (select)Rely On
F_CODE_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_GTVCALL	Rely On
F_GET_DESCRIPTION	Oracle Package Function	S10B80.BANINST1.GB_GTVCALL	Rely On
GTVCALL	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_GTVCALL	SQL Index	S10B80.GENERAL	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GTVCALL

Object Dates

Creation Date	Analysis Date
04/02/2008 20:33:39:000	04/02/2008 21:17:58:000

Source Code Comments

QuickFlow Validation Table

Columns Comments for GTVCALL_CODE (# 1)

Source Code Comments

This field identifies the QuickFlow code referenced by the QuickFlow Definition Form (GUAQUIK).

Columns Comments for GTVCALL_DESC (# 2)

Source Code Comments

This field identifies the description associated with the QuickFlow code

Columns Comments for GTVCALL_ACTIVITY_DATE (# 3)

Source Code Comments

This field identifies the date a record was added or last updated

Table GTVOBJT

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

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

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	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 GURCALL

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
GURCALL_CALL_CODE	VARCHAR2(10)	No	*
GURCALL_FORM	VARCHAR2(8)	No
GURCALL_SEQNO	NUMBER(23,20)	No
GURCALL_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
GURCALL_CALL_CODE	GTVCALL_CODE	GTVCALL

Index

Index Name	Index Type	Column Name
GURCALL_INDEX		GURCALL_CALL_CODE
GURCALL_INDEX		GURCALL_FORM

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
GURCALL_INDEX	SQL Index	S10B80.GENERAL	Rely On
GTVCALL	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GURCALL

Object Dates

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

Source Code Comments

QuickFlow Repeating Table

Columns Comments for GURCALL_CALL_CODE (# 1)

Source Code Comments

This field identifies the QuickFlow code the record belongs to. The field is validated againt the QuickFlow Validation table - GTVQUIK

Columns Comments for GURCALL_FORM (# 2)

Source Code Comments

This field identifies the name of the form to be included in the QuickFlow.

Columns Comments for GURCALL_SEQNO (# 3)

Source Code Comments

This field defines the order which the form is to be called within the QuickFlow

Columns Comments for GURCALL_ACTIVITY_DATE (# 4)

Source Code Comments

This field identifies the date a record was added or last updated

Table GURMENU

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	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.

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)

Link between GORWFDD and GOBWFDD

Link List

Link Type	Link	Project
Refer (delete,cascade)	Link Informative Foreign Key Between GORWFDD and GOBWFDD (FK1_GORWFDD_INV_GOBWFDD_KEY)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GORWFDD	GORWFDD_ID	GOBWFDD_ID	GOBWFDD	(1,1)-(0,n)

Link between GURCALL and GTVCALL

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GURCALL and GTVCALL (FK1_GURCALL_INV_GTVCALL_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GURCALL	GURCALL_CALL_CODE	GTVCALL_CODE	GTVCALL	(1,1)-(0,n)

Link between GORWFMP and GOBWFDD

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GORWFMP and GOBWFDD (FK1_GORWFMP_INV_GOBWFDD_KEY)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GORWFMP	GORWFMP_APPL_ID	GOBWFDD_ID	GOBWFDD	(0,1)-(0,n)