Golden record

FieldValueTaken fromWhyDeciding tier
First nameKeithEnrollment enrollment:687agency-a-derived/enrollment_clean.csv, row 687Most trusted source (enrollment over CRM)Rules (automatic)
Last nameWongEnrollment enrollment:687agency-a-derived/enrollment_clean.csv, row 687Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1937-11-22Enrollment enrollment:687agency-a-derived/enrollment_clean.csv, row 687Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******RJ43Enrollment enrollment:687agency-a-derived/enrollment_clean.csv, row 687Most trusted source (enrollment over CRM)Rules (automatic)
Street97524 Schneider TraceCRM crm:C-00783agency-a-snapshot/clients.csv, row 783Most recent recordRules (automatic)
CityNew LatoyachesterCRM crm:C-00783agency-a-snapshot/clients.csv, row 783Most recent recordRules (automatic)
StateKYCRM crm:C-00783agency-a-snapshot/clients.csv, row 783Most recent recordRules (automatic)
ZIP40836CRM crm:C-00783agency-a-snapshot/clients.csv, row 783Most recent recordRules (automatic)
Phone(859) 555-0111CRM crm:C-00783agency-a-snapshot/clients.csv, row 783Most recent recordRules (automatic)
Emailkeith.wong783@example.comCRM crm:C-00783agency-a-snapshot/clients.csv, row 783Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-00783Enrollment enrollment:687
First nameKeithKeith
Last nameWongWong
Birth date1937-11-221937-11-22
MBI (last 4 only)*******RJ43*******RJ43
Street97524 Schneider TraceMissing
CityNew LatoyachesterMissing
StateKYMissing
ZIP40836Missing
Phone(859) 555-0111Missing
Emailkeith.wong783@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 783agency-a-derived/enrollment_clean.csv, row 687
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
699Mergedcrm:C-00783 and enrollment:687Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Keith Wong

Only this person is in the household.

  • Keith Wong (this person)