CSO_SCH_CONFIG_REV_HI

This table stores the history of the configurarion revisions.

Details

• Schema: FUSION

• Object owner: CSO

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
CSO_SCH_CONFIG_REV_HI_PK	RECORD_ID, ROW_START

Columns

Name	Datatype	Length	Not-null	Comments
APP	VARCHAR2	8	Yes	The application that updated the configuration, (e.g. IB for Intent Builder)
CREATED_BY_ID	VARCHAR2	32		UUID of the user that created the revision.
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.
PUBLISH_DATE	TIMESTAMP			This is the datetime when the revision is published.
RECORD_ID	VARCHAR2	32	Yes	Record ID, forming compound primary key with ROW_START
REVISION	NUMBER			This is the configuration revision for this record.
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.

Indexes

Index	Uniqueness	Columns
CSO_SCH_CONFIG_REV_HI_U1	Unique	RECORD_ID, ROW_START