HumanResources.vJobCandidateEmployment

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 Name	Type and Size
JobCandidateID	int identity NOT NULL
Emp.StartDate	datetime NULL
Emp.EndDate	datetime NULL
Emp.OrgName	nvarchar(100) NULL
Emp.JobTitle	nvarchar(100) NULL
Emp.Responsibility	nvarchar(max) NULL
Emp.FunctionCategory	nvarchar(max) NULL
Emp.IndustryCategory	nvarchar(max) NULL
Emp.Loc.CountryRegion	nvarchar(max) NULL
Emp.Loc.State	nvarchar(max) NULL
Emp.Loc.City	nvarchar(max) NULL