OpportunityEditHistoryFieldChange
Captures the change to an individual field that is recorded when an opportunity record is updated. This table supports granular pipeline auditing by identifying precise updates that influence opportunity progress.
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | Int | False |
Represents the unique identifier (Id) of the OpportunityEditHistoryFieldChange table. This value links each field-level change to a distinct record so Bullhorn CRM can track modifications at a granular level. |
| ColumnName | String | False |
Identifies the name of the column that is modified in the OpportunityEditHistoryFieldChange table. This value indicates which field in the related Opportunity record is affected during the edit event. |
| Display | String | False |
Provides the display-friendly label that is associated with the changed field in the OpportunityEditHistoryFieldChange table. This value supports user-facing audit logs where readable field names are required. |
| EditHistoryId | Int | False |
Specifies the Id of the related OpportunityEditHistory record. This relationship ties the field-level change to its parent edit event so Bullhorn CRM can maintain a structured audit hierarchy. |
| NewValue | String | False |
Captures the new value that is assigned to the field during the edit that is recorded in the OpportunityEditHistoryFieldChange table. This entry supports comparison logic by documenting the outcome of the modification. |
| OldValue | String | False |
Stores the previous value that is replaced during the modification that is captured in the OpportunityEditHistoryFieldChange table. This value enables before-and-after auditing for compliance and historical review. |