DW_CXS_SALES_RESOURCE_CF_DN_DH

Resource Manager Denormalized Dimension

Details

Module:

Key Columns

DENORMALIZED_MANAGER_ID

Columns

Columns
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.