DW_CXSR_CATEGORIES_CF_DH

Column Flattened Hierarchical information for SR Categories

Details

Module: Service Request Management

Key Columns

LEVEL_0_CATEGORY_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
LEVEL_0_CATEGORY_ID NUMBER 38 0 True Base Service Category ID DW_CXSR_CATEGORIES_D_TL CATEGORY_ID
SOURCE_RECORD_ID VARCHAR2 256 This column is for Oracle Internal use only. System
FIXED_HIERARCHY_LEVEL NUMBER 38 0 Fixed Hierarchy Level
LEVEL_1_CATEGORY_ID NUMBER 38 0 Level 1 Service Category ID DW_CXSR_CATEGORIES_D_TL CATEGORY_ID
LEVEL_2_CATEGORY_ID NUMBER 38 0 Level 2 Service Category ID DW_CXSR_CATEGORIES_D_TL CATEGORY_ID
LEVEL_3_CATEGORY_ID NUMBER 38 0 Level 3 Service Category ID DW_CXSR_CATEGORIES_D_TL CATEGORY_ID
LEVEL_4_CATEGORY_ID NUMBER 38 0 Level 4 Service Category ID DW_CXSR_CATEGORIES_D_TL CATEGORY_ID
LEVEL_5_CATEGORY_ID NUMBER 38 0 Level 5 Service Category ID DW_CXSR_CATEGORIES_D_TL CATEGORY_ID
LEVEL_6_CATEGORY_ID NUMBER 38 0 Level 6 Service Category ID DW_CXSR_CATEGORIES_D_TL CATEGORY_ID
LEVEL_7_CATEGORY_ID NUMBER 38 0 Level 7 Service Category ID DW_CXSR_CATEGORIES_D_TL CATEGORY_ID
LEVEL_8_CATEGORY_ID NUMBER 38 0 Level 8 Service Category ID DW_CXSR_CATEGORIES_D_TL CATEGORY_ID
LEVEL_9_CATEGORY_ID NUMBER 38 0 Top Level Service Category ID DW_CXSR_CATEGORIES_D_TL CATEGORY_ID
CREATION_DATE TIMESTAMP Creation Date
LAST_UPDATE_DATE TIMESTAMP Last Updated Date
PATH VARCHAR2 999 Hierarchy traversal Path