HumanResources.JobCandidate (table)

wikibot

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
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

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