Databases > AdventureWorks2019 > Views > HumanResources.vEmployeeDepartment

AdventureWorks2019

HumanResources.vEmployeeDepartment

//

Returns employee name, title, and current department.

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
JobTitle

[nvarchar](50) NOT NULL
Department

[Name] NOT NULL
GroupName

[Name] NOT NULL
StartDate

[date] NOT NULL

Definition

Sample Data

BusinessEntityID

Title

FirstName

MiddleName

LastName

Suffix

JobTitle

Department

GroupName

StartDate

1

NULL

Ken

J

Sánchez

NULL

Chief Executive Officer

Executive

Executive General and Administration

1/13/2009

2

NULL

Terri

Lee

Duffy

NULL

Vice President of Engineering

Engineering

Research and Development

1/30/2008

3

NULL

Roberto

NULL

Tamburello

NULL

Engineering Manager

Engineering

Research and Development

11/10/2007

4

NULL

Rob

NULL

Walters

NULL

Senior Tool Designer

Tool Design

Research and Development

5/30/2010

5

Ms.

Gail

A

Erickson

NULL

Design Engineer

Engineering

Research and Development

1/5/2008

6

Mr.

Jossef

H

Goldberg

NULL

Design Engineer

Engineering

Research and Development

1/23/2008

7

NULL

Dylan

A

Miller

NULL

Research and Development Manager

Research and Development

Research and Development

2/7/2009

8

NULL

Diane

L

Margheim

NULL

Research and Development Engineer

Research and Development

Research and Development

12/28/2008

9

NULL

Gigi

N

Matthew

NULL

Research and Development Engineer

Research and Development

Research and Development

1/15/2009

10

NULL

Michael

NULL

Raheem

NULL

Research and Development Manager

Research and Development

Research and Development

5/2/2009

11

NULL

Ovidiu

V

Cracium

NULL

Senior Tool Designer

Tool Design

Research and Development

12/4/2010

12

NULL

Thierry

B

D'Hers

NULL

Tool Designer

Tool Design

Research and Development

12/10/2007

13

Ms.

Janice

M

Galvin

NULL

Tool Designer

Tool Design

Research and Development

12/22/2010

14

NULL

Michael

I

Sullivan

NULL

Senior Design Engineer

Engineering

Research and Development

12/29/2010

15

NULL

Sharon

B

Salavaria

NULL

Design Engineer

Engineering

Research and Development

1/17/2011

16

NULL

David

M

Bradley

NULL

Marketing Manager

Marketing

Sales and Marketing

7/14/2009

17

NULL

Kevin

F

Brown

NULL

Marketing Assistant

Marketing

Sales and Marketing

1/25/2007

18

NULL

John

L

Wood

NULL

Marketing Specialist

Marketing

Sales and Marketing

2/6/2011

19

NULL

Mary

A

Dempsey

NULL

Marketing Assistant

Marketing

Sales and Marketing

2/13/2011

20

NULL

Wanida

M

Benshoof

NULL

Marketing Assistant

Marketing

Sales and Marketing

1/6/2011

21

NULL

Terry

J

Eminhizer

NULL

Marketing Specialist

Marketing

Sales and Marketing

3/1/2009

22

NULL

Sariya

E

Harnpadoungsataya

NULL

Marketing Specialist

Marketing

Sales and Marketing

12/11/2008

23

NULL

Mary

E

Gibson

NULL

Marketing Specialist

Marketing

Sales and Marketing

1/11/2009

24

Ms.

Jill

A

Williams

NULL

Marketing Specialist

Marketing

Sales and Marketing

1/17/2009

25

NULL

James

R

Hamilton

NULL

Vice President of Production

Production

Manufacturing

2/2/2009