CSO_SCH_INT_PARAM_HI

This table stores the history of Concept parameter that enables Intent to match a range of questions that differ only in a specific detail, using the same IML question pattern (currently not used)

Details

  • Schema: FUSION

  • Object owner: CSO

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

CSO_SCH_INT_PARAM_HI_PK

RECORD_ID, ROW_START

Columns

Name Datatype Length Not-null Comments
CONCEPT_ID VARCHAR2 32 Yes This is the Concept Id for this record.
DESCRIPTION VARCHAR2 4000 Yes This is the description of the config object.
INTENT_ID VARCHAR2 32 This is the intent ID of this record.
PARAMETERS_ORDER NUMBER The order of this parameter in the list of Concept parameters of the Intent.
RECORD_ID VARCHAR2 32 Yes Record ID, forming compound primary key with ROW_START
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.
VARIABLE VARCHAR2 64 Yes Global variable defined in IML (In order for Intents to use Concept parameters, the IML pattern must contain a global variable)

Indexes

Index Uniqueness Columns
CSO_SCH_INT_PARAM_HI_U1 Unique RECORD_ID, ROW_START