--- schema_version: "1" id: e3f60fbaf04fb9e2f4afed2b5f009f56632636b0dbc95164eccaad5b0e3d4d0d title: FieldHistoryArchive collection: legacydeveloper version: current locale: en-us portal_url: https://docs.salesforce.com/legacydeveloper/current/en-us/object_reference/sforce_api_objects_fieldhistoryarchive.md canonical_url: https://developer.salesforce.com/docs/atlas.en-us.object_reference.meta/object_reference/sforce_api_objects_fieldhistoryarchive.htm source_site: developer.salesforce.com content_type: documentation content_hash: 5012521accf4b4450905d8cc4f457416af7290c938fdff409027b7498bffa7a2 description: Represents field history values for all objects that retain field history. FieldHistoryArchive is a big object, available only to users with the “Retain Field History” permission. This object is available in API version 29.0 and later. --- # FieldHistoryArchive Represents field history values for all objects that retain field history. FieldHistoryArchive is a big object, available only to users with the “Retain Field History” permission. This object is available in API version 29.0 and later. Each instance of the FieldHistoryArchive object represents a single change in the value of a field. FieldHistoryArchive stores history for both standard and custom fields. The Field field returns the name of the field unless the parent field or object is deleted, in which case it returns the field ID. You can use the ID to retrieve the old field and object name from the FieldNameAfterArchival and ParentNameAfterArchival fields, respectively. ## Supported Calls describeSObjects(), query() ## Fields | Field Name | Details | | --- | --- | | ArchiveFieldName | Type string Properties Nillable Description The name of the field at the time the data was archived. If the field name changed, the name is sometimes not the same for all records related to a single field. | | ArchiveParentName | Type string Properties Nillable Description The name of the parent object at the time the data was archived. If the object name changed, the name is sometimes not the same for all records related to a single field. | | ArchiveParentType | Type string Properties Nillable Description The type of the field at the time the data was archived. If the field type changed, the type is sometimes not the same for all records related to a single field. | | ArchiveTimestamp | Type dateTime Properties Nillable Description The date and time at which the data was archived. | | Field | Type picklist Properties Restricted picklist Description The name of the field that was changed. If the field is deleted from the parent object, the Field field contains the field ID instead. | | FieldHistoryType | Type picklist Properties Filter, Nillable, Restricted picklist, Sort Description The name of the object that contains the field history. Possible values are: - Account - Article - Asset - AuthorizationFormConsent – Available in version 58.0 and later. - Case - CommSubscriptionConsent – Available in version 58.0 and later. - Contact - ContactPointConsent – Available in version 58.0 and later. - ContactPointTypeConsent – Available in version 58.0 and later. - Contract - ContractLineItem - Crisis - Employee - EmployeeCrisisAssessment - Entitlement - Individual - InternalOrganizationUnit - Knowledge - Lead - Opportunity - Order - OrderItem - PartyConsent – Available in version 58.0 and later. - Pricebook2 - PricebookEntry - Product2 - ServiceAppointment - ServiceContract - Solution - WorkOrder - WorkOrderLineItem | | HistoryId | Type reference Properties Filter, Sort Description The ID of the relevant history object (for example, AccountHistory). This field is available in versions 42.0 and later. | | NewValue | Type anyType Properties Nillable Description The new value of the modified field. | | OldValue | Type anyType Properties Nillable Description The previous value of the modified field. | | ParentId | Type reference Properties Filter, Sort Description The ID of the object that contains the field (the parent object). | ## Usage When sorting fields, order them as follows: 1. FieldHistoryType ASC 2. ParentID ASC 3. CreatedDate DESC #### See Also - [_Developer Guide:_Big Objects Implementation Guide](https://developer.salesforce.com/docs/atlas.en-us.264.0.bigobjects.meta/bigobjects/big_object.htm " Developer Guide:Big Objects Implementation Guide - HTML (New Window)")