Model Workflow Electronic Documents

Model Label : Banner General Workflow Electronic Documents
Path : BANNER DEV/General/ERD/Workflow Electronic Documents

List of Objects

Object Name	Object Type	Layer Name
GOBWFDD	TABLE	Default
GOBWFED	TABLE	Default
GORWFDB	TABLE	Default
GORWFDD	TABLE	Default
GORWFDH	TABLE	Default
GORWFDS	TABLE	Default
GORWFED	TABLE	Default
GORWFMP	TABLE	Default
GORWFPM	TABLE	Default
GORWFSQ	TABLE	Default
GOVWFDB	VIEW	Default
GOVWFED	VIEW	Default
GTVOBJT	TABLE	Default
GTVSYSI	TABLE	Default
GTVWFED	TABLE	Default
GUBOBJS	TABLE	Default
GURMENU	TABLE	Default

Comments

Model View

Table GOBWFDD

Schema Name GENERAL
Label GOBWFDD
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
GOBWFDD_ID	GOBWFDD_ID	NUMBER(8,0)	No	*
GOBWFDD_PRODUCT_TYPE	GOBWFDD_PRODUCT_TYPE	VARCHAR2(20)	No
GOBWFDD_APPL_NAME	GOBWFDD_APPL_NAME	VARCHAR2(20)	No		*
GOBWFDD_USER_ID	GOBWFDD_USER_ID	VARCHAR2(30)	No
GOBWFDD_ACTIVITY_DATE	GOBWFDD_ACTIVITY_DATE	DATE	No

Foreign Key information

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

Index

Index Name	Index Type	Column Name
PK_GOBWFDD	Unique	GOBWFDD_ID

Comments

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 GOBWFED

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
GOBWFED_TRANS_NO	GOBWFED_TRANS_NO	NUMBER(15,0)	No	*
GOBWFED_DESC	GOBWFED_DESC	VARCHAR2(60)	No
GOBWFED_ACTIVITY_DATE	GOBWFED_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GOBWFED	Unique	GOBWFED_TRANS_NO

Comments

Source Code Comments

Workflow Electronic Documents Base Table

Columns Comments for GOBWFED_TRANS_NO (1)

Source Code Comments

TRANSACTION NUMBER: Electronic Document Transaction Number

Columns Comments for GOBWFED_DESC (2)

Source Code Comments

DESCRIPTION: Electronic Document Transcation Description

Table GORWFDB

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
GORWFDB_WFED_CODE	GORWFDB_WFED_CODE	VARCHAR2(20)	No	*
GORWFDB_PAGE	GORWFDB_PAGE	NUMBER(2,0)	No
GORWFDB_LINE	GORWFDB_LINE	NUMBER(2,0)	No
GORWFDB_USER_ID	GORWFDB_USER_ID	VARCHAR2(30)	No
GORWFDB_ACTIVITY_DATE	GORWFDB_ACTIVITY_DATE	DATE	No
GORWFDB_A	GORWFDB_A	VARCHAR2(60)	Yes
GORWFDB_B	GORWFDB_B	VARCHAR2(60)	Yes
GORWFDB_C	GORWFDB_C	VARCHAR2(60)	Yes
GORWFDB_D	GORWFDB_D	VARCHAR2(60)	Yes
GORWFDB_E	GORWFDB_E	VARCHAR2(60)	Yes
GORWFDB_F	GORWFDB_F	VARCHAR2(60)	Yes
GORWFDB_G	GORWFDB_G	VARCHAR2(60)	Yes
GORWFDB_H	GORWFDB_H	VARCHAR2(60)	Yes
GORWFDB_I	GORWFDB_I	VARCHAR2(60)	Yes
GORWFDB_J	GORWFDB_J	VARCHAR2(60)	Yes
GORWFDB_K	GORWFDB_K	VARCHAR2(60)	Yes
GORWFDB_L	GORWFDB_L	VARCHAR2(60)	Yes
GORWFDB_M	GORWFDB_M	VARCHAR2(60)	Yes
GORWFDB_N	GORWFDB_N	VARCHAR2(60)	Yes
GORWFDB_O	GORWFDB_O	VARCHAR2(60)	Yes
GORWFDB_P	GORWFDB_P	VARCHAR2(60)	Yes
GORWFDB_Q	GORWFDB_Q	VARCHAR2(60)	Yes
GORWFDB_R	GORWFDB_R	VARCHAR2(60)	Yes
GORWFDB_S	GORWFDB_S	VARCHAR2(60)	Yes
GORWFDB_T	GORWFDB_T	VARCHAR2(60)	Yes
GORWFDB_U	GORWFDB_U	VARCHAR2(60)	Yes
GORWFDB_V	GORWFDB_V	VARCHAR2(60)	Yes
GORWFDB_W	GORWFDB_W	VARCHAR2(60)	Yes
GORWFDB_X	GORWFDB_X	VARCHAR2(60)	Yes
GORWFDB_Y	GORWFDB_Y	VARCHAR2(60)	Yes
GORWFDB_Z	GORWFDB_Z	VARCHAR2(60)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GORWFDB_WFED_CODE	GTVWFED_CODE	GTVWFED

