DW_ITEM_CATEGORY_SETS_D

This table contains item category set information.

Details

Module:

Key Columns

CATEGORY_SET_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
CATEGORY_SET_ID NUMBER 38 0 True CATEGORY_SET_ID
SOURCE_RECORD_ID NUMBER 38 0 This column is for Oracle Internal use only. Source record identifier.
CATALOG_CODE VARCHAR2 32 CATALOG_CODE
MULT_ITEM_CAT_ASSIGN_FLAG VARCHAR2 16 MULT_ITEM_CAT_ASSIGN_FLAG
CONTROL_LEVEL NUMBER CONTROL_LEVEL DW_CATALOG_CONTROL_LVL_LKP_TL CATALOG_CONTROL_LEVEL_CODE
DEFAULT_CATEGORY_CODE VARCHAR2 999 Category an item is assigned to when during new item creation
START_DATE DATE Date the catalog will become active
END_DATE DATE Date the catalog will become inactive