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

ZCH_BATCH_DATA_ENRICH_REQ_DTLS

Table that stores the DAAS JOBS submitted for one enrichment job

Details

  • Schema: FUSION

  • Object owner: ZCH

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

ZCH_BTCH_DATA_ERCH_DTLS_PK

REQUEST_DETAIL_ID

Columns

Name Datatype Length Precision Not-null Comments Status
REQUEST_DETAIL_ID NUMBER 18 Yes Column displaying the unique request detail identifier, primary key for this table
BATCH_REQUEST_ID NUMBER 18 Yes Foreign key to BATCH_REQUEST_ID in table ZCH_BATCH_DATA_ENRICH_REQ
DAAS_JOB_STATUS VARCHAR2 30 Column indicating the status of the DaaS enrichment job
STATUS VARCHAR2 30 Column indicating the status of the chunk
DAAS_JOB_ID NUMBER 18 Job ID submitted to DaaS for enrichment.
IMPORT_JOB_ID NUMBER 18 Column indicating the import job id for the chunk
DAAS_PROCESSED_RECORDS NUMBER 18 Number of records submitted to Daas in this batch
DAAS_MATCHED_RECORDS NUMBER 18 Number of records matched in DaaS
DAAS_REJECTED_RECORDS NUMBER 18 Number of records rejected for matching by DaaS
DAAS_FAILED_RECORDS NUMBER 18 Number of records for which match was not found in DaaS.
NUM_RECORDS_COMPLETED NUMBER 18 Number of Import completed
NUM_RECORDS_ERRORED NUMBER 18 Number of import failed
DAAS_ERROR_CODE VARCHAR2 100 Error Code returned by DaaS if job fails
CHUNK_ID NUMBER 18 Yes ID representing the data chunk that is part of the enrichment process.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated 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

Foreign Keys

Table Foreign Table Foreign Key Column
ZCH_BATCH_DATA_ENRICH_REQ_DTLS zch_batch_data_enrich_req BATCH_REQUEST_ID

Indexes

Index Uniqueness Tablespace Columns
ZCH_BTCH_DATA_ERCH_DTLS_N1 Non Unique Default BATCH_REQUEST_ID
ZCH_BTCH_DATA_ERCH_DTLS_U1 Unique Default REQUEST_DETAIL_ID