Re: Finally they thought of it
"What happened here was a breach of GDPR, and Caldecott - the latter being the governance for medical data. If heads didn't roll, then the Caldecott guardian for the trust needs to be fired, too."
Agree, but who gets the chop?
Reading between the lines, the specific information requested was found using a pivot table, fine; the original worksheet was deleted, so far so good; but the analyst didn't realize there was a copy of the data in the pivot cache, fail. Since the audit found only 2 incidents out of 8000 requests, we can assume there is a written procedure that works, _when followed_.
If the analyst was inexperienced then there should have been more careful oversight which is a management error. If the analyst was experienced then not following the procedure is on them.