Golden record

FieldValueTaken fromWhyDeciding tier
First nameMichaelEnrollment enrollment:303agency-a-derived/enrollment_clean.csv, row 303Most trusted source (enrollment over CRM)Rules (automatic)
Last nameSmithEnrollment enrollment:303agency-a-derived/enrollment_clean.csv, row 303Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1948-02-05Enrollment enrollment:303agency-a-derived/enrollment_clean.csv, row 303Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******XQ09Enrollment enrollment:303agency-a-derived/enrollment_clean.csv, row 303Most trusted source (enrollment over CRM)Rules (automatic)
Street75899 Moran LakesCRM crm:C-00355agency-a-snapshot/clients.csv, row 355Most recent recordRules (automatic)
CityWilsonburyCRM crm:C-00355agency-a-snapshot/clients.csv, row 355Most recent recordRules (automatic)
StateMOCRM crm:C-00355agency-a-snapshot/clients.csv, row 355Most recent recordRules (automatic)
ZIP65192CRM crm:C-00355agency-a-snapshot/clients.csv, row 355Most recent recordRules (automatic)
Phone(444) 555-0116CRM crm:C-00355agency-a-snapshot/clients.csv, row 355Most recent recordRules (automatic)
EmailNoneNoneNo record has a valueNone

Member records side by side

FieldCRM crm:C-00355Enrollment enrollment:303
First nameMichaelMichael
Last nameSmithSmith
Birth date1948-02-051948-02-05
MBI (last 4 only)*******XQ09*******XQ09
Street75899 Moran LakesMissing
CityWilsonburyMissing
StateMOMissing
ZIP65192Missing
Phone(444) 555-0116Missing
EmailMissingMissing
Sourceagency-a-snapshot/clients.csv, row 355agency-a-derived/enrollment_clean.csv, row 303
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
305Mergedcrm:C-00355 and enrollment:303Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Michael Smith

Only this person is in the household.

  • Michael Smith (this person)