GORRSQL GORSQPA GORSVSQ GTVSQPA GTVSQPR GTVSQRU GTVSVAP GTVSVBA

Model Business Rule Builder


Model Label : Banner General Business Rule Builder
Path : BANNER DEV/General/ERD/Business Rule Builder

List of Objects

Object Name Object Type Layer Name
GORRSQL TABLE Default
GORSQPA TABLE Default
GORSVSQ TABLE Default
GTVSQPA TABLE Default
GTVSQPR TABLE Default
GTVSQRU TABLE Default
GTVSVAP TABLE Default
GTVSVBA TABLE Default

Comments

Model View

''

Table GORRSQL

Schema Name GENERAL
Label GORRSQL
Server name MALDEV8_B60
Creation Date 07/01/2003 14:22:19:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GORRSQL_SQPR_CODE GORRSQL_SQPR_CODE VARCHAR2(30) No * *
GORRSQL_SQRU_CODE GORRSQL_SQRU_CODE VARCHAR2(30) No * *
GORRSQL_SEQ_NO GORRSQL_SEQ_NO NUMBER(5,0) No *
GORRSQL_ACTIVE_IND GORRSQL_ACTIVE_IND VARCHAR2(1) No
GORRSQL_VALIDATED_IND GORRSQL_VALIDATED_IND VARCHAR2(1) No
GORRSQL_START_DATE GORRSQL_START_DATE DATE No
GORRSQL_SELECT_FROM GORRSQL_SELECT_FROM VARCHAR2(4000) No
GORRSQL_ACTIVITY_DATE GORRSQL_ACTIVITY_DATE DATE No
GORRSQL_USER_ID GORRSQL_USER_ID VARCHAR2(30) No
GORRSQL_SELECT_VALUE GORRSQL_SELECT_VALUE VARCHAR2(4000) Yes
GORRSQL_WHERE_CLAUSE GORRSQL_WHERE_CLAUSE CLOB Yes
GORRSQL_END_DATE GORRSQL_END_DATE DATE Yes
GORRSQL_PARSED_SQL GORRSQL_PARSED_SQL CLOB Yes

Foreign Key information

Column name is Foreign Key For Column on Table
GORRSQL_SQPR_CODE GTVSQPR_CODE GTVSQPR
GORRSQL_SQRU_CODE GTVSQRU_CODE GTVSQRU

Index

Index Name Index Type Column Name
PK_GORRSQL Unique GORRSQL_SQPR_CODE
PK_GORRSQL Unique GORRSQL_SQRU_CODE
PK_GORRSQL Unique GORRSQL_SEQ_NO

Comments

Source Code Comments

SQL Process Rules Table

Columns Comments for GORRSQL_SQPR_CODE (1)

Source Code Comments

SQL PROCESS CODE: Process code for dynamic SQL processing.

Columns Comments for GORRSQL_SQRU_CODE (2)

Source Code Comments

SQL RULE CODE: Rule code for dynamic SQL processing.

Columns Comments for GORRSQL_SEQ_NO (3)

Source Code Comments

SQL RULE SEQUENCE NUMBER: Sequence for SEVIS SQL rule for uniqueness and process order.

Columns Comments for GORRSQL_ACTIVE_IND (4)

Source Code Comments

ACTIVE INDICATOR: Indicator to show if the rule is currently active.

Columns Comments for GORRSQL_VALIDATED_IND (5)

Source Code Comments

VALIDATED INDICATOR: Indicator to show if the SQL has been validated.

Columns Comments for GORRSQL_START_DATE (6)

Source Code Comments

START DATE: Date that the rule becomes effective.

Columns Comments for GORRSQL_SELECT_FROM (7)

Source Code Comments

SELECT FROM VALUE: Tables and views that are in the FROM portion of the SQL statement.

Columns Comments for GORRSQL_ACTIVITY_DATE (8)

Source Code Comments

ACTIVITY DATE: The most recent date a record was created or updated

Columns Comments for GORRSQL_USER_ID (9)

Source Code Comments

USER ID: The most recent user to create or update a record.

Columns Comments for GORRSQL_SELECT_VALUE (10)

Source Code Comments

SELECT VALUE: Value that is in the SELECT portion of the SQL statement.

