Golden record

FieldValueTaken fromWhyDeciding tier
First nameJohnEnrollment enrollment:1295agency-a-derived/enrollment_clean.csv, row 1295Most trusted source (enrollment over CRM)Rules (automatic)
Last nameVasquezEnrollment enrollment:1295agency-a-derived/enrollment_clean.csv, row 1295Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1937-03-14Enrollment enrollment:1295agency-a-derived/enrollment_clean.csv, row 1295Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)NoneNoneNo record has a valueNone
Street836 Erin WellsCRM crm:C-01415agency-a-snapshot/clients.csv, row 1415Most recent recordRules (automatic)
CityBarbaraboroughCRM crm:C-01415agency-a-snapshot/clients.csv, row 1415Most recent recordRules (automatic)
StateMICRM crm:C-01415agency-a-snapshot/clients.csv, row 1415Most recent recordRules (automatic)
ZIP48486CRM crm:C-01415agency-a-snapshot/clients.csv, row 1415Most recent recordRules (automatic)
Phone(556) 555-0116CRM crm:C-01415agency-a-snapshot/clients.csv, row 1415Most recent recordRules (automatic)
Emailjohn.vasquez1415@example.comCRM crm:C-01415agency-a-snapshot/clients.csv, row 1415Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-01415Enrollment enrollment:1295
First nameJohnJohn
Last nameVasquezVasquez
Birth date1937-03-141937-03-14
MBI (last 4 only)MissingMissing
Street836 Erin WellsMissing
CityBarbaraboroughMissing
StateMIMissing
ZIP48486Missing
Phone(556) 555-0116Missing
Emailjohn.vasquez1415@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 1415agency-a-derived/enrollment_clean.csv, row 1295
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
1315Mergedcrm:C-01415 and enrollment:1295Rules (automatic)0.9975AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.John Vasquez

Only this person is in the household.

  • John Vasquez (this person)