Golden record

FieldValueTaken fromWhyDeciding tier
First namePaulEnrollment enrollment:310agency-a-derived/enrollment_clean.csv, row 310Most trusted source (enrollment over CRM)Rules (automatic)
Last nameHouseEnrollment enrollment:310agency-a-derived/enrollment_clean.csv, row 310Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1957-04-12Enrollment enrollment:310agency-a-derived/enrollment_clean.csv, row 310Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******TR47Enrollment enrollment:310agency-a-derived/enrollment_clean.csv, row 310Most trusted source (enrollment over CRM)Rules (automatic)
Street04380 Cervantes Cove Apt. 863CRM crm:C-00363agency-a-snapshot/clients.csv, row 363Most recent recordRules (automatic)
CityHeathertonCRM crm:C-00363agency-a-snapshot/clients.csv, row 363Most recent recordRules (automatic)
StateMNCRM crm:C-00363agency-a-snapshot/clients.csv, row 363Most recent recordRules (automatic)
ZIP56389CRM crm:C-00363agency-a-snapshot/clients.csv, row 363Most recent recordRules (automatic)
Phone(545) 555-0175CRM crm:C-00363agency-a-snapshot/clients.csv, row 363Most recent recordRules (automatic)
Emailpaul.house363@example.comCRM crm:C-00363agency-a-snapshot/clients.csv, row 363Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-00363Enrollment enrollment:310
First namePaulPaul
Last nameHouseHouse
Birth date1957-04-121957-04-12
MBI (last 4 only)*******TR47*******TR47
Street04380 Cervantes Cove Apt. 863Missing
CityHeathertonMissing
StateMNMissing
ZIP56389Missing
Phone(545) 555-0175Missing
Emailpaul.house363@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 363agency-a-derived/enrollment_clean.csv, row 310
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
312Mergedcrm:C-00363 and enrollment:310Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Paul House

Only this person is in the household.

  • Paul House (this person)