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 |