Golden record

FieldValueTaken fromWhyDeciding tier
First nameElizabethEnrollment enrollment:1363agency-a-derived/enrollment_clean.csv, row 1363Most trusted source (enrollment over CRM)Rules (automatic)
Last nameBrownEnrollment enrollment:1363agency-a-derived/enrollment_clean.csv, row 1363Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1936-06-05Enrollment enrollment:1363agency-a-derived/enrollment_clean.csv, row 1363Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******KP68Enrollment enrollment:1363agency-a-derived/enrollment_clean.csv, row 1363Most trusted source (enrollment over CRM)Rules (automatic)
Street8826 Jason RueCRM crm:C-01481agency-a-snapshot/clients.csv, row 1481Most recent recordRules (automatic)
CityChristinavilleCRM crm:C-01481agency-a-snapshot/clients.csv, row 1481Most recent recordRules (automatic)
StateILCRM crm:C-01481agency-a-snapshot/clients.csv, row 1481Most recent recordRules (automatic)
ZIP61532CRM crm:C-01481agency-a-snapshot/clients.csv, row 1481Most recent recordRules (automatic)
Phone(496) 555-0132CRM crm:C-01481agency-a-snapshot/clients.csv, row 1481Most recent recordRules (automatic)
Emailelizabeth.brown1481@example.comCRM crm:C-01481agency-a-snapshot/clients.csv, row 1481Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-01481CRM crm:C-02006Enrollment enrollment:1362Enrollment enrollment:1363
First nameElizabethElizabethElizabethElizabeth
Last nameBrownBrownBrownBrown
Birth date1936-06-051936-06-051936-06-051936-06-05
MBI (last 4 only)*******KP68*******KP68*******KP68*******KP68
Street8826 Jason Rue8826 Jason RueMissingMissing
CityChristinavilleChristinavilleMissingMissing
StateILILMissingMissing
ZIP6153261532MissingMissing
Phone(496) 555-0132(496) 555-0132MissingMissing
Emailelizabeth.brown1481@example.comMissingMissingMissing
Sourceagency-a-snapshot/clients.csv, row 1481agency-a-snapshot/clients.csv, row 2006agency-a-derived/enrollment_clean.csv, row 1362agency-a-derived/enrollment_clean.csv, row 1363
Active policyYesNoNoYes

Merge log lines for this person

LineActionPairTierScoreRule
1383Mergedcrm:C-01481 and crm:C-02006Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)
1384Mergedcrm:C-01481 and enrollment:1362Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)
1385Mergedcrm:C-01481 and enrollment:1363Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)
1884Mergedcrm:C-02006 and enrollment:1362Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)
1885Mergedcrm:C-02006 and enrollment:1363Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)
1967Mergedenrollment:1362 and enrollment:1363Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Elizabeth Brown

Only this person is in the household.

  • Elizabeth Brown (this person)