Columns Comments for GORRSQL_WHERE_CLAUSE (11)

Source Code Comments

WHERE CLAUSE: WHERE clause of the SQL statement.

Columns Comments for GORRSQL_END_DATE (12)

Source Code Comments

END DATE: Date that the rule becomes obsolete.

Columns Comments for GORRSQL_PARSED_SQL (13)

Source Code Comments

PARSED SQL: Parsed SQL statement.

Table GORSQPA

Schema Name GENERAL
Label GORSQPA
Server name MALDEV8_B60
Creation Date 06/06/2003 11:03:25:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GORSQPA_SQPR_CODE GORSQPA_SQPR_CODE VARCHAR2(30) No * *
GORSQPA_SQPA_CODE GORSQPA_SQPA_CODE VARCHAR2(30) No * *
GORSQPA_SYS_REQ_IND GORSQPA_SYS_REQ_IND VARCHAR2(1) No
GORSQPA_ACTIVITY_DATE GORSQPA_ACTIVITY_DATE DATE No
GORSQPA_USER_ID GORSQPA_USER_ID VARCHAR2(30) No

Foreign Key information

Column name is Foreign Key For Column on Table
GORSQPA_SQPA_CODE GTVSQPA_CODE GTVSQPA
GORSQPA_SQPR_CODE GTVSQPR_CODE GTVSQPR

Index

Index Name Index Type Column Name
PK_GORSQPA Unique GORSQPA_SQPR_CODE
PK_GORSQPA Unique GORSQPA_SQPA_CODE

Comments

Source Code Comments

SQL Process Parameter Table

Columns Comments for GORSQPA_SQPR_CODE (1)

Source Code Comments

PROCESS CODE: SQL Process code

Columns Comments for GORSQPA_SQPA_CODE (2)

Source Code Comments

PARAMETER CODE: Parameter code associated with the SQL process code.

Columns Comments for GORSQPA_SYS_REQ_IND (3)

Source Code Comments

SYSTEM REQUIRED INDICATOR: Indicates whether or not this parameter is system required.

Columns Comments for GORSQPA_ACTIVITY_DATE (4)

Source Code Comments

ACTIVITY DATE: The most recent date a record was created or updated

Columns Comments for GORSQPA_USER_ID (5)

Source Code Comments

USER ID: The most recent user to create or update a record.

Table GORSVSQ

Schema Name GENERAL
Label GORSVSQ
Server name MALDEV8_B60
Creation Date 07/01/2003 14:31:55:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GORSVSQ_SQPR_CODE GORSVSQ_SQPR_CODE VARCHAR2(30) No * *
GORSVSQ_SQRU_CODE GORSVSQ_SQRU_CODE VARCHAR2(30) No * *
GORSVSQ_SEQ_NO GORSVSQ_SEQ_NO NUMBER(5,0) No *
GORSVSQ_PROCESS_TYPE_IND GORSVSQ_PROCESS_TYPE_IND VARCHAR2(1) No
GORSVSQ_ACTIVE_IND GORSVSQ_ACTIVE_IND VARCHAR2(1) No
GORSVSQ_START_DATE GORSVSQ_START_DATE DATE No
GORSVSQ_ACTIVITY_DATE GORSVSQ_ACTIVITY_DATE DATE No
GORSVSQ_USER_ID GORSVSQ_USER_ID VARCHAR2(30) No
GORSVSQ_SVAP_CODE GORSVSQ_SVAP_CODE VARCHAR2(30) Yes *
GORSVSQ_SVBA_CODE GORSVSQ_SVBA_CODE VARCHAR2(30) Yes *
GORSVSQ_END_DATE GORSVSQ_END_DATE DATE Yes

Foreign Key information

Column name is Foreign Key For Column on Table
GORSVSQ_SQPR_CODE GTVSQPR_CODE GTVSQPR
GORSVSQ_SQRU_CODE GTVSQRU_CODE GTVSQRU
GORSVSQ_SVAP_CODE GTVSVAP_CODE GTVSVAP
GORSVSQ_SVBA_CODE GTVSVBA_CODE GTVSVBA

Index

