Golden record

FieldValueTaken fromWhyDeciding tier
First nameRobertEnrollment enrollment:1615agency-a-derived/enrollment_clean.csv, row 1615Most trusted source (enrollment over CRM)Rules (automatic)
Last nameMurphyEnrollment enrollment:1615agency-a-derived/enrollment_clean.csv, row 1615Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1948-10-05Enrollment enrollment:1615agency-a-derived/enrollment_clean.csv, row 1615Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******PQ57Enrollment enrollment:1615agency-a-derived/enrollment_clean.csv, row 1615Most trusted source (enrollment over CRM)Rules (automatic)
Street9743 Wiley Greens Apt. 882CRM crm:C-01759agency-a-snapshot/clients.csv, row 1759Most recent recordRules (automatic)
CityEast BrandonCRM crm:C-01759agency-a-snapshot/clients.csv, row 1759Most recent recordRules (automatic)
StateMTCRM crm:C-01759agency-a-snapshot/clients.csv, row 1759Most recent recordRules (automatic)
ZIP59618CRM crm:C-01759agency-a-snapshot/clients.csv, row 1759Most recent recordRules (automatic)
Phone(226) 555-0142CRM crm:C-01759agency-a-snapshot/clients.csv, row 1759Most recent recordRules (automatic)
EmailNoneNoneNo record has a valueNone

Member records side by side

FieldCRM crm:C-01759Enrollment enrollment:1615
First nameRobertRobert
Last nameMurphyMurphy
Birth date1948-10-051948-10-05
MBI (last 4 only)*******PQ57*******PQ57
Street9743 Wiley Greens Apt. 882Missing
CityEast BrandonMissing
StateMTMissing
ZIP59618Missing
Phone(226) 555-0142Missing
EmailMissingMissing
Sourceagency-a-snapshot/clients.csv, row 1759agency-a-derived/enrollment_clean.csv, row 1615
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
1642Mergedcrm:C-01759 and enrollment:1615Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphThis person shares a household with Catherine Murphy.same householdRobert MurphyCatherine Murphy

This person shares a household with Catherine Murphy.