SSIS Components for Bullhorn CRM

Build 25.0.9539

Candidate

Represents candidate records that store personal, professional, and placement-related information within Bullhorn CRM. This table supports recruiting workflows by enabling searching, matching, tracking, and qualification management.

Columns

Name Type ReadOnly Description
Id [KEY] Int False

Specifies the unique identifier (Id) for this candidate record. This Id supports system-level referencing by linking the candidate to related job orders, submissions, and workflow activities within the Bullhorn CRM system.

AdditonalskillsResumeparser String False

Captures additional skills that are extracted by the resume parser. This field supports talent evaluation by supplementing the primary skills profile with parser-identified competencies.

AddressAddress String False

Stores the primary street address for the candidate. This field supports contact management by providing a foundational location detail for communication and compliance activities.

AddressAddress2 String False

Stores the secondary street address for the candidate. This field supports accurate mailing and geographic classification by capturing apartment numbers, suites, or other sub-address information.

AddressCity String False

Captures the city portion of the candidate's address. This field supports location-based sourcing, filtering, and reporting by supplying a standardized municipal value.

AddressCountry Int False

Specifies the country Id that is associated with the candidate's address. This field supports geographic normalization by linking the address to the standardized country list in the Bullhorn CRM system.

AddresscountryCode String False

Captures the country code that corresponds to the candidate's address. This field supports international formatting and integrations by providing a code that external systems recognize.

AddresscountryName String False

Stores the full country name that is associated with the candidate's address. This field supports readable geographic context across sourcing, reporting, and compliance workflows.

AddressState String False

Captures the state or provincial value for the candidate's address. This field supports geographic filtering, tax eligibility checks, and regional reporting requirements.

AddressZip String False

Stores the postal or ZIP code for the candidate's address. This field supports matching, proximity searches, and territory assignment by refining the candidate's geographic profile.

Allowcandidatetoeditprofile Bool False

Returns a value of 'true' when the candidate is permitted to edit their online profile. It returns a value of 'false' when self-service profile updates are restricted, which influences candidate engagement and data accuracy workflows.

AuthorizedtoworkintheUS Bool False

Returns a value of 'true' when the candidate is authorized to work in the United States. It returns a value of 'false' when work authorization is not verified, which affects eligibility checks and compliance review steps.

AvailableUntil Datetime False

Specifies the date until which the candidate is available for assignment. This field supports scheduling and sourcing efficiency by indicating when a candidate may require redeployment or follow-up.

Birthday Datetime False

Captures the candidate's date of birth. This field supports verification processes and internal demographic reporting that rely on accurate age-related information.

BranchID Int False

Specifies the branch Id associated with the candidate. This field supports organizational structure by assigning the candidate to the appropriate office, region, or business unit.

CandidateName String False

Stores the candidate's primary name value. This field supports searching, display formatting, and identity verification within Bullhorn CRM workflows.

CandidateName2 String False

Captures an alternate or supplemental name value for the candidate. This field supports data enrichment scenarios where multiple legal or preferred names require storage.

CandidateName3 String False

Captures a tertiary name value that supplements the candidate's primary identity information. This field supports organizations that maintain multiple name variations for compliance or historical tracking.

CandidateName4 String False

Stores an additional candidate-name variation for workflows that require multiple Ids. This field supports organizations with complex identity, compliance, or regional naming requirements.

CandidateName5 String False

Stores a fifth name variation that expands the candidate's identity record. This field supports scenarios where alternative names must be maintained for matching, verification, or historical reference.

CanEnterTime Bool False

Returns a value of 'true' when the candidate is permitted to enter time within the system. It returns a value of 'false' when time entry is restricted, which affects payroll, billing, and compliance workflows.

CategoryId Int False

Specifies the category Id that classifies the candidate. This field supports skill grouping, segmentation, and reporting by linking the candidate to a standardized category structure.

Certifications String False

Stores certification details that are associated with the candidate. This field supports compliance, qualification analysis, and matching by displaying relevant credentials that influence job eligibility.

