Golden record

FieldValueTaken fromWhyDeciding tier
First nameMichealEnrollment enrollment:1190agency-a-derived/enrollment_clean.csv, row 1190Most trusted source (enrollment over CRM)Rules (automatic)
Last nameAliEnrollment enrollment:1190agency-a-derived/enrollment_clean.csv, row 1190Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1950-02-07Enrollment enrollment:1190agency-a-derived/enrollment_clean.csv, row 1190Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******HG35Enrollment enrollment:1190agency-a-derived/enrollment_clean.csv, row 1190Most trusted source (enrollment over CRM)Rules (automatic)
Street91009 Mercedes HarborCRM crm:C-01295agency-a-snapshot/clients.csv, row 1295Most recent recordRules (automatic)
CityWest SeanshireCRM crm:C-01295agency-a-snapshot/clients.csv, row 1295Most recent recordRules (automatic)
StateSDCRM crm:C-01295agency-a-snapshot/clients.csv, row 1295Most recent recordRules (automatic)
ZIP57697CRM crm:C-01295agency-a-snapshot/clients.csv, row 1295Most recent recordRules (automatic)
Phone(273) 555-0122CRM crm:C-01295agency-a-snapshot/clients.csv, row 1295Most recent recordRules (automatic)
Emailmicheal.ali1295@example.comCRM crm:C-01295agency-a-snapshot/clients.csv, row 1295Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-01295Enrollment enrollment:1190
First nameMichealMicheal
Last nameAliAli
Birth date1950-02-071950-02-07
MBI (last 4 only)*******HG35*******HG35
Street91009 Mercedes HarborMissing
CityWest SeanshireMissing
StateSDMissing
ZIP57697Missing
Phone(273) 555-0122Missing
Emailmicheal.ali1295@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 1295agency-a-derived/enrollment_clean.csv, row 1190
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
1210Mergedcrm:C-01295 and enrollment:1190Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphThis person shares a household with Colton Ali.same householdMicheal AliColton Ali

This person shares a household with Colton Ali.

  • Colton Ali: same household
  • Micheal Ali (this person)