POI_BATCHES

This table contains information about the classification batches. A batch is created when the classification process is run for a data set. The information available about the batch is: batch name, knowledge base used, taxonomy name, and batch approval status. There is one record for each batch in the table.

Details

• Schema: FUSION

• Object owner: POI

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
POI_BATCHES_PK	BATCH_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
BATCH_ID	NUMBER		18	Yes	Uniquely identifies the transaction batch submitted or uploaded.
CLSF_START_DATE	DATE			Yes	Start date for the batch classification.
CLSF_END_DATE	DATE				End date for the batch classification.
APPROVAL_STATUS	VARCHAR2	30			Indicates approval status of batch.
APPROVAL_DATE	DATE				Date when the batch is approved.
CLSF_STATUS	VARCHAR2	30			Data classification status about the batch approval.
APPROVED_BY	VARCHAR2	30			Name of the approver of the batch
TAXONOMY_ID	NUMBER		18		Unique identifier for the taxonomy.
BATCH_DESC	VARCHAR2	255			Identifies the description of the batch.
MODEL_NAME	VARCHAR2	30			Identifies the name of the model in the batch.
ERROR_CODE	VARCHAR2	240			Error code of the processed batch.
APPLY_OPERATION_NAME	VARCHAR2	30			Operation name given at the time of batch creation.
DATA_SOURCE_LISTS	VARCHAR2	2000			Identifies the value of data source lists.
APPROVAL_ERR_MSG	VARCHAR2	2000			Error message, if any, in the approval process.
ERROR_MESSAGE	VARCHAR2	1000			Error message, if any, from the batch process.
CURRENT_STEP	VARCHAR2	30			Identifies the current step in the process.
CURRENT_STEP_PERCENT_COMPLETE	NUMBER				Percentage of current step that is completed in the batch process.
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_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of 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.

Indexes

Index	Uniqueness	Tablespace	Columns
POI_BATCHES_U1	Unique	Default	BATCH_ID