Golden record

FieldValueTaken fromWhyDeciding tier
First nameNancyEnrollment enrollment:1486agency-a-derived/enrollment_clean.csv, row 1486Most trusted source (enrollment over CRM)Rules (automatic)
Last nameFreyEnrollment enrollment:1486agency-a-derived/enrollment_clean.csv, row 1486Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1952-05-27Enrollment enrollment:1486agency-a-derived/enrollment_clean.csv, row 1486Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******MY63Enrollment enrollment:1486agency-a-derived/enrollment_clean.csv, row 1486Most trusted source (enrollment over CRM)Rules (automatic)
Street860 Kathleen Plain Apt. 179CRM crm:C-01623agency-a-snapshot/clients.csv, row 1623Most recent recordRules (automatic)
CityOlsonfortCRM crm:C-01623agency-a-snapshot/clients.csv, row 1623Most recent recordRules (automatic)
StateMOCRM crm:C-01623agency-a-snapshot/clients.csv, row 1623Most recent recordRules (automatic)
ZIP65521CRM crm:C-01623agency-a-snapshot/clients.csv, row 1623Most recent recordRules (automatic)
Phone(455) 555-0158CRM crm:C-01623agency-a-snapshot/clients.csv, row 1623Most recent recordRules (automatic)
Emailnancy.frey1623@example.comCRM crm:C-01623agency-a-snapshot/clients.csv, row 1623Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-01623Enrollment enrollment:1486
First nameNancyNancy
Last nameFreyFrey
Birth date1952-05-271952-05-27
MBI (last 4 only)*******MY63*******MY63
Street860 Kathleen Plain Apt. 179Missing
CityOlsonfortMissing
StateMOMissing
ZIP65521Missing
Phone(455) 555-0158Missing
Emailnancy.frey1623@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 1623agency-a-derived/enrollment_clean.csv, row 1486
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
1509Mergedcrm:C-01623 and enrollment:1486Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphThis person shares a household with David Frey.same householdNancy FreyDavid Frey

This person shares a household with David Frey.

  • David Frey: same household
  • Nancy Frey (this person)