Golden record

FieldValueTaken fromWhyDeciding tier
First nameMichelleEnrollment enrollment:1209agency-a-derived/enrollment_clean.csv, row 1209Most trusted source (enrollment over CRM)Rules (automatic)
Last nameHaynesEnrollment enrollment:1209agency-a-derived/enrollment_clean.csv, row 1209Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1939-11-22Enrollment enrollment:1209agency-a-derived/enrollment_clean.csv, row 1209Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******NH84Enrollment enrollment:1209agency-a-derived/enrollment_clean.csv, row 1209Most trusted source (enrollment over CRM)Rules (automatic)
Street6534 Harvey Neck Apt. 707CRM crm:C-01311agency-a-snapshot/clients.csv, row 1311Most recent recordRules (automatic)
CityMichaelviewCRM crm:C-01311agency-a-snapshot/clients.csv, row 1311Most recent recordRules (automatic)
StateMOCRM crm:C-01311agency-a-snapshot/clients.csv, row 1311Most recent recordRules (automatic)
ZIP63400CRM crm:C-01311agency-a-snapshot/clients.csv, row 1311Most recent recordRules (automatic)
Phone(310) 555-0167CRM crm:C-01311agency-a-snapshot/clients.csv, row 1311Most recent recordRules (automatic)
EmailNoneNoneNo record has a valueNone

Member records side by side

FieldCRM crm:C-01311Enrollment enrollment:1209
First nameMichelleMichelle
Last nameHaynesHaynes
Birth date1939-11-221939-11-22
MBI (last 4 only)*******NH84*******NH84
Street6534 Harvey Neck Apt. 707Missing
CityMichaelviewMissing
StateMOMissing
ZIP63400Missing
Phone(310) 555-0167Missing
EmailMissingMissing
Sourceagency-a-snapshot/clients.csv, row 1311agency-a-derived/enrollment_clean.csv, row 1209
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
1229Mergedcrm:C-01311 and enrollment:1209Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Michelle Haynes

Only this person is in the household.

  • Michelle Haynes (this person)