Golden record

FieldValueTaken fromWhyDeciding tier
First nameBrendaEnrollment enrollment:1643agency-a-derived/enrollment_clean.csv, row 1643Most trusted source (enrollment over CRM)Rules (automatic)
Last nameLangEnrollment enrollment:1643agency-a-derived/enrollment_clean.csv, row 1643Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1944-05-10Enrollment enrollment:1643agency-a-derived/enrollment_clean.csv, row 1643Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******AW92Enrollment enrollment:1643agency-a-derived/enrollment_clean.csv, row 1643Most trusted source (enrollment over CRM)Rules (automatic)
Street727 Matthew WellCRM crm:C-01783agency-a-snapshot/clients.csv, row 1783Most recent recordRules (automatic)
CityEast ErictonCRM crm:C-01783agency-a-snapshot/clients.csv, row 1783Most recent recordRules (automatic)
StateILCRM crm:C-01783agency-a-snapshot/clients.csv, row 1783Most recent recordRules (automatic)
ZIP60677CRM crm:C-01783agency-a-snapshot/clients.csv, row 1783Most recent recordRules (automatic)
Phone(205) 555-0175CRM crm:C-01783agency-a-snapshot/clients.csv, row 1783Most recent recordRules (automatic)
Emailbrenda.lang1783@example.comCRM crm:C-01783agency-a-snapshot/clients.csv, row 1783Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-01783Enrollment enrollment:1641Enrollment enrollment:1642Enrollment enrollment:1643
First nameBrendaBrendaBrendaBrenda
Last nameLangLangLangLang
Birth date1944-05-101944-05-101944-05-101944-05-10
MBI (last 4 only)*******AW92*******AW92*******AW92*******AW92
Street727 Matthew WellMissingMissingMissing
CityEast ErictonMissingMissingMissing
StateILMissingMissingMissing
ZIP60677MissingMissingMissing
Phone(205) 555-0175MissingMissingMissing
Emailbrenda.lang1783@example.comMissingMissingMissing
Sourceagency-a-snapshot/clients.csv, row 1783agency-a-derived/enrollment_clean.csv, row 1641agency-a-derived/enrollment_clean.csv, row 1642agency-a-derived/enrollment_clean.csv, row 1643
Active policyYesNoNoYes

Merge log lines for this person

LineActionPairTierScoreRule
1667Mergedcrm:C-01783 and enrollment:1641Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)
1668Mergedcrm:C-01783 and enrollment:1642Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)
1669Mergedcrm:C-01783 and enrollment:1643Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)
2003Mergedenrollment:1641 and enrollment:1642Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)
2004Mergedenrollment:1641 and enrollment:1643Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)
2005Mergedenrollment:1642 and enrollment:1643Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Brenda Lang

Only this person is in the household.

  • Brenda Lang (this person)