Model Desktop_Tools*

Model Label :

List of Objects

Object Name	Object Type	Layer Name
GORDLUP	SQL Table	Default
GORDPRP	SQL Table	Default
GORDSEC	SQL Table	Default
GORDSPR	SQL Table	Default
GORDSTE	SQL Table	Default
GORDSTP	SQL Table	Default
GORDWIZ	SQL Table	Default
GTVDADD	SQL Table	Default
GTVDPRP	SQL Table	Default
GTVDSTP	SQL Table	Default

Model View

Table GORDLUP

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GORDLUP_DADD_CODE	VARCHAR2(15)	No	*	*
GORDLUP_LOOKUP_NAME	VARCHAR2(15)	No	*
GORDLUP_LOOKUP_DESCRIPTION	VARCHAR2(60)	No
GORDLUP_MENU_SEQNO	NUMBER(5,2)	No
GORDLUP_FINAID_IND	VARCHAR2(1)	No
GORDLUP_POSBUD_IND	VARCHAR2(1)	No
GORDLUP_BILCSH_IND	VARCHAR2(1)	No
GORDLUP_HUMANRE_IND	VARCHAR2(1)	No
GORDLUP_FINANCE_IND	VARCHAR2(1)	No
GORDLUP_ALUMNI_IND	VARCHAR2(1)	No
GORDLUP_STUDENT_IND	VARCHAR2(1)	No
GORDLUP_USER_ID	VARCHAR2(30)	No
GORDLUP_ACTIVITY_DATE	DATE	No
GORDLUP_LOAD_FUNCTION	VARCHAR2(255)	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
GORDLUP_DADD_CODE	GTVDADD_CODE	GTVDADD

Index

Index Name	Index Type	Column Name
PK_GORDLUP	Unique	GORDLUP_DADD_CODE
PK_GORDLUP	Unique	GORDLUP_LOOKUP_NAME

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
P_LOOKUP_PROPERTIES	Oracle Package Procedure	S10B80.BANINST1.GOKDTOP	Rely On
P_LOOKUP_PROPERTIES	Oracle Package Procedure	S10B80.BANINST1.GOKDTOP	Use (select)
GORDLUP	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_GORDLUP	SQL Index	S10B80.GENERAL	Rely On
GTVDADD	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GORDLUP

Object Dates

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

Source Code Comments

Add-In Data Lookup Repeating table

