Golden record

FieldValueTaken fromWhyDeciding tier
First nameCatherineEnrollment enrollment:1616agency-a-derived/enrollment_clean.csv, row 1616Most trusted source (enrollment over CRM)Rules (automatic)
Last nameMurphyEnrollment enrollment:1616agency-a-derived/enrollment_clean.csv, row 1616Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1959-12-10Enrollment enrollment:1616agency-a-derived/enrollment_clean.csv, row 1616Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******VA95Enrollment enrollment:1616agency-a-derived/enrollment_clean.csv, row 1616Most trusted source (enrollment over CRM)Rules (automatic)
Street9743 Wiley Greens Apt. 882CRM crm:C-01760agency-a-snapshot/clients.csv, row 1760Most recent recordRules (automatic)
CityEast BrandonCRM crm:C-01760agency-a-snapshot/clients.csv, row 1760Most recent recordRules (automatic)
StateMTCRM crm:C-01760agency-a-snapshot/clients.csv, row 1760Most recent recordRules (automatic)
ZIP59618CRM crm:C-01760agency-a-snapshot/clients.csv, row 1760Most recent recordRules (automatic)
Phone(282) 555-0169CRM crm:C-01760agency-a-snapshot/clients.csv, row 1760Most recent recordRules (automatic)
Emailcatherine.murphy1760@example.comCRM crm:C-01760agency-a-snapshot/clients.csv, row 1760Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-01760Enrollment enrollment:1616
First nameCatherineCatherine
Last nameMurphyMurphy
Birth date1959-12-101959-12-10
MBI (last 4 only)*******VA95*******VA95
Street9743 Wiley Greens Apt. 882Missing
CityEast BrandonMissing
StateMTMissing
ZIP59618Missing
Phone(282) 555-0169Missing
Emailcatherine.murphy1760@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 1760agency-a-derived/enrollment_clean.csv, row 1616
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
1643Mergedcrm:C-01760 and enrollment:1616Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphThis person shares a household with Robert Murphy.same householdCatherine MurphyRobert Murphy

This person shares a household with Robert Murphy.