Real word challenges in integrating electronic medical record and administrative health data for regional quality improvement in diabetes: a retrospective cross-sectional analysis.

BACKGROUND: Linked electronic medical records and administrative data have the potential to support a learning health system and data-driven quality improvement. However, data completeness and accuracy must first be assessed before their application. We evaluated the processes, feasibility, and limitations of linking electronic medical records and administrative data for the purpose of quality improvement within five specialist diabetes clinics in Edmonton, Alberta, a province known for its robust health data infrastructure. METHODS: We conducted a retrospective cross-sectional analysis using electronic medical record and administrative data for individuals ≥ 18 years attending the clinics between March 2017 and December 2018. Descriptive statistics were produced for demographics, service use, diabetes type, and standard diabetes benchmarks. The systematic and iterative process of obtaining results is described. RESULTS: The process of integrating electronic medical record with administrative data for quality improvement was found to be non-linear and iterative and involved four phases: project planning, information generating, limitations analysis, and action. After limitations analysis, questions were grouped into those that were answerable with confidence, answerable with limitations, and not answerable with available data. Factors contributing to data limitations included inaccurate data entry, coding, collation, migration and synthesis, changes in laboratory reporting, and information not captured in existing databases. CONCLUSION: Electronic medical records and administrative databases can be powerful tools to establish clinical practice patterns, inform data-driven quality improvement at a regional level, and support a learning health system. However, there are substantial data limitations that must be addressed before these sources can be reliably leveraged.

Understanding challenges of using routinely collected health data to address clinical care gaps: a case study in Alberta, Canada.

High-quality data are fundamental to healthcare research, future applications of artificial intelligence and advancing healthcare delivery and outcomes through a learning health system. Although routinely collected administrative health and electronic medical record data are rich sources of information, they have significant limitations. Through four example projects from the Physician Learning Program in Edmonton, Alberta, Canada, we illustrate barriers to using routinely collected health data to conduct research and engage in clinical quality improvement. These include challenges with data availability for variables of clinical interest, data completeness within a clinical visit, missing and duplicate visits, and variability of data capture systems. We make four recommendations that highlight the need for increased clinical engagement to improve the collection and coding of routinely collected data. Advancing the quality and usability of health systems data will support the continuous quality improvement needed to achieve the quintuple aim.