Golden record

FieldValueTaken fromWhyDeciding tier
First nameAprilEnrollment enrollment:212agency-a-derived/enrollment_clean.csv, row 212Most trusted source (enrollment over CRM)Rules (automatic)
Last nameWheelerEnrollment enrollment:212agency-a-derived/enrollment_clean.csv, row 212Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1948-03-03Enrollment enrollment:212agency-a-derived/enrollment_clean.csv, row 212Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******QX23Enrollment enrollment:212agency-a-derived/enrollment_clean.csv, row 212Most trusted source (enrollment over CRM)Rules (automatic)
Street54152 Randy Inlet Apt. 611CRM crm:C-00252agency-a-snapshot/clients.csv, row 252Most recent recordRules (automatic)
CityEast ThomasbergCRM crm:C-00252agency-a-snapshot/clients.csv, row 252Most recent recordRules (automatic)
StateGACRM crm:C-00252agency-a-snapshot/clients.csv, row 252Most recent recordRules (automatic)
ZIP30600CRM crm:C-00252agency-a-snapshot/clients.csv, row 252Most recent recordRules (automatic)
Phone(961) 555-0147CRM crm:C-00252agency-a-snapshot/clients.csv, row 252Most recent recordRules (automatic)
Emailapril.wheeler252@example.comCRM crm:C-00252agency-a-snapshot/clients.csv, row 252Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-00252Enrollment enrollment:212
First nameAprilApril
Last nameWheelerWheeler
Birth date1948-03-031948-03-03
MBI (last 4 only)*******QX23*******QX23
Street54152 Randy Inlet Apt. 611Missing
CityEast ThomasbergMissing
StateGAMissing
ZIP30600Missing
Phone(961) 555-0147Missing
Emailapril.wheeler252@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 252agency-a-derived/enrollment_clean.csv, row 212
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
216Mergedcrm:C-00252 and enrollment:212Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphThis person shares a household with Sean Wheeler.same householdApril WheelerSean Wheeler

This person shares a household with Sean Wheeler.

  • April Wheeler (this person)
  • Sean Wheeler: same household