DW_CXS_SALES_TERRITORY_CF_DN_DH

Territory Hierarchy Column Flatten Extract Dimension

Details

Module:

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 This column is for Oracle Internal use only. 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