Index

Index Name	Index Type	Column Name
GORWFDB_INDEX		GORWFDB_WFED_CODE
GORWFDB_INDEX		GORWFDB_PAGE
GORWFDB_INDEX		GORWFDB_LINE

Comments

Source Code Comments

Workflow Electronic Docuents Builder Table

Columns Comments for GORWFDB_WFED_CODE (1)

Source Code Comments

ELECTRONIC DOCUMENT: Workflow Electronic Document Type Code

Columns Comments for GORWFDB_PAGE (2)

Source Code Comments

PAGE: Page number for the mapping

Columns Comments for GORWFDB_LINE (3)

Source Code Comments

LINE: Line number for the mapping

Columns Comments for GORWFDB_A (6)

Source Code Comments

A: Column A for the mapping

Columns Comments for GORWFDB_B (7)

Source Code Comments

B: Column B for the mapping

Columns Comments for GORWFDB_C (8)

Source Code Comments

C: Column C for the mapping

Columns Comments for GORWFDB_D (9)

Source Code Comments

D: Column D for the mapping

Columns Comments for GORWFDB_E (10)

Source Code Comments

E: Column E for the mapping

Columns Comments for GORWFDB_F (11)

Source Code Comments

F: Column F for the mapping

Columns Comments for GORWFDB_G (12)

Source Code Comments

G: Column G for the mapping

Columns Comments for GORWFDB_H (13)

Source Code Comments

H: Column H for the mapping

Columns Comments for GORWFDB_I (14)

Source Code Comments

I: Column I for the mapping

Columns Comments for GORWFDB_K (16)

Source Code Comments

K: Column K for the mapping

Columns Comments for GORWFDB_L (17)

Source Code Comments

L: Column L for the mapping

Columns Comments for GORWFDB_M (18)

Source Code Comments

M: Column M for the mapping

Columns Comments for GORWFDB_N (19)

Source Code Comments

N: Column N for the mapping

Columns Comments for GORWFDB_O (20)

Source Code Comments

O: Column O for the mapping

Columns Comments for GORWFDB_P (21)

Source Code Comments

P: Column P for the mapping

Columns Comments for GORWFDB_Q (22)

Source Code Comments

Q: Column Q for the mapping

Columns Comments for GORWFDB_R (23)

Source Code Comments

R: Column R for the mapping

Columns Comments for GORWFDB_S (24)

Source Code Comments

S: Column S for the mapping

Columns Comments for GORWFDB_T (25)

Source Code Comments

T: Column T for the mapping

Columns Comments for GORWFDB_U (26)

Source Code Comments

U: Column U for the mapping

Columns Comments for GORWFDB_V (27)

Source Code Comments

V: Column V for the mapping

Columns Comments for GORWFDB_W (28)

Source Code Comments

W: Column W for the mapping

Columns Comments for GORWFDB_X (29)

Source Code Comments

X: Column X for the mapping

Columns Comments for GORWFDB_Y (30)

Source Code Comments

Y: Column Y for the mapping

Columns Comments for GORWFDB_Z (31)

Source Code Comments

Z: Column Z for the mapping

Table GORWFDD

