1. Tables and Views for Sales and Fusion Service
  2. ZCH_DATA_MGMT_BATCHES_B

ZCH_DATA_MGMT_BATCHES_B

This table stores batches information to identify duplicates in a system. It uses data quality rules to identify duplicate records to automatically or manually merge the duplicate records.

Details

  • Schema: FUSION

  • Object owner: ZCH

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

ZCH_DATA_MGMT_BATCHES_B_PK

DATA_MGMT_BATCH_ID

Columns

Name Datatype Length Precision Not-null Comments
DATA_MGMT_BATCH_ID NUMBER 18 Yes Primary key
BATCH_NUMBER VARCHAR2 64 Yes Identification Batch Number
BATCH_STATUS_CODE VARCHAR2 30 Yes Status of the identification batch
PROCESS_OPTION_CODE VARCHAR2 50 Processing options: auto create duplicate request, auto create duplicate request and auto merge, manual review, auto cleansing, simulate cleansing
OBJ_NAME VARCHAR2 30 The object name to run match or cleansing, party, address, location ect.
OBJ_DEF VARCHAR2 100 The merge object definition, whole package name
ASSIGNED_USER_ID VARCHAR2 64 Identifier of the User assigned to the batch
BATCH_TYPE VARCHAR2 30 Type of the Batch. Example, CLEANSING, MATCH or INTERNAL
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
TOTAL_RECORDS_PROCESSED NUMBER 18 Total nu,mber of records processed
TOTAL_RECORDS_ERROR NUMBER 18 Number of records are not updated to base table because of error
BATCH_START_TIME TIMESTAMP Batch start time
BATCH_END_TIME TIMESTAMP Batch end time
PROCESS_DURATION NUMBER 18 Process duration
PROCESS_DURATION_UOM VARCHAR2 30 Unit of measure for process duration. It could be hours, or minutes
PROCESS_MODE VARCHAR2 30 Cleanse mode or validation mode
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
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.
REQUESTED_USER_ID NUMBER 18 This column stores the actual user who created the record.
REPEAT_FLAG VARCHAR2 1 To indicate if this batch is a template only
PARENT_BATCH_ID NUMBER 18 The identifier of the original template batch where this batch is copied from
CONFIG_CODE VARCHAR2 50 To store the DQ batch config code
DQ_REQUEST_ID NUMBER 18 Indicates the ESS request ID of the DQ job
MATCH_MODE VARCHAR2 30 To store the mode of the DQ match
MATCH_THRESHOLD NUMBER 3 The minimum match score required for match results to be returned. Can take values of 0-101.
MATCH_CLUSTER_LEVEL VARCHAR2 20 The cluster level of keys based on which records are matched for identifying potential duplicates. Can take values of 1(Normal), 2(Typical) and 3(Exhaustive).
MERGE_THRESHOLD NUMBER 3 The minimum match score required for duplicates to be merged with the master. Can take values of 0-101.
LINK_THRESHOLD NUMBER 3 The minimum match score required for duplicates to be linked with the master. Can take values of 0-101.
SEND_NOTIFICATION VARCHAR2 1 To indicate whether merge processing notifications will be sent for merge requests created from this batch.
CLNS_MIN_VERIF_LEVEL VARCHAR2 30 Configuration to specify minimum verification level to which an address should match before cleansing
CLNS_MIN_VERIF_SCORE NUMBER 3 Configuration to specify minimum verification score which an address should achieve before being cleansed
CLNS_DEFAULT_COUNTRY_CODE VARCHAR2 2 Configuration to specify default country value which will be used for cleansing, if an address does not have a country field value
CLNS_OUTPUT_CASE VARCHAR2 30 Configuration to specify the case of a cleansed address. Example: upper case, lower case, and so on.
CLNS_PARTIAL_VERIF_ALLOWED VARCHAR2 1 Configuration to specify whether a partially matched address should be cleansed
CLNS_AMBIGUOUS_ADDR_ALLOWED VARCHAR2 1 Configuration to specify whether an ambiguous match should be cleansed
CLNS_RETURN_NATIVE_SCRIPT VARCHAR2 1 Configuration to specify whether a cleansed address output should be saved in a native script
OBJ_FILTER_EXPR CLOB Object filter expression used in the batch selection criteria.

Foreign Keys

Table Foreign Table Foreign Key Column
zch_data_select_criteria_b zch_data_mgmt_batches_b DATA_MGMT_BATCH_ID
zch_clns_loc_results zch_data_mgmt_batches_b DATA_MGMT_BATCH_ID
zch_select_results zch_data_mgmt_batches_b DATA_MGMT_BATCH_ID
zch_dup_idnt_sets zch_data_mgmt_batches_b DATA_MGMT_BATCH_ID
zch_data_mgmt_obj_dtls zch_data_mgmt_batches_b DATA_MGMT_BATCH_ID
zch_data_mgmt_batches_tl zch_data_mgmt_batches_b DATA_MGMT_BATCH_ID

Indexes

Index Uniqueness Tablespace Columns
ZCH_DATA_MGMT_BATCHES_B_N1 Non Unique Default BATCH_STATUS_CODE, BATCH_TYPE
ZCH_DATA_MGMT_BATCHES_B_N2 Non Unique Default BATCH_NUMBER, BATCH_STATUS_CODE
ZCH_DATA_MGMT_BATCHES_B_N3 Non Unique Default CREATION_DATE
ZCH_DATA_MGMT_BATCHES_B_PK Unique Default DATA_MGMT_BATCH_ID
ZCH_DATA_MGMT_BATCHES_B_U1 Unique Default BATCH_NUMBER