Golden record

FieldValueTaken fromWhyDeciding tier
First nameAmandaEnrollment enrollment:157agency-a-derived/enrollment_clean.csv, row 157Most trusted source (enrollment over CRM)Rules (automatic)
Last nameHarrisEnrollment enrollment:157agency-a-derived/enrollment_clean.csv, row 157Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1963-02-21Enrollment enrollment:157agency-a-derived/enrollment_clean.csv, row 157Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******QF63Enrollment enrollment:157agency-a-derived/enrollment_clean.csv, row 157Most trusted source (enrollment over CRM)Rules (automatic)
Street91878 Miller PortCRM crm:C-00186agency-a-snapshot/clients.csv, row 186Most recent recordRules (automatic)
CityNorth MariahavenCRM crm:C-00186agency-a-snapshot/clients.csv, row 186Most recent recordRules (automatic)
StateALCRM crm:C-00186agency-a-snapshot/clients.csv, row 186Most recent recordRules (automatic)
ZIP36221CRM crm:C-00186agency-a-snapshot/clients.csv, row 186Most recent recordRules (automatic)
Phone(665) 555-0186CRM crm:C-00186agency-a-snapshot/clients.csv, row 186Most recent recordRules (automatic)
Emailamanda.harris186@example.comCRM crm:C-00186agency-a-snapshot/clients.csv, row 186Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-00186Enrollment enrollment:157
First nameAmandaAmanda
Last nameHarrisHarris
Birth date1963-02-211963-02-21
MBI (last 4 only)*******QF63*******QF63
Street91878 Miller PortMissing
CityNorth MariahavenMissing
StateALMissing
ZIP36221Missing
Phone(665) 555-0186Missing
Emailamanda.harris186@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 186agency-a-derived/enrollment_clean.csv, row 157
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
161Mergedcrm:C-00186 and enrollment:157Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphThis person shares a household with Franklin Harris.same householdAmanda HarrisFranklin Harris

This person shares a household with Franklin Harris.