Golden record

FieldValueTaken fromWhyDeciding tier
First nameKaylaEnrollment enrollment:1120agency-a-derived/enrollment_clean.csv, row 1120Most trusted source (enrollment over CRM)Rules (automatic)
Last nameRamosEnrollment enrollment:1120agency-a-derived/enrollment_clean.csv, row 1120Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1958-01-08Enrollment enrollment:1120agency-a-derived/enrollment_clean.csv, row 1120Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******MX03Enrollment enrollment:1120agency-a-derived/enrollment_clean.csv, row 1120Most trusted source (enrollment over CRM)Rules (automatic)
Street1130 Lopez Track Apt. 369CRM crm:C-01223agency-a-snapshot/clients.csv, row 1223Most recent recordRules (automatic)
CitySamuelbergCRM crm:C-01223agency-a-snapshot/clients.csv, row 1223Most recent recordRules (automatic)
StateIDCRM crm:C-01223agency-a-snapshot/clients.csv, row 1223Most recent recordRules (automatic)
ZIP83504CRM crm:C-01223agency-a-snapshot/clients.csv, row 1223Most recent recordRules (automatic)
Phone(441) 555-0164CRM crm:C-01223agency-a-snapshot/clients.csv, row 1223Most recent recordRules (automatic)
Emailkayla.ramos1223@example.comCRM crm:C-01223agency-a-snapshot/clients.csv, row 1223Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-01223Enrollment enrollment:1119Enrollment enrollment:1120
First nameKaylaKaylaKayla
Last nameRamosRamosRamos
Birth date1958-01-081958-01-081958-01-08
MBI (last 4 only)*******MX03*******MX03*******MX03
Street1130 Lopez Track Apt. 369MissingMissing
CitySamuelbergMissingMissing
StateIDMissingMissing
ZIP83504MissingMissing
Phone(441) 555-0164MissingMissing
Emailkayla.ramos1223@example.comMissingMissing
Sourceagency-a-snapshot/clients.csv, row 1223agency-a-derived/enrollment_clean.csv, row 1119agency-a-derived/enrollment_clean.csv, row 1120
Active policyYesNoYes

Merge log lines for this person

LineActionPairTierScoreRule
1138Mergedcrm:C-01223 and enrollment:1119Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)
1139Mergedcrm:C-01223 and enrollment:1120Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)
1934Mergedenrollment:1119 and enrollment:1120Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphThis person shares a household with Elizabeth Ramos.same householdKayla RamosElizabeth Ramos

This person shares a household with Elizabeth Ramos.

  • Kayla Ramos (this person)
  • Elizabeth Ramos: same household