MDWT_AdventureWorksDW.DimEmployee

Metadata hierarchy: MDWT_Adventure_Works_Demo » MDWT_AdventureWorksDW

Attributes in DimEmployee

Column Name	Data Type	Is Key	Short description
EmployeeKey	int		Surrogate primary key
BKEmployeeID	int		Employee ID used in the transaction system
NationalIDNumber	char		National ID Number (eg SSN) for employee
EmployeeIDName	varchar		Employee full name prepended with national ID# (eg SSN)
EmployeeFullName	varchar		Employee full name: last, first middle
EmployeeFirstName	varchar		Employee's first name
EmployeeLastName	varchar		Employee's last name
EmployeeMiddleName	varchar		Employee's middle name
BKManagerID	int		Manager ID used in the transaction system
ManagerFullName	varchar		Manager's full name
ManagerEmail	varchar		Manager's email address
BirthDate	datetime		Employee's birth date
MaritalStatus	char		What is the employee's marital status?
Gender	char		What is the employee's gender?
IsSalaried	char		Is the employee salaried?
IsCurrentEmployee	char		Is this person currently an employee?
IsSalesPerson	char		Is the employee a sales person?
JobTitle	varchar		Employee's job title
DepartmentID	int		Department ID from the source system
Department	varchar		Department
DepartmentGroup	varchar		Department group
BKCurrentSalesTerritoryId	int		Natural key for the employee's current sales territory
CurrentSalesTerritory	varchar		Current sales territory
CurrentSalesTerritoryCountry	varchar		Current sales territory country
CurrentSalesTerritoryGroup	varchar		Current sales territory group
BKHistoricalSalesTerritoryId	int		Natural key for the employee's historical sales territory
HistoricalSalesTerritory	varchar		Historical sales territory
HistoricalSalesTerritoryCountry	varchar		Historical sales territory country
HistoricalSalesTerritoryGroup	varchar		Historical sales territory group
HireDate	datetime		Date employee was hired
EmploymentEndDate	datetime		Date employment ended; 12/31/9999 if a current employee
LoginID	varchar		Employee's login ID
EmployeeEmail	varchar		Employee's email address
EmployeePhone	varchar		Phone number
RowIsCurrent	char		Is this the current row for this member (Y/N)?
RowStartDate	datetime		When did this row become valid for this member?
RowEndDate	datetime		When did this row become invalid? (12/31/9999 if current row)
RowChangeReason	varchar		Why did the row change last?
AuditKey	int		What process loaded this row?

Internal data warehouse auditing attributes

Column Name

Data Type