Golden record

FieldValueTaken fromWhyDeciding tier
First nameDanielEnrollment enrollment:239agency-a-derived/enrollment_clean.csv, row 239Most trusted source (enrollment over CRM)Rules (automatic)
Last nameRodriguezEnrollment enrollment:239agency-a-derived/enrollment_clean.csv, row 239Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1937-05-26Enrollment enrollment:239agency-a-derived/enrollment_clean.csv, row 239Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******ET72Enrollment enrollment:239agency-a-derived/enrollment_clean.csv, row 239Most trusted source (enrollment over CRM)Rules (automatic)
Street44565 Chavez FortCRM crm:C-00277agency-a-snapshot/clients.csv, row 277Most recent recordRules (automatic)
CityEast DerekshireCRM crm:C-00277agency-a-snapshot/clients.csv, row 277Most recent recordRules (automatic)
StateNCCRM crm:C-00277agency-a-snapshot/clients.csv, row 277Most recent recordRules (automatic)
ZIP28315CRM crm:C-00277agency-a-snapshot/clients.csv, row 277Most recent recordRules (automatic)
Phone(700) 555-0100CRM crm:C-00277agency-a-snapshot/clients.csv, row 277Most recent recordRules (automatic)
Emaildaniel.rodriguez277@example.comCRM crm:C-00277agency-a-snapshot/clients.csv, row 277Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-00277Enrollment enrollment:238Enrollment enrollment:239
First nameDanielDanielDaniel
Last nameRodriguezRodriguezRodriguez
Birth date1937-05-261937-05-261937-05-26
MBI (last 4 only)*******ET72*******ET72*******ET72
Street44565 Chavez FortMissingMissing
CityEast DerekshireMissingMissing
StateNCMissingMissing
ZIP28315MissingMissing
Phone(700) 555-0100MissingMissing
Emaildaniel.rodriguez277@example.comMissingMissing
Sourceagency-a-snapshot/clients.csv, row 277agency-a-derived/enrollment_clean.csv, row 238agency-a-derived/enrollment_clean.csv, row 239
Active policyYesNoYes

Merge log lines for this person

LineActionPairTierScoreRule
243Mergedcrm:C-00277 and enrollment:238Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)
244Mergedcrm:C-00277 and enrollment:239Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)
2050Mergedenrollment:238 and enrollment:239Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Daniel Rodriguez

Only this person is in the household.

  • Daniel Rodriguez (this person)