GORDLUP GORDPRP GORDSEC GORDSPR GORDSTE GORDSTP GORDWIZ GTVDADD GTVDPRP GTVDSTP

Model Desktop Tools


Model Label : Banner General Desktop Tools
Path : BANNER DEV/General/ERD/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 MALDEV8_B60
Creation Date 04/15/2002 18:04:28: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

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 MALDEV8_B60
Creation Date 04/15/2002 18:04:28: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

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 MALDEV8_B60
Creation Date 04/15/2002 18:04:28: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

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 MALDEV8_B60
Creation Date 04/15/2002 18:04:28: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

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 MALDEV8_B60
Creation Date 04/15/2002 18:04:28: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

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 MALDEV8_B60
Creation Date 04/15/2002 18:04:28: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

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 MALDEV8_B60
Creation Date 04/15/2002 18:04:28:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GORDWIZ_DADD_CODE GORDWIZ_DADD_CODE VARCHAR2(15) No * *
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
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

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 MALDEV8_B60
Creation Date 04/15/2002 18:04:32:000

Table Columns information

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

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 MALDEV8_B60
Creation Date 04/15/2002 18:04:33:000

Table Columns information

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

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_GTVDPRP Unique GTVDPRP_CODE

Comments

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

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

Table Columns information

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

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_GTVDSTP Unique GTVDSTP_CODE

Comments

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

Caller : GORDWIZ
Called : GORDSEC

Join Information

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

Link List

Link Type Link Project
Join Link Between GORDWIZ and GORDSEC GENERAL

Link Between GORDWIZ and GORDSEC

Caller : GORDWIZ
Called : GORDSEC
Link Type : Join
Link : Link Between GORDWIZ and GORDSEC

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
GORDWIZ GORDWIZ_DADD_CODE GORDSEC_DADD_CODE GORDSEC (0,1)-(0,1)
GORDWIZ GORDWIZ_WIZARD_NAME GORDSEC_WIZARD_NAME GORDSEC (0,1)-(0,1)

Comments

Link between GORDSEC and GTVDADD

Caller : GORDSEC
Called : GTVDADD

Link List

Link Type Link Project
Refer(No Action ) Link Foreign Key Between GORDSEC and GTVDADD GENERAL

Link Foreign Key Between GORDSEC and GTVDADD

Caller : GORDSEC
Called : GTVDADD
Link Type : Refer(No Action )
Link : Link Foreign Key Between GORDSEC and GTVDADD

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)

Comments

Link between GORDSPR and GTVDADD

Caller : GORDSPR
Called : GTVDADD

Link List

Link Type Link Project
Refer(No Action ) Link Foreign Key Between GORDSPR and GTVDADD GENERAL

Link Foreign Key Between GORDSPR and GTVDADD

Caller : GORDSPR
Called : GTVDADD
Link Type : Refer(No Action )
Link : Link Foreign Key Between GORDSPR and GTVDADD

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)

Comments

Link between GORDSPR and GTVDPRP

Caller : GORDSPR
Called : GTVDPRP

Link List

Link Type Link Project
Refer(No Action ) Link Foreign Key Between GORDSPR and GTVDPRP GENERAL

Link Foreign Key Between GORDSPR and GTVDPRP

Caller : GORDSPR
Called : GTVDPRP
Link Type : Refer(No Action )
Link : Link Foreign Key Between GORDSPR and GTVDPRP

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)

Comments

Link between GORDSTE and GTVDADD

Caller : GORDSTE
Called : GTVDADD

Link List

Link Type Link Project
Refer(No Action ) Link Foreign Key Between GORDSTE and GTVDADD GENERAL

Link Foreign Key Between GORDSTE and GTVDADD

Caller : GORDSTE
Called : GTVDADD
Link Type : Refer(No Action )
Link : Link Foreign Key Between GORDSTE and GTVDADD

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)

Comments

Link between GORDSTP and GTVDPRP

Caller : GORDSTP
Called : GTVDPRP

Link List

Link Type Link Project
Refer(No Action ) Link Foreign Key Between GORDSTP and GTVDPRP GENERAL

Link Foreign Key Between GORDSTP and GTVDPRP

Caller : GORDSTP
Called : GTVDPRP
Link Type : Refer(No Action )
Link : Link Foreign Key Between GORDSTP and GTVDPRP

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)

Comments

Link between GORDLUP and GTVDADD

Caller : GORDLUP
Called : GTVDADD

Link List

Link Type Link Project
Refer(No Action ) Link Foreign Key Between GORDLUP and GTVDADD GENERAL

Link Foreign Key Between GORDLUP and GTVDADD

Caller : GORDLUP
Called : GTVDADD
Link Type : Refer(No Action )
Link : Link Foreign Key Between GORDLUP and GTVDADD

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)

Comments

Link between GORDSTE and GTVDSTP

Caller : GORDSTE
Called : GTVDSTP

Link List

Link Type Link Project
Refer(No Action ) Link Foreign Key Between GORDSTE and GTVDSTP GENERAL

Link Foreign Key Between GORDSTE and GTVDSTP

Caller : GORDSTE
Called : GTVDSTP
Link Type : Refer(No Action )
Link : Link Foreign Key Between GORDSTE and GTVDSTP

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)

Comments

Link between GORDSTP and GTVDSTP

Caller : GORDSTP
Called : GTVDSTP

Link List

Link Type Link Project
Refer(No Action ) Link Foreign Key Between GORDSTP and GTVDSTP GENERAL

Link Foreign Key Between GORDSTP and GTVDSTP

Caller : GORDSTP
Called : GTVDSTP
Link Type : Refer(No Action )
Link : Link Foreign Key Between GORDSTP and GTVDSTP

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)

Comments

Link between GORDWIZ and GTVDADD

Caller : GORDWIZ
Called : GTVDADD

Link List

Link Type Link Project
Refer(No Action ) Link Foreign Key Between GORDWIZ and GTVDADD GENERAL

Link Foreign Key Between GORDWIZ and GTVDADD

Caller : GORDWIZ
Called : GTVDADD
Link Type : Refer(No Action )
Link : Link Foreign Key Between GORDWIZ and GTVDADD

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)

Comments

Link between GORDPRP and GTVDPRP

Caller : GORDPRP
Called : GTVDPRP

Link List

Link Type Link Project
Refer(No Action ) Link Foreign Key Between GORDPRP and GTVDPRP GENERAL

Link Foreign Key Between GORDPRP and GTVDPRP

Caller : GORDPRP
Called : GTVDPRP
Link Type : Refer(No Action )
Link : Link Foreign Key Between GORDPRP and GTVDPRP

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)

Comments