Posts for the month of March 2015

HERON McMillan Marsh improves IDX/O2 encounter mapping and introduces Alerts

Looking for medications prescribed at an outpatient surgery visit? Want to limit patients with an outpatient surgery to those with a specific diagnosis at the time of surgery? Now you can. HERON McMillan Marsh maps IDX and O2 encounters resulting in the ability to link O2 concepts, such as diagnosis and medications, with IDX concepts, such as outpatient procedures, with the same financial encounter temporal constraint.

New data types

  • Best practice and medication alerts are accessible in the Alert folder. This folder is in draft mode, and your feedback is welcome.
  • Emergency Episode is a new field available in the Visit Details/Encounter Type folder. This field allows you to search for patients seen in the emergency department regardless of where their encounters originated or terminated. The Emergency field, also in the Encounter Type folder, represents patients who left the Emergency Department without being admitted to the hospital.

Questions about HERON? Join the Frontiers Lunch and Learn which meets the 1st and 3rd Tuesdays of each month from 12:00 - 1:30 PM in room 3001D Student Center. Register in advance if possible but drop-ins are welcome.

Any publication that results from a project utilizing HERON should cite grant support (CTSA Award # UL1TR000001).

HERON McMillan Marsh Contents Summary

Our tour of rivers and lakes expands to include bodies of water within the Greater Plains Collaborative states. This month honors the McMillian Marsh in Marshfield, WI.

The HERON repository contains approximately 1.68 billion real observations from the hospital, clinics, and research systems:

Observation Patients Source Go-Live Snapshot Issues
Alerts 15.5M 399K
KUH/O2/Epic Nov 2007 Feb 2015
Allergy 571K 258K
KUH/O2/Epic Nov 2007 Feb 2015 various*
Cancer Cases 11.6M 77.6K
KUH Cancer Registry 1950s Feb 2015 labels*
Cardiology Labs 24.1M 348K
KUH/O2/Epic Nov 2007 Feb 2015
Demographics 20.1M 2.10M
KUH Billing (O2 via SMS) 1980s Feb 2015 various*
UKP Billing 2000 Feb 2015
32.6K 32.6K Frontiers participant registry Jun 2009 Feb 2015 #2451
186.2K 186.2K Social Security Death Index 1962 Feb 2015 #3388
Diagnoses (IDC9) 74.6M 810K
KUH/O2/Epic Nov 2007 Feb 2015 various*
UKP Billing 2000 Feb 2015
University HealthSystem Consortium (UHC) Q4 2008 Sept 2014
History 36.1M 447K
KUH/O2/Epic Nov 2007 Feb 2015
Lab Results 159M 382K
KUH/O2/Epic 2003 Feb 2015 various*
Medications 166M 457K
KUH/O2/Epic (Organized by VA Class) Nov 2007 Feb 2015 various*
Microbiology 3.54M 31K
KUH/O2/Epic 2003 (?) Feb 2015 various*
826K 128K Negative 2003 Feb 2015
11.8K 8.68K Positive 2003 Feb 2015
Nursing Observations 889M ?
KUH/O2/Epic Nov 2007 Feb 2015 various*
Procedure Orders 183M 583K
KUH/O2/Epic 2003 (?) Feb 2015 various*
Procedures (CPT) 14.3M 701K
UKP Billing 2000 Feb 2015 #26
REDCap 1.18M 48.8K
REDCap July 2011 Feb 2015
Reports/Notes 76M 434K
KUH/O2/Epic ? Feb 2015
Specimens 129K 9.3K
KUMC Biospecimen Repository ? Feb 2015
Visit Details 86.4M 97K
KUH/O2/Epic Nov 2007 Feb 2015
Hospital Quality Metrics 7.52M 101K
University HealthSystem Consortium (UHC) Q4 2008 Sept 2014 #2911
All 1.68B


Some material in the UMLS Metathesaurus is from copyrighted sources of the respective copyright holders. Users of the UMLS Metathesaurus are solely responsible for compliance with any copyright, patent or trademark restrictions and are referred to the copyright, patent or trademark notices appearing in the original sources, all of which are hereby incorporated by reference.

Misuse of the Limited Access Death Master File, NTIS, U.S. Department of Commerce data is subject to penalties under provisions of 15 CFR § 1110.200.

Beta Disclaimer

We are providing this early access to obtain feedback from you, the research community. While we are actively working on validating the data loaded into the system with hospital and clinic technical staff, there may be problems with our translation of data from our source systems (HospitalEpicSource and ClinicIdxSource) into HERON.

Please email us at if you discover information you believe may be erroneous.

We are actively working on enhancing the types of data included. Stay tuned to our roadmap to track progress toward upcoming releases.

Various Issues Still Apply

Keep in mind the issues noted in the original HERON beta notice, including:

Enhancements and Problems/Defects/Issues Addressed in this Release

Due to in-progress trac access policy issues, this section may be blank for a time.

same encounter queries don't work between IDX and Epic/O2
Best Practice Alerts (BPA)s and Medication Alerts from the Epic EMR in HERON
HERON does not find all expected ED visits (as recorded in ED_EPISODE_ID)

Outstanding Problems/Defects/Issues