Duplicate Check Audit

Custom Objects

The dupcheck__dcAudit__c object is part of the Plauti Deduplicate system and stores a historical log of actions taken during the deduplication process. It provides traceability and visibility into what actions were performed, by whom, and when.

Purpose

Duplicate Check Audit is used to record audit trail entries for deduplication jobs and user actions, such as merges, conversion, skips, or delta queue entries.

Fields & Metadata

Field LabelAPI NameTypeDescription
Audit Datedupcheck__AuditDate__cDate/TimeTimestamp of when the audit event occurred
Created ByCreatedByIdLookup(User)System audit field
Datadupcheck__Data__cLong Text AreaContains structured JSON detailing the full context of a deduplication event, including user, object, method, and merged records. See more below.
Duplicate Check Auditdupcheck__dcAudit__cLookup(dcAudit)Self-lookup, used for linking grouped audit entries
Duplicate Check Audit NameNameAuto NumberUnique identifier for the audit entry
Duplicate Check Jobdupcheck__dcJob__cLookup(dcJob)Reference to the job that triggered the audit (can be null)
Last Modified ByLastModifiedByIdLookup(User)System audit field
Methoddupcheck__Method__cText(50)Technical source of the action (e.g., flow, component, API)
Object Iddupcheck__ObjectId__cText(18) (External ID)ID of the object related to the audit
Object Labeldupcheck__ObjectName__cText(255)Display label of the object type
Object Prefixdupcheck__Prefix__cText(4)Key prefix of the object type
Orderdupcheck__Order__cNumber(18, 0)Sequence of execution or grouping
OwnerOwnerIdLookup(User, Group)Ownership field
Record Iddupcheck__RecordId__cText(18)Specific record ID affected by the action
Related Records Idsdupcheck__RelatedIds__cText(255)Record IDs of loser records after a successful merge event
Typedupcheck__Type__cPicklistType of audit event (e.g., Merge, Convert, Delta)
Type Stringdupcheck__TypeString__cText(50) (External ID)Text representation of type
Userdupcheck__User__cLookup(User)User who performed or triggered the action

Understanding the dupcheck__Data__c Field

The dupcheck__Data__c field stores detailed JSON data that describes what happened during a deduplication event such as a merge or queue entry.

For merge events this field includes:

  • User information: Who triggered the event, including their user ID and name.
  • Timestamp: Exact time the event occurred.
  • Event type: Indicated by the auditType (e.g., "Merge", "Delta").
  • Merge method: Whether the merge was manual, automatic, or API-driven.
  • Master object: The record that was retained after the merge, including field values like address and description.
  • Loser objects: Full snapshots of the records that were merged into the master, including both standard and custom fields.
  • Context: Optional internal flags or merge rule versions used at the time of execution.

This field is useful for developers and admins who need complete visibility into how merges were performed, for syncing with external systems, rollback logic, compliance auditing, or custom reporting. You can parse this JSON data in Flows, Apex, or external ETL tools to take follow-up actions or generate traceable logs.

Developer Use Cases

  • Trigger Post-Event Logic via Flow: Launch a Flow when an audit entry is created (e.g., TypeString = 'Merge') to perform follow-up actions. Example: Automatically merge related Opportunities when a Contact is merged, or notify record owner.
  • Audit Trail Reporting: Use this object to build compliance reports or dashboards showing user and system deduplication actions over time.
  • Merge Tracking: When TypeString = 'Merge', analyze the contents of dupcheck__Data__c to see which records were merged, the user who performed it, and what changed.
  • Error Forensics: Use dupcheck__Data__c to retrieve structured payloads such as user info, timestamps, merge context, and record data for debugging and audit.
  • Use Related IDs for External Sync: The dupcheck__RelatedIds__c field contains the IDs of the "loser" records in a merge. You can use these IDs in integrations to update or archive records in external systems.