Views

Name	Description
HumanResources.vEmployee	Employee names and addresses.
HumanResources.vEmployeeDepartment	Returns employee name, title, and current department.
HumanResources.vEmployeeDepartmentHistory	Returns employee name and current and previous departments.
HumanResources.vJobCandidate	Job candidate names and resumes.
HumanResources.vJobCandidateEducation	Displays the content from each education related element in the xml column Resume in the HumanResources.JobCandidate table. The content has been localized into French, Simplified Chinese and Thai. Some data may not display correctly unless supplemental language support is installed.
HumanResources.vJobCandidateEmployment	Displays the content from each employement history related element in the xml column Resume in the HumanResources.JobCandidate table. The content has been localized into French, Simplified Chinese and Thai. Some data may not display correctly unless supplemental language support is installed.
Person.vAdditionalContactInfo	Displays the contact name and content from each element in the xml column AdditionalContactInfo for that person.
Person.vStateProvinceCountryRegion	Joins StateProvince table with CountryRegion table.
Production.vProductAndDescription	Product names and descriptions. Product descriptions are provided in multiple languages.
Production.vProductModelCatalogDescription	Displays the content from each element in the xml column CatalogDescription for each product in the Production.ProductModel table that has catalog data.
Production.vProductModelInstructions	Displays the content from each element in the xml column Instructions for each product in the Production.ProductModel table that has manufacturing instructions.
Purchasing.vVendorWithAddresses	Vendor (company) names and addresses .
Purchasing.vVendorWithContacts	Vendor (company) names and the names of vendor employees to contact.
Sales.vIndividualCustomer	Individual customers (names and addresses) that purchase Adventure Works Cycles products online.
Sales.vPersonDemographics	Displays the content from each element in the xml column Demographics for each customer in the Person.Person table.
Sales.vSalesPerson	Sales representiatives (names and addresses) and their sales-related information.
Sales.vSalesPersonSalesByFiscalYears	Uses PIVOT to return aggregated sales information for each sales representative.
Sales.vStoreWithAddresses	Stores (including store addresses) that sell Adventure Works Cycles products to consumers.
Sales.vStoreWithContacts	Stores (including store contacts) that sell Adventure Works Cycles products to consumers.
Sales.vStoreWithDemographics	Stores (including demographics) that sell Adventure Works Cycles products to consumers.