Golden record

FieldValueTaken fromWhyDeciding tier
First nameAlecEnrollment enrollment:1021agency-a-derived/enrollment_clean.csv, row 1021Most trusted source (enrollment over CRM)Rules (automatic)
Last nameEvansEnrollment enrollment:1021agency-a-derived/enrollment_clean.csv, row 1021Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1940-06-07Enrollment enrollment:1021agency-a-derived/enrollment_clean.csv, row 1021Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******GQ93Enrollment enrollment:1021agency-a-derived/enrollment_clean.csv, row 1021Most trusted source (enrollment over CRM)Rules (automatic)
Street1805 James Crescent Suite 173CRM crm:C-01122agency-a-snapshot/clients.csv, row 1122Most recent recordRules (automatic)
CityNew BridgetfortCRM crm:C-01122agency-a-snapshot/clients.csv, row 1122Most recent recordRules (automatic)
StateILCRM crm:C-01122agency-a-snapshot/clients.csv, row 1122Most recent recordRules (automatic)
ZIP60428CRM crm:C-01122agency-a-snapshot/clients.csv, row 1122Most recent recordRules (automatic)
Phone(552) 555-0117CRM crm:C-01122agency-a-snapshot/clients.csv, row 1122Most recent recordRules (automatic)
Emailalec.evans1122@example.comCRM crm:C-01122agency-a-snapshot/clients.csv, row 1122Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-01122Enrollment enrollment:1020Enrollment enrollment:1021
First nameAlecAlecAlec
Last nameEvansEvansEvans
Birth date1940-06-071940-06-071940-06-07
MBI (last 4 only)*******GQ93*******GQ93*******GQ93
Street1805 James Crescent Suite 173MissingMissing
CityNew BridgetfortMissingMissing
StateILMissingMissing
ZIP60428MissingMissing
Phone(552) 555-0117MissingMissing
Emailalec.evans1122@example.comMissingMissing
Sourceagency-a-snapshot/clients.csv, row 1122agency-a-derived/enrollment_clean.csv, row 1020agency-a-derived/enrollment_clean.csv, row 1021
Active policyYesNoYes

Merge log lines for this person

LineActionPairTierScoreRule
1035Mergedcrm:C-01122 and enrollment:1020Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)
1036Mergedcrm:C-01122 and enrollment:1021Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)
1922Mergedenrollment:1020 and enrollment:1021Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Alec Evans

Only this person is in the household.

  • Alec Evans (this person)