Bob Resolve / Record provenance
Why did these records become one person?
Michael Le is 3 records: crm:C-01656, enrollment:1515, enrollment:1516.
Aliases: Mike.
Candidate identity group. A deterministic match does not confirm a person.
Golden record
| Field | Value | Taken from | Why | Deciding tier |
|---|---|---|---|---|
| First name | Michael | Enrollment enrollment:1516agency-a-derived/enrollment_clean.csv, row 1516 | Most trusted source (enrollment over CRM) | Rules (automatic) |
| Last name | Le | Enrollment enrollment:1516agency-a-derived/enrollment_clean.csv, row 1516 | Most trusted source (enrollment over CRM) | Rules (automatic) |
| Suffix | None | None | No record has a value | None |
| Birth date | 1943-03-06 | Enrollment enrollment:1516agency-a-derived/enrollment_clean.csv, row 1516 | Most trusted source (enrollment over CRM) | Rules (automatic) |
| MBI (last 4 only) | *******KA15 | Enrollment enrollment:1516agency-a-derived/enrollment_clean.csv, row 1516 | Most trusted source (enrollment over CRM) | Rules (automatic) |
| Street | 4222 Cook Radial | CRM crm:C-01656agency-a-snapshot/clients.csv, row 1656 | Most recent record | Rules (automatic) |
| City | South Brianview | CRM crm:C-01656agency-a-snapshot/clients.csv, row 1656 | Most recent record | Rules (automatic) |
| State | KY | CRM crm:C-01656agency-a-snapshot/clients.csv, row 1656 | Most recent record | Rules (automatic) |
| ZIP | 42404 | CRM crm:C-01656agency-a-snapshot/clients.csv, row 1656 | Most recent record | Rules (automatic) |
| Phone | (561) 555-0183 | CRM crm:C-01656agency-a-snapshot/clients.csv, row 1656 | Most recent record | Rules (automatic) |
| michael.le1656@example.com | CRM crm:C-01656agency-a-snapshot/clients.csv, row 1656 | Most recent record | Rules (automatic) |
Member records side by side
| Field | CRM crm:C-01656 | Enrollment enrollment:1515 | Enrollment enrollment:1516 |
|---|---|---|---|
| First name | Mike | Michael | Michael |
| Last name | Le | Le | Le |
| Birth date | 1943-03-06 | 1943-03-06 | 1943-03-06 |
| MBI (last 4 only) | *******KA15 | *******KA15 | *******KA15 |
| Street | 4222 Cook Radial | Missing | Missing |
| City | South Brianview | Missing | Missing |
| State | KY | Missing | Missing |
| ZIP | 42404 | Missing | Missing |
| Phone | (561) 555-0183 | Missing | Missing |
| michael.le1656@example.com | Missing | Missing | |
| Source | agency-a-snapshot/clients.csv, row 1656 | agency-a-derived/enrollment_clean.csv, row 1515 | agency-a-derived/enrollment_clean.csv, row 1516 |
| Active policy | Yes | No | Yes |
Merge log lines for this person
| Line | Action | Pair | Tier | Score | Rule |
|---|---|---|---|---|---|
| 1538 | Merged | crm:C-01656 and enrollment:1515 | Rules (automatic) | 0.9999 | AUTO-MATCH-HIGH (Automatic match) |
| 1539 | Merged | crm:C-01656 and enrollment:1516 | Rules (automatic) | 0.9999 | AUTO-MATCH-HIGH (Automatic match) |
| 1987 | Merged | enrollment:1515 and enrollment:1516 | Rules (automatic) | >0.9999 | AUTO-MATCH-HIGH (Automatic match) |
Household
This person shares a household with Sabrina Le.
- Michael Le (this person)
- Sabrina Le: same household