Column Flattened Hierarchical information for SR Categories
Module: Service Request Management
LEVEL_0_CATEGORY_ID
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 |
Copyright © 2019, 2024, Oracle and/or its affiliates.