SSIS Components for Bullhorn CRM

Build 25.0.9539

ClientContact2

Represents a supplemental contact configuration for individuals who are linked to client corporations. This table supports enhanced customer relationship management (CRM) processes by enabling the system to store additional relational or demographic details.

Columns

Name Type ReadOnly Description
Id [KEY] Int False

Represents the unique identifier (Id) for the ClientContact2 record. This field allows Bullhorn CRM to retrieve, manage, and distinguish contact entries within this alternate or specialized contact structure.

AdditionalSkills String False

Captures the supplemental skills that are associated with the client contact. This field enhances search accuracy by allowing Bullhorn CRM users to identify contacts with niche expertise or value-added competencies.

AddressAddress String False

Captures the primary street address of the client contact. This field supports correspondence, mapping, and region-based workflows that rely on precise address information within Bullhorn CRM.

AddressAddress2 String False

Captures the secondary street address line for the client contact. This field provides extended address detail that is essential for organizations with complex or multi-line address formatting.

AddressCity String False

Specifies the city associated with the contact's address. This field supports geographic filtering, territory management, and regional analysis in Bullhorn CRM.

AddressCountry Int False

Specifies the country Id linked to the contact's address. This field supports international communication, localization behavior, and global business operations within Bullhorn CRM.

AddresscountryCode String False

Specifies the standardized country code for the contact's address. This field ensures consistent international formatting and helps Bullhorn CRM users communicate across borders effectively.

AddresscountryName String False

Captures the full country name for the contact's address. This field improves readability and provides clear geographic context for users viewing client contact profiles.

AddressState String False

Specifies the state or province associated with the contact's address. This field supports territory-based segmentation, compliance workflows, and geographic organization in Bullhorn CRM.

AddressZip String False

Captures the postal or ZIP code for the contact's address. This field supports proximity-based workflows, regional grouping, and address standardization within Bullhorn CRM.

BranchID Int False

Specifies the branch Id that is associated with the client contact. This field enables Bullhorn CRM to categorize contacts by internal office hierarchy or regional structure.

CategoryId Int False

Specifies the category Id that classifies the client contact. This field helps Bullhorn CRM group contacts based on business type, skill relevance, or industry classification.

Certifications String False

Captures the certifications that are associated with the client contact. This field helps Bullhorn CRM users identify contacts who hold specialized credentials or regulatory qualifications.

ClientContactID Int False

Specifies the legacy or external contact Id tied to this record. This field supports migration scenarios and helps Bullhorn CRM maintain continuity with prior systems.

CompanyId Int False

Specifies the company Id that is associated with the client contact. This field links the contact to a specific client corporation and supports account-based workflows in Bullhorn CRM.

CompanyName String False

Captures the name of the company associated with the contact. This field provides organizational context and helps users understand the contact's business environment.

ContactName String False

Represents the primary display name for the client contact. This field enables clear identification during searches, communication, and record navigation within Bullhorn CRM.

ContactName2 String False

Captures the secondary name or alternate naming format for the client contact. This field supports multilingual naming, alias usage, or custom identification conventions.

ContactName3 String False

Captures a tertiary name value for the client contact. This field enhances identification flexibility within Bullhorn CRM, especially in organizations with complex naming structures.

ContactName4 String False

Captures a fourth naming variation for the client contact. This field supports extended naming conventions and helps distinguish contact records in multi-entity organizations.

ContactName5 String False

Captures a fifth naming variation for the client contact. This field allows Bullhorn CRM to store additional identifiers used in complex organizational or cultural naming patterns.

ContactOwnerId Int False

Specifies the owner Id that is associated with the client contact. This field determines responsibility and access permissions within Bullhorn CRM engagement workflows.

DateAdded Datetime False

Captures the date and time when the client contact record is created. This field supports chronological tracking, auditing, and workflow-based automation.

DateLastModified Datetime False

Captures the date and time when the client contact record is last updated. This field helps Bullhorn CRM users monitor data freshness and maintain accurate, up-to-date records.

DeleteMe String False

Stores placeholder or deprecated system values retained for compatibility. This field enables Bullhorn CRM to preserve legacy data structures during transitions or migrations.

