Record, PRV, bronze and silver
PRV-28013
Received 2026-09-10T04:22:09Z, line 9,210 of the PRV feed
PRVRule
Bronze vs silver
Field by field: what arrived, what normalisation produced, and whether anything changed
| Field | Bronze (as received) | Silver (normalised) | Change |
|---|---|---|---|
| First name | Richard | Richard | Unchanged |
| Middle | — | — | Unchanged |
| Last name | Graham | Graham | Unchanged |
| Date of birth | 1940-08-21 | 1940-08-21 | Unchanged |
| Gender | F | F | Unchanged |
| Member ID | UNKNOWN | — | Cleared |
| SSN | •••-••-3875 | •••-••-3875 | Unchanged |
| Phone | 457-219-5228 | 4572195228 | Parsed |
| RICHARD.GRAHAM@YAHOO.COM | richard.graham@yahoo.com | Changed | |
| Address | 9332 Camelback Rd | 9332 Camelback Rd | Unchanged |
| City | Tempe | Tempe | Unchanged |
| State | AZ | AZ | Unchanged |
| ZIP | 85243 | 85243 | Unchanged |
| Group | - | — | Cleared |
| Plan | ···· | — | Unchanged |
- Quality score
- 0.94
- Name key
- richard|graham
- Address key
- 9332|camelback|85243
- Canonical first
- richard
Quality flags
3 raised during normalisation
- Phone reformattedPhone reduced to ten digits, punctuation and leading country code removed
- Email lower-casedEmail lower-cased
- 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 |
|---|---|---|---|---|
| CLM-427300 | 0.97 | Rule | D2 ssn4 + dob + last name | Auto-linked |
| CLM-427299 | 0.83 | Scored | — | Sent to steward |
Resolution
Linked 2026-10-22 12:43:43
- Identity
- MBR-043802
- Method
- Rule
- Confidence
- 0.97
- Rule
- D2 ssn4 + dob + last name
Golden record: Richard Graham, 1940-08-21, 2 records, Verified
Evidence
Matched against CLM-427300
| Field | Similarity | Weight | Note |
|---|---|---|---|
| Name | 1.00 | 3.0 | |
| Date of birth | 1.00 | 3.0 | exact |
| SSN (last four) | 1.00 | 2.5 | |
| Phone | 1.00 | 1.5 |
Audit
5 hash-chained entries for this record
- Record linked automatically0762465e242026-10-22 12:43:55, matching_agentidentity id MBR-043802, confidence 0.97, rule D2 ssn4 + dob + last name, method deterministic, matched record CLM-427300
- Record linked automatically035ef929ca2026-10-19 19:54:39, matching_agentidentity id MBR-043802, confidence 0.97, rule D2 ssn4 + dob + last name, method deterministic, matched record CLM-427300
- Record linked automatically66757afb1d2026-10-19 19:52:09, matching_agentidentity id MBR-043802, confidence 0.97, rule D2 ssn4 + dob + last name, method deterministic, matched record CLM-427300
- Record linked automatically3793dfdaaa2026-10-19 19:45:42, matching_agentidentity id MBR-043802, confidence 0.97, rule D2 ssn4 + dob + last name, method deterministic, matched record CLM-427300
- Record linked automatically9482f0d1c32026-10-19 19:32:31, matching_agentidentity id MBR-043802, confidence 0.97, rule D2 ssn4 + dob + last name, method deterministic, matched record CLM-427300