DW_CXS_SALES_TERRITORY_CF_DN_DH

Territory Hierarchy Column Flatten Extract Dimension

Details

Module: Opportunity Management

Key Columns

TERRITORY_HIERARCHY_CF_DN_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
TERRITORY_HIERARCHY_CF_DN_ID NUMBER 38 0 True Marketing Opportunity Sales Territory Hierarchy Column Flatten Extract Id    
SOURCE_RECORD_ID VARCHAR2 64     Source Record Id that is Unique    
BASE_TERRITORY_ID NUMBER 38 0   Identifier of territory at base level    
BASE_TERRITORY_VERSION_ID NUMBER 38 0   Identifier of territory version at base level DW_CXS_SALES_TERRITORY_D TERRITORY_VERSION_ID
CREATED_BY VARCHAR2 64     indicates the user who created the row.    
CREATION_DATE TIMESTAMP       indicates the date and time of the row creation.    
CURRENT_FLAG VARCHAR2 32     Current Flag    
FIXED_HIERARCHY_LEVEL NUMBER 38 0   Fixed Territory Hierarchy Level    
TERRITORY_HIERARCHY_END_DATE TIMESTAMP       Territory Hierarchy End Date    
TERRITORY_HIERARCHY_START_DATE TIMESTAMP       Territory Hierarchy Start Date    
LAST_REFRESH_DATE TIMESTAMP       Last Refresh Date of Territory Hierarchy    
LAST_UPDATE_DATE TIMESTAMP       indicates the date and time of the last update of the row.    
LAST_UPDATE_LOGIN VARCHAR2 32     Indicates the session login associated to the user who last updated the row.    
LAST_UPDATED_BY VARCHAR2 64     Iindicates the user who last updated the row.    
LEVEL1_TERRITORY_ID NUMBER 38 0   Identifier of territory at level 2    
LEVEL1_TERRITORY_VERSION_ID NUMBER 38 0   Identifier of territory version at level 2 DW_CXS_SALES_TERRITORY_D TERRITORY_VERSION_ID
LEVEL2_TERRITORY_ID NUMBER 38 0   Identifier of territory at level 3    
LEVEL2_TERRITORY_VERSION_ID NUMBER 38 0   Identifier of territory version at level 3 DW_CXS_SALES_TERRITORY_D TERRITORY_VERSION_ID
LEVEL3_TERRITORY_ID NUMBER 38 0   Identifier of territory at level 4    
LEVEL3_TERRITORY_VERSION_ID NUMBER 38 0   Identifier of territory version at level 4 DW_CXS_SALES_TERRITORY_D TERRITORY_VERSION_ID
LEVEL4_TERRITORY_ID NUMBER 38 0   Identifier of territory at level 5    
LEVEL4_TERRITORY_VERSION_ID NUMBER 38 0   Identifier of territory version at level 5 DW_CXS_SALES_TERRITORY_D TERRITORY_VERSION_ID
LEVEL5_TERRITORY_ID NUMBER 38 0   Identifier of territory at level 6    
LEVEL5_TERRITORY_VERSION_ID NUMBER 38 0   Identifier of territory version at level 6 DW_CXS_SALES_TERRITORY_D TERRITORY_VERSION_ID
LEVEL6_TERRITORY_ID NUMBER 38 0   Identifier of territory at level 7    
LEVEL6_TERRITORY_VERSION_ID NUMBER 38 0   Identifier of territory version at level 7 DW_CXS_SALES_TERRITORY_D TERRITORY_VERSION_ID
LEVEL7_TERRITORY_ID NUMBER 38 0   Identifier of territory at level 8    
LEVEL7_TERRITORY_VERSION_ID NUMBER 38 0   Identifier of territory version at level 8 DW_CXS_SALES_TERRITORY_D TERRITORY_VERSION_ID
LEVEL8_TERRITORY_ID NUMBER 38 0   Identifier of territory at level 9    
LEVEL8_TERRITORY_VERSION_ID NUMBER 38 0   Identifier of territory version at level 9 DW_CXS_SALES_TERRITORY_D TERRITORY_VERSION_ID
LEVEL9_TERRITORY_ID NUMBER 38 0   Identifier of territory at level 10    
LEVEL9_TERRITORY_VERSION_ID NUMBER 38 0   Identifier of territory version at level 10 DW_CXS_SALES_TERRITORY_D TERRITORY_VERSION_ID
LEVEL10_TERRITORY_ID NUMBER 38 0   Identifier of territory at level 11    
LEVEL10_TERRITORY_VERSION_ID NUMBER 38 0   Identifier of territory version at level 11 DW_CXS_SALES_TERRITORY_D TERRITORY_VERSION_ID
LEVEL11_TERRITORY_ID NUMBER 38 0   Identifier of territory at level 12    
LEVEL11_TERRITORY_VERSION_ID NUMBER 38 0   Identifier of territory version at level 12 DW_CXS_SALES_TERRITORY_D TERRITORY_VERSION_ID
LEVEL12_TERRITORY_ID NUMBER 38 0   Identifier of territory at level 13    
LEVEL12_TERRITORY_VERSION_ID NUMBER 38 0   Identifier of territory version at level 13 DW_CXS_SALES_TERRITORY_D TERRITORY_VERSION_ID
LEVEL13_TERRITORY_ID NUMBER 38 0   Identifier of territory at level 14    
LEVEL13_TERRITORY_VERSION_ID NUMBER 38 0   Identifier of territory version at level 14 DW_CXS_SALES_TERRITORY_D TERRITORY_VERSION_ID
LEVEL14_TERRITORY_ID NUMBER 38 0   Identifier of territory at level 15    
LEVEL14_TERRITORY_VERSION_ID NUMBER 38 0   Identifier of territory version at level 15 DW_CXS_SALES_TERRITORY_D TERRITORY_VERSION_ID
LEVEL15_TERRITORY_ID NUMBER 38 0   Identifier of territory at level 16    
LEVEL15_TERRITORY_VERSION_ID NUMBER 38 0   Identifier of territory version at level 16 DW_CXS_SALES_TERRITORY_D TERRITORY_VERSION_ID
LEVEL16_TERRITORY_ID NUMBER 38 0   Identifier of territory at level 17    
LEVEL16_TERRITORY_VERSION_ID NUMBER 38 0   Identifier of territory version at level 17 DW_CXS_SALES_TERRITORY_D TERRITORY_VERSION_ID
TOP_LEVEL_TERRITORY_ID NUMBER 38 0   Identifier of territory at top level    
TOP_LEVEL_TERRITORY_VERSION_ID NUMBER 38 0   Identifier of territory version at top level DW_CXS_SALES_TERRITORY_D TERRITORY_VERSION_ID

Copyright © 2019, 2023, Oracle and/or its affiliates.