CSO_DATA_LIST

This table contains the definition of a data list. Data lists can be based off of content channels or static lists.

Details

• Schema: FUSION

• Object owner: CSO

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
CSO_DATA_LIST_PK	RECORD_ID

Columns

Name	Datatype	Length	Not-null	Comments
USE_OR_FILTER	VARCHAR2	255	Yes	DEPRECATED: A flag indicating if an OR filter should be used - default to n.
CONTENT_CHANNEL_ID	VARCHAR2	32		This is the Reference to content channel record.
DATE_ADDED	TIMESTAMP		Yes	This is the date that the record was added to the repository.
DATE_MODIFIED	TIMESTAMP		Yes	This is the date that the record was modified.
DISPLAY_SOURCE	VARCHAR2	1000		XPATH value of the channel attribute that will contain the DISPLAY name for the data list entry.
LIST_TYPE_ID	VARCHAR2	32	Yes	This is the GUID reference to LOOKUP_CODE table that indicates what type of datalist this is. i.e. static or channel based.
OWNER_SITE_ID	VARCHAR2	32	Yes	This is the GUID reference to the repository (SITE) that this data list belongs to
RECORD_ID	VARCHAR2	32	Yes	This is the primary key of the table.
REFERENCE_KEY	VARCHAR2	255	Yes	This is the Non localized name for a repository ojbect.
USE_CONTENT_GUID_FLAG	CHAR	1		DEPRECATED: not used any longer. Default to n.
VALUE_SOURCE	VARCHAR2	1000		XPATH value of the channel attribute (dynamic lists) of the datalist channel that will contain the VALUE of the data list entry.
SORT_VALUE_SOURCE	VARCHAR2	1000		XPATH value for the attribute (dynamic lists) that will be used to sort the data list.
DEFAULT_VALUE_SOURCE	VARCHAR2	1000		XPATH value of the channel attribute (dynamic lists) that will be used as the default value for the list.
DEFAULT_VALUE	VARCHAR2	255		Default value (static lists) used as the default value of the data list.
DEFAULT_VALUE_OPERATOR	NUMBER			A flag indicating the default operator (1=equals, 2=not equals)
STATIC_SORT	CHAR	1		A flag indicating the how the data list should be sorted (A=alpha sort, S=defined sort order)

Foreign Keys

Table	Foreign Table	Foreign Key Column
CSO_DATA_LIST	cso_channel	CONTENT_CHANNEL_ID
CSO_DATA_LIST	cso_lookup_code	LIST_TYPE_ID
CSO_DATA_LIST	cso_site	OWNER_SITE_ID
cso_data_list_item	cso_data_list	DATA_LIST_ID
cso_schema_attribute	cso_data_list	DATA_LIST_ID
cso_data_list_res	cso_data_list	DATA_LIST_ID
cso_data_list_filter	cso_data_list	DATA_LIST_ID

Indexes

Index	Uniqueness	Columns
CSO_DATA_LIST_U1	Unique	RECORD_ID
CSO_DATA_LIST_N1	Non Unique	OWNER_SITE_ID
CSO_DATA_LIST_N2	Non Unique	CONTENT_CHANNEL_ID
CSO_DATA_LIST_N3	Non Unique	LIST_TYPE_ID