Model Business_Rule_Builder

Model Label :

List of Objects

Object Name	Object Type	Layer Name
GOBICPS	SQL Table	Default
GORCTAB	SQL Table	Default
GORIROL	SQL Table	Default
GORRSQL	SQL Table	Default
GORSQPA	SQL Table	Default
GORSVSQ	SQL Table	Default
GTVSQPA	SQL Table	Default
GTVSQPR	SQL Table	Default
GTVSQRU	SQL Table	Default

Model View

Table GOBICPS

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GOBICPS_SQPR_CODE	VARCHAR2(30)	No	*	*
GOBICPS_ICSN_CODE	VARCHAR2(30)	No	*	*
GOBICPS_MULTIPLE_IND	VARCHAR2(1)	No
GOBICPS_ACTIVITY_DATE	DATE	No
GOBICPS_USER_ID	VARCHAR2(30)	No
GOBICPS_VALIDATION_SQL	VARCHAR2(4000)	Yes
GOBICPS_VALIDATION_SYSTEM	VARCHAR2(20)	Yes
GOBICPS_LIST_VALUES	VARCHAR2(30)	Yes
GOBICPS_DATA_ORIGIN	VARCHAR2(30)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GOBICPS_ICSN_CODE	GTVICSN_CODE	GTVICSN
GOBICPS_SQPR_CODE	GTVSQPR_CODE	GTVSQPR

Index

Index Name	Index Type	Column Name
PK_GOBICPS	Unique	GOBICPS_SQPR_CODE
PK_GOBICPS	Unique	GOBICPS_ICSN_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GORICCR	SQL Table	S10B80.GENERAL	Refer (no action)
GOBICPS_C	Oracle Package Cursor	S10B80.BANINST1.GB_INTEG_CONFIG_RULES	Use (select)
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.GB_INTEG_CONFIG_RULES	Rely On
F_VALID_SETTING_VALUE	Oracle Package Function	S10B80.BANINST1.GB_INTEG_CONFIG_RULES	Use (select)
GOBICPS	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_GOBICPS	SQL Index	S10B80.GENERAL	Rely On
GTVICSN	SQL Table	S10B80.GENERAL	Refer (no action)
GTVSQPR	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GOBICPS

Object Dates

Creation Date	Analysis Date
04/02/2008 20:31:30:000	04/02/2008 21:17:55:000

Source Code Comments

GOBICPS: Integration Configuration Process/Setting Name Table.

