REDLetr: Workflow and tools to support the migration of legacy clinical data capture systems to REDCap

International Journal of Medical Informatics

Volumn 93, Issue , 2016, Pages 103-110

  Dunn, William D ^a   Cobb, Jake ^b   Levey, Allan I ^a   Gutman, David A ^a  

^a EMORY UNIVERSITY SCHOOL OF MEDICINE   (United States)

^b Georgia Institute of Technology   (United States)

Author keywords

Biomedical informatics; Clinical informatics; Clinical research informatics; Electronic health record; ETL; REDCap

Indexed keywords

BIOINFORMATICS; COGNITIVE SYSTEMS; DATA INTEGRATION; DIGITAL STORAGE; INFORMATION SCIENCE; LEGACY SYSTEMS; RECORDS MANAGEMENT;

BIOMEDICAL INFORMATICS; CLINICAL INFORMATICS; CLINICAL RESEARCH INFORMATICS; ELECTRONIC HEALTH RECORD; REDCAP;

DATA ACQUISITION;

ARTICLE; CLINICAL DATA CAPTURE SYSTEM; DATA BASE; DATA COLLECTION METHOD; DATA EXTRACTION; HUMAN; INFORMATION PROCESSING; MEDICAL INFORMATICS; NEUROPSYCHOLOGICAL TEST; PATIENT CARE; PRIORITY JOURNAL; REDCAP; WORKFLOW; CLINICAL TRIAL (TOPIC); COMPUTER INTERFACE; DATABASE MANAGEMENT SYSTEM; ELECTRONIC HEALTH RECORD; FACTUAL DATABASE; INTERNET; MEDICAL RESEARCH; PROCEDURES; SOFTWARE;

BIOMEDICAL RESEARCH; CLINICAL TRIALS AS TOPIC; DATA COLLECTION; DATABASE MANAGEMENT SYSTEMS; DATABASES, FACTUAL; ELECTRONIC HEALTH RECORDS; HUMANS; INTERNET; MEDICAL INFORMATICS; SOFTWARE; USER-COMPUTER INTERFACE; WORKFLOW;

EID: 84990985993     PISSN: 13865056     EISSN: 18728243     Source Type: Journal    
DOI: 10.1016/j.ijmedinf.2016.06.015     Document Type: Article

References (33)

