Golden record

FieldValueTaken fromWhyDeciding tier
First nameLisaEnrollment enrollment:202agency-a-derived/enrollment_clean.csv, row 202Most trusted source (enrollment over CRM)Rules (automatic)
Last nameGloverEnrollment enrollment:202agency-a-derived/enrollment_clean.csv, row 202Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1936-09-09Enrollment enrollment:202agency-a-derived/enrollment_clean.csv, row 202Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******RW15Enrollment enrollment:202agency-a-derived/enrollment_clean.csv, row 202Most trusted source (enrollment over CRM)Rules (automatic)
Street74517 Kimberly Freeway Apt. 959CRM crm:C-00242agency-a-snapshot/clients.csv, row 242Most recent recordRules (automatic)
CityMartinbergCRM crm:C-00242agency-a-snapshot/clients.csv, row 242Most recent recordRules (automatic)
StateMOCRM crm:C-00242agency-a-snapshot/clients.csv, row 242Most recent recordRules (automatic)
ZIP65423CRM crm:C-00242agency-a-snapshot/clients.csv, row 242Most recent recordRules (automatic)
Phone(916) 555-0172CRM crm:C-00242agency-a-snapshot/clients.csv, row 242Most recent recordRules (automatic)
EmailNoneNoneNo record has a valueNone

Member records side by side

FieldCRM crm:C-00242Enrollment enrollment:201Enrollment enrollment:202
First nameLisaLisaLisa
Last nameGloverGloverGlover
Birth date1936-09-091936-09-091936-09-09
MBI (last 4 only)*******RW15*******RW15*******RW15
Street74517 Kimberly Freeway Apt. 959MissingMissing
CityMartinbergMissingMissing
StateMOMissingMissing
ZIP65423MissingMissing
Phone(916) 555-0172MissingMissing
EmailMissingMissingMissing
Sourceagency-a-snapshot/clients.csv, row 242agency-a-derived/enrollment_clean.csv, row 201agency-a-derived/enrollment_clean.csv, row 202
Active policyYesNoYes

Merge log lines for this person

LineActionPairTierScoreRule
205Mergedcrm:C-00242 and enrollment:201Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)
206Mergedcrm:C-00242 and enrollment:202Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)
2044Mergedenrollment:201 and enrollment:202Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Lisa Glover

Only this person is in the household.

  • Lisa Glover (this person)