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

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

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

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