DW_CXSR_CATEGORIES_CF_DH

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     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 4000     Path