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    

Copyright © 2019, 2024, Oracle and/or its affiliates.