wiki:HospitalEpicSource

The EPIC data from the KU hospital (KUH) is one of the primary HERON data sources.

Epic is also rolling out to the KUPI clinics, so HospitalEpicSource is becoming a misnomer.

With a 1st cut at demographics, diagnoses, labs, and meds, from a Sep 2010 snapshot, we declared victory on milestone:EpicAlphai2b2. With the addition of flowsheets and automated system access policies, we reached milestone:EpicAlphai2b2. We're working on a Jan 2010 snapshot; see HeronLoad.

Epic Clarity Relational Store

The Epic online documentation Galaxy explains two different data models within Epic:

Arvinder has been working with hospital database folks to get so-called "build" data; see source:heron/clarity_build_instance and Clarity Spring 2008 data model.

Clarity Training Companions explain ADT, Inpatient, etc.

We may explore chronicles access in the future (#20).

We can find the Clarity column name and the description of a item from Hyperspace by doing a Ctrl+left click in the item box.

Other sites using Epic and i2b2

UC Davis Clinical and Translational Science Center (CTSC), Larry Errecart

Here's our primary script we use to build our patient_dimension, visit_dimension and observation_fact tables.

-- Larry Errecart <larry.errecart@…> 9/15/2010 12:29 PM

Cincinnati, Keith Marsolo

Additional information from Keith Marsolo at Cincinnati on how they extract from EPIC:

On Sun, 2010-09-19 at 12:03 -0400, Keith Marsolo wrote:

All,

We've posted some documentation that describes our work with the Epic Clarity database.

The first document: Moving Data from Epic to I2B2.docx describes, well, our approach to moving data from Epic to i2b2. It's not complete, but it provides an overview of how we load demographics, diagnoses, and medications. There's some information on how we create metadata XML for each content type. This is similar to the upcoming "modifier" functionality in version 1.6. Until we release our code, it's more or less CCHMC-specific, but the content would be applicable to either approach.

The other document epic_dw_master_tables.pdf details some of the steps used to create our "Master" Epic datamart that we provide to users for reporting and other purposes. Not all of the tables are included, but we've provided a few of the more frequently used ones. The scripts provide an overview of what columns/tables to use to look for certain content.

Words of "wisdom":

  1. The tables/columns in Epic may have misleading names. Always check the Epic UserWeb/Clarity data dictionaries [e.g. Clarity Spring 2008 data model] to determine the true purpose of the field.
  2. Never assume that the Epic documentation is accurate and/or complete. Each institutions Epic implementation is different, and data may be in unique locations, particularly if that data is fed by an interface. To verify the data you are working with is correct (i.e. what you think it means), I would encourage you to work with your Clarity Reporting Team or end users to ensure that the data in the database matches what appears on the screen.

Thanks.

Keith

Last modified 5 years ago Last modified on 04/18/13 09:51:43

Attachments (1)

Download all attachments as: .zip