Model Common_Matching

Model Label :

List of Objects

Object Name	Object Type	Layer Name
GOBCMUS	SQL Table	Default
GORCMDD	SQL Table	Default
GORCMDH	SQL Table	Default
GORCMDO	SQL Table	Default
GORCMSC	SQL Table	Default
GORCMSP	SQL Table	Default
GORCMSR	SQL Table	Default
GORCMUP	SQL Table	Default
GORNAME	SQL Table	Default
GORNPNM	SQL Table	Default
GOTCMME	SQL Table	Default
GOTCMRT	SQL Table	Default
GTVCMSC	SQL Table	Default
GTVEMAL	SQL Table	Default
GUBOBJS	SQL Table	Default
STVATYP	SQL Table	Default
STVTELE	SQL Table	Default

Model View

Table GOBCMUS

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GOBCMUS_CM_USER_ID	VARCHAR2(30)	No	*
GOBCMUS_CMSC_OPTION_IND	VARCHAR2(1)	No
GOBCMUS_EXCLUDE_IND	VARCHAR2(1)	No
GOBCMUS_USER_ID	VARCHAR2(30)	No
GOBCMUS_ACTIVITY_DATE	DATE	No
GOBCMUS_CMSC_CODE	VARCHAR2(20)	Yes		*
GOBCMUS_DATA_ORIGIN	VARCHAR2(30)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GOBCMUS_CMSC_CODE	GTVCMSC_CODE	GTVCMSC

Index

Index Name	Index Type	Column Name
PK_GOBCMUS	Unique	GOBCMUS_CM_USER_ID

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GORSDAV	SQL Table	S10B80.GENERAL	Join
GOBCMUS_ADD	SQL View	S10B80.BANINST1	Use (select)
GOBCMUS_ADS	SQL View	S10B80.BANINST1	Use (select)
CM_USER_SETUP_REC	Oracle Package Type	S10B80.BANINST1.GB_CM_USER_SETUP	Rely On
P_NEWPERS_CM	Oracle Package Procedure	S10B80.BANINST1.BWPKEPDT	Rely On
P_OVERLAY_VALIDATION_REC	Oracle Package Procedure	S10B80.BANINST1.GB_CM_USER_SETUP	Rely On
F_BUILD_GOBCMUS_REC	Oracle Package Function	S10B80.BANINST1.GB_CM_USER_SETUP	Rely On
F_VALIDATE_CMSC_CODE	Oracle Package Function	S10B80.BANINST1.GB_CM_USER_SETUP_RULES	Rely On
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.GB_CM_USER_SETUP	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.GB_CM_USER_SETUP	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.DML_GOBCMUS	Use (delete)
P_GET_CM_OPTIONS	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Rely On
P_GET_CM_OPTIONS	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Use (select)
P_INSERT	Oracle Package Procedure	S10B80.BANINST1.DML_GOBCMUS	Use (Insert)Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.GB_CM_USER_SETUP	Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.GB_CM_USER_SETUP	Use (select)
P_NEW_PERSON_CM	Oracle Package Procedure	S10B80.BANINST1.NOKEPAF	Rely On
P_REGISTER_ENTITY	Oracle Package Procedure	S10B80.BANINST1.GB_CM_USER_SETUP_RULES	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.GB_CM_USER_SETUP	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.DML_GOBCMUS	Use (update)Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.GB_CM_USER_SETUP_RULES	Rely On
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GP_PERSON_IDENTITY	Use (select)
F_CODE_EXISTS_IN_TABLE	Oracle Package Function	S10B80.BANINST1.GB_GTVCMSC	Use (select)
F_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_CM_USER_SETUP	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_CM_USER_SETUP	Use (select)
F_GET_PERSON_IDENTITY	Oracle Package Function	S10B80.BANINST1.GP_PERSON_IDENTITY	Rely On
F_GET_PERSON_IDENTITY	Oracle Package Function	S10B80.BANINST1.GP_PERSON_IDENTITY	Use (select)
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.GB_CM_USER_SETUP	Use (select)
F_QUERY_BY_ROWID	Oracle Package Function	S10B80.BANINST1.GB_CM_USER_SETUP	Use (select)
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.GB_CM_USER_SETUP	Rely On
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.GB_CM_USER_SETUP	Use (select)
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.GB_CM_USER_SETUP	Rely On
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.GB_CM_USER_SETUP	Use (select)
F_VALIDATE_CMSC_CDE_OPTION	Oracle Package Function	S10B80.BANINST1.GB_CM_USER_SETUP_RULES	Rely On
F_VALIDATE_CM_USER	Oracle Package Function	S10B80.BANINST1.GB_CM_USER_SETUP_RULES	Rely On
GOBCMUS	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_GOBCMUS	SQL Index	S10B80.GENERAL	Rely On
GTVCMSC	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GOBCMUS

Object Dates

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

Source Code Comments

Common Matching User Setup Table

