Posts for the month of May 2014

HERON Republican: searching by lab value fixed and microbiology positive results available

HERON Republican release allows you to limit laboratory searches to a value for tests with a value assigned. If a lab test does not include a value (e.g., testing positive or negative for influenza) the option to limit by value will not appear. This release also introduces outpatient billing service lines and microbiology positive results.

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

HERON Republican Contents Summary

This month, our tour of rivers and lakes in Kansas honors the Republican River.

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

Observation Patients Source Go-Live Snapshot Issues
Allergy 492K 229K
KUH/O2/Epic Nov 2007 April 2014 various*
Cancer Cases 10.7M 73K
KUH Cancer Registry 1950s April 2014 labels*
Demographics 19.5M 2.04M
KUH Billing (O2 via SMS) 1980s April 2014 various*
UKP Billing 2000 April 2014
27.6K 27.6K Frontiers participant registry Jun 2009 April 2014 #2451
192.8K 192.8K Social Security Death Index 1962 April 2014
Diagnoses (IDC9) 60.7M 750K
KUH/O2/Epic Nov 2007 April 2014 various*
UKP Billing 2000 April 2014
University HealthSystem Consortium (UHC) Q4 2008 Dec 2013
History 25.7M 379K
KUH/O2/Epic Nov 2007 April 2014
Lab Results 139M 346K
KUH/O2/Epic 2003 April 2014 various*
Medications 116M 390K
KUH/O2/Epic (Organized by VA Class) Nov 2007 April 2014 various*
Microbiology 3.05M 27.1K
KUH/O2/Epic 2003 (?) April 2014 various*
737K 115K Negative 2003 April 2014
9.2K 6.97K Positive 2003 April 2014
Nursing Observations 758M ?
KUH/O2/Epic Nov 2007 April 2014 various*
Procedure Orders 154M 527K
KUH/O2/Epic 2003 (?) April 2014 various*
Procedures (CPT) 12.9M 654K
UKP Billing 2000 April 2014 #26
REDCap .96M 45.9K
REDCap July 2011 April 2014
Reports/Notes 58.8M 370K
KUH/O2/Epic ? April 2014
Specimens 110K 8.16K
KUMC Biospecimen Repository ? April 2014
Visit Details 55.8M 813K
KUH/O2/Epic Nov 2007 April 2014
Hospital Quality Metrics 5.91M 80.2K
University HealthSystem Consortium (UHC) Q4 2008 Dec 2013
All 1.4B


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.

Searching for some lab concepts such as INFLUENZA A NW (#2686) incorrectly prompts the user for numeric constraints
outdated links from HERON home page
Micro positive results without sensitivity
Update HERON system access agreement to include new requirements for SSDMF use
Load 'Outpatient Billing Service Line Areas' to HERON

Outstanding Problems/Defects/Issues