Model Desktop Tools

Model Label : Banner General Desktop Tools
Path : Default Folder/B70/General/Desktop_Tools

List of Objects

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

Comments

Model View

Table GORDLUP

Schema Name GENERAL
Label GORDLUP
Server name S4B70
Creation Date 09/29/2003 12:04:33:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
GORDLUP_DADD_CODE	GORDLUP_DADD_CODE	VARCHAR2(15)	No	*	*
GORDLUP_LOOKUP_NAME	GORDLUP_LOOKUP_NAME	VARCHAR2(15)	No	*
GORDLUP_LOOKUP_DESCRIPTION	GORDLUP_LOOKUP_DESCRIPTION	VARCHAR2(60)	No
GORDLUP_MENU_SEQNO	GORDLUP_MENU_SEQNO	NUMBER(5,2)	No
GORDLUP_FINAID_IND	GORDLUP_FINAID_IND	VARCHAR2(1)	No
GORDLUP_POSBUD_IND	GORDLUP_POSBUD_IND	VARCHAR2(1)	No
GORDLUP_BILCSH_IND	GORDLUP_BILCSH_IND	VARCHAR2(1)	No
GORDLUP_HUMANRE_IND	GORDLUP_HUMANRE_IND	VARCHAR2(1)	No
GORDLUP_FINANCE_IND	GORDLUP_FINANCE_IND	VARCHAR2(1)	No
GORDLUP_ALUMNI_IND	GORDLUP_ALUMNI_IND	VARCHAR2(1)	No
GORDLUP_STUDENT_IND	GORDLUP_STUDENT_IND	VARCHAR2(1)	No
GORDLUP_USER_ID	GORDLUP_USER_ID	VARCHAR2(30)	No
GORDLUP_ACTIVITY_DATE	GORDLUP_ACTIVITY_DATE	DATE	No
GORDLUP_LOAD_FUNCTION	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
GORDLUP	SYNONYM	S4B70.PUBLIC	Rely on ()
P_LOOKUP_PROPERTIES	Package procedure	S4B70.BANINST1.GOKDTOP	Rely on ()
P_LOOKUP_PROPERTIES	Package procedure	S4B70.BANINST1.GOKDTOP	Use(select )
GORDLUP	Forms DataBlock	BANNER7_FORMS.GOADADD	Rely on () Use(insert,update,delete,select )
GORDLUP	Forms DataBlock	BANNER7_FORMS_10G.GOADADD	Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

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

Comments

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

Schema Name GENERAL
Label GORDPRP
Server name S4B70
Creation Date 09/29/2003 12:04:33:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
GORDPRP_DPRP_CODE	GORDPRP_DPRP_CODE	VARCHAR2(15)	No	*	*
GORDPRP_VALUE_NAME	GORDPRP_VALUE_NAME	VARCHAR2(15)	No	*
GORDPRP_VALUE_DESCRIPTION	GORDPRP_VALUE_DESCRIPTION	VARCHAR2(30)	No
GORDPRP_USER_ID	GORDPRP_USER_ID	VARCHAR2(30)	No
GORDPRP_ACTIVITY_DATE	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)

Object Name	Object Type	Parent Name	Link Type
GORDPRP	SYNONYM	S4B70.PUBLIC	Rely on ()
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS.GOADSTE.GORDSPR.GORDSPR_VALUE	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS_10G.GOADSTE.GORDSPR.GORDSPR_VALUE	Use(select )
GORDPRP_RG	Forms Record Group	BANNER7_FORMS.GOADSTE	Use(select )
GORDPRP_RG	Forms Record Group	BANNER7_FORMS_10G.GOADSTE	Use(select )
CHECK_GORDPRP_VALUES	Forms Trigger	BANNER7_FORMS.GOADSTE.GORDSPR	Use(select )
CHECK_GORDPRP_VALUES	Forms Trigger	BANNER7_FORMS_10G.GOADSTE.GORDSPR	Use(select )
GORDPRP	Forms DataBlock	BANNER7_FORMS.GORDPRP	Rely on () Use(insert,update,delete,select )
GORDPRP	Forms DataBlock	BANNER7_FORMS_10G.GORDPRP	Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

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

Comments

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

