Generated using SQL Data Dictionary demo version.

View 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.

Column Data Type Nullable
JobCandidateID int
Emp.StartDate datetime X
Emp.EndDate datetime X
Emp.OrgName nvarchar(100) X
Emp.JobTitle nvarchar(100) X
Emp.Responsibility nvarchar(max) X
Emp.FunctionCategory nvarchar(max) X
Emp.IndustryCategory nvarchar(max) X
Emp.Loc.CountryRegion nvarchar(max) X
Emp.Loc.State nvarchar(max) X
Emp.Loc.City nvarchar(max) X