DesiredCategories String False

Captures the preferred categories or areas of interest for the client contact. This field helps Bullhorn CRM support targeted engagement and opportunity-matching workflows.

DesiredLocations String False

Captures the geographic regions that the contact prefers or focuses on. This field assists users in tailoring communication and engagement strategies based on regional interest.

DesiredSkills String False

Captures the skills that the client contact desires or prioritizes. This field helps Bullhorn CRM align candidate capabilities with client needs during matching workflows.

DesiredSpecialties String False

Captures the specialty areas that the client contact prefers. This field supports niche matching and allows Bullhorn CRM to refine engagement based on specialized requirements.

Division String False

Specifies the internal division associated with the contact. This field helps Bullhorn CRM organize contacts according to organizational structure and departmental alignment.

Email String False

Specifies the primary email address of the client contact. This field supports communication workflows including outreach, scheduling, and automated notifications.

Email2 String False

Captures the secondary email address for the client contact. This field ensures communication continuity by providing an alternate email channel when the primary address is unavailable.

Email3 String False

Captures a tertiary email address for the client contact. This field supports organizations that maintain multiple email identities across departments or roles.

ExternalID String False

Captures the external Id associated with the client contact. This field supports data synchronization by allowing Bullhorn CRM to map records across external systems.

Fax String False

Captures the primary fax number for the client contact. This field supports industries or workflows where fax communication remains part of standard business practice.

Fax2 String False

Captures a secondary fax number for the client contact. This field provides additional communication options for organizations with multiple fax-enabled locations.

Fax3 String False

Captures a tertiary fax number for the client contact. This field enhances flexibility for businesses that maintain several fax lines across departments or remote offices.

GeneralContactComments String False

Captures general comments or notes about the client contact. This field provides historical context that helps Bullhorn CRM users strengthen client relationships.

IsAnonymized Bool False

Returns a value of 'true' when the client contact record is anonymized. It returns a value of 'false' when the record retains identifiable personal information and remains available for standard workflows.

IsDaylightSavings Bool False

Returns a value of 'true' when the contact's location is observing daylight savings time. It returns a value of 'false' when standard time is in effect, ensuring accurate scheduling and time-based automation in Bullhorn CRM.

IsDefaultContact Bool False

Returns a value of 'true' when the contact is designated as the primary communication point for the associated client. It returns a value of 'false' when another contact holds the primary responsibility.

IsLockedOut Bool False

Returns a value of 'true' when the contact's associated account is locked. It returns a value of 'false' when the contact can successfully authenticate into connected systems where applicable.

LastNote Datetime False

Captures the date and time when the most recent note is recorded for the contact. This field helps Bullhorn CRM users assess the recency and frequency of engagement.

LastVisit Datetime False

Captures the date and time when the contact is last visited or directly engaged. This field supports client relationship tracking and helps identify inactive accounts.

LinkedPersonId Int False

Specifies the person Id that is linked to the client contact. This field helps Bullhorn CRM associate the record with related personal identities or merged profile structures across the platform.

MasterUserID Int False

Specifies the master user Id that is associated with the contact. This field supports administrative mapping where multiple records correspond to a primary controlling user within Bullhorn CRM.

MigrateGUID String False

Stores the unique identifier for the migration object that is associated with the contact record. This field assists Bullhorn CRM in tracing imported or synchronized data that originates from external systems.

Mobile String False

Captures the mobile phone number of the client contact. This field supports mobile-first communication strategies, including text messaging and quick outbound contact in Bullhorn CRM.

Name String False

Specifies the full name of the client contact. This field is prominently displayed throughout Bullhorn CRM and supports clear identification during communication and search workflows.

NickName String False

Captures the preferred nickname for the contact. This field supports personalized communication and allows Bullhorn CRM users to address the contact according to their preferences.

NumberofEmployees Int False

Captures the number of employees that are associated with the contact's organization or department. This field supports account profiling, segmentation, and strategic planning in Bullhorn CRM.

Office String False

Specifies the office where the contact works. This field helps Bullhorn CRM users understand organizational placement and route communications appropriately.

