1. Tables and Views for Sales and Fusion Service
  2. CSO_SCH_CONT_VAR

CSO_SCH_CONT_VAR

This table stores context variables (currently not used)

Details

  • Schema: FUSION

  • Object owner: CSO

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

CSO_SCH_CONT_VAR_PK

RECORD_ID

Columns

Name Datatype Length Not-null Comments
CACHE_LEVEL NUMBER Yes This is the Cache level for the record.
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.
DATA_TYPE_CLASS VARCHAR2 100 This is the Data type for this 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.
ENABLED NUMBER Yes A boolean flag indicating whether the config object is enabled.
EXACT_MATCH NUMBER Yes A boolean flag indicating whether context variable is exact match
MODIFIABLE NUMBER Yes A boolean flag indicating whether context variable is modifiable.
NOTES VARCHAR2 4000 These are the Notes for the config object.
PURPOSE VARCHAR2 100 This is the Purpose of this record in this tables.
RECORD_ID VARCHAR2 32 Yes This is the primary key of the table.
REFERENCE_KEY VARCHAR2 255 Non localized reference key for the config object.
SAVE_MESSAGE VARCHAR2 255 This is the Commentary for saving the record.
TITLE VARCHAR2 4000 Yes This is the Title for the record.
TRAVERSAL_TYPE NUMBER Yes This is the Traversal type for 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.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.
ORA_SEED_SET1 VARCHAR2 1 Yes Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N.
ORA_SEED_SET2 VARCHAR2 1 Yes Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N.

Foreign Keys

Table Foreign Table Foreign Key Column
cso_sch_cxt_var_res cso_sch_cont_var RESOURCE_ID

Indexes

Index Uniqueness Tablespace Columns
CSO_SCH_CONT_VAR_U1 Unique Default RECORD_ID, ORA_SEED_SET1
CSO_SCH_CONT_VAR_U11 Unique Default RECORD_ID, ORA_SEED_SET2