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 Id field.

Fields

• cdp_sys_record_currency
• ChangedById
• ChangeOperation
• ChangeTimestamp
• CreatedDate
• DataSourceId
• DataSourceObjectId
• DataSpaceId
• FieldApiName
• FieldCreatedDateTime
• FieldDataType
• FieldModifiedDateTime
• Id
• InternalOrganizationId
• IsZeroCopySource
• NewValue
• OldValue
• OrgId
• SourceObjectApiName
• 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.