Columns Comments for GOBCMUS_CM_USER_ID (# 1)

Source Code Comments

COMMON MATCHING USER ID: User ID associated with these rules for Common Matching process when creating a new person or non-person record from a form.

Columns Comments for GOBCMUS_CMSC_OPTION_IND (# 2)

Source Code Comments

COMMON MATCHING SOURCE CODE OPTIONS INDICATOR: Y/N indicator if the user ID may select different Common Matching Source Codes for on-line processing.

Columns Comments for GOBCMUS_EXCLUDE_IND (# 3)

Source Code Comments

EXCLUDE INDICATOR: Y/N indicates that the user ID has been excluded from executing the Common Matching process on-line.

Columns Comments for GOBCMUS_USER_ID (# 4)

Source Code Comments

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

Columns Comments for GOBCMUS_ACTIVITY_DATE (# 5)

Source Code Comments

ACTIVITY DATE: Date record was created or last updated.

Columns Comments for GOBCMUS_CMSC_CODE (# 6)

Source Code Comments

COMMON MATCHING SOURCE CODE: Source code and associated rules to use as preference for user ID when Common Matching is run on-line from a form.

Columns Comments for GOBCMUS_DATA_ORIGIN (# 7)

Source Code Comments

DATA ORIGIN: Source system that created or updated the row

Table GORCMDD

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GORCMDD_TABLE	VARCHAR2(30)	No	*
GORCMDD_COLUMN_NAME	VARCHAR2(30)	No	*
GORCMDD_ELEMENT	VARCHAR2(30)	No
GORCMDD_MAX_LENGTH	NUMBER(3,0)	No
GORCMDD_OVERRIDE_LENGTH_IND	VARCHAR2(1)	No
GORCMDD_ALLOW_NEG_LENGTH_IND	VARCHAR2(1)	No
GORCMDD_ONLINE_MATCH_IND	VARCHAR2(1)	No
GORCMDD_SYS_REQ_IND	VARCHAR2(1)	No
GORCMDD_ELEMENT_REQ_IND	VARCHAR2(1)	No
GORCMDD_USER_ID	VARCHAR2(30)	No
GORCMDD_ACTIVITY_DATE	DATE	No
GORCMDD_DATA_ORIGIN	VARCHAR2(30)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GORCMDD	Unique	GORCMDD_TABLE
PK_GORCMDD	Unique	GORCMDD_COLUMN_NAME
UK1_GORCMDD_COLUMN_NAME	Unique	GORCMDD_COLUMN_NAME

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GORCMSR	SQL Table	S10B80.GENERAL	Refer (no action)
GORCMDD_ADD	SQL View	S10B80.BANINST1	Use (select)
GORCMDD_ADS	SQL View	S10B80.BANINST1	Use (select)
CM_DATA_DICTIONARY_REC	Oracle Package Type	S10B80.BANINST1.GB_CM_DATA_DICTIONARY	Rely On
DATARECORDTYP	Oracle Package Type	S10B80.BANINST1.GOKCMPK	Rely On
CMSR_CUR	Oracle Package Cursor	S10B80.BANINST1.IMF_SERVICE2	Use (select)
P_BUILD_MSG	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Rely On
P_MATCH_ID	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Rely On
P_OPEN_SABSUPL_CV	Oracle Package Procedure	S10B80.BANINST1.SAKMTCH	Use (select)
P_OPEN_SORHSCH_CV	Oracle Package Procedure	S10B80.BANINST1.SAKMTCH	Use (select)
P_OPEN_SORHSCH_CV	Oracle Package Procedure	S10B80.BANINST1.GOKDEBT	Use (select)
P_OVERLAY_VALIDATION_REC	Oracle Package Procedure	S10B80.BANINST1.GB_CM_DATA_DICTIONARY	Rely On
P_POPULATE_DATAREC	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Rely On
ELEMENTTABTYP	Oracle Package Type	S10B80.BANINST1.GOKCMPK	Rely On
GV_ELEMENT_VALUE	Oracle Package Variable	S10B80.BANINST1.GOKCMPK	Rely On
F_BUILD_GORCMDD_REC	Oracle Package Function	S10B80.BANINST1.GB_CM_DATA_DICTIONARY	Rely On
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.GB_CM_DATA_DICTIONARY	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.DML_GORCMDD	Use (delete)
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.GB_CM_RULES	Use (select)
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.GB_CM_DATA_DICTIONARY	Rely On
P_INSERT	Oracle Package Procedure	S10B80.BANINST1.DML_GORCMDD	Use (Insert)Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.GB_CM_DATA_DICTIONARY	Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.GB_CM_DATA_DICTIONARY	Use (select)
P_REGISTER_ENTITY	Oracle Package Procedure	S10B80.BANINST1.GB_CM_DATA_DICTIONARY_RULES	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.DML_GORCMDD	Use (update)Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.GB_CM_DATA_DICTIONARY	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.GB_CM_RULES_RULES	Use (select)
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.GB_CM_DATA_DICTIONARY_RULES	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.GB_CM_SOURCE_RULES_RULES	Use (select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_CM_USER_PROCEDURE	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_CM_RULES	Use (Insert,select)
F_ALL_REQD_ADDED	Oracle Package Function	S10B80.BANINST1.GB_CM_RULES	Use (select)
F_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_CM_DATA_DICTIONARY	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_CM_DATA_DICTIONARY	Use (select)
F_GET_COLUMN	Oracle Package Function	S10B80.BANINST1.GB_CM_DATA_DICTIONARY	Rely On
F_GET_COLUMN	Oracle Package Function	S10B80.BANINST1.GB_CM_DATA_DICTIONARY	Use (select)
F_GET_ELEMENT	Oracle Package Function	S10B80.BANINST1.GB_CM_DATA_DICTIONARY	Rely On
F_GET_ELEMENT	Oracle Package Function	S10B80.BANINST1.GB_CM_DATA_DICTIONARY	Use (select)
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.GB_CM_DATA_DICTIONARY	Rely On
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.GB_CM_DATA_DICTIONARY	Use (select)
F_QUERY_BY_ROWID	Oracle Package Function	S10B80.BANINST1.GB_CM_DATA_DICTIONARY	Use (select)
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.GB_CM_DATA_DICTIONARY	Rely On
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.GB_CM_DATA_DICTIONARY	Use (select)
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.GB_CM_DATA_DICTIONARY	Rely On
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.GB_CM_DATA_DICTIONARY	Use (select)
F_SYS_REQ	Oracle Package Function	S10B80.BANINST1.GB_CM_DATA_DICTIONARY	Rely On
F_SYS_REQ	Oracle Package Function	S10B80.BANINST1.GB_CM_DATA_DICTIONARY	Use (select)
F_TABLE_RULE_EXISTS	Oracle Package Function	S10B80.BANINST1.GOKCMPK	Rely On
F_TABLE_RULE_EXISTS	Oracle Package Function	S10B80.BANINST1.GOKCMPK	Use (select)
GORCMDD	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_GORCMDD	SQL Index	S10B80.GENERAL	Rely On
UK1_GORCMDD_COLUMN_NAME	SQL Index	S10B80.GENERAL	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GORCMDD

Object Dates

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

Source Code Comments

Common Matching Data Dictionary Table

Columns Comments for GORCMDD_TABLE (# 1)

Source Code Comments

TABLE: Database table associated with column name and element.

Columns Comments for GORCMDD_COLUMN_NAME (# 2)

Source Code Comments

COLUMN NAME: Column name associated with element to be used by Common Matching Rules.

Columns Comments for GORCMDD_ELEMENT (# 3)

Source Code Comments

ELEMENT: Element to be used by Common Matching Rules.

Columns Comments for GORCMDD_MAX_LENGTH (# 4)

Source Code Comments

MAXIMUM LENGTH: Maximum length of data for associated element.

Columns Comments for GORCMDD_OVERRIDE_LENGTH_IND (# 5)

Source Code Comments

OVERRIDE LENGTH INDICATOR: Y/N indicator to allow update to the number of characters being used in matching.

Columns Comments for GORCMDD_ALLOW_NEG_LENGTH_IND (# 6)

Source Code Comments

ALLOW NEGATIVE LENGTH INDICATOR: Y/N indicator to allow a negative length to be used for the data element. This will reverse the character string to use the last number of characters.

Columns Comments for GORCMDD_ONLINE_MATCH_IND (# 7)

Source Code Comments

ON-LINE INDICATOR: Y/N indicator that this element is available for on-line Common Matching processing.

Columns Comments for GORCMDD_SYS_REQ_IND (# 8)

Source Code Comments

SYSTEM REQUIRED INDICATOR: Y/N indicator. A (Y) in this field indicates that this is required data that was delivered by SCT and should not be removed or changed.

Columns Comments for GORCMDD_ELEMENT_REQ_IND (# 9)

Source Code Comments

CORE MATCHING ELEMENT INDICATOR: Y/N indicator. A (Y) in this field indicates that this is a core matching element used during the primary matching process. At least one core matching element is required for all Common Matching rule sets.

Columns Comments for GORCMDD_USER_ID (# 10)

Source Code Comments

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

Columns Comments for GORCMDD_ACTIVITY_DATE (# 11)

Source Code Comments

ACTIVITY DATE: Date record was created or last updated.

Columns Comments for GORCMDD_DATA_ORIGIN (# 12)

Source Code Comments

DATA ORIGIN: Source system that created or updated the row

Table GORCMDH

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GORCMDH_CMSC_CODE	VARCHAR2(20)	No	*	*
GORCMDH_HIER_TYPE	VARCHAR2(4)	No	*
GORCMDH_HIER_SEQ_NO	NUMBER(2,0)	No	*
GORCMDH_HIER_CODE	VARCHAR2(4)	No
GORCMDH_USER_ID	VARCHAR2(30)	No
GORCMDH_ACTIVITY_DATE	DATE	No
GORCMDH_DATA_ORIGIN	VARCHAR2(30)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GORCMDH_CMSC_CODE	GTVCMSC_CODE	GTVCMSC

Index

Index Name	Index Type	Column Name
PK_GORCMDH	Unique	GORCMDH_CMSC_CODE
PK_GORCMDH	Unique	GORCMDH_HIER_TYPE
PK_GORCMDH	Unique	GORCMDH_HIER_SEQ_NO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
CM_DISP_HIER_REC	Oracle Package Type	S10B80.BANINST1.GB_CM_DISP_HIER	Rely On
P_OVERLAY_VALIDATION_REC	Oracle Package Procedure	S10B80.BANINST1.GB_CM_DISP_HIER	Rely On
F_BUILD_GORCMDH_REC	Oracle Package Function	S10B80.BANINST1.GB_CM_DISP_HIER	Rely On
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.GB_CM_DISP_HIER	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.DML_GORCMDH	Use (delete)
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.GB_CM_DISP_HIER	Rely On
P_INSERT	Oracle Package Procedure	S10B80.BANINST1.DML_GORCMDH	Use (Insert)Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.GB_CM_DISP_HIER	Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.GB_CM_DISP_HIER	Use (select)
P_REGISTER_ENTITY	Oracle Package Procedure	S10B80.BANINST1.GB_CM_DISP_HIER_RULES	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.DML_GORCMDH	Use (update)Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.GB_CM_DISP_HIER	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.GB_CM_DISP_HIER_RULES	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_CM_DISP_HIER	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_CM_DISP_HIER	Use (select)
F_EXISTS_BY_TYPE_SEQ_CODE	Oracle Package Function	S10B80.BANINST1.GB_CM_DISP_HIER	Rely On
F_EXISTS_BY_TYPE_SEQ_CODE	Oracle Package Function	S10B80.BANINST1.GB_CM_DISP_HIER	Use (select)
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.GB_CM_DISP_HIER	Rely On
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.GB_CM_DISP_HIER	Use (select)
F_QUERY_BY_ROWID	Oracle Package Function	S10B80.BANINST1.GB_CM_DISP_HIER	Use (select)
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.GB_CM_DISP_HIER	Rely On
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.GB_CM_DISP_HIER	Use (select)
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.GB_CM_DISP_HIER	Rely On
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.GB_CM_DISP_HIER	Use (select)
GORCMDH	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_GORCMDH	SQL Index	S10B80.GENERAL	Rely On
GTVCMSC	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GORCMDH

Object Dates

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

Source Code Comments

Common Matching Display Hierarchy Table

Columns Comments for GORCMDH_CMSC_CODE (# 1)

Source Code Comments

COMMON MATCHING SOURCE CODE: The Common Matching Source Code.

Columns Comments for GORCMDH_HIER_TYPE (# 2)

Source Code Comments

HIERARCHY TYPE: Contains 1 of 3 values: ATYP for Address Type, EMAL for E-mail Type, or TELE for Telephone Type.

Columns Comments for GORCMDH_HIER_SEQ_NO (# 3)

Source Code Comments

HIERARCHY TYPE SEQUENCE NUMBER: Sequence of the Hierarchy code within the the Hierarchy type.

Columns Comments for GORCMDH_HIER_CODE (# 4)

Source Code Comments

HIERARCHY CODE: Hierarchy code for the Hierarchy type. Validated against STVATYP, GTVEMAL, or STVTELE.

Columns Comments for GORCMDH_USER_ID (# 5)

Source Code Comments

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

Columns Comments for GORCMDH_ACTIVITY_DATE (# 6)

Source Code Comments

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

Columns Comments for GORCMDH_DATA_ORIGIN (# 7)

Source Code Comments

DATA ORIGIN: Source system that created or updated the row

Table GORCMDO

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GORCMDO_CMSC_CODE	VARCHAR2(20)	No	*	*
GORCMDO_OBJS_NAME	VARCHAR2(30)	No	*
GORCMDO_SEQ_NO	NUMBER(1,0)	No
GORCMDO_USER_ID	VARCHAR2(30)	No
GORCMDO_ACTIVITY_DATE	DATE	No
GORCMDO_DATA_ORIGIN	VARCHAR2(30)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GORCMDO_CMSC_CODE	GORCMSC_CMSC_CODE	GORCMSC

Index

Index Name	Index Type	Column Name
PK_GORCMDO	Unique	GORCMDO_CMSC_CODE
PK_GORCMDO	Unique	GORCMDO_OBJS_NAME

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GORCMDO_ADD	SQL View	S10B80.BANINST1	Use (select)
GORCMDO_ADS	SQL View	S10B80.BANINST1	Use (select)
GORCMDO_SUB	SQL View	S10B80.BANINST1	Use (select)
CM_DISPLAY_OPTIONS_REC	Oracle Package Type	S10B80.BANINST1.GB_CM_DISPLAY_OPTIONS	Rely On
P_OVERLAY_VALIDATION_REC	Oracle Package Procedure	S10B80.BANINST1.GB_CM_DISPLAY_OPTIONS	Rely On
F_BUILD_GORCMDO_REC	Oracle Package Function	S10B80.BANINST1.GB_CM_DISPLAY_OPTIONS	Rely On
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.GB_CM_DISPLAY_OPTIONS	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.DML_GORCMDO	Use (delete)
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.GB_CM_DISPLAY_OPTIONS	Rely On
P_INSERT	Oracle Package Procedure	S10B80.BANINST1.DML_GORCMDO	Use (Insert)Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.GB_CM_DISPLAY_OPTIONS	Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.GB_CM_DISPLAY_OPTIONS	Use (select)
P_REGISTER_ENTITY	Oracle Package Procedure	S10B80.BANINST1.GB_CM_DISPLAY_OPTIONS_RULES	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.DML_GORCMDO	Use (update)Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.GB_CM_DISPLAY_OPTIONS	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.GB_CM_DISPLAY_OPTIONS_RULES	Rely On
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_CM_SOURCE_RULES	Use (Insert,select)
F_CODE_EXISTS_IN_TABLE	Oracle Package Function	S10B80.BANINST1.GB_GTVCMSC	Use (select)
F_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_CM_DISPLAY_OPTIONS	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_CM_DISPLAY_OPTIONS	Use (select)
F_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_CM_DISPLAY_OPTIONS	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_CM_DISPLAY_OPTIONS	Use (select)
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.GB_CM_DISPLAY_OPTIONS	Rely On
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.GB_CM_DISPLAY_OPTIONS	Use (select)
F_QUERY_BY_ROWID	Oracle Package Function	S10B80.BANINST1.GB_CM_DISPLAY_OPTIONS	Use (select)
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.GB_CM_DISPLAY_OPTIONS	Rely On
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.GB_CM_DISPLAY_OPTIONS	Use (select)
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.GB_CM_DISPLAY_OPTIONS	Rely On
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.GB_CM_DISPLAY_OPTIONS	Use (select)
GORCMDO	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_GORCMDO	SQL Index	S10B80.GENERAL	Rely On
GORCMSC	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GORCMDO

Object Dates

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

Source Code Comments

Common Matching Display Options Table

Columns Comments for GORCMDO_CMSC_CODE (# 1)

Source Code Comments

COMMON MATCHING SOURCE CODE: The Common Matching Source Code to associate the forms to be called on the Match Entry Process.

Columns Comments for GORCMDO_OBJS_NAME (# 2)

Source Code Comments

OBJECT NAME: The SCT Banner Form to be displayed and called based on the Common Matching Source Code in the Key-Block of the Match Entry Process Form.

Columns Comments for GORCMDO_SEQ_NO (# 3)

Source Code Comments

SEQUENCE NUMBER: The order in which to display the form names.

Columns Comments for GORCMDO_USER_ID (# 4)

Source Code Comments

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

Columns Comments for GORCMDO_ACTIVITY_DATE (# 5)

Source Code Comments

ACTIVITY DATE: Date record was created or last updated.

Columns Comments for GORCMDO_DATA_ORIGIN (# 6)

Source Code Comments

DATA ORIGIN: Source system that created or updated the row

Table GORCMSC

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GORCMSC_CMSC_CODE	VARCHAR2(20)	No	*	*
GORCMSC_ONLINE_MATCH_IND	VARCHAR2(1)	No
GORCMSC_ENTITY_CDE	VARCHAR2(1)	No
GORCMSC_USER_ID	VARCHAR2(30)	No
GORCMSC_ACTIVITY_DATE	DATE	No
GORCMSC_ATYP_CODE	VARCHAR2(2)	Yes		*
GORCMSC_TELE_CODE	VARCHAR2(4)	Yes		*
GORCMSC_EMAL_CODE	VARCHAR2(4)	Yes		*
GORCMSC_DATA_ORIGIN	VARCHAR2(30)	Yes
GORCMSC_TRANSPOSE_DATE_IND	VARCHAR2(1)	No
GORCMSC_TRANSPOSE_NAME_IND	VARCHAR2(1)	No
GORCMSC_ALIAS_WILDCARD_IND	VARCHAR2(1)	No
GORCMSC_LENGTH_OVERRIDE_IND	VARCHAR2(1)	No
GORCMSC_API_FAILURE_IND	VARCHAR2(1)	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
GORCMSC_CMSC_CODE	GTVCMSC_CODE	GTVCMSC
GORCMSC_EMAL_CODE	GTVEMAL_CODE	GTVEMAL
GORCMSC_ATYP_CODE	STVATYP_CODE	STVATYP
GORCMSC_TELE_CODE	STVTELE_CODE	STVTELE

Index

Index Name	Index Type	Column Name
PK_GORCMSC	Unique	GORCMSC_CMSC_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GORCMDO	SQL Table	S10B80.GENERAL	Refer (no action)
GORCMSP	SQL Table	S10B80.GENERAL	Refer (no action)
GORSDAV	SQL Table	S10B80.GENERAL	Join
GORCMSC_ADD	SQL View	S10B80.BANINST1	Use (select)
GORCMSC_ADS	SQL View	S10B80.BANINST1	Use (select)
CM_SOURCE_RULES_REC	Oracle Package Type	S10B80.BANINST1.GB_CM_SOURCE_RULES	Rely On
P_GET_ENTITY_CDE	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Rely On
P_OVERLAY_VALIDATION_REC	Oracle Package Procedure	S10B80.BANINST1.GB_CM_SOURCE_RULES	Rely On
GV_ALIAS_WILDCARD_IND	Oracle Package Variable	S10B80.BANINST1.GOKCMPK	Rely On
GV_ENTITY_CDE	Oracle Package Variable	S10B80.BANINST1.GOKCMPK	Rely On
GV_LENGTH_OVERRIDE_IND	Oracle Package Variable	S10B80.BANINST1.GOKCMPK	Rely On
GV_TRANSPOSE_DATE_IND	Oracle Package Variable	S10B80.BANINST1.GOKCMPK	Rely On
GV_TRANSPOSE_NAME_IND	Oracle Package Variable	S10B80.BANINST1.GOKCMPK	Rely On
F_BUILD_GORCMSC_REC	Oracle Package Function	S10B80.BANINST1.GB_CM_SOURCE_RULES	Rely On
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.GB_CM_SOURCE_RULES	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.DML_GORCMSC	Use (delete)
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.GB_CM_SOURCE_RULES	Rely On
P_INSERT	Oracle Package Procedure	S10B80.BANINST1.DML_GORCMSC	Use (Insert)Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.GB_CM_SOURCE_RULES	Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.GB_CM_SOURCE_RULES	Use (select)
P_REGISTER_ENTITY	Oracle Package Procedure	S10B80.BANINST1.GB_CM_SOURCE_RULES_RULES	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.DML_GORCMSC	Use (update)Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.GB_CM_SOURCE_RULES	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.GB_CM_RULES_RULES	Use (select)
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.GB_CM_SOURCE_RULES_RULES	Rely On
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_CM_DISPLAY_OPTIONS	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_CM_DISP_HIER	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_CM_USER_PROCEDURE	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_CM_SOURCE_RULES	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_CM_SOURCE_PRIORITY	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_CM_RULES	Use (Insert,select)
F_CODE_EXISTS_IN_TABLE	Oracle Package Function	S10B80.BANINST1.GB_GTVCMSC	Use (select)
F_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_CM_SOURCE_RULES	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_CM_SOURCE_RULES	Use (select)
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.GB_CM_SOURCE_RULES	Rely On
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.GB_CM_SOURCE_RULES	Use (select)
F_QUERY_BY_ROWID	Oracle Package Function	S10B80.BANINST1.GB_CM_SOURCE_RULES	Use (select)
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.GB_CM_SOURCE_RULES	Rely On
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.GB_CM_SOURCE_RULES	Use (select)
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.GB_CM_SOURCE_RULES	Rely On
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.GB_CM_SOURCE_RULES	Use (select)
GORCMSC	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_GORCMSC	SQL Index	S10B80.GENERAL	Rely On
GTVCMSC	SQL Table	S10B80.GENERAL	Refer (no action)
GTVEMAL	SQL Table	S10B80.GENERAL	Refer (no action)
STVATYP	SQL Table	S10B80.SATURN	Refer (no action)
STVTELE	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GORCMSC

Object Dates

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

Source Code Comments

Common Matching Source Code Rules Table

Columns Comments for GORCMSC_CMSC_CODE (# 1)

Source Code Comments

COMMON MATCHING SOURCE CODE: Common Matching Source Code associated with these rules.

Columns Comments for GORCMSC_ONLINE_MATCH_IND (# 2)

Source Code Comments

ON-LINE INDICATOR: Y/N indicates if the Source Code and associated rules (table gorcmsr) will be used for Common Matching when run on-line from a form.

Columns Comments for GORCMSC_ENTITY_CDE (# 3)

Source Code Comments

ENTITY INDICATOR: Identifies if the Source will be matching person (P), non-person (C), or both (B) entity types when selecting SPRIDEN records.

Columns Comments for GORCMSC_USER_ID (# 4)

Source Code Comments

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

Columns Comments for GORCMSC_ACTIVITY_DATE (# 5)

Source Code Comments

ACTIVITY DATE: Date record was created or last updated.

Columns Comments for GORCMSC_ATYP_CODE (# 6)

Source Code Comments

ADDRESS TYPE CODE: Address type to use when creating a new address record for this source.

Columns Comments for GORCMSC_TELE_CODE (# 7)

Source Code Comments

TELEPHONE TYPE CODE: Telephone type code to use when creating a new telephone record for this source.

Columns Comments for GORCMSC_EMAL_CODE (# 8)

Source Code Comments

E-MAIL TYPE CODE: E-mail type code to use when creating a new e-mail record for this source.

Columns Comments for GORCMSC_DATA_ORIGIN (# 9)

Source Code Comments

DATA ORIGIN: Source system that created or updated the row

Columns Comments for GORCMSC_TRANSPOSE_DATE_IND (# 10)

Source Code Comments

TRANSPOSE DATE INDICATOR: Option allows birthdate day/month to also be checked as month/day. Valid values are Y to allow date transposing or N to disallow date transposing. Default is N.

Columns Comments for GORCMSC_TRANSPOSE_NAME_IND (# 11)

Source Code Comments

TRANSPOSE NAME INDICATOR: Option allows First Name/Last Name to also be checked as Last Name/First Name. Valid values are Y to allow name transposing or N to disallow transposing. Default is N.

Columns Comments for GORCMSC_ALIAS_WILDCARD_IND (# 12)

Source Code Comments

ALIAS WILDCARD INDICATOR: Option allows wildcard searching when performing name alias look ups. Valid values are Y to allow wildcard searching or N to disallow wildcard searching. Default is N.

Columns Comments for GORCMSC_LENGTH_OVERRIDE_IND (# 13)

Source Code Comments

LENGTH OVERRIDE INDICATOR: Option allows data length to override rule length if length entered is less than rule length. Valid values are Y to override or N to not override. Default is N.

Columns Comments for GORCMSC_API_FAILURE_IND (# 14)

Source Code Comments

API FAILURE INDICATOR: Option prevents creation of ID if address, phone, or email api fail during the Create ID process. Y prevents the creation fo the ID. Default is N.

Table GORCMSP

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GORCMSP_CMSC_CODE	VARCHAR2(20)	No	*	*
GORCMSP_PRIORITY_NO	NUMBER(2,0)	No	*
GORCMSP_DESC	VARCHAR2(60)	No
GORCMSP_USER_ID	VARCHAR2(30)	No
GORCMSP_ACTIVITY_DATE	DATE	No
GORCMSP_DATA_ORIGIN	VARCHAR2(30)	Yes
GORCMSP_LONG_DESC	VARCHAR2(4000)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GORCMSP_CMSC_CODE	GORCMSC_CMSC_CODE	GORCMSC

Index

Index Name	Index Type	Column Name
PK_GORCMSP	Unique	GORCMSP_CMSC_CODE
PK_GORCMSP	Unique	GORCMSP_PRIORITY_NO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GORCMSR	SQL Table	S10B80.GENERAL	Refer (no action)
GORCMUP	SQL Table	S10B80.GENERAL	Refer (no action)
CM_SOURCE_PRIORITY_REC	Oracle Package Type	S10B80.BANINST1.GB_CM_SOURCE_PRIORITY	Rely On
P_OVERLAY_VALIDATION_REC	Oracle Package Procedure	S10B80.BANINST1.GB_CM_SOURCE_PRIORITY	Rely On
UT_GB_CM_SOURCE_PRIORITYD_API	Oracle Package Procedure	S10B80.BANINST1.UT_GB_CM_SOURCE_PRIORITY	Use (Insert)
F_BUILD_GORCMSP_REC	Oracle Package Function	S10B80.BANINST1.GB_CM_SOURCE_PRIORITY	Rely On
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.GB_CM_SOURCE_PRIORITY	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.DML_GORCMSP	Use (delete)
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.GB_CM_SOURCE_PRIORITY	Rely On
P_INSERT	Oracle Package Procedure	S10B80.BANINST1.DML_GORCMSP	Use (Insert)Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.GB_CM_SOURCE_PRIORITY	Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.GB_CM_SOURCE_PRIORITY	Use (select)
P_REGISTER_ENTITY	Oracle Package Procedure	S10B80.BANINST1.GB_CM_SOURCE_PRIORITY_RULES	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.DML_GORCMSP	Use (update)Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.GB_CM_SOURCE_PRIORITY	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.GB_CM_RULES_RULES	Use (select)
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.GB_CM_SOURCE_PRIORITY_RULES	Rely On
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_CM_USER_PROCEDURE	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_CM_SOURCE_RULES	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_CM_SOURCE_PRIORITY	Use (select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_CM_RULES	Use (Insert,select)
F_CODE_EXISTS_IN_TABLE	Oracle Package Function	S10B80.BANINST1.GB_GTVCMSC	Use (select)
F_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_CM_SOURCE_PRIORITY	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_CM_SOURCE_PRIORITY	Use (select)
F_PARENT_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_CM_RULES_RULES	Use (select)
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.GB_CM_SOURCE_PRIORITY	Rely On
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.GB_CM_SOURCE_PRIORITY	Use (select)
F_QUERY_ALL_BY_CMSC	Oracle Package Function	S10B80.BANINST1.GB_CM_SOURCE_PRIORITY	Rely On
F_QUERY_ALL_BY_CMSC	Oracle Package Function	S10B80.BANINST1.GB_CM_SOURCE_PRIORITY	Use (select)
F_QUERY_BY_ROWID	Oracle Package Function	S10B80.BANINST1.GB_CM_SOURCE_PRIORITY	Use (select)
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.GB_CM_SOURCE_PRIORITY	Rely On
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.GB_CM_SOURCE_PRIORITY	Use (select)
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.GB_CM_SOURCE_PRIORITY	Rely On
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.GB_CM_SOURCE_PRIORITY	Use (select)
GORCMSP	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_GORCMSP	SQL Index	S10B80.GENERAL	Rely On
GORCMSC	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GORCMSP

Object Dates

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

Source Code Comments

Common Matching Source Priority Table.

Columns Comments for GORCMSP_CMSC_CODE (# 1)

Source Code Comments

SOURCE CODE: Common Matching Source Code associated with rules.

Columns Comments for GORCMSP_PRIORITY_NO (# 2)

Source Code Comments

PRIORITY NUMBER: The priority number of rule to be processed.

Columns Comments for GORCMSP_DESC (# 3)

Source Code Comments

DESCRIPTION: Priority number description.

Columns Comments for GORCMSP_USER_ID (# 4)

Source Code Comments

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

Columns Comments for GORCMSP_ACTIVITY_DATE (# 5)

Source Code Comments

ACTIVITY DATE: Date record was created or last updated.

Columns Comments for GORCMSP_DATA_ORIGIN (# 6)

Source Code Comments

DATA ORIGIN: Source system that created or updated the row

Columns Comments for GORCMSP_LONG_DESC (# 7)

Source Code Comments

Column to hold a long description.

Table GORCMSR

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GORCMSR_CMSC_CODE	VARCHAR2(20)	No	*	*
GORCMSR_PRIORITY_NO	NUMBER(2,0)	No	*	*
GORCMSR_COLUMN_NAME	VARCHAR2(30)	No	*	*
GORCMSR_LENGTH	NUMBER(3,0)	No
GORCMSR_DATA_REQ_IND	VARCHAR2(1)	No
GORCMSR_USER_ID	VARCHAR2(30)	No
GORCMSR_ACTIVITY_DATE	DATE	No
GORCMSR_DATA_ORIGIN	VARCHAR2(30)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GORCMSR_COLUMN_NAME	GORCMDD_COLUMN_NAME	GORCMDD
GORCMSR_CMSC_CODE	GORCMSP_CMSC_CODE	GORCMSP
GORCMSR_PRIORITY_NO	GORCMSP_PRIORITY_NO	GORCMSP

Index

Index Name	Index Type	Column Name
PK_GORCMSR	Unique	GORCMSR_CMSC_CODE
PK_GORCMSR	Unique	GORCMSR_PRIORITY_NO
PK_GORCMSR	Unique	GORCMSR_COLUMN_NAME

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GORCMSR_ADD	SQL View	S10B80.BANINST1	Use (select)
GORCMSR_ADS	SQL View	S10B80.BANINST1	Use (select)
CM_RULES_REC	Oracle Package Type	S10B80.BANINST1.GB_CM_RULES	Rely On
DATARECORDTYP	Oracle Package Type	S10B80.BANINST1.GOKCMPK	Rely On
CMSR_CUR	Oracle Package Cursor	S10B80.BANINST1.IMF_SERVICE2	Use (select)
RULERECORDTYP	Oracle Package Type	S10B80.BANINST1.GOKCMPK	Rely On
P_CHECK_NET_USER	Oracle Package Procedure	S10B80.BANINST1.IMF_SERVICE2	Use (select)
P_GET_ENTITY_CDE	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Rely On
P_GET_RULES	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Rely On
P_INSERT_NAMES	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Rely On
P_LVH_INSERT_NAMES	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Rely On
P_MATCH_ID	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Rely On
P_OPEN_SABSUPL_CV	Oracle Package Procedure	S10B80.BANINST1.SAKMTCH	Use (select)
P_OPEN_SORHSCH_CV	Oracle Package Procedure	S10B80.BANINST1.SAKMTCH	Use (select)
P_OPEN_SORHSCH_CV	Oracle Package Procedure	S10B80.BANINST1.GOKDEBT	Use (select)
P_OVERLAY_VALIDATION_REC	Oracle Package Procedure	S10B80.BANINST1.GB_CM_RULES	Rely On
P_POPULATE_DATAREC	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Rely On
P_PRIMARY_MATCH_ID	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Rely On
P_PRIMARY_MATCH_NAME	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Rely On
P_PRIMARY_MATCH_SSN	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Rely On
P_PROCESS_GORCMUP	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Rely On
P_PROCESS_SECONDARY_MATCHES	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Rely On
UT_GB_CM_SOURCE_PRIORITYD_API	Oracle Package Procedure	S10B80.BANINST1.UT_GB_CM_SOURCE_PRIORITY	Use (Insert)
GV_DATA_REQ_IND	Oracle Package Variable	S10B80.BANINST1.GOKCMPK	Rely On
GV_LENGTH	Oracle Package Variable	S10B80.BANINST1.GOKCMPK	Rely On
GV_START	Oracle Package Variable	S10B80.BANINST1.GOKCMPK	Rely On
F_BUILD_GORCMSR_REC	Oracle Package Function	S10B80.BANINST1.GB_CM_RULES	Rely On
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.GB_CM_RULES	Rely On
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.GB_CM_RULES	Use (select)
P_COMMON_MATCHING	Oracle Package Procedure	S10B80.BANINST1.GP_COMMON_MATCHING	Rely On
P_COMMON_MATCHING	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Rely On
P_COMMON_MATCHING	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Use (select)
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.GB_CM_RULES	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.DML_GORCMSR	Use (delete)
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.GB_CM_RULES	Rely On
P_INSERT	Oracle Package Procedure	S10B80.BANINST1.DML_GORCMSR	Use (Insert)Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.GB_CM_RULES	Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.GB_CM_RULES	Use (select)
P_PA_GTVCMSC_EQUAL	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Use (select)
P_REGISTER_ENTITY	Oracle Package Procedure	S10B80.BANINST1.GB_CM_RULES_RULES	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.DML_GORCMSR	Use (update)Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.GB_CM_RULES	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.GB_CM_RULES_RULES	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.GB_CM_SOURCE_RULES_RULES	Use (select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_CM_USER_PROCEDURE	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GP_PERSON_IDENTITY	Use (select)
F_ALL_REQD_ADDED	Oracle Package Function	S10B80.BANINST1.GB_CM_RULES	Rely On
F_ALL_REQD_ADDED	Oracle Package Function	S10B80.BANINST1.GB_CM_RULES	Use (select)
F_CODE_EXISTS_IN_TABLE	Oracle Package Function	S10B80.BANINST1.GB_GTVCMSC	Use (select)
F_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_CM_RULES	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_CM_RULES	Use (select)
F_EXISTS_BY_COLUMN	Oracle Package Function	S10B80.BANINST1.GB_CM_RULES	Rely On
F_EXISTS_BY_COLUMN	Oracle Package Function	S10B80.BANINST1.GB_CM_RULES	Use (select)
F_PARENT_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_CM_RULES_RULES	Rely On
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.GB_CM_RULES	Rely On
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.GB_CM_RULES	Use (select)
F_QUERY_BY_ROWID	Oracle Package Function	S10B80.BANINST1.GB_CM_RULES	Use (select)
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.GB_CM_RULES	Rely On
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.GB_CM_RULES	Use (select)
F_RULES_EXISTS	Oracle Package Function	S10B80.BANINST1.GOKCMPK	Rely On
F_TABLE_RULE_EXISTS	Oracle Package Function	S10B80.BANINST1.GOKCMPK	Rely On
F_TABLE_RULE_EXISTS	Oracle Package Function	S10B80.BANINST1.GOKCMPK	Use (select)
GORCMSR	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_GORCMSR	SQL Index	S10B80.GENERAL	Rely On
GORCMDD	SQL Table	S10B80.GENERAL	Refer (no action)
GORCMSP	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GORCMSR

Object Dates

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

Source Code Comments

Common Matching Rules Table

Columns Comments for GORCMSR_CMSC_CODE (# 1)

Source Code Comments

SOURCE CODE: Common Matching Source Code associated with rules.

Columns Comments for GORCMSR_PRIORITY_NO (# 2)

Source Code Comments

PRIORITY NUMBER: Priority number of rule to be processed.

Columns Comments for GORCMSR_COLUMN_NAME (# 3)

Source Code Comments

COLUMN NAME: Database column name associated with element used for Common Matching process.

Columns Comments for GORCMSR_LENGTH (# 4)

Source Code Comments

LENGTH: Number of characters that will be matched in Common Matching process.

Columns Comments for GORCMSR_DATA_REQ_IND (# 5)

Source Code Comments

DATA REQUIRED INDICATOR: Indicates if data is required both in the database and from the input source (R) or if the data may be null either in the database or the input source (Y). Valid values are R, Y.

Columns Comments for GORCMSR_USER_ID (# 6)

Source Code Comments

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

Columns Comments for GORCMSR_ACTIVITY_DATE (# 7)

Source Code Comments

ACTIVITY DATE: Date record was created or last updated.

Columns Comments for GORCMSR_DATA_ORIGIN (# 8)

Source Code Comments

DATA ORIGIN: Source system that created or updated the row

Table GORCMUP

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GORCMUP_CMSC_CODE	VARCHAR2(20)	No	*	*
GORCMUP_PRIORITY_NO	NUMBER(2,0)	No	*	*
GORCMUP_SEQ_NO	NUMBER(2,0)	No	*
GORCMUP_PROCEDURE_NAME	VARCHAR2(95)	No
GORCMUP_USER_ID	VARCHAR2(30)	No
GORCMUP_ACTIVITY_DATE	DATE	No
GORCMUP_DATA_ORIGIN	VARCHAR2(30)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GORCMUP_CMSC_CODE	GORCMSP_CMSC_CODE	GORCMSP
GORCMUP_PRIORITY_NO	GORCMSP_PRIORITY_NO	GORCMSP

Index

Index Name	Index Type	Column Name
PK_GORCMUP	Unique	GORCMUP_CMSC_CODE
PK_GORCMUP	Unique	GORCMUP_PRIORITY_NO
PK_GORCMUP	Unique	GORCMUP_SEQ_NO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
CM_USER_PROCEDURE_REC	Oracle Package Type	S10B80.BANINST1.GB_CM_USER_PROCEDURE	Rely On
P_OVERLAY_VALIDATION_REC	Oracle Package Procedure	S10B80.BANINST1.GB_CM_USER_PROCEDURE	Rely On
P_PROCESS_GORCMUP	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Rely On
P_PROCESS_GORCMUP	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Use (select)
F_BUILD_GORCMUP_REC	Oracle Package Function	S10B80.BANINST1.GB_CM_USER_PROCEDURE	Rely On
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.GB_CM_USER_PROCEDURE	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.DML_GORCMUP	Use (delete)
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.GB_CM_USER_PROCEDURE	Rely On
P_INSERT	Oracle Package Procedure	S10B80.BANINST1.DML_GORCMUP	Use (Insert)Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.GB_CM_USER_PROCEDURE	Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.GB_CM_USER_PROCEDURE	Use (select)
P_REGISTER_ENTITY	Oracle Package Procedure	S10B80.BANINST1.GB_CM_USER_PROCEDURE_RULES	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.DML_GORCMUP	Use (update)Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.GB_CM_USER_PROCEDURE	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.GB_CM_USER_PROCEDURE_RULES	Rely On
F_CODE_EXISTS_IN_TABLE	Oracle Package Function	S10B80.BANINST1.GB_GTVCMSC	Use (select)
F_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_CM_USER_PROCEDURE	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_CM_USER_PROCEDURE	Use (select)
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.GB_CM_USER_PROCEDURE	Rely On
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.GB_CM_USER_PROCEDURE	Use (select)
F_QUERY_BY_ROWID	Oracle Package Function	S10B80.BANINST1.GB_CM_USER_PROCEDURE	Use (select)
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.GB_CM_USER_PROCEDURE	Rely On
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.GB_CM_USER_PROCEDURE	Use (select)
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.GB_CM_USER_PROCEDURE	Rely On
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.GB_CM_USER_PROCEDURE	Use (select)
GORCMUP	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_GORCMUP	SQL Index	S10B80.GENERAL	Rely On
GORCMSP	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GORCMUP

Object Dates

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

Source Code Comments

Common Matching User Procedure Table.

Columns Comments for GORCMUP_CMSC_CODE (# 1)

Source Code Comments

SOURCE CODE: Common Matching Source Code associated with user procedure.

Columns Comments for GORCMUP_PRIORITY_NO (# 2)

Source Code Comments

PRIORITY NUMBER: Priority number associated with the user procedure.

Columns Comments for GORCMUP_SEQ_NO (# 3)

Source Code Comments

SEQUENCE NUMBER: The order in which to execute the user procedure.

Columns Comments for GORCMUP_PROCEDURE_NAME (# 4)

Source Code Comments

PROCEDURE NAME: Procedure name associated with rules to be used for Common Matching.

Columns Comments for GORCMUP_USER_ID (# 5)

Source Code Comments

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

Columns Comments for GORCMUP_ACTIVITY_DATE (# 6)

Source Code Comments

ACTIVITY DATE: Date record was created or last updated.

Columns Comments for GORCMUP_DATA_ORIGIN (# 7)

Source Code Comments

DATA ORIGIN: Source system that created or updated the row

Table GORNAME

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GORNAME_NAME	VARCHAR2(60)	No	*
GORNAME_ALIAS	VARCHAR2(60)	No	*
GORNAME_USER_ID	VARCHAR2(30)	No
GORNAME_ACTIVITY_DATE	DATE	No
GORNAME_DATA_ORIGIN	VARCHAR2(30)	Yes
GORNAME_NAME_COMPRESS	VARCHAR2(60)	Yes
GORNAME_ALIAS_COMPRESS	VARCHAR2(60)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
GORNAME_INDEX_COMPRESS		GORNAME_NAME_COMPRESS
GORNAME_INDEX_COMPRESS		GORNAME_ALIAS_COMPRESS
PK_GORNAME	Unique	GORNAME_NAME
PK_GORNAME	Unique	GORNAME_ALIAS

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
NAME_TRANSLATE_REC	Oracle Package Type	S10B80.BANINST1.GB_NAME_TRANSLATE	Rely On
P_OVERLAY_VALIDATION_REC	Oracle Package Procedure	S10B80.BANINST1.GB_NAME_TRANSLATE	Rely On
F_BUILD_GORNAME_REC	Oracle Package Function	S10B80.BANINST1.GB_NAME_TRANSLATE	Rely On
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.GB_NAME_TRANSLATE	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.GB_NAME_TRANSLATE	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.DML_GORNAME	Use (delete)
P_INSERT	Oracle Package Procedure	S10B80.BANINST1.DML_GORNAME	Use (Insert)Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.GB_NAME_TRANSLATE	Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.GB_NAME_TRANSLATE	Use (select)
P_REGISTER_ENTITY	Oracle Package Procedure	S10B80.BANINST1.GB_NAME_TRANSLATE_RULES	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.GB_NAME_TRANSLATE_RULES	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_NAME_TRANSLATE	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_NAME_TRANSLATE	Use (select)
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.GB_NAME_TRANSLATE	Rely On
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.GB_NAME_TRANSLATE	Use (select)
F_QUERY_BY_ROWID	Oracle Package Function	S10B80.BANINST1.GB_NAME_TRANSLATE	Use (select)
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.GB_NAME_TRANSLATE	Rely On
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.GB_NAME_TRANSLATE	Use (select)
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.GB_NAME_TRANSLATE	Rely On
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.GB_NAME_TRANSLATE	Use (select)
F_TEST_NAME	Oracle Package Function	S10B80.BANINST1.GOKCMPK	Use (select)
GORNAME	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
GORNAME_INDEX_COMPRESS	SQL Index	S10B80.GENERAL	Rely On
PK_GORNAME	SQL Index	S10B80.GENERAL	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GORNAME

Object Dates

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

Source Code Comments

Common Matching Person Name Translation Table.

Columns Comments for GORNAME_NAME (# 1)

Source Code Comments

NAME: Given name of the person. May be used for first name or middle name.

Columns Comments for GORNAME_ALIAS (# 2)

Source Code Comments

ALIAS: Alias or nickname associated with name.

Columns Comments for GORNAME_USER_ID (# 3)

Source Code Comments

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

Columns Comments for GORNAME_ACTIVITY_DATE (# 4)

Source Code Comments

ACTIVITY DATE: Date record was created or last updated.

Columns Comments for GORNAME_DATA_ORIGIN (# 5)

Source Code Comments

DATA ORIGIN: Source system that created or updated the row

Columns Comments for GORNAME_NAME_COMPRESS (# 6)

Source Code Comments

COMPRESSED NAME: Compressed, uppercase version of the name.

Table GORNPNM

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GORNPNM_NAME	VARCHAR2(60)	No	*
GORNPNM_ALIAS	VARCHAR2(60)	No	*
GORNPNM_USER_ID	VARCHAR2(30)	No
GORNPNM_ACTIVITY_DATE	DATE	No
GORNPNM_DATA_ORIGIN	VARCHAR2(30)	Yes
GORNPNM_NAME_COMPRESS	VARCHAR2(60)	Yes
GORNPNM_ALIAS_COMPRESS	VARCHAR2(60)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
GORNPNM_ALIAS_INDEX_COMPRESS		GORNPNM_ALIAS_COMPRESS
GORNPNM_INDEX_COMPRESS		GORNPNM_NAME_COMPRESS
GORNPNM_INDEX_COMPRESS		GORNPNM_ALIAS_COMPRESS
PK_GORNPNM	Unique	GORNPNM_NAME
PK_GORNPNM	Unique	GORNPNM_ALIAS

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
NP_NAME_TRANS_REC	Oracle Package Type	S10B80.BANINST1.GB_NP_NAME_TRANS	Rely On
P_OVERLAY_VALIDATION_REC	Oracle Package Procedure	S10B80.BANINST1.GB_NP_NAME_TRANS	Rely On
F_BUILD_GORNPNM_REC	Oracle Package Function	S10B80.BANINST1.GB_NP_NAME_TRANS	Rely On
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.GB_NP_NAME_TRANS	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.GB_NP_NAME_TRANS	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.DML_GORNPNM	Use (delete)
P_INSERT	Oracle Package Procedure	S10B80.BANINST1.DML_GORNPNM	Use (Insert)Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.GB_NP_NAME_TRANS	Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.GB_NP_NAME_TRANS	Use (select)
P_REGISTER_ENTITY	Oracle Package Procedure	S10B80.BANINST1.GB_NP_NAME_TRANS_RULES	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.GB_NP_NAME_TRANS_RULES	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_NP_NAME_TRANS	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_NP_NAME_TRANS	Use (select)
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.GB_NP_NAME_TRANS	Rely On
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.GB_NP_NAME_TRANS	Use (select)
F_QUERY_BY_ROWID	Oracle Package Function	S10B80.BANINST1.GB_NP_NAME_TRANS	Use (select)
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.GB_NP_NAME_TRANS	Rely On
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.GB_NP_NAME_TRANS	Use (select)
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.GB_NP_NAME_TRANS	Rely On
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.GB_NP_NAME_TRANS	Use (select)
F_TEST_NAME	Oracle Package Function	S10B80.BANINST1.GOKCMPK	Rely On
F_TEST_NP_NAME	Oracle Package Function	S10B80.BANINST1.GOKCMPK	Rely On
F_TEST_NP_NAME	Oracle Package Function	S10B80.BANINST1.GOKCMPK	Use (select)
GORNPNM	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
GORNPNM_ALIAS_INDEX_COMPRESS	SQL Index	S10B80.GENERAL	Rely On
GORNPNM_INDEX_COMPRESS	SQL Index	S10B80.GENERAL	Rely On
PK_GORNPNM	SQL Index	S10B80.GENERAL	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GORNPNM

Object Dates

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

Source Code Comments

Common Matching Non-Person Name Translation Table.

Columns Comments for GORNPNM_NAME (# 1)

Source Code Comments

NAME: Name of the non-person.

Columns Comments for GORNPNM_ALIAS (# 2)

Source Code Comments

ALIAS: Alias or nickname associated with name.

Columns Comments for GORNPNM_USER_ID (# 3)

Source Code Comments

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

Columns Comments for GORNPNM_ACTIVITY_DATE (# 4)

Source Code Comments

ACTIVITY DATE: Date record was created or last updated.

Columns Comments for GORNPNM_DATA_ORIGIN (# 5)

Source Code Comments

DATA ORIGIN: Source system that created or updated the row

Columns Comments for GORNPNM_NAME_COMPRESS (# 6)

Source Code Comments

COMPRESSED NAME: Compressed, uppercase version of the given name of the non-person.

Columns Comments for GORNPNM_ALIAS_COMPRESS (# 7)

Source Code Comments

COMPRESSED ALIAS: Compressed, uppercase version of the alias or nickname associated with name.

Table GOTCMME

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL
GOTCMME_LAST_NAME	VARCHAR2(60)	Yes
GOTCMME_ENTITY_CDE	VARCHAR2(1)	No
GOTCMME_FIRST_NAME	VARCHAR2(60)	Yes
GOTCMME_MI	VARCHAR2(60)	Yes
GOTCMME_ID	VARCHAR2(9)	Yes
GOTCMME_STREET_LINE1	VARCHAR2(75)	Yes
GOTCMME_STREET_LINE2	VARCHAR2(75)	Yes
GOTCMME_STREET_LINE3	VARCHAR2(75)	Yes
GOTCMME_CITY	VARCHAR2(50)	Yes
GOTCMME_STAT_CODE	VARCHAR2(3)	Yes
GOTCMME_ZIP	VARCHAR2(30)	Yes
GOTCMME_NATN_CODE	VARCHAR2(5)	Yes
GOTCMME_CNTY_CODE	VARCHAR2(5)	Yes
GOTCMME_PHONE_AREA	VARCHAR2(6)	Yes
GOTCMME_PHONE_NUMBER	VARCHAR2(12)	Yes
GOTCMME_PHONE_EXT	VARCHAR2(10)	Yes
GOTCMME_SSN	VARCHAR2(15)	Yes
GOTCMME_BIRTH_DAY	VARCHAR2(2)	Yes
GOTCMME_BIRTH_MON	VARCHAR2(2)	Yes
GOTCMME_BIRTH_YEAR	VARCHAR2(4)	Yes
GOTCMME_SEX	VARCHAR2(1)	Yes
GOTCMME_EMAIL_ADDRESS	VARCHAR2(128)	Yes
GOTCMME_ATYP_CODE	VARCHAR2(2)	Yes
GOTCMME_TELE_CODE	VARCHAR2(4)	Yes
GOTCMME_EMAL_CODE	VARCHAR2(4)	Yes
GOTCMME_ASRC_CODE	VARCHAR2(4)	Yes
GOTCMME_CTRY_CODE_PHONE	VARCHAR2(4)	Yes
GOTCMME_HOUSE_NUMBER	VARCHAR2(10)	Yes
GOTCMME_STREET_LINE4	VARCHAR2(75)	Yes
GOTCMME_SURNAME_PREFIX	VARCHAR2(60)	Yes

Foreign Key information

No Foreign Key

Index

No Result

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
P_INSERT_NAMES	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Rely On
P_LVH_INSERT_NAMES	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Rely On
P_MATCH_GOREMAL	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Rely On
P_MATCH_ID	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Rely On
P_MATCH_NAME	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Rely On
P_MATCH_SPBPERS	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Rely On
P_MATCH_SPRADDR	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Rely On
P_MATCH_SPRTELE	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Rely On
P_OPEN_SORHSCH_CV	Oracle Package Procedure	S10B80.BANINST1.GOKDEBT	Rely On
P_OPEN_SPBPERS_CV	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Rely On
P_OPEN_SPRADDR_CV	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Rely On
P_OPEN_SPRTELE_CV	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Rely On
P_PRIMARY_MATCH_ID	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Rely On
P_PRIMARY_MATCH_NAME	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Rely On
P_PRIMARY_MATCH_SSN	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Rely On
P_PROCESS_GORCMUP	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Rely On
P_PROCESS_SECONDARY_MATCHES	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Rely On
P_COMMON_MATCHING	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Rely On
P_COMMON_MATCHING	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Use (select)Rely On
P_INSERT_GOTCMME	Oracle Package Procedure	S10B80.BANINST1.GP_COMMON_MATCHING	Rely On
P_INSERT_GOTCMME	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Rely On
P_INSERT_GOTCMME	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Use (Insert,delete)
P_MATCH_SORHSCH	Oracle Package Procedure	S10B80.BANINST1.GOKDEBT	Rely On
P_MATCH_SORHSCH	Oracle Package Procedure	S10B80.BANINST1.GOKDEBT	Use (select)Rely On
P_QUICK_ADMIT	Oracle Package Procedure	S10B80.BANINST1.SAKQADM	Rely On
GOTCMME	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GOTCMME

Object Dates

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

Source Code Comments

Common Matching Match Entry Global Temporary Table

Columns Comments for GOTCMME_LAST_NAME (# 1)

Source Code Comments

LAST NAME: The last name of the person or the name of the non-person to be created.

Columns Comments for GOTCMME_ENTITY_CDE (# 2)

Source Code Comments

ENTITY INDICATOR: Identifies whether record is person or non-person to be created. It does not display on the form. Valid values P = person, C = non-person.

Columns Comments for GOTCMME_FIRST_NAME (# 3)

Source Code Comments

FIRST NAME: The name of the person to be created.

Columns Comments for GOTCMME_MI (# 4)

Source Code Comments

MIDDLE NAME: The middle name of the person to be created.

Columns Comments for GOTCMME_ID (# 5)

Source Code Comments

ID: Identification Number for the person or non-person record to be created.

Columns Comments for GOTCMME_STREET_LINE1 (# 6)

Source Code Comments

ADDRESS LINE 1: The first line of the address of the person/non-person to be created.

Columns Comments for GOTCMME_STREET_LINE2 (# 7)

Source Code Comments

ADDRESS LINE 2: The second line of the address of the person/non-person to be created.

Columns Comments for GOTCMME_STREET_LINE3 (# 8)

Source Code Comments

ADDRESS LINE 3: The third line of the address of the person/non-person to be created.

Columns Comments for GOTCMME_CITY (# 9)

Source Code Comments

CITY: The city associated with the address of the person/non-person to be created.

Columns Comments for GOTCMME_STAT_CODE (# 10)

Source Code Comments

STATE:The state or province code associated with the address of the person/non-person to be created.

Columns Comments for GOTCMME_ZIP (# 11)

Source Code Comments

ZIP: The zip or postal code associated with the address of the person/non-person to be created.

Columns Comments for GOTCMME_NATN_CODE (# 12)

Source Code Comments

NATION:The nation or country associated with the address of the person/non-person to be created.

Columns Comments for GOTCMME_CNTY_CODE (# 13)

Source Code Comments

COUNTY: The county associated with the address of the person/non-person to be created.

Columns Comments for GOTCMME_PHONE_AREA (# 14)

Source Code Comments

AREA CODE: The telephone area code associated with the phone number of the person/non-person to be created.

Columns Comments for GOTCMME_PHONE_NUMBER (# 15)

Source Code Comments

PHONE NUMBER: The telephone number of the person/non-person to be created.

Columns Comments for GOTCMME_PHONE_EXT (# 16)

Source Code Comments

PHONE EXTENSION: The extention of the telephone number of the person/non-person to be created.

Columns Comments for GOTCMME_SSN (# 17)

Source Code Comments

SOCIAL SECURITY NUMBER: The Social Security Number, Social Insurance Number, or the Tax File Number associated with the person/non-person to be created.

Columns Comments for GOTCMME_BIRTH_DAY (# 18)

Source Code Comments

BIRTH DAY: The day of the person's birthday to be created.

Columns Comments for GOTCMME_BIRTH_MON (# 19)

Source Code Comments

BIRTH MONTH: The month of the person's birthday to be created.

Columns Comments for GOTCMME_BIRTH_YEAR (# 20)

Source Code Comments

BIRTH YEAR: The year of the person's birthday to be created.

Columns Comments for GOTCMME_SEX (# 21)

Source Code Comments

GENDER: The gender of the person to be created.

Columns Comments for GOTCMME_EMAIL_ADDRESS (# 22)

Source Code Comments

E-MAIL ADDRESS: The e-mail address of the person/non-person to be created.

Columns Comments for GOTCMME_ATYP_CODE (# 23)

Source Code Comments

ADDRESS TYPE CODE: The address type to associate with the address.

Columns Comments for GOTCMME_TELE_CODE (# 24)

Source Code Comments

TELEPHONE CODE: The telephone type to associate woth the telephone number.

Columns Comments for GOTCMME_EMAL_CODE (# 25)

Source Code Comments

E-MAIL TYPE: The e-mail type to associate with the e-mail address.

Columns Comments for GOTCMME_ASRC_CODE (# 26)

Source Code Comments

ADDRESS SOURCE CODE: The address entry method. For example, Tapeload, World Wide Web, Self report.

Columns Comments for GOTCMME_CTRY_CODE_PHONE (# 27)

Source Code Comments

TELEPHONE COUNTRY CODE: Code designating the region or country.

Columns Comments for GOTCMME_HOUSE_NUMBER (# 28)

Source Code Comments

HOUSE NUMBER: Building or lot number on a street or in an area.

Columns Comments for GOTCMME_STREET_LINE4 (# 29)

Source Code Comments

ADDRESS LINE4: The fourth line of the address of the person/non-person to be created.

Columns Comments for GOTCMME_SURNAME_PREFIX (# 30)

Source Code Comments

SURNAME PREFIX: Name tag preceding the last name or surname. (Van, Von, Mac, etc.)

Table GOTCMRT

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL
GOTCMRT_CMSC_CODE	VARCHAR2(20)	No
GOTCMRT_CMSR_PRIORITY_NO	NUMBER(2,0)	No
GOTCMRT_PIDM	NUMBER(8,0)	No
GOTCMRT_RESULT_TYPE	VARCHAR2(1)	No
GOTCMRT_MATCH_COUNT	NUMBER(2,0)	No
GOTCMRT_MISSING_COUNT	NUMBER(2,0)	No
GOTCMRT_UNMATCH_COUNT	NUMBER(2,0)	No
GOTCMRT_MESSAGE	VARCHAR2(250)	No
GOTCMRT_RESULT_IND	VARCHAR2(1)	No
GOTCMRT_SPRIDEN_ID_ROWID	VARCHAR2(18)	Yes
GOTCMRT_SPRIDEN_NAME_ROWID	VARCHAR2(18)	Yes
GOTCMRT_SPRADDR_ROWID	VARCHAR2(18)	Yes
GOTCMRT_SPRTELE_ROWID	VARCHAR2(18)	Yes
GOTCMRT_GOREMAL_ROWID	VARCHAR2(18)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
GOTCMRT_KEY_INDEX	Unique	GOTCMRT_CMSC_CODE
GOTCMRT_KEY_INDEX	Unique	GOTCMRT_CMSR_PRIORITY_NO
GOTCMRT_KEY_INDEX	Unique	GOTCMRT_PIDM

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GOVCMRT	SQL View	S10B80.BANINST1	Use (select)
CM_PIDM_REC	Oracle Package Type	S10B80.BANINST1.GP_UDC_USER_PROVISIONING	Rely On
RESULTRECORDTYP	Oracle Package Type	S10B80.BANINST1.GOKCMPK	Rely On
P_BUILD_MSG	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Rely On
P_GET_SINGLE_RESULT	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Rely On
P_GET_SINGLE_RESULT	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Use (select)
P_INCREMENT_CNTS	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Rely On
P_INSERT_NAMES	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Use (Insert,select)
P_LVH_INSERT_NAMES	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Use (Insert,select)
P_MATCH_GOREMAL	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Rely On
P_MATCH_ID	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Rely On
P_MATCH_NAME	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Rely On
P_MATCH_NAME	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Use (update)Rely On
P_MATCH_SPBPERS	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Rely On
P_MATCH_SPRADDR	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Rely On
P_MATCH_SPRTELE	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Rely On
P_OPEN_GOREMAL_CV	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Rely On
P_OPEN_SABSUPL_CV	Oracle Package Procedure	S10B80.BANINST1.SAKMTCH	Rely On
P_OPEN_SORHSCH_CV	Oracle Package Procedure	S10B80.BANINST1.SAKMTCH	Rely On
P_OPEN_SORHSCH_CV	Oracle Package Procedure	S10B80.BANINST1.GOKDEBT	Rely On
P_OPEN_SPBPERS_CV	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Rely On
P_OPEN_SPRADDR_CV	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Rely On
P_OPEN_SPRTELE_CV	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Rely On
P_PRIMARY_MATCH_ID	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Use (Insert,select)
P_PRIMARY_MATCH_SSN	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Use (Insert,delete,select)
P_PROCESS_GORCMUP	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Rely On
P_PROCESS_RULE_RESULTS	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Rely On
P_PROCESS_RULE_RESULTS	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Use (select)
P_PROCESS_SECONDARY_MATCHES	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Rely On
P_PROCESS_SECONDARY_MATCHES	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Use (select)Rely On
P_UPDATE_GOTCMRT_RESULT_IND	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Rely On
P_UPDATE_RESULT	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Use (update)Rely On
GV_RESULT_IND	Oracle Package Variable	S10B80.BANINST1.GOKCMPK	Rely On
F_GOREMAL_EXISTS	Oracle Package Function	S10B80.BANINST1.GOKCMPK	Rely On
F_RESULTS_EXIST	Oracle Package Function	S10B80.BANINST1.GOKCMPK	Rely On
F_RESULTS_EXIST	Oracle Package Function	S10B80.BANINST1.GOKCMPK	Use (select)
F_SABSUPL_EXISTS	Oracle Package Function	S10B80.BANINST1.SAKMTCH	Rely On
F_SORHSCH_EXISTS	Oracle Package Function	S10B80.BANINST1.SAKMTCH	Rely On
F_SORHSCH_EXISTS	Oracle Package Function	S10B80.BANINST1.GOKDEBT	Rely On
F_SPRADDR_EXISTS	Oracle Package Function	S10B80.BANINST1.GOKCMPK	Rely On
F_SPRTELE_EXISTS	Oracle Package Function	S10B80.BANINST1.GOKCMPK	Rely On
P_COMMON_MATCHING	Oracle Package Procedure	S10B80.BANINST1.GP_COMMON_MATCHING	Rely On
P_COMMON_MATCHING	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Rely On
P_COMMON_MATCHING	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Use (delete)
P_MASS_EDIT	Oracle Package Procedure	S10B80.BANINST1.NOKEDIT	Rely On
P_MATCH_AMCAS_ID	Oracle Package Procedure	S10B80.BANINST1.SAKMTCH	Rely On
P_MATCH_SORHSCH	Oracle Package Procedure	S10B80.BANINST1.SAKMTCH	Rely On
P_MATCH_SORHSCH	Oracle Package Procedure	S10B80.BANINST1.GOKDEBT	Rely On
P_NEW_PERSON_CM	Oracle Package Procedure	S10B80.BANINST1.NOKEPAF	Rely On
P_PROCESS_RESULT_TABLE	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Rely On
F_CHECK_MATCHES	Oracle Package Function	S10B80.BANINST1.GP_UDC_USER_PROVISIONING	Use (select)
F_GET_PERSON_IDENTITY	Oracle Package Function	S10B80.BANINST1.GP_PERSON_IDENTITY	Rely On
F_GET_PERSON_IDENTITY	Oracle Package Function	S10B80.BANINST1.GP_PERSON_IDENTITY	Use (select)Rely On
F_QUERY_CM_PIDMS	Oracle Package Function	S10B80.BANINST1.GP_UDC_USER_PROVISIONING	Use (select)
F_RESULT_PRIORITY	Oracle Package Function	S10B80.BANINST1.GOKCMPK	Rely On
F_RESULT_PRIORITY	Oracle Package Function	S10B80.BANINST1.GOKCMPK	Use (select)
GOTCMRT	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
GOTCMRT_KEY_INDEX	SQL Index	S10B80.GENERAL	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GOTCMRT

Object Dates

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

Source Code Comments

Common Matching Results Global Temporary Table

Columns Comments for GOTCMRT_CMSC_CODE (# 1)

Source Code Comments

SOURCE CODE: The source code used by the Common Matching process.

Columns Comments for GOTCMRT_CMSR_PRIORITY_NO (# 2)

Source Code Comments

PRIORITY NUMBER: Priority number of rule to be processed.

Columns Comments for GOTCMRT_PIDM (# 3)

Source Code Comments

PIDM: The pidm returned as matched or suspense for the rule as a result of the Common Matching process.

Columns Comments for GOTCMRT_RESULT_TYPE (# 4)

Source Code Comments

RESULT TYPE: Primary match that generated the result.

Columns Comments for GOTCMRT_MATCH_COUNT (# 5)

Source Code Comments

MATCH COUNT: Internal use only.

Columns Comments for GOTCMRT_MISSING_COUNT (# 6)

Source Code Comments

MISSING COUNT: Internal use only.

Columns Comments for GOTCMRT_UNMATCH_COUNT (# 7)

Source Code Comments

UNMATCH COUNT: Internal use only.

Columns Comments for GOTCMRT_MESSAGE (# 8)

Source Code Comments

MESSAGE: The results of the Common Matching identifying match conditions that are met or unmet.

Columns Comments for GOTCMRT_RESULT_IND (# 9)

Source Code Comments

RESULT INDICATOR: Match result for the row.

Columns Comments for GOTCMRT_SPRIDEN_ID_ROWID (# 10)

Source Code Comments

ID ROWID: The rowid of the spriden record returned for the ID match.

Columns Comments for GOTCMRT_SPRIDEN_NAME_ROWID (# 11)

Source Code Comments

NAME ROWID: The rowid of the spriden record returned for the NAME match.

Columns Comments for GOTCMRT_SPRADDR_ROWID (# 12)

Source Code Comments

ADDRESS ROWID: The rowid of the spraddr record returned for an address match.

Columns Comments for GOTCMRT_SPRTELE_ROWID (# 13)

Source Code Comments

TELEPHONE ROWID: The rowid of the sprtele record returned for a telephone match.

Columns Comments for GOTCMRT_GOREMAL_ROWID (# 14)

Source Code Comments

E-MAIL ROWID: The rowid of the goremal record returned for an e-mail match.

Table GTVCMSC

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GTVCMSC_CODE	VARCHAR2(20)	No	*
GTVCMSC_DESC	VARCHAR2(60)	No
GTVCMSC_USER_ID	VARCHAR2(30)	No
GTVCMSC_ACTIVITY_DATE	DATE	No
GTVCMSC_DATA_ORIGIN	VARCHAR2(30)	Yes
GTVCMSC_LONG_DESC	VARCHAR2(4000)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GTVCMSC	Unique	GTVCMSC_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GOBCMUS	SQL Table	S10B80.GENERAL	Refer (no action)
GORCMDH	SQL Table	S10B80.GENERAL	Refer (no action)
GORCMSC	SQL Table	S10B80.GENERAL	Refer (no action)
STVINFC	SQL Table	S10B80.SATURN	Refer (no action)
GTVCMSC_C	Oracle Package Cursor	S10B80.BANINST1.GB_GTVCMSC	Rely On
GTVCMSC_C	Oracle Package Cursor	S10B80.BANINST1.GB_GTVCMSC	Use (select)Rely On
P_QUICK_ADMIT	Oracle Package Procedure	S10B80.BANINST1.SAKQADM	Rely On
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_CM_USER_SETUP	Use (Insert)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_CM_DISPLAY_OPTIONS	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_CM_DISP_HIER	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_CM_USER_PROCEDURE	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_CM_SOURCE_RULES	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GP_PERSON_IDENTITY	Use (Insert)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_CM_SOURCE_PRIORITY	Use (Insert)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_CM_RULES	Use (Insert,select)
F_CODE_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_GTVCMSC	Rely On
F_CODE_EXISTS_IN_TABLE	Oracle Package Function	S10B80.BANINST1.GB_GTVCMSC	Rely On
F_GET_DESCRIPTION	Oracle Package Function	S10B80.BANINST1.GB_GTVCMSC	Rely On
F_GET_LONG_DESC	Oracle Package Function	S10B80.BANINST1.GB_GTVCMSC	Rely On
F_IS_CODE_DELETEABLE	Oracle Package Function	S10B80.BANINST1.GB_GTVCMSC	Rely On
GTVCMSC	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_GTVCMSC	SQL Index	S10B80.GENERAL	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GTVCMSC

Object Dates

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

Source Code Comments

Common Matching Source Code Table

Columns Comments for GTVCMSC_CODE (# 1)

Source Code Comments

SOURCE CODE: Code to identify the source of data to by used by Common Matching process.

Columns Comments for GTVCMSC_DESC (# 2)

Source Code Comments

DESCRIPTION: Description associated with Source Code to be used by Common Matching Rules.

Columns Comments for GTVCMSC_USER_ID (# 3)

Source Code Comments

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

Columns Comments for GTVCMSC_ACTIVITY_DATE (# 4)

Source Code Comments

ACTIVITY DATE: Date record was created or last updated.

Columns Comments for GTVCMSC_DATA_ORIGIN (# 5)

Source Code Comments

DATA ORIGIN: Source system that created or updated the row

Columns Comments for GTVCMSC_LONG_DESC (# 6)

Source Code Comments

Column to hold a long description.

Table GTVEMAL

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GTVEMAL_CODE	VARCHAR2(4)	No	*
GTVEMAL_DESC	VARCHAR2(60)	Yes
GTVEMAL_ACTIVITY_DATE	DATE	No
GTVEMAL_DISP_WEB_IND	VARCHAR2(1)	No
GTVEMAL_URL_IND	VARCHAR2(1)	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GTVEMAL	Unique	GTVEMAL_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GTVEMAL	Oracle Synonym	S10B80.FAISMGR	Rely On
APBWIDN	SQL Table	S10B80.ALUMNI	Refer (no action)
GORCMSC	SQL Table	S10B80.GENERAL	Refer (no action)
GOREMAL	SQL Table	S10B80.GENERAL	Refer (no action)
ROTEMAL	SQL Table	S10B80.FAISMGR	Refer (no action)
SARWAPP	SQL Table	S10B80.SATURN	Refer (no action)
SMBWCRL	SQL Table	S10B80.SATURN	Refer (no action)
SRBWPRO	SQL Table	S10B80.SATURN	Refer (no action)
SRTEMAL	SQL Table	S10B80.SATURN	Refer (no action)
EMAIL_RECORD	Oracle Package Type	S10B80.BANINST1.GOKSEVN	Rely On
EMAL_TYPE	Oracle Package Type	S10B80.BANINST1.BWAKADVS	Rely On
GOREMAL_LINK_TYPE	Oracle Package Type	S10B80.BANINST1.BWGKOADR	Rely On
GTVEMAL_REC	Oracle Package Variable	S10B80.BANINST1.BWDKCPRF	Rely On
GTVEMAL_REC	Oracle Package Variable	S10B80.BANINST1.BWGKOADR	Rely On
GETGTVEMALC	Oracle Package Cursor	S10B80.BANINST1.BWAKALOG	Use (select)Rely On
GOREMALEMALEADDC	Oracle Package Cursor	S10B80.BANINST1.BWGKOADR	Use (select)
GOREMALERIDC	Oracle Package Cursor	S10B80.BANINST1.BWGKOADR	Use (select)
GOREMALLINKC	Oracle Package Cursor	S10B80.BANINST1.BWGKOADR	Use (select)
GOREMALVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKADVS	Use (select)
GTVEMALC	Oracle Package Cursor	S10B80.BANINST1.BWGKOPRF	Use (select)
GTVEMALVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKCPRF	Use (select)Rely On
GTVEMAL_C	Oracle Package Cursor	S10B80.BANINST1.BWGKOGAD	Rely On
GTVEMAL_C	Oracle Package Cursor	S10B80.BANINST1.BWGKOGAD	Use (select)Rely On
GTVEMAL_REC	Oracle Package Variable	S10B80.BANINST1.BWLKOSAD	Rely On
GTVEMAL_REC	Oracle Package Variable	S10B80.BANINST1.BWAKALOG	Rely On
GTVEMAL_REC	Oracle Package Variable	S10B80.BANINST1.BWGKOPRF	Rely On
GV_EMAIL_CODE1	Oracle Package Variable	S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT	Rely On
GV_EMAIL_CODE2	Oracle Package Variable	S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT	Rely On
GV_EMAIL_CODE3	Oracle Package Variable	S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT	Rely On
F_CHECK_EMAL_CODE	Oracle Package Function	S10B80.BANINST1.SAKL045	Use (select)
GTVEMALC	Oracle Package Cursor	S10B80.BANINST1.GTKEMAL	Use (select)Rely On
GTVEMALLISTC	Oracle Package Cursor	S10B80.BANINST1.GOKLIBS	Use (select)Rely On
GTVEMALVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWGKOADR	Use (select)Rely On
GTVEMALWEBC	Oracle Package Cursor	S10B80.BANINST1.BWGKOADR	Use (select)Rely On
GTVEMALWEBLISTC	Oracle Package Cursor	S10B80.BANINST1.BWGKOADR	Use (select)Rely On
GTVEMAL_C	Oracle Package Cursor	S10B80.BANINST1.GB_GTVEMAL	Rely On
GTVEMAL_C	Oracle Package Cursor	S10B80.BANINST1.GB_GTVEMAL	Use (select)Rely On
P_DISPEMAILUPDATE	Oracle Package Procedure	S10B80.BANINST1.BWGKOGAD	Rely On
P_PA_GTVEMAL_EQUAL	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Use (select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_CM_DISPLAY_OPTIONS	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_EMAIL	Use (Insert)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_CM_DISP_HIER	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SP_HOUSING_PROFILE	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_CM_SOURCE_RULES	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT	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_GB_EFDTEST	Use (Insert)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_EMERGENCY_CONTACT	Use (Insert)
F_CODE_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_GTVEMAL	Rely On
F_GET_DESCRIPTION	Oracle Package Function	S10B80.BANINST1.GB_GTVEMAL	Rely On
F_GTVEMAL_EQUAL	Oracle Package Function	S10B80.BANINST1.AOKPVAL	Use (select)
F_SORXREF_CHK	Oracle Package Function	S10B80.BANINST1.SAKPCOM	Use (select)
F_SORXREF_VAL	Oracle Package Function	S10B80.BANINST1.SAKPCOM	Use (select)
GTVEMAL	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_GTVEMAL	SQL Index	S10B80.GENERAL	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GTVEMAL

Object Dates

Creation Date	Analysis Date
04/02/2008 10:35:10:000	04/02/2008 21:17:51:000

Source Code Comments

The GTVEMAL table contains the valid e-mail type codes.

Columns Comments for GTVEMAL_CODE (# 1)

Source Code Comments

A code identifying the type of e-mail address.

Columns Comments for GTVEMAL_DESC (# 2)

Source Code Comments

The description of the e-mail address.

Columns Comments for GTVEMAL_ACTIVITY_DATE (# 3)

Source Code Comments

The date on which the row was added or modified.

Columns Comments for GTVEMAL_DISP_WEB_IND (# 4)

Source Code Comments

Display on Web Indicator, Y indicates this type of email should display

Columns Comments for GTVEMAL_URL_IND (# 5)

Source Code Comments

URL Indicator, Y indicates that this email record is actually a URL.

Table GUBOBJS

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GUBOBJS_NAME	VARCHAR2(30)	No	*
GUBOBJS_DESC	VARCHAR2(80)	No
GUBOBJS_OBJT_CODE	VARCHAR2(10)	No		*
GUBOBJS_SYSI_CODE	VARCHAR2(2)	No		*
GUBOBJS_USER_ID	VARCHAR2(30)	No
GUBOBJS_ACTIVITY_DATE	DATE	No
GUBOBJS_HELP_IND	VARCHAR2(1)	No
GUBOBJS_EXTRACT_ENABLED_IND	VARCHAR2(1)	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
GUBOBJS_OBJT_CODE	GTVOBJT_CODE	GTVOBJT
GUBOBJS_SYSI_CODE	GTVSYSI_CODE	GTVSYSI

Index

Index Name	Index Type	Column Name
GUBOBJS_OBJT_INDEX		GUBOBJS_OBJT_CODE
PK_GUBOBJS	Unique	GUBOBJS_NAME

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GURHMNU	SQL Table	S10B80.GENERAL	Join
GURMENU	SQL Table	S10B80.GENERAL	Join
GUBOBJS_C	Oracle Package Cursor	S10B80.BANINST1.GB_GUBOBJS	Rely On
GUBOBJS_C	Oracle Package Cursor	S10B80.BANINST1.GB_GUBOBJS	Use (select)Rely On
P_BLD_PERS_MENU	Oracle Package Procedure	S10B80.BANINST1.GUKMENU	Use (select)
P_BLD_PROD_MENU	Oracle Package Procedure	S10B80.BANINST1.GUKMENU	Use (select)
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.DML_GUBOBJS	Use (delete)
P_INSERT	Oracle Package Procedure	S10B80.BANINST1.DML_GUBOBJS	Use (Insert)Rely On
P_REFRESH_MENU	Oracle Package Procedure	S10B80.BANINST1.GUKMENU	Use (select)
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.DML_GUBOBJS	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.GB_DISPLAYCOLUMNS_RULES	Use (select)
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.GB_CM_DISPLAY_OPTIONS_RULES	Use (select)
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.GB_DISPLAYMASK_RULES	Use (select)
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.GB_FGACEXCLUDEDOBJECTS_RULES	Use (select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_FGACEXCLUDEDOBJECTS	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_DISPLAYMASK	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_DISPLAYCOLUMNS	Use (Insert,select)
F_CODE_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_GUBOBJS	Rely On
F_GET_DESCRIPTION	Oracle Package Function	S10B80.BANINST1.GB_GUBOBJS	Rely On
F_PERS_BANNER	Oracle Package Function	S10B80.BANINST1.BWGCXCHN	Rely On
F_PERS_BANNER	Oracle Package Function	S10B80.BANINST1.BWGCXCHN	Use (select)
GUBOBJS	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
GUBOBJS_OBJT_INDEX	SQL Index	S10B80.GENERAL	Rely On
PK_GUBOBJS	SQL Index	S10B80.GENERAL	Rely On
GTVOBJT	SQL Table	S10B80.GENERAL	Refer (no action)
GTVSYSI	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GUBOBJS

Object Dates

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

Source Code Comments

General Object Base Table

Columns Comments for GUBOBJS_NAME (# 1)

Source Code Comments

This item contains the name of the object.

Columns Comments for GUBOBJS_DESC (# 2)

Source Code Comments

This item contains the description of the object.

Columns Comments for GUBOBJS_OBJT_CODE (# 3)

Source Code Comments

This item contains the object type code.

Columns Comments for GUBOBJS_SYSI_CODE (# 4)

Source Code Comments

This item contains the value which identifies the Banner System to which this object belongs.

Columns Comments for GUBOBJS_USER_ID (# 5)

Source Code Comments

This item contains the name of the user who owns the object.

Columns Comments for GUBOBJS_ACTIVITY_DATE (# 6)

Source Code Comments

This item contains the date of creation or update.

Columns Comments for GUBOBJS_HELP_IND (# 7)

Source Code Comments

Indicator column to identify which objects have new help files.

Columns Comments for GUBOBJS_EXTRACT_ENABLED_IND (# 8)

Source Code Comments

This column indicates whether the data displayed on the form can be extracted into a csv (Comma Separated Value) file. Values are: D - data block only, B - Both key block and data block, N - not available.

Table STVATYP

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
STVATYP_CODE	VARCHAR2(2)	No	*
STVATYP_DESC	VARCHAR2(30)	Yes
STVATYP_ACTIVITY_DATE	DATE	No
STVATYP_SYSTEM_REQ_IND	VARCHAR2(1)	Yes
STVATYP_TELE_CODE	VARCHAR2(4)	Yes		*
STVATYP_UPDATE_WEB_IND	RAW(1)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
STVATYP_TELE_CODE	STVTELE_CODE	STVTELE

Index

Index Name	Index Type	Column Name
PK_STVATYP	Unique	STVATYP_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AABDINS	SQL Table	S10B80.ALUMNI	Refer (no action)
AARMEMB	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRGASC	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRPASC	SQL Table	S10B80.ALUMNI	Refer (no action)
AMBMAIL	SQL Table	S10B80.ALUMNI	Refer (no action)
AOBORGN	SQL Table	S10B80.ALUMNI	Refer (no action)
AORCONT	SQL Table	S10B80.ALUMNI	Refer (no action)
APBCONS	SQL Table	S10B80.ALUMNI	Refer (no action)
APBWIDN	SQL Table	S10B80.ALUMNI	Refer (no action)
APRCHLD	SQL Table	S10B80.ALUMNI	Refer (no action)
APRMAIL	SQL Table	S10B80.ALUMNI	Refer (no action)
ASBSORG	SQL Table	S10B80.ALUMNI	Refer (no action)
ASRSORG	SQL Table	S10B80.ALUMNI	Refer (no action)
GERATTD	SQL Table	S10B80.GENERAL	Refer (no action)
GERPART	SQL Table	S10B80.GENERAL	Refer (no action)
GOBSEVS	SQL Table	S10B80.GENERAL	Refer (no action)
GORADRL	SQL Table	S10B80.GENERAL	Join
GORCMSC	SQL Table	S10B80.GENERAL	Refer (no action)
GORSVAS	SQL Table	S10B80.GENERAL	Refer (no action)
GORSVEI	SQL Table	S10B80.GENERAL	Refer (no action)
GTVSDAX	SQL Table	S10B80.GENERAL	Join
GURAPAY	SQL Table	S10B80.GENERAL	Refer (no action)
PXR1099	SQL Table	S10B80.PAYROLL	Refer (no action)
PXRMTTN	SQL Table	S10B80.PAYROLL	Refer (no action)
RHRRQST	SQL Table	S10B80.FAISMGR	Refer (no action)
SARWAPP	SQL Table	S10B80.SATURN	Refer (no action)
SORFOLK	SQL Table	S10B80.SATURN	Refer (no action)
SORMSTA	SQL Table	S10B80.SATURN	Refer (no action)
SORXREF	SQL Table	S10B80.SATURN	Join
SPRADDR	SQL Table	S10B80.SATURN	Refer (no action)
SPREMRG	SQL Table	S10B80.SATURN	Refer (no action)
SPRTELE	SQL Table	S10B80.SATURN	Refer (no action)
SRBWPRO	SQL Table	S10B80.SATURN	Refer (no action)
SRTADDR	SQL Table	S10B80.SATURN	Refer (no action)
SRTTELE	SQL Table	S10B80.SATURN	Refer (no action)
APVADRS	SQL View	S10B80.BANINST1	Use (select)
PPVADRS	SQL View	S10B80.BANINST1	Use (select)
RPVADDR	SQL View	S10B80.BANINST1	Use (select)
RPVADRS	SQL View	S10B80.BANINST1	Use (select)
RPVFDRS	SQL View	S10B80.BANINST1	Use (select)
SAVADRS	SQL View	S10B80.BANINST1	Use (select)
SGVADRS	SQL View	S10B80.BANINST1	Use (select)
SPVADDF	SQL View	S10B80.BANINST1	Use (select)
SPVADDI	SQL View	S10B80.BANINST1	Use (select)
SPVADDI_OJ	SQL View	S10B80.BANINST1	Use (select)
SPVADDS	SQL View	S10B80.BANINST1	Use (select)
SPVADRS	SQL View	S10B80.BANINST1	Use (select)
SRVADRS	SQL View	S10B80.BANINST1	Use (select)
F_GET_DESC	SQL Function	S10B80.BANINST1	Use (select)
F_GET_DESC_ALUMNI	SQL Function	S10B80.BANINST1	Use (select)
ADDRESS_LINK_TYPE	Oracle Package Type	S10B80.BANINST1.BWGKOADR	Rely On
ADDRESS_TYPE	Oracle Package Type	S10B80.BANINST1.BWAKPREF	Rely On
ADDR_TYPE	Oracle Package Type	S10B80.BANINST1.BWAKMAIL	Rely On
MAIL_TYPE	Oracle Package Type	S10B80.BANINST1.BWAKMAIL	Rely On
STVATYP_REC	Oracle Package Variable	S10B80.BANINST1.BWDKPREF	Rely On
STVATYP_REC	Oracle Package Variable	S10B80.BANINST1.BWAKPREF	Rely On
STVATYP_REC	Oracle Package Variable	S10B80.BANINST1.BWDKCPRF	Rely On
STVATYP_REC	Oracle Package Variable	S10B80.BANINST1.BWGKOADR	Rely On
GETALLATYPC	Oracle Package Cursor	S10B80.BANINST1.BWDKPREF	Use (select)
GETALLATYPC	Oracle Package Cursor	S10B80.BANINST1.BWAKWRUL	Use (select)
GETSTVATYPC	Oracle Package Cursor	S10B80.BANINST1.BWAKPREF	Use (select)
GETSTVATYPC	Oracle Package Cursor	S10B80.BANINST1.BWAKALOG	Use (select)Rely On
SPRADDRLINKC	Oracle Package Cursor	S10B80.BANINST1.BWGKOADR	Use (select)
SPRADDR_ACTIVE_C	Oracle Package Cursor	S10B80.BANINST1.BWPKEPCR	Use (select)
SPRADDR_ADDRESSC	Oracle Package Cursor	S10B80.BANINST1.BWSKWTRR	Use (select)
SPRADDR_ALL_C	Oracle Package Cursor	S10B80.BANINST1.BWPKEPCR	Use (select)
SPRADDR_LISTC	Oracle Package Cursor	S10B80.BANINST1.BWSKRQST	Use (select)
SPRADDR_LISTC	Oracle Package Cursor	S10B80.BANINST1.BWSKWTRR	Use (select)
STVATYPUPDATEC	Oracle Package Cursor	S10B80.BANINST1.BWGKOADR	Use (select)Rely On
STVATYPVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWLKOSAD	Use (select)Rely On
STVATYPVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKCPRF	Use (select)Rely On
STVATYPVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWGKOADR	Use (select)Rely On
P_DEFAULT_ADDRESS	Oracle Package Procedure	S10B80.BANINST1.BWSKALOG	Use (select)
P_VALIDATION	Oracle Package Procedure	S10B80.BANINST1.TS_STUDENT_OAPERF	Use (Insert)
ATYP	Oracle Package Variable	S10B80.BANINST1.BWSKAADR	Rely On
GV_ATYP_CODE1	Oracle Package Variable	S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT	Rely On
GV_ATYP_CODE2	Oracle Package Variable	S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT	Rely On
GV_ATYP_CODE3	Oracle Package Variable	S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT	Rely On
GV_FRN_ATYP_CODE	Oracle Package Variable	S10B80.BANINST1.GP_INTERNATIONAL_STUDENT	Rely On
GV_US_ATYP_CODE	Oracle Package Variable	S10B80.BANINST1.GP_INTERNATIONAL_STUDENT	Rely On
STVATYP_REC	Oracle Package Variable	S10B80.BANINST1.BWLKOSAD	Rely On
STVATYP_REC	Oracle Package Variable	S10B80.BANINST1.BWAKALOG	Rely On
F_BUILD_STUDENT	Oracle Package Function	S10B80.BANINST1.GP_INTERNATIONAL_STUDENT	Rely On
F_BUILD_STUDENT_COLLECTION	Oracle Package Function	S10B80.BANINST1.GP_INTERNATIONAL_STUDENT	Rely On
F_CHK_SPRADDR	Oracle Package Function	S10B80.BANINST1.SAKL050	Use (select)
F_GETQUALIFIERS	Oracle Package Function	S10B80.BANINST1.BWSKAPAR	Rely On
F_GETQUALIFIERS	Oracle Package Function	S10B80.BANINST1.BWSKAPAR	Use (select)
F_GETQUALIFIERS	Oracle Package Function	S10B80.BANINST1.BWSKAADR	Use (select)
F_GET_ADDR_TYPE	Oracle Package Function	S10B80.BANINST1.GP_ENTITY_ADDRESS	Use (select)
F_GET_MAX_ADDRESS_SEQNO	Oracle Package Function	S10B80.BANINST1.GP_INTERNATIONAL_STUDENT	Rely On
APRMAILGETVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKMAIL	Use (select)
APRMAILVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKMAIL	Use (select)
SPRADDRVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKMAIL	Use (select)
STVATYPC	Oracle Package Cursor	S10B80.BANINST1.STKATYP	Use (select)Rely On
STVATYP_C	Oracle Package Cursor	S10B80.BANINST1.GB_STVATYP	Rely On
STVATYP_C	Oracle Package Cursor	S10B80.BANINST1.GB_STVATYP	Use (select)Rely On
P_APTADDR_IN_USE	Oracle Package Procedure	S10B80.BANINST1.AOKHHLD	Rely On
P_DELETE_STVATYP	Oracle Package Procedure	S10B80.BANINST1.TS_SB_VALIDATION	Rely On
P_DELETE_STVATYP	Oracle Package Procedure	S10B80.BANINST1.TS_SB_VALIDATION	Use (delete)
P_DISPSTATUSSARADAP	Oracle Package Procedure	S10B80.BANINST1.BWSKASTA	Rely On
P_DISP_DIPLOMA_ADDR	Oracle Package Procedure	S10B80.BANINST1.BWSKGRAD	Rely On
P_DISP_DIPLOMA_ADDR	Oracle Package Procedure	S10B80.BANINST1.BWSKGRAD	Use (select)
P_DISP_TRANSCRIPT_ADDRESS	Oracle Package Procedure	S10B80.BANINST1.BWSKWTRR	Rely On
P_INSERTDATAINTOTABLES	Oracle Package Procedure	S10B80.BANINST1.BWSKWPRV	Rely On
P_INSERTDATAINTOTABLES	Oracle Package Procedure	S10B80.BANINST1.BWSKWPRV	Use (select)
P_INSERT_STVATYP	Oracle Package Procedure	S10B80.BANINST1.TS_SB_VALIDATION	Rely On
P_INSERT_STVATYP	Oracle Package Procedure	S10B80.BANINST1.TS_SB_VALIDATION	Use (Insert)
P_LOOKUP	Oracle Package Procedure	S10B80.BANINST1.BWFKPROC	Rely On
P_LOOKUP	Oracle Package Procedure	S10B80.BANINST1.BWFKPROC	Use (select)
P_PA_STVATYP_EQUAL	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Use (select)
P_PA_STVATYP_HIERARCHY_EQUAL	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Use (select)
P_PREF_ADDRESS	Oracle Package Procedure	S10B80.BANINST1.BWAKPREF	Use (select)
P_PROCESS_HOUSEHOLD_ADDR_RECS	Oracle Package Procedure	S10B80.BANINST1.AOKHHLD	Use (select)
P_PROCESS_MASS_ENTRY	Oracle Package Procedure	S10B80.BANINST1.SOKMAUD	Rely On
P_STVATYP_PRTY	Oracle Package Procedure	S10B80.BANINST1.SOKPVAL	Use (select)
P_UPDATE_STVATYP	Oracle Package Procedure	S10B80.BANINST1.TS_SB_VALIDATION	Rely On
P_UPDATE_STVATYP	Oracle Package Procedure	S10B80.BANINST1.TS_SB_VALIDATION	Use (update)
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.GOKPVAL	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.AOKPVAL	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.TOKPVAL	Rely On
P_VALIDATEDATA	Oracle Package Procedure	S10B80.BANINST1.BWSKWPRV	Rely On
P_VALIDATEDATA	Oracle Package Procedure	S10B80.BANINST1.BWSKWPRV	Use (select)
P_WEBPROSPECTMAIN	Oracle Package Procedure	S10B80.BANINST1.BWSKWPRO	Rely On
P_WEBPROSPECTMAIN	Oracle Package Procedure	S10B80.BANINST1.BWSKWPRO	Use (select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_TELEPHONE	Use (Insert)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_TB_MEMO	Use (Insert)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_AB_ADV_INDIVIDUAL	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_TB_CUSTOMER_PROFILE	Use (Insert)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_AB_ADV_ORGANIZATION	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_CM_DISPLAY_OPTIONS	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_CM_DISP_HIER	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_TB_RECEIVABLE	Use (Insert)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SP_HOUSING_PROFILE	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_CM_SOURCE_RULES	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GP_PERSON_IDENTITY	Use (Insert)
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_GB_ADDRESS	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_EFDTEST	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_EMERGENCY_CONTACT	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GP_ENTITY_ADDRESS	Use (Insert,update)
F_ADDRESS_TELEPHONE_VALUE	Oracle Package Function	S10B80.BANINST1.GOKSELS	Rely On
F_ADDRESS_VALUE	Oracle Package Function	S10B80.BANINST1.P_ADDR_TELE	Rely On
F_ADD_ENTITY_ADDRESS	Oracle Package Function	S10B80.BANINST1.GP_ENTITY_ADDRESS	Rely On
F_CODE_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_STVATYP	Rely On
F_EXPIRE_ENTITY_ADDRESS	Oracle Package Function	S10B80.BANINST1.GP_ENTITY_ADDRESS	Rely On
F_GET_DESCRIPTION	Oracle Package Function	S10B80.BANINST1.GB_STVATYP	Rely On
F_GET_STUDENT_DATA	Oracle Package Function	S10B80.BANINST1.GP_INTERNATIONAL_STUDENT	Rely On
F_GET_VALID_DESCRIPTION	Oracle Package Function	S10B80.BANINST1.GB_ADDRESS	Rely On
F_GET_VALID_DESCRIPTION	Oracle Package Function	S10B80.BANINST1.GB_ADDRESS	Use (select)
STVATYP	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_STVATYP	SQL Index	S10B80.SATURN	Rely On
STVTELE	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.STVATYP

Object Dates

Creation Date	Analysis Date
04/02/2008 20:48:46:000	04/02/2008 21:18:11:000

Source Code Comments

Address Type Validation Table

Columns Comments for STVATYP_CODE (# 1)

Source Code Comments

A code used throughout all BANNER systems to identify the type of address for which information is maintained (for example; Mailing, Permanent, or Billing).

Columns Comments for STVATYP_DESC (# 2)

Source Code Comments

This field identifies the address type associated with the type code.

Columns Comments for STVATYP_ACTIVITY_DATE (# 3)

Source Code Comments

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

Columns Comments for STVATYP_SYSTEM_REQ_IND (# 4)

Source Code Comments

System Required Indicator

Columns Comments for STVATYP_TELE_CODE (# 5)

Source Code Comments

Default Telephone type code for telephone number.

Columns Comments for STVATYP_UPDATE_WEB_IND (# 6)

Source Code Comments

Web update indicator. This column is now obsolete. Refer to table goradrl

Table STVTELE

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
STVTELE_CODE	VARCHAR2(4)	No	*
STVTELE_DESC	VARCHAR2(30)	No
STVTELE_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_STVTELE	Unique	STVTELE_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
APBWIDN	SQL Table	S10B80.ALUMNI	Refer (no action)
GORCMSC	SQL Table	S10B80.GENERAL	Refer (no action)
SIROFFC	SQL Table	S10B80.SATURN	Refer (no action)
SORWDSP	SQL Table	S10B80.SATURN	Join
SPRTELE	SQL Table	S10B80.SATURN	Refer (no action)
SRTTELE	SQL Table	S10B80.SATURN	Refer (no action)
STVATYP	SQL Table	S10B80.SATURN	Refer (no action)
F_GET_DESC_ALUMNI	SQL Function	S10B80.BANINST1	Use (select)
STVTELEVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKLIBS	Use (select)Rely On
STVTELE_REC	Oracle Package Variable	S10B80.BANINST1.BWDKLIBS	Rely On
STVTELE_REC	Oracle Package Variable	S10B80.BANINST1.BWDKCPRF	Rely On
STVTELE_REC	Oracle Package Variable	S10B80.BANINST1.BWGKOADR	Rely On
GETSTVTELEC	Oracle Package Cursor	S10B80.BANINST1.BWAKWRUL	Use (select)
GETSTVTELEC	Oracle Package Cursor	S10B80.BANINST1.BWAKALOG	Use (select)Rely On
STVTELEVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKCPRF	Use (select)Rely On
GV_TELE_CODE1	Oracle Package Variable	S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT	Rely On
GV_TELE_CODE2	Oracle Package Variable	S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT	Rely On
GV_TELE_CODE3	Oracle Package Variable	S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT	Rely On
STVTELE_REC	Oracle Package Variable	S10B80.BANINST1.BWAKWRUL	Rely On
STVTELE_REC	Oracle Package Variable	S10B80.BANINST1.BWAKALOG	Rely On
STVTELEC	Oracle Package Cursor	S10B80.BANINST1.STKTELE	Use (select)Rely On
STVTELELISTC	Oracle Package Cursor	S10B80.BANINST1.GOKLIBS	Use (select)Rely On
STVTELE_C	Oracle Package Cursor	S10B80.BANINST1.GB_STVTELE	Rely On
STVTELE_C	Oracle Package Cursor	S10B80.BANINST1.GB_STVTELE	Use (select)Rely On
STVTELE_WDSP_C	Oracle Package Cursor	S10B80.BANINST1.BWCKLIBS	Use (select)Rely On
P_DELETE_STVTELE	Oracle Package Procedure	S10B80.BANINST1.TS_SB_VALIDATION	Rely On
P_DELETE_STVTELE	Oracle Package Procedure	S10B80.BANINST1.TS_SB_VALIDATION	Use (delete)
P_DISPADDRVIEW	Oracle Package Procedure	S10B80.BANINST1.BWLKOSAD	Rely On
P_FAC_OFFICE_HOURS	Oracle Package Procedure	S10B80.BANINST1.BWLKOFFH	Rely On
P_INSERT_STVTELE	Oracle Package Procedure	S10B80.BANINST1.TS_SB_VALIDATION	Rely On
P_INSERT_STVTELE	Oracle Package Procedure	S10B80.BANINST1.TS_SB_VALIDATION	Use (Insert)
P_OFFICE_HOURS	Oracle Package Procedure	S10B80.BANINST1.BWCKFRMT	Use (select)
P_PA_STVTELE_EQUAL	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Use (select)
P_PRINT_TELE_SELECTION	Oracle Package Procedure	S10B80.BANINST1.BWPKEPCR	Use (select)
P_SEL_OFFICE_HOURS	Oracle Package Procedure	S10B80.BANINST1.BWLKOFFH	Use (select)
P_UPDATE_STVTELE	Oracle Package Procedure	S10B80.BANINST1.TS_SB_VALIDATION	Rely On
P_UPDATE_STVTELE	Oracle Package Procedure	S10B80.BANINST1.TS_SB_VALIDATION	Use (update)
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.GOKPVAL	Rely On
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_TELEPHONE	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_AB_ADV_INDIVIDUAL	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_AB_ADV_ORGANIZATION	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_CM_DISPLAY_OPTIONS	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_CM_DISP_HIER	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SP_HOUSING_PROFILE	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_CM_SOURCE_RULES	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT	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)
F_CODE_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_STVTELE	Rely On
F_GET_DESCRIPTION	Oracle Package Function	S10B80.BANINST1.GB_STVTELE	Rely On
F_STVTELE_EQUAL	Oracle Package Function	S10B80.BANINST1.AOKPVAL	Use (select)
STVTELE	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_STVTELE	SQL Index	S10B80.SATURN	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.STVTELE

Object Dates

Creation Date	Analysis Date
04/02/2008 20:59:50:000	04/02/2008 21:18:20:000

Source Code Comments

Telephone Type Validation Table.

Columns Comments for STVTELE_CODE (# 1)

Source Code Comments

Telephone Type code.

Columns Comments for STVTELE_DESC (# 2)

Source Code Comments

Telephone Type Description.

Columns Comments for STVTELE_ACTIVITY_DATE (# 3)

Source Code Comments

Date of last change for telephone type record.

Link between GORCMDO and GORCMSC

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GORCMDO and GORCMSC (FK1_GORCMDO_INV_GORCMSC_KEY)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GORCMDO	GORCMDO_CMSC_CODE	GORCMSC_CMSC_CODE	GORCMSC	(1,1)-(0,n)

Link between GORCMSC and GTVEMAL

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GORCMSC and GTVEMAL (FK1_GORCMSC_INV_GTVEMAL_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GORCMSC	GORCMSC_EMAL_CODE	GTVEMAL_CODE	GTVEMAL	(0,1)-(0,n)

Link between GORCMSP and GORCMSC

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GORCMSP and GORCMSC (FK1_GORCMSP_INV_GORCMSC_KEY)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GORCMSP	GORCMSP_CMSC_CODE	GORCMSC_CMSC_CODE	GORCMSC	(1,1)-(0,n)

Link between GORCMSR and GORCMDD

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GORCMSR and GORCMDD (FK1_GORCMSR_INV_GORCMDD_KEY)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GORCMSR	GORCMSR_COLUMN_NAME	GORCMDD_COLUMN_NAME	GORCMDD	(1,1)-(0,n)

Link between GORCMSR and GORCMSP

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GORCMSR and GORCMSP (FK1_GORCMSR_INV_GORCMSP_KEY)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GORCMSR	GORCMSR_CMSC_CODE	GORCMSP_CMSC_CODE	GORCMSP	(1,1)-(0,n)
GORCMSR	GORCMSR_PRIORITY_NO	GORCMSP_PRIORITY_NO	GORCMSP	(1,1)-(0,n)

Link between GORCMUP and GORCMSP

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GORCMUP and GORCMSP (FK1_GORCMUP_INV_GORCMSP_KEY)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GORCMUP	GORCMUP_CMSC_CODE	GORCMSP_CMSC_CODE	GORCMSP	(1,1)-(0,n)
GORCMUP	GORCMUP_PRIORITY_NO	GORCMSP_PRIORITY_NO	GORCMSP	(1,1)-(0,n)

Link between GORCMDH and GTVCMSC

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GORCMDH and GTVCMSC (FK1_GORCMDH_INV_GTVCMSC_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GORCMDH	GORCMDH_CMSC_CODE	GTVCMSC_CODE	GTVCMSC	(1,1)-(0,n)

Link between GORCMSC and GTVCMSC

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GORCMSC and GTVCMSC (FK1_GORCMSC_INV_GTVCMSC_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GORCMSC	GORCMSC_CMSC_CODE	GTVCMSC_CODE	GTVCMSC	(1,1)-(0,1)

Link between GOBCMUS and GTVCMSC

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GOBCMUS and GTVCMSC (FK1_GOBCMUS_INV_GTVCMSC_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GOBCMUS	GOBCMUS_CMSC_CODE	GTVCMSC_CODE	GTVCMSC	(0,1)-(0,n)

Link between GORCMSC and STVATYP

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GORCMSC and STVATYP (FK1_GORCMSC_INV_STVATYP_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GORCMSC	GORCMSC_ATYP_CODE	STVATYP_CODE	STVATYP	(0,1)-(0,n)

Link between STVATYP and STVTELE

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between STVATYP and STVTELE (FK1_STVATYP_INV_STVTELE_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
STVATYP	STVATYP_TELE_CODE	STVTELE_CODE	STVTELE	(0,1)-(0,n)

Link between GORCMSC and STVTELE

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GORCMSC and STVTELE (FK1_GORCMSC_INV_STVTELE_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GORCMSC	GORCMSC_TELE_CODE	STVTELE_CODE	STVTELE	(0,1)-(0,n)