Model Supplemental_Data_Engine

Model Label :

List of Objects

Object Name	Object Type	Layer Name
GOBSDCT	SQL Table	Default
GOBSDDC	SQL Table	Default
GOBSDTB	SQL Table	Default
GORSDAM	SQL Table	Default
GORSDAV	SQL Table	Default
GORSDDV	SQL Table	Default
GOTSDCR	SQL Table	Default
GUBPPRF	SQL Table	Default

Model View

Table GOBSDCT

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GOBSDCT_NAME	VARCHAR2(4)	No	*
GOBSDCT_DESC	VARCHAR2(50)	No
GOBSDCT_TEMPLATE	CLOB	No
GOBSDCT_ACTIVITY_DATE	DATE	No
GOBSDCT_USER_ID	VARCHAR2(30)	No
GOBSDCT_DATA_ORIGIN	VARCHAR2(30)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GOBSDCT	Unique	GOBSDCT_NAME

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
F_GET_TRIGGER	SQL Function	S10B80.BANINST1	Use (select)
F_GET_TRIGGER	Oracle Package Function	S10B80.BANINST1.GP_GOKSDEN	Use (select)
F_GET_VIEW	Oracle Package Function	S10B80.BANINST1.GP_GOKSDEN	Use (select)
GOBSDCT	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_GOBSDCT	SQL Index	S10B80.GENERAL	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GOBSDCT

Object Dates

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

Source Code Comments

SDE Code Templates Table.

