JDBC Driver for Bullhorn CRM

Build 25.0.9539

Person

Represents person records that store profile attributes for individuals involved in Bullhorn CRM workflows. This table supports entity linking and profile management by centralizing information that can be reused across candidates, client contacts, and other record types.

Columns

Name Type ReadOnly Description
Id [KEY] Int False

Represents the identifier (Id) that uniquely identifies each record that is stored in the Person table. This value enables internal workflows, integrations, and reporting to reference the correct person entry.

Addressaddress1 String False

Specifies the first address line that is associated with the Person table. This value is used when generating correspondence, location records, and formatted address outputs.

Addressaddress2 String False

Specifies the second address line that is associated with the Person table. This value provides additional address detail that is required for delivery, mailing, and regulatory verification processes.

Addresscity String False

Specifies the city portion of the address that is stored for a record in the Person table. This value supports mapping, filtering, territory assignments, and geolocation logic.

AddresscountryCode String False

Indicates the country code that is recorded for the address in the Person table. This value is used by integrations and validation rules that enforce international formatting requirements.

AddresscountryID Int False

Represents the country Id that corresponds to the address stored in the Person table. This value links the person's address to standardized country metadata for reporting and compliance.

AddresscountryName String False

Captures the full country name that is assigned to the person's address in the Person table. This value improves readability in UI displays, mailers, and exported forms.

Addressstate String False

Specifies the state or provincial value that is included in the person's address in the Person table. This value supports region-based routing, assignment logic, and filtering.

Addresszip String False

Specifies the ZIP or postal code that is associated with the person's address in the Person table. This value is used for territory calculations, tax determinations, and proximity-based business rules.

BranchId Int False

Represents the branch Id that is linked to the record in the Person table. This value associates the person with a specific organizational branch for permissions, routing, and reporting.

CompanyName String False

Captures the company name that is stored for the record in the Person table. This value is used when the person serves as a contact, lead, or associated business representative.

DateLastContacted Datetime False

Indicates the datetime when the person was last contacted as recorded in the Person table. This value supports activity tracking, engagement frequency reporting, and follow-up logic.

Email String False

Specifies the primary email address that is associated with the record in the Person table. This value is used for communication workflows, notifications, and identity verification.

Email2 String False

Specifies the secondary email address that is recorded for the Person table. This value provides an alternate communication channel for outreach, notifications, and recovery processes.

Email3 String False

Specifies the tertiary email address that is associated with the Person table. This value supports cases where multiple business or personal email addresses must be maintained.

Fax String False

Captures the primary fax number that is stored for a record in the Person table. This value is used in workflows that continue to support fax-based document exchange.

Fax2 String False

Captures the secondary fax number that is associated with the record in the Person table. This value supports organizations that maintain multiple department or regional fax lines.

Fax3 String False

Captures the tertiary fax number that is recorded for the Person table. This value preserves additional communication channels that may be required for legacy or departmental operations.

FirstName String False

Specifies the first name that is stored in the Person table. This value appears in all user-facing displays, integrations, and search operations.

IsAnonymized Bool False

Returns a value of 'true' when the person's record is anonymized in the Person table. It returns a value of 'false' when the record remains fully identifiable for reporting and operational use.

IsDayLightSavings Bool False

Returns a value of 'true' when the person's profile indicates that daylight savings rules apply. It returns a value of 'false' when the profile operates under a non-Daylight Savings schedule.

IsLockedOut Bool False

Returns a value of 'true' when the person's account is locked out due to authentication or security policy enforcement. It returns a value of 'false' when the account is permitted to authenticate normally.

LastName String False

Specifies the last name that is stored for the record in the Person table. This value is used for sorting, identity validation, and all name-formatting logic.

MassMailOptOut Bool False

Returns a value of 'true' when the person opts out of mass email communications in the Person table. It returns a value of 'false' when the person remains eligible to receive mass-distributed messages.

MasterUserID Int False

Identifies the master user Id that is linked to the record in the Person table. This value establishes hierarchical relationships for permissions, ownership, and account lineage.

MiddleName String False

Specifies the middle name that is recorded for a person in the Person table. This value contributes to full-name formatting, identity matching, and legal documentation.

Mobile String False

Captures the mobile phone number that is associated with the Person table. This value supports SMS workflows, mobile contact, and authentication processes that use mobile numbers for verification.

Name String False

Provides the full name that is constructed or stored for the record in the Person table. This value is displayed in UI components, search results, and external integrations that require a formatted name.

NamePrefix String False

Captures the prefix or title that is associated with the record in the Person table. This value supports culturally correct name formatting and formal communication.

NameSuffix String False

Captures the suffix that is applied to the record in the Person table. This value is used for legal documents, identity disambiguation, and display formatting.

NickName String False

Specifies the nickname that is stored for the person in the Person table. This value supports informal communication preferences and improves identity recognition for users.

Occupation String False

Captures the occupation or professional role that is recorded in the Person table. This value supports analytics, categorization, and workflow segmentation.

Pager String False

Stores the pager number that is associated with the Person table. This value supports legacy communication workflows in industries where pagers remain in use.

Phone String False

Captures the primary phone number that is stored in the Person table. This value supports call workflows, contact routing, and identity verification.

Phone2 String False

Captures the secondary phone number that is associated with the Person table. This value provides additional contact options for operational and communication needs.

Phone3 String False

Captures the tertiary phone number that is recorded for the Person table. This value supports organizations that manage multiple contact channels for a single person.

Status String False

Indicates the status that is assigned to the record in the Person table. This value influences visibility, access controls, workflow routing, and reporting.

TimeZoneOffsetEST Int False

Represents the Eastern Standard Time (EST) zone offset that is stored for the record in the Person table. This value supports scheduling, timestamp conversions, and system time alignment.

Type String False

Specifies the type classification that is assigned to the record in the Person table. This value determines how the person is treated across workflows, permissions, and categorization.

UserDateAdded Datetime False

Captures the datetime when the person's profile is added to the system and stored in the Person table. This value supports auditing, activity tracking, and profile lifecycle management.

Username String False

Specifies the username that is assigned to the record in the Person table. This value is used for authentication, identity resolution, and user-account linkage.

UserTypeId Int False

Identifies the user type Id that is associated with the record in the Person table. This value determines permission groupings, access rights, and functional capabilities.

IsDeleted Bool False

Returns a value of 'true' when the record in the Person table is marked as deleted. It returns a value of 'false' when the record remains active for operational use.

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