CurrentCompany String False

Captures the name of the candidate's current employer. This field supports sourcing, competitive intelligence, and screening by providing employment context.

CurrentPayRate String False

Stores the candidate's current pay rate. This field supports compensation analysis, offer preparation, and rate alignment during job matching.

CurrentSalary String False

Captures the candidate's current salary. This field supports role alignment, negotiation planning, and compensation benchmarking workflows.

DateAdded Datetime False

Specifies the date and time when the candidate record was created. This field supports audit processes and time-based reporting by establishing when the candidate entered the system.

DateAvailable Datetime False

Captures the date when the candidate becomes available for new assignments. This field supports sourcing and scheduling workflows by indicating when outreach or placement activities should begin.

DateI9Expiration Datetime False

Stores the expiration date of the candidate's I-9 documentation. This field supports compliance and verification processes by identifying when renewed documentation is required.

DateLastModified Datetime False

Captures the timestamp that is recorded when the candidate record is last updated. This field supports audit tracking by helping users identify when changes occur during recruiting and compliance workflows.

DateNextCall Datetime False

Specifies the scheduled date for the candidate's next follow-up call. This field supports recruiter task planning by establishing a clear timeframe for candidate outreach and engagement.

DayRate String False

Captures the candidate's typical daily compensation rate. This field supports pay comparisons and budgeting by storing rate information that hiring teams reference during offer development.

DayRateLow String False

Captures the lower bound of the candidate's acceptable daily compensation range. This field supports negotiation workflows by documenting minimum rate expectations for contract roles.

Degrees String False

Lists the degrees that the candidate has earned. This field supports qualification evaluation by displaying educational accomplishments that influence fit for specialized roles.

DesiredLocations String False

Captures the geographic areas where the candidate is willing to work. This field supports matching and sourcing by aligning location preferences with job opportunities.

DesiredPayRate String False

Specifies the pay rate that the candidate prefers for contract or hourly assignments. This field supports rate negotiation by establishing compensation expectations early in the hiring process.

DesiredSalary String False

Specifies the salary amount that the candidate prefers for full-time roles. This field supports offer planning by documenting compensation requirements that guide employer discussions.

Disability String False

Captures disability-related information when the candidate provides it voluntarily and in compliance with applicable policy. This field supports internal reporting by allowing organizations to track self-identified data where permitted.

DistancewillingtotravelMiles Int False

Specifies the number of miles that the candidate is willing to travel for a job. This field supports assignment suitability checks by helping recruiters assess commute feasibility.

EducationLevel String False

Captures the candidate's highest completed level of education. This field supports screening workflows by helping users determine eligibility for roles with minimum education requirements.

Email1 String False

Stores the candidate's primary email address. This field supports communication workflows by serving as the main point of electronic contact for interviews, updates, and confirmations.

Email2 String False

Stores the candidate's secondary email address. This field supports redundancy and flexibility by enabling alternate communication options when the primary address is unavailable.

Email3 String False

Stores an additional email address for the candidate. This field supports specialized communication needs by allowing users to maintain multiple contact channels.

EmployeeType String False

Indicates the employment category that applies to the candidate, such as full-time or contract. This field supports classification and reporting by aligning candidate types with staffing models.

EmploymentPreference String False

Captures the types of employment arrangements that the candidate prefers. This field supports sourcing alignment by helping recruiters match candidates to roles that meet their work style and availability expectations.

Ethnicity String False

Captures self-reported ethnicity information in compliance with organizational policy. This field supports internal reporting by allowing organizations to analyze demographic trends within permitted guidelines.

ExternalID String False

Stores an external Id that links the candidate record to another system. This field supports data synchronization by helping organizations align Bullhorn CRM records with third-party platforms.

Fax String False

Stores the candidate's primary fax number. This field supports communication workflows for organizations that use fax-based document exchange.

Fax2 String False

