HERON: Big Hill release adds home medications, other medication orders, and expands UHC data
The Big Hill release adds support for home medications and expands UHC coverage. Previously, we only had medications that are dispensed by the hospital pharmacy; now, you'll be able to see
- medications that the patient reports taking at home (so called "historical medications"), as well as
- all other orders, which includes prescriptions, inpatient medication orders, and discharge medication orders.
- data for an additional 100K patients
The UHC data, although primarily administrative, provides a new view on a patient's interaction at the hospital. New UHC concepts include:
- ICU length of stay: Search on time spent in ICU.
- Admission and Discharge status concepts: Search where patients came from prior to admission or went to upon discharge.
- Readmission concept: Helps you search for patients readmitted after discharge to their home, allowing specification to a desired number of days.
- Clinical Classification Software (CCS) ICD-9: These codes provided by AHRQ collapse ICD-9 diagnosis and procedure codes into a smaller number of categories useful in analyzing data. See AHRQ web site.
- All Patient Refined Diagnosis Related Groups (APR DRGs): DRG codes expanded to include 4 subclasses in severity of illness and mortality subgroups for each code. See web site.
- Major Diagnostic Categories (MDCs): Search these diagnosis categories created by combining ICD-9 diagnosis codes into 25 MDCs. These codes, which are used primarily for administrative and billing purposes, provide another view on patient data.
- Comorbidity: Search 29 comorbidity categories.
Currently the UHC data is limited to a 1-year time period (Nov. 2010-Nov. 2011). Look for additional years in future releases. This data is limited to hospital encounters and lacks clinic data.
HERON Big Hill Contents Summary
This month, our tour of rivers and lakes in Kansas honors lake Big Hill.
The HERON repository contains approximately 630 million real observations from the hospital, clinics, and research systems:
Observation | Patients | Source | Go-Live | Snapshot | Issues | |
---|---|---|---|---|---|---|
Demographics | 18.0M | 1.90M | ||||
KUH Billing (O2 via SMS) | 1980s | Feb 2012 | various* | |||
UKP Billing | 2000 | Feb 2012 | ||||
9.5K | 9.5K | Frontiers participant registry | Jun 2009 | Feb 2012 | ||
183K | 183k | Social Security Death Index | 1962 | Feb 2012 | ||
Diagnoses (IDC9) | 18.7M | 602K | ||||
KUH/O2/Epic | Nov 2007 | Feb 2012 | various* | |||
UKP Billing | 2000 | Feb 2012 | ||||
Medications | 78.1M | 245K | ||||
KUH/O2/Epic | Nov 2007 | Feb 2012 | various* | |||
Nursing Observations | 463M | ? | ||||
KUH/O2/Epic | Nov 2007 | Feb 2012 | various* | |||
Lab Results | 72.6M | 257K | ||||
KUH/O2/Epic | 2003 | Feb 2012 | various* | |||
Procedures (CPT) | 9.6M | 542K | ||||
UKP Billing | 2000 | Feb 2012 | ||||
Specimens | 27.8K | 2.80K | ||||
KUMC Biospecimen Repository | ? | Jan 2012 | ||||
Cancer Cases | 9.1M | 62.8K | ||||
KUH Cancer Registry | 1950s | Jan 2012 | labels* | |||
Hospital Quality Metrics | .97M | 19.7K | ||||
University HealthSystem Consortium (UHC) | N/A | Nov 2011 | #997 | |||
All | 630M |
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 heron-admin@kumc.edu 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:
- date shifting, part of our DeIdentificationStrategy
- age searching (#158)
Enhancements and Problems/Defects/Issues Addressed in this Release
No results
Outstanding Problems/Defects/Issues
Ticket | Summary | Keywords |
---|---|---|
#2301 | constraining birth-date by date doesn't work - HERON uses sysdate for start_date in demographics | public-web wrong-results training |
#2617 | Saved searches not updated in REDCap projects after Arkansas release | public-web redcap-to-heron |
Comments
No comments.