Object type: Data view

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.

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
Edu.Level
Edu.StartDate
Edu.EndDate
Edu.Degree
Edu.Major
Edu.Minor
Edu.GPA
Edu.GPAScale
Edu.School
Edu.Loc.CountryRegion
Edu.Loc.State
Edu.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