Object type: Data view

Returns employee name and current and previous departments.

Properties 

Transactional	Uses cursors	Executes procedures	Dynamic content	Encrypted
No	No	No	No	No

Data Source Activity 

Accesses	Description
HumanResources.Department	Lookup table containing the departments within the Adventure Works Cycles company.
HumanResources.Employee	Employee information such as salary, department, and title.
HumanResources.EmployeeDepartmentHistory	Employee department transfers.
HumanResources.Shift	Work shift lookup table.
Person.Contact	Names of each employee, customer contact, and vendor contact.

Output Recordset 

Column	Description
EmployeeID
Title
FirstName
MiddleName
LastName
Suffix
Shift
Department
GroupName
StartDate
EndDate

Data source	Description
HumanResources.Department	Lookup table containing the departments within the Adventure Works Cycles company.
HumanResources.Employee	Employee information such as salary, department, and title.
HumanResources.EmployeeDepartmentHistory	Employee department transfers.
HumanResources.Shift	Work shift lookup table.
Person.Contact	Names of each employee, customer contact, and vendor contact.

Applies to

Views

The AdventureWorks database sample was developed by Microsoft Corporation, copyright 2005. SQL Server is a trademark of Microsoft Corporation