Case 01
The serial-number rule I approved joined records too confidently
In 2018 I approved a rule that matched service history to equipment by serial number alone. Within a single product family that could appear sufficient. Across the mixed manufacturer and model estate in our enterprise, the same value could refer to different items. The application was doing what I had authorised, which meant the correction had to begin with the assumption behind the rule rather than an accusation that field colleagues had entered careless data.
We examined 640 equipment records. Five hundred and eighty-eight had identities supported by the available evidence; fifty-two required investigation. The quickest proposal was to add a prefix based on the most likely manufacturer and continue the conversion. The project sponsor favoured that approach because it preserved the schedule and avoided visits to equipment held at customer locations. Rohan's engineering colleagues wanted the uncertain relationships checked against documents and, where needed, the physical item. I supported that work and authorised ₹38 lakh for verification and the data correction.
Forty-four of the fifty-two ambiguous records were resolved. Eight remained held, leaving 632 supported identities and eight exceptions in the examined cohort. The revised model retained the manufacturer and model relationship with the serial value and linked the evidence used to confirm the physical item. It did not claim that a composite identifier could settle every possible identity problem without review. Where the evidence remained inadequate, the system showed the exception instead of manufacturing a confident match to satisfy the migration field.
The cost included work the simpler matching rule was meant to avoid. I accepted that trade-off because the alternative would allow a service history to appear attached to equipment it might not describe. The record does not assert that 640 devices were defective, that all ambiguous entries had already caused an incorrect repair or that the programme established technical suitability. It establishes an identity problem, the bounded review and the remaining eight questions. My lesson was to examine the population covered by an identifier before making it the basis of a cross-enterprise rule. A value can be precise on the screen while its meaning becomes uncertain when it is taken beyond the context in which it was assigned.