Territory

Global dimensional table for Territory sourced from Align.

Global DDS Field Field Type

Source Data

Connector: Global

Table: territory_gbl_ods__v

dim_global_territory_id__v bigint  
territory_name__v varchar(384) territory_name__v
territory_description__v varchar(3000) territory_description__v
territory_start_date__v date territory_start_date__v
territory_end_date__v date territory_end_date__v
vault_territory_id__v varchar(18) native_id__v
parent_territory_id__v varchar(18) parent_terrtory_id__v
parent_territory_name__v varchar(384) parent_territory_name__v
hierarchy_level__v varchar(1280) hierarchy_level__v
territory_external_id__v varchar(360) territory_external_id__v
start_date__v date start_date__v
end_date__v date end_date__v