CSO_SCH_CLUS_HI

This table stores the history of clusters, namely a set of concepts that are related to each other but not synonymous (currently not used)

Details

• Schema: FUSION

• Object owner: CSO

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
CSO_SCH_CLUS_HI_PK	RECORD_ID, ROW_START

Columns

Name	Datatype	Length	Not-null	Comments
CONFIG_CREATE_DATE	TIMESTAMP			This is the datetime when the config object was created (This value can be initially set by the user)
CONFIG_UPDATE_DATE	TIMESTAMP			This is the datetime when the config object was last modified (This value can be initially set by the user)
CREATE_USER_LOGIN	VARCHAR2	255		This is the user that created the record.
DATE_ADDED	TIMESTAMP		Yes	This is the datetime when the record was added.
DATE_MODIFIED	TIMESTAMP		Yes	This is the datetime when the record was last modified.
DOMAIN_ID	VARCHAR2	32		A foreign key reference to RECORD_ID in CSO_SCH_DOM table.
ENABLED	NUMBER		Yes	A boolean flag indicating whether the config object is enabled.
NOTES	VARCHAR2	4000		These are the Notes for the config object.
RECORD_ID	VARCHAR2	32	Yes	Record ID, forming compound primary key with ROW_START
REFERENCE_KEY	VARCHAR2	255		Non localized reference key for the config object.
ROW_END	TIMESTAMP			This is the dateime when a specific version of the config object was modified (NULL indicates this version has not been modified and is currently active)
ROW_START	TIMESTAMP		Yes	This is the datetime when a specific version of the config object was added.
SAVE_MESSAGE	VARCHAR2	255		This is the Commentary for saving the record.
UPDATE_USER_LOGIN	VARCHAR2	255		This is the user that updated the record.
VERSION	NUMBER			This is the revision number for this record.

Indexes

Index	Uniqueness	Columns
CSO_SCH_CLUS_HI_U1	Unique	RECORD_ID, ROW_START