Columns Comments for GORDLUP_DADD_CODE (# 1)

Source Code Comments

ADD-IN CODE: Add-In code to associate with Data lookup.

Columns Comments for GORDLUP_LOOKUP_NAME (# 2)

Source Code Comments

LOOKUP NAME: Lookup Name associate with Add-In code.

Columns Comments for GORDLUP_LOOKUP_DESCRIPTION (# 3)

Source Code Comments

LOOKUP DESCRIPTION: Description of the Lookup.

Columns Comments for GORDLUP_MENU_SEQNO (# 4)

Source Code Comments

MENU SEQUENCE NUMBER: The number which represents item position on the Menu.

Columns Comments for GORDLUP_FINAID_IND (# 5)

Source Code Comments

FINANCIAL AID INDICATOR: Indicates that menu item is visible if Financial Aid is installed.

Columns Comments for GORDLUP_POSBUD_IND (# 6)

Source Code Comments

POSITION CONTROL INDICATOR: Indicates that menu item is visible if Position Control is installed.

Columns Comments for GORDLUP_BILCSH_IND (# 7)

Source Code Comments

BILLCSH INDICATOR: Indicates that menu item is visible if Billcsh is installed.

Columns Comments for GORDLUP_HUMANRE_IND (# 8)

Source Code Comments

HUMAN RESOURCE INDICATOR: Indicates that menu item is visible if Human Resource is installed.

Columns Comments for GORDLUP_FINANCE_IND (# 9)

Source Code Comments

FINANCE INDICATOR: Indicates that menu item is visible if Finance is installed.

Columns Comments for GORDLUP_ALUMNI_IND (# 10)

Source Code Comments

ALUMNI INDICATOR: Indicates that menu item is visible if Alumni is installed.

Columns Comments for GORDLUP_STUDENT_IND (# 11)

Source Code Comments

STUDENT INDICATOR: Indicates that menu item is visible if Student is installed.

Columns Comments for GORDLUP_USER_ID (# 12)

Source Code Comments

USER ID: The unique identification code of the user.

Columns Comments for GORDLUP_ACTIVITY_DATE (# 13)

Source Code Comments

ACTIVITY DATE: The date the information for the table on the record was entered or last updated.

Columns Comments for GORDLUP_LOAD_FUNCTION (# 14)

Source Code Comments

LOAD FUNCTION: The name of the function to be executed to load the data for the lookup.

Table GORDPRP

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GORDPRP_DPRP_CODE	VARCHAR2(15)	No	*	*
GORDPRP_VALUE_NAME	VARCHAR2(15)	No	*
GORDPRP_VALUE_DESCRIPTION	VARCHAR2(30)	No
GORDPRP_USER_ID	VARCHAR2(30)	No
GORDPRP_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
GORDPRP_DPRP_CODE	GTVDPRP_CODE	GTVDPRP

Index

Index Name	Index Type	Column Name
PK_GORDPRP	Unique	GORDPRP_DPRP_CODE
PK_GORDPRP	Unique	GORDPRP_VALUE_NAME

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

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GORDPRP

Object Dates

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

Source Code Comments

Step Property Repeating Table

Columns Comments for GORDPRP_DPRP_CODE (# 1)

Source Code Comments

STEP PROPERTY CODE: The unique step property code

Columns Comments for GORDPRP_VALUE_NAME (# 2)

Source Code Comments

STEP PROPERTY VALUE: Value of the step property

Columns Comments for GORDPRP_VALUE_DESCRIPTION (# 3)

Source Code Comments

STEP PROPERTY VALUE DESCRIPTION: Description of the step property value

Columns Comments for GORDPRP_USER_ID (# 4)

Source Code Comments

USER ID: The unique identification code of the user.

Columns Comments for GORDPRP_ACTIVITY_DATE (# 5)

Source Code Comments

ACTIVITY DATE: The date the information for the table on the record was entered or last updated.

Table GORDSEC

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GORDSEC_RECIPIENT_USER_ID	VARCHAR2(30)	No	*
GORDSEC_DADD_CODE	VARCHAR2(15)	No	*	*
GORDSEC_WIZARD_NAME	VARCHAR2(15)	No	*
GORDSEC_USER_ID	VARCHAR2(30)	No
GORDSEC_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
GORDSEC_DADD_CODE	GTVDADD_CODE	GTVDADD

Index

Index Name	Index Type	Column Name
PK_GORDSEC	Unique	GORDSEC_RECIPIENT_USER_ID
PK_GORDSEC	Unique	GORDSEC_DADD_CODE
PK_GORDSEC	Unique	GORDSEC_WIZARD_NAME

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GORDWIZ	SQL Table	S10B80.GENERAL	Join
P_USER_SECURITY_WIZARD	Oracle Package Procedure	S10B80.BANINST1.GOKDTOP	Use (select)
GORDSEC	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_GORDSEC	SQL Index	S10B80.GENERAL	Rely On
GTVDADD	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GORDSEC

Object Dates

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

Source Code Comments

User Security Repeating table.

Columns Comments for GORDSEC_RECIPIENT_USER_ID (# 1)

Source Code Comments

RECIPIANT USER ID: User id of security previlages recipiant.

Columns Comments for GORDSEC_DADD_CODE (# 2)

Source Code Comments

ADD-IN CODE: Add-In code to associate with Wizard name and Recipiant.

Columns Comments for GORDSEC_WIZARD_NAME (# 3)

Source Code Comments

WIZARD NAME: Wizard name to be associated with Recipiant.

Columns Comments for GORDSEC_USER_ID (# 4)

Source Code Comments

USER ID: The unique identification code of the user.

Columns Comments for GORDSEC_ACTIVITY_DATE (# 5)

Source Code Comments

ACTIVITY DATE: The date the information for the table on the record was entered or last updated.

Table GORDSPR

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GORDSPR_DADD_CODE	VARCHAR2(15)	No	*	*
GORDSPR_WIZARD_NAME	VARCHAR2(15)	No	*
GORDSPR_STEP_NAME	VARCHAR2(30)	No	*
GORDSPR_DPRP_CODE	VARCHAR2(15)	No	*	*
GORDSPR_USER_ID	VARCHAR2(30)	No
GORDSPR_ACTIVITY_DATE	DATE	No
GORDSPR_VALUE	VARCHAR2(255)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GORDSPR_DADD_CODE	GTVDADD_CODE	GTVDADD
GORDSPR_DPRP_CODE	GTVDPRP_CODE	GTVDPRP

Index

Index Name	Index Type	Column Name
PK_GORDSPR	Unique	GORDSPR_DADD_CODE
PK_GORDSPR	Unique	GORDSPR_WIZARD_NAME
PK_GORDSPR	Unique	GORDSPR_STEP_NAME
PK_GORDSPR	Unique	GORDSPR_DPRP_CODE

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

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GORDSPR

Object Dates

Creation Date	Analysis Date
04/02/2008 20:29:47:000	04/02/2008 21:17:53:000

Source Code Comments

Wizard Step Properties Repeating table

Columns Comments for GORDSPR_DADD_CODE (# 1)

Source Code Comments

ADD-IN CODE: Add-In code to associate with Wizard name and Step name.

Columns Comments for GORDSPR_WIZARD_NAME (# 2)

Source Code Comments

WIZARD NAME: Wizard name to be associated with SPRp name.

Columns Comments for GORDSPR_STEP_NAME (# 3)

Source Code Comments

STEP NAME: Step name of the Wizard.

Columns Comments for GORDSPR_DPRP_CODE (# 4)

Source Code Comments

STEP PROPERTY CODE: The code for Step type.

Columns Comments for GORDSPR_USER_ID (# 5)

Source Code Comments

USER ID: The unique identification code of the user.

Columns Comments for GORDSPR_ACTIVITY_DATE (# 6)

Source Code Comments

ACTIVITY DATE: The date the information for the table on the record was entered or last updated.

Columns Comments for GORDSPR_VALUE (# 7)

Source Code Comments

PROPERTY VALUE: The value of the property of the step.

Table GORDSTE

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GORDSTE_DADD_CODE	VARCHAR2(15)	No	*	*
GORDSTE_WIZARD_NAME	VARCHAR2(15)	No	*
GORDSTE_STEP_NAME	VARCHAR2(30)	No	*
GORDSTE_DSTP_CODE	VARCHAR2(15)	No		*
GORDSTE_USER_ID	VARCHAR2(30)	No
GORDSTE_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
GORDSTE_DSTP_CODE	GTVDSTP_CODE	GTVDSTP
GORDSTE_DADD_CODE	GTVDADD_CODE	GTVDADD

Index

Index Name	Index Type	Column Name
PK_GORDSTE	Unique	GORDSTE_DADD_CODE
PK_GORDSTE	Unique	GORDSTE_WIZARD_NAME
PK_GORDSTE	Unique	GORDSTE_STEP_NAME

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
P_STEP_TYPE	Oracle Package Procedure	S10B80.BANINST1.GOKDTOP	Rely On
P_STEP_TYPE	Oracle Package Procedure	S10B80.BANINST1.GOKDTOP	Use (select)
GORDSTE	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_GORDSTE	SQL Index	S10B80.GENERAL	Rely On
GTVDADD	SQL Table	S10B80.GENERAL	Refer (no action)
GTVDSTP	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GORDSTE

Object Dates

Creation Date	Analysis Date
04/02/2008 20:29:56:000	04/02/2008 21:17:53:000

Source Code Comments

Wizard Step Repeating table

Columns Comments for GORDSTE_DADD_CODE (# 1)

Source Code Comments

ADD-IN CODE: Add-In code to associate with Wizard name and Step name.

Columns Comments for GORDSTE_WIZARD_NAME (# 2)

Source Code Comments

WIZARD NAME: Wizard name to be associated with Step name.

Columns Comments for GORDSTE_STEP_NAME (# 3)

Source Code Comments

STEP NAME: Step name of the Wizard.

Columns Comments for GORDSTE_DSTP_CODE (# 4)

Source Code Comments

STEP TYPE CODE: The code for step type.

Columns Comments for GORDSTE_USER_ID (# 5)

Source Code Comments

USER ID: The unique identification code of the user.

Columns Comments for GORDSTE_ACTIVITY_DATE (# 6)

Source Code Comments

ACTIVITY DATE: The date the information for the table on the record was entered or last updated.

Table GORDSTP

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GORDSTP_DSTP_CODE	VARCHAR2(15)	No	*	*
GORDSTP_DPRP_CODE	VARCHAR2(15)	No	*	*
GORDSTP_LOCK_IND	VARCHAR2(1)	No
GORDSTP_REQUIRED_IND	VARCHAR2(1)	No
GORDSTP_USER_ID	VARCHAR2(30)	No
GORDSTP_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
GORDSTP_DSTP_CODE	GTVDSTP_CODE	GTVDSTP
GORDSTP_DPRP_CODE	GTVDPRP_CODE	GTVDPRP

Index

Index Name	Index Type	Column Name
PK_GORDSTP	Unique	GORDSTP_DSTP_CODE
PK_GORDSTP	Unique	GORDSTP_DPRP_CODE

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

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GORDSTP

Object Dates

Creation Date	Analysis Date
04/02/2008 20:29:57:000	04/02/2008 21:17:53:000

Source Code Comments

Step Type Property Repeating Table

Columns Comments for GORDSTP_DSTP_CODE (# 1)

Source Code Comments

STEP PROPERTY TYPE CODE: The uniqu step property type code.

Columns Comments for GORDSTP_DPRP_CODE (# 2)

Source Code Comments

STEP PROPERTY CODE: The step property code to be associated with Type code.

Columns Comments for GORDSTP_LOCK_IND (# 3)

Source Code Comments

LOCK INDICATOR: Indicates that the property is locked or not.

Columns Comments for GORDSTP_REQUIRED_IND (# 4)

Source Code Comments

REQUIRED INDICATOR: Indicates that the property is required or not.

Columns Comments for GORDSTP_USER_ID (# 5)

Source Code Comments

USER ID: The unique identification code of the user.

Columns Comments for GORDSTP_ACTIVITY_DATE (# 6)

Source Code Comments

ACTIVITY DATE: The date theinformation for the table on the record was entered or last updated.

Table GORDWIZ

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GORDWIZ_DADD_CODE	VARCHAR2(15)	No	*	*
GORDWIZ_WIZARD_NAME	VARCHAR2(15)	No	*	*
GORDWIZ_WIZARD_DESCRIPTION	VARCHAR2(60)	No
GORDWIZ_MENU_SEQNO	NUMBER(5,2)	No
GORDWIZ_FINAID_IND	VARCHAR2(1)	No
GORDWIZ_POSBUD_IND	VARCHAR2(1)	No
GORDWIZ_BILCSH_IND	VARCHAR2(1)	No
GORDWIZ_HUMANRE_IND	VARCHAR2(1)	No
GORDWIZ_FINANCE_IND	VARCHAR2(1)	No
GORDWIZ_ALUMNI_IND	VARCHAR2(1)	No
GORDWIZ_STUDENT_IND	VARCHAR2(1)	No
GORDWIZ_USER_ID	VARCHAR2(30)	No
GORDWIZ_ACTIVITY_DATE	DATE	No
GORDWIZ_FINISH_FUNCTION	VARCHAR2(255)	No
GORDWIZ_NEXT_FUNCTION	VARCHAR2(255)	No
GORDWIZ_UNLOAD_FUNCTION	VARCHAR2(255)	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
GORDWIZ_DADD_CODE	GTVDADD_CODE	GTVDADD
GORDWIZ_DADD_CODE	GORDSEC_DADD_CODE	GORDSEC
GORDWIZ_WIZARD_NAME	GORDSEC_WIZARD_NAME	GORDSEC

Index

Index Name	Index Type	Column Name
PK_GORDWIZ	Unique	GORDWIZ_DADD_CODE
PK_GORDWIZ	Unique	GORDWIZ_WIZARD_NAME

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
P_USER_SECURITY_WIZARD	Oracle Package Procedure	S10B80.BANINST1.GOKDTOP	Use (select)
P_WIZARD_PROPERTIES	Oracle Package Procedure	S10B80.BANINST1.GOKDTOP	Rely On
P_WIZARD_PROPERTIES	Oracle Package Procedure	S10B80.BANINST1.GOKDTOP	Use (select)
F_GETADDINDESCRIPTION	Oracle Package Function	S10B80.BANINST1.GOKEDVD	Use (select)
F_GETWIZARDDESCRIPTION	Oracle Package Function	S10B80.BANINST1.GOKEDVD	Rely On
F_GETWIZARDDESCRIPTION	Oracle Package Function	S10B80.BANINST1.GOKEDVD	Use (select)
F_VALIDATEADDINCODE	Oracle Package Function	S10B80.BANINST1.GOKEDVD	Use (select)
F_VALIDATEWIZARD	Oracle Package Function	S10B80.BANINST1.GOKEDVD	Rely On
F_VALIDATEWIZARD	Oracle Package Function	S10B80.BANINST1.GOKEDVD	Use (select)
GORDWIZ	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_GORDWIZ	SQL Index	S10B80.GENERAL	Rely On
GORDSEC	SQL Table	S10B80.GENERAL	Join
GTVDADD	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GORDWIZ

Object Dates

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

Source Code Comments

Add-In Wizard Association table

Columns Comments for GORDWIZ_DADD_CODE (# 1)

Source Code Comments

ADD-IN CODE: Add-In code to associate with Wizard.

Columns Comments for GORDWIZ_WIZARD_NAME (# 2)

Source Code Comments

WIZARD NAME: Wizard Name associate with Add-In code.

Columns Comments for GORDWIZ_WIZARD_DESCRIPTION (# 3)

Source Code Comments

WIZARD DESCRIPTION: Description of the Wizard.

Columns Comments for GORDWIZ_MENU_SEQNO (# 4)

Source Code Comments

MENU SEQUENCE NUMBER: The number which represents item position on the Menu.

Columns Comments for GORDWIZ_FINAID_IND (# 5)

Source Code Comments

FINANCIAL AID INDICATOR: Indicates that wizard is available if Financial Aid is installed.

Columns Comments for GORDWIZ_POSBUD_IND (# 6)

Source Code Comments

POSITION CONTROL INDICATOR: Indicates that wizard is available if Position Control is installed.

Columns Comments for GORDWIZ_BILCSH_IND (# 7)

Source Code Comments

BILLCSH INDICATOR: Indicates that wizard is available if Billcsh is installed.

Columns Comments for GORDWIZ_HUMANRE_IND (# 8)

Source Code Comments

HUMAN RESOURCE INDICATOR: Indicates that wizard is available if Human Resources is installed.

Columns Comments for GORDWIZ_FINANCE_IND (# 9)

Source Code Comments

FINANCE INDICATOR: Indicates that wizard is available if Finance is installed.

Columns Comments for GORDWIZ_ALUMNI_IND (# 10)

Source Code Comments

ALUMINI INDICATOR: Indicates that wizard is available if Alumni is installed.

Columns Comments for GORDWIZ_STUDENT_IND (# 11)

Source Code Comments

STUDENT INDICATOR: Indicates that wizard is available if Student is installed.

Columns Comments for GORDWIZ_USER_ID (# 12)

Source Code Comments

USER ID: The unique identification code of the user.

Columns Comments for GORDWIZ_ACTIVITY_DATE (# 13)

Source Code Comments

ACTIVITY DATE: The date the information for the table on the record was entered or last updated.

Columns Comments for GORDWIZ_FINISH_FUNCTION (# 14)

Source Code Comments

FINISH FUNCTION: The name of the function to be executed when user finish the Wizard step.

Columns Comments for GORDWIZ_NEXT_FUNCTION (# 15)

Source Code Comments

NEXT FUNCTION: The name of the function to be executed when user go to next step.

Columns Comments for GORDWIZ_UNLOAD_FUNCTION (# 16)

Source Code Comments

UNLOAD FUNCTION: Named function will be run to process cancellation of currently running wizard at user request (cancel button pressed).

Table GTVDADD

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GTVDADD_CODE	VARCHAR2(15)	No	*
GTVDADD_DESC	VARCHAR2(30)	No
GTVDADD_USER_ID	VARCHAR2(30)	No
GTVDADD_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GTVDADD	Unique	GTVDADD_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GORDLUP	SQL Table	S10B80.GENERAL	Refer (no action)
GORDSEC	SQL Table	S10B80.GENERAL	Refer (no action)
GORDSPR	SQL Table	S10B80.GENERAL	Refer (no action)
GORDSTE	SQL Table	S10B80.GENERAL	Refer (no action)
GORDWIZ	SQL Table	S10B80.GENERAL	Refer (no action)
GTVDADD_C	Oracle Package Cursor	S10B80.BANINST1.GB_GTVDADD	Rely On
GTVDADD_C	Oracle Package Cursor	S10B80.BANINST1.GB_GTVDADD	Use (select)Rely On
P_WIZARD_PROPERTIES	Oracle Package Procedure	S10B80.BANINST1.GOKDTOP	Rely On
P_WIZARD_PROPERTIES	Oracle Package Procedure	S10B80.BANINST1.GOKDTOP	Use (select)
F_CODE_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_GTVDADD	Rely On
F_GETADDINDESCRIPTION	Oracle Package Function	S10B80.BANINST1.GOKEDVD	Rely On
F_GETADDINDESCRIPTION	Oracle Package Function	S10B80.BANINST1.GOKEDVD	Use (select)
F_GETWIZARDDESCRIPTION	Oracle Package Function	S10B80.BANINST1.GOKEDVD	Rely On
F_GET_DESCRIPTION	Oracle Package Function	S10B80.BANINST1.GB_GTVDADD	Rely On
F_VALIDATEADDINCODE	Oracle Package Function	S10B80.BANINST1.GOKEDVD	Rely On
F_VALIDATEADDINCODE	Oracle Package Function	S10B80.BANINST1.GOKEDVD	Use (select)
F_VALIDATEDADD	Oracle Package Function	S10B80.BANINST1.GOKEDVD	Rely On
F_VALIDATEDADD	Oracle Package Function	S10B80.BANINST1.GOKEDVD	Use (select)
F_VALIDATEWIZARD	Oracle Package Function	S10B80.BANINST1.GOKEDVD	Rely On
GTVDADD	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_GTVDADD	SQL Index	S10B80.GENERAL	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GTVDADD

Object Dates

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

Source Code Comments

Add-In code Validation Table

Columns Comments for GTVDADD_CODE (# 1)

Source Code Comments

ADD-IN CODE: The unique Add-In Code for the Visual Basic Add-Ins.

Columns Comments for GTVDADD_DESC (# 2)

Source Code Comments

ADD-IN DESCRIPTION: Description of the Add-In.

Columns Comments for GTVDADD_USER_ID (# 3)

Source Code Comments

USER ID: The unique identification code of the user.

Columns Comments for GTVDADD_ACTIVITY_DATE (# 4)

Source Code Comments

ACTIVITY DATE: The date the information for the table on the record was entered or last updated.

Table GTVDPRP

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GTVDPRP_CODE	VARCHAR2(15)	No	*
GTVDPRP_DESC	VARCHAR2(30)	No
GTVDPRP_USER_ID	VARCHAR2(30)	No
GTVDPRP_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GTVDPRP	Unique	GTVDPRP_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GORDPRP	SQL Table	S10B80.GENERAL	Refer (no action)
GORDSPR	SQL Table	S10B80.GENERAL	Refer (no action)
GORDSTP	SQL Table	S10B80.GENERAL	Refer (no action)
GTVDPRP_C	Oracle Package Cursor	S10B80.BANINST1.GB_GTVDPRP	Rely On
GTVDPRP_C	Oracle Package Cursor	S10B80.BANINST1.GB_GTVDPRP	Use (select)Rely On
F_CODE_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_GTVDPRP	Rely On
F_GET_DESCRIPTION	Oracle Package Function	S10B80.BANINST1.GB_GTVDPRP	Rely On
GTVDPRP	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_GTVDPRP	SQL Index	S10B80.GENERAL	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GTVDPRP

Object Dates

Creation Date	Analysis Date
04/02/2008 20:29:46:000	04/02/2008 21:17:53:000

Source Code Comments

Step Property Validation Table

Columns Comments for GTVDPRP_CODE (# 1)

Source Code Comments

STEP PROPERTY CODE: The unique step property code.

Columns Comments for GTVDPRP_DESC (# 2)

Source Code Comments

STEP PROPERTY DESCRIPTION: Description of the step property.

Columns Comments for GTVDPRP_USER_ID (# 3)

Source Code Comments

USER ID: The unique identification code of the user.

Columns Comments for GTVDPRP_ACTIVITY_DATE (# 4)

Source Code Comments

ACTIVITY DATE: The date the information for the table on the record was entered or last updated.

Table GTVDSTP

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GTVDSTP_CODE	VARCHAR2(15)	No	*
GTVDSTP_DESC	VARCHAR2(30)	No
GTVDSTP_USER_ID	VARCHAR2(30)	No
GTVDSTP_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GTVDSTP	Unique	GTVDSTP_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GORDSTE	SQL Table	S10B80.GENERAL	Refer (no action)
GORDSTP	SQL Table	S10B80.GENERAL	Refer (no action)
GTVDSTP_C	Oracle Package Cursor	S10B80.BANINST1.GB_GTVDSTP	Rely On
GTVDSTP_C	Oracle Package Cursor	S10B80.BANINST1.GB_GTVDSTP	Use (select)Rely On
F_CODE_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_GTVDSTP	Rely On
F_GET_DESCRIPTION	Oracle Package Function	S10B80.BANINST1.GB_GTVDSTP	Rely On
GTVDSTP	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_GTVDSTP	SQL Index	S10B80.GENERAL	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GTVDSTP

Object Dates

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

Source Code Comments

Step Type code Validation Table

Columns Comments for GTVDSTP_CODE (# 1)

Source Code Comments

STEP TYPE CODE: The unique step type Code for the Wizard step which defines its properties.

Columns Comments for GTVDSTP_DESC (# 2)

Source Code Comments

STEP TYPE DESCRIPTION: Description of the Data Lookup.

Columns Comments for GTVDSTP_USER_ID (# 3)

Source Code Comments

USER ID: The unique identification code of the user.

Columns Comments for GTVDSTP_ACTIVITY_DATE (# 4)

Source Code Comments

ACTIVITY DATE: The date the information for the table on the record was entered or last updated.

Link between GORDWIZ and GORDSEC

Join Information

Objects list
scope-procedure : S10B80.BANINST1.GOKDTOP.P_USER_SECURITY_WIZARD

Link List

Link Type	Link	Project
Join	Link Between GORDWIZ and GORDSEC	GENERAL

List of Real links

Link type	Between	And
Join	GORDWIZ	GORDSEC

Link between GORDSEC and GTVDADD

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GORDSEC and GTVDADD (FK1_GORDSEC_INV_GTVDADD_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GORDSEC	GORDSEC_DADD_CODE	GTVDADD_CODE	GTVDADD	(1,1)-(0,n)

Link between GORDSPR and GTVDADD

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GORDSPR and GTVDADD (FK1_GORDSPR_INV_GTVDADD_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GORDSPR	GORDSPR_DADD_CODE	GTVDADD_CODE	GTVDADD	(1,1)-(0,n)

Link between GORDSPR and GTVDPRP

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GORDSPR and GTVDPRP (FK1_GORDSPR_INV_GTVDPRP_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GORDSPR	GORDSPR_DPRP_CODE	GTVDPRP_CODE	GTVDPRP	(1,1)-(0,n)

Link between GORDSTE and GTVDADD

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GORDSTE and GTVDADD (FK1_GORDSTE_INV_GTVDADD_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GORDSTE	GORDSTE_DADD_CODE	GTVDADD_CODE	GTVDADD	(1,1)-(0,n)

Link between GORDSTP and GTVDPRP

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GORDSTP and GTVDPRP (FK1_GORDSTP_INV_GTVDPRP_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GORDSTP	GORDSTP_DPRP_CODE	GTVDPRP_CODE	GTVDPRP	(1,1)-(0,n)

Link between GORDLUP and GTVDADD

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GORDLUP and GTVDADD (FK1_GORDLUP_INV_GTVDADD_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GORDLUP	GORDLUP_DADD_CODE	GTVDADD_CODE	GTVDADD	(1,1)-(0,n)

Link between GORDSTE and GTVDSTP

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GORDSTE and GTVDSTP (FK1_GORDSTE_INV_GTVDSTP_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GORDSTE	GORDSTE_DSTP_CODE	GTVDSTP_CODE	GTVDSTP	(1,1)-(0,n)

Link between GORDSTP and GTVDSTP

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GORDSTP and GTVDSTP (FK1_GORDSTP_INV_GTVDSTP_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GORDSTP	GORDSTP_DSTP_CODE	GTVDSTP_CODE	GTVDSTP	(1,1)-(0,n)

Link between GORDWIZ and GTVDADD

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GORDWIZ and GTVDADD (FK1_GORDWIZ_INV_GTVDADD_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GORDWIZ	GORDWIZ_DADD_CODE	GTVDADD_CODE	GTVDADD	(1,1)-(0,n)

Link between GORDPRP and GTVDPRP

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GORDPRP and GTVDPRP (FK1_GORDPRP_INV_GTVDPRP_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GORDPRP	GORDPRP_DPRP_CODE	GTVDPRP_CODE	GTVDPRP	(1,1)-(0,n)