HumanResources.vEmployeeDepartment

View: 'HumanResources.vEmployeeDepartment', Returns employee name, title, and current department.

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