Schema Name GENERAL
Label GORDSEC
Server name S4B70
Creation Date 09/29/2003 12:04:33:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
GORDSEC_RECIPIENT_USER_ID	GORDSEC_RECIPIENT_USER_ID	VARCHAR2(30)	No	*
GORDSEC_DADD_CODE	GORDSEC_DADD_CODE	VARCHAR2(15)	No	*	*
GORDSEC_WIZARD_NAME	GORDSEC_WIZARD_NAME	VARCHAR2(15)	No	*
GORDSEC_USER_ID	GORDSEC_USER_ID	VARCHAR2(30)	No
GORDSEC_ACTIVITY_DATE	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
GORDSEC	SYNONYM	S4B70.PUBLIC	Rely on ()
WHEN-BUTTON-PRESSED	Forms Trigger	BANNER7_FORMS.GORDSEC.BUTTON_CONTROL_BLOCK.COPY_USER_ID_LBT	Use(insert,select )
WHEN-BUTTON-PRESSED	Forms Trigger	BANNER7_FORMS_10G.GORDSEC.BUTTON_CONTROL_BLOCK.COPY_USER_ID_LBT	Use(insert,select )
MNU_DELETE_USER_INFO	Forms Trigger	BANNER7_FORMS.GORDSEC	Use(delete )
MNU_DELETE_USER_INFO	Forms Trigger	BANNER7_FORMS_10G.GORDSEC	Use(delete )
P_USER_SECURITY_WIZARD	Package procedure	S4B70.BANINST1.GOKDTOP	Use(select )
GORDSEC	Forms DataBlock	BANNER7_FORMS.GORDSEC	Rely on () Use(insert,update,delete,select )
GORDSEC	Forms DataBlock	BANNER7_FORMS_10G.GORDSEC	Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

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

Comments

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

Schema Name GENERAL
Label GORDSPR
Server name S4B70
Creation Date 09/29/2003 12:04:33:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
GORDSPR_DADD_CODE	GORDSPR_DADD_CODE	VARCHAR2(15)	No	*	*
GORDSPR_WIZARD_NAME	GORDSPR_WIZARD_NAME	VARCHAR2(15)	No	*
GORDSPR_STEP_NAME	GORDSPR_STEP_NAME	VARCHAR2(30)	No	*
GORDSPR_DPRP_CODE	GORDSPR_DPRP_CODE	VARCHAR2(15)	No	*	*
GORDSPR_USER_ID	GORDSPR_USER_ID	VARCHAR2(30)	No
GORDSPR_ACTIVITY_DATE	GORDSPR_ACTIVITY_DATE	DATE	No
GORDSPR_VALUE	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)

Object Name	Object Type	Parent Name	Link Type
GORDSPR	SYNONYM	S4B70.PUBLIC	Rely on ()
CHECK_REQUIRED_PROPERTIES	Forms Trigger	BANNER7_FORMS.GOADSTE	Use(select )
CHECK_REQUIRED_PROPERTIES	Forms Trigger	BANNER7_FORMS_10G.GOADSTE	Use(select )
WHEN_NEW_BLOCK_INSTANCE_TRG	Forms Trigger	BANNER7_FORMS.GOADSTE	Use(insert,select )
WHEN_NEW_BLOCK_INSTANCE_TRG	Forms Trigger	BANNER7_FORMS_10G.GOADSTE	Use(insert,select )
ON-CHECK-DELETE-MASTER	Forms Trigger	BANNER7_FORMS.GOADSTE.GORDSTE	Use(delete )
ON-CHECK-DELETE-MASTER	Forms Trigger	BANNER7_FORMS_10G.GOADSTE.GORDSTE	Use(delete )
PRE-DELETE	Forms Trigger	BANNER7_FORMS.GOADSTE.GORDSTE	Use(delete )
PRE-DELETE	Forms Trigger	BANNER7_FORMS_10G.GOADSTE.GORDSTE	Use(delete )
PRE-INSERT	Forms Trigger	BANNER7_FORMS.GOADSTE.GORDSTE	Use(insert,select )
PRE-INSERT	Forms Trigger	BANNER7_FORMS_10G.GOADSTE.GORDSTE	Use(insert,select )
PRE-UPDATE	Forms Trigger	BANNER7_FORMS.GOADSTE.GORDSTE	Use(update )
PRE-UPDATE	Forms Trigger	BANNER7_FORMS_10G.GOADSTE.GORDSTE	Use(update )
GORDSPR	Forms DataBlock	BANNER7_FORMS.GOADSTE	Rely on () Use(insert,update,delete,select )
GORDSPR	Forms DataBlock	BANNER7_FORMS_10G.GOADSTE	Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GORDSPR	INDEX	S4B70."GENERAL"	Rely on ()
GTVDADD	TABLE	S4B70."GENERAL"	Refer( No Action )
GTVDPRP	TABLE	S4B70."GENERAL"	Refer( No Action )

