ZCQ_CONFIGURATIONS

ZCQ_CONFIGURATIONS table stores the various configurations for each data quality entity along with the match option and the data quality server used got this configuration. This table stores both matching and cleansing configurations

Details

• Schema: FUSION

• Object owner: ZCQ

• Object type: TABLE

• Tablespace: REFERENCE

Primary Key

Name	Columns
ZCQ_CONFIGURATIONS_PK	CONFIGURATION_CODE

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
CONFIGURATION_CODE	VARCHAR2	64		Yes	CONFIGURATION_CODE	Active
CONFIGURATION_NAME	VARCHAR2	128		Yes	CONFIGURATION_NAME	Active
CONFIGURATION_DESCRIPTION	VARCHAR2	260			CONFIGURATION_DESCRIPTION	Active
ENTITY_CODE	VARCHAR2	32			ENTITY_CODE	Active
SERVER_OPERATION_ID	NUMBER		18	Yes	SERVER_OPERATION_ID	Active
OPTION_CODE	VARCHAR2	32			OPTION_CODE	Active
CONFIG_TYPE	VARCHAR2	32			CONFIG_TYPE	Active
DEFAULT_FLAG	VARCHAR2	1			DEFAULT_RT_FLAG	Active
DEFAULT_FLAG_BT	VARCHAR2	1			DEFAULT_BT_FLAG
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.	Active
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.	Active
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.	Active
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.	Active
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.	Active
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.	Active
ENABLED_FLAG	VARCHAR2	1			Decide if the configuration is enabled
READY_FLAG	VARCHAR2	1			Decide if the configuration is ready to use
VALID_FLAG	VARCHAR2	1			Decide if the configuration is valid
STATUS_MESSAGE_CODE	VARCHAR2	40			Message Code
STATUS_TIMESTAMP_TOKEN	TIMESTAMP				Timestamp of message token
STATUS_UPDATE_TIME	TIMESTAMP				The timestamp of updating status fields
JOB_REQUEST_ID	NUMBER		18		ESS Job request ID
STATUS_NUMBER_TOKEN	NUMBER		18		STATUS_NUMBER_TOKEN
ENGINE_TYPE	VARCHAR2	20			Type of match scoring engine. e.g. EDQ or Custom Scoring.
SEED_DATA_SOURCE	VARCHAR2	512			Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.
CANDIDATE_SQL	CLOB				Candidate SQL to load up the TCA data for this mapping.
BATCH_ENGINE_TYPE	VARCHAR2	20			Type of scoring engine for batch match - EDQ or Custom Scoring.
ORA_SEED_SET1	VARCHAR2	1		Yes	Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N.
ORA_SEED_SET2	VARCHAR2	1		Yes	Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N.

Foreign Keys

Table	Foreign Table	Foreign Key Column
ZCQ_CONFIGURATIONS	zcq_server_operations	SERVER_OPERATION_ID
zcq_iir_sync_summaries	zcq_configurations	SYNC_CONFIG_CODE

Indexes

Index	Uniqueness	Tablespace	Columns	Status
ZCQ_CONFIGURATIONS_PK	Unique	FUSION_TS_SEED	CONFIGURATION_CODE, ORA_SEED_SET1	Active
ZCQ_CONFIGURATIONS_PK1	Unique	FUSION_TS_SEED	CONFIGURATION_CODE, ORA_SEED_SET2
ZCQ_CONFIGURATIONS_U1	Unique	FUSION_TS_SEED	CONFIGURATION_CODE, LAST_UPDATE_DATE, ORA_SEED_SET1	Active
ZCQ_CONFIGURATIONS_U11	Unique	FUSION_TS_SEED	CONFIGURATION_CODE, LAST_UPDATE_DATE, ORA_SEED_SET2