HumanResources.vJobCandidateEducation

View: 'HumanResources.vJobCandidateEducation', 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.

Field Name Type and Size

JobCandidateID int identity NOT NULL

Edu.Level nvarchar(max) NULL

Edu.StartDate datetime NULL

Edu.EndDate datetime NULL

Edu.Degree nvarchar(50) NULL

Edu.Major nvarchar(50) NULL

Edu.Minor nvarchar(50) NULL

Edu.GPA nvarchar(5) NULL

Edu.GPAScale nvarchar(5) NULL

Edu.School nvarchar(100) NULL

Edu.Loc.CountryRegion nvarchar(100) NULL

Edu.Loc.State nvarchar(100) NULL

Edu.Loc.City nvarchar(100) NULL

Field Name	Type and Size
JobCandidateID	int identity NOT NULL
Edu.Level	nvarchar(max) NULL
Edu.StartDate	datetime NULL
Edu.EndDate	datetime NULL
Edu.Degree	nvarchar(50) NULL
Edu.Major	nvarchar(50) NULL
Edu.Minor	nvarchar(50) NULL
Edu.GPA	nvarchar(5) NULL
Edu.GPAScale	nvarchar(5) NULL
Edu.School	nvarchar(100) NULL
Edu.Loc.CountryRegion	nvarchar(100) NULL
Edu.Loc.State	nvarchar(100) NULL
Edu.Loc.City	nvarchar(100) NULL