Comments

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

Schema Name GENERAL
Label GORDSTE
Server name S4B70
Creation Date 09/29/2003 12:04:33:000

Table Columns information

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

Foreign Key information

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

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
GORDSTE	SYNONYM	S4B70.PUBLIC	Rely on ()
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS.GOADSTE.GORDSTE.GORDSTE_STEP_NAME	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS_10G.GOADSTE.GORDSTE.GORDSTE_STEP_NAME	Use(select )
ENABLE_ITEMS	Forms Trigger	BANNER7_FORMS.GOADSTE.GORDSTE	Use(select )
ENABLE_ITEMS	Forms Trigger	BANNER7_FORMS_10G.GOADSTE.GORDSTE	Use(select )
P_STEP_TYPE	Package procedure	S4B70.BANINST1.GOKDTOP	Rely on ()
P_STEP_TYPE	Package procedure	S4B70.BANINST1.GOKDTOP	Use(select )
GORDSTE	Forms DataBlock	BANNER7_FORMS.GOADSTE	Rely on () Use(insert,update,delete,select )
GORDSTE	Forms DataBlock	BANNER7_FORMS_10G.GOADSTE	Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GORDSTE	INDEX	S4B70."GENERAL"	Rely on ()
GTVDADD	TABLE	S4B70."GENERAL"	Refer( No Action )
GTVDSTP	TABLE	S4B70."GENERAL"	Refer( No Action )

Comments

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

Schema Name GENERAL
Label GORDSTP
Server name S4B70
Creation Date 09/29/2003 12:04:33:000

Table Columns information

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

Foreign Key information

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

Index

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

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GORDSTP	SYNONYM	S4B70.PUBLIC	Rely on ()
POST-CHANGE	Forms Trigger	BANNER7_FORMS.GOADSTE.GORDSPR.GORDSPR_DPRP_CODE	Rely on () Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.GOADSTE.GORDSPR.GORDSPR_DPRP_CODE	Rely on () Use(select )
CHECK_REQUIRED_PROPERTIES	Forms Trigger	BANNER7_FORMS.GOADSTE	Use(select )
CHECK_REQUIRED_PROPERTIES	Forms Trigger	BANNER7_FORMS_10G.GOADSTE	Use(select )
WHEN_NEW_BLOCK_INSTANCE_TRG	Forms Trigger	BANNER7_FORMS.GOADSTE	Use(select )
WHEN_NEW_BLOCK_INSTANCE_TRG	Forms Trigger	BANNER7_FORMS_10G.GOADSTE	Use(select )
GORDSTP_RG	Forms Record Group	BANNER7_FORMS.GOADSTE	Use(select )
GORDSTP_RG	Forms Record Group	BANNER7_FORMS_10G.GOADSTE	Use(select )
PRE-INSERT	Forms Trigger	BANNER7_FORMS.GOADSTE.GORDSTE	Use(select )
PRE-INSERT	Forms Trigger	BANNER7_FORMS_10G.GOADSTE.GORDSTE	Use(select )
GORDSTP	Forms DataBlock	BANNER7_FORMS.GORDSTP	Rely on () Use(insert,update,delete,select )
GORDSTP	Forms DataBlock	BANNER7_FORMS_10G.GORDSTP	Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GORDSTP	INDEX	S4B70."GENERAL"	Rely on ()
GTVDPRP	TABLE	S4B70."GENERAL"	Refer( No Action )
GTVDSTP	TABLE	S4B70."GENERAL"	Refer( No Action )

