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