Posts for the month of May 2015

HERON Quivira reinstates the Human Subjects Training check and presents email flags

HERON Quivira release checks the new CITI Human Subjects Training program. If your training has lapsed, you will have until July 1, 2015 to complete it. After July 1, your HERON access will be terminated if training is not in compliance.

Want to know how many patients meeting your search criteria have email addresses on file? HERON Quivira release includes a searchable flag for either IDX (billing) or O2 (electronic medical record) recorded email addresses.

In an effort to facilitate your data analysis, this release will allow for data limited to modifiers. Previously, your data set would include any modifier attached to the patient observation. For example, if you wanted an inpatient medication, such as Clopidogrel, you would receive any observation associated with that medication (e.g., inpatient order, dose, historical medication, and more). Now, if you only want the data associated with one of the modifiers, such as outpatient order, your dataset will include only outpatient order observations. All modifiers are still available for a search concept. The data will reflect your search. If you pull a modifier into your search, you will receive observations for that modifier only. If you don't limit the modifier in the search, you will receive all modifier observations for that concept.

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

This month, our tour of rivers and lakes in Kansas honors the Quivira National Wildlife Refuge.

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

Observation Patients Source Go-Live Snapshot Issues
Alerts 16.7M 413K
KUH/O2/Epic Nov 2007 Apr 2015
Allergy 587K 264K
KUH/O2/Epic Nov 2007 Apr 2015 various*
Cancer Cases 11.8M 78.8K
KUH Cancer Registry 1950s Apr 2015 labels*
Cardiology Labs 24.9M 354K
KUH/O2/Epic Nov 2007 Apr 2015
Demographics 25M 2.11M
KUH Billing (O2 via SMS) 1980s Apr 2015 various*
UKP Billing 2000 Apr 2015
34.2K 34.2K Frontiers participant registry Jun 2009 Apr 2015
197.9K 197.9K Social Security Death Index 1962 Apr 2015
Diagnoses (IDC9) 77.7M 823K
KUH/O2/Epic Nov 2007 Apr 2015 various*
UKP Billing 2000 Apr 2015
University HealthSystem Consortium (UHC) Q4 2008 Feb 2015
History 38.9M 460K
KUH/O2/Epic Nov 2007 Apr 2015
Lab Results 163M 389K
KUH/O2/Epic 2003 Apr 2015 various*
Medications 181M 470K
KUH/O2/Epic (Organized by VA Class) Nov 2007 Apr 2015 various*
Microbiology 3.66M 31.8K
KUH/O2/Epic 2003 (?) Apr 2015 various*
843K 130K Negative 2003 Apr 2015
12.4K 9K Positive 2003 Apr 2015
Nursing Observations 915M ?
KUH/O2/Epic Nov 2007 Apr 2015 various*
Procedure Orders 189M 595K
KUH/O2/Epic 2003 (?) Apr 2015 various*
Procedures (CPT) 14.6M 712K
UKP Billing 2000 Apr 2015
REDCap 1.19M 48.8K
REDCap July 2011 Apr 2015
Reports/Notes 79.7M 446K
KUH/O2/Epic ? Apr 2015
Specimens 96K 6.69K
KUMC Biospecimen Repository ? Apr 2015 #3526
Visit Details 89.9M 99K
KUH/O2/Epic Nov 2007 Apr 2015
Hospital Quality Metrics 8.13M 104K
University HealthSystem Consortium (UHC) Q4 2008 Feb 2015 #2911
All 1.90B


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.

query for do we have an email address? in HERON
Portable DataBuilder does not use jobname file prefixes for CSVs
Clicking "Other Medication Concepts" in the i2b2 webclient results in "Database Error" message

Outstanding Problems/Defects/Issues