ZCA_BATCH_DETAILS
The ZCA_BATCH_DETAILS is a transactional table that holds details about each batch that is submitted via a job.
Details
-
Schema: FUSION
-
Object owner: ZCA
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
ZCA_BATCH_DETAILS_PK |
BATCH_DETAIL_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| BATCH_DETAIL_ID | NUMBER | 18 | Yes | Sequence generated primary key. | |
| JOB_DEFINITION | VARCHAR2 | 800 | ESS job definition. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| PARENT_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the parent request ID of the job that created or last updated the row. | ||
| BATCH_TYPE | VARCHAR2 | 30 | Type of the Batch | ||
| SOURCE_DATA_LOCATION | VARCHAR2 | 2000 | Location of source data to be processed by the batch | ||
| SOURCE_TYPE | VARCHAR2 | 30 | The type of source data provided in field SOURCE_DATA_LOCATION | ||
| BATCH_MODE | VARCHAR2 | 250 | Mode of batch. For example 'FULL','INCREMENTAL', 'RECOVER', etc. | ||
| SOURCE_OBJECT_CODE | VARCHAR2 | 250 | The source object to import. Example - IB Asset, OSS Asset. | ||
| NUMBER_OF_BATCHES | NUMBER | 10 | Number of batches per source object code. | ||
| BATCH_ID | NUMBER | 18 | Batch Identifier. | ||
| BATCH_STATUS | VARCHAR2 | 100 | Execution status of the batch. Valid values are 'QUEUED', 'PROCESSING', 'COMPLETE','ERROR'. | ||
| PROCESSED_ROW_COUNT | NUMBER | 18 | Number of rows processed with the batch. | ||
| ERROR_MESSAGE | VARCHAR2 | 4000 | Error message for the batch. | ||
| RECOVERABLE_FLAG | VARCHAR2 | 1 | Indicator to show if the batch is 'RECOVERABLE or 'NON-RECOVERABLE'. | ||
| RETRIES_LEFT | NUMBER | 2 | Number of re-tries left for the batch. | ||
| 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. | ||
| SOURCE_DATA | CLOB | Source data to be processed by the batch. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| ZCA_BATCH_DETAILS_N1 | Non Unique | Default | PARENT_REQUEST_ID, BATCH_ID, SOURCE_OBJECT_CODE |
| ZCA_BATCH_DETAILS_N2 | Non Unique | Default | PARENT_REQUEST_ID, BATCH_STATUS, RECOVERABLE_FLAG |
| ZCA_BATCH_DETAILS_N3 | Non Unique | Default | JOB_DEFINITION, BATCH_STATUS |
| ZCA_BATCH_DETAILS_N4 | Non Unique | Default | REQUEST_ID |
| ZCA_BATCH_DETAILS_PK | Unique | Default | BATCH_DETAIL_ID |