Index Name Index Type Column Name
PK_GORSVSQ Unique GORSVSQ_SQPR_CODE
PK_GORSVSQ Unique GORSVSQ_SQRU_CODE
PK_GORSVSQ Unique GORSVSQ_SEQ_NO

Comments

Source Code Comments

SEVIS SQL Rules Table

Columns Comments for GORSVSQ_SQPR_CODE (1)

Source Code Comments

SQL PROCESS CODE: Process code for SEVIS SQL processing.

Columns Comments for GORSVSQ_SQRU_CODE (2)

Source Code Comments

SQL RULE CODE: Rule code for SEVIS SQL processing.

Columns Comments for GORSVSQ_SEQ_NO (3)

Source Code Comments

SEVIS SQL RULE SEQUENCE NUMBER: Sequence for SEVIS SQL rule for uniqueness.

Columns Comments for GORSVSQ_PROCESS_TYPE_IND (4)

Source Code Comments

SEVIS SQL PROCESS TYPE: Process type - autopopulate update or business action.

Columns Comments for GORSVSQ_ACTIVE_IND (5)

Source Code Comments

ACTIVE INDICATOR: Indicator to show if the rule is currently active.

Columns Comments for GORSVSQ_START_DATE (6)

Source Code Comments

START DATE: Date that the rule comes into effective.

Columns Comments for GORSVSQ_ACTIVITY_DATE (7)

Source Code Comments

ACTIVITY DATE: The most recent date a record was created or updated

Columns Comments for GORSVSQ_USER_ID (8)

Source Code Comments

USER ID: The most recent user to create or update a record.

Columns Comments for GORSVSQ_SVAP_CODE (9)

Source Code Comments

SEVIS AUTO-POPULATE COLUMN CODE: Name of table column to be auto-populated.

Columns Comments for GORSVSQ_SVBA_CODE (10)

Source Code Comments

SEVIS BUSINESS ACTION CODE: Code of the business action to be executed.

Columns Comments for GORSVSQ_END_DATE (11)

Source Code Comments

END DATE: Date that the rule is no longer in effect.

Table GTVSQPA

Schema Name GENERAL
Label GTVSQPA
Server name MALDEV8_B60
Creation Date 05/19/2003 13:42:06:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GTVSQPA_CODE GTVSQPA_CODE VARCHAR2(30) No *
GTVSQPA_DESC GTVSQPA_DESC VARCHAR2(60) No
GTVSQPA_DATA_TYPE_CDE GTVSQPA_DATA_TYPE_CDE VARCHAR2(1) No
GTVSQPA_START_DATE GTVSQPA_START_DATE DATE No
GTVSQPA_ACTIVITY_DATE GTVSQPA_ACTIVITY_DATE DATE No
GTVSQPA_USER_ID GTVSQPA_USER_ID VARCHAR2(30) No
GTVSQPA_END_DATE GTVSQPA_END_DATE DATE Yes

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_GTVSQPA Unique GTVSQPA_CODE

Comments

Source Code Comments

SQL Process Parameter Validation Table

Columns Comments for GTVSQPA_CODE (1)

Source Code Comments

PARAMETER CODE: Parameter code.

Columns Comments for GTVSQPA_DESC (2)

Source Code Comments

PARAMETER DESCRIPTION: Description of the parameter code.

Columns Comments for GTVSQPA_DATA_TYPE_CDE (3)

Source Code Comments

DATA TYPE INDICATOR: Indicates whether this parameter is (C)haracter, (N)umber or (D)ate.

Columns Comments for GTVSQPA_START_DATE (4)

Source Code Comments

START DATE: Date code became effective.

Columns Comments for GTVSQPA_ACTIVITY_DATE (5)

Source Code Comments

ACTIVITY DATE: The most recent date a record was created or updated

Columns Comments for GTVSQPA_USER_ID (6)

Source Code Comments

USER ID: The most recent user to create or update a record.

Columns Comments for GTVSQPA_END_DATE (7)

Source Code Comments

END DATE: Date code became obsolete.

Table GTVSQPR