1. [1] Chen, R., Klein, G.O., Sundvall, E., Karlsson, D., Ahlfeldt, H., Archetype-based conversion of EHR content models: pilot experience with a regional EHR system. BMC Med. Inform. Decis. Mak., 9, 2009, 33.
2. [2] Kalra, D., Beale, T., Heard, S., The openEHR foundation. Stud. Health Technol. Inform. 115 (2005), 153–173.
3. [3] Helms, R.W., Data quality issues in electronic data capture. Drug Inform. J. 35 (2001), 827–837.
4. [4] Litchfield, J., Freeman, J., Schou, H., Elsley, M., Fuller, R., Chubb, B., Is the future for clinical trials internet-based? A cluster randomized clinical trial. Clin. Trials 2 (2005), 72–79.
5. [5] Velikova, G., Wright, E.P., Smith, A.B., Cull, A., Gould, A., Forman, D., et al. Automated collection of quality-of-life data: a comparison of paper and computer touch-screen questionnaires. J. Clin. Oncol. 17 (1999), 998–1007.
6. [6] Shah, J., Rajgor, D., Pradhan, S., McCready, M., Zaveri, A., Pietrobon, R., Electronic data capture for registries and clinical trials in orthopaedic surgery: open source versus commercial systems. Clin. Orthop. Relat. Res. 468 (2010), 2664–2671.
7. [7] Prokscha, S., Practical Guide to Clinical Data Management. 2011, CRC Press.
8. [8] Welker, J.A., Implementation of electronic data capture systems: barriers and solutions. Contemp. Clin. Trials 28 (2007), 329–336.
9. [9] de Lusignan, S., van Weel, C., The use of routinely collected computer data for research in primary care: opportunities and challenges. Fam. Pract. 23 (2006), 253–263.
10. [10] El Emam, K., Jonker, E., Sampson, M., Krleza-Jerić, K., Neisa, A., The use of electronic data capture tools in clinical trials: web-survey of 259 Canadian trials. J. Med. Internet Res., 11, 2009, e8.
11. [11] Masys, D.R., Harris, P.A., Fearn, P.A., Kohane, I.S., Designing a public square for research computing. Sci. Transl. Med., 4, 2012, 149fs32.
12. [12] Leroux, H., McBride, S., Gibson, S., On selecting a clinical trial management system for large scale, multi-centre, multi-modal clinical research study. Stud. Health Technol. Inform. 168 (2011), 89–95.
13. [13] Oracle Clinical – Overview | Oracle n.d. http://www.oracle.com/us/products/applications/health-sciences/e- clinical/clinical/index.html (accessed 9.04.16).
14. [14] Fegan, G.W., Lang, T.A., Could an open-source clinical trial data-management system be what we have all been looking for?. PLoS Med., 5, 2008, e6.
15. [15] OpenClinica Open Source EDC, OpenClinica n.d. https://community.openclinica.com/ (accessed 9.04.16).
16. [16] Harris, P.A., Taylor, R., Thielke, R., Payne, J., Gonzalez, N., Conde, J.G., Research electronic data capture (REDCap)—a metadata-driven methodology and workflow process for providing translational research informatics support. J. Biomed. Inform. 42 (2009), 377–381.
17. [17] Obeid, J.S., McGraw, C.A., Minor, B.L., Conde, J.G., Pawluk, R., Lin, M., et al. Procurement of shared data instruments for research electronic data capture (REDCap). J. Biomed. Inform. 46 (2013), 259–265.
18. [18] Wong, T.C., Captur, G., Valeti, U., Moon, J., Schelbert, E.B., Feasibility of the REDCap platform for single center and collaborative multicenter CMR research. J. Cardiovasc. Magn. Reson., 16, 2014, P89.
19. [19] REDCap Plugins (U of Iowa) – REDCap Documentation – Institute for Clinical and Translational Science n.d. https://www.icts.uiowa.edu/confluence/pages/viewpage.action?pageId=67307660 (accessed 8.04.16).
20. [20] 123andy. 123andy/redcap-hook-framework. GitHub n.d. https://github.com/123andy/redcap-hook-framework (accessed 9.04.16).
21. [21] Gutierrez, J.B., Harb, O.S., Zheng, J., Tisch, D.J., Charlebois, E.D., Stoeckert, C.J. Jr., et al. A framework for global collaborative data management for malaria research. Am. J. Trop. Med. Hyg. 93 (2015), 124–132.
22. [22] Anaconda Scientific Python Distribution n.d. https://store.continuum.io/cshop/anaconda/ (accessed 24.04.15).
23. [23] S.S. Burns, A. Browne, G.N. Davis, S.L. Rimrodt, L.E. Cutting, Nashville, TN, Vanderbilt University and Philadelphia, PA. Childrens Hospital of Philadelphia. PyCap (Version 1.0) [Computer Software]. GitHub n.d. https://github.com/sburns/PyCap (accessed 24.04.15).
24. [24] F. Perez, B.E. Granger, IPython: A System for Interactive Scientific Computing, Comput. Sci. Eng. n.d. 9 21-29.
25. [25] Post, A., Kurc, T., Overcash, M., Cantrell, D., Morris, T., Eckerson, K., et al. A temporal abstraction-based extract, transform and load process for creating registry databases for research. AMIA Jt. Summits Transl. Sci. Proc. 2011 (2011), 46–50.
26. [26] Office Migration Planning Manager (OMPM): Office Compatibility. Microsoft Download Center n.d. http://www.microsoft.com/en- us/download/details.aspx?id=11454 (accessed April 24.0415).
27. [27] Openpyxl – A Python library to read/write Excel 2007 xlsx/xlsm files—openpyxl 2.2.1 documentation n.d. https://openpyxl.readthedocs.org/en/latest/ (accessed 24.04.15).
28. [28] Python-docx – A Python library for creating and updating Microsoft Word (.docx) files—python-docx 0.8.5 documentation n.d. https://python-docx.readthedocs.io/en/latest/ (accessed 29.04.16).
29. [29] Lewis, J.R., IBM computer usability satisfaction questionnaires: psychometric evaluation and instructions for use. Int. J. Hum. Comput. Interact. 7 (1995), 57–78.
30. [30] Dillon, T.W., Ratcliffe, T.M., Evaluating point-of-care technology with the IBM computer usability satisfaction questionnaire. Issues Inform. Syst. 5 (2004), 441–446.
31. [31] Franklin, J.D., Guidry, A., Brinkley, J.F., A partnership approach for Electronic Data Capture in small-scale clinical trials. J. Biomed. Inform. 44:Suppl 1 (2011), S103–8.
32. [32] B. Adagarla, D.W. Connolly, T.M. McMahon, M. Nair, L.D. VanHoose, P. Sharma, et al. SEINE: Methods for Electronic Data Capture and Integrated Data Repository Synthesis with Patient Registry Use Cases (2015).
33. [33] Forrest, C.B., Margolis, P.A., Bailey, L.C., Marsolo, K., Del Beccaro, M.A., Finkelstein, J.A., et al. PEDSnet: a national pediatric learning health system. J. Am. Med. Inform. Assoc. 21 (2014), 602–606.