HumanResources.vEmployeeDepartmentHistory

View: 'HumanResources.vEmployeeDepartmentHistory', Returns employee name and current and previous departments.

Field NameType and Size
EmployeeIDint NOT NULL
Titlenvarchar(8) NULL
FirstNameName NOT NULL
MiddleNameName NULL
LastNameName NOT NULL
Suffixnvarchar(10) NULL
ShiftName NOT NULL
DepartmentName NOT NULL
GroupNameName NOT NULL
StartDatedatetime NOT NULL
EndDatedatetime NULL