ODBC Driver for Bullhorn CRM

Build 25.0.9539

CandidateWorkHistory

Captures past employment details that are associated with candidate profiles. This table supports qualification assessments by storing work experience that influences matching, vetting, and placement workflows.

Columns

Name Type ReadOnly Description
Id [KEY] Int False

Represents the unique identifier (Id) for the CandidateWorkHistory record. This field allows Bullhorn CRM to retrieve, update, and organize specific employment history entries for each candidate.

Bonus Double False

Specifies the bonus amount that is associated with the candidate's employment for this record. This field supports compensation analysis and helps Bullhorn CRM users assess total earnings for prior roles.

CandidateId Int False

Specifies the candidate Id that is linked to the work history entry. This field ensures that Bullhorn CRM associates the employment record with the correct candidate profile.

ClientCorporationId Int False

Captures the client corporation Id for the employer that is associated with the work history record. This field supports organization-based reporting and enables Bullhorn CRM to connect employment history to specific client companies.

Comments String False

Captures comments or notes related to the candidate's employment history. This field provides context that Bullhorn CRM users review during screening, evaluation, and hiring decisions.

Commission Double False

Specifies the commission amount that the candidate earned during the recorded employment period. This field helps Bullhorn CRM users evaluate total compensation structures and financial performance.

CompanyName String False

Captures the name of the company where the candidate worked. This field supports employment verification and helps Bullhorn CRM present clear historical work information.

DateAdded Datetime False

Captures the date and time when the work history entry is created. This field supports chronological tracking and allows Bullhorn CRM to maintain accurate employment timelines.

EndDate Datetime False

Specifies the end date of the candidate's employment for this role. This field helps Bullhorn CRM calculate tenure and determine whether the role is current or historical.

IsLastJob Bool False

Returns a value of 'true' when the recorded position is the candidate's most recent job. It returns a value of 'false' when the entry represents an earlier employment period in the candidate's history.

JobPostingId Int False

Specifies the job posting Id that is associated with the work history entry. This field supports traceability by linking past roles to job submissions or placement workflows within Bullhorn CRM.

MigrateGUID String False

Stores the unique identifier for the migration object that is associated with the work history record. This field assists Bullhorn CRM in tracking imported data from external systems during conversions or integrations.

PlacementId Int False

Specifies the placement Id that is related to this employment period. This field helps Bullhorn CRM correlate work history with placement activity and performance metrics.

SalaryHigh String False

Captures the upper range of the candidate's salary for the recorded role. This field supports compensation benchmarking and assists Bullhorn CRM users in evaluating earning potential.

SalaryLow String False

Captures the lower range of the candidate's salary for the recorded role. This field provides context for salary progression and compensation comparisons within Bullhorn CRM.

SalaryType String False

Specifies the salary type for the role (for example, 'hourly' or 'annual'). This field helps Bullhorn CRM apply appropriate compensation logic and supports consistent reporting across records.

StartDate Datetime False

Specifies the start date of the candidate's employment for this role. This field supports tenure calculations and ensures that Bullhorn CRM can accurately represent the candidate's work history timeline.

TerminationReason String False

Captures the reason for the candidate's employment termination, when it is available. This field provides important context that Bullhorn CRM users review during screening and recruiter evaluation processes.

Title String False

Represents the job title that the candidate held during this employment period. This field supports experience-level assessment and helps Bullhorn CRM align candidates to appropriate roles.

IsDeleted Bool False

Returns a value of 'true' when the work history entry is marked as deleted within Bullhorn CRM. It returns a value of 'false' when the record remains active and is available for evaluation and reporting.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 25.0.9539