# Field History DMO

Field-level change history sourced from the Field History data lake object (FieldHistory_std\_\_dll). One record per tracked field change.

## Object Properties

**Object API Name:** `std__DataModelObjFieldValHistDmo__dlm`\
**Category:** Unassigned\
**Availability:** Available in 264 and later versions\
**Primary Key Field:** Id

## Relationships

- **ChangedById** has a FOREIGNKEY relationship with the [User DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-userdmo-dmo.md) `Id` field.

## Fields

- [cdp_sys_record_currency](#cdp_sys_record_currency)
- [ChangedById](#changedbyid)
- [ChangeOperation](#changeoperation)
- [ChangeTimestamp](#changetimestamp)
- [CreatedDate](#createddate)
- [DataSourceId](#datasourceid)
- [DataSourceObjectId](#datasourceobjectid)
- [DataSpaceId](#dataspaceid)
- [FieldApiName](#fieldapiname)
- [FieldCreatedDateTime](#fieldcreateddatetime)
- [FieldDataType](#fielddatatype)
- [FieldModifiedDateTime](#fieldmodifieddatetime)
- [Id](#id)
- [InternalOrganizationId](#internalorganizationid)
- [IsZeroCopySource](#iszerocopysource)
- [NewValue](#newvalue)
- [OldValue](#oldvalue)
- [OrgId](#orgid)
- [SourceObjectApiName](#sourceobjectapiname)
- [SourceObjectRecordIdentifier](#sourceobjectrecordidentifier)

### cdp_sys_record_currency

- **Field API Name:** `std__cdp_sys_record_currency__c`
- **Data Type:** TEXT
- **Description:** System-generated metadata field that stores a 3-letter ISO currency code.

### ChangedById

- **Field API Name:** `std__ChangedById__c`
- **Data Type:** TEXT
- **Description:** Identifier of the user who changed the field.

### ChangeOperation

- **Field API Name:** `std__ChangeOperation__c`
- **Data Type:** TEXT
- **Description:** Type of change: INSERT, UPDATE_PREIMAGE, UPDATE_POSTIMAGE, or DELETE.

### ChangeTimestamp

- **Field API Name:** `std__ChangeTimestamp__c`
- **Data Type:** DATETIME
- **Description:** Time the source record's field changed. Use for ordering.

### CreatedDate

- **Field API Name:** `std__CreatedDate__c`
- **Data Type:** DATETIME
- **Description:** Time the field-history record was created.

### DataSourceId

- **Field API Name:** `std__DataSourceId__c`
- **Data Type:** TEXT
- **Description:** A unique, system-generated identifier for this record.

### DataSourceObjectId

- **Field API Name:** `std__DataSourceObjectId__c`
- **Data Type:** TEXT
- **Description:** A unique, system-generated identifier for this record.

### DataSpaceId

- **Field API Name:** `std__DataSpaceId__c`
- **Data Type:** TEXT
- **Description:** Data space identifier used for per-data-space filtering and governance boundaries.

### FieldApiName

- **Field API Name:** `std__FieldApiName__c`
- **Data Type:** TEXT
- **Description:** API name of the field that changed.

### FieldCreatedDateTime

- **Field API Name:** `std__FieldCreatedDateTime__c`
- **Data Type:** DATETIME
- **Description:** Date and time the field value was created.

### FieldDataType

- **Field API Name:** `std__FieldDataType__c`
- **Data Type:** TEXT
- **Description:** Data type of the changed field, for example TEXT, NUMBER, DATE, DATETIME, BOOLEAN, ID, PICKLIST, CURRENCY, EMAIL, PHONE, or PERCENT.

### FieldModifiedDateTime

- **Field API Name:** `std__FieldModifiedDateTime__c`
- **Data Type:** DATETIME
- **Description:** Date and time the field value was last modified.

### Id

- **Field API Name:** `std__Id__c`
- **Data Type:** TEXT
- **Description:** Deterministic unique identifier for the field-history event.

### InternalOrganizationId

- **Field API Name:** `std__InternalOrganizationId__c`
- **Data Type:** TEXT
- **Description:** A unique, system-generated identifier for this record.

### IsZeroCopySource

- **Field API Name:** `std__IsZeroCopySource__c`
- **Data Type:** BOOLEAN
- **Description:** Indicates whether the field is sourced from a zero-copy DLO, such as Snowflake or Redshift, where no Change Data Feed is available.

### NewValue

- **Field API Name:** `std__NewValue__c`
- **Data Type:** TEXT
- **Description:** Value of the field after the change.

### OldValue

- **Field API Name:** `std__OldValue__c`
- **Data Type:** TEXT
- **Description:** Value of the field before the change.

### OrgId

- **Field API Name:** `std__OrgId__c`
- **Data Type:** TEXT
- **Description:** Identifier of the org that owns the changed record.

### SourceObjectApiName

- **Field API Name:** `std__SourceObjectApiName__c`
- **Data Type:** TEXT
- **Description:** API name of the object whose field changed.

### SourceObjectRecordIdentifier

- **Field API Name:** `std__SourceObjectRecordIdentifier__c`
- **Data Type:** TEXT
- **Description:** Identifier of the source record whose field changed.