Golden record

FieldValueTaken fromWhyDeciding tier
First nameStacyEnrollment enrollment:632agency-a-derived/enrollment_clean.csv, row 632Most trusted source (enrollment over CRM)Rules (automatic)
Last nameGordonEnrollment enrollment:632agency-a-derived/enrollment_clean.csv, row 632Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1939-04-20Enrollment enrollment:632agency-a-derived/enrollment_clean.csv, row 632Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******HH44Enrollment enrollment:632agency-a-derived/enrollment_clean.csv, row 632Most trusted source (enrollment over CRM)Rules (automatic)
Street52654 David Crest Apt. 339CRM crm:C-00715agency-a-snapshot/clients.csv, row 715Most recent recordRules (automatic)
CitySouth WilliamCRM crm:C-00715agency-a-snapshot/clients.csv, row 715Most recent recordRules (automatic)
StateILCRM crm:C-00715agency-a-snapshot/clients.csv, row 715Most recent recordRules (automatic)
ZIP61137CRM crm:C-00715agency-a-snapshot/clients.csv, row 715Most recent recordRules (automatic)
Phone(467) 555-0175CRM crm:C-00715agency-a-snapshot/clients.csv, row 715Most recent recordRules (automatic)
EmailNoneNoneNo record has a valueNone

Member records side by side

FieldCRM crm:C-00715Enrollment enrollment:632
First nameStacyStacy
Last nameGordonGordon
Birth date1939-04-201939-04-20
MBI (last 4 only)*******HH44*******HH44
Street52654 David Crest Apt. 339Missing
CitySouth WilliamMissing
StateILMissing
ZIP61137Missing
Phone(467) 555-0175Missing
EmailMissingMissing
Sourceagency-a-snapshot/clients.csv, row 715agency-a-derived/enrollment_clean.csv, row 632
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
642Mergedcrm:C-00715 and enrollment:632Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Stacy Gordon

Only this person is in the household.

  • Stacy Gordon (this person)