Golden record

FieldValueTaken fromWhyDeciding tier
First nameGeorgeEnrollment enrollment:1077agency-a-derived/enrollment_clean.csv, row 1077Most trusted source (enrollment over CRM)Rules (automatic)
Last nameNormanEnrollment enrollment:1077agency-a-derived/enrollment_clean.csv, row 1077Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1957-08-28Enrollment enrollment:1077agency-a-derived/enrollment_clean.csv, row 1077Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******HC27Enrollment enrollment:1077agency-a-derived/enrollment_clean.csv, row 1077Most trusted source (enrollment over CRM)Rules (automatic)
Street3470 Ellis Roads Suite 238CRM crm:C-01181agency-a-snapshot/clients.csv, row 1181Most recent recordRules (automatic)
CityJoystadCRM crm:C-01181agency-a-snapshot/clients.csv, row 1181Most recent recordRules (automatic)
StateARCRM crm:C-01181agency-a-snapshot/clients.csv, row 1181Most recent recordRules (automatic)
ZIP72897CRM crm:C-01181agency-a-snapshot/clients.csv, row 1181Most recent recordRules (automatic)
Phone(927) 555-0123CRM crm:C-01181agency-a-snapshot/clients.csv, row 1181Most recent recordRules (automatic)
Emailgeorge.norman1181@example.comCRM crm:C-01181agency-a-snapshot/clients.csv, row 1181Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-01181Enrollment enrollment:1077
First nameGeorgeGeorge
Last nameNormanNorman
Birth date1957-08-281957-08-28
MBI (last 4 only)*******HC27*******HC27
Street3470 Ellis Roads Suite 238Missing
CityJoystadMissing
StateARMissing
ZIP72897Missing
Phone(927) 555-0123Missing
Emailgeorge.norman1181@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 1181agency-a-derived/enrollment_clean.csv, row 1077
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
1096Mergedcrm:C-01181 and enrollment:1077Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphThis person shares a household with Vincent Norman.same householdGeorge NormanVincent Norman

This person shares a household with Vincent Norman.