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