{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,5,3]],"date-time":"2026-05-03T23:49:18Z","timestamp":1777852158742,"version":"3.51.4"},"reference-count":38,"publisher":"SAGE Publications","issue":"1","license":[{"start":{"date-parts":[[2022,1,1]],"date-time":"2022-01-01T00:00:00Z","timestamp":1640995200000},"content-version":"unspecified","delay-in-days":0,"URL":"https:\/\/creativecommons.org\/licenses\/by-nc\/4.0\/"}],"funder":[{"DOI":"10.13039\/501100002347","name":"Bundesministerium f\u00fcr Bildung und Forschung","doi-asserted-by":"publisher","award":["01EO1004"],"award-info":[{"award-number":["01EO1004"]}],"id":[{"id":"10.13039\/501100002347","id-type":"DOI","asserted-by":"publisher"}]},{"DOI":"10.13039\/501100002347","name":"Bundesministerium f\u00fcr Bildung und Forschung","doi-asserted-by":"publisher","award":["01EO1504"],"award-info":[{"award-number":["01EO1504"]}],"id":[{"id":"10.13039\/501100002347","id-type":"DOI","asserted-by":"publisher"}]}],"content-domain":{"domain":["journals.sagepub.com"],"crossmark-restriction":true},"short-container-title":["Health Informatics J"],"published-print":{"date-parts":[[2022,1]]},"abstract":"<jats:p>A deep integration of routine care and research remains challenging in many respects. We aimed to show the feasibility of an automated transformation and transfer process feeding deeply structured data with a high level of granularity collected for a clinical prospective cohort study from our hospital information system to the study\u2019s electronic data capture system, while accounting for study-specific data and visits. We developed a system integrating all necessary software and organizational processes then used in the study. The process and key system components are described together with descriptive statistics to show its feasibility in general and to identify individual challenges in particular. Data of 2051 patients enrolled between 2014 and 2020 was transferred. We were able to automate the transfer of approximately 11 million individual data values, representing 95% of all entered study data. These were recorded in n = 314 variables (28% of all variables), with some variables being used multiple times for follow-up visits. Our validation approach allowed for constant good data quality over the course of the study. In conclusion, the automated transfer of multi-dimensional routine medical data from HIS to study databases using specific study data and visit structures is complex, yet viable.<\/jats:p>","DOI":"10.1177\/14604582211058081","type":"journal-article","created":{"date-parts":[[2022,1,5]],"date-time":"2022-01-05T22:04:42Z","timestamp":1641420282000},"update-policy":"https:\/\/doi.org\/10.1177\/sage-journals-update-policy","source":"Crossref","is-referenced-by-count":10,"title":["Automated provision of clinical routine data for a complex clinical follow-up study: A data warehouse solution"],"prefix":"10.1177","volume":"28","author":[{"ORCID":"https:\/\/orcid.org\/0000-0002-6722-766X","authenticated-orcid":false,"given":"Mathias","family":"Kaspar","sequence":"first","affiliation":[{"name":"Comprehensive Heart Failure Center and Department of Internal Medicine I, University and University Hospital W\u00fcrzburg, W\u00fcrzburg, Germany"},{"name":"Department of Health Services Research, Carl von Ossietzky University of Oldenburg, Oldenburg, Germany"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Georg","family":"Fette","sequence":"additional","affiliation":[{"name":"Service Center Medical Informatics, W\u00fcrzburg University Hospital, W\u00fcrzburg, Germany"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Monika","family":"Hanke","sequence":"additional","affiliation":[{"name":"Comprehensive Heart Failure Center and Department of Internal Medicine I, University and University Hospital W\u00fcrzburg, W\u00fcrzburg, Germany"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Maximilian","family":"Ertl","sequence":"additional","affiliation":[{"name":"Service Center Medical Informatics, W\u00fcrzburg University Hospital, W\u00fcrzburg, Germany"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Frank","family":"Puppe","sequence":"additional","affiliation":[{"name":"Chair of Computer Science VI, University of W\u00fcrzburg, W\u00fcrzburg, Germany"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Stefan","family":"St\u00f6rk","sequence":"additional","affiliation":[{"name":"Comprehensive Heart Failure Center and Department of Internal Medicine I, University and University Hospital W\u00fcrzburg, W\u00fcrzburg, Germany"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"179","published-online":{"date-parts":[[2022,1,5]]},"reference":[{"key":"bibr1-14604582211058081","doi-asserted-by":"publisher","DOI":"10.1016\/j.ijmedinf.2014.08.007"},{"key":"bibr2-14604582211058081","doi-asserted-by":"publisher","DOI":"10.1016\/j.ijmedinf.2010.03.004"},{"key":"bibr3-14604582211058081","doi-asserted-by":"publisher","DOI":"10.1186\/s12911-016-0376-2"},{"key":"bibr4-14604582211058081","first-page":"1315","volume":"245","author":"Xu T","year":"2017","journal-title":"Stud Health Technol Inform"},{"key":"bibr5-14604582211058081","first-page":"94","volume":"248","author":"Rinner C","year":"2018","journal-title":"Stud Health Technol Inform"},{"key":"bibr6-14604582211058081","doi-asserted-by":"publisher","DOI":"10.1371\/journal.pone.0212463"},{"key":"bibr7-14604582211058081","doi-asserted-by":"publisher","DOI":"10.1136\/jamia.2009.000893"},{"key":"bibr8-14604582211058081","doi-asserted-by":"publisher","DOI":"10.3414\/ME17-02-0010"},{"key":"bibr9-14604582211058081","doi-asserted-by":"publisher","DOI":"10.1093\/bib\/bbu006"},{"key":"bibr10-14604582211058081","doi-asserted-by":"publisher","DOI":"10.1007\/s00392-018-1245-z"},{"key":"bibr11-14604582211058081","doi-asserted-by":"publisher","DOI":"10.1111\/jep.12908"},{"key":"bibr12-14604582211058081","doi-asserted-by":"publisher","DOI":"10.1016\/j.ijmedinf.2019.05.018"},{"key":"bibr13-14604582211058081","doi-asserted-by":"publisher","DOI":"10.1017\/cts.2017.301"},{"key":"bibr14-14604582211058081","first-page":"867","volume":"2010","author":"Weng C","year":"2010","journal-title":"AMIA Annu Symp Proc"},{"key":"bibr15-14604582211058081","doi-asserted-by":"publisher","DOI":"10.1210\/jc.2019-01252"},{"key":"bibr16-14604582211058081","doi-asserted-by":"publisher","DOI":"10.1007\/s00392-016-0975-z"},{"key":"bibr17-14604582211058081","doi-asserted-by":"publisher","DOI":"10.1210\/jc.2019-00705"},{"key":"bibr18-14604582211058081","doi-asserted-by":"publisher","DOI":"10.1186\/s12882-019-1522-8"},{"key":"bibr19-14604582211058081","doi-asserted-by":"publisher","DOI":"10.3414\/ME13-01-0134"},{"key":"bibr20-14604582211058081","doi-asserted-by":"publisher","DOI":"10.1186\/s12885-019-5866-z"},{"key":"bibr21-14604582211058081","unstructured":"Adagarla B, Connolly DW, Nair M, et al. Integrating REDCap patient registries within an i2b2 integrated data repository. In AMIA Clinical Research Informatics Joint Summit 2013."},{"key":"bibr22-14604582211058081","doi-asserted-by":"publisher","DOI":"10.1016\/j.atg.2014.09.010"},{"key":"bibr23-14604582211058081","first-page":"1125","volume":"3","author":"Bae CJ","year":"2015","journal-title":"EGEMS (Washington, DC)"},{"key":"bibr24-14604582211058081","first-page":"1","volume":"2010","author":"Botsis T","year":"2010","journal-title":"Summit Transl Bioinform"},{"key":"bibr25-14604582211058081","doi-asserted-by":"publisher","DOI":"10.3414\/ME18-03-0003"},{"key":"bibr26-14604582211058081","doi-asserted-by":"publisher","DOI":"10.2147\/DHPS.S226486"},{"key":"bibr27-14604582211058081","doi-asserted-by":"publisher","DOI":"10.3414\/ME15-02-0015"},{"key":"bibr28-14604582211058081","doi-asserted-by":"publisher","DOI":"10.3171\/2015.9.FOCUS15382"},{"key":"bibr29-14604582211058081","first-page":"76","volume":"2017","author":"Campion Jr","year":"2017","journal-title":"AMIA Jt Summits Transl Sci Proc"},{"key":"bibr30-14604582211058081","unstructured":"Gabetta M, Mirabelli M, Klersy C, et al. An extension of the i2b2 data warehouse to support REDCap dynamic data pull. In EFMI-STC, 2019, pp. 21\u201325."},{"key":"bibr31-14604582211058081","doi-asserted-by":"publisher","DOI":"10.1186\/s12911-019-0939-0"},{"issue":"1","key":"bibr32-14604582211058081","first-page":"1244","volume":"4","author":"Kahn MG","year":"2016","journal-title":"EGEMS (Washington, DC)"},{"key":"bibr33-14604582211058081","unstructured":"International Council for Harmonisation of Technical Requirements for Pharmaceuticals for Human Use (ICH), Integrated Addendum to ICH E6(r1). Guideline for Good Clinical Practice E6(r2), EMA\/CHMP\/ICH\/135\/1995."},{"key":"bibr34-14604582211058081","doi-asserted-by":"publisher","DOI":"10.1093\/jamia\/ocab018"},{"key":"bibr35-14604582211058081","first-page":"534","volume":"180","author":"Ouagne D","year":"2012","journal-title":"Stud Health Technol Inform"},{"key":"bibr36-14604582211058081","first-page":"1","author":"Recalde M","year":"2021","journal-title":"Int J Obes"},{"key":"bibr37-14604582211058081","doi-asserted-by":"publisher","DOI":"10.1136\/amiajnl-2011-000622"},{"key":"bibr38-14604582211058081","doi-asserted-by":"publisher","DOI":"10.1055\/s-0040-1709708"}],"container-title":["Health Informatics Journal"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/journals.sagepub.com\/doi\/pdf\/10.1177\/14604582211058081","content-type":"application\/pdf","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/journals.sagepub.com\/doi\/full-xml\/10.1177\/14604582211058081","content-type":"application\/xml","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/journals.sagepub.com\/doi\/pdf\/10.1177\/14604582211058081","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2026,4,29]],"date-time":"2026-04-29T22:31:42Z","timestamp":1777501902000},"score":1,"resource":{"primary":{"URL":"https:\/\/journals.sagepub.com\/doi\/10.1177\/14604582211058081"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2022,1]]},"references-count":38,"journal-issue":{"issue":"1","published-print":{"date-parts":[[2022,1]]}},"alternative-id":["10.1177\/14604582211058081"],"URL":"https:\/\/doi.org\/10.1177\/14604582211058081","relation":{},"ISSN":["1460-4582","1741-2811"],"issn-type":[{"value":"1460-4582","type":"print"},{"value":"1741-2811","type":"electronic"}],"subject":[],"published":{"date-parts":[[2022,1]]},"article-number":"14604582211058081"}}