Golden record

FieldValueTaken fromWhyDeciding tier
First nameMichaelEnrollment enrollment:369agency-a-derived/enrollment_clean.csv, row 369Most trusted source (enrollment over CRM)Rules (automatic)
Last nameCollinsEnrollment enrollment:369agency-a-derived/enrollment_clean.csv, row 369Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1948-11-21Enrollment enrollment:369agency-a-derived/enrollment_clean.csv, row 369Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******JD16Enrollment enrollment:369agency-a-derived/enrollment_clean.csv, row 369Most trusted source (enrollment over CRM)Rules (automatic)
Street7784 Taylor Square Apt. 997CRM crm:C-00431agency-a-snapshot/clients.csv, row 431Most recent recordRules (automatic)
CityMillssideCRM crm:C-00431agency-a-snapshot/clients.csv, row 431Most recent recordRules (automatic)
StateARCRM crm:C-00431agency-a-snapshot/clients.csv, row 431Most recent recordRules (automatic)
ZIP72060CRM crm:C-00431agency-a-snapshot/clients.csv, row 431Most recent recordRules (automatic)
Phone(299) 555-0161CRM crm:C-00431agency-a-snapshot/clients.csv, row 431Most recent recordRules (automatic)
Emailmichael.collins431@example.comCRM crm:C-00431agency-a-snapshot/clients.csv, row 431Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-00431Enrollment enrollment:369
First nameMichaelMichael
Last nameCollinsCollins
Birth date1948-11-211948-11-21
MBI (last 4 only)*******JD16*******JD16
Street7784 Taylor Square Apt. 997Missing
CityMillssideMissing
StateARMissing
ZIP72060Missing
Phone(299) 555-0161Missing
Emailmichael.collins431@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 431agency-a-derived/enrollment_clean.csv, row 369
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
370Mergedcrm:C-00431 and enrollment:369Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Michael Collins

Only this person is in the household.

  • Michael Collins (this person)