Model Workflow Electronic Documents

Model Label : Banner General Workflow Electronic Docuemnts
Path : Default Folder/B70/General/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 S4B70
Creation Date 09/29/2003 12:04:33: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

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GOBWFDD	SYNONYM	S4B70.PUBLIC	Rely on ()
GORWFDD	TABLE	S4B70."GENERAL"	Refer( Cascade delete )
GORWFMP	TABLE	S4B70."GENERAL"	Refer( No Action )
APPL_RG	Forms Record Group	BANNER7_FORMS.GORWFDB	Use(select )
APPL_RG	Forms Record Group	BANNER7_FORMS_10G.GORWFDB	Use(select )
GOBWFDD_RG	Forms Record Group	BANNER7_FORMS.GOQOLIB	Use(select )
GOBWFDD_RG	Forms Record Group	BANNER7_FORMS.GORWFDD	Use(select )
GOBWFDD_RG	Forms Record Group	BANNER7_FORMS_10G.GOQOLIB	Use(select )
GOBWFDD_RG	Forms Record Group	BANNER7_FORMS.GORWFDB	Use(select )
GOBWFDD_RG	Forms Record Group	BANNER7_FORMS_10G.GORWFDB	Use(select )
GOBWFDD_RG	Forms Record Group	BANNER7_FORMS_10G.GORWFDD	Use(select )
CHK_APPL_NAME	Forms Function	BANNER7_FORMS.GORWFDB	Use(select )
CHK_APPL_NAME	Forms Function	BANNER7_FORMS_10G.GORWFDB	Use(select )
CHK_APPL_NAME	Forms Function	BANNER7_FORMS_10G.GORWFDD	Use(select )
CHK_APPL_NAME	Forms Function	BANNER7_FORMS.GORWFDD	Use(select )
CHK_METADATA_EXISTS	Forms Function	BANNER7_FORMS.GOAWFIZ	Use(select )
CHK_METADATA_EXISTS	Forms Function	BANNER7_FORMS_10G.GOAWFIZ	Use(select )
GET_APPL_ID	Forms Function	BANNER7_FORMS.GORWFDB	Use(select )
GET_APPL_ID	Forms Function	BANNER7_FORMS_10G.GORWFDD	Use(select )
GET_APPL_ID	Forms Function	BANNER7_FORMS_10G.GORWFDB	Use(select )
GET_APPL_ID	Forms Function	BANNER7_FORMS_10G.GOAWFED	Use(select )
GET_APPL_ID	Forms Function	BANNER7_FORMS.GORWFDD	Use(select )
GET_APPL_ID	Forms Function	BANNER7_FORMS.GOAWFED	Use(select )
GET_APPL_NAME	Forms Function	BANNER7_FORMS.GORWFDB	Rely on () Use(select )
GET_APPL_NAME	Forms Function	BANNER7_FORMS.GOAWFED	Rely on () Use(select )
GET_APPL_NAME	Forms Function	BANNER7_FORMS_10G.GORWFDD	Rely on () Use(select )
GET_APPL_NAME	Forms Function	BANNER7_FORMS_10G.GORWFDB	Rely on () Use(select )
GET_APPL_NAME	Forms Function	BANNER7_FORMS_10G.GOAWFED	Rely on () Use(select )
GET_APPL_NAME	Forms Function	BANNER7_FORMS.GORWFDD	Rely on () Use(select )
DELETE_METADATA	Forms Sub Procedure	BANNER7_FORMS.GOQRPLS.G$_READ_METADATA	Use(delete )
DELETE_METADATA	Forms Sub Procedure	BANNER7_FORMS_10G.GOQRPLS.G$_READ_METADATA	Use(delete )
READ_METADATA	Forms Sub Procedure	BANNER7_FORMS.GOQRPLS.G$_READ_METADATA	Use(insert,select )
READ_METADATA	Forms Sub Procedure	BANNER7_FORMS_10G.GOQRPLS.G$_READ_METADATA	Use(insert,select )

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GOBWFDD	INDEX	S4B70."GENERAL"	Rely on ()
GUBOBJS	TABLE	S4B70."GENERAL"	Join

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 S4B70
Creation Date 09/29/2003 12:04:33: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

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GOBWFED	SYNONYM	S4B70.PUBLIC	Rely on ()
GORWFDH	TABLE	S4B70."GENERAL"	Refer( No Action )
GORWFED	TABLE	S4B70."GENERAL"	Refer( No Action )
GOBWFED_RG	Forms Record Group	BANNER7_FORMS.GOQOLIB	Use(select )
GOBWFED_RG	Forms Record Group	BANNER7_FORMS_10G.GOAWFED	Use(select )
GOBWFED_RG	Forms Record Group	BANNER7_FORMS.GOAWFED	Use(select )
GOBWFED_RG	Forms Record Group	BANNER7_FORMS_10G.GOQOLIB	Use(select )
CREATE_NEW_DOC	Forms Procedure	BANNER7_FORMS.GOAWFED	Use(insert )
CREATE_NEW_DOC	Forms Procedure	BANNER7_FORMS_10G.GOAWFED	Use(insert )
GET_TRANS_DESC	Forms Function	BANNER7_FORMS.GOAWFED	Rely on () Use(select )
GET_TRANS_DESC	Forms Function	BANNER7_FORMS_10G.GOAWFED	Rely on () Use(select )
P_WFEDEVNT	Package procedure	S4B70.BANINST1.GOKSEVN	Rely on ()
F_CHECKTRANSNO	Package function	S4B70.BANINST1.GOKEDVD	Rely on ()
F_CHECKTRANSNO	Package function	S4B70.BANINST1.GOKEDVD	Use(select )
F_GETWFEDDESCRIPTION	Package function	S4B70.BANINST1.GOKEDVD	Rely on ()
F_GETWFEDDESCRIPTION	Package function	S4B70.BANINST1.GOKEDVD	Use(select )

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GOBWFED	INDEX	S4B70."GENERAL"	Rely on ()

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 S4B70
Creation Date 09/29/2003 12:04:34: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

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GORWFDB	SYNONYM	S4B70.PUBLIC	Rely on ()
GOVWFDB	VIEW	S4B70.BANINST1	Use(select )
CHECK_WFED	Forms Function	BANNER7_FORMS.GTVWFED	Use(select )
CHECK_WFED	Forms Function	BANNER7_FORMS_10G.GTVWFED	Use(select )

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GORWFDB_INDEX	INDEX	S4B70."GENERAL"	Rely on ()
GTVWFED	TABLE	S4B70."GENERAL"	Refer( No Action )

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 S4B70
Creation Date 09/29/2003 12:04:34: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

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GORWFDD	SYNONYM	S4B70.PUBLIC	Rely on ()
APPL_ELEM_RG	Forms Record Group	BANNER7_FORMS.GORWFDB	Use(select )
APPL_ELEM_RG	Forms Record Group	BANNER7_FORMS_10G.GORWFDB	Use(select )
GET_METADATA_DEFAULT	Forms Procedure	BANNER7_FORMS.GORWFDB	Use(select )
GET_METADATA_DEFAULT	Forms Procedure	BANNER7_FORMS_10G.GORWFDB	Use(select )
P_SEARCH	Forms Procedure	BANNER7_FORMS.GOAWFED	Use(select )
P_SEARCH	Forms Procedure	BANNER7_FORMS_10G.GOAWFED	Use(select )
F_CHECK_DYNAMIC_LIST_EXISTS	Forms Function	BANNER7_FORMS.GOAWFED	Use(select )
F_CHECK_DYNAMIC_LIST_EXISTS	Forms Function	BANNER7_FORMS_10G.GOAWFED	Use(select )
READ_METADATA	Forms Sub Procedure	BANNER7_FORMS.GOQRPLS.G$_READ_METADATA	Use(insert )
READ_METADATA	Forms Sub Procedure	BANNER7_FORMS_10G.GOQRPLS.G$_READ_METADATA	Use(insert )
GORWFDD	Forms DataBlock	BANNER7_FORMS.GORWFDD	Rely on () Use(insert,update,delete,select )
GORWFDD	Forms DataBlock	BANNER7_FORMS_10G.GORWFDD	Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GORWFDD	INDEX	S4B70."GENERAL"	Rely on ()
GOBWFDD	TABLE	S4B70."GENERAL"	Refer( Cascade delete )

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 S4B70
Creation Date 09/29/2003 12:04:34: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

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GORWFDH	SYNONYM	S4B70.PUBLIC	Rely on ()
WFED_TRANS_NO_RG	Forms Record Group	BANNER7_FORMS.GOQOLIB	Use(select )
WFED_TRANS_NO_RG	Forms Record Group	BANNER7_FORMS_10G.GOQOLIB	Use(select )
WFED_TRANS_NO_RG	Forms Record Group	BANNER7_FORMS.GOAWFED	Use(select )
WFED_TRANS_NO_RG	Forms Record Group	BANNER7_FORMS_10G.GOAWFED	Use(select )
CREATE_NEW_DOC	Forms Procedure	BANNER7_FORMS.GOAWFED	Use(insert )
CREATE_NEW_DOC	Forms Procedure	BANNER7_FORMS_10G.GOAWFED	Use(insert )
CREATE_NEW_GORWFDH_SEQ_NO	Forms Procedure	BANNER7_FORMS.GOAWFED	Use(insert,select )
CREATE_NEW_GORWFDH_SEQ_NO	Forms Procedure	BANNER7_FORMS_10G.GOAWFED	Use(insert,select )
UPDATE_TRANS_STATUS	Forms Procedure	BANNER7_FORMS.GOAWFED	Use(update,select )
UPDATE_TRANS_STATUS	Forms Procedure	BANNER7_FORMS_10G.GOAWFED	Use(update,select )
CHECK_ACCESS	Forms Function	BANNER7_FORMS.GOAWFED	Use(select )
CHECK_ACCESS	Forms Function	BANNER7_FORMS_10G.GOAWFED	Use(select )
CHK_TRANS_NO	Forms Function	BANNER7_FORMS.GOAWFED	Use(select )
CHK_TRANS_NO	Forms Function	BANNER7_FORMS_10G.GOAWFED	Use(select )
GET_TRANS_STATUS	Forms Function	BANNER7_FORMS.GOAWFED	Rely on () Use(select )
GET_TRANS_STATUS	Forms Function	BANNER7_FORMS_10G.GOAWFED	Rely on () Use(select )
P_APPLY_TRANS_STATUS	Package procedure	S4B70.BANINST1.GOKWFED	Use(update,select )
P_UPDATE_TRANS_STATUS	Package procedure	S4B70.BANINST1.GOKWFED	Use(update,select )
P_WFEDEVNT	Package procedure	S4B70.BANINST1.GOKSEVN	Rely on ()
F_GETWFDHSTATUS	Package function	S4B70.BANINST1.GOKEDVD	Rely on ()
F_GETWFDHSTATUS	Package function	S4B70.BANINST1.GOKEDVD	Use(select )
F_GET_ACCESS	Package function	S4B70.BANINST1.GOKWFED	Use(select )
F_INITIATEEVENT	Package function	S4B70.BANINST1.GOKEDVD	Rely on ()
F_INITIATEEVENT	Package function	S4B70.BANINST1.GOKEDVD	Use(select )
GORWFDH	Forms DataBlock	BANNER7_FORMS.GOAWFED	Rely on () Use(insert,update,delete,select )
GORWFDH	Forms DataBlock	BANNER7_FORMS_10G.GOAWFED	Rely on () Use(insert,update,delete,select )
GORWFDH_1	Forms DataBlock	BANNER7_FORMS.GOAWFED	Rely on () Use(select )
GORWFDH_1	Forms DataBlock	BANNER7_FORMS_10G.GOAWFED	Rely on () Use(select )

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GORWFDH	INDEX	S4B70."GENERAL"	Rely on ()
GOBWFED	TABLE	S4B70."GENERAL"	Refer( No Action )

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 S4B70
Creation Date 09/29/2003 12:04:34: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

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GORWFDS	SYNONYM	S4B70.PUBLIC	Rely on ()
GET_SUPERUSER_DATA	Forms Procedure	BANNER7_FORMS.GOAWFED	Rely on () Use(select )
GET_SUPERUSER_DATA	Forms Procedure	BANNER7_FORMS_10G.GOAWFED	Rely on () Use(select )
CHECK_ACCESS	Forms Function	BANNER7_FORMS.GOAWFED	Use(select )
CHECK_ACCESS	Forms Function	BANNER7_FORMS_10G.GOAWFED	Use(select )
CHECK_UNIQUE_WFED	Forms Function	BANNER7_FORMS.GORWFDS	Use(select )
CHECK_UNIQUE_WFED	Forms Function	BANNER7_FORMS_10G.GORWFDS	Use(select )
F_GET_ACCESS	Package function	S4B70.BANINST1.GOKWFED	Use(select )
GORWFDS	Forms DataBlock	BANNER7_FORMS.GORWFDS	Rely on () Use(insert,update,delete,select )
GORWFDS	Forms DataBlock	BANNER7_FORMS_10G.GORWFDS	Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GORWFDS	INDEX	S4B70."GENERAL"	Rely on ()

