HumanResources.JobCandidate

Object type: Table

Résumés submitted to Human Resources by job applicants.

Columns

Name Data type Nullable Description

JobCandidateID int No Column has identity seed value of 1 with a step value of 1.
Primary key for JobCandidate records.

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

Resume XML(HumanResources.HRResumeSchemaCollection) Yes Résumé in XML format.

ModifiedDate datetime No Default value: GETDATE()
Date and time the record was last updated.

Constraints

Name Type Columns Description

DF_JobCandidate_ModifiedDate DEFAULT ModifiedDate Value: GETDATE()
Default constraint value of GETDATE()

PK_JobCandidate_JobCandidateID PRIMARY KEY JobCandidateID Clustered index created by a primary key constraint.

FK_JobCandidate_Employee_EmployeeID FOREIGN KEY EmployeeID Reference table: HumanResources.Employee
Foreign key constraint referencing Employee.EmployeeID.

Indices

Name Description

IX_JobCandidate_EmployeeID Nonclustered index.

Triggers

Name Description

HumanResources.uJobCandidate AFTER UPDATE trigger setting the ModifiedDate column in the JobCandidat table to the current date.

Accessed by

Name Description

HumanResources.vJobCandidate Job candidate names and resumes.

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.

HumanResources.vJobCandidateEmployment Displays the content from each employement history 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.

Modified by

Name Description

HumanResources.uJobCandidate AFTER UPDATE trigger setting the ModifiedDate column in the JobCandidat table to the current date.

Applies to

Tables | User

Name	Data type	Nullable	Description
JobCandidateID	int	No	Column has identity seed value of 1 with a step value of 1. Primary key for JobCandidate records.
EmployeeID	int	Yes	Employee identification number if applicant was hired. Foreign key to Employee.EmployeeID.
Resume	XML(HumanResources.HRResumeSchemaCollection)	Yes	Résumé in XML format.
ModifiedDate	datetime	No	Default value: GETDATE() Date and time the record was last updated.

Name	Type	Columns	Description
DF_JobCandidate_ModifiedDate	DEFAULT	ModifiedDate	Value: GETDATE() Default constraint value of GETDATE()
PK_JobCandidate_JobCandidateID	PRIMARY KEY	JobCandidateID	Clustered index created by a primary key constraint.
FK_JobCandidate_Employee_EmployeeID	FOREIGN KEY	EmployeeID	Reference table: HumanResources.Employee Foreign key constraint referencing Employee.EmployeeID.

Name	Description
IX_JobCandidate_EmployeeID	Nonclustered index.

Name	Description
HumanResources.uJobCandidate	AFTER UPDATE trigger setting the ModifiedDate column in the JobCandidat table to the current date.

Name	Description
HumanResources.vJobCandidate	Job candidate names and resumes.
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.
HumanResources.vJobCandidateEmployment	Displays the content from each employement history 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.