JDBC Driver for Bullhorn CRM

Build 25.0.9539

LocationEditHistory

Tracks historical updates that are applied to location records. This table supports auditing and record accuracy by documenting changes that affect operational or geographic information.

Columns

Name Type ReadOnly Description
Id [KEY] Int False

Represents the unique identifier (Id) of the LocationEditHistory entry. This value allows Bullhorn CRM to track and distinguish each recorded change that is applied to a Location record.

AuditTrail String False

Captures the audit trail details that are associated with the history entry. This information provides narrative context that supports compliance reviews and assists users with understanding what was modified.

DateAdded Datetime False

Indicates the datetime when the LocationEditHistory entry is created. This timestamp enables chronological reconstruction of changes and supports audit validation processes.

EffectiveDateChangeId Int False

Specifies the Id of the effective-date change that is linked to the Location update. This association helps the system track location versioning rules that depend on activation or deactivation timelines.

MigrateGUID String False

Stores the unique identifier for the migration object that is assigned during data migration or synchronization activities. This value ensures that imported or updated historical entries remain traceable across systems.

ModifyingPersonId Int False

Captures the Id of the person who performs the modification that results in the history entry. This detail supports accountability and provides visibility into user-driven changes.

TargetEntityId Int False

Identifies the Id of the Location record that is affected by the history entry. This reference ensures that each recorded update is linked to the correct location entity.

TransactionID String False

Stores the transaction Id that is associated with the update operation. This value enables grouping of related changes under a single transactional context.

VersionID Int False

Specifies the Id of the Location version that is associated with the edit. This value allows the system to track version-specific changes for locations that evolve over time.

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