Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

Page History: HumanResources JobCandidate (table)

Compare Page Revisions



« Older Revision - Back to Page History - Newer Revision »


Page Revision: 2010/01/09 17:03


wikibot

TableHumanResources.JobCandidate
DescriptionRésumés submitted to Human Resources by job applicants.

ColumnData TypeNullableDefaultDescription / PK / Index
JobCandidateIDintnot null Primary key for JobCandidate records.
PK_JobCandidate_JobCandidateID
EmployeeIDintnull Employee identification number if applicant was hired. Foreign key to Employee.EmployeeID.
IX_JobCandidate_EmployeeID
Resumexmlnull Résumé in XML format.
ModifiedDatedatetimenot null(getdate())Date and time the record was last updated.



RelationColumnReferenced Column
HumanResources.EmployeeEmployeeIDEmployeeID

Dependency TypeObject TypeReferenced Object
Data TypeXML Schema CollectionHumanResources.HRResumeSchemaCollection

Reference TypeObject TypeReferencing Object
SelectViewHumanResources.vJobCandidate
SelectViewHumanResources.vJobCandidateEducation
SelectViewHumanResources.vJobCandidateEmployment

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.