Columns Comments for GOBSDCT_NAME (# 1)

Source Code Comments

Template Name: The Name for a template.

Columns Comments for GOBSDCT_DESC (# 2)

Source Code Comments

Template Description: The description of the template.

Columns Comments for GOBSDCT_TEMPLATE (# 3)

Source Code Comments

Template: The code template.

Columns Comments for GOBSDCT_ACTIVITY_DATE (# 4)

Source Code Comments

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

Columns Comments for GOBSDCT_USER_ID (# 5)

Source Code Comments

USER IDENTIFICATION: The unique identification of the user.

Columns Comments for GOBSDCT_DATA_ORIGIN (# 6)

Source Code Comments

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

Table GOBSDDC

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GOBSDDC_CODE	VARCHAR2(10)	No	*
GOBSDDC_DESC	VARCHAR2(64)	No
GOBSDDC_METHOD	VARCHAR2(1)	No
GOBSDDC_ACTIVITY_DATE	DATE	No
GOBSDDC_USER_ID	VARCHAR2(30)	No
GOBSDDC_VALIDATION	VARCHAR2(1024)	Yes
GOBSDDC_DATA_ORIGIN	VARCHAR2(30)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GOBSDDC	Unique	GOBSDDC_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GORSDAM	SQL Table	S10B80.GENERAL	Refer (no action)
GORSDDV	SQL Table	S10B80.GENERAL	Refer (no action)
SDE_DISCRIMINATOR_REC	Oracle Package Type	S10B80.BANINST1.GB_SDE_DISCRIMINATOR	Rely On
P_OVERLAY_VALIDATION_REC	Oracle Package Procedure	S10B80.BANINST1.GB_SDE_DISCRIMINATOR	Rely On
F_BUILD_GOBSDDC_REC	Oracle Package Function	S10B80.BANINST1.GB_SDE_DISCRIMINATOR	Rely On
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.GB_SDE_DISCRIMINATOR	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.GB_SDE_DISCRIMINATOR	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.DML_GOBSDDC	Use (delete)
P_INSERT	Oracle Package Procedure	S10B80.BANINST1.DML_GOBSDDC	Use (Insert)Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.GB_SDE_DISCRIMINATOR	Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.GB_SDE_DISCRIMINATOR	Use (select)
P_REGISTER_ENTITY	Oracle Package Procedure	S10B80.BANINST1.GB_SDE_DISCRIMINATOR_RULES	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.GB_SDE_DISCRIMINATOR	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.DML_GOBSDDC	Use (update)Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.GB_SDE_DISCRIMINATOR_RULES	Rely On
P_VALIDATE_SDDC_CHANGE	Oracle Package Procedure	S10B80.BANINST1.GB_SDE_METADATA	Rely On
P_VALIDATE_SDDC_CHANGE	Oracle Package Procedure	S10B80.BANINST1.GB_SDE_METADATA	Use (select)Rely On
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_SDE_DISCRIM_VALUE	Use (Insert)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_SDE_DISCRIMINATOR	Use (Insert)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_SDE_METADATA	Use (Insert)
F_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_SDE_DISCRIMINATOR	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_SDE_DISCRIMINATOR	Use (select)
F_GET_VIEW	Oracle Package Function	S10B80.BANINST1.GP_GOKSDEN	Use (select)
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.GB_SDE_DISCRIMINATOR	Rely On
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.GB_SDE_DISCRIMINATOR	Use (select)
F_QUERY_BY_ROWID	Oracle Package Function	S10B80.BANINST1.GB_SDE_DISCRIMINATOR	Use (select)
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.GB_SDE_DISCRIMINATOR	Rely On
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.GB_SDE_DISCRIMINATOR	Use (select)
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.GB_SDE_DISCRIMINATOR	Rely On
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.GB_SDE_DISCRIMINATOR	Use (select)
GOBSDDC	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_GOBSDDC	SQL Index	S10B80.GENERAL	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GOBSDDC

Object Dates

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

Source Code Comments

Supplemental Data Discriminator base table.

Columns Comments for GOBSDDC_CODE (# 1)

Source Code Comments

Code: The Discriminator Code.

Columns Comments for GOBSDDC_DESC (# 2)

Source Code Comments

Description: The description for the discriminator.

Columns Comments for GOBSDDC_METHOD (# 3)

Source Code Comments

Discrimination Method: The method used to discriminate. I for Index, S for Select Statement, U for user defined in table GORSDDV.

Columns Comments for GOBSDDC_ACTIVITY_DATE (# 4)

Source Code Comments

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

Columns Comments for GOBSDDC_USER_ID (# 5)

Source Code Comments

USER IDENTIFICATION: The unique identification of the user.

Columns Comments for GOBSDDC_VALIDATION (# 6)

Source Code Comments

Discriminator Validation: The Select statement to build a list of values or the maximum Index.

Columns Comments for GOBSDDC_DATA_ORIGIN (# 7)

Source Code Comments

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

Table GOBSDTB

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GOBSDTB_TABLE_NAME	VARCHAR2(30)	No	*
GOBSDTB_OWNER	VARCHAR2(30)	No
GOBSDTB_ACTIVITY_DATE	DATE	No
GOBSDTB_USER_ID	VARCHAR2(30)	No
GOBSDTB_PK_DYNSQL	VARCHAR2(2000)	Yes
GOBSDTB_DATA_ORIGIN	VARCHAR2(30)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GOBSDTB	Unique	GOBSDTB_TABLE_NAME

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GORSDAM	SQL Table	S10B80.GENERAL	Refer (no action)
F_GET_PK_TEMP	SQL Function	S10B80.BANINST1	Rely On
F_GET_PK_TEMP	SQL Function	S10B80.BANINST1	Use (select)
F_GET_TRIGGER	SQL Function	S10B80.BANINST1	Rely On
F_GET_TRIGGER	SQL Function	S10B80.BANINST1	Use (select)
SDE_TABLE_REC	Oracle Package Type	S10B80.BANINST1.GB_SDE_TABLE	Rely On
P_OVERLAY_VALIDATION_REC	Oracle Package Procedure	S10B80.BANINST1.GB_SDE_TABLE	Rely On
P_REPLACE_GLOBAL_TAGS	Oracle Package Procedure	S10B80.BANINST1.GP_GOKSDEN	Rely On
P_REPLACE_GLOBAL_TAGS	Oracle Package Procedure	S10B80.BANINST1.GP_GOKSDEN	Use (select)
F_BUILD_GOBSDTB_REC	Oracle Package Function	S10B80.BANINST1.GB_SDE_TABLE	Rely On
P_COPY_ATTR_MD	Oracle Package Procedure	S10B80.BANINST1.GP_GOKSDEN	Rely On
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.GB_SDE_TABLE	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.DML_GOBSDTB	Use (delete)
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.GB_SDE_TABLE	Rely On
P_INSERT	Oracle Package Procedure	S10B80.BANINST1.DML_GOBSDTB	Use (Insert)Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.GB_SDE_TABLE	Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.GB_SDE_TABLE	Use (select)
P_REGISTER_ENTITY	Oracle Package Procedure	S10B80.BANINST1.GB_SDE_TABLE_RULES	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.DML_GOBSDTB	Use (update)Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.GB_SDE_TABLE	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.GB_SDE_TABLE_RULES	Rely On
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_SDE_DISCRIMINATOR	Use (Insert)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_SDE_METADATA	Use (Insert)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_SDE_TABLE	Use (Insert)
F_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_SDE_TABLE	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_SDE_TABLE	Use (select)
F_GET_PK_DEF	Oracle Package Function	S10B80.BANINST1.GP_GOKSDEN	Rely On
F_GET_PK_DEF	Oracle Package Function	S10B80.BANINST1.GP_GOKSDEN	Use (select)
F_GET_TRIGGER	Oracle Package Function	S10B80.BANINST1.GP_GOKSDEN	Rely On
F_GET_TRIGGER	Oracle Package Function	S10B80.BANINST1.GP_GOKSDEN	Use (select)
F_GET_VIEW	Oracle Package Function	S10B80.BANINST1.GP_GOKSDEN	Rely On
F_GET_VIEW	Oracle Package Function	S10B80.BANINST1.GP_GOKSDEN	Use (select)
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.GB_SDE_TABLE	Rely On
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.GB_SDE_TABLE	Use (select)
F_QUERY_BY_ROWID	Oracle Package Function	S10B80.BANINST1.GB_SDE_TABLE	Use (select)
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.GB_SDE_TABLE	Rely On
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.GB_SDE_TABLE	Use (select)
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.GB_SDE_TABLE	Rely On
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.GB_SDE_TABLE	Use (select)
GOBSDTB	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_GOBSDTB	SQL Index	S10B80.GENERAL	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GOBSDTB

Object Dates

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

Source Code Comments

Banner Tables with Supplemental Data.

Columns Comments for GOBSDTB_TABLE_NAME (# 1)

Source Code Comments

Table Name: The Banner Table Name.

Columns Comments for GOBSDTB_OWNER (# 2)

Source Code Comments

Owner: The Banner Table Owner.

Columns Comments for GOBSDTB_ACTIVITY_DATE (# 3)

Source Code Comments

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

Columns Comments for GOBSDTB_USER_ID (# 4)

Source Code Comments

USER IDENTIFICATION: The unique identification of the user.

Columns Comments for GOBSDTB_PK_DYNSQL (# 5)

Source Code Comments

Primary Key Dynamic SQL: The SQL to generate the record ID from ROWID in Banner Table Name.

Columns Comments for GOBSDTB_DATA_ORIGIN (# 6)

Source Code Comments

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

Table GORSDAM

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GORSDAM_TABLE_NAME	VARCHAR2(30)	No	*	*
GORSDAM_ATTR_NAME	VARCHAR2(30)	No	*
GORSDAM_ATTR_TYPE	VARCHAR2(1)	No
GORSDAM_ATTR_ORDER	NUMBER(3,0)	No
GORSDAM_ATTR_REQD_IND	VARCHAR2(1)	No
GORSDAM_ATTR_DATA_TYPE	VARCHAR2(30)	No
GORSDAM_ATTR_PROMPT	VARCHAR2(50)	No
GORSDAM_ACTIVITY_DATE	DATE	No
GORSDAM_USER_ID	VARCHAR2(30)	No
GORSDAM_ATTR_DATA_LEN	NUMBER(8,0)	Yes
GORSDAM_ATTR_DATA_SCALE	NUMBER(2,0)	Yes
GORSDAM_ATTR_INFO	VARCHAR2(1024)	Yes
GORSDAM_ATTR_BASE_COL	VARCHAR2(30)	Yes
GORSDAM_SDDC_CODE	VARCHAR2(10)	Yes		*
GORSDAM_DATA_ORIGIN	VARCHAR2(30)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GORSDAM_SDDC_CODE	GOBSDDC_CODE	GOBSDDC
GORSDAM_TABLE_NAME	GOBSDTB_TABLE_NAME	GOBSDTB

Index

Index Name	Index Type	Column Name
PK_GORSDAM	Unique	GORSDAM_TABLE_NAME
PK_GORSDAM	Unique	GORSDAM_ATTR_NAME

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GOTSDCR	SQL Table	S10B80.GENERAL	Join
SDE_METADATA_REC	Oracle Package Type	S10B80.BANINST1.GB_SDE_METADATA	Rely On
P_OVERLAY_VALIDATION_REC	Oracle Package Procedure	S10B80.BANINST1.GB_SDE_METADATA	Rely On
F_BUILD_GORSDAM_REC	Oracle Package Function	S10B80.BANINST1.GB_SDE_METADATA	Rely On
P_COPY_ATTR_MD	Oracle Package Procedure	S10B80.BANINST1.GP_GOKSDEN	Use (select)
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.GB_SDE_METADATA	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.DML_GORSDAM	Use (delete)
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.GB_SDE_DISCRIMINATOR	Use (select)
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.GB_SDE_METADATA	Rely On
P_INSERT	Oracle Package Procedure	S10B80.BANINST1.DML_GORSDAM	Use (Insert)Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.GB_SDE_METADATA	Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.GB_SDE_METADATA	Use (select)
P_REGISTER_ENTITY	Oracle Package Procedure	S10B80.BANINST1.GB_SDE_METADATA_RULES	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.DML_GORSDAM	Use (update)Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.GB_SDE_METADATA	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.GB_SDE_METADATA_RULES	Rely On
P_VALIDATE_SDDC_CHANGE	Oracle Package Procedure	S10B80.BANINST1.GB_SDE_METADATA	Rely On
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_SDE_METADATA	Use (Insert)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_SDE_TABLE	Use (Insert)
F_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_SDE_METADATA	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_SDE_METADATA	Use (select)
F_GET_VIEW	Oracle Package Function	S10B80.BANINST1.GP_GOKSDEN	Use (select)
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.GB_SDE_METADATA	Rely On
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.GB_SDE_METADATA	Use (select)
F_QUERY_BY_ROWID	Oracle Package Function	S10B80.BANINST1.GB_SDE_METADATA	Use (select)
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.GB_SDE_METADATA	Rely On
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.GB_SDE_METADATA	Use (select)
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.GB_SDE_METADATA	Rely On
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.GB_SDE_METADATA	Use (select)
GORSDAM	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_GORSDAM	SQL Index	S10B80.GENERAL	Rely On
GOBSDDC	SQL Table	S10B80.GENERAL	Refer (no action)
GOBSDTB	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GORSDAM

Object Dates

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

Source Code Comments

Attribute Metadata table.

Columns Comments for GORSDAM_TABLE_NAME (# 1)

Source Code Comments

Table Name: The name of the table supplemented by the attribute.

Columns Comments for GORSDAM_ATTR_NAME (# 2)

Source Code Comments

Attribute Name: The name of the attribute.

Columns Comments for GORSDAM_ATTR_TYPE (# 3)

Source Code Comments

Attribute Type: The type of the attribute; A(dd) to table, S(ubstitutes) field.

Columns Comments for GORSDAM_ATTR_ORDER (# 4)

Source Code Comments

Attribute Order: The default display order of the attribute.

Columns Comments for GORSDAM_ATTR_REQD_IND (# 5)

Source Code Comments

Attribute Required Indicator: The Indicator to specify that the Attribute is required? (Y/N).

Columns Comments for GORSDAM_ATTR_DATA_TYPE (# 6)

Source Code Comments

Attribute Data Type: The data type of the Attribute.

Columns Comments for GORSDAM_ATTR_PROMPT (# 7)

Source Code Comments

Attribute Prompt: The default prompt or label for the user interface.

Columns Comments for GORSDAM_ACTIVITY_DATE (# 8)

Source Code Comments

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

Columns Comments for GORSDAM_USER_ID (# 9)

Source Code Comments

USER IDENTIFICATION: The unique identification of the user.

Columns Comments for GORSDAM_ATTR_DATA_LEN (# 10)

Source Code Comments

Attribute Data Length: The maximum length of the attribute data.

Columns Comments for GORSDAM_ATTR_DATA_SCALE (# 11)

Source Code Comments

Attribute Data Precision: The scale for number type attributes.

Columns Comments for GORSDAM_ATTR_INFO (# 12)

Source Code Comments

Attribute Info: The default hint or information text for the user interface.

Columns Comments for GORSDAM_ATTR_BASE_COL (# 13)

Source Code Comments

Attribute Substitute Column: The base table field substituted by this attribute.

Columns Comments for GORSDAM_SDDC_CODE (# 14)

Source Code Comments

Discriminator Code: The Discriminator associated with this Attribute.

Columns Comments for GORSDAM_DATA_ORIGIN (# 15)

Source Code Comments

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

Table GORSDAV

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GORSDAV_TABLE_NAME	VARCHAR2(30)	No	*
GORSDAV_ATTR_NAME	VARCHAR2(30)	No	*
GORSDAV_DISC	VARCHAR2(64)	No	*
GORSDAV_PK_PARENTTAB	VARCHAR2(512)	No	*	*

Foreign Key information

Column name	is Foreign Key For Column	on Table
GORSDAV_PK_PARENTTAB	GTVPURP_CODE	GTVPURP
GORSDAV_PK_PARENTTAB	GTVSYSI_CODE	GTVSYSI
GORSDAV_PK_PARENTTAB	STVRDEF_CODE	STVRDEF
GORSDAV_PK_PARENTTAB	GTVTRTP_CODE	GTVTRTP
GORSDAV_PK_PARENTTAB	GTVCELG_CODE	GTVCELG
GORSDAV_PK_PARENTTAB	GTVSRCE_CODE	GTVSRCE
GORSDAV_PK_PARENTTAB	SLBBLDG_BLDG_CODE	SLBBLDG
GORSDAV_PK_PARENTTAB	GTVDOCM_CODE	GTVDOCM
GORSDAV_PK_PARENTTAB	SMRPRLE_PROGRAM	SMRPRLE
GORSDAV_PK_PARENTTAB	GOBCMUS_CM_USER_ID	GOBCMUS
GORSDAV_PK_PARENTTAB	GTVVISS_CODE	GTVVISS
GORSDAV_PK_PARENTTAB	GORCMSC_CMSC_CODE	GORCMSC

Index

No Result

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GUBPPRF	SQL Table	S10B80.GENERAL	Join
APBCONS_ADD	SQL View	S10B80.BANINST1	Use (select)
FPRREQD_ADD	SQL View	S10B80.BANINST1	Use (select)
GJBJOBS_ADD	SQL View	S10B80.BANINST1	Use (select)
GJBJOBS_ADS	SQL View	S10B80.BANINST1	Use (select)
GJBPDEF_ADD	SQL View	S10B80.BANINST1	Use (select)
GJBPDEF_ADS	SQL View	S10B80.BANINST1	Use (select)
GJRJPRM_ADS	SQL View	S10B80.BANINST1	Use (select)
GJRJPRM_SUB	SQL View	S10B80.BANINST1	Use (select)
GLBEXTR_ADD	SQL View	S10B80.BANINST1	Use (select)
GLBEXTR_ADS	SQL View	S10B80.BANINST1	Use (select)
GOBCMUS_ADD	SQL View	S10B80.BANINST1	Use (select)
GOBCMUS_ADS	SQL View	S10B80.BANINST1	Use (select)
GORCMDD_ADD	SQL View	S10B80.BANINST1	Use (select)
GORCMDD_ADS	SQL View	S10B80.BANINST1	Use (select)
GORCMDO_ADD	SQL View	S10B80.BANINST1	Use (select)
GORCMDO_ADS	SQL View	S10B80.BANINST1	Use (select)
GORCMDO_SUB	SQL View	S10B80.BANINST1	Use (select)
GORCMSC_ADD	SQL View	S10B80.BANINST1	Use (select)
GORCMSC_ADS	SQL View	S10B80.BANINST1	Use (select)
GORCMSR_ADD	SQL View	S10B80.BANINST1	Use (select)
GORCMSR_ADS	SQL View	S10B80.BANINST1	Use (select)
GORSRVR_ADS	SQL View	S10B80.BANINST1	Use (select)
GORSRVR_SUB	SQL View	S10B80.BANINST1	Use (select)
GORVISA_ADD	SQL View	S10B80.BANINST1	Use (select)
GORVISA_ADS	SQL View	S10B80.BANINST1	Use (select)
GORVISA_SUB	SQL View	S10B80.BANINST1	Use (select)
GORWFDD_ADS	SQL View	S10B80.BANINST1	Use (select)
GORWFDD_SUB	SQL View	S10B80.BANINST1	Use (select)
GTVCELG_ADD	SQL View	S10B80.BANINST1	Use (select)
GTVCURR_ADD	SQL View	S10B80.BANINST1	Use (select)
GTVCURR_ADS	SQL View	S10B80.BANINST1	Use (select)
GTVDOCM_ADD	SQL View	S10B80.BANINST1	Use (select)
GTVDOCM_ADS	SQL View	S10B80.BANINST1	Use (select)
GTVPURP_ADD	SQL View	S10B80.BANINST1	Use (select)
GTVPURP_ADS	SQL View	S10B80.BANINST1	Use (select)
GTVSCOD_ADD	SQL View	S10B80.BANINST1	Use (select)
GTVSCOD_ADS	SQL View	S10B80.BANINST1	Use (select)
GTVSDAX_ADD	SQL View	S10B80.BANINST1	Use (select)
GTVSDAX_ADS	SQL View	S10B80.BANINST1	Use (select)
GTVSRCE_ADD	SQL View	S10B80.BANINST1	Use (select)
GTVSRCE_ADS	SQL View	S10B80.BANINST1	Use (select)
GTVSYSI_ADD	SQL View	S10B80.BANINST1	Use (select)
GTVSYSI_ADS	SQL View	S10B80.BANINST1	Use (select)
GTVTRTP_ADD	SQL View	S10B80.BANINST1	Use (select)
GTVTRTP_ADS	SQL View	S10B80.BANINST1	Use (select)
GTVVISS_ADD	SQL View	S10B80.BANINST1	Use (select)
GTVVISS_ADS	SQL View	S10B80.BANINST1	Use (select)
GTVZIPC_ADD	SQL View	S10B80.BANINST1	Use (select)
GTVZIPC_ADS	SQL View	S10B80.BANINST1	Use (select)
GUBLETR_ADD	SQL View	S10B80.BANINST1	Use (select)
GUBPPRF_ADD	SQL View	S10B80.BANINST1	Use (select)
GUBPPRF_ADS	SQL View	S10B80.BANINST1	Use (select)
GURCURR_ADS	SQL View	S10B80.BANINST1	Use (select)
GURCURR_SUB	SQL View	S10B80.BANINST1	Use (select)
GURSRVQ_ADD	SQL View	S10B80.BANINST1	Use (select)
GURSRVQ_ADS	SQL View	S10B80.BANINST1	Use (select)
GURSRVQ_SUB	SQL View	S10B80.BANINST1	Use (select)
SLBBLDG_ADD	SQL View	S10B80.BANINST1	Use (select)
SLBBLDG_ADS	SQL View	S10B80.BANINST1	Use (select)
SMRPRLE_ADD	SQL View	S10B80.BANINST1	Use (select)
SMRPRLE_ADS	SQL View	S10B80.BANINST1	Use (select)
SPRADDR_ADD	SQL View	S10B80.BANINST1	Use (select)
SPRADDR_ADS	SQL View	S10B80.BANINST1	Use (select)
STVRDEF_ADD	SQL View	S10B80.BANINST1	Use (select)
STVRDEF_ADS	SQL View	S10B80.BANINST1	Use (select)
F_GET_PK_TEMP	SQL Function	S10B80.BANINST1	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.GB_SDE_METADATA	Use (select)
P_VALIDATE_SDDC_CHANGE	Oracle Package Procedure	S10B80.BANINST1.GB_SDE_METADATA	Use (select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_SDE_METADATA	Use (Insert)
F_GET_PK_DEF	Oracle Package Function	S10B80.BANINST1.GP_GOKSDEN	Rely On
GORSDAV	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
GOBCMUS	SQL Table	S10B80.GENERAL	Join
GORCMSC	SQL Table	S10B80.GENERAL	Join
GTVCELG	SQL Table	S10B80.GENERAL	Join
GTVDOCM	SQL Table	S10B80.GENERAL	Join
GTVPURP	SQL Table	S10B80.GENERAL	Join
GTVSRCE	SQL Table	S10B80.GENERAL	Join
GTVSYSI	SQL Table	S10B80.GENERAL	Join
GTVTRTP	SQL Table	S10B80.GENERAL	Join
GTVVISS	SQL Table	S10B80.GENERAL	Join
SLBBLDG	SQL Table	S10B80.SATURN	Join
SMRPRLE	SQL Table	S10B80.SATURN	Join
STVRDEF	SQL Table	S10B80.SATURN	Join

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GORSDAV

Object Dates

Creation Date	Analysis Date
04/02/2008 20:28:25:000	01/01/1900 00:00:00:000

Columns Comments for GORSDAV_TABLE_NAME (# 1)

Source Code Comments

Table Name: The name of the table supplemented by the attribute.

Columns Comments for GORSDAV_ATTR_NAME (# 2)

Source Code Comments

Attribute Name: The name of the attribute.

Columns Comments for GORSDAV_DISC (# 3)

Source Code Comments

Discriminator: The discriminator value for multiple valued attributes.

Columns Comments for GORSDAV_PK_PARENTTAB (# 4)

Source Code Comments

Primary Key Parent Table: The Primary key of of the record in the Parent table.

Table GORSDDV

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GORSDDV_SDDC_CODE	VARCHAR2(10)	No	*	*
GORSDDV_DISC	VARCHAR2(64)	No	*
GORSDDV_DESC	VARCHAR2(64)	No
GORSDDV_ACTIVITY_DATE	DATE	No
GORSDDV_USER_ID	VARCHAR2(30)	No
GORSDDV_DATA_ORIGIN	VARCHAR2(30)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GORSDDV_SDDC_CODE	GOBSDDC_CODE	GOBSDDC

Index

Index Name	Index Type	Column Name
PK_GORSDDV	Unique	GORSDDV_SDDC_CODE
PK_GORSDDV	Unique	GORSDDV_DISC

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SDE_DISCRIM_VALUE_REC	Oracle Package Type	S10B80.BANINST1.GB_SDE_DISCRIM_VALUE	Rely On
P_OVERLAY_VALIDATION_REC	Oracle Package Procedure	S10B80.BANINST1.GB_SDE_DISCRIM_VALUE	Rely On
F_BUILD_GORSDDV_REC	Oracle Package Function	S10B80.BANINST1.GB_SDE_DISCRIM_VALUE	Rely On
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.GB_SDE_DISCRIM_VALUE	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.DML_GORSDDV	Use (delete)
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.GB_SDE_DISCRIM_VALUE	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.GB_SDE_DISCRIMINATOR	Use (select)
P_INSERT	Oracle Package Procedure	S10B80.BANINST1.DML_GORSDDV	Use (Insert)Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.GB_SDE_DISCRIM_VALUE	Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.GB_SDE_DISCRIM_VALUE	Use (select)
P_REGISTER_ENTITY	Oracle Package Procedure	S10B80.BANINST1.GB_SDE_DISCRIM_VALUE_RULES	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.DML_GORSDDV	Use (update)Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.GB_SDE_DISCRIM_VALUE	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.GB_SDE_DISCRIM_VALUE_RULES	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_SDE_DISCRIM_VALUE	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_SDE_DISCRIM_VALUE	Use (select)
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.GB_SDE_DISCRIM_VALUE	Rely On
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.GB_SDE_DISCRIM_VALUE	Use (select)
F_QUERY_BY_ROWID	Oracle Package Function	S10B80.BANINST1.GB_SDE_DISCRIM_VALUE	Use (select)
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.GB_SDE_DISCRIM_VALUE	Rely On
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.GB_SDE_DISCRIM_VALUE	Use (select)
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.GB_SDE_DISCRIM_VALUE	Rely On
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.GB_SDE_DISCRIM_VALUE	Use (select)
GORSDDV	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_GORSDDV	SQL Index	S10B80.GENERAL	Rely On
GOBSDDC	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GORSDDV

Object Dates

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

Source Code Comments

User Defined Supplemental Data Discriminator Values table.

Columns Comments for GORSDDV_SDDC_CODE (# 1)

Source Code Comments

Code: The Discriminator Code of the Discriminator Value.

Columns Comments for GORSDDV_DISC (# 2)

Source Code Comments

Discriminator: The discriminator value that is allowed.

Columns Comments for GORSDDV_DESC (# 3)

Source Code Comments

Description: The description for the discriminator value.

Columns Comments for GORSDDV_ACTIVITY_DATE (# 4)

Source Code Comments

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

Columns Comments for GORSDDV_USER_ID (# 5)

Source Code Comments

USER IDENTIFICATION: The unique identification of the user.

Columns Comments for GORSDDV_DATA_ORIGIN (# 6)

Source Code Comments

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

Table GOTSDCR

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GOTSDCR_TABLE_NAME	VARCHAR2(30)	No	*	*
GOTSDCR_ATTR_NAME	VARCHAR2(30)	No	*	*
GOTSDCR_DISC	VARCHAR2(64)	No	*
GOTSDCR_DESC	VARCHAR2(64)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GOTSDCR_TABLE_NAME	GORSDAM_TABLE_NAME	GORSDAM
GOTSDCR_ATTR_NAME	GORSDAM_ATTR_NAME	GORSDAM

Index

Index Name	Index Type	Column Name
PK_GOTSDCR	Unique	GOTSDCR_TABLE_NAME
PK_GOTSDCR	Unique	GOTSDCR_ATTR_NAME
PK_GOTSDCR	Unique	GOTSDCR_DISC

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GOTSDCR	SQL Index	S10B80.GENERAL	Rely On
GORSDAM	SQL Table	S10B80.GENERAL	Join

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GOTSDCR

Object Dates

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

Source Code Comments

Temporary Table to hold discriminators from a dynamic query.

Columns Comments for GOTSDCR_TABLE_NAME (# 1)

Source Code Comments

Table Name: The name of the table supplemented by the attribute.

Columns Comments for GOTSDCR_ATTR_NAME (# 2)

Source Code Comments

Attribute Name: The name of the attribute.

Columns Comments for GOTSDCR_DISC (# 3)

Source Code Comments

Discriminator: The discriminator value for multiple valued attributes.

Columns Comments for GOTSDCR_DESC (# 4)

Source Code Comments

Description: The description for the discriminator value.

Table GUBPPRF

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
GUBPPRF_FORMAT	VARCHAR2(1)	No	*
GUBPPRF_VALUE	VARCHAR2(1)	No
GUBPPRF_SELF_NOTIFY_TYPE_IND	VARCHAR2(1)	No
GUBPPRF_ADMIN_NOTIFY_TYPE_IND	VARCHAR2(1)	No
GUBPPRF_PRE_EXPIRE_IND	VARCHAR2(1)	No
GUBPPRF_USER_ID	VARCHAR2(30)	No
GUBPPRF_ACTIVITY_DATE	DATE	No
GUBPPRF_APPLICATION	VARCHAR2(30)	Yes	*
GUBPPRF_LETR_CODE_LETTER	VARCHAR2(15)	Yes	*
GUBPPRF_LETR_CODE_EMAIL	VARCHAR2(15)	Yes	*
GUBPPRF_LENGTH_LAST_NAME	NUMBER(2,0)	Yes
GUBPPRF_MIN_LENGTH	NUMBER(2,0)	No
GUBPPRF_MAX_LENGTH	NUMBER(2,0)	No
GUBPPRF_NO_OF_QSTNS	NUMBER(2,0)	No
GUBPPRF_NUM_IND	VARCHAR2(1)	No
GUBPPRF_CHAR_IND	VARCHAR2(1)	No
GUBPPRF_REUSE_DAYS	NUMBER(3,0)	No
GUBPPRF_QSTN_MIN_LENGTH	NUMBER(2,0)	Yes
GUBPPRF_ANSR_MIN_LENGTH	NUMBER(2,0)	Yes
GUBPPRF_EDITQSTN_IND	VARCHAR2(1)	No
GUBPPRF_SELF_LETR_CODE_LETTER	VARCHAR2(15)	Yes
GUBPPRF_SELF_LETR_CODE_EMAIL	VARCHAR2(15)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GUBPPRF_APPLICATION	GLBAPPL_APPLICATION	GLBAPPL
GUBPPRF_LETR_CODE_LETTER	GTVLETR_CODE	GTVLETR
GUBPPRF_LETR_CODE_EMAIL	GTVLETR_CODE	GTVLETR
GUBPPRF_FORMAT	GORSDAV_PK_PARENTTAB	GORSDAV

Index

No Result

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GUBPPRF_ADD	SQL View	S10B80.BANINST1	Use (select)
GUBPPRF_ADS	SQL View	S10B80.BANINST1	Use (select)
GUBPPRF_REC	Oracle Package Variable	S10B80.WTAILOR.TWBKLIBS	Rely On
C_GUBPPRF	Oracle Package Cursor	S10B80.BANINST1.GB_THIRD_PARTY_ACCESS_STRINGS	Use (select)
GETGUBPPRFC	Oracle Package Cursor	S10B80.BANINST1.BWAKALOG	Use (select)Rely On
P_INSERT_GURMAIL	Oracle Package Procedure	S10B80.BANINST1.GOKTPTY	Rely On
P_INSERT_GURMAIL	Oracle Package Procedure	S10B80.BANINST1.GOKTPTY	Use (select)
P_PIN_CHANGED_NOTIFICATION	Oracle Package Procedure	S10B80.BANINST1.GB_THIRD_PARTY_ACCESS	Rely On
UT_GB_THIRD_PARTY_ACCESSC_API	Oracle Package Procedure	S10B80.BANINST1.UT_GB_THIRD_PARTY_ACCESS	Use (update)
UT_GB_THIRD_PARTY_ACCESSU_API	Oracle Package Procedure	S10B80.BANINST1.UT_GB_THIRD_PARTY_ACCESS	Use (update)
GUBPPRF_REC	Oracle Package Variable	S10B80.BANINST1.GB_THIRD_PARTY_ACCESS_STRINGS	Rely On
GUBPPRF_REC	Oracle Package Variable	S10B80.BANINST1.BWAKALOG	Rely On
GUBPPRFC	Oracle Package Cursor	S10B80.BANINST1.GUKLIBS	Use (select)Rely On
P_DISPSECURITYQUESTION	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Rely On
P_DISPSECURITYQUESTION	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Use (select)Rely On
P_INSERT_GOBTPAC	Oracle Package Procedure	S10B80.BANINST1.GOKTPTY	Rely On
P_INSERT_GOBTPAC	Oracle Package Procedure	S10B80.BANINST1.GOKTPTY	Use (select)
P_PIN_CHANGED_NOTIFICATION	Oracle Package Procedure	S10B80.BANINST1.GOKMAIL	Rely On
P_PROCSECURITYANSWER	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Rely On
P_PROCSECURITYANSWER	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Use (select)Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.GB_THIRD_PARTY_ACCESS_RULES	Rely On
P_VALIDATEQUESTIONANSWER	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Rely On
P_VALIDATEQUESTIONANSWER	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Use (select)Rely On
P_VALIDATE_PINRULES	Oracle Package Procedure	S10B80.BANINST1.GB_THIRD_PARTY_ACCESS_RULES	Rely On
F_GENERATE_EXTERNAL_USER	Oracle Package Function	S10B80.BANINST1.GOKTPTY	Use (select)
F_PINLENGTH	Oracle Package Function	S10B80.WTAILOR.TWBKGLIB	Use (select)
F_PINLENGTH	Oracle Package Function	S10B80.BANINST1.GOKLIBS	Use (select)
F_PINLENGTH_VALIDATE	Oracle Package Function	S10B80.WTAILOR.TWBKGLIB	Rely On
F_PINLENGTH_VALIDATE	Oracle Package Function	S10B80.WTAILOR.TWBKGLIB	Use (select)
F_PINREUSED	Oracle Package Function	S10B80.BANINST1.GOKLIBS	Use (select)
F_RESET_PIN	Oracle Package Function	S10B80.BANINST1.GOKTPTY	Rely On
F_RESET_PIN	Oracle Package Function	S10B80.BANINST1.GOKTPTY	Use (select)
F_VALIDATE_PIN	Oracle Package Function	S10B80.BANINST1.GOKTPTY	Rely On
F_VALIDATE_PIN	Oracle Package Function	S10B80.BANINST1.GOKTPTY	Use (select)
TWBKLIBS	Oracle Package	S10B80.WTAILOR	Use (select)
GUBPPRF	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
GLBAPPL	SQL Table	S10B80.GENERAL	Refer (no action)
GORSDAV	SQL Table	S10B80.GENERAL	Join
GTVLETR	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GUBPPRF

Object Dates

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

Source Code Comments

Enterprise Pin Preference table.

Columns Comments for GUBPPRF_FORMAT (# 1)

Source Code Comments

PIN RESET FORMAT: N = Numeric, A = Alphanumeric.

Columns Comments for GUBPPRF_VALUE (# 2)

Source Code Comments

PIN RESET VALUE: B = Birth date, R = Random value.

Columns Comments for GUBPPRF_SELF_NOTIFY_TYPE_IND (# 3)

Source Code Comments

PIN USER INSERT/UPDATE NOTIFICATION CONTROL: E = Create Email, L = Create Letter, B = Create Both Email and Letter, N = No Notification.

Columns Comments for GUBPPRF_ADMIN_NOTIFY_TYPE_IND (# 4)

Source Code Comments

PIN ADMINISTRATOR INSERT/UPDATE NOTIFICATION CONTROL: E = Create Email, L = Create Letter, B = Create Both Email and Letter, N = No Notification.

Columns Comments for GUBPPRF_PRE_EXPIRE_IND (# 5)

Source Code Comments

PRE-EXPIRE PIN INDICATOR: Y = Pre-expire PINs when created automatically or in batch, N = Do not pre-expire PINs.

Columns Comments for GUBPPRF_USER_ID (# 6)

Source Code Comments

USER ID: The USER ID which changed this record.

Columns Comments for GUBPPRF_ACTIVITY_DATE (# 7)

Source Code Comments

The date on which the row was added or modified.

Columns Comments for GUBPPRF_APPLICATION (# 8)

Source Code Comments

APPLICATION CODE: Letter Generation Application code. (From GLBAPPL)

Columns Comments for GUBPPRF_LETR_CODE_LETTER (# 9)

Source Code Comments

LETTER CODE: The pin reset letter generation code for the letter notification. (From GTVLETR)

Columns Comments for GUBPPRF_LETR_CODE_EMAIL (# 10)

Source Code Comments

LETTER CODE: The pin reset letter generation code for the email notification. (From GTVLETR)

Columns Comments for GUBPPRF_LENGTH_LAST_NAME (# 11)

Source Code Comments

LENGTH OF LAST NAME: Length used when generating the GOBTPAC_EXTERNAL_USER value. The value of 7 is the preexisting (before 7.4) behavior.

Columns Comments for GUBPPRF_MIN_LENGTH (# 12)

Source Code Comments

MIN_LENGTH: Minimum length required for PIN.

Columns Comments for GUBPPRF_MAX_LENGTH (# 13)

Source Code Comments

MAX_LENGTH: Maximum length required for PIN.

Columns Comments for GUBPPRF_NO_OF_QSTNS (# 14)

Source Code Comments

NO_OF_QSTNS: Number of questions required to be answered before PIN reset is allowed.

Columns Comments for GUBPPRF_NUM_IND (# 15)

Source Code Comments

NUM_IND: Indicator requires numeric value to be present.

Columns Comments for GUBPPRF_CHAR_IND (# 16)

Source Code Comments

CHAR_IND: Indicator requires character value to be present.

Columns Comments for GUBPPRF_REUSE_DAYS (# 17)

Source Code Comments

REUSE_DAYS: Number of days required to be checked for password reuse.

Columns Comments for GUBPPRF_QSTN_MIN_LENGTH (# 18)

Source Code Comments

QSTN_MIN_LENGTH: Minimum length required for question.

Columns Comments for GUBPPRF_ANSR_MIN_LENGTH (# 19)

Source Code Comments

ANSR_MIN_LENGTH: Minimum length required for answer.

Columns Comments for GUBPPRF_EDITQSTN_IND (# 20)

Source Code Comments

EDITQSTN_IND: This indicates whether question can be edited or not.

Columns Comments for GUBPPRF_SELF_LETR_CODE_LETTER (# 21)

Source Code Comments

SELF_LETR_CODE_LETTER: Self Letter code to be used for letter generation.

Columns Comments for GUBPPRF_SELF_LETR_CODE_EMAIL (# 22)

Source Code Comments

SELF_LETR_CODE_EMAIL: Self EMail code to be used for letter generation.

Link between GOTSDCR and GORSDAM

Join Information

Objects list
schema-view : S10B80.BANINST1.GOVSDAV

Link List

Link Type	Link	Project
Join	Link Between GOTSDCR and GORSDAM	GENERAL

List of Real links

Link type	Between	And
Join	GOTSDCR	GORSDAM

Link between GUBPPRF and GORSDAV

Join Information

Objects list
schema-view : S10B80.BANINST1.GUBPPRF_ADD schema-view : S10B80.BANINST1.GUBPPRF_ADS

Link List

Link Type	Link	Project
Join	Link Between GUBPPRF and GORSDAV	GENERAL

List of Real links

Link type	Between	And
Join	GUBPPRF	GORSDAV

Link between GORSDAM and GOBSDDC

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GORSDAM and GOBSDDC (FK1_GORSDAM_INV_GOBSDDC_KEY)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GORSDAM	GORSDAM_SDDC_CODE	GOBSDDC_CODE	GOBSDDC	(0,1)-(0,n)

Link between GORSDDV and GOBSDDC

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GORSDDV and GOBSDDC (FK1_GORSDDV_INV_GOBSDDC_KEY)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GORSDDV	GORSDDV_SDDC_CODE	GOBSDDC_CODE	GOBSDDC	(1,1)-(0,n)

Link between GORSDAM and GOBSDTB

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GORSDAM and GOBSDTB (FK1_GORSDAM_INV_GOBSDTB_KEY)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GORSDAM	GORSDAM_TABLE_NAME	GOBSDTB_TABLE_NAME	GOBSDTB	(1,1)-(0,n)