Golden record

FieldValueTaken fromWhyDeciding tier
First nameAprilEnrollment enrollment:1163agency-a-derived/enrollment_clean.csv, row 1163Most trusted source (enrollment over CRM)Rules (automatic)
Last nameThomasEnrollment enrollment:1163agency-a-derived/enrollment_clean.csv, row 1163Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1940-04-30Enrollment enrollment:1163agency-a-derived/enrollment_clean.csv, row 1163Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******PT36Enrollment enrollment:1163agency-a-derived/enrollment_clean.csv, row 1163Most trusted source (enrollment over CRM)Rules (automatic)
Street37976 Valentine Estate Suite 051CRM crm:C-01267agency-a-snapshot/clients.csv, row 1267Most recent recordRules (automatic)
CityWest JaniceportCRM crm:C-01267agency-a-snapshot/clients.csv, row 1267Most recent recordRules (automatic)
StateCOCRM crm:C-01267agency-a-snapshot/clients.csv, row 1267Most recent recordRules (automatic)
ZIP81504CRM crm:C-01267agency-a-snapshot/clients.csv, row 1267Most recent recordRules (automatic)
Phone(666) 555-0167CRM crm:C-01267agency-a-snapshot/clients.csv, row 1267Most recent recordRules (automatic)
Emailapril.thomas1267@example.comCRM crm:C-01267agency-a-snapshot/clients.csv, row 1267Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-01267Enrollment enrollment:1163
First nameAprilApril
Last nameThomasThomas
Birth date1940-04-301940-04-30
MBI (last 4 only)*******PT36*******PT36
Street37976 Valentine Estate Suite 051Missing
CityWest JaniceportMissing
StateCOMissing
ZIP81504Missing
Phone(666) 555-0167Missing
Emailapril.thomas1267@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 1267agency-a-derived/enrollment_clean.csv, row 1163
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
1183Mergedcrm:C-01267 and enrollment:1163Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphThis person shares a household with Troy Thomas.same householdApril ThomasTroy Thomas

This person shares a household with Troy Thomas.

  • April Thomas (this person)
  • Troy Thomas: same household