Golden record

FieldValueTaken fromWhyDeciding tier
First nameMarthaEnrollment enrollment:1648agency-a-derived/enrollment_clean.csv, row 1648Most trusted source (enrollment over CRM)Rules (automatic)
Last nameWileyEnrollment enrollment:1648agency-a-derived/enrollment_clean.csv, row 1648Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1939-10-30Enrollment enrollment:1648agency-a-derived/enrollment_clean.csv, row 1648Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******KN48Enrollment enrollment:1648agency-a-derived/enrollment_clean.csv, row 1648Most trusted source (enrollment over CRM)Rules (automatic)
Street65496 Regina Streets Apt. 833CRM crm:C-01789agency-a-snapshot/clients.csv, row 1789Most recent recordRules (automatic)
CityKellymouthCRM crm:C-01789agency-a-snapshot/clients.csv, row 1789Most recent recordRules (automatic)
StateDECRM crm:C-01789agency-a-snapshot/clients.csv, row 1789Most recent recordRules (automatic)
ZIP19978CRM crm:C-01789agency-a-snapshot/clients.csv, row 1789Most recent recordRules (automatic)
Phone(505) 555-0108CRM crm:C-01789agency-a-snapshot/clients.csv, row 1789Most recent recordRules (automatic)
Emailmartha.wiley1789@example.comCRM crm:C-01789agency-a-snapshot/clients.csv, row 1789Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-01789Enrollment enrollment:1648
First nameMarthaMartha
Last nameWileyWiley
Birth date1939-10-301939-10-30
MBI (last 4 only)*******KN48*******KN48
Street65496 Regina Streets Apt. 833Missing
CityKellymouthMissing
StateDEMissing
ZIP19978Missing
Phone(505) 555-0108Missing
Emailmartha.wiley1789@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 1789agency-a-derived/enrollment_clean.csv, row 1648
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
1675Mergedcrm:C-01789 and enrollment:1648Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Martha Wiley

Only this person is in the household.

  • Martha Wiley (this person)