Golden record

FieldValueTaken fromWhyDeciding tier
First nameKatieEnrollment enrollment:544agency-a-derived/enrollment_clean.csv, row 544Most trusted source (enrollment over CRM)Rules (automatic)
Last nameHubbardEnrollment enrollment:544agency-a-derived/enrollment_clean.csv, row 544Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1939-08-01Enrollment enrollment:544agency-a-derived/enrollment_clean.csv, row 544Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******UM07Enrollment enrollment:544agency-a-derived/enrollment_clean.csv, row 544Most trusted source (enrollment over CRM)Rules (automatic)
Street53539 Martinez VillagesCRM crm:C-00617agency-a-snapshot/clients.csv, row 617Most recent recordRules (automatic)
CityHardyviewCRM crm:C-00617agency-a-snapshot/clients.csv, row 617Most recent recordRules (automatic)
StateVACRM crm:C-00617agency-a-snapshot/clients.csv, row 617Most recent recordRules (automatic)
ZIP23928CRM crm:C-00617agency-a-snapshot/clients.csv, row 617Most recent recordRules (automatic)
Phone(592) 555-0177CRM crm:C-00617agency-a-snapshot/clients.csv, row 617Most recent recordRules (automatic)
Emailkatie.hubbard617@example.comCRM crm:C-00617agency-a-snapshot/clients.csv, row 617Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-00617Enrollment enrollment:544
First nameKatieKatie
Last nameHubbardHubbard
Birth date1939-08-011939-08-01
MBI (last 4 only)*******UM07*******UM07
Street53539 Martinez VillagesMissing
CityHardyviewMissing
StateVAMissing
ZIP23928Missing
Phone(592) 555-0177Missing
Emailkatie.hubbard617@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 617agency-a-derived/enrollment_clean.csv, row 544
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
551Mergedcrm:C-00617 and enrollment:544Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Katie Hubbard

Only this person is in the household.

  • Katie Hubbard (this person)