Golden record

FieldValueTaken fromWhyDeciding tier
First nameChristopherEnrollment enrollment:648agency-a-derived/enrollment_clean.csv, row 648Most trusted source (enrollment over CRM)Rules (automatic)
Last nameRileyEnrollment enrollment:648agency-a-derived/enrollment_clean.csv, row 648Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1953-09-24Enrollment enrollment:648agency-a-derived/enrollment_clean.csv, row 648Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******QQ19Enrollment enrollment:648agency-a-derived/enrollment_clean.csv, row 648Most trusted source (enrollment over CRM)Rules (automatic)
Street3173 Wall View Suite 831CRM crm:C-00733agency-a-snapshot/clients.csv, row 733Most recent recordRules (automatic)
CityDuranmouthCRM crm:C-00733agency-a-snapshot/clients.csv, row 733Most recent recordRules (automatic)
StateNECRM crm:C-00733agency-a-snapshot/clients.csv, row 733Most recent recordRules (automatic)
ZIP68595CRM crm:C-00733agency-a-snapshot/clients.csv, row 733Most recent recordRules (automatic)
Phone(309) 555-0170CRM crm:C-00733agency-a-snapshot/clients.csv, row 733Most recent recordRules (automatic)
EmailNoneNoneNo record has a valueNone

Member records side by side

FieldCRM crm:C-00733Enrollment enrollment:648
First nameChristopherChristopher
Last nameRileyRiley
Birth date1953-09-241953-09-24
MBI (last 4 only)*******QQ19*******QQ19
Street3173 Wall View Suite 831Missing
CityDuranmouthMissing
StateNEMissing
ZIP68595Missing
Phone(309) 555-0170Missing
EmailMissingMissing
Sourceagency-a-snapshot/clients.csv, row 733agency-a-derived/enrollment_clean.csv, row 648
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
659Mergedcrm:C-00733 and enrollment:648Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Christopher Riley

Only this person is in the household.

  • Christopher Riley (this person)