> ## Documentation Index
> Fetch the complete documentation index at: https://developer.affinity.co/llms.txt
> Use this file to discover all available pages before exploring further.

# Opportunities Value Changes

Includes the history of changes to global field values on opportunities. Only fields with change tracking enabled record changes. Changes to list-specific fields are not in this table; they are in list\_entries\_value\_changes, which reaches an opportunity through list\_entries\_opportunities. Field metadata is in the fields\_metadata table (join field\_id to fields\_metadata.id).

**Name:** `v1_0.opportunities_value_changes`

<Warning>
  Grant access to the share only to users who are authorized to view all
  organization data. There are no per-user or per-role visibility filters applied at the
  share level.
</Warning>

## Columns

| Column            | Description                                                                                                                                                                                                                                                                                                                                                                   |
| ----------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `id`              | The field value change's unique identifier                                                                                                                                                                                                                                                                                                                                    |
| `field_id`        | The ID of the field whose value changed (join to fields\_metadata.id)                                                                                                                                                                                                                                                                                                         |
| `opportunity_id`  | The ID of the opportunity the change is on                                                                                                                                                                                                                                                                                                                                    |
| `changer_id`      | The person ID of the user that made the change (null for system-generated changes or when the user has been deleted)                                                                                                                                                                                                                                                          |
| `changed_at`      | The date that the change was recorded                                                                                                                                                                                                                                                                                                                                         |
| `action_type`     | The type of change (add, update, or delete)                                                                                                                                                                                                                                                                                                                                   |
| `value`           | The new value for add/update changes, or the removed value for delete changes, as a one-entry JSON object keyed by field\_id — the same shape as a custom\_fields entry. Person, company, and dropdown values are rendered as the referenced ID (null when the referenced row has since been deleted). Use the value\_type on the joined fields\_metadata row to interpret it |
| `value_display`   | Display text snapshot captured at change time for person, company, and dropdown values (person name, company name, or dropdown option text); null for other value types                                                                                                                                                                                                       |
| `is_deleted`      | Whether the field value change has been deleted                                                                                                                                                                                                                                                                                                                               |
| `last_updated_at` | Timestamp when this record was last updated                                                                                                                                                                                                                                                                                                                                   |


## Related topics

- [List Entries Value Changes](/pages/data-share/list_entries_value_changes_v1_0.md)
- [Changelog](/pages/data-share/changelog.md)
- [Get all field value changes](/api-reference/2024-01-01/field-value-changes/get-all-field-value-changes.md)
- [Get Field Value Changes on a List Entry](/api-reference/2024-01-01/lists/get-field-value-changes-on-a-list-entry.md)