Golden record

FieldValueTaken fromWhyDeciding tier
First nameDanielleEnrollment enrollment:1489agency-a-derived/enrollment_clean.csv, row 1489Most trusted source (enrollment over CRM)Rules (automatic)
Last nameSparksEnrollment enrollment:1489agency-a-derived/enrollment_clean.csv, row 1489Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1939-10-30Enrollment enrollment:1489agency-a-derived/enrollment_clean.csv, row 1489Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******GD89Enrollment enrollment:1489agency-a-derived/enrollment_clean.csv, row 1489Most trusted source (enrollment over CRM)Rules (automatic)
Street957 Sarah GrovesCRM crm:C-01625agency-a-snapshot/clients.csv, row 1625Most recent recordRules (automatic)
CityTaylorchesterCRM crm:C-01625agency-a-snapshot/clients.csv, row 1625Most recent recordRules (automatic)
StateDECRM crm:C-01625agency-a-snapshot/clients.csv, row 1625Most recent recordRules (automatic)
ZIP19941CRM crm:C-01625agency-a-snapshot/clients.csv, row 1625Most recent recordRules (automatic)
Phone(724) 555-0138CRM crm:C-01625agency-a-snapshot/clients.csv, row 1625Most recent recordRules (automatic)
EmailNoneNoneNo record has a valueNone

Member records side by side

FieldCRM crm:C-01625Enrollment enrollment:1489
First nameDanielleDanielle
Last nameSparksSparks
Birth date1939-10-031939-10-30
MBI (last 4 only)*******GD89*******GD89
Street957 Sarah GrovesMissing
CityTaylorchesterMissing
StateDEMissing
ZIP19941Missing
Phone(724) 555-0138Missing
EmailMissingMissing
Sourceagency-a-snapshot/clients.csv, row 1625agency-a-derived/enrollment_clean.csv, row 1489
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
1512Mergedcrm:C-01625 and enrollment:1489Rules (automatic)0.9998AUTO-MATCH-HIGH (Automatic match)

Household

Household graphThis person shares a household with Melissa Sparks.same householdDanielle SparksMelissa Sparks

This person shares a household with Melissa Sparks.