Share via


JobCandidate Table (AdventureWorks)

Contains résumés submitted to the Human Resources department by job applicants.

JobCandidate Table Definition

The JobCandidate table is contained in the HumanResources schema.

Column

Data type

Nullability

Description

JobCandidateID

int

Not null

Primary key for JobCandidate rows.

EmployeeID

int

null

Employee identification number if applicant was hired. Foreign key to Employee.EmployeeID.

Resume

xml

null

Résumé in XML format. For more information, see About the JobCandidate.Resume xml Column.

ModifiedDate

datetime

Not null

Date and time the row was last updated.