HumanResources JobCandidate (table)

wikibot ¶

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

Columns ¶

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

Primary Key ¶

Primary Key	Columns
PK_JobCandidate_JobCandidateID	JobCandidateID

Indexes ¶

Index	Type	Columns
IX_JobCandidate_EmployeeID		EmployeeID

Foreign Keys ¶

Relation	Column	Referenced Column
HumanResources.Employee	EmployeeID	EmployeeID

References ¶

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

Dependencies ¶

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