Golden record

FieldValueTaken fromWhyDeciding tier
First nameKarenEnrollment enrollment:192agency-a-derived/enrollment_clean.csv, row 192Most trusted source (enrollment over CRM)Rules (automatic)
Last nameHarrisEnrollment enrollment:192agency-a-derived/enrollment_clean.csv, row 192Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1955-01-14Enrollment enrollment:192agency-a-derived/enrollment_clean.csv, row 192Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******PV77Enrollment enrollment:192agency-a-derived/enrollment_clean.csv, row 192Most trusted source (enrollment over CRM)Rules (automatic)
Street660 Shannon MeadowCRM crm:C-00233agency-a-snapshot/clients.csv, row 233Most recent recordRules (automatic)
CitySmithboroughCRM crm:C-00233agency-a-snapshot/clients.csv, row 233Most recent recordRules (automatic)
StateNECRM crm:C-00233agency-a-snapshot/clients.csv, row 233Most recent recordRules (automatic)
ZIP68493CRM crm:C-00233agency-a-snapshot/clients.csv, row 233Most recent recordRules (automatic)
Phone(284) 555-0160CRM crm:C-00233agency-a-snapshot/clients.csv, row 233Most recent recordRules (automatic)
EmailNoneNoneNo record has a valueNone

Member records side by side

FieldCRM crm:C-00233Enrollment enrollment:192
First nameKarenKaren
Last nameHarrisHarris
Birth date1955-01-141955-01-14
MBI (last 4 only)*******PV77*******PV77
Street660 Shannon MeadowMissing
CitySmithboroughMissing
StateNEMissing
ZIP68493Missing
Phone(284) 555-0160Missing
EmailMissingMissing
Sourceagency-a-snapshot/clients.csv, row 233agency-a-derived/enrollment_clean.csv, row 192
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
196Mergedcrm:C-00233 and enrollment:192Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphThis person shares a household with Lindsey Harris.same householdKaren HarrisLindsey Harris

This person shares a household with Lindsey Harris.

  • Karen Harris (this person)
  • Lindsey Harris: same household