Golden record

FieldValueTaken fromWhyDeciding tier
First nameJamesEnrollment enrollment:490agency-a-derived/enrollment_clean.csv, row 490Most trusted source (enrollment over CRM)Rules (automatic)
Last nameGrantEnrollment enrollment:490agency-a-derived/enrollment_clean.csv, row 490Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1935-07-06Enrollment enrollment:490agency-a-derived/enrollment_clean.csv, row 490Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******FP86Enrollment enrollment:490agency-a-derived/enrollment_clean.csv, row 490Most trusted source (enrollment over CRM)Rules (automatic)
Street279 Courtney TunnelCRM crm:C-00559agency-a-snapshot/clients.csv, row 559Most recent recordRules (automatic)
CityMichaeltownCRM crm:C-00559agency-a-snapshot/clients.csv, row 559Most recent recordRules (automatic)
StateCACRM crm:C-00559agency-a-snapshot/clients.csv, row 559Most recent recordRules (automatic)
ZIP91089CRM crm:C-00559agency-a-snapshot/clients.csv, row 559Most recent recordRules (automatic)
Phone(610) 555-0179CRM crm:C-00559agency-a-snapshot/clients.csv, row 559Most recent recordRules (automatic)
Emailjames.grant559@example.comCRM crm:C-00559agency-a-snapshot/clients.csv, row 559Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-00559Enrollment enrollment:489Enrollment enrollment:490
First nameJamesJamesJames
Last nameGrantGrantGrant
Birth date1935-07-061935-07-061935-07-06
MBI (last 4 only)*******FP86*******FP86*******FP86
Street279 Courtney TunnelMissingMissing
CityMichaeltownMissingMissing
StateCAMissingMissing
ZIP91089MissingMissing
Phone(610) 555-0179MissingMissing
Emailjames.grant559@example.comMissingMissing
Sourceagency-a-snapshot/clients.csv, row 559agency-a-derived/enrollment_clean.csv, row 489agency-a-derived/enrollment_clean.csv, row 490
Active policyYesNoYes

Merge log lines for this person

LineActionPairTierScoreRule
494Mergedcrm:C-00559 and enrollment:489Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)
495Mergedcrm:C-00559 and enrollment:490Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)
2085Mergedenrollment:489 and enrollment:490Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.James Grant

Only this person is in the household.

  • James Grant (this person)