DW_CXS_PRODUCT_GROUP_CF_DN_DH

This table contains products hierarchy

Details

Module:

Key Columns

USAGE_CODE, PRODUCT_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
PRODUCT_ID NUMBER 38 0 True Product Identifier for the Product Group
USAGE_CODE VARCHAR2 32 True Usage Code for the product . For eg Service,Base or HRHELPDESK
SOURCE_RECORD_ID VARCHAR2 128 This column is for Oracle Internal use only. System Generated Key
INVENTORY_ITEM_ID NUMBER 38 0 INVENTORY_ITEM_ID DW_CXS_PRODUCT_D INVENTORY_ITEM_ID
INVENTORY_ORGANIZATION_ID NUMBER 38 0 INV_ORG_ID
PRODUCT_GROUP_ID NUMBER 38 0 Product Group Identifier, derived field. DW_CXS_PRODUCT_GROUP_D PRODUCT_GROUP_ID
ITEM_OR_PRODUCT_GROUP VARCHAR2 16 Is this a item or a product group
FIRST_PRODUCT_GROUP_ID NUMBER 38 0 Root or the topmost item in the product hierarchy DW_CXS_PRODUCT_GROUP_D PRODUCT_GROUP_ID
LAST_PRODUCT_GROUP_ID NUMBER 38 0 Current product id in discussion. This is used in generating the entire product hiearchy from root to the current product DW_CXS_PRODUCT_GROUP_D PRODUCT_GROUP_ID
FIXED_HIERARCHY_LEVEL NUMBER 38 0 This gives the distance from the root to the current product
PRODUCT_GROUP_LEVEL_0_TO_TOP NUMBER 38 0 Root item or product group DW_CXS_PRODUCT_GROUP_D PRODUCT_GROUP_ID
PRODUCT_GROUP_LEVEL_1_TO_TOP NUMBER 38 0 Child Item at denormalized distance 1 DW_CXS_PRODUCT_GROUP_D PRODUCT_GROUP_ID
PRODUCT_GROUP_LEVEL_2_TO_TOP NUMBER 38 0 Child Item at denormalized distance 2 DW_CXS_PRODUCT_GROUP_D PRODUCT_GROUP_ID
PRODUCT_GROUP_LEVEL_3_TO_TOP NUMBER 38 0 Child Item at denormalized distance 3 DW_CXS_PRODUCT_GROUP_D PRODUCT_GROUP_ID
PRODUCT_GROUP_LEVEL_4_TO_TOP NUMBER 38 0 Child Item at denormalized distance 4 DW_CXS_PRODUCT_GROUP_D PRODUCT_GROUP_ID
PRODUCT_GROUP_LEVEL_5_TO_TOP NUMBER 38 0 Child Item at denormalized distance 5 DW_CXS_PRODUCT_GROUP_D PRODUCT_GROUP_ID
PRODUCT_GROUP_LEVEL_6_TO_TOP NUMBER 38 0 Child Item at denormalized distance 6 DW_CXS_PRODUCT_GROUP_D PRODUCT_GROUP_ID
PRODUCT_GROUP_LEVEL_7_TO_TOP NUMBER 38 0 Child Item at denormalized distance 7 DW_CXS_PRODUCT_GROUP_D PRODUCT_GROUP_ID
PRODUCT_GROUP_LEVEL_8_TO_TOP NUMBER 38 0 Child Item at denormalized distance 8 DW_CXS_PRODUCT_GROUP_D PRODUCT_GROUP_ID
PRODUCT_GROUP_LEVEL_9_TO_TOP NUMBER 38 0 Child Item at denormalized distance 9 DW_CXS_PRODUCT_GROUP_D PRODUCT_GROUP_ID
PRODUCT_GROUP_LEVEL_10_TO_TOP NUMBER 38 0 Child Item at denormalized distance 10 DW_CXS_PRODUCT_GROUP_D PRODUCT_GROUP_ID
PRODUCT_GROUP_LEVEL_11_TO_TOP NUMBER 38 0 Child Item at denormalized distance 11 DW_CXS_PRODUCT_GROUP_D PRODUCT_GROUP_ID
PRODUCT_GROUP_LEVEL_12_TO_TOP NUMBER 38 0 Child Item at denormalized distance 12 DW_CXS_PRODUCT_GROUP_D PRODUCT_GROUP_ID
PRODUCT_GROUP_LEVEL_13_TO_TOP NUMBER 38 0 Child Item at denormalized distance 13 DW_CXS_PRODUCT_GROUP_D PRODUCT_GROUP_ID
PRODUCT_GROUP_LEVEL_14_TO_TOP NUMBER 38 0 Child Item at denormalized distance 14 DW_CXS_PRODUCT_GROUP_D PRODUCT_GROUP_ID
RELATIONSHIP_ACTIVE_FLAG VARCHAR2 16 REL_ACTIVE_FLAG 
RELATIONSHIP_START_DATE TIMESTAMP REL_START_DATE
RELATIONSHIP_END_DATE TIMESTAMP REL_END_DATE
CREATED_BY VARCHAR2 128 Who column: indicates the date and time of the creation of the row.
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 128 Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 64 Who column: indicates the session login associated to the user who last updated the row.