ADO.NET Provider for Bullhorn CRM

Build 25.0.9539

AppointmentEditHistory

Tracks the historical changes that are applied to appointment records. This table supports auditing and compliance by preserving a chronological record of updates that provide context for user actions and appointment lifecycle events.

Columns

Name Type ReadOnly Description
Id [KEY] Int False

Represents the unique identifier (Id) for this appointment edit history record. This field supports audit tracking by distinguishing each historical entry for review and reconciliation.

AuditTrail String False

Describes the serialized audit information that is captured when an appointment is modified. This field supports detailed change analysis by storing the before-and-after values that document how the appointment was altered.

DateAdded Datetime False

Indicates the date and time when this appointment edit history record is added. This field supports chronological auditing by establishing when the system recorded the modification.

MigrateGUID String False

Specifies the globally unique value that is used to migrate or synchronize appointment edit history records across systems. This field supports data integrity during import, export, or cross-environment alignment.

ModifyingPersonId Int False

Identifies the person Id that is associated with the user who performs the appointment update. This field supports accountability workflows by linking modification activity to the individual who made the change.

TargetEntityId Int False

Identifies the appointment Id that is associated with this historical entry. This field supports accurate traceability by connecting the edit history record to the appointment that is being modified.

TransactionID String False

Captures the transaction Id that groups related update operations into a single audit event. This field supports consistent auditing by allowing systems to interpret multiple field changes as part of one logical modification.

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