{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,2,22]],"date-time":"2025-02-22T05:37:11Z","timestamp":1740202631286,"version":"3.37.3"},"reference-count":0,"publisher":"IOS Press","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2010]]},"abstract":"<jats:p>Background: We have used routinely collected clinical data in epidemiological and quality improvement research for over 10 years. We extract, pseudonymise and link data from heterogeneous distributed databases; inevitably encountering errors and problems. Objective: To develop a solution-orientated system of error reporting which enables appropriate corrective action. Method: Review of the 94 errors, which occurred in 2008\/9. Previously we had described failures in terms of the data missing from our response files; however this provided little information about causation. We therefore developed a taxonomy based on the IT component limiting data extraction. Results: Our final taxonomy categorised errors as: (A) Data extraction Method and Process; (B) Translation Layer and Proxy Specification; (C) Shape and Complexity of the Original Schema; (D) Communication and System (mainly Software-based) Faults; (E) Hardware and Infrastructure; (F) Generic\/Uncategorised and\/or Human Errors. We found 79 distinct errors among the 94 reported; and the categories were generally predictive of the time needed to develop fixes. Conclusions: A systematic approach to errors and linking them to problem solving has improved project efficiency and enabled us to better predict any associated delays.<\/jats:p>","DOI":"10.3233\/978-1-60750-588-4-724","type":"book-chapter","created":{"date-parts":[[2025,2,21]],"date-time":"2025-02-21T18:09:19Z","timestamp":1740161359000},"source":"Crossref","is-referenced-by-count":0,"title":["A system for solution-orientated reporting of errors associated with the extraction of routinely collected clinical data for research and quality improvement"],"prefix":"10.3233","author":[{"family":"Michalakidis Georgios","sequence":"additional","affiliation":[]},{"family":"Kumarapeli Pushpa","sequence":"additional","affiliation":[]},{"family":"Ring Andre","sequence":"additional","affiliation":[]},{"family":"van Vlymen Jeremy","sequence":"additional","affiliation":[]},{"family":"Krause Paul","sequence":"additional","affiliation":[]},{"family":"de Lusignan Simon","sequence":"additional","affiliation":[]}],"member":"7437","container-title":["Studies in Health Technology and Informatics","MEDINFO 2010"],"original-title":[],"deposited":{"date-parts":[[2025,2,21]],"date-time":"2025-02-21T18:23:50Z","timestamp":1740162230000},"score":1,"resource":{"primary":{"URL":"https:\/\/www.medra.org\/servlet\/aliasResolver?alias=iospressISSNISBN&issn=0926-9630&volume=160&spage=724"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2010]]},"references-count":0,"URL":"https:\/\/doi.org\/10.3233\/978-1-60750-588-4-724","relation":{},"ISSN":["0926-9630"],"issn-type":[{"value":"0926-9630","type":"print"}],"subject":[],"published":{"date-parts":[[2010]]}}}