Score and System Fields
Score and System Fields
MatchLogic can include additional metadata columns in your export that provide detailed information about match scores and internal record status. These fields are invaluable for auditing, downstream processing, and understanding why records were grouped together.
Include Score Fields
When this option is enabled, MatchLogic adds columns for each match definition's score and the match key that produced the best result. The additional columns include:
- Per-definition match scores — A numeric score (0 to 100) for each match definition you created. If you have three definitions, three score columns are added. This lets you see how well each record matched under each set of criteria.
- Maximum score — The highest score across all definitions for each record pair.
- Match key — The name of the definition or field combination that produced the winning match. For example, "FirstName + LastName" or "Email (Exact)".
Score fields are useful when you want to perform additional analysis on your matched data, such as filtering by score threshold or identifying which matching criteria contributed most to your results.
Include System Fields
System fields are internal metadata columns that MatchLogic uses to track record status throughout the pipeline. When enabled, the following columns are added to your export:
- _isMasterRecord — Boolean flag indicating whether this record was designated as the master record in its group during the Merge and Survivorship step.
- _selected — Boolean flag indicating whether a reviewer marked this record as "selected" during match results review.
- _notDuplicate — Boolean flag indicating whether a reviewer marked this record as "not a duplicate" (false positive).
- _groupId — The unique identifier of the match group this record belongs to. Records with the same group ID were matched together.
When to Use Each
- For audit trails — Enable both score and system fields. This gives a complete picture of why each record was matched, its score, and its final status.
- For downstream processing — Enable system fields so your target system can read the master record flag, group ID, or selection status and apply its own logic.
- For clean deliverables — Disable both options to export only the original data columns without any MatchLogic metadata.
Tip
You can use the "Hide System Columns" toggle in the export preview to temporarily hide these columns while reviewing your data, without changing the actual export settings. See #previewing-export-data for details.