Object type: Data view

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.

Properties 

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

Data Source Activity 

Accesses	Description
HumanResources.JobCandidate	Résumés submitted to Human Resources by job applicants.

Output Recordset 

Column	Description
JobCandidateID
Emp.StartDate
Emp.EndDate
Emp.OrgName
Emp.JobTitle
Emp.Responsibility
Emp.FunctionCategory
Emp.IndustryCategory
Emp.Loc.CountryRegion
Emp.Loc.State
Emp.Loc.City

Data source	Description
HumanResources.JobCandidate	Résumés submitted to Human Resources by job applicants.

Applies to

Views

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