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 | 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, 2023, Oracle and/or its affiliates.