Golden record

FieldValueTaken fromWhyDeciding tier
First nameDonaldEnrollment enrollment:330agency-a-derived/enrollment_clean.csv, row 330Most trusted source (enrollment over CRM)Rules (automatic)
Last nameToddEnrollment enrollment:330agency-a-derived/enrollment_clean.csv, row 330Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1944-03-06Enrollment enrollment:330agency-a-derived/enrollment_clean.csv, row 330Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******TX19Enrollment enrollment:330agency-a-derived/enrollment_clean.csv, row 330Most trusted source (enrollment over CRM)Rules (automatic)
Street427 Randy ParkwayCRM crm:C-00388agency-a-snapshot/clients.csv, row 388Most recent recordRules (automatic)
CityLake JohnburghCRM crm:C-00388agency-a-snapshot/clients.csv, row 388Most recent recordRules (automatic)
StateOHCRM crm:C-00388agency-a-snapshot/clients.csv, row 388Most recent recordRules (automatic)
ZIP43222CRM crm:C-00388agency-a-snapshot/clients.csv, row 388Most recent recordRules (automatic)
Phone(655) 555-0105CRM crm:C-00388agency-a-snapshot/clients.csv, row 388Most recent recordRules (automatic)
Emaildonald.todd388@example.comCRM crm:C-00388agency-a-snapshot/clients.csv, row 388Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-00388Enrollment enrollment:330
First nameDonaldDonald
Last nameToddTodd
Birth date1944-03-061944-03-06
MBI (last 4 only)*******TX19*******TX19
Street427 Randy ParkwayMissing
CityLake JohnburghMissing
StateOHMissing
ZIP43222Missing
Phone(655) 555-0105Missing
Emaildonald.todd388@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 388agency-a-derived/enrollment_clean.csv, row 330
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
332Mergedcrm:C-00388 and enrollment:330Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphThis person shares a household with Erik Todd.same householdDonald ToddErik Todd

This person shares a household with Erik Todd.

  • Donald Todd (this person)
  • Erik Todd: same household