POI_RESET_ACTIVITY_STATUS

This table contains information about the reset action on classified data sets. Reset action sets the data set back to its original state, the state before running classification process on the data set. After reset action, users can submit the data set for classification again.

Details

• Schema: FUSION

• Object owner: POI

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
poi_reset_activity_status_PK	SEQ_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
DATA_TYPE	VARCHAR2	30			Data set that is being reset to clear the calculated values.
NEW_DS_NAME	VARCHAR2	100			Name of new dataset during copy action.
DATASET_NAME	VARCHAR2	100			Name of the data set to which the REST operation is applied.
BATCH_ID	NUMBER		18		Identifies the batch reset activity.
DATASET_RESET_CRITERIA	VARCHAR2	1000			Criteria used to reset the data set to check for the operation.
STATUS	VARCHAR2	30			Status of the reset activity on the data set.
SEQ_ID	NUMBER		18	Yes	Identifies the activity sequence.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of 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_RESET_ACTIVITY_STATUS_N1	Non Unique	Default	CREATION_DATE
POI_RESET_ACTIVITY_STATUS_U1	Unique	Default	SEQ_ID