Golden record

FieldValueTaken fromWhyDeciding tier
First nameGaryEnrollment enrollment:1141agency-a-derived/enrollment_clean.csv, row 1141Most trusted source (enrollment over CRM)Rules (automatic)
Last nameButlerEnrollment enrollment:1141agency-a-derived/enrollment_clean.csv, row 1141Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1940-08-27Enrollment enrollment:1141agency-a-derived/enrollment_clean.csv, row 1141Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******XX27Enrollment enrollment:1141agency-a-derived/enrollment_clean.csv, row 1141Most trusted source (enrollment over CRM)Rules (automatic)
Street541 Morrison UnionCRM crm:C-01246agency-a-snapshot/clients.csv, row 1246Most recent recordRules (automatic)
CitySmithshireCRM crm:C-01246agency-a-snapshot/clients.csv, row 1246Most recent recordRules (automatic)
StateMICRM crm:C-01246agency-a-snapshot/clients.csv, row 1246Most recent recordRules (automatic)
ZIP49789CRM crm:C-01246agency-a-snapshot/clients.csv, row 1246Most recent recordRules (automatic)
Phone(737) 555-0164CRM crm:C-01246agency-a-snapshot/clients.csv, row 1246Most recent recordRules (automatic)
Emailgary.butler1246@example.comCRM crm:C-01246agency-a-snapshot/clients.csv, row 1246Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-01246Enrollment enrollment:1141
First nameGaryGary
Last nameButlerButler
Birth date1940-08-271940-08-27
MBI (last 4 only)*******XX27*******XX27
Street541 Morrison UnionMissing
CitySmithshireMissing
StateMIMissing
ZIP49789Missing
Phone(737) 555-0164Missing
Emailgary.butler1246@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 1246agency-a-derived/enrollment_clean.csv, row 1141
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
1161Mergedcrm:C-01246 and enrollment:1141Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphThis person shares a household with Melissa Butler.same householdGary ButlerMelissa Butler

This person shares a household with Melissa Butler.