Stores the candidate's secondary fax number. This field supports backup communication channels when multiple fax contacts are maintained.

Fax3 String False

Stores an additional fax number for the candidate. This field supports specialized workflows that require multiple document-receiving endpoints.

FederalAddtionalWitholdingsAmount String False

Captures the candidate's additional federal withholding amount for payroll purposes. This field supports accurate payroll processing by adding supplemental tax information to the compensation profile.

FederalExemptions Int False

Specifies the number of federal tax exemptions that the candidate claims. This field supports payroll calculations by influencing withholding amounts during each pay cycle.

FederalextrawithholdingamountForeachpayperiod String False

Captures the additional federal withholding amount that applies to each pay period. This field supports payroll accuracy by documenting supplemental tax instructions provided by the candidate.

FederalFilingStatus String False

Specifies the candidate's federal tax filing status. This field supports payroll compliance by determining which withholding rules apply during compensation processing.

Gender String False

Captures gender information that the candidate voluntarily provides. This field supports internal reporting within permitted policy guidelines by helping organizations understand demographic composition.

GeneralCandidateComments String False

Stores general comments or notes that relate to the candidate. This field supports recruiter collaboration by capturing contextual information that informs engagement history and next steps.

HomePhone String False

Stores the candidate's primary home phone number. This field supports communication workflows by providing a stable contact method for outreach and scheduling.

I9OnFile Int False

Indicates whether the candidate's Form I-9 documentation is on file. This field supports compliance checks by confirming whether eligibility-verification materials have been submitted.

IsAnonymized Bool False

Indicates whether the candidate record has been anonymized. This field supports privacy compliance by signaling that personal identifiers have been removed or obfuscated according to policy.

IsDaylightSavings Bool False

Indicates whether the candidate's time zone observes daylight saving time. This field supports scheduling accuracy by ensuring that system-generated times align with the candidate's regional time adjustments.

IsExempt Bool False

Indicates whether the candidate is classified as exempt under applicable labor guidelines. This field supports payroll and compliance workflows by clarifying how overtime and pay rules apply.

IsLockedOut Bool False

Indicates whether the candidate is locked out of system access. This field supports security controls by preventing activity from user accounts that have been restricted.

LastNote Datetime False

Captures the timestamp of the most recent note that is associated with the candidate. This field supports activity tracking by helping users understand the recency of recruiter interactions.

LeadTypeId Int False

Stores the Id of the lead type that is linked to the candidate. This field supports classification and pipeline management by associating candidates with specific sourcing categories.

LinkedPersonId Int False

Stores the Id of the related person record that is associated with the candidate. This field supports record unification by linking candidate data to the underlying person profile.

LocalAddtionalWitholdingsAmount String False

Captures additional local tax withholding amounts for the candidate. This field supports payroll processing by incorporating supplemental local tax requirements.

LocalExemptions Int False

Specifies the number of local tax exemptions that the candidate claims. This field supports tax calculation accuracy by adjusting withholding rules at the local level.

LocalFilingStatus String False

Specifies the candidate's local tax filing status. This field supports compliance by determining which local withholding rules apply.

LocalTaxCode String False

Stores the local tax code that applies to the candidate. This field supports payroll accuracy by linking tax calculations to the appropriate jurisdictional rules.

MasterUserID Int False

Stores the Id of the master user who is associated with the candidate. This field supports administrative tracking by identifying ownership or responsibility relationships.

MigrateGUID String False

Stores the unique identifier for the migration object that identifies the candidate record during data transfer or system consolidation. This field supports data-migration workflows by ensuring stable cross-system references.

MobilePhone String False

Stores the candidate's mobile phone number. This field supports communication workflows by enabling fast, direct contact for time-sensitive updates.

Name String False

Captures the primary name value that is associated with the candidate. This field supports identification and communication workflows across screening and hiring processes.

Nickname String False

Stores the candidate's preferred nickname. This field supports personalized communication by allowing recruiters to address candidates according to their stated preferences.

NumberofCategories Int False

