MSC_FILTERS_DATA

This table stores the pre-collected data for an instance that is used for showing the filter options in collect planning data screen.

Details

• Schema: FUSION

• Object owner: MSC

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
MSC_FILTERS_DATA_PK	FILTER_ENTITY_NAME, FILTER_ENTITY_VALUE, SR_INSTANCE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
FILTER_ENTITY_NAME	VARCHAR2	100		Yes	Name of the entity that is used as a filter option ???PRICE_LISTS???, ???ORDER_TYPES???, ???CONVERSION_RATE_TYPES???, ???CATEGORY_SETS???
ATTRIBUTE_CATEGORY	VARCHAR2	30			Descriptive Flexfield: structure definition of the user descriptive flexfield.
FILTER_ENTITY_VALUE	VARCHAR2	300		Yes	List Values that are populated by pre collection and are shown as list of values for the filters
FILTER_ENTITY_CODE	VARCHAR2	50			Codes that are populated by pre collection. This column will be populated only for COUNTRY filter.
SR_INSTANCE_ID	NUMBER		18	Yes	Instance Identifier, for which the pre-collected data belongs to
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
ATTRIBUTE_DATE1	DATE				Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE2	DATE				Descriptive Flexfield: segment of the user descriptive flexfield.

Indexes

Index	Uniqueness	Tablespace	Columns
MSC_FILTERS_DATA_U1	Unique	Default	FILTER_ENTITY_NAME, FILTER_ENTITY_VALUE, SR_INSTANCE_ID