Golden record

FieldValueTaken fromWhyDeciding tier
First nameJohnEnrollment enrollment:105agency-a-derived/enrollment_clean.csv, row 105Most trusted source (enrollment over CRM)Rules (automatic)
Last nameYoungEnrollment enrollment:105agency-a-derived/enrollment_clean.csv, row 105Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1957-10-02Enrollment enrollment:105agency-a-derived/enrollment_clean.csv, row 105Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******QD91Enrollment enrollment:105agency-a-derived/enrollment_clean.csv, row 105Most trusted source (enrollment over CRM)Rules (automatic)
Street706 Rhodes FreewayCRM crm:C-00125agency-a-snapshot/clients.csv, row 125Most recent recordRules (automatic)
CityBishopmouthCRM crm:C-00125agency-a-snapshot/clients.csv, row 125Most recent recordRules (automatic)
StateWVCRM crm:C-00125agency-a-snapshot/clients.csv, row 125Most recent recordRules (automatic)
ZIP26543CRM crm:C-00125agency-a-snapshot/clients.csv, row 125Most recent recordRules (automatic)
Phone(758) 555-0188CRM crm:C-00125agency-a-snapshot/clients.csv, row 125Most recent recordRules (automatic)
Emailjohn.young125@example.comCRM crm:C-00125agency-a-snapshot/clients.csv, row 125Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-00125Enrollment enrollment:105
First nameJohnJohn
Last nameYoungYoung
Birth date1957-10-021957-10-02
MBI (last 4 only)*******QD91*******QD91
Street706 Rhodes FreewayMissing
CityBishopmouthMissing
StateWVMissing
ZIP26543Missing
Phone(758) 555-0188Missing
Emailjohn.young125@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 125agency-a-derived/enrollment_clean.csv, row 105
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
109Mergedcrm:C-00125 and enrollment:105Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.John Young

Only this person is in the household.

  • John Young (this person)