ADO.NET Provider for Bullhorn CRM

Build 25.0.9539

LocationEffectiveDateChange

Captures effective date changes that apply to Location records. This table supports time-based accuracy by storing date transitions that influence location validity, assignment rules, or billing periods.

Columns

Name Type ReadOnly Description
Id [KEY] Int False

Represents the unique identifier (Id) of the LocationEffectiveDateChange entry. This value distinguishes each effective-date adjustment that is applied to a Location record within Bullhorn CRM.

EditHistoryId Int False

Indicates the Id of the LocationEditHistory entry that is associated with the effective-date change. This linkage connects the timing adjustment to the broader edit event that triggers it.

NewEffectiveDate Date False

Specifies the new effective date that is assigned to the Location record. This field supports versioning logic that determines when updated Location details become active in the system.

PreviousEffectiveDate Date False

Captures the previous effective date that is replaced during the update. This information allows auditing tools to reconstruct version histories and interpret how Location timing changes evolve over time.

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