HumanResources.JobCandidate (table)
wikibot
| Table | HumanResources.JobCandidate |
| Column | Data Type | Nullable | Default | PK | Index |
| JobCandidateID | int | not null | PK_JobCandidate_JobCandidateID | ||
| EmployeeID | int | null | IX_JobCandidate_EmployeeID | ||
| Resume | xml | null | |||
| ModifiedDate | datetime | not null | (getdate()) |
| Relation | Column | Referenced Column |
| HumanResources.Employee | EmployeeID | EmployeeID |
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 |
| Referenced Object | Object Type | Dependency Type |
| .HumanResources | Schema | Schema |
| HumanResources.HRResumeSchemaCollection | XML Schema Collection | Data Type |
| Referencing Object | Object Type | Reference Type |
| HumanResources.vJobCandidate | View | Select |
| HumanResources.vJobCandidateEducation | View | Select |
| HumanResources.vJobCandidateEmployment | View | Select |
