Golden record

FieldValueTaken fromWhyDeciding tier
First nameChristopherEnrollment enrollment:1344agency-a-derived/enrollment_clean.csv, row 1344Most trusted source (enrollment over CRM)Rules (automatic)
Last nameJohnsonEnrollment enrollment:1344agency-a-derived/enrollment_clean.csv, row 1344Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1948-05-10Enrollment enrollment:1344agency-a-derived/enrollment_clean.csv, row 1344Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******PG57Enrollment enrollment:1344agency-a-derived/enrollment_clean.csv, row 1344Most trusted source (enrollment over CRM)Rules (automatic)
Street4026 Jennifer Land Suite 824CRM crm:C-01463agency-a-snapshot/clients.csv, row 1463Most recent recordRules (automatic)
CityPort RhondaCRM crm:C-01463agency-a-snapshot/clients.csv, row 1463Most recent recordRules (automatic)
StateVACRM crm:C-01463agency-a-snapshot/clients.csv, row 1463Most recent recordRules (automatic)
ZIP22996CRM crm:C-01463agency-a-snapshot/clients.csv, row 1463Most recent recordRules (automatic)
Phone(677) 555-0108CRM crm:C-01463agency-a-snapshot/clients.csv, row 1463Most recent recordRules (automatic)
Emailchristopher.johnson1463@example.comCRM crm:C-01463agency-a-snapshot/clients.csv, row 1463Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-01463Enrollment enrollment:1344
First nameChristopherChristopher
Last nameJohnsonJohnson
Birth date1948-05-101948-05-10
MBI (last 4 only)*******PG57*******PG57
Street4026 Jennifer Land Suite 824Missing
CityPort RhondaMissing
StateVAMissing
ZIP22996Missing
Phone(677) 555-0108Missing
Emailchristopher.johnson1463@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 1463agency-a-derived/enrollment_clean.csv, row 1344
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
1365Mergedcrm:C-01463 and enrollment:1344Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Christopher Johnson

Only this person is in the household.

  • Christopher Johnson (this person)