CSO_CONFIG_VALUE

This table contains the Configuration Values.

Details

  • Schema: FUSION

  • Object owner: CSO

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

CSO_CONFIG_VALUE_PK

RECORD_ID

Columns

Name Datatype Length Not-null Comments
DATE_ADDED TIMESTAMP Yes This is the date that the record was added to the repository.
DATE_MODIFIED TIMESTAMP Yes Date record was last modified in repository.
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.
RECORD_ID VARCHAR2 32 Yes This is the primary key of the table.
CONFIG_MODULE_ID VARCHAR2 32 Yes This is the GUID reference to the module.
PROPERTY_ID VARCHAR2 32 This is the GUID reference to the config property.
VALUE VARCHAR2 2000 This is the Value for the property for this record.
INSTANCE_ID VARCHAR2 32 Instance ID where the value applies.
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_CONFIG_VALUE cso_config_property_def PROPERTY_ID
CSO_CONFIG_VALUE cso_config_module CONFIG_MODULE_ID

Indexes

Index Uniqueness Tablespace Columns
CSO_CONFIG_VALUE_N1 Non Unique Default PROPERTY_ID
CSO_CONFIG_VALUE_N2 Non Unique Default CONFIG_MODULE_ID
CSO_CONFIG_VALUE_U1 Unique Default RECORD_ID, ORA_SEED_SET1
CSO_CONFIG_VALUE_U11 Unique Default RECORD_ID, ORA_SEED_SET2