Golden record

FieldValueTaken fromWhyDeciding tier
First nameAngelaEnrollment enrollment:169agency-a-derived/enrollment_clean.csv, row 169Most trusted source (enrollment over CRM)Rules (automatic)
Last nameSmithEnrollment enrollment:169agency-a-derived/enrollment_clean.csv, row 169Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1954-03-30Enrollment enrollment:169agency-a-derived/enrollment_clean.csv, row 169Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******NF13Enrollment enrollment:169agency-a-derived/enrollment_clean.csv, row 169Most trusted source (enrollment over CRM)Rules (automatic)
Street771 Gill Island Apt. 556CRM crm:C-00205agency-a-snapshot/clients.csv, row 205Most recent recordRules (automatic)
CityNew MichellebergCRM crm:C-00205agency-a-snapshot/clients.csv, row 205Most recent recordRules (automatic)
StateCOCRM crm:C-00205agency-a-snapshot/clients.csv, row 205Most recent recordRules (automatic)
ZIP80371CRM crm:C-00205agency-a-snapshot/clients.csv, row 205Most recent recordRules (automatic)
Phone(243) 555-0164CRM crm:C-00205agency-a-snapshot/clients.csv, row 205Most recent recordRules (automatic)
Emailangela.smith205@example.comCRM crm:C-00205agency-a-snapshot/clients.csv, row 205Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-00205Enrollment enrollment:169
First nameAngelaAngela
Last nameSmithSmith
Birth date1954-03-301954-03-30
MBI (last 4 only)*******NF13*******NF13
Street771 Gill Island Apt. 556Missing
CityNew MichellebergMissing
StateCOMissing
ZIP80371Missing
Phone(243) 555-0164Missing
Emailangela.smith205@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 205agency-a-derived/enrollment_clean.csv, row 169
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
173Mergedcrm:C-00205 and enrollment:169Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Angela Smith

Only this person is in the household.

  • Angela Smith (this person)