HumanResources.JobCandidate (table)

wikibot

Table

HumanResources.JobCandidate

Column	Data Type	Nullable	Default	PK	Index
JobCandidateID	int	not null		PK_JobCandidate_JobCandidateID
EmployeeID	int	null			IX_JobCandidate_EmployeeID
Resume	xml	null
ModifiedDate	datetime	not null	(getdate())

Relation	Column	Referenced Column
HumanResources.Employee	EmployeeID	EmployeeID

automatically generated

Table	HumanResources.JobCandidate
Description	Résumés submitted to Human Resources by job applicants.

Column	Data Type	Nullable	Default	Description / PK / Index
JobCandidateID	int	not null		Primary key for JobCandidate records. PK_JobCandidate_JobCandidateID
EmployeeID	int	null		Employee identification number if applicant was hired. Foreign key to Employee.EmployeeID. IX_JobCandidate_EmployeeID
Resume	XML	null		Résumé in XML format.
ModifiedDate	datetime	not null	(GETDATE())	Date and time the record was last updated.

Relation	Column	Referenced Column
HumanResources.Employee	EmployeeID	EmployeeID

Referenced Object	Object Type	Dependency Type
HumanResources.HRResumeSchemaCollection	XML Schema Collection	Data Type

Referencing Object	Object Type	Reference Type
HumanResources.vJobCandidate	View	Select
HumanResources.vJobCandidateEducation	View	Select
HumanResources.vJobCandidateEmployment	View	Select