Captures the number of categories that are assigned to the candidate. This field supports classification and reporting by quantifying the breadth of candidate categorization.

NumberofOwners Int False

Captures the number of user owners who are assigned to the candidate record. This field supports workflow distribution by identifying how responsibility for the candidate is shared.

OptedOut Bool False

Indicates whether the candidate has opted out of communications. This field supports compliance with communication preferences by restricting outreach when required.

OtherDeductionsAmount String False

Captures other deduction amounts that apply to the candidate during payroll processing. This field supports financial accuracy by documenting deductions that influence net compensation.

OtherIncomeAmount String False

Captures the amount of additional income that the candidate reports outside regular wages. This field supports payroll and financial assessments by recording supplemental earnings that may influence compensation calculations.

OtherPhone String False

Stores an alternate phone number for the candidate. This field supports communication accuracy by providing another method for contacting the individual when primary numbers are unavailable.

OwnershipId Int False

Identifies the ownership record that is linked to the candidate. This field supports organizational configuration by associating the candidate with the appropriate owning user, team, or department.

Pager String False

Stores the candidate's pager number. This field supports legacy communication workflows by retaining contact details that may still be required in specific industries or environments.

PaperWorkOnFile String False

Indicates whether the candidate's required paperwork is on file. This field supports compliance tracking by signaling whether documentation such as onboarding forms or verification records has been submitted.

Password String False

Stores the candidate's system password in encoded form. This field supports secure authentication workflows by retaining credentials that allow candidates to access portal or self-service features.

PersonalURL String False

Stores a personal website link that the candidate provides. This field supports branding and evaluation workflows by giving users access to online portfolios, professional profiles, or similar resources.

PersonSubtype String False

Specifies the subtype classification that further categorizes the candidate's person record. This field supports reporting and workflow routing by distinguishing different candidate types or statuses.

Phone3 String False

Stores a third phone number that is associated with the candidate. This field supports thorough communication tracking by capturing additional contact information beyond primary and secondary numbers.

PreferredContact String False

Specifies the candidate's preferred method of communication. This field supports relationship management by helping users choose the most effective channel for outreach.

RecentEmployers String False

Stores a list of employers that the candidate has worked for recently. This field supports qualification and screening by providing a snapshot of recent work history relevant to job matching.

ReferredbyOther String False

Captures a freeform referral source that indicates how the candidate learned about the organization or job opportunity. This field supports sourcing analytics by documenting external or nonstandard referral paths.

ReferredById Int False

Identifies the record that refers the candidate to the organization. This field supports sourcing and attribution by linking the candidate to the user, contact, or entity responsible for the referral.

Resume String False

Stores the candidate's resume content or a reference to the resume file. This field supports evaluation and submission workflows by making the candidate's professional background readily accessible for review.

SecondaryAddressAddress String False

Stores the street address for the candidate's secondary location. This field supports logistical planning by capturing alternate residential or mailing information.

SecondaryAddressAddress2 String False

Stores the additional address line for the candidate's secondary location. This field supports accurate recordkeeping by retaining extended address details such as apartment or suite numbers.

SecondaryAddressCity String False

Stores the city that is associated with the candidate's secondary address. This field supports geographic filtering and correspondence tasks by identifying an alternate city location.

SecondaryAddressCountry Int False

Identifies the country that is associated with the candidate's secondary address. This field supports location normalization by linking the address to a standardized country identifier.

SecondaryAddresscountryCode String False

Stores the country code for the candidate's secondary address. This field supports geographic validation and integration workflows by retaining a code that corresponds to recognized country formats.

SecondaryAddresscountryName String False

Stores the full country name for the candidate's secondary address. This field supports clarity and reporting by making the country designation human-readable.

SecondaryAddressState String False

Stores the state or provincial designation for the candidate's secondary address. This field supports compliance and routing workflows by identifying the appropriate regional subdivision.

SecondaryAddressZip String False

