Golden record

FieldValueTaken fromWhyDeciding tier
First nameSaraEnrollment enrollment:466agency-a-derived/enrollment_clean.csv, row 466Most trusted source (enrollment over CRM)Rules (automatic)
Last nameSmithEnrollment enrollment:466agency-a-derived/enrollment_clean.csv, row 466Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1943-10-14Enrollment enrollment:466agency-a-derived/enrollment_clean.csv, row 466Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******QH23Enrollment enrollment:466agency-a-derived/enrollment_clean.csv, row 466Most trusted source (enrollment over CRM)Rules (automatic)
Street41027 Alvarez Mountains Apt. 667CRM crm:C-00535agency-a-snapshot/clients.csv, row 535Most recent recordRules (automatic)
CityDustinchesterCRM crm:C-00535agency-a-snapshot/clients.csv, row 535Most recent recordRules (automatic)
StateDECRM crm:C-00535agency-a-snapshot/clients.csv, row 535Most recent recordRules (automatic)
ZIP19998CRM crm:C-00535agency-a-snapshot/clients.csv, row 535Most recent recordRules (automatic)
Phone(289) 555-0108CRM crm:C-00535agency-a-snapshot/clients.csv, row 535Most recent recordRules (automatic)
Emailsara.smith535@example.comCRM crm:C-00535agency-a-snapshot/clients.csv, row 535Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-00535Enrollment enrollment:466
First nameSaraSara
Last nameSmithSmith
Birth date1943-10-141943-10-14
MBI (last 4 only)*******QH23*******QH23
Street41027 Alvarez Mountains Apt. 667Missing
CityDustinchesterMissing
StateDEMissing
ZIP19998Missing
Phone(289) 555-0108Missing
Emailsara.smith535@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 535agency-a-derived/enrollment_clean.csv, row 466
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
471Mergedcrm:C-00535 and enrollment:466Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Sara Smith

Only this person is in the household.

  • Sara Smith (this person)