CSO_DELETION_HISTORY

This table is used to store history of deleted records from other tables such as TAG.

Details

• Schema: FUSION

• Object owner: CSO

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
CSO_DELETION_HISTORY_PK	RECORD_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
RECORD_ID	VARCHAR2	32		Yes	This is the primary key of the table.
USER_ID	VARCHAR2	32			This is the obsolete GUID of a user who deleted a record from a table.
DATE_DELETED	TIMESTAMP			Yes	This is the datetime that the ID_DELETED record was deleted from the table identified by TABLE_NAME.
TABLE_NAME	VARCHAR2	255		Yes	This is the name of the database table from which the ID_DELETED record was removed.
ID_DELETED	VARCHAR2	32		Yes	The record ID that was deleted from the table identified by TABLE_NAME.
ENTITY_TYPE	VARCHAR2	255			A record type used in code and for business use to track deletion.
ENTITY_SUB_TYPE	VARCHAR2	255			A record sub type used in code and for business use to track deletion.
COMMENTS	VARCHAR2	1024			Extra information on the record that was removed.
USER_PARTY_ID	NUMBER		18		This is the ID of a user who deleted a record from a table.

Indexes

Index	Uniqueness	Tablespace	Columns
CSO_DELETION_HISTORY_U1	Unique	Default	RECORD_ID