Golden record

FieldValueTaken fromWhyDeciding tier
First nameDavidEnrollment enrollment:307agency-a-derived/enrollment_clean.csv, row 307Most trusted source (enrollment over CRM)Rules (automatic)
Last nameCrossEnrollment enrollment:307agency-a-derived/enrollment_clean.csv, row 307Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1949-02-03Enrollment enrollment:307agency-a-derived/enrollment_clean.csv, row 307Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******YH58Enrollment enrollment:307agency-a-derived/enrollment_clean.csv, row 307Most trusted source (enrollment over CRM)Rules (automatic)
Street0808 Roberson OrchardCRM crm:C-00358agency-a-snapshot/clients.csv, row 358Most recent recordRules (automatic)
CityLake BethCRM crm:C-00358agency-a-snapshot/clients.csv, row 358Most recent recordRules (automatic)
StateALCRM crm:C-00358agency-a-snapshot/clients.csv, row 358Most recent recordRules (automatic)
ZIP36177CRM crm:C-00358agency-a-snapshot/clients.csv, row 358Most recent recordRules (automatic)
Phone(502) 555-0179CRM crm:C-00358agency-a-snapshot/clients.csv, row 358Most recent recordRules (automatic)
Emaildavid.cross358@example.comCRM crm:C-00358agency-a-snapshot/clients.csv, row 358Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-00358Enrollment enrollment:307
First nameDavidDavid
Last nameCrossCross
Birth date1949-02-031949-02-03
MBI (last 4 only)*******YH58*******YH58
Street0808 Roberson OrchardMissing
CityLake BethMissing
StateALMissing
ZIP36177Missing
Phone(502) 555-0179Missing
Emaildavid.cross358@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 358agency-a-derived/enrollment_clean.csv, row 307
Active policyNoNo

Merge log lines for this person

LineActionPairTierScoreRule
309Mergedcrm:C-00358 and enrollment:307Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.David Cross

Only this person is in the household.

  • David Cross (this person)