JDBC Driver for Bullhorn CRM

Build 25.0.9539

Location

Represents physical or organizational locations that are associated with corporate or client entities. This table supports operational workflows by storing address, region, and location attributes that influence assignment, billing, and reporting.

Columns

Name Type ReadOnly Description
Id [KEY] Int False

Represents the unique identifier (Id) of the Location record. This value allows Bullhorn CRM to distinguish this location from all other corporate, client, or worksite locations.

AddressAddress1 String False

Captures the first address line for the Location. This field supports mailing, mapping, and work assignment processes that rely on precise street-level data.

AddressAddress2 String False

Captures the second address line for the Location. This value provides extended address details that improve accuracy in delivery, navigation, and compliance reporting.

AddressCity String False

Specifies the city component of the Location address. This information supports geographic reporting, regional search filters, and jurisdiction-specific business rules.

AddressCountry Int False

Indicates the Id of the country that is associated with the Location. This value ensures that the system applies the correct regional formatting, validation, and compliance logic.

AddresscountryCode String False

Stores the country code that is associated with the Location. This value assists with standardized data exchange, mapping integrations, and cross-border reporting.

AddresscountryName String False

Stores the full country name of the Location. This value improves readability in user interfaces and exported reports that require descriptive location detail.

AddressState String False

Captures the state or province for the Location address. This information supports tax calculations, geographic assignment rules, and region-based reporting.

AddressZip String False

Captures the ZIP or postal code for the Location. This value improves routing, candidate placement assignments, and distance-based search operations.

BillTo Bool False

Specifies whether the Location serves as a billing address. Returns a value of 'true' when the Location is designated for invoicing and accounts receivable purposes. It returns a value of 'false' when billing for the associated entity is handled elsewhere.

CandidateUserID Int False

Indicates the Id of the candidate user who is associated with the Location. This relationship ties the Location to user-level permissions, activities, or worksite responsibilities.

ClientCorporationID Int False

Specifies the Id of the client corporation that is linked to the Location. This value connects the Location to account management workflows and corporation-level reporting.

DateAdded Datetime False

Captures the datetime when the Location record is created. This timestamp enables chronological tracking and supports audit trail requirements.

DateLastModified Datetime False

Captures the datetime when the Location record was most recently updated. This value supports change auditing and assists synchronization and integration processes.

Description String False

Provides a descriptive label for the Location. This value enhances record clarity in lists, searches, and organizational reporting.

EffectiveDate Date False

Indicates the date when the Location record becomes effective. This value supports rule-based logic that depends on location activation timelines.

EffectiveEndDate Date False

Indicates the date when the Location record is no longer effective. This value allows the system to manage inactive or obsolete locations without deleting historical data.

LocationCode String False

Stores a code that identifies the Location within an organization. This field supports internal tracking, reporting, and integration with external systems that rely on standardized location identifiers.

LocationVersionID Int False

Specifies the Id of the version that is associated with the Location. This value supports version control processes for locations that evolve over time.

SoldTo Bool False

Specifies whether the Location functions as a 'sold to' address. Returns a value of 'true' when the Location is used for order or sale transactions. It returns a value of 'false' when those transactions are directed to another associated location.

Status String False

Represents the current status of the Location. This value supports filtering, workflow routing, and business rules that depend on active or inactive state.

Title String False

Captures the display title or label that is assigned to the Location. This value improves record identification in interfaces where multiple locations appear in lists or selection menus.

UserID Int False

Indicates the Id of the user who is associated with the Location. This value links the Location to user-driven actions, responsibilities, or assignment logic.

Worksite Bool False

Specifies whether the Location serves as a worksite. Returns a value of 'true' when the Location is designated as an active work location for placements or assignments. It returns a value of 'false' when the Location is not used for worksite purposes.

IsDeleted Bool False

Indicates whether the Location record is marked as deleted. Returns a value of 'true' when the record is removed from active use but retained for historical or audit reasons. It returns a value of 'false' when the Location is active and available for standard operations.

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