Golden record

FieldValueTaken fromWhyDeciding tier
First nameDavidEnrollment enrollment:682agency-a-derived/enrollment_clean.csv, row 682Most trusted source (enrollment over CRM)Rules (automatic)
Last nameWeaverEnrollment enrollment:682agency-a-derived/enrollment_clean.csv, row 682Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1946-09-23Enrollment enrollment:682agency-a-derived/enrollment_clean.csv, row 682Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******ER12Enrollment enrollment:682agency-a-derived/enrollment_clean.csv, row 682Most trusted source (enrollment over CRM)Rules (automatic)
Street206 Lisa IslandsCRM crm:C-00776agency-a-snapshot/clients.csv, row 776Most recent recordRules (automatic)
CityNew JamieCRM crm:C-00776agency-a-snapshot/clients.csv, row 776Most recent recordRules (automatic)
StateNCCRM crm:C-00776agency-a-snapshot/clients.csv, row 776Most recent recordRules (automatic)
ZIP27483CRM crm:C-00776agency-a-snapshot/clients.csv, row 776Most recent recordRules (automatic)
Phone(428) 555-0165CRM crm:C-00776agency-a-snapshot/clients.csv, row 776Most recent recordRules (automatic)
Emaildavid.weaver776@example.comCRM crm:C-00776agency-a-snapshot/clients.csv, row 776Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-00776Enrollment enrollment:682
First nameDavidDavid
Last nameWeaverWeaver
Birth date1946-09-231946-09-23
MBI (last 4 only)*******ER12*******ER12
Street206 Lisa IslandsMissing
CityNew JamieMissing
StateNCMissing
ZIP27483Missing
Phone(428) 555-0165Missing
Emaildavid.weaver776@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 776agency-a-derived/enrollment_clean.csv, row 682
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
693Mergedcrm:C-00776 and enrollment:682Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphThis person shares a household with Sheila Weaver.same householdDavid WeaverSheila Weaver

This person shares a household with Sheila Weaver.