Posts for the month of February 2015

HERON Webster release finely tunes data fulfillment and fixes search timeout issue

HERON searches would stop running and appear as processing indefinitely once timed out (~180 seconds). HERON Webster release fixes the issue. Once a search times out, it will continue to search in the background. Check the query in your previous queries section to see if the search completes.

This release includes back-end enhancements that will allow for more precise data delivery when requesting data. Searches limited by dates will now provide only data within those date ranges. Improvements to identified data requests are also included. Learn more about requesting data.

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 Webster Contents Summary

This month, our tour of rivers and lakes in Kansas honors the Webster Reservoir.

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

Observation Patients Source Go-Live Snapshot Issues
Allergy 565K 256K
KUH/O2/Epic Nov 2007 Jan 2015 various*
Cancer Cases 11.5M 77.2K
KUH Cancer Registry 1950s Jan 2015 labels*
Cardiology Labs 23.8M 345K
KUH/O2/Epic Nov 2007 Jan 2015
Demographics 20M 2.10M
KUH Billing (O2 via SMS) 1980s Jan 2015 various*
UKP Billing 2000 Jan 2015
31.1K 31.1K Frontiers participant registry Jun 2009 Jan 2015 #2451
195.4K 195.4K Social Security Death Index 1962 Jan 2015
Diagnoses (IDC9) 73.3M 805K
KUH/O2/Epic Nov 2007 Jan 2015 various*
UKP Billing 2000 Jan 2015
University HealthSystem Consortium (UHC) Q4 2008 Sept 2014
History 35.1M 442K
KUH/O2/Epic Nov 2007 Jan 2015
Lab Results 157M 378K
KUH/O2/Epic 2003 Jan 2015 various*
Medications 164M 452K
KUH/O2/Epic (Organized by VA Class) Nov 2007 Jan 2015 various*
Microbiology 3.5M 30.6K
KUH/O2/Epic 2003 (?) Jan 2015 various*
818K 127K Negative 2003 Jan 2015
11.5K 8.5K Positive 2003 Jan 2015
Nursing Observations 876M ?
KUH/O2/Epic Nov 2007 Jan 2015 various*
Procedure Orders 180M 578K
KUH/O2/Epic 2003 (?) Jan 2015 various*
Procedures (CPT) 14.2M 696K
UKP Billing 2000 Jan 2015 #26
REDCap 1.16M 48.8K
REDCap July 2011 Jan 2015
Reports/Notes 74.4M 428K
KUH/O2/Epic ? Jan 2015
Specimens 128K 9.3K
KUMC Biospecimen Repository ? Jan 2015
Visit Details 84.6M 97K
KUH/O2/Epic Nov 2007 Jan 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.

identified DUA fulfillment based on original dates
limit DUA datasets by date
Prefix diagnosis hierarchy labels with ICD-9 codes to make it easier to navigate
Hospital visits fact in same financial encounter with "smoking, yes" leads to a mismatched ID between the two
data builder requires access to user's home directory
.0 from date field in csv in DUA-NG causes compatibility issues with excel
repeated concepts are treated as redundant by data builder
NULL MRNs in encounter mapping

Outstanding Problems/Defects/Issues