Resource Manager Denormalized Dimension
Module:
DENORMALIZED_MANAGER_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| DENORMALIZED_MANAGER_ID | NUMBER | 38 | 0 | True | Unique identifier for denorm record | ||
| SOURCE_RECORD_ID | VARCHAR2 | 64 | This column is for Oracle Internal use only. Unique key | ||||
| BASE_RESOURCE_ID | NUMBER | 38 | 0 | Resource Identifier at Base level | DW_CXS_RESOURCE_D | RESOURCE_ID | |
| BASE_ORGANIZATION_ID | NUMBER | 38 | 0 | Organization Identifier for resource at Base level | DW_INTERNAL_ORG_D_TL | ORGANIZATION_ID | |
| BASE_ROLE_CODE | VARCHAR2 | 32 | Role Code for resource at Base level | DW_CXS_SALES_RESOURCE_ROLE_CODE_TL | Code | ||
| LEVEL1_RESOURCE_ID | NUMBER | 38 | 0 | Resource Identifier at LEVEL1 | DW_CXS_RESOURCE_D | RESOURCE_ID | |
| LEVEL1_ORGANIZATION_ID | NUMBER | 38 | 0 | Organization Identifier for resource at LEVEL1 | DW_INTERNAL_ORG_D_TL | ORGANIZATION_ID | |
| LEVEL1_ROLE_CODE | VARCHAR2 | 32 | Role Code for resource at LEVEL1 | DW_CXS_SALES_RESOURCE_ROLE_CODE_TL | Code | ||
| LEVEL2_RESOURCE_ID | NUMBER | 38 | 0 | Resource Identifier at LEVEL2 | DW_CXS_RESOURCE_D | RESOURCE_ID | |
| LEVEL2_ORGANIZATION_ID | NUMBER | 38 | 0 | Organization Identifier for resource at LEVEL2 | DW_INTERNAL_ORG_D_TL | ORGANIZATION_ID | |
| LEVEL2_ROLE_CODE | VARCHAR2 | 32 | Role Code for resource at LEVEL2 | DW_CXS_SALES_RESOURCE_ROLE_CODE_TL | Code | ||
| LEVEL3_RESOURCE_ID | NUMBER | 38 | 0 | Resource Identifier at LEVEL3 | DW_CXS_RESOURCE_D | RESOURCE_ID | |
| LEVEL3_ORGANIZATION_ID | NUMBER | 38 | 0 | Organization Identifier for resource at LEVEL3 | DW_INTERNAL_ORG_D_TL | ORGANIZATION_ID | |
| LEVEL3_ROLE_CODE | VARCHAR2 | 32 | Role Code for resource at LEVEL3 | DW_CXS_SALES_RESOURCE_ROLE_CODE_TL | Code | ||
| LEVEL4_RESOURCE_ID | NUMBER | 38 | 0 | Resource Identifier at LEVEL4 | DW_CXS_RESOURCE_D | RESOURCE_ID | |
| LEVEL4_ORGANIZATION_ID | NUMBER | 38 | 0 | Organization Identifier for resource at LEVEL4 | DW_INTERNAL_ORG_D_TL | ORGANIZATION_ID | |
| LEVEL4_ROLE_CODE | VARCHAR2 | 32 | Role Code for resource at LEVEL4 | DW_CXS_SALES_RESOURCE_ROLE_CODE_TL | Code | ||
| LEVEL5_RESOURCE_ID | NUMBER | 38 | 0 | Resource Identifier at LEVEL5 | DW_CXS_RESOURCE_D | RESOURCE_ID | |
| LEVEL5_ORGANIZATION_ID | NUMBER | 38 | 0 | Organization Identifier for resource at LEVEL5 | DW_INTERNAL_ORG_D_TL | ORGANIZATION_ID | |
| LEVEL5_ROLE_CODE | VARCHAR2 | 32 | Role Code for resource at LEVEL5 | DW_CXS_SALES_RESOURCE_ROLE_CODE_TL | Code | ||
| LEVEL6_RESOURCE_ID | NUMBER | 38 | 0 | Resource Identifier at LEVEL6 | DW_CXS_RESOURCE_D | RESOURCE_ID | |
| LEVEL6_ORGANIZATION_ID | NUMBER | 38 | 0 | Organization Identifier for resource at LEVEL6 | DW_INTERNAL_ORG_D_TL | ORGANIZATION_ID | |
| LEVEL6_ROLE_CODE | VARCHAR2 | 32 | Role Code for resource at LEVEL6 | DW_CXS_SALES_RESOURCE_ROLE_CODE_TL | Code | ||
| LEVEL7_RESOURCE_ID | NUMBER | 38 | 0 | Resource Identifier at LEVEL7 | DW_CXS_RESOURCE_D | RESOURCE_ID | |
| LEVEL7_ORGANIZATION_ID | NUMBER | 38 | 0 | Organization Identifier for resource at LEVEL7 | DW_INTERNAL_ORG_D_TL | ORGANIZATION_ID | |
| LEVEL7_ROLE_CODE | VARCHAR2 | 32 | Role Code for resource at LEVEL7 | DW_CXS_SALES_RESOURCE_ROLE_CODE_TL | Code | ||
| LEVEL8_RESOURCE_ID | NUMBER | 38 | 0 | Resource Identifier at LEVEL8 | DW_CXS_RESOURCE_D | RESOURCE_ID | |
| LEVEL8_ORGANIZATION_ID | NUMBER | 38 | 0 | Organization Identifier for resource at LEVEL8 | DW_INTERNAL_ORG_D_TL | ORGANIZATION_ID | |
| LEVEL8_ROLE_CODE | VARCHAR2 | 32 | Role Code for resource at LEVEL8 | DW_CXS_SALES_RESOURCE_ROLE_CODE_TL | Code | ||
| LEVEL9_RESOURCE_ID | NUMBER | 38 | 0 | Resource Identifier at LEVEL9 | DW_CXS_RESOURCE_D | RESOURCE_ID | |
| LEVEL9_ORGANIZATION_ID | NUMBER | 38 | 0 | Organization Identifier for resource at LEVEL9 | DW_INTERNAL_ORG_D_TL | ORGANIZATION_ID | |
| LEVEL9_ROLE_CODE | VARCHAR2 | 32 | Role Code for resource at LEVEL9 | DW_CXS_SALES_RESOURCE_ROLE_CODE_TL | Code | ||
| LEVEL10_RESOURCE_ID | NUMBER | 38 | 0 | Resource Identifier at LEVEL10 | DW_CXS_RESOURCE_D | RESOURCE_ID | |
| LEVEL10_ORGANIZATION_ID | NUMBER | 38 | 0 | Organization Identifier for resource at LEVEL10 | DW_INTERNAL_ORG_D_TL | ORGANIZATION_ID | |
| LEVEL10_ROLE_CODE | VARCHAR2 | 32 | Role Code for resource at LEVEL10 | DW_CXS_SALES_RESOURCE_ROLE_CODE_TL | Code | ||
| LEVEL11_RESOURCE_ID | NUMBER | 38 | 0 | Resource Identifier at LEVEL11 | DW_CXS_RESOURCE_D | RESOURCE_ID | |
| LEVEL11_ORGANIZATION_ID | NUMBER | 38 | 0 | Organization Identifier for resource at LEVEL11 | DW_INTERNAL_ORG_D_TL | ORGANIZATION_ID | |
| LEVEL11_ROLE_CODE | VARCHAR2 | 32 | Role Code for resource at LEVEL11 | DW_CXS_SALES_RESOURCE_ROLE_CODE_TL | Code | ||
| LEVEL12_RESOURCE_ID | NUMBER | 38 | 0 | Resource Identifier at LEVEL12 | DW_CXS_RESOURCE_D | RESOURCE_ID | |
| LEVEL12_ORGANIZATION_ID | NUMBER | 38 | 0 | Organization Identifier for resource at LEVEL12 | DW_INTERNAL_ORG_D_TL | ORGANIZATION_ID | |
| LEVEL12_ROLE_CODE | VARCHAR2 | 32 | Role Code for resource at LEVEL12 | DW_CXS_SALES_RESOURCE_ROLE_CODE_TL | Code | ||
| LEVEL13_RESOURCE_ID | NUMBER | 38 | 0 | Resource Identifier at LEVEL13 | DW_CXS_RESOURCE_D | RESOURCE_ID | |
| LEVEL13_ORGANIZATION_ID | NUMBER | 38 | 0 | Organization Identifier for resource at LEVEL13 | DW_INTERNAL_ORG_D_TL | ORGANIZATION_ID | |
| LEVEL13_ROLE_CODE | VARCHAR2 | 32 | Role Code for resource at LEVEL13 | DW_CXS_SALES_RESOURCE_ROLE_CODE_TL | Code | ||
| LEVEL14_RESOURCE_ID | NUMBER | 38 | 0 | Resource Identifier at LEVEL14 | DW_CXS_RESOURCE_D | RESOURCE_ID | |
| LEVEL14_ORGANIZATION_ID | NUMBER | 38 | 0 | Organization Identifier for resource at LEVEL14 | DW_INTERNAL_ORG_D_TL | ORGANIZATION_ID | |
| LEVEL14_ROLE_CODE | VARCHAR2 | 32 | Role Code for resource at LEVEL14 | DW_CXS_SALES_RESOURCE_ROLE_CODE_TL | Code | ||
| LEVEL15_RESOURCE_ID | NUMBER | 38 | 0 | Resource Identifier at LEVEL15 | DW_CXS_RESOURCE_D | RESOURCE_ID | |
| LEVEL15_ORGANIZATION_ID | NUMBER | 38 | 0 | Organization Identifier for resource at LEVEL15 | DW_INTERNAL_ORG_D_TL | ORGANIZATION_ID | |
| LEVEL15_ROLE_CODE | VARCHAR2 | 32 | Role Code for resource at LEVEL15 | DW_CXS_SALES_RESOURCE_ROLE_CODE_TL | Code | ||
| LEVEL16_RESOURCE_ID | NUMBER | 38 | 0 | Resource Identifier at LEVEL16 | DW_CXS_RESOURCE_D | RESOURCE_ID | |
| LEVEL16_ORGANIZATION_ID | NUMBER | 38 | 0 | Organization Identifier for resource at LEVEL16 | DW_INTERNAL_ORG_D_TL | ORGANIZATION_ID | |
| LEVEL16_ROLE_CODE | VARCHAR2 | 32 | Role Code for resource at LEVEL16 | DW_CXS_SALES_RESOURCE_ROLE_CODE_TL | Code | ||
| TOP_LEVEL_RESOURCE_ID | NUMBER | 38 | 0 | Resource Identifier at Top Level | DW_CXS_RESOURCE_D | RESOURCE_ID | |
| TOP_LEVEL_ORGANIZATION_ID | NUMBER | 38 | 0 | Organization Identifier for resource at Top Level | DW_INTERNAL_ORG_D_TL | ORGANIZATION_ID | |
| TOP_LEVEL_ROLE_CODE | VARCHAR2 | 32 | Role Code for resource at Top Level | DW_CXS_SALES_RESOURCE_ROLE_CODE_TL | Code | ||
| FIXED_HIERARCHY_LEVEL | NUMBER | 38 | 0 | Fixed level of resource | |||
| CREATED_BY | VARCHAR2 | 128 | Indicates the user who created the row. | ||||
| CREATION_DATE | TIMESTAMP | Indicates the date and time of the creation of the row. | |||||
| CURRENT_FLAG | VARCHAR2 | 16 | Current Flag | ||||
| HIERARCHY_END_DATE | DATE | Hierarchy End Date | |||||
| HIERARCHY_START_DATE | DATE | Hierarchy Start Date |
Copyright © 2019, 2025, Oracle and/or its affiliates.