Golden record

FieldValueTaken fromWhyDeciding tier
First nameKathyEnrollment enrollment:886agency-a-derived/enrollment_clean.csv, row 886Most trusted source (enrollment over CRM)Rules (automatic)
Last nameCookEnrollment enrollment:886agency-a-derived/enrollment_clean.csv, row 886Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1952-05-15Enrollment enrollment:886agency-a-derived/enrollment_clean.csv, row 886Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******JR88Enrollment enrollment:886agency-a-derived/enrollment_clean.csv, row 886Most trusted source (enrollment over CRM)Rules (automatic)
Street197 Delgado BypassCRM crm:C-00983agency-a-snapshot/clients.csv, row 983Most recent recordRules (automatic)
CityRobertboroughCRM crm:C-00983agency-a-snapshot/clients.csv, row 983Most recent recordRules (automatic)
StateARCRM crm:C-00983agency-a-snapshot/clients.csv, row 983Most recent recordRules (automatic)
ZIP72001CRM crm:C-00983agency-a-snapshot/clients.csv, row 983Most recent recordRules (automatic)
Phone(820) 555-0199CRM crm:C-00983agency-a-snapshot/clients.csv, row 983Most recent recordRules (automatic)
Emailkathy.cook983@example.comCRM crm:C-00983agency-a-snapshot/clients.csv, row 983Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-00983Enrollment enrollment:885Enrollment enrollment:886
First nameKathyKathyKathy
Last nameCookCookCook
Birth date1952-05-151952-05-151952-05-15
MBI (last 4 only)*******JR88*******JR88*******JR88
Street197 Delgado BypassMissingMissing
CityRobertboroughMissingMissing
StateARMissingMissing
ZIP72001MissingMissing
Phone(820) 555-0199MissingMissing
Emailkathy.cook983@example.comMissingMissing
Sourceagency-a-snapshot/clients.csv, row 983agency-a-derived/enrollment_clean.csv, row 885agency-a-derived/enrollment_clean.csv, row 886
Active policyYesNoYes

Merge log lines for this person

LineActionPairTierScoreRule
901Mergedcrm:C-00983 and enrollment:885Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)
902Mergedcrm:C-00983 and enrollment:886Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)
2143Mergedenrollment:885 and enrollment:886Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Kathy Cook

Only this person is in the household.

  • Kathy Cook (this person)