Object type: Data view

Employee names and addresses.

Properties 

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

Data Source Activity 

Accesses	Description
HumanResources.Employee	Employee information such as salary, department, and title.
HumanResources.EmployeeAddress	Cross-reference table mapping employees to their address(es).
Person.Address	Street address information for customers, employees, and vendors.
Person.Contact	Names of each employee, customer contact, and vendor contact.
Person.CountryRegion	Lookup table containing the ISO standard codes for countries and regions.
Person.StateProvince	State and province lookup table.

Output Recordset 

Column	Description
EmployeeID
Title
FirstName
MiddleName
LastName
Suffix
JobTitle
Phone
EmailAddress
EmailPromotion
AddressLine1
AddressLine2
City
StateProvinceName
PostalCode
CountryRegionName
AdditionalContactInfo

Data source	Description
HumanResources.Employee	Employee information such as salary, department, and title.
HumanResources.EmployeeAddress	Cross-reference table mapping employees to their address(es).
Person.Address	Street address information for customers, employees, and vendors.
Person.Contact	Names of each employee, customer contact, and vendor contact.
Person.CountryRegion	Lookup table containing the ISO standard codes for countries and regions.
Person.StateProvince	State and province lookup table.

Applies to

Views

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