AdventureWorks2019
HumanResources.vEmployee
//
Employee names and addresses.
Created: Modified:
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
-
PhoneNumber[Phone] NULL
-
PhoneNumberType[Name] NULL
-
EmailAddress[nvarchar](50) NULL
-
EmailPromotion[int] NOT NULL
-
AddressLine1[nvarchar](60) NOT NULL
-
AddressLine2[nvarchar](60) NULL
-
City[nvarchar](30) NOT NULL
-
StateProvinceName[Name] NOT NULL
-
PostalCode[nvarchar](15) NOT NULL
-
CountryRegionName[Name] NOT NULL
-
AdditionalContactInfo[xml] NULL
Definition
Sample Data
BusinessEntityID
Title
FirstName
MiddleName
LastName
Suffix
JobTitle
PhoneNumber
PhoneNumberType
EmailAddress
EmailPromotion
AddressLine1
AddressLine2
City
StateProvinceName
PostalCode
CountryRegionName
AdditionalContactInfo
1
NULL
Ken
J
Sánchez
NULL
Chief Executive Officer
697-555-0142
Cell
ken0@adventure-works.com
NULL
4350 Minute Dr.
NULL
Newport Hills
Washington
98006
United States
[xml]
2
NULL
Terri
Lee
Duffy
NULL
Vice President of Engineering
819-555-0175
Work
terri0@adventure-works.com
1
7559 Worth Ct.
NULL
Renton
Washington
98055
United States
[xml]
3
NULL
Roberto
NULL
Tamburello
NULL
Engineering Manager
212-555-0187
Cell
roberto0@adventure-works.com
NULL
2137 Birchwood Dr
NULL
Redmond
Washington
98052
United States
[xml]
4
NULL
Rob
NULL
Walters
NULL
Senior Tool Designer
612-555-0100
Cell
rob0@adventure-works.com
NULL
5678 Lakeview Blvd.
NULL
Minneapolis
Minnesota
55402
United States
[xml]
5
Ms.
Gail
A
Erickson
NULL
Design Engineer
849-555-0139
Cell
gail0@adventure-works.com
NULL
9435 Breck Court
NULL
Bellevue
Washington
98004
United States
[xml]
6
Mr.
Jossef
H
Goldberg
NULL
Design Engineer
122-555-0189
Work
jossef0@adventure-works.com
NULL
5670 Bel Air Dr.
NULL
Renton
Washington
98055
United States
[xml]
7
NULL
Dylan
A
Miller
NULL
Research and Development Manager
181-555-0156
Work
dylan0@adventure-works.com
2
7048 Laurel
NULL
Kenmore
Washington
98028
United States
[xml]
8
NULL
Diane
L
Margheim
NULL
Research and Development Engineer
815-555-0138
Cell
diane1@adventure-works.com
NULL
475 Santa Maria
NULL
Everett
Washington
98201
United States
[xml]
9
NULL
Gigi
N
Matthew
NULL
Research and Development Engineer
185-555-0186
Cell
gigi0@adventure-works.com
NULL
7808 Brown St.
NULL
Bellevue
Washington
98004
United States
[xml]
10
NULL
Michael
NULL
Raheem
NULL
Research and Development Manager
330-555-2568
Work
michael6@adventure-works.com
2
1234 Seaside Way
NULL
San Francisco
California
94109
United States
[xml]
11
NULL
Ovidiu
V
Cracium
NULL
Senior Tool Designer
719-555-0181
Cell
ovidiu0@adventure-works.com
NULL
5458 Gladstone Drive
NULL
Kenmore
Washington
98028
United States
[xml]
12
NULL
Thierry
B
D'Hers
NULL
Tool Designer
168-555-0183
Work
thierry0@adventure-works.com
2
1970 Napa Ct.
NULL
Bothell
Washington
98011
United States
[xml]
13
Ms.
Janice
M
Galvin
NULL
Tool Designer
473-555-0117
Work
janice0@adventure-works.com
2
3397 Rancho View Drive
NULL
Redmond
Washington
98052
United States
[xml]
14
NULL
Michael
I
Sullivan
NULL
Senior Design Engineer
465-555-0156
Cell
michael8@adventure-works.com
2
6510 Hacienda Drive
NULL
Renton
Washington
98055
United States
[xml]
15
NULL
Sharon
B
Salavaria
NULL
Design Engineer
970-555-0138
Cell
sharon0@adventure-works.com
2
7165 Brock Lane
NULL
Renton
Washington
98055
United States
[xml]
16
NULL
David
M
Bradley
NULL
Marketing Manager
913-555-0172
Work
david0@adventure-works.com
1
3768 Door Way
NULL
Redmond
Washington
98052
United States
[xml]
17
NULL
Kevin
F
Brown
NULL
Marketing Assistant
150-555-0189
Cell
kevin0@adventure-works.com
2
7883 Missing Canyon Court
NULL
Everett
Washington
98201
United States
[xml]
18
NULL
John
L
Wood
NULL
Marketing Specialist
486-555-0150
Work
john5@adventure-works.com
2
9906 Oak Grove Road
NULL
Redmond
Washington
98052
United States
[xml]
19
NULL
Mary
A
Dempsey
NULL
Marketing Assistant
124-555-0114
Cell
mary2@adventure-works.com
1
6307 Greenbelt Way
NULL
Bellevue
Washington
98004
United States
[xml]
20
NULL
Wanida
M
Benshoof
NULL
Marketing Assistant
708-555-0141
Work
wanida0@adventure-works.com
2
6951 Harmony Way
NULL
Sammamish
Washington
98074
United States
[xml]
21
NULL
Terry
J
Eminhizer
NULL
Marketing Specialist
138-555-0118
Cell
terry0@adventure-works.com
2
8668 Via Neruda
NULL
Bellevue
Washington
98004
United States
[xml]
22
NULL
Sariya
E
Harnpadoungsataya
NULL
Marketing Specialist
399-555-0176
Work
sariya0@adventure-works.com
NULL
1185 Dallas Drive
NULL
Everett
Washington
98201
United States
[xml]
23
NULL
Mary
E
Gibson
NULL
Marketing Specialist
531-555-0183
Work
mary0@adventure-works.com
NULL
3928 San Francisco
NULL
Everett
Washington
98201
United States
[xml]
24
Ms.
Jill
A
Williams
NULL
Marketing Specialist
510-555-0121
Work
jill0@adventure-works.com
NULL
3238 Laguna Circle
NULL
Everett
Washington
98201
United States
[xml]
25
NULL
James
R
Hamilton
NULL
Vice President of Production
870-555-0122
Work
james1@adventure-works.com
NULL
9652 Los Angeles
NULL
Monroe
Washington
98272
United States
[xml]