Schema Name GENERAL
Label GTVSQPR
Server name MALDEV8_B60
Creation Date 07/01/2003 13:59:20:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GTVSQPR_CODE GTVSQPR_CODE VARCHAR2(30) No *
GTVSQPR_DESC GTVSQPR_DESC VARCHAR2(60) No
GTVSQPR_SYS_REQ_IND GTVSQPR_SYS_REQ_IND VARCHAR2(1) No
GTVSQPR_START_DATE GTVSQPR_START_DATE DATE No
GTVSQPR_ACTIVITY_DATE GTVSQPR_ACTIVITY_DATE DATE No
GTVSQPR_USER_ID GTVSQPR_USER_ID VARCHAR2(30) No
GTVSQPR_END_DATE GTVSQPR_END_DATE DATE Yes

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_GTVSQPR Unique GTVSQPR_CODE

Comments

Source Code Comments

Validation entries for SQL Process Codes.

Columns Comments for GTVSQPR_CODE (1)

Source Code Comments

PROCESS CODE: Process code for dynamic SQL processing.

Columns Comments for GTVSQPR_DESC (2)

Source Code Comments

PROCESS CODE DESCRIPTION: Description of SQL process code.

Columns Comments for GTVSQPR_SYS_REQ_IND (3)

Source Code Comments

SYSTEM REQUIRED INDICATOR: This field identifies whether or not this code is required by the system.

Columns Comments for GTVSQPR_START_DATE (4)

Source Code Comments

START DATE: Date code became effective.

Columns Comments for GTVSQPR_ACTIVITY_DATE (5)

Source Code Comments

ACTIVITY DATE: This field identifies the most recent date a record was created or updated.

Columns Comments for GTVSQPR_USER_ID (6)

Source Code Comments

USER ID: This field identifies the most recent user to create or update a record.

Columns Comments for GTVSQPR_END_DATE (7)

Source Code Comments

END DATE: Date code became obsolete.

Table GTVSQRU

Schema Name GENERAL
Label GTVSQRU
Server name MALDEV8_B60
Creation Date 07/01/2003 14:03:00:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GTVSQRU_CODE GTVSQRU_CODE VARCHAR2(30) No *
GTVSQRU_DESC GTVSQRU_DESC VARCHAR2(60) No
GTVSQRU_SYS_REQ_IND GTVSQRU_SYS_REQ_IND VARCHAR2(1) No
GTVSQRU_START_DATE GTVSQRU_START_DATE DATE No
GTVSQRU_ACTIVITY_DATE GTVSQRU_ACTIVITY_DATE DATE No
GTVSQRU_USER_ID GTVSQRU_USER_ID VARCHAR2(30) No
GTVSQRU_END_DATE GTVSQRU_END_DATE DATE Yes

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_GTVSQRU Unique GTVSQRU_CODE

Comments

Source Code Comments

Validation entries for SQL Rule Codes.

Columns Comments for GTVSQRU_CODE (1)

Source Code Comments

RULE CODE: Rule code for dynamic SQL rules.

Columns Comments for GTVSQRU_DESC (2)

Source Code Comments

RULE CODE DESCRIPTION: Description of dynamic SQL rule code.

Columns Comments for GTVSQRU_SYS_REQ_IND (3)

Source Code Comments

SYSTEM REQUIRED INDICATOR: This field identifies whether or not this code is required by the system.

Columns Comments for GTVSQRU_START_DATE (4)

Source Code Comments

START DATE: Date code became effective.

Columns Comments for GTVSQRU_ACTIVITY_DATE (5)

Source Code Comments

ACTIVITY DATE: This field identifies the most recent date a record was created or updated.

Columns Comments for GTVSQRU_USER_ID (6)

Source Code Comments

USER ID: This field identifies the most recent user to create or update a record.

Columns Comments for GTVSQRU_END_DATE (7)

Source Code Comments

END DATE: Date code became obsolete.

Table GTVSVAP

Schema Name GENERAL
Label GTVSVAP
Server name MALDEV8_B60
Creation Date 05/25/2003 01:42:48:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GTVSVAP_CODE GTVSVAP_CODE VARCHAR2(30) No *
GTVSVAP_DESC GTVSVAP_DESC VARCHAR2(60) No
GTVSVAP_SYS_REQ_IND GTVSVAP_SYS_REQ_IND VARCHAR2(1) No
GTVSVAP_START_DATE GTVSVAP_START_DATE DATE No
GTVSVAP_ACTIVITY_DATE GTVSVAP_ACTIVITY_DATE DATE No
GTVSVAP_USER_ID GTVSVAP_USER_ID VARCHAR2(30) No
GTVSVAP_END_DATE GTVSVAP_END_DATE DATE Yes

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_GTVSVAP Unique GTVSVAP_CODE