Schema Name GENERAL
Label GORWFDD
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
GORWFDD_ID	GORWFDD_ID	NUMBER(8,0)	No	*	*
GORWFDD_ELEMENT_NAME	GORWFDD_ELEMENT_NAME	VARCHAR2(100)	No	*
GORWFDD_ELEMENT_TYPE	GORWFDD_ELEMENT_TYPE	VARCHAR2(20)	No
GORWFDD_ELEMENT_DTYPE	GORWFDD_ELEMENT_DTYPE	VARCHAR2(20)	No
GORWFDD_LENGTH	GORWFDD_LENGTH	NUMBER(6,0)	No
GORWFDD_REQUIRED_IND	GORWFDD_REQUIRED_IND	VARCHAR2(1)	No
GORWFDD_MULTI_LINE_IND	GORWFDD_MULTI_LINE_IND	VARCHAR2(1)	No
GORWFDD_USER_ID	GORWFDD_USER_ID	VARCHAR2(30)	No
GORWFDD_ACTIVITY_DATE	GORWFDD_ACTIVITY_DATE	DATE	No
GORWFDD_DATABASE_ELEMENT	GORWFDD_DATABASE_ELEMENT	VARCHAR2(61)	Yes
GORWFDD_ELEMENT_HINT	GORWFDD_ELEMENT_HINT	VARCHAR2(2000)	Yes
GORWFDD_LOW_RANGE	GORWFDD_LOW_RANGE	VARCHAR2(60)	Yes
GORWFDD_HIGH_RANGE	GORWFDD_HIGH_RANGE	VARCHAR2(60)	Yes
GORWFDD_FORMAT_MASK	GORWFDD_FORMAT_MASK	VARCHAR2(30)	Yes
GORWFDD_CASE	GORWFDD_CASE	VARCHAR2(9)	Yes
GORWFDD_ALIGNMENT	GORWFDD_ALIGNMENT	VARCHAR2(6)	Yes
GORWFDD_LIST_APPL_NAME	GORWFDD_LIST_APPL_NAME	VARCHAR2(10)	Yes
GORWFDD_LIST_TABLE_NAME	GORWFDD_LIST_TABLE_NAME	VARCHAR2(30)	Yes
GORWFDD_LIST_COLUMN_NAME	GORWFDD_LIST_COLUMN_NAME	VARCHAR2(30)	Yes
GORWFDD_LIST_DESC_COLUMN_NAME	GORWFDD_LIST_DESC_COLUMN_NAME	VARCHAR2(30)	Yes
GORWFDD_LIST_WHERE_CLAUSE	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

Comments

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 GORWFDH

Schema Name GENERAL
Label GORWFDH
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
GORWFDH_TRANS_NO	GORWFDH_TRANS_NO	NUMBER(15,0)	No	*	*
GORWFDH_SEQ_NO	GORWFDH_SEQ_NO	NUMBER(2,0)	No	*
GORWFDH_STATUS	GORWFDH_STATUS	VARCHAR2(20)	No
GORWFDH_USER_ID	GORWFDH_USER_ID	VARCHAR2(30)	No
GORWFDH_ACTIVITY_DATE	GORWFDH_ACTIVITY_DATE	DATE	No
GORWFDH_COMMENTS	GORWFDH_COMMENTS	VARCHAR2(2000)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GORWFDH_TRANS_NO	GOBWFED_TRANS_NO	GOBWFED

Index

Index Name	Index Type	Column Name
PK_GORWFDH	Unique	GORWFDH_TRANS_NO
PK_GORWFDH	Unique	GORWFDH_SEQ_NO

Comments

Source Code Comments

Workflow Electronic Documents History Table

Columns Comments for GORWFDH_TRANS_NO (1)

Source Code Comments

TRANSACTION NUMBER: Electronic Document Transaction Number

Columns Comments for GORWFDH_SEQ_NO (2)

Source Code Comments

SEQUENCE NUMBER: Sequence Number per Transaction Number in History for this transaction

Columns Comments for GORWFDH_STATUS (3)

Source Code Comments

STATUS: Status of transactions

Columns Comments for GORWFDH_USER_ID (4)

Source Code Comments

USER ID: Oracle User Id

Columns Comments for GORWFDH_ACTIVITY_DATE (5)

Source Code Comments

ACTIVITY DATE: Activity Date when transaction was generated

Columns Comments for GORWFDH_COMMENTS (6)

Source Code Comments

COMMENTS: Comments for transactions

Table GORWFDS

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
GORWFDS_USER_ID	GORWFDS_USER_ID	VARCHAR2(30)	No	*
GORWFDS_WFED_CODE	GORWFDS_WFED_CODE	VARCHAR2(20)	No	*
GORWFDS_QUERY_MODE_IND	GORWFDS_QUERY_MODE_IND	VARCHAR2(1)	No
GORWFDS_UPDATE_MODE_IND	GORWFDS_UPDATE_MODE_IND	VARCHAR2(1)	No
GORWFDS_ACTIVITY_DATE	GORWFDS_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GORWFDS	Unique	GORWFDS_USER_ID
PK_GORWFDS	Unique	GORWFDS_WFED_CODE

