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.

See Also

Reference

Employee Table (AdventureWorks)

Other Resources

AdventureWorks Data Dictionary

Help and Information

Getting SQL Server 2005 Assistance