Comments

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

Schema Name GENERAL
Label GORDWIZ
Server name S4B70
Creation Date 09/29/2003 12:04:33:000

Table Columns information

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

Foreign Key information

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

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
GORDWIZ	SYNONYM	S4B70.PUBLIC	Rely on ()
POST-CHANGE	Forms Trigger	BANNER7_FORMS.GOADSTE.KEY_BLOCK.ADDIN_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.GOADSTE.KEY_BLOCK.WIZARD_NAME	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.GOADSTE.KEY_BLOCK.ADDIN_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.GORDSEC.GORDSEC.GORDSEC_WIZARD_NAME	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.GORDSEC.GORDSEC.GORDSEC_WIZARD_NAME	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.GOADSTE.KEY_BLOCK.WIZARD_NAME	Use(select )
GORDWIZ_RG	Forms Record Group	BANNER7_FORMS.GOQOLIB	Use(select )
GORDWIZ_RG	Forms Record Group	BANNER7_FORMS.GOADSTE	Use(select )
GORDWIZ_RG	Forms Record Group	BANNER7_FORMS_10G.GOQOLIB	Use(select )
GORDWIZ_RG	Forms Record Group	BANNER7_FORMS_10G.GORDSEC	Use(select )
GORDWIZ_RG	Forms Record Group	BANNER7_FORMS_10G.GOADSTE	Use(select )
GORDWIZ_RG	Forms Record Group	BANNER7_FORMS.GORDSEC	Use(select )
GTVDADD_GORDWIZ_RG	Forms Record Group	BANNER7_FORMS.GOQOLIB	Use(select )
GTVDADD_GORDWIZ_RG	Forms Record Group	BANNER7_FORMS_10G.GORDSEC	Use(select )
GTVDADD_GORDWIZ_RG	Forms Record Group	BANNER7_FORMS_10G.GOADSTE	Use(select )
GTVDADD_GORDWIZ_RG	Forms Record Group	BANNER7_FORMS_10G.GOQOLIB	Use(select )
GTVDADD_GORDWIZ_RG	Forms Record Group	BANNER7_FORMS.GOADSTE	Use(select )
GTVDADD_GORDWIZ_RG	Forms Record Group	BANNER7_FORMS.GORDSEC	Use(select )
P_USER_SECURITY_WIZARD	Package procedure	S4B70.BANINST1.GOKDTOP	Use(select )
P_WIZARD_PROPERTIES	Package procedure	S4B70.BANINST1.GOKDTOP	Rely on ()
P_WIZARD_PROPERTIES	Package procedure	S4B70.BANINST1.GOKDTOP	Use(select )
F_GETADDINDESCRIPTION	Package function	S4B70.BANINST1.GOKEDVD	Use(select )
F_GETWIZARDDESCRIPTION	Package function	S4B70.BANINST1.GOKEDVD	Rely on ()
F_GETWIZARDDESCRIPTION	Package function	S4B70.BANINST1.GOKEDVD	Use(select )
F_VALIDATEADDINCODE	Package function	S4B70.BANINST1.GOKEDVD	Use(select )
F_VALIDATEWIZARD	Package function	S4B70.BANINST1.GOKEDVD	Rely on ()
F_VALIDATEWIZARD	Package function	S4B70.BANINST1.GOKEDVD	Use(select )
GORDWIZ	Forms DataBlock	BANNER7_FORMS.GOADADD	Rely on () Use(insert,update,delete,select )
GORDWIZ	Forms DataBlock	BANNER7_FORMS_10G.GOADADD	Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

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

Comments

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