Comments

Source Code Comments

Validation entries for SEVIS Auto-populate codes.

Columns Comments for GTVSVAP_CODE (1)

Source Code Comments

AUTO-POPULATE ELEMENT CODE: Name of element to be auto-populated.

Columns Comments for GTVSVAP_SYS_REQ_IND (3)

Source Code Comments

SYSTEM REQUIRED INDICATOR: This field identifies whether or not this code is required by the system.

Columns Comments for GTVSVAP_START_DATE (4)

Source Code Comments

START DATE: Date SEVIS auto-populate code starts.

Columns Comments for GTVSVAP_USER_ID (6)

Source Code Comments

USER ID: This field identifies the most recent user to create or update a record.

Columns Comments for GTVSVAP_END_DATE (7)

Source Code Comments

END DATE: Date SEVIS auto-populate code became obsolete.

Table GTVSVBA

Schema Name GENERAL
Label GTVSVBA
Server name MALDEV8_B60
Creation Date 07/01/2003 14:13:05:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GTVSVBA_CODE GTVSVBA_CODE VARCHAR2(30) No *
GTVSVBA_DESC GTVSVBA_DESC VARCHAR2(60) No
GTVSVBA_SYS_REQ_IND GTVSVBA_SYS_REQ_IND VARCHAR2(1) No
GTVSVBA_DBPROC_NAME GTVSVBA_DBPROC_NAME VARCHAR2(100) No
GTVSVBA_START_DATE GTVSVBA_START_DATE DATE No
GTVSVBA_ACTIVITY_DATE GTVSVBA_ACTIVITY_DATE DATE No
GTVSVBA_USER_ID GTVSVBA_USER_ID VARCHAR2(30) No
GTVSVBA_END_DATE GTVSVBA_END_DATE DATE Yes

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_GTVSVBA Unique GTVSVBA_CODE

Comments

Source Code Comments

Validation entries for SEVIS Business Action Codes.

Columns Comments for GTVSVBA_CODE (1)

Source Code Comments

BUSINESS ACTION CODE: SEVIS business action code.

Columns Comments for GTVSVBA_DESC (2)

Source Code Comments

BUSINESS ACTION CODE DESCRIPTION: Description of SEVIS business action code.

Columns Comments for GTVSVBA_SYS_REQ_IND (3)

Source Code Comments

SYSTEM REQUIRED INDICATOR: This field identifies whether or not this code is required by the system.

Columns Comments for GTVSVBA_DBPROC_NAME (4)

Source Code Comments

PROCEDURE NAME: Procedure to be executed if business action is TRUE.

Columns Comments for GTVSVBA_START_DATE (5)

Source Code Comments

START DATE: Date Business action code starts.

Columns Comments for GTVSVBA_ACTIVITY_DATE (6)

Source Code Comments

ACTIVITY DATE: This field identifies the most recent date a record was created or updated.

Columns Comments for GTVSVBA_USER_ID (7)

Source Code Comments

USER ID: This field identifies the most recent user to create or update a record.

Columns Comments for GTVSVBA_END_DATE (8)

Source Code Comments

END DATE: Date Business Action code became obsolete.

Link between GORSVSQ and GTVSQPR

Caller : GORSVSQ
Called : GTVSQPR

Link List

Link Type Link Project
Refer(No Action ) Link Foreign Key Between GORSVSQ and GTVSQPR GENERAL

Link Foreign Key Between GORSVSQ and GTVSQPR

Caller : GORSVSQ
Called : GTVSQPR
Link Type : Refer(No Action )
Link : Link Foreign Key Between GORSVSQ and GTVSQPR

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
GORSVSQ GORSVSQ_SQPR_CODE GTVSQPR_CODE GTVSQPR (1,1)-(0,n)

Comments

Link between GORSVSQ and GTVSQRU

