CSO_SCH_SPELL_CORR_HI

This table stores the history of spellcheck lists, namely user-defined spelling corrections.

Details

  • Schema: FUSION

  • Object owner: CSO

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

CSO_SCH_SPELL_CORR_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.
DESCRIPTION VARCHAR2 4000 This is the description of the config object.
ENABLED NUMBER Yes A boolean flag indicating whether the config object is enabled.
LOCALE VARCHAR2 32 Yes The locale of the spellcheck list.
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_SPELL_CORR_HI_U1 Unique RECORD_ID, ROW_START