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