DimEmployee.CurrentSalesTerritory

Metadata hierarchy: MDWT_Adventure_Works_Demo » MDWT_AdventureWorksDW » DimEmployee

Attribute DimEmployee.CurrentSalesTerritory

Property NameValue
DescriptionCurrent sales territory
Display NameCurrentSalesTerritory
ETL RulesJoin to Sales.SalesPerson on TerritoryID
Is Audit Subsystem
SCD Type1
Source Datatypenvarchar(50)
Source Field NameName
Source SchemaSales
Source SystemAW
Source TableSalesTerritory
Table Type
Used in schemas
View Name

Also Found In

  • A list tables where this item is also located can be found here.

    • More information about the source and ETL of this column can be found in:

  • Package: DimEmployee