DimEmployee.DepartmentID

Metadata hierarchy: MDWT_Adventure_Works_Demo » MDWT_AdventureWorksDW » DimEmployee

Attribute DimEmployee.DepartmentID

Property NameValue
CommentsCreate initial history from EmployeeDepartmentHistory
DescriptionDepartment ID from the source system
Display NameDepartmentID
Example Values1, 2, 3
Is Audit Subsystem
SCD Type2
Source Datatypesmallint
Source Field NameDepartmentId
Source SchemaHumanResources
Source SystemAW
Source TableEmployeeDepartmentHistory
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