Golden record

FieldValueTaken fromWhyDeciding tier
First nameThomasEnrollment enrollment:592agency-a-derived/enrollment_clean.csv, row 592Most trusted source (enrollment over CRM)Rules (automatic)
Last nameJacksonEnrollment enrollment:592agency-a-derived/enrollment_clean.csv, row 592Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1956-07-07Enrollment enrollment:592agency-a-derived/enrollment_clean.csv, row 592Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******JF20Enrollment enrollment:592agency-a-derived/enrollment_clean.csv, row 592Most trusted source (enrollment over CRM)Rules (automatic)
Street452 Jacob Summit Suite 168CRM crm:C-00672agency-a-snapshot/clients.csv, row 672Most recent recordRules (automatic)
CityNorth RandalltownCRM crm:C-00672agency-a-snapshot/clients.csv, row 672Most recent recordRules (automatic)
StateCTCRM crm:C-00672agency-a-snapshot/clients.csv, row 672Most recent recordRules (automatic)
ZIP06406CRM crm:C-00672agency-a-snapshot/clients.csv, row 672Most recent recordRules (automatic)
Phone(689) 555-0120CRM crm:C-00672agency-a-snapshot/clients.csv, row 672Most recent recordRules (automatic)
Emailthomas.jackson672@example.comCRM crm:C-00672agency-a-snapshot/clients.csv, row 672Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-00672Enrollment enrollment:592
First nameThomasThomas
Last nameJacksonJackson
Birth date1956-07-071956-07-07
MBI (last 4 only)*******JF20*******JF20
Street452 Jacob Summit Suite 168Missing
CityNorth RandalltownMissing
StateCTMissing
ZIP06406Missing
Phone(689) 555-0120Missing
Emailthomas.jackson672@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 672agency-a-derived/enrollment_clean.csv, row 592
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
600Mergedcrm:C-00672 and enrollment:592Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Thomas Jackson

Only this person is in the household.

  • Thomas Jackson (this person)