CSO_SCH_CAT_ALIAS

This table stores category alias.

Details

• Schema: FUSION

• Object owner: CSO

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
CSO_SCH_CAT_ALIAS_PK	RECORD_ID

Columns

Name	Datatype	Length	Not-null	Comments
ALIAS	VARCHAR2	100	Yes	This is the text of the alias name.
CATEGORY_ID	VARCHAR2	32	Yes	Category ID the alias refers to
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.
DISAMBIGUATORS	VARCHAR2	2000		Comma-separated list of product node names, used as additional required matches, to disambiguate an ambiguous (aka SEGMENTED) alias during Alias Classification.
ENABLED	NUMBER		Yes	A boolean flag indicating whether the config object is enabled.
GENERATED	NUMBER		Yes	A boolean flag indicating whether the alias was automatically generated by the Category Alias Generator.
IMPORTANCE	NUMBER		Yes	Range value: from 0.0 low, such as for a parent node, to 1.0 high, such as for a leaf node in Product Tree.
RECORD_ID	VARCHAR2	32	Yes	This is the primary key of the table.
REFERENCE_KEY	VARCHAR2	255	Yes	Non localized reference key for the config object.
MATCHING_STRATEGY	VARCHAR2	50	Yes	Matching strategy for matching Alias to Content.
SAFETY_FACTOR	NUMBER		Yes	Range value: from 0.0 unsafe to 1.0 very safe (confident that it is a good alias)
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_CAT_ALIAS_U1	Unique	RECORD_ID