Golden record

FieldValueTaken fromWhyDeciding tier
First nameJasonEnrollment enrollment:20agency-a-derived/enrollment_clean.csv, row 20Most trusted source (enrollment over CRM)Rules (automatic)
Last nameNolanEnrollment enrollment:20agency-a-derived/enrollment_clean.csv, row 20Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1947-09-30Enrollment enrollment:20agency-a-derived/enrollment_clean.csv, row 20Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******DU14Enrollment enrollment:20agency-a-derived/enrollment_clean.csv, row 20Most trusted source (enrollment over CRM)Rules (automatic)
Street12805 Russell CanyonCRM crm:C-00023agency-a-snapshot/clients.csv, row 23Most recent recordRules (automatic)
CityMichaeltonCRM crm:C-00023agency-a-snapshot/clients.csv, row 23Most recent recordRules (automatic)
StateCOCRM crm:C-00023agency-a-snapshot/clients.csv, row 23Most recent recordRules (automatic)
ZIP81273CRM crm:C-00023agency-a-snapshot/clients.csv, row 23Most recent recordRules (automatic)
Phone(763) 555-0162CRM crm:C-00023agency-a-snapshot/clients.csv, row 23Most recent recordRules (automatic)
Emailjason.nolan23@example.comCRM crm:C-00023agency-a-snapshot/clients.csv, row 23Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-00023CRM crm:C-02011Enrollment enrollment:19Enrollment enrollment:20
First nameJasonJasonJasonJason
Last nameNolanNlanNolanNolan
Birth date1947-09-301947-09-301947-09-301947-09-30
MBI (last 4 only)*******DU14*******DU14*******DU14*******DU14
Street12805 Russell Canyon12805 Russell CanyonMissingMissing
CityMichaeltonMichaeltonMissingMissing
StateCOCOMissingMissing
ZIP8127381273MissingMissing
Phone(763) 555-0162(763) 555-0162MissingMissing
Emailjason.nolan23@example.comMissingMissingMissing
Sourceagency-a-snapshot/clients.csv, row 23agency-a-snapshot/clients.csv, row 2011agency-a-derived/enrollment_clean.csv, row 19agency-a-derived/enrollment_clean.csv, row 20
Active policyYesNoNoYes

Merge log lines for this person

LineActionPairTierScoreRule
20Mergedcrm:C-00023 and crm:C-02011Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)
21Mergedcrm:C-00023 and enrollment:19Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)
22Mergedcrm:C-00023 and enrollment:20Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)
1888Mergedcrm:C-02011 and enrollment:19Rules (automatic)0.9999AUTO-MATCH-HIGH (Automatic match)
1889Mergedcrm:C-02011 and enrollment:20Rules (automatic)0.9999AUTO-MATCH-HIGH (Automatic match)
2041Mergedenrollment:19 and enrollment:20Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Jason Nolan

Only this person is in the household.

  • Jason Nolan (this person)