Golden record

FieldValueTaken fromWhyDeciding tier
First nameRaymondEnrollment enrollment:123agency-a-derived/enrollment_clean.csv, row 123Most trusted source (enrollment over CRM)Rules (automatic)
Last nameBerryEnrollment enrollment:123agency-a-derived/enrollment_clean.csv, row 123Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1954-02-21Enrollment enrollment:123agency-a-derived/enrollment_clean.csv, row 123Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******AU81Enrollment enrollment:123agency-a-derived/enrollment_clean.csv, row 123Most trusted source (enrollment over CRM)Rules (automatic)
Street55690 Erika LandCRM crm:C-00145agency-a-snapshot/clients.csv, row 145Most recent recordRules (automatic)
CityScottlandCRM crm:C-00145agency-a-snapshot/clients.csv, row 145Most recent recordRules (automatic)
StateSDCRM crm:C-00145agency-a-snapshot/clients.csv, row 145Most recent recordRules (automatic)
ZIP57798CRM crm:C-00145agency-a-snapshot/clients.csv, row 145Most recent recordRules (automatic)
Phone(842) 555-0184CRM crm:C-00145agency-a-snapshot/clients.csv, row 145Most recent recordRules (automatic)
Emailraymond.berry145@example.comCRM crm:C-00145agency-a-snapshot/clients.csv, row 145Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-00145Enrollment enrollment:123
First nameRaymondRaymond
Last nameBerryBerry
Birth date1954-02-121954-02-21
MBI (last 4 only)*******AU81*******AU81
Street55690 Erika LandMissing
CityScottlandMissing
StateSDMissing
ZIP57798Missing
Phone(842) 555-0184Missing
Emailraymond.berry145@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 145agency-a-derived/enrollment_clean.csv, row 123
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
127Mergedcrm:C-00145 and enrollment:123Rules (automatic)0.9998AUTO-MATCH-HIGH (Automatic match)

Household

Household graphThis person shares a household with Alyssa Berry.same householdRaymond BerryAlyssa Berry

This person shares a household with Alyssa Berry.

  • Alyssa Berry: same household
  • Raymond Berry (this person)