Caller : GORSVSQ
Called : GTVSQRU

Link List

Link Type Link Project
Refer(No Action ) Link Foreign Key Between GORSVSQ and GTVSQRU GENERAL

Link Foreign Key Between GORSVSQ and GTVSQRU

Caller : GORSVSQ
Called : GTVSQRU
Link Type : Refer(No Action )
Link : Link Foreign Key Between GORSVSQ and GTVSQRU

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
GORSVSQ GORSVSQ_SQRU_CODE GTVSQRU_CODE GTVSQRU (1,1)-(0,n)

Comments

Link between GORRSQL and GTVSQPR

Caller : GORRSQL
Called : GTVSQPR

Link List

Link Type Link Project
Refer(No Action ) Link Foreign Key Between GORRSQL and GTVSQPR GENERAL

Link Foreign Key Between GORRSQL and GTVSQPR

Caller : GORRSQL
Called : GTVSQPR
Link Type : Refer(No Action )
Link : Link Foreign Key Between GORRSQL and GTVSQPR

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
GORRSQL GORRSQL_SQPR_CODE GTVSQPR_CODE GTVSQPR (1,1)-(0,n)

Comments

Link between GORRSQL and GTVSQRU

Caller : GORRSQL
Called : GTVSQRU

Link List

Link Type Link Project
Refer(No Action ) Link Foreign Key Between GORRSQL and GTVSQRU GENERAL

Link Foreign Key Between GORRSQL and GTVSQRU

Caller : GORRSQL
Called : GTVSQRU
Link Type : Refer(No Action )
Link : Link Foreign Key Between GORRSQL and GTVSQRU

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
GORRSQL GORRSQL_SQRU_CODE GTVSQRU_CODE GTVSQRU (1,1)-(0,n)

Comments

Link between GORSVSQ and GTVSVAP

Caller : GORSVSQ
Called : GTVSVAP

Link List

Link Type Link Project
Refer(No Action ) Link Foreign Key Between GORSVSQ and GTVSVAP GENERAL

Link Foreign Key Between GORSVSQ and GTVSVAP

Caller : GORSVSQ
Called : GTVSVAP
Link Type : Refer(No Action )
Link : Link Foreign Key Between GORSVSQ and GTVSVAP

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
GORSVSQ GORSVSQ_SVAP_CODE GTVSVAP_CODE GTVSVAP (0,1)-(0,n)

Comments

Link between GORSVSQ and GTVSVBA

Caller : GORSVSQ
Called : GTVSVBA

Link List

Link Type Link Project
Refer(No Action ) Link Foreign Key Between GORSVSQ and GTVSVBA GENERAL

Link Foreign Key Between GORSVSQ and GTVSVBA

Caller : GORSVSQ
Called : GTVSVBA
Link Type : Refer(No Action )
Link : Link Foreign Key Between GORSVSQ and GTVSVBA

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
GORSVSQ GORSVSQ_SVBA_CODE GTVSVBA_CODE GTVSVBA (0,1)-(0,n)

Comments

Link between GORSQPA and GTVSQPA

Caller : GORSQPA
Called : GTVSQPA

Link List

Link Type Link Project
Refer(No Action ) Link Foreign Key Between GORSQPA and GTVSQPA GENERAL

Link Foreign Key Between GORSQPA and GTVSQPA

Caller : GORSQPA
Called : GTVSQPA
Link Type : Refer(No Action )
Link : Link Foreign Key Between GORSQPA and GTVSQPA

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
GORSQPA GORSQPA_SQPA_CODE GTVSQPA_CODE GTVSQPA (1,1)-(0,n)

Comments

Link between GORSQPA and GTVSQPR

Caller : GORSQPA
Called : GTVSQPR

Link List

Link Type Link Project
Refer(No Action ) Link Foreign Key Between GORSQPA and GTVSQPR GENERAL

Link Foreign Key Between GORSQPA and GTVSQPR

Caller : GORSQPA
Called : GTVSQPR
Link Type : Refer(No Action )
Link : Link Foreign Key Between GORSQPA and GTVSQPR

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
GORSQPA GORSQPA_SQPR_CODE GTVSQPR_CODE GTVSQPR (1,1)-(0,n)

Comments