Golden record

FieldValueTaken fromWhyDeciding tier
First nameKristineEnrollment enrollment:805agency-a-derived/enrollment_clean.csv, row 805Most trusted source (enrollment over CRM)Rules (automatic)
Last nameBrownEnrollment enrollment:805agency-a-derived/enrollment_clean.csv, row 805Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1946-12-09Enrollment enrollment:805agency-a-derived/enrollment_clean.csv, row 805Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******CG30Enrollment enrollment:805agency-a-derived/enrollment_clean.csv, row 805Most trusted source (enrollment over CRM)Rules (automatic)
Street737 Joshua Camp Apt. 723CRM crm:C-00900agency-a-snapshot/clients.csv, row 900Most recent recordRules (automatic)
CityAshleyfurtCRM crm:C-00900agency-a-snapshot/clients.csv, row 900Most recent recordRules (automatic)
StateGACRM crm:C-00900agency-a-snapshot/clients.csv, row 900Most recent recordRules (automatic)
ZIP31758CRM crm:C-00900agency-a-snapshot/clients.csv, row 900Most recent recordRules (automatic)
Phone(451) 555-0192CRM crm:C-00900agency-a-snapshot/clients.csv, row 900Most recent recordRules (automatic)
Emailkristine.brown900@example.comCRM crm:C-00900agency-a-snapshot/clients.csv, row 900Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-00900Enrollment enrollment:805
First nameKristineKristine
Last nameBrownBrown
Birth date1946-12-091946-12-09
MBI (last 4 only)*******CG30*******CG30
Street737 Joshua Camp Apt. 723Missing
CityAshleyfurtMissing
StateGAMissing
ZIP31758Missing
Phone(451) 555-0192Missing
Emailkristine.brown900@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 900agency-a-derived/enrollment_clean.csv, row 805
Active policyNoNo

Merge log lines for this person

LineActionPairTierScoreRule
819Mergedcrm:C-00900 and enrollment:805Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphThis person shares a household with Lindsey Brown.same householdKristine BrownLindsey Brown

This person shares a household with Lindsey Brown.

  • Lindsey Brown: same household
  • Kristine Brown (this person)