OptedOut Bool False

Returns a value of 'true' when the contact has opted out of receiving communications. It returns a value of 'false' when the contact is eligible for outreach, ensuring compliance with communication preferences.

Pager String False

Captures the pager number for the client contact. This field supports industries and workflows where pager communication remains an operational requirement.

Password String False

Stores the password that is associated with the contact's user account in connected Bullhorn CRM systems. This field supports authentication processes and is typically restricted to secure administrative handling.

PersonSubtype String False

Specifies the subtype classification of the client contact. This field supports segmentation by role, functional category, or organizational structure within Bullhorn CRM.

Phone String False

Captures the primary phone number for the contact. This field supports general communication workflows and provides a primary voice-based channel for outreach.

Phone2 String False

Captures a secondary phone number for the client contact. This field provides an alternate communication channel for organizations managing multiple lines per contact.

Phone3 String False

Captures a third phone number for the client contact. This field enhances communication reliability in environments where contacts use several voice lines across departments or locations.

PreferredContactMethod String False

Specifies the communication method preferred by the contact. This field guides Bullhorn CRM users in selecting the most effective engagement channel to improve response rates.

ProfessionaloverviewResume String False

Captures résumé-style narrative or professional background information for the contact. This field provides useful context for relationship building and account development.

ReferredbyId Int False

Specifies the Id of the party who referred the contact. This field supports referral tracking and helps Bullhorn CRM analyze the origin and effectiveness of referral networks.

ReportstoId Int False

Specifies the Id of the supervisor or manager to whom the contact reports. This field helps Bullhorn CRM represent organizational hierarchy and identify key decision-makers.

SecondaryAddressAddress String False

Captures the street address for the contact's secondary location. This field supports contacts who operate in multiple offices or regions.

SecondaryAddressAddress2 String False

Captures the secondary address line for the contact's additional location. This field provides extended geographic detail where multi-line addresses are required.

SecondaryAddressCity String False

Specifies the city that is associated with the contact's secondary address. This field supports segmentation and geographic organization across multiple operational regions.

SecondaryAddressCountry Int False

Specifies the country Id for the contact's secondary address. This field supports international operations and ensures accurate localization within Bullhorn CRM.

SecondaryAddresscountryCode String False

Specifies the standardized country code for the contact's secondary location. This field ensures consistent formatting and supports international communication workflows.

SecondaryAddresscountryName String False

Captures the full country name for the contact's secondary address. This field improves clarity and ensures users can identify global geographic context easily.

SecondaryAddressState String False

Specifies the state or province for the contact's secondary location. This field supports territory management and region-based workflow configuration.

SecondaryAddressZip String False

Captures the postal or ZIP code for the contact's secondary address. This field supports proximity-based workflows, regional classification, and mapping functions.

Source String False

Specifies the source from which the client contact originated. This field supports sourcing analytics and helps Bullhorn CRM evaluate intake channels and acquisition pathways.

Status String False

Captures the current status assigned to the client contact. This field supports workflow routing, prioritization, and lifecycle management.

TimeZoneOffsetEST Int False

Specifies the time-zone offset from Eastern Standard Time (EST) for the contact's location. This field helps Bullhorn CRM coordinate communication and scheduling across different regions.

Title String False

Specifies the job title of the client contact. This field provides organizational context and assists users in evaluating the contact's influence and responsibilities.

TrackTitle String False

Captures a tracking title or alternate role description for the client contact. This field supports custom organizational labeling and specialized workflows within Bullhorn CRM.

Type String False

Specifies the type classification of the client contact. This field enables segmentation for workflows, reporting, and targeted engagement strategies.

UserDateAdded Datetime False

Captures the date and time when the contact's user account is added to the system. This field supports account lifecycle auditing and administrative reporting.

Username String False

Specifies the username associated with the contact's account in connected Bullhorn CRM systems. This field supports authentication, identity management, and access control.

UserTypeId Int False

Specifies the user type Id that is assigned to the client contact. This field controls permission levels and determines what the user can access or modify within Bullhorn CRM.

IsDeleted Bool False

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

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