Comments

Table GORWFED

Schema Name GENERAL
Label GORWFED
Server name S4B70
Creation Date 09/29/2003 12:04:34: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

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GORWFED	SYNONYM	S4B70.PUBLIC	Rely on ()
GOVWFED	VIEW	S4B70.BANINST1	Use(select )
GET_CODE	Forms Function	BANNER7_FORMS.GOAWFED	Rely on () Use(select )
GET_CODE	Forms Function	BANNER7_FORMS_10G.GOAWFED	Rely on () Use(select )
GET_CODE	Forms Function	BANNER7_FORMS_10G.GOQWFED	Rely on () Use(select )
GET_CODE	Forms Function	BANNER7_FORMS.GOQWFED	Rely on () Use(select )
GET_NEXT_TRANS_NO	Forms Function	BANNER7_FORMS.GOAWFED	Rely on ()
GET_NEXT_TRANS_NO	Forms Function	BANNER7_FORMS_10G.GOAWFED	Rely on ()
GET_NEXT_TRANS_NO_OLD	Forms Function	BANNER7_FORMS.GOAWFED	Rely on () Use(select )
GET_NEXT_TRANS_NO_OLD	Forms Function	BANNER7_FORMS_10G.GOAWFED	Rely on () Use(select )
P_GETGRADECHANGEEDATA	Package procedure	S4B70.BANINST1.SHKWEVN	Rely on ()
P_WFEDEVNT	Package procedure	S4B70.BANINST1.GOKSEVN	Rely on ()
F_GETDOCUMENTTYPE	Package function	S4B70.BANINST1.GOKEDVD	Rely on ()
F_GETDOCUMENTTYPE	Package function	S4B70.BANINST1.GOKEDVD	Use(select )
F_GET_ACCESS	Package function	S4B70.BANINST1.GOKWFED	Rely on ()
F_GET_ACCESS	Package function	S4B70.BANINST1.GOKWFED	Use(sel