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.

Field NameType and Size
JobCandidateIDint identity NOT NULL
Emp.StartDatedatetime NULL
Emp.EndDatedatetime NULL
Emp.OrgNamenvarchar(100) NULL
Emp.JobTitlenvarchar(100) NULL
Emp.Responsibilitynvarchar(max) NULL
Emp.FunctionCategorynvarchar(max) NULL
Emp.IndustryCategorynvarchar(max) NULL
Emp.Loc.CountryRegionnvarchar(max) NULL
Emp.Loc.Statenvarchar(max) NULL
Emp.Loc.Citynvarchar(max) NULL