What happened
What this says
Current to 11 Oct 26Customer reported duplicate resident family contact records with spelling variations across homes, blocking accurate matching against commissioner referrals. Root cause identified as inconsistent source formatting.
Josh reported duplicate resident family contact records with spelling variations appearing across homes, preventing accurate matching against commissioner referral data. Bethan quickly reproduced the issue and traced it to inconsistent formatting in the source data. She escalated investigation to Kieran. This resolved faster than the previous duplicate report.
Details
Updated 9 Oct 26Trail
- public_reply · Josh Fairburn 15 Sep 2026 10:30Just wanted to flag something we've spotted: duplicate contacts in a few of our records.
- created · Josh Fairburn 15 Sep 2026 12:52Hi, we've noticed some duplicate entries in the resident family contact records. We're seeing the same contact appear twice with slight spelling variations in their name across several homes. This is causing issues when we try to match records against commissioner referrals. Can you help us understand why this is happening and what we can do to clean it up?
- public_reply · Bethan Lister 15 Sep 2026 13:43Just so I've got this right: you're seeing the same family contact listed twice with different name spellings? Can you give me an example from one of your homes?
- internal_note · Bethan Lister 16 Sep 2026 09:56Reproduced the issue. Duplicate contact entries across several homes. Source data has inconsistent formatting.
- public_reply · Bethan Lister 16 Sep 2026 10:10I've found the duplicates you mentioned. They're coming from inconsistency in the source data. I'm investigating the sync now to see if we can fix it at source.
- public_reply · Josh Fairburn 16 Sep 2026 10:12Thanks for looking into this. Let me know what you find.
- status_change · 21 Sep 2026 23:59