Databases > AdventureWorks2019 > Views > HumanResources.vEmployeeDepartmentHistory

AdventureWorks2019

HumanResources.vEmployeeDepartmentHistory

//

Returns employee name and current and previous departments.

Created: 5/8/2023 Modified: 5/8/2023

Columns

BusinessEntityID

[int] NOT NULL
Title

[nvarchar](8) NULL
FirstName

[Name] NOT NULL
MiddleName

[Name] NULL
LastName

[Name] NOT NULL
Suffix

[nvarchar](10) NULL
Shift

[Name] NOT NULL
Department

[Name] NOT NULL
GroupName

[Name] NOT NULL
StartDate

[date] NOT NULL
EndDate

[date] NULL

Definition

Sample Data

BusinessEntityID

Title

FirstName

MiddleName

LastName

Suffix

Shift

Department

GroupName

StartDate

EndDate

1

NULL

Ken

J

Sánchez

NULL

Day

Executive

Executive General and Administration

1/13/2009

NULL

2

NULL

Terri

Lee

Duffy

NULL

Day

Engineering

Research and Development

1/30/2008

NULL

3

NULL

Roberto

NULL

Tamburello

NULL

Day

Engineering

Research and Development

11/10/2007

NULL

4

NULL

Rob

NULL

Walters

NULL

Day

Engineering

Research and Development

12/4/2007 5/29/2010

4

NULL

Rob

NULL

Walters

NULL

Day

Tool Design

Research and Development

5/30/2010

NULL

5

Ms.

Gail

A

Erickson

NULL

Day

Engineering

Research and Development

1/5/2008

NULL

6

Mr.

Jossef

H

Goldberg

NULL

Day

Engineering

Research and Development

1/23/2008

NULL

7

NULL

Dylan

A

Miller

NULL

Day

Research and Development

Research and Development

2/7/2009

NULL

8

NULL

Diane

L

Margheim

NULL

Day

Research and Development

Research and Development

12/28/2008

NULL

9

NULL

Gigi

N

Matthew

NULL

Day

Research and Development

Research and Development

1/15/2009

NULL

10

NULL

Michael

NULL

Raheem

NULL

Day

Research and Development

Research and Development

5/2/2009

NULL

11

NULL

Ovidiu

V

Cracium

NULL

Day

Tool Design

Research and Development

12/4/2010

NULL

12

NULL

Thierry

B

D'Hers

NULL

Day

Tool Design

Research and Development

12/10/2007

NULL

13

Ms.

Janice

M

Galvin

NULL

Day

Tool Design

Research and Development

12/22/2010

NULL

14

NULL

Michael

I

Sullivan

NULL

Day

Engineering

Research and Development

12/29/2010

NULL

15

NULL

Sharon

B

Salavaria

NULL

Day

Engineering

Research and Development

1/17/2011

NULL

16

NULL

David

M

Bradley

NULL

Day

Purchasing

Inventory Management

12/19/2007 7/13/2009

16

NULL

David

M

Bradley

NULL

Day

Marketing

Sales and Marketing

7/14/2009

NULL

17

NULL

Kevin

F

Brown

NULL

Day

Marketing

Sales and Marketing

1/25/2007

NULL

18

NULL

John

L

Wood

NULL

Day

Marketing

Sales and Marketing

2/6/2011

NULL

19

NULL

Mary

A

Dempsey

NULL

Day

Marketing

Sales and Marketing

2/13/2011

NULL

20

NULL

Wanida

M

Benshoof

NULL

Day

Marketing

Sales and Marketing

1/6/2011

NULL

21

NULL

Terry

J

Eminhizer

NULL

Day

Marketing

Sales and Marketing

3/1/2009

NULL

22

NULL

Sariya

E

Harnpadoungsataya

NULL

Day

Marketing

Sales and Marketing

12/11/2008

NULL

23

NULL

Mary

E

Gibson

NULL

Day

Marketing

Sales and Marketing

1/11/2009

NULL