Golden record

FieldValueTaken fromWhyDeciding tier
First nameLisaEnrollment enrollment:160agency-a-derived/enrollment_clean.csv, row 160Most trusted source (enrollment over CRM)Rules (automatic)
Last nameCummingsEnrollment enrollment:160agency-a-derived/enrollment_clean.csv, row 160Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1934-05-11Enrollment enrollment:160agency-a-derived/enrollment_clean.csv, row 160Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******GN72Enrollment enrollment:160agency-a-derived/enrollment_clean.csv, row 160Most trusted source (enrollment over CRM)Rules (automatic)
Street39718 Stokes Motorway Apt. 867CRM crm:C-00189agency-a-snapshot/clients.csv, row 189Most recent recordRules (automatic)
CityNew StevenportCRM crm:C-00189agency-a-snapshot/clients.csv, row 189Most recent recordRules (automatic)
StateIDCRM crm:C-00189agency-a-snapshot/clients.csv, row 189Most recent recordRules (automatic)
ZIP83232CRM crm:C-00189agency-a-snapshot/clients.csv, row 189Most recent recordRules (automatic)
Phone(641) 555-0136CRM crm:C-00189agency-a-snapshot/clients.csv, row 189Most recent recordRules (automatic)
EmailNoneNoneNo record has a valueNone

Member records side by side

FieldCRM crm:C-00189Enrollment enrollment:160
First nameLisaLisa
Last nameCummingsCummings
Birth date1934-05-111934-05-11
MBI (last 4 only)*******GN72*******GN72
Street39718 Stokes Motorway Apt. 867Missing
CityNew StevenportMissing
StateIDMissing
ZIP83232Missing
Phone(641) 555-0136Missing
EmailMissingMissing
Sourceagency-a-snapshot/clients.csv, row 189agency-a-derived/enrollment_clean.csv, row 160
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
164Mergedcrm:C-00189 and enrollment:160Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphThis person shares a household with Randy Cummings.same householdLisa CummingsRandy Cummings

This person shares a household with Randy Cummings.