Columns Comments for GOBICPS_SQPR_CODE (# 1)

Source Code Comments

PROCESS CODE: The integration configuration setting process code.

Columns Comments for GOBICPS_ICSN_CODE (# 2)

Source Code Comments

SETTING NAME: The integration configuration setting name code.

Columns Comments for GOBICPS_MULTIPLE_IND (# 3)

Source Code Comments

MULTIPLE INDICATOR: Indicates whether multiple occurrences of the process/name combination are allowed in the GORICCR table.

Columns Comments for GOBICPS_ACTIVITY_DATE (# 4)

Source Code Comments

ACTIVITY DATE: The date that the information for the row was inserted or updated in the GOBICPS table.

Columns Comments for GOBICPS_USER_ID (# 5)

Source Code Comments

USER ID: The unique identification of the user.

Columns Comments for GOBICPS_VALIDATION_SQL (# 6)

Source Code Comments

VALIDATION SQL: SQL query used to validate values associated with the process/name combination in the GORICCR table.

Columns Comments for GOBICPS_VALIDATION_SYSTEM (# 7)

Source Code Comments

VALIDATION SYSTEM: System in which the validation SQL will query, and in which the List Values form is found. Values in the field must be recognizable to the goksyst.f_isproductinstalled function.

Columns Comments for GOBICPS_LIST_VALUES (# 8)

Source Code Comments

LIST VALUES: Name of a form that can be used to provide a list of valid values that can be associated with the process/name combination in the GORICCR table.

Columns Comments for GOBICPS_DATA_ORIGIN (# 9)

Source Code Comments

DATA ORIGIN: Source system that created or updated the row.

Table GORCTAB

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GORCTAB_SEQ_NO	NUMBER(0,0)	No	*
GORCTAB_SQPR_CODE	VARCHAR2(30)	No		*
GORCTAB_TABLE_NAME	VARCHAR2(30)	No
GORCTAB_TABLE_OWNER	VARCHAR2(30)	No
GORCTAB_APPLY_HANDLER	VARCHAR2(120)	No
GORCTAB_ACTIVITY_DATE	DATE	No
GORCTAB_USER_ID	VARCHAR2(30)	No
GORCTAB_DATA_ORIGIN	VARCHAR2(30)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GORCTAB_SQPR_CODE	GTVSQPR_CODE	GTVSQPR

Index

Index Name	Index Type	Column Name
PK_GORCTAB	Unique	GORCTAB_SEQ_NO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GORCCOL	SQL Table	S10B80.GENERAL	Refer (no action)
GORCRUL	SQL Table	S10B80.GENERAL	Refer (no action)
STREAMS_TABLES_REC	Oracle Package Type	S10B80.BANINST1.GB_STREAMS_TABLES	Rely On
P_OVERLAY_VALIDATION_REC	Oracle Package Procedure	S10B80.BANINST1.GB_STREAMS_TABLES	Rely On
F_BUILD_GORCTAB_REC	Oracle Package Function	S10B80.BANINST1.GB_STREAMS_TABLES	Rely On
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.GB_STREAMS_TABLES	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.DML_GORCTAB	Use (delete)
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.GB_STREAMS_TABLES	Rely On
P_INSERT	Oracle Package Procedure	S10B80.BANINST1.DML_GORCTAB	Use (Insert)Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.GB_STREAMS_TABLES	Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.GB_STREAMS_TABLES	Use (select)
P_REGISTER_ENTITY	Oracle Package Procedure	S10B80.BANINST1.GB_STREAMS_TABLES_RULES	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.DML_GORCTAB	Use (update)Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.GB_STREAMS_TABLES	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.GB_STREAMS_TABLES_RULES	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_STREAMS_TABLES	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_STREAMS_TABLES	Use (select)
F_PARENT_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_STREAMS_RULES_RULES	Use (select)
F_PARENT_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_STREAMS_COLUMNS_RULES	Use (select)
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.GB_STREAMS_TABLES	Rely On
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.GB_STREAMS_TABLES	Use (select)
F_QUERY_BY_ROWID	Oracle Package Function	S10B80.BANINST1.GB_STREAMS_TABLES	Use (select)
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.GB_STREAMS_TABLES	Rely On
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.GB_STREAMS_TABLES	Use (select)
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.GB_STREAMS_TABLES	Rely On
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.GB_STREAMS_TABLES	Use (select)
GORCTAB	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_GORCTAB	SQL Index	S10B80.GENERAL	Rely On
GTVSQPR	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GORCTAB

Object Dates

Creation Date	Analysis Date
04/02/2008 20:28:07:000	04/02/2008 21:17:51:000

Source Code Comments

This table maps the capture processes, tables and the apply handler for that table.

Columns Comments for GORCTAB_SEQ_NO (# 1)

Source Code Comments

SEQUENCE NUMBER: This is a one up sequence number.

Columns Comments for GORCTAB_SQPR_CODE (# 2)

Source Code Comments

PROCESS CODE: Capture Process Code. References process code defined in gtvsqpr.

Columns Comments for GORCTAB_TABLE_NAME (# 3)

Source Code Comments

TABLE NAME: Table name for the capture.

Columns Comments for GORCTAB_TABLE_OWNER (# 4)

Source Code Comments

TABLE OWNER NAME: Table owner name for the capture.

Columns Comments for GORCTAB_APPLY_HANDLER (# 5)

Source Code Comments

APPLY HANDLER: Callback PL/SQL Packaged procedure associated with the table for a capture process.

Columns Comments for GORCTAB_ACTIVITY_DATE (# 6)

Source Code Comments

ACTIVITY DATE: Date the row was created or last updated.

Columns Comments for GORCTAB_USER_ID (# 7)

Source Code Comments

USER ID: User ID of the user who created or last updated the row.

Columns Comments for GORCTAB_DATA_ORIGIN (# 8)

Source Code Comments

DATA ORIGIN: Source system that created or updated the row.

Table GORIROL

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
GORIROL_PIDM	NUMBER(8,0)	No
GORIROL_ROLE_GROUP	VARCHAR2(30)	No	*
GORIROL_ROLE	VARCHAR2(30)	No	*
GORIROL_ACTIVITY_DATE	DATE	No
GORIROL_USER_ID	VARCHAR2(30)	No
GORIROL_VPDI_CODE	VARCHAR2(6)	Yes	*
GORIROL_DATA_ORIGIN	VARCHAR2(30)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GORIROL_ROLE_GROUP	GTVSQPR_CODE	GTVSQPR
GORIROL_ROLE	GTVSQRU_CODE	GTVSQRU
GORIROL_VPDI_CODE	GTVVPDI_CODE	GTVVPDI

Index

Index Name	Index Type	Column Name
UK_GORIROL	Unique	GORIROL_PIDM
UK_GORIROL	Unique	GORIROL_ROLE_GROUP
UK_GORIROL	Unique	GORIROL_ROLE
UK_GORIROL	Unique	GORIROL_VPDI_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
INSTITUTION_ROLE_REC	Oracle Package Type	S10B80.BANINST1.GB_INSTITUTION_ROLE	Rely On
P_DELETE_ROLES	Oracle Package Procedure	S10B80.BANINST1.GB_INSTITUTION_ROLE	Rely On
P_GET_ROLE_INSTITUTIONS	Oracle Package Procedure	S10B80.BANINST1.GB_INSTITUTION_ROLE	Rely On
P_INSERT_ROLES	Oracle Package Procedure	S10B80.BANINST1.GB_INSTITUTION_ROLE	Rely On
P_OVERLAY_VALIDATION_REC	Oracle Package Procedure	S10B80.BANINST1.GB_INSTITUTION_ROLE	Rely On
F_BUILD_GORIROL_REC	Oracle Package Function	S10B80.BANINST1.GB_INSTITUTION_ROLE	Rely On
F_ROLE_IS_VPD	Oracle Package Function	S10B80.BANINST1.GB_INSTITUTION_ROLE	Rely On
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.GB_INSTITUTION_ROLE	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.DML_GORIROL	Use (delete)
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.GB_INSTITUTION_ROLE	Rely On
P_INSERT	Oracle Package Procedure	S10B80.BANINST1.DML_GORIROL	Use (Insert)Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.GB_INSTITUTION_ROLE	Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.GB_INSTITUTION_ROLE	Use (select)
P_MAINTAIN_ROLES	Oracle Package Procedure	S10B80.BANINST1.GB_INSTITUTION_ROLE	Rely On
P_REGISTER_ENTITY	Oracle Package Procedure	S10B80.BANINST1.GB_INSTITUTION_ROLE_RULES	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.DML_GORIROL	Use (update)Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.GB_INSTITUTION_ROLE	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.GB_INSTITUTION_ROLE_RULES	Rely On
P_VALIDATE_MAINTAIN_REQUEST	Oracle Package Procedure	S10B80.BANINST1.GB_INSTITUTION_ROLE_RULES	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_INSTITUTION_ROLE	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_INSTITUTION_ROLE	Use (select)
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.GB_INSTITUTION_ROLE	Rely On
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.GB_INSTITUTION_ROLE	Use (select)
F_QUERY_BY_ROWID	Oracle Package Function	S10B80.BANINST1.GB_INSTITUTION_ROLE	Use (select)
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.GB_INSTITUTION_ROLE	Rely On
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.GB_INSTITUTION_ROLE	Use (select)
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.GB_INSTITUTION_ROLE	Rely On
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.GB_INSTITUTION_ROLE	Use (select)
GORIROL	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
UK_GORIROL	SQL Index	S10B80.GENERAL	Rely On
GTVSQPR	SQL Table	S10B80.GENERAL	Refer (no action)
GTVSQRU	SQL Table	S10B80.GENERAL	Refer (no action)
GTVVPDI	SQL Table	S10B80.BANSECR	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GORIROL

Object Dates

Creation Date	Analysis Date
04/02/2008 20:28:38:000	04/02/2008 21:17:52:000

Source Code Comments

GORIROL: Institution Role Table.

Columns Comments for GORIROL_PIDM (# 1)

Source Code Comments

PIDM: Internal identification number of the person.

Columns Comments for GORIROL_ROLE_GROUP (# 2)

Source Code Comments

ROLE GROUP: Group a role belongs to.

Columns Comments for GORIROL_ROLE (# 3)

Source Code Comments

ROLE: Institution Role name.

Columns Comments for GORIROL_ACTIVITY_DATE (# 4)

Source Code Comments

ACTIVITY DATE: Date the record was created or last updated.

Columns Comments for GORIROL_USER_ID (# 5)

Source Code Comments

USER ID: The unique identification of the user.

Columns Comments for GORIROL_VPDI_CODE (# 6)

Source Code Comments

VPDI CODE: This field contains a VPD Institution Code.

Columns Comments for GORIROL_DATA_ORIGIN (# 7)

Source Code Comments

DATA ORIGIN: Source system that created or updated the row

Table GORRSQL

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

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

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

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
RULE_TABTYPE	Oracle Package Type	S10B80.BANINST1.GOKISQL	Rely On
GLOBAL_ROLES_REC_TYPE	Oracle Package Type	S10B80.BANINST1.ICGOKROL	Rely On
GORRSQL_ROLES_REC_TYPE	Oracle Package Type	S10B80.BANINST1.ICGOKROL	Rely On
GORRSQL_RULES_REC_TYPE	Oracle Package Type	S10B80.BANINST1.ICGOKROL	Rely On
GET_GORRSQL_C	Oracle Package Cursor	S10B80.BANINST1.ICGOKCOM	Rely On
GET_GORRSQL_C	Oracle Package Cursor	S10B80.BANINST1.ICGOKCOM	Use (select)
RULES_BY_PROCESS_CURSOR_C	Oracle Package Cursor	S10B80.BANINST1.GP_GORRSQL	Use (select)
UT_GB_INSTITUTION_ROLEQ_API	Oracle Package Procedure	S10B80.BANINST1.UT_GB_INSTITUTION_ROLE	Use (update)
UT_GP_CARDHOLDERPROCESSAPI	Oracle Package Procedure	S10B80.BANINST1.UT_GP_CARDHOLDER	Use (Insert,select)
UT_SP_HOUSING_ELIGIBILITYP_API	Oracle Package Procedure	S10B80.BANINST1.UT_SP_HOUSING_ELIGIBILITY	Use (Insert)
UT_SP_LDIPERSONPROCESSAPI	Oracle Package Procedure	S10B80.BANINST1.UT_SP_LDIPERSON	Use (update)
RULE_TABTYPE	Oracle Package Type	S10B80.BANINST1.ICGOKROL	Rely On
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_INSTITUTION_ROLE	Use (Insert,delete,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SP_LDIPERSON	Use (update)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GP_CARDHOLDER	Use (delete)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SP_HOUSING_ELIGIBILITY	Use (select)
F_CHECK_ROLE	Oracle Package Function	S10B80.BANINST1.GOKISQL	Rely On
F_CHECK_ROLE	Oracle Package Function	S10B80.BANINST1.GOKISQL	Use (select)Rely On
F_EXECUTE_SQL_RULES	Oracle Package Function	S10B80.BANINST1.GOKSVSQ	Use (select)
F_GET_ALL_ROLES	Oracle Package Function	S10B80.BANINST1.GOKISQL	Rely On
F_GET_ALL_ROLES	Oracle Package Function	S10B80.BANINST1.GOKISQL	Use (select)Rely On
F_GET_ELIGIBLE_CARDHOLDERS	Oracle Package Function	S10B80.BANINST1.GP_CARDHOLDER	Rely On
F_GET_ELIGIBLE_CARDHOLDERS	Oracle Package Function	S10B80.BANINST1.GP_CARDHOLDER	Use (select)
F_GET_GORRSQL_SQRU_CODE	Oracle Package Function	S10B80.BANINST1.ICGOKCOM	Rely On
F_GET_ROLES	Oracle Package Function	S10B80.BANINST1.GOKISQL	Rely On
F_GET_ROLES	Oracle Package Function	S10B80.BANINST1.GOKISQL	Use (select)Rely On
F_GET_ROLE_NT	Oracle Package Function	S10B80.BANINST1.GOKPAPI	Rely On
GORRSQL	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_GORRSQL	SQL Index	S10B80.GENERAL	Rely On
GTVSQPR	SQL Table	S10B80.GENERAL	Refer (no action)
GTVSQRU	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GORRSQL

Object Dates

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

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.

Columns Comments for GORRSQL_SYS_REQ_IND (# 14)

Source Code Comments

SYSTEM REQUIRED INDICATOR:Indicates Process Code/Rule Code combination is SCT delivered data. Valid values are (Y)es or (N)o.

Table GORSQPA

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GORSQPA_SQPR_CODE	VARCHAR2(30)	No	*	*
GORSQPA_SQPA_CODE	VARCHAR2(30)	No	*	*
GORSQPA_SYS_REQ_IND	VARCHAR2(1)	No
GORSQPA_ACTIVITY_DATE	DATE	No
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

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SP_HOUSING_ELIGIBILITY	Use (Insert,select)
F_VALIDATE_SQL_RULE	Oracle Package Function	S10B80.BANINST1.GOKRSQL	Rely On
F_VALIDATE_SQL_RULE	Oracle Package Function	S10B80.BANINST1.GOKRSQL	Use (select)Rely On
GORSQPA	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_GORSQPA	SQL Index	S10B80.GENERAL	Rely On
GTVSQPA	SQL Table	S10B80.GENERAL	Refer (no action)
GTVSQPR	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GORSQPA

Object Dates

Creation Date	Analysis Date
04/02/2008 20:33:09:000	04/02/2008 21:17:57:000

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

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GORSVSQ_SQPR_CODE	VARCHAR2(30)	No	*	*
GORSVSQ_SQRU_CODE	VARCHAR2(30)	No	*	*
GORSVSQ_SEQ_NO	NUMBER(5,0)	No	*
GORSVSQ_PROCESS_TYPE_IND	VARCHAR2(1)	No
GORSVSQ_ACTIVE_IND	VARCHAR2(1)	No
GORSVSQ_START_DATE	DATE	No
GORSVSQ_ACTIVITY_DATE	DATE	No
GORSVSQ_USER_ID	VARCHAR2(30)	No
GORSVSQ_SVAP_CODE	VARCHAR2(30)	Yes		*
GORSVSQ_SVBA_CODE	VARCHAR2(30)	Yes		*
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

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
P_PROCESS_AGAIN	Oracle Package Procedure	S10B80.BANINST1.GOKSVSQ	Rely On
P_PROCESS_AGAIN	Oracle Package Procedure	S10B80.BANINST1.GOKSVSQ	Use (select)Rely On
P_PROCESS_SQL_RULES	Oracle Package Procedure	S10B80.BANINST1.GOKSVSQ	Rely On
P_PROCESS_SQL_RULES	Oracle Package Procedure	S10B80.BANINST1.GOKSVSQ	Use (select)Rely On
GORSVSQ	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_GORSVSQ	SQL Index	S10B80.GENERAL	Rely On
GTVSQPR	SQL Table	S10B80.GENERAL	Refer (no action)
GTVSQRU	SQL Table	S10B80.GENERAL	Refer (no action)
GTVSVAP	SQL Table	S10B80.GENERAL	Refer (no action)
GTVSVBA	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GORSVSQ

Object Dates

Creation Date	Analysis Date
04/02/2008 20:31:13:000	04/02/2008 21:17:54:000

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

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

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

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GTVSQPA	Unique	GTVSQPA_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GORSQPA	SQL Table	S10B80.GENERAL	Refer (no action)
PARAM_REC	Oracle Package Type	S10B80.BANINST1.GOKISQL	Rely On
TEMPRULE_REC	Oracle Package Type	S10B80.BANINST1.GOKISQL	Rely On
GTVSQPA_C	Oracle Package Cursor	S10B80.BANINST1.GB_GTVSQPA	Rely On
GTVSQPA_C	Oracle Package Cursor	S10B80.BANINST1.GB_GTVSQPA	Use (select)Rely On
F_CODE_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_GTVSQPA	Rely On
F_GET_DESCRIPTION	Oracle Package Function	S10B80.BANINST1.GB_GTVSQPA	Rely On
F_VALIDATE_SQL_RULE	Oracle Package Function	S10B80.BANINST1.GOKRSQL	Rely On
F_VALIDATE_SQL_RULE	Oracle Package Function	S10B80.BANINST1.GOKRSQL	Use (select)
GTVSQPA	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_GTVSQPA	SQL Index	S10B80.GENERAL	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GTVSQPA

Object Dates

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

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

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

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

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GTVSQPR	Unique	GTVSQPR_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GOBICPS	SQL Table	S10B80.GENERAL	Refer (no action)
GORCTAB	SQL Table	S10B80.GENERAL	Refer (no action)
GORIROL	SQL Table	S10B80.GENERAL	Refer (no action)
GORRSQL	SQL Table	S10B80.GENERAL	Refer (no action)
GORSQPA	SQL Table	S10B80.GENERAL	Refer (no action)
GORSVSQ	SQL Table	S10B80.GENERAL	Refer (no action)
TEMPRULE_REC	Oracle Package Type	S10B80.BANINST1.GOKISQL	Rely On
GTVSQPR_C	Oracle Package Cursor	S10B80.BANINST1.GB_GTVSQPR	Rely On
GTVSQPR_C	Oracle Package Cursor	S10B80.BANINST1.GB_GTVSQPR	Use (select)Rely On
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_INSTITUTION_ROLE	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SP_LDIPERSON	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GP_CARDHOLDER	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SP_HOUSING_ELIGIBILITY	Use (Insert,select)
F_CODE_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_GTVSQPR	Rely On
F_GET_DESCRIPTION	Oracle Package Function	S10B80.BANINST1.GB_GTVSQPR	Rely On
GTVSQPR	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_GTVSQPR	SQL Index	S10B80.GENERAL	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GTVSQPR

Object Dates

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

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

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

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

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GTVSQRU	Unique	GTVSQRU_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GORIROL	SQL Table	S10B80.GENERAL	Refer (no action)
GORRSQL	SQL Table	S10B80.GENERAL	Refer (no action)
GORSVSQ	SQL Table	S10B80.GENERAL	Refer (no action)
GV_INVALID_ROLE	Oracle Package Variable	S10B80.BANINST1.UT_GP_CARDHOLDER	Rely On
GTVSQRU_C	Oracle Package Cursor	S10B80.BANINST1.GB_GTVSQRU	Rely On
GTVSQRU_C	Oracle Package Cursor	S10B80.BANINST1.GB_GTVSQRU	Use (select)Rely On
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_INSTITUTION_ROLE	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GP_CARDHOLDER	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SP_HOUSING_ELIGIBILITY	Use (Insert,select)
F_CODE_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_GTVSQRU	Rely On
F_GET_DESCRIPTION	Oracle Package Function	S10B80.BANINST1.GB_GTVSQRU	Rely On
F_GET_ELIGIBLE_CARDHOLDERS	Oracle Package Function	S10B80.BANINST1.GP_ASYNC_CARDHOLDER	Use (select)
GTVSQRU	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_GTVSQRU	SQL Index	S10B80.GENERAL	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GTVSQRU

Object Dates

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

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.

Link between GORIROL and GTVSQPR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GORIROL and GTVSQPR (FK1_GORIROL_INV_GTVSQPR_CODE)	GENERAL

Foreign Key information

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

Link between GORCTAB and GTVSQPR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GORCTAB and GTVSQPR (FK1_GORCTAB_INV_GTVSQPR_CODE)	GENERAL

Foreign Key information

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

Link between GORIROL and GTVSQRU

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GORIROL and GTVSQRU (FK1_GORIROL_INV_GTVSQRU_CODE)	GENERAL

Foreign Key information

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

Link between GORSVSQ and GTVSQPR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GORSVSQ and GTVSQPR (FK1_GORSVSQ_INV_GTVSQPR_CODE)	GENERAL

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)

Link between GORSVSQ and GTVSQRU

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GORSVSQ and GTVSQRU (FK1_GORSVSQ_INV_GTVSQRU_CODE)	GENERAL

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)

Link between GOBICPS and GTVSQPR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GOBICPS and GTVSQPR (FK1_GOBICPS_INV_GTVSQPR_CODE)	GENERAL

Foreign Key information

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

Link between GORRSQL and GTVSQPR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GORRSQL and GTVSQPR (FK1_GORRSQL_INV_GTVSQPR_CODE)	GENERAL

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)

Link between GORRSQL and GTVSQRU

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GORRSQL and GTVSQRU (FK1_GORRSQL_INV_GTVSQRU_CODE)	GENERAL

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)

Link between GORSQPA and GTVSQPA

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GORSQPA and GTVSQPA (FK1_GORSQPA_INV_GTVSQPA_CODE)	GENERAL

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)

Link between GORSQPA and GTVSQPR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GORSQPA and GTVSQPR (FK1_GORSQPA_INV_GTVSQPR_CODE)	GENERAL

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)