Comments

Table GORWFED

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
GORWFED_TRANS_NO	GORWFED_TRANS_NO	NUMBER(15,0)	No	*
GORWFED_WFED_CODE	GORWFED_WFED_CODE	VARCHAR2(20)	No	*
GORWFED_PAGE	GORWFED_PAGE	NUMBER(2,0)	No
GORWFED_LINE	GORWFED_LINE	NUMBER(2,0)	No
GORWFED_ACTIVITY_DATE	GORWFED_ACTIVITY_DATE	DATE	No
GORWFED_A	GORWFED_A	VARCHAR2(60)	Yes
GORWFED_B	GORWFED_B	VARCHAR2(60)	Yes
GORWFED_C	GORWFED_C	VARCHAR2(60)	Yes
GORWFED_D	GORWFED_D	VARCHAR2(60)	Yes
GORWFED_E	GORWFED_E	VARCHAR2(60)	Yes
GORWFED_F	GORWFED_F	VARCHAR2(60)	Yes
GORWFED_G	GORWFED_G	VARCHAR2(60)	Yes
GORWFED_H	GORWFED_H	VARCHAR2(60)	Yes
GORWFED_I	GORWFED_I	VARCHAR2(60)	Yes
GORWFED_J	GORWFED_J	VARCHAR2(60)	Yes
GORWFED_K	GORWFED_K	VARCHAR2(60)	Yes
GORWFED_L	GORWFED_L	VARCHAR2(60)	Yes
GORWFED_M	GORWFED_M	VARCHAR2(60)	Yes
GORWFED_N	GORWFED_N	VARCHAR2(60)	Yes
GORWFED_O	GORWFED_O	VARCHAR2(60)	Yes
GORWFED_P	GORWFED_P	VARCHAR2(60)	Yes
GORWFED_Q	GORWFED_Q	VARCHAR2(60)	Yes
GORWFED_R	GORWFED_R	VARCHAR2(60)	Yes
GORWFED_S	GORWFED_S	VARCHAR2(60)	Yes
GORWFED_T	GORWFED_T	VARCHAR2(60)	Yes
GORWFED_U	GORWFED_U	VARCHAR2(60)	Yes
GORWFED_V	GORWFED_V	VARCHAR2(60)	Yes
GORWFED_W	GORWFED_W	VARCHAR2(60)	Yes
GORWFED_X	GORWFED_X	VARCHAR2(60)	Yes
GORWFED_Y	GORWFED_Y	VARCHAR2(60)	Yes
GORWFED_Z	GORWFED_Z	VARCHAR2(60)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GORWFED_TRANS_NO	GOBWFED_TRANS_NO	GOBWFED
GORWFED_WFED_CODE	GTVWFED_CODE	GTVWFED

Index

Index Name	Index Type	Column Name
GORWFED_INDEX		GORWFED_TRANS_NO
GORWFED_INDEX		GORWFED_WFED_CODE
GORWFED_INDEX		GORWFED_PAGE
GORWFED_INDEX		GORWFED_LINE

Comments

Source Code Comments

Workflow Electronic Documents Repeating Table

Columns Comments for GORWFED_TRANS_NO (1)

Source Code Comments

TRANSACTION NUMBER: Transcation Number for the Electronic Document

Columns Comments for GORWFED_WFED_CODE (2)

Source Code Comments

ELECTRONIC DOCUMENT: Workflow Electronic Document Type Code

Columns Comments for GORWFED_PAGE (3)

Source Code Comments

PAGE: Page number for the mapping

Columns Comments for GORWFED_LINE (4)

Source Code Comments

LINE: Line number for the mapping

Columns Comments for GORWFED_A (6)

Source Code Comments

A: Column A for the mapping

Columns Comments for GORWFED_B (7)

Source Code Comments

B: Column B for the mapping

Columns Comments for GORWFED_C (8)

Source Code Comments

C: Column C for the mapping

Columns Comments for GORWFED_D (9)

Source Code Comments

D: Column D for the mapping

Columns Comments for GORWFED_E (10)

Source Code Comments

E: Column E for the mapping

Columns Comments for GORWFED_F (11)

Source Code Comments

F: Column F for the mapping

Columns Comments for GORWFED_G (12)

Source Code Comments

G: Column G for the mapping

Columns Comments for GORWFED_H (13)

Source Code Comments

H: Column H for the mapping

Columns Comments for GORWFED_I (14)

Source Code Comments

I: Column I for the mapping

