Record, CLM, bronze and silver
CLM-418992
Received 2026-03-23T12:02:03Z, line 57,114 of the CLM feed
CLMRule
Bronze vs silver
Field by field: what arrived, what normalisation produced, and whether anything changed
| Field | Bronze (as received) | Silver (normalised) | Change |
|---|---|---|---|
| First name | Rioos, Sofia | Sofia | Changed |
| Middle | I | I | Unchanged |
| Last name | — | Rioos | Changed |
| Date of birth | Jun 6, 1992 | 1992-06-06 | Parsed |
| Gender | ·Male | M | Parsed |
| Member ID | UHC-21043-75 | UHC-21043-75 | Unchanged |
| SSN | •••-••-4960 | •••-••-4960 | Unchanged |
| Phone | 868-875-2423 | 8688752423 | Parsed |
| NULL | — | Cleared | |
| Address | N/A | — | Cleared |
| City | null | — | Cleared |
| State | — | — | Unchanged |
| ZIP | — | — | Unchanged |
| Group | GRP-9972 | GRP-9972 | Unchanged |
| Plan | - | — | Cleared |
- Quality score
- 0.66
- Name key
- sofia|rioos
- Address key
- —
- Canonical first
- sofia
Quality flags
5 raised during normalisation
- Name split from “Last, First”First-name field held "LAST, FIRST"; the two parts were split into their own fields
- Date of birth reformattedDate of birth rewritten to ISO 8601 from a source format (MM/DD/YYYY, YYYYMMDD, Mon D, YYYY)
- Phone reformattedPhone reduced to ten digits, punctuation and leading country code removed
- Gender normalisedGender mapped to F or M from a longer or variant value
- Placeholder values clearedPlaceholder tokens such as NULL, N/A, UNKNOWN or "-" treated as empty
Candidate pairs
Every scored comparison involving this record, highest score first
| Other record | Score | Method | Rule | Decision |
|---|---|---|---|---|
| ENR-125019 | 0.96 | Rule | D3 member id + name | Auto-linked |
| ENR-125020 | 0.96 | Rule | D3 member id + name | Auto-linked |
Resolution
Linked 2026-10-22 12:43:43
- Identity
- MBR-021553
- Method
- Rule
- Confidence
- 0.96
- Rule
- D3 member id + name
Golden record: Sofia Rios, 1992-06-06, 3 records, Verified
Audit
6 hash-chained entries for this record
- Record linked automatically2a64e306902026-10-22 12:43:54, matching_agentidentity id MBR-021553, confidence 0.96, rule D3 member_id + name, method deterministic, matched record ENR-125019
- Record linked automatically81f5a35cd72026-10-19 19:54:38, matching_agentidentity id MBR-021553, confidence 0.96, rule D3 member_id + name, method deterministic, matched record ENR-125019
- Record linked automatically7f5990aa002026-10-19 19:52:09, matching_agentidentity id MBR-021553, confidence 0.96, rule D3 member_id + name, method deterministic, matched record ENR-125019
- Record linked automaticallyba147aec382026-10-19 19:45:42, matching_agentidentity id MBR-021553, confidence 0.96, rule D3 member_id + name, method deterministic, matched record ENR-125019
- Record linked automatically59a11727462026-10-19 19:32:31, matching_agentidentity id MBR-021553, confidence 0.96, rule D3 member_id + name, method deterministic, matched record ENR-125019
- Record linked automaticallyaa873011492026-10-19 19:31:28, matching_agentidentity id MBR-029304, confidence 0.99, rule D1 member_id + dob exact, method deterministic, matched record ENR-124841