The client is a hospital system that serves Mississauga, Ontario, and western Toronto in Canada. They have two hospitals and a Health Centre and offer the full range of acute care hospital services and a variety of community-based, specialized programs.

The client rolled out Epic EHR, which resulted in the sunsetting of their Pharmacy Information System and Oncology EMR. They decided to archive the last 2 years' data from these systems as indexed PDF documents, which would be available to view from Epic Hyperspace. Unfortunately, neither retiring system had any ability to generate pdf documents.

Key Challenges

  • Understanding data model of both the Pharmacy Information System and the Oncology EMR
  • Identifying how many document types are needed to present the information
  • Generating PDF layout that matches the application’s user interface
  • Application awareness
  • Aggressive project delivery timelines

Solution Approach

314e Corporation undertook the project to extract patient data from the Pharmacy Information System and the Oncology EMR and generate PDF files to load them into a new EMR. Both retiring software was highly proprietary systems with little or no documentation about their database schemas. 314e’s team wrote custom python code that queried data from the Oracle database of one system and the MS SQL Server database of the other system to generate PDF reports with all relevant data.

314e developed this solution using Python programming language utilizing Oracle native driver and SQL Server ODBC driver. We wrote SQL queries to retrieve relevant data from the database and generated high-quality PDF files using technologies like LaTeX. The program used a high degree of separation between PDF generation and data composition.

Business Outcomes

The end solution was optimized thoroughly for performance such that the need for “catch-up” extracts was obviated. All data were extracted, converted to pdf, and loaded into the new EMR over the cut-over weekend.