Columns Comments for GORWFED_K (16)

Source Code Comments

K: Column K for the mapping

Columns Comments for GORWFED_L (17)

Source Code Comments

L: Column L for the mapping

Columns Comments for GORWFED_M (18)

Source Code Comments

M: Column M for the mapping

Columns Comments for GORWFED_N (19)

Source Code Comments

N: Column N for the mapping

Columns Comments for GORWFED_O (20)

Source Code Comments

O: Column O for the mapping

Columns Comments for GORWFED_P (21)

Source Code Comments

P: Column P for the mapping

Columns Comments for GORWFED_Q (22)

Source Code Comments

Q: Column Q for the mapping

Columns Comments for GORWFED_R (23)

Source Code Comments

R: Column R for the mapping

Columns Comments for GORWFED_S (24)

Source Code Comments

S: Column S for the mapping

Columns Comments for GORWFED_T (25)

Source Code Comments

T: Column T for the mapping

Columns Comments for GORWFED_U (26)

Source Code Comments

U: Column U for the mapping

Columns Comments for GORWFED_V (27)

Source Code Comments

V: Column V for the mapping

Columns Comments for GORWFED_W (28)

Source Code Comments

W: Column W for the mapping

Columns Comments for GORWFED_X (29)

Source Code Comments

X: Column X for the mapping

Columns Comments for GORWFED_Y (30)

Source Code Comments

Y: Column Y for the mapping

Columns Comments for GORWFED_Z (31)

Source Code Comments

Z: Column Z for the mapping

Table GORWFMP

Schema Name GENERAL
Label GORWFMP
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
GORWFMP_WFED_CODE	GORWFMP_WFED_CODE	VARCHAR2(20)	No	*	*
GORWFMP_PAGE	GORWFMP_PAGE	NUMBER(2,0)	No	*
GORWFMP_X_VALUE	GORWFMP_X_VALUE	VARCHAR2(2)	No	*
GORWFMP_Y_VALUE	GORWFMP_Y_VALUE	NUMBER(2,0)	No	*
GORWFMP_CELL_TYPE	GORWFMP_CELL_TYPE	VARCHAR2(20)	No
GORWFMP_REQUIRED_IND	GORWFMP_REQUIRED_IND	VARCHAR2(1)	No
GORWFMP_DEFAULT_OVERRIDE_IND	GORWFMP_DEFAULT_OVERRIDE_IND	VARCHAR2(1)	No
GORWFMP_USER_ID	GORWFMP_USER_ID	VARCHAR2(30)	No
GORWFMP_ACTIVITY_DATE	GORWFMP_ACTIVITY_DATE	DATE	No
GORWFMP_APPL_ID	GORWFMP_APPL_ID	NUMBER(8,0)	Yes		*
GORWFMP_APPL_TARGET_NAME	GORWFMP_APPL_TARGET_NAME	VARCHAR2(100)	Yes
GORWFMP_DATABASE_TARGET_NAME	GORWFMP_DATABASE_TARGET_NAME	VARCHAR2(100)	Yes
GORWFMP_DEFAULT	GORWFMP_DEFAULT	VARCHAR2(60)	Yes
GORWFMP_LOW_RANGE	GORWFMP_LOW_RANGE	VARCHAR2(30)	Yes
GORWFMP_HIGH_RANGE	GORWFMP_HIGH_RANGE	VARCHAR2(30)	Yes
GORWFMP_LIST	GORWFMP_LIST	VARCHAR2(20)	Yes
GORWFMP_EVENT_TYPE	GORWFMP_EVENT_TYPE	VARCHAR2(20)	Yes
GORWFMP_CELL_DTYPE	GORWFMP_CELL_DTYPE	VARCHAR2(9)	Yes
GORWFMP_LENGTH	GORWFMP_LENGTH	NUMBER(3,0)	Yes
GORWFMP_ENTER_HINT	GORWFMP_ENTER_HINT	VARCHAR2(2000)	Yes
GORWFMP_APPLY_HINT	GORWFMP_APPLY_HINT	VARCHAR2(2000)	Yes
GORWFMP_CASE	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

Comments

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 GORWFPM

