Golden record

FieldValueTaken fromWhyDeciding tier
First nameDebbieEnrollment enrollment:1844agency-a-derived/enrollment_clean.csv, row 1844Most trusted source (enrollment over CRM)Rules (automatic)
Last nameGilmoreEnrollment enrollment:1844agency-a-derived/enrollment_clean.csv, row 1844Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1987-11-01Enrollment enrollment:1844agency-a-derived/enrollment_clean.csv, row 1844Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******TU31Enrollment enrollment:1844agency-a-derived/enrollment_clean.csv, row 1844Most trusted source (enrollment over CRM)Rules (automatic)
Street82562 West PlazaCRM crm:C-01997agency-a-snapshot/clients.csv, row 1997Most recent recordRules (automatic)
CityLopezviewCRM crm:C-01997agency-a-snapshot/clients.csv, row 1997Most recent recordRules (automatic)
StateMECRM crm:C-01997agency-a-snapshot/clients.csv, row 1997Most recent recordRules (automatic)
ZIP04430CRM crm:C-01997agency-a-snapshot/clients.csv, row 1997Most recent recordRules (automatic)
Phone(949) 555-0101CRM crm:C-01997agency-a-snapshot/clients.csv, row 1997Most recent recordRules (automatic)
Emaildebbie.gilmore1997@example.comCRM crm:C-01997agency-a-snapshot/clients.csv, row 1997Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-01997Enrollment enrollment:1844
First nameDebbieDebbie
Last nameGilmoreGilmore
Birth date1987-11-011987-11-01
MBI (last 4 only)*******TU31*******TU31
Street82562 West PlazaMissing
CityLopezviewMissing
StateMEMissing
ZIP04430Missing
Phone(949) 555-0101Missing
Emaildebbie.gilmore1997@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 1997agency-a-derived/enrollment_clean.csv, row 1844
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
1876Mergedcrm:C-01997 and enrollment:1844Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Debbie Gilmore

Only this person is in the household.

  • Debbie Gilmore (this person)