Golden record

FieldValueTaken fromWhyDeciding tier
First nameDavidEnrollment enrollment:299agency-a-derived/enrollment_clean.csv, row 299Most trusted source (enrollment over CRM)Rules (automatic)
Last nameWestEnrollment enrollment:299agency-a-derived/enrollment_clean.csv, row 299Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1944-10-07Enrollment enrollment:299agency-a-derived/enrollment_clean.csv, row 299Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******NR03Enrollment enrollment:299agency-a-derived/enrollment_clean.csv, row 299Most trusted source (enrollment over CRM)Rules (automatic)
Street0838 Powell Freeway Apt. 779CRM crm:C-00350agency-a-snapshot/clients.csv, row 350Most recent recordRules (automatic)
CityMillerfortCRM crm:C-00350agency-a-snapshot/clients.csv, row 350Most recent recordRules (automatic)
StateVTCRM crm:C-00350agency-a-snapshot/clients.csv, row 350Most recent recordRules (automatic)
ZIP05049CRM crm:C-00350agency-a-snapshot/clients.csv, row 350Most recent recordRules (automatic)
Phone(985) 555-0148CRM crm:C-00350agency-a-snapshot/clients.csv, row 350Most recent recordRules (automatic)
Emaildavid.west350@example.comCRM crm:C-00350agency-a-snapshot/clients.csv, row 350Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-00350Enrollment enrollment:298Enrollment enrollment:299
First nameDavidDavidDavid
Last nameWestWestWest
Birth date1944-10-071944-10-071944-10-07
MBI (last 4 only)*******NR03*******NR03*******NR03
Street0838 Powell Freeway Apt. 779MissingMissing
CityMillerfortMissingMissing
StateVTMissingMissing
ZIP05049MissingMissing
Phone(985) 555-0148MissingMissing
Emaildavid.west350@example.comMissingMissing
Sourceagency-a-snapshot/clients.csv, row 350agency-a-derived/enrollment_clean.csv, row 298agency-a-derived/enrollment_clean.csv, row 299
Active policyYesNoYes

Merge log lines for this person

LineActionPairTierScoreRule
300Mergedcrm:C-00350 and enrollment:298Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)
301Mergedcrm:C-00350 and enrollment:299Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)
2059Mergedenrollment:298 and enrollment:299Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphThis person shares a household with Tyler West.same householdDavid WestTyler West

This person shares a household with Tyler West.

  • David West (this person)
  • Tyler West: same household