Golden record

FieldValueTaken fromWhyDeciding tier
First nameGregEnrollment enrollment:488agency-a-derived/enrollment_clean.csv, row 488Most trusted source (enrollment over CRM)Rules (automatic)
Last nameAllenEnrollment enrollment:488agency-a-derived/enrollment_clean.csv, row 488Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1948-05-25Enrollment enrollment:488agency-a-derived/enrollment_clean.csv, row 488Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******UJ83Enrollment enrollment:488agency-a-derived/enrollment_clean.csv, row 488Most trusted source (enrollment over CRM)Rules (automatic)
Street19467 Jamie RouteCRM crm:C-00558agency-a-snapshot/clients.csv, row 558Most recent recordRules (automatic)
CityAlexandrachesterCRM crm:C-00558agency-a-snapshot/clients.csv, row 558Most recent recordRules (automatic)
StateOHCRM crm:C-00558agency-a-snapshot/clients.csv, row 558Most recent recordRules (automatic)
ZIP43408CRM crm:C-00558agency-a-snapshot/clients.csv, row 558Most recent recordRules (automatic)
Phone(328) 555-0171CRM crm:C-00558agency-a-snapshot/clients.csv, row 558Most recent recordRules (automatic)
EmailNoneNoneNo record has a valueNone

Member records side by side

FieldCRM crm:C-00558Enrollment enrollment:488
First nameGregGreg
Last nameAllenAllen
Birth date1948-05-251948-05-25
MBI (last 4 only)*******UJ83*******UJ83
Street19467 Jamie RouteMissing
CityAlexandrachesterMissing
StateOHMissing
ZIP43408Missing
Phone(328) 555-0171Missing
EmailMissingMissing
Sourceagency-a-snapshot/clients.csv, row 558agency-a-derived/enrollment_clean.csv, row 488
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
493Mergedcrm:C-00558 and enrollment:488Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Greg Allen

Only this person is in the household.

  • Greg Allen (this person)