Schema Name GENERAL
Label GTVDADD
Server name S4B70
Creation Date 09/29/2003 12:04:34:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
GTVDADD_CODE	GTVDADD_CODE	VARCHAR2(15)	No	*
GTVDADD_DESC	GTVDADD_DESC	VARCHAR2(30)	No
GTVDADD_USER_ID	GTVDADD_USER_ID	VARCHAR2(30)	No
GTVDADD_ACTIVITY_DATE	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
GTVDADD	SYNONYM	S4B70.PUBLIC	Rely on ()
GORDLUP	TABLE	S4B70."GENERAL"	Refer( No Action )
GORDSEC	TABLE	S4B70."GENERAL"	Refer( No Action )
GORDSPR	TABLE	S4B70."GENERAL"	Refer( No Action )
GORDSTE	TABLE	S4B70."GENERAL"	Refer( No Action )
GORDWIZ	TABLE	S4B70."GENERAL"	Refer( No Action )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.GOADSTE.KEY_BLOCK.ADDIN_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.GORDSEC.GORDSEC.GORDSEC_DADD_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.GOADADD.KEY_BLOCK.ADDIN_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.GORDSEC.GORDSEC.GORDSEC_DADD_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.GOADSTE.KEY_BLOCK.ADDIN_CODE	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS_10G.GOADADD.KEY_BLOCK.ADDIN_CODE	Use(select )
GTVDADD_GORDWIZ_RG	Forms Record Group	BANNER7_FORMS.GOQOLIB	Use(select )
GTVDADD_GORDWIZ_RG	Forms Record Group	BANNER7_FORMS.GOADSTE	Use(select )
GTVDADD_GORDWIZ_RG	Forms Record Group	BANNER7_FORMS.GORDSEC	Use(select )
GTVDADD_GORDWIZ_RG	Forms Record Group	BANNER7_FORMS_10G.GOQOLIB	Use(select )
GTVDADD_GORDWIZ_RG	Forms Record Group	BANNER7_FORMS_10G.GORDSEC	Use(select )
GTVDADD_GORDWIZ_RG	Forms Record Group	BANNER7_FORMS_10G.GOADSTE	Use(select )
GTVDADD_RG	Forms Record Group	BANNER7_FORMS.GOQOLIB	Use(select )
GTVDADD_RG	Forms Record Group	BANNER7_FORMS.GOADADD	Use(select )
GTVDADD_RG	Forms Record Group	BANNER7_FORMS_10G.GOADADD	Use(select )
GTVDADD_RG	Forms Record Group	BANNER7_FORMS_10G.GOQOLIB	Use(select )
P_WIZARD_PROPERTIES	Package procedure	S4B70.BANINST1.GOKDTOP	Rely on ()
P_WIZARD_PROPERTIES	Package procedure	S4B70.BANINST1.GOKDTOP	Use(select )
GTVDADD_C	Package cursor	S4B70.BANINST1.GB_GTVDADD	Rely on ()
GTVDADD_C	Package cursor	S4B70.BANINST1.GB_GTVDADD	Rely on () Use(select )
F_CODE_EXISTS	Package function	S4B70.BANINST1.GB_GTVDADD	Rely on ()
F_CODE_EXISTS	Package function	S4B70.BANINST1.GB_GTVDADD	Rely on ()
F_GETADDINDESCRIPTION	Package function	S4B70.BANINST1.GOKEDVD	Rely on ()
F_GETADDINDESCRIPTION	Package function	S4B70.BANINST1.GOKEDVD	Use(select )
F_GETWIZARDDESCRIPTION	Package function	S4B70.BANINST1.GOKEDVD	Rely on ()
F_GET_DESCRIPTION	Package function	S4B70.BANINST1.GB_GTVDADD	Rely on ()
F_GET_DESCRIPTION	Package function	S4B70.BANINST1.GB_GTVDADD	Rely on ()
F_VALIDATEADDINCODE	Package function	S4B70.BANINST1.GOKEDVD	Rely on ()
F_VALIDATEADDINCODE	Package function	S4B70.BANINST1.GOKEDVD	Use(select )
F_VALIDATEDADD	Package function	S4B70.BANINST1.GOKEDVD	Rely on ()
F_VALIDATEDADD	Package function	S4B70.BANINST1.GOKEDVD	Use(select )
F_VALIDATEWIZARD	Package function	S4B70.BANINST1.GOKEDVD	Rely on ()
GTVDADD	Forms DataBlock	BANNER7_FORMS.GTVDADD	Rely on () Use(insert,update,delete,select )
GTVDADD	Forms DataBlock	BANNER7_FORMS_10G.GTVDADD	Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

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

Comments

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

Schema Name GENERAL
Label GTVDPRP
Server name S4B70
Creation Date 09/29/2003 12:04:34:000

Table Columns information

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