DW_ITEM_CATEGORIES_DH

This table holds the information about Item category Hierarchy.

Details

Module:

Key Columns

CATEGORY_SET_ID, CATEGORY_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
CATEGORY_SET_ID NUMBER 38 0 True Collection of items grouped into categories. DW_ITEM_CATEGORY_SETS_D CATEGORY_SET_ID
CATEGORY_ID NUMBER 38 0 True Category belonging to the Item Catalog. DW_ITEM_CATEGORIES_D CATEGORY_ID
SOURCE_RECORD_ID VARCHAR2 64     Unique Identifier    
CATALOG_CODE VARCHAR2 32     Unique indentifier of the catalogs.    
CATEGORY_CODE VARCHAR2 1024     A unique identification assigned to an item class which can be easily associated with the UNSPC category.    
LVL NUMBER       Level    
PATH VARCHAR2 4000     Path    
PARENT_CATEGORY_ID1 VARCHAR2 4000     Parent Category ID1 DW_ITEM_CATEGORIES_D CATEGORY_ID
PARENT_CATEGORY_CODE1 VARCHAR2 1024     Parent Category Code1    
PARENT_CATEGORY_ID2 VARCHAR2 4000     Parent Category ID2 DW_ITEM_CATEGORIES_D CATEGORY_ID
PARENT_CATEGORY_CODE2 VARCHAR2 1024     Parent Category Code2    
PARENT_CATEGORY_ID3 VARCHAR2 4000     Parent Category ID3 DW_ITEM_CATEGORIES_D CATEGORY_ID
PARENT_CATEGORY_CODE3 VARCHAR2 1024     Parent Category Code3    
PARENT_CATEGORY_ID4 VARCHAR2 4000     Parent Category ID4 DW_ITEM_CATEGORIES_D CATEGORY_ID
PARENT_CATEGORY_CODE4 VARCHAR2 1024     Parent Category Code4    
PARENT_CATEGORY_ID5 VARCHAR2 4000     Parent Category ID5 DW_ITEM_CATEGORIES_D CATEGORY_ID
PARENT_CATEGORY_CODE5 VARCHAR2 1024     Parent Category Code5    
PARENT_CATEGORY_ID6 VARCHAR2 4000     Parent Category ID6 DW_ITEM_CATEGORIES_D CATEGORY_ID
PARENT_CATEGORY_CODE6 VARCHAR2 1024     Parent Category Code6    
PARENT_CATEGORY_ID7 VARCHAR2 4000     Parent Category ID7 DW_ITEM_CATEGORIES_D CATEGORY_ID
PARENT_CATEGORY_CODE7 VARCHAR2 1024     Parent Category Code7    
PARENT_CATEGORY_ID8 VARCHAR2 4000     Parent Category ID8 DW_ITEM_CATEGORIES_D CATEGORY_ID
PARENT_CATEGORY_CODE8 VARCHAR2 1024     Parent Category Code8    
PARENT_CATEGORY_ID9 VARCHAR2 4000     Parent Category ID9 DW_ITEM_CATEGORIES_D CATEGORY_ID
PARENT_CATEGORY_CODE9 VARCHAR2 1024     Parent Category Code9    
PARENT_CATEGORY_ID10 VARCHAR2 4000     Parent Category ID10 DW_ITEM_CATEGORIES_D CATEGORY_ID
PARENT_CATEGORY_CODE10 VARCHAR2 1024     Parent Category Code10    
PARENT_CATEGORY_ID11 VARCHAR2 4000     Parent Category ID11 DW_ITEM_CATEGORIES_D CATEGORY_ID
PARENT_CATEGORY_CODE11 VARCHAR2 1024     Parent Category Code11    
PARENT_CATEGORY_ID12 VARCHAR2 4000     Parent Category ID12 DW_ITEM_CATEGORIES_D CATEGORY_ID
PARENT_CATEGORY_CODE12 VARCHAR2 1024     Parent Category Code12    
PARENT_CATEGORY_ID13 VARCHAR2 4000     Parent Category ID13 DW_ITEM_CATEGORIES_D CATEGORY_ID
PARENT_CATEGORY_CODE13 VARCHAR2 1024     Parent Category Code13    
PARENT_CATEGORY_ID14 VARCHAR2 4000     Parent Category ID14 DW_ITEM_CATEGORIES_D CATEGORY_ID
PARENT_CATEGORY_CODE14 VARCHAR2 1024     Parent Category Code14    
PARENT_CATEGORY_ID15 VARCHAR2 4000     Parent Category ID15 DW_ITEM_CATEGORIES_D CATEGORY_ID
PARENT_CATEGORY_CODE15 VARCHAR2 1024     Parent Category Code15