Golden record

FieldValueTaken fromWhyDeciding tier
First nameTimothyEnrollment enrollment:448agency-a-derived/enrollment_clean.csv, row 448Most trusted source (enrollment over CRM)Rules (automatic)
Last nameRodriguezEnrollment enrollment:448agency-a-derived/enrollment_clean.csv, row 448Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1944-10-20Enrollment enrollment:448agency-a-derived/enrollment_clean.csv, row 448Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******XQ48Enrollment enrollment:448agency-a-derived/enrollment_clean.csv, row 448Most trusted source (enrollment over CRM)Rules (automatic)
Street3329 Durham Lock Apt. 557CRM crm:C-00516agency-a-snapshot/clients.csv, row 516Most recent recordRules (automatic)
CityJohnsonfortCRM crm:C-00516agency-a-snapshot/clients.csv, row 516Most recent recordRules (automatic)
StateILCRM crm:C-00516agency-a-snapshot/clients.csv, row 516Most recent recordRules (automatic)
ZIP60248CRM crm:C-00516agency-a-snapshot/clients.csv, row 516Most recent recordRules (automatic)
Phone(764) 555-0169CRM crm:C-00516agency-a-snapshot/clients.csv, row 516Most recent recordRules (automatic)
Emailtimothy.rodriguez516@example.comCRM crm:C-00516agency-a-snapshot/clients.csv, row 516Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-00516Enrollment enrollment:448
First nameTimothyTimothy
Last nameRodriguezRodriguez
Birth date1944-10-201944-10-20
MBI (last 4 only)*******XQ48*******XQ48
Street3329 Durham Lock Apt. 557Missing
CityJohnsonfortMissing
StateILMissing
ZIP60248Missing
Phone(764) 555-0169Missing
Emailtimothy.rodriguez516@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 516agency-a-derived/enrollment_clean.csv, row 448
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
453Mergedcrm:C-00516 and enrollment:448Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphThis person shares a household with Megan Rodriguez.same householdTimothy RodriguezMegan Rodriguez

This person shares a household with Megan Rodriguez.

  • Timothy Rodriguez (this person)
  • Megan Rodriguez: same household