Golden record

FieldValueTaken fromWhyDeciding tier
First nameBrendaEnrollment enrollment:866agency-a-derived/enrollment_clean.csv, row 866Most trusted source (enrollment over CRM)Rules (automatic)
Last nameLinEnrollment enrollment:866agency-a-derived/enrollment_clean.csv, row 866Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1947-02-22Enrollment enrollment:866agency-a-derived/enrollment_clean.csv, row 866Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******DQ52Enrollment enrollment:866agency-a-derived/enrollment_clean.csv, row 866Most trusted source (enrollment over CRM)Rules (automatic)
Street60787 Christopher Groves Apt. 591CRM crm:C-00962agency-a-snapshot/clients.csv, row 962Most recent recordRules (automatic)
CityArianamouthCRM crm:C-00962agency-a-snapshot/clients.csv, row 962Most recent recordRules (automatic)
StateARCRM crm:C-00962agency-a-snapshot/clients.csv, row 962Most recent recordRules (automatic)
ZIP72893CRM crm:C-00962agency-a-snapshot/clients.csv, row 962Most recent recordRules (automatic)
Phone(307) 555-0151CRM crm:C-00962agency-a-snapshot/clients.csv, row 962Most recent recordRules (automatic)
Emailbrenda.lin962@example.comCRM crm:C-00962agency-a-snapshot/clients.csv, row 962Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-00962Enrollment enrollment:866
First nameBrendaBrenda
Last nameLinLin
Birth date1947-02-221947-02-22
MBI (last 4 only)*******DQ52*******DQ52
Street60787 Christopher Groves Apt. 591Missing
CityArianamouthMissing
StateARMissing
ZIP72893Missing
Phone(307) 555-0151Missing
Emailbrenda.lin962@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 962agency-a-derived/enrollment_clean.csv, row 866
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
882Mergedcrm:C-00962 and enrollment:866Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphThis person shares a household with David Lin.same householdBrenda LinDavid Lin

This person shares a household with David Lin.

  • David Lin: same household
  • Brenda Lin (this person)