Schema Name GENERAL
Label GORWFPM
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
GORWFPM_WFED_CODE	GORWFPM_WFED_CODE	VARCHAR2(20)	No	*	*
GORWFPM_PAGE	GORWFPM_PAGE	NUMBER(2,0)	No	*
GORWFPM_X_VALUE	GORWFPM_X_VALUE	VARCHAR2(2)	No	*
GORWFPM_Y_VALUE	GORWFPM_Y_VALUE	NUMBER(2,0)	No	*
GORWFPM_FUNC_NAME	GORWFPM_FUNC_NAME	VARCHAR2(61)	No
GORWFPM_FUNC_SEQ_NO	GORWFPM_FUNC_SEQ_NO	NUMBER(2,0)	No	*
GORWFPM_SEQ_NO	GORWFPM_SEQ_NO	NUMBER(2,0)	No	*
GORWFPM_PARM_X_VALUE	GORWFPM_PARM_X_VALUE	VARCHAR2(2)	No
GORWFPM_PARM_Y_VALUE	GORWFPM_PARM_Y_VALUE	NUMBER(2,0)	No
GORWFPM_DTYPE	GORWFPM_DTYPE	VARCHAR2(20)	No
GORWFPM_USER_ID	GORWFPM_USER_ID	VARCHAR2(30)	No
GORWFPM_ACTIVITY_DATE	GORWFPM_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
GORWFPM_WFED_CODE	GTVWFED_CODE	GTVWFED

Index

Index Name	Index Type	Column Name
PK_GORWFPM	Unique	GORWFPM_WFED_CODE
PK_GORWFPM	Unique	GORWFPM_PAGE
PK_GORWFPM	Unique	GORWFPM_X_VALUE
PK_GORWFPM	Unique	GORWFPM_Y_VALUE
PK_GORWFPM	Unique	GORWFPM_FUNC_SEQ_NO
PK_GORWFPM	Unique	GORWFPM_SEQ_NO

Comments

Source Code Comments

Parameters Table

Columns Comments for GORWFPM_WFED_CODE (1)

Source Code Comments

ELECTRONIC DOCUMENT: Workflow Electronic Document Type Code

Columns Comments for GORWFPM_PAGE (2)

Source Code Comments

Page: Page Number

Columns Comments for GORWFPM_X_VALUE (3)

Source Code Comments

X_VALUE: X coordinate of the cell

Columns Comments for GORWFPM_Y_VALUE (4)

Source Code Comments

Y_VALUE: Y coordinate of the cell

Columns Comments for GORWFPM_FUNC_NAME (5)

Source Code Comments

FUNCTION NAME: Database Function Name

Columns Comments for GORWFPM_FUNC_SEQ_NO (6)

Source Code Comments

FUNCTION SEQUENCE NUMBER: Sequence number of the function per Document Type

Columns Comments for GORWFPM_SEQ_NO (7)

Source Code Comments

SEQUENCE NUMBER: Parameter Sequence Number for the Function

Columns Comments for GORWFPM_PARM_X_VALUE (8)

Source Code Comments

PARAMETER X_VALUE: Parameter Value X coordinate of the cell

Columns Comments for GORWFPM_PARM_Y_VALUE (9)

Source Code Comments

PARAMETER Y_VALUE: Parameter Value Y coordinate of the cell

Columns Comments for GORWFPM_DTYPE (10)

Source Code Comments

DATATYPE: Datatype of parameters

Table GORWFSQ

Schema Name GENERAL
Label GORWFSQ
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
GORWFSQ_WFED_CODE	GORWFSQ_WFED_CODE	VARCHAR2(20)	No	*	*
GORWFSQ_SEQ_NO	GORWFSQ_SEQ_NO	NUMBER(2,0)	No	*
GORWFSQ_ID	GORWFSQ_ID	NUMBER(8,0)	No	*
GORWFSQ_USER_ID	GORWFSQ_USER_ID	VARCHAR2(30)	No
GORWFSQ_ACTIVITY_DATE	GORWFSQ_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
GORWFSQ_WFED_CODE	GTVWFED_CODE	GTVWFED

Index

Index Name	Index Type	Column Name
PK_GORWFSQ	Unique	GORWFSQ_WFED_CODE
PK_GORWFSQ	Unique	GORWFSQ_SEQ_NO
PK_GORWFSQ	Unique	GORWFSQ_ID

Comments

Source Code Comments

Documents Sequence Table

Columns Comments for GORWFSQ_WFED_CODE (1)

Source Code Comments

ELECTRONIC DOCUMENT: Workflow Electronic Document Type Code

Columns Comments for GORWFSQ_SEQ_NO (2)

Source Code Comments

SEQUENCE NUMBER: Documents Sequence Number

Columns Comments for GORWFSQ_ID (3)

Source Code Comments

ID: Application Id

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
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	*