CSO_SCH_CONT_VALUE_HI

This table stores the history of the context variable values (currently not used)

Details

  • Schema: FUSION

  • Object owner: CSO

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

CSO_SCH_CONT_VALUE_HI_PK

RECORD_ID, ROW_START

Columns

Name Datatype Length Not-null Comments
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.
RECORD_ID VARCHAR2 32 Yes Record ID, forming compound primary key with ROW_START
REQUEST_USE_CASE_ID VARCHAR2 32 This is the Request use case Id.
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.
VALUE VARCHAR2 255 Yes This is the Context variable value.
VARIABLE_KEY_ID VARCHAR2 32 This is the Context variable key Id.

Indexes

Index Uniqueness Columns
CSO_SCH_CONT_VALUE_HI_U1 Unique RECORD_ID, ROW_START