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/02/11 09:05


wikibot

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

Columns

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

Primary Key

Primary KeyColumns
PK_JobCandidate_JobCandidateIDJobCandidateID

Indexes

IndexTypeColumns
IX_JobCandidate_EmployeeID EmployeeID

Foreign Keys

RelationColumnReferenced Column
HumanResources.EmployeeEmployeeIDEmployeeID

References

Dependency TypeObject TypeReferenced Object
SchemaSchemaHumanResources
Data TypeXML Schema CollectionHumanResources.HRResumeSchemaCollection

Dependencies

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

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