Golden record

FieldValueTaken fromWhyDeciding tier
First nameLauraEnrollment enrollment:1733agency-a-derived/enrollment_clean.csv, row 1733Most trusted source (enrollment over CRM)Rules (automatic)
Last nameWilkinsonEnrollment enrollment:1733agency-a-derived/enrollment_clean.csv, row 1733Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1950-12-17Enrollment enrollment:1733agency-a-derived/enrollment_clean.csv, row 1733Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******PQ96Enrollment enrollment:1733agency-a-derived/enrollment_clean.csv, row 1733Most trusted source (enrollment over CRM)Rules (automatic)
Street98726 Glenn Ports Suite 322CRM crm:C-01884agency-a-snapshot/clients.csv, row 1884Most recent recordRules (automatic)
CityChristianfortCRM crm:C-01884agency-a-snapshot/clients.csv, row 1884Most recent recordRules (automatic)
StateIACRM crm:C-01884agency-a-snapshot/clients.csv, row 1884Most recent recordRules (automatic)
ZIP51560CRM crm:C-01884agency-a-snapshot/clients.csv, row 1884Most recent recordRules (automatic)
Phone(225) 555-0184CRM crm:C-01884agency-a-snapshot/clients.csv, row 1884Most recent recordRules (automatic)
Emaillaura.wilkinson1884@example.comCRM crm:C-01884agency-a-snapshot/clients.csv, row 1884Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-01884Enrollment enrollment:1733
First nameLauraLaura
Last nameWilkinsonWilkinson
Birth date1950-12-171950-12-17
MBI (last 4 only)*******PQ96*******PQ96
Street98726 Glenn Ports Suite 322Missing
CityChristianfortMissing
StateIAMissing
ZIP51560Missing
Phone(225) 555-0184Missing
Emaillaura.wilkinson1884@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 1884agency-a-derived/enrollment_clean.csv, row 1733
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
1763Mergedcrm:C-01884 and enrollment:1733Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Laura Wilkinson

Only this person is in the household.

  • Laura Wilkinson (this person)