Specifies the postal or ZIP code that is associated with the candidate's secondary address. This field supports location accuracy by enabling regional searches, compliance validation, and standardized address formatting.

Source String False

Identifies the source from which the candidate originated. This field supports talent acquisition analytics by helping recruiters determine which sourcing channels generate high-quality candidates.

SSN String False

Stores the masked Social Security Number for the candidate. This field supports secure identity verification by providing a controlled reference value that complies with privacy and data-handling requirements.

StateAddtionalWitholdingsAmount String False

Specifies the amount of additional state withholding that applies to the candidate. This field supports payroll accuracy by recording extra withholding amounts that influence net pay calculations.

StateExemptions Int False

Captures the number of state tax exemptions that are claimed by the candidate. This field supports compliance and payroll processing by determining how state tax liabilities are calculated.

StateFilingStatus String False

Specifies the candidate's filing status for state tax purposes. This field supports payroll configuration by aligning state-level tax logic with the candidate's declared tax category.

Status String False

Indicates the candidate's current status within the recruiting lifecycle. This field supports workflow progression by signaling whether the candidate is active, placed, archived, or in another operational state.

TaxID String False

Stores the tax identification number that is associated with the candidate. This field supports payroll, compliance, and reporting workflows by providing a unique reference value for tax-related processing.

TaxState String False

Identifies the state whose tax regulations apply to the candidate. This field supports accurate withholding and payroll configuration by linking candidate compensation to the appropriate jurisdiction.

TimeZoneOffsetEST Int False

Specifies the candidate's time zone offset from Eastern Standard Time. This field supports communication and scheduling accuracy by helping users account for regional time differences when engaging candidates.

Title String False

Captures the professional title or job designation that applies to the candidate. This field supports matching and search workflows by reflecting the candidate's primary area of expertise.

TotalDependentClaimAmount String False

Specifies the total amount of dependent-related claims that the candidate reports. This field supports payroll and tax calculations by providing values that influence withholding formulas.

TravelMethod String False

Specifies the candidate's preferred travel method for assignments or interviews. This field supports logistical planning by helping recruiters coordinate travel arrangements that align with candidate preferences.

Twojobs Bool False

Returns a value of 'true' when the candidate works multiple jobs. It returns a value of 'false' when the candidate does not hold more than one active position.

Type String False

Identifies the candidate type that is applied within the Bullhorn CRM system. This field supports classification, reporting, and workflow routing by distinguishing permanent, contract, or specialized candidate categories.

UserDateAdded Datetime False

Specifies the date and time when the candidate record was added by a system user. This field supports auditing and historical analysis by showing when human-initiated record creation occurred.

Username String False

Captures the username that is associated with the candidate record for system authentication or portal access. This field supports security and usability by linking candidate interactions to a consistent account identity.

UserTypeId Int False

Specifies the user type that is associated with the candidate, if applicable. This field supports permissions and workflow routing by identifying system roles that influence how the candidate interacts with Bullhorn CRM features.

Veteran String False

Indicates the candidate's veteran classification, if it is disclosed. This field supports compliance reporting and diversity tracking by preserving veteran-status information for authorized organizational use.

WillingtoRelocate Bool False

Returns a value of 'true' when the candidate is willing to relocate. It returns a value of 'false' when the candidate prefers to remain in their current geographic area.

WorkPhone String False

Specifies the candidate's primary work phone number. This field supports communication workflows by providing an additional contact method for scheduling and engagement.

YearsExperience Int False

Captures the number of years of professional experience that the candidate reports. This field supports qualification assessment by helping recruiters evaluate seniority and skill depth.

IsDeleted Bool False

Returns a value of 'true' when the candidate record is marked as deleted within the Bullhorn CRM system. It returns a value of 'false' when the record remains active and available for standard processing.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
LuceneQuery String

Specifies a Lucene query that is sent directly to the Bullhorn CRM API. This pseudocolumn supports advanced search workflows by allowing users to bypass standard filters and apply custom query logic when necessary.

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