CandidateCertificationEditHistory
Tracks historical updates that are applied to candidate certification records. This table supports audit and compliance requirements by documenting when certification details are changed and how those changes affect qualification status.
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | Int | False |
Specifies the unique identifier (Id) for this certification edit history record. This field supports auditing processes by allowing the system to distinguish each historical change event. |
| AuditTrail | String | False |
Captures the serialized audit information that is associated with modifications to a candidate certification. This field provides detailed visibility into who changed specific values and how those changes affect certification compliance. |
| DateAdded | Datetime | False |
Indicates the date and time when the record for this certification edit history is created. This field supports chronological analysis by placing each modification within the broader timeline of certification updates. |
| MigrateGUID | String | False |
Stores the migration Id that is used during data import workflows. This field supports system integration by linking the history entry to external or legacy data sources. |
| ModifyingPersonId | Int | False |
Specifies the Id of the person who performs the certification update. This field supports accountability by identifying the individual responsible for a specific modification. |
| TargetEntityId | Int | False |
Identifies the Id of the candidate certification record that is affected by the edit. This field maintains relational integrity by linking each history entry to the certification it describes. |
| TransactionID | String | False |
Stores the transaction Id that groups together related certification updates. This field supports audit reconstruction by enabling the system to associate multiple field-level changes with a single update event. |