Golden record

FieldValueTaken fromWhyDeciding tier
First nameLanceEnrollment enrollment:447agency-a-derived/enrollment_clean.csv, row 447Most trusted source (enrollment over CRM)Rules (automatic)
Last nameDavisEnrollment enrollment:447agency-a-derived/enrollment_clean.csv, row 447Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1955-05-15Enrollment enrollment:447agency-a-derived/enrollment_clean.csv, row 447Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******FF39Enrollment enrollment:447agency-a-derived/enrollment_clean.csv, row 447Most trusted source (enrollment over CRM)Rules (automatic)
Street545 Jennifer Skyway Apt. 792CRM crm:C-00515agency-a-snapshot/clients.csv, row 515Most recent recordRules (automatic)
CityPort LeahmouthCRM crm:C-00515agency-a-snapshot/clients.csv, row 515Most recent recordRules (automatic)
StateFLCRM crm:C-00515agency-a-snapshot/clients.csv, row 515Most recent recordRules (automatic)
ZIP32468CRM crm:C-00515agency-a-snapshot/clients.csv, row 515Most recent recordRules (automatic)
Phone(392) 555-0131CRM crm:C-00515agency-a-snapshot/clients.csv, row 515Most recent recordRules (automatic)
Emaillance.davis515@example.comCRM crm:C-00515agency-a-snapshot/clients.csv, row 515Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-00515Enrollment enrollment:447
First nameLanceLance
Last nameDavisDavis
Birth date1955-05-151955-05-15
MBI (last 4 only)*******FF39*******FF39
Street545 Jennifer Skyway Apt. 792Missing
CityPort LeahmouthMissing
StateFLMissing
ZIP32468Missing
Phone(392) 555-0131Missing
Emaillance.davis515@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 515agency-a-derived/enrollment_clean.csv, row 447
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
452Mergedcrm:C-00515 and enrollment:447Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Lance Davis

Only this person is in the household.

  • Lance Davis (this person)