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. |