Posts by author tmcmahon

HERON Michigan: Search for patients with MyChart accounts

Interested in limiting your search to patients with MyChart accounts? HERON Michigan introduces the MyChart folder within Demographics. This folder provides granular information in addition to the general question of whether or not the patient has an account. For example: Looking for only active MyChart users? Search patients who activated and accessed their account. This will eliminate patients who activate but never use their accounts. Want to limit your search to only patients you can contact via email? Search the "Chose to receive E-mail" folder.

Identified patient notes are now available for identified data requests. While you cannot search these notes in HERON, the notes can be provided in an approved identified data request. For example, drag Reports->Visit Notes->Note Types->ED Provider Notes into your query to receive the provider note text from ED visits for patients in your patient set.

Need help with 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 Michigan Contents Summary

Our tour of rivers and lakes expands to include bodies of water within the ​Greater Plains Collaborative states. This month honors Lake Michigan.

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

Observation Patients Source Go-Live Snapshot Issues
Alerts 20.2M 448K
KUH/O2/Epic Nov 2007 Sept 2015
Allergy 622K 277K
KUH/O2/Epic Nov 2007 Sept 2015 various*
Cancer Cases 17.9M 81.2.7K
KUH Cancer Registry 1950s Sept 2015 labels*
Cardiology Labs 26.9M 369K
KUH/O2/Epic Nov 2007 Sept 2015
Demographics 26.7M 2.15M
KUH Billing (O2 via SMS) 1980s Sep 2015 various*
UKP Billing 2000 Sep 2015
38.7K 38.7K Frontiers participant registry Jun 2009 Sep 2015
200.7K 200.7K Social Security Death Index 1962 Sep 2015
Diagnoses (IDC9, ICD10) 90M* 858K*
KUH/O2/Epic Nov 2007 Sep 2015 various*
UKP Billing 2000 Sep 2015
University HealthSystem Consortium (UHC) Q4 2008 Jun 2015
History 44.2M 490K
KUH/O2/Epic Nov 2007 Sep 2015
Lab Results 173M 407K
KUH/O2/Epic 2003 Sep 2015 various*
Medications 213M 499K
KUH/O2/Epic (Organized by VA Class) Nov 2007 Sep 2015 various*
Microbiology 4.02M 34.0K
KUH/O2/Epic 2003 (?) Sep 2015 various*
887K 137K Negative 2003 Sep 2015
13.7K 9.8K Positive 2003 Sep 2015
National Cardiovascular Data Registry 1.33M 11.3K
NCDR (?) Dec 2014
Nursing Observations 988M ?
KUH/O2/Epic Nov 2007 Sep 2015 various*
Procedure Orders 205M 623K
KUH/O2/Epic 2003 (?) Sep 2015 various*
Procedures (CPT) 15.3M 739K
UKP Billing 2000 Sep 2015
REDCap 1.26M 49.5K
REDCap July 2011 Sep 2015
Reports/Notes 101M 476K
KUH/O2/Epic ? Sep 2015
Specimens 137K 9.7K
KUMC Biospecimen Repository ? Jun 2015
Visit Details 99M 1.02M
KUH/O2/Epic Nov 2007 Sep 2015
Hospital Quality Metrics 8.78M 112K
University HealthSystem Consortium (UHC) Q4 2008 Jun 2015 #2911
All 2.09B

* Currently, HERON is missing around 3M encounter diagnosis records. We expect to resolve this issue in the next release.

Notice

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 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:

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.

No results

Outstanding Problems/Defects/Issues

HERON River Walk debuts NCDR data

Search for data used to measure and improve quality of cardiovascular care at KUMC with the National Cardiovascular Data Registry (NCDR) data in HERON. The NCDR is used to answer questions regarding patient risk factors and outcomes as well as procedures, treatments and device use.

Searching with alerts continues to improve with enhancements to the drug interaction and allergy alerts data.

Need help with 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 River Walk Contents Summary

Our tour of rivers and lakes expands to include bodies of water within the ​Greater Plains Collaborative states. This month honors the River Walk in San Antonio, TX.

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

Observation Patients Source Go-Live Snapshot Issues
Alerts 18.8M 434K
KUH/O2/Epic Nov 2007 Jul 2015
Allergy 608K 272K
KUH/O2/Epic Nov 2007 Jul 2015 various*
Cancer Cases 12.1M 80.2K
KUH Cancer Registry 1950s Jul 2015 labels*
Cardiology Labs 26.1M 363K
KUH/O2/Epic Nov 2007 Jul 2015
Demographics 25.7M 2.13M
KUH Billing (O2 via SMS) 1980s Jul 2015 various*
UKP Billing 2000 Jun 2015
36.4K 36.4K Frontiers participant registry Jun 2009 Jul 2015
199.6K 199.6K Social Security Death Index 1962 Jul 2015
Diagnoses (IDC9) 91M 845K
KUH/O2/Epic Nov 2007 Jul 2015 various*
UKP Billing 2000 Jul 2015
University HealthSystem Consortium (UHC) Q4 2008 Mar 2015
History 42M 477K
KUH/O2/Epic Nov 2007 Jul 2015
Lab Results 169M 400K
KUH/O2/Epic 2003 Jul 2015 various*
Medications 207M 487K
KUH/O2/Epic (Organized by VA Class) Nov 2007 Jul 2015 various*
Microbiology 3.87M 33.1K
KUH/O2/Epic 2003 (?) Jul 2015 various*
869K 134K Negative 2003 Jul 2015
13.2K 9.5K Positive 2003 Jul 2015
National Cardiovascular Data Registry 1.33M 11.3K
NCDR (?) Jul 2015
Nursing Observations 957M ?
KUH/O2/Epic Nov 2007 Jul 2015 various*
Procedure Orders 198M 611K
KUH/O2/Epic 2003 (?) Jul 2015 various*
Procedures (CPT) 15M 726K
UKP Billing 2000 Jul 2015
REDCap 1.24M 49.5K
REDCap July 2011 Jul 2015
Reports/Notes 85M 463K
KUH/O2/Epic ? Jul 2015
Specimens 137K 9.7K
KUMC Biospecimen Repository ? Jun 2015
Visit Details 95M 1.01M
KUH/O2/Epic Nov 2007 Jul 2015
Hospital Quality Metrics 8.28M 108K
University HealthSystem Consortium (UHC) Q4 2008 Mar 2015 #2911
All 2.01B

Notice

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 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:

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.

#3224
Bring NCDR(v4) data into HERON - Phase I
#3505
Alerts 2.0 - Bring in drug dosage, drug allergy and other alert types.
#3640
Epic discharge billing diagnosis modifier "Present on admission" will incorrectly return 0 patients

Outstanding Problems/Defects/Issues

HERON Calhoun includes O2 billing diagnosis

O2 billing diagnosis is the latest addition to diagnosis modifiers in the HERON Calhoun release. Other diagnosis modifiers include IDX/UHC billing and O2 clinical. Modifiers can be used to narrow your search for a more precise patient set.

Medication order end dates and alert start and end dates/times are corrected with this release.

Need help with 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 Calhoun Contents Summary

Our tour of rivers and lakes expands to include bodies of water within the ​Greater Plains Collaborative states. This month honors the Lake Calhoun in Minneapolis, MN.

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 17.8M 425K
KUH/O2/Epic Nov 2007 Jun 2015
Allergy 599K 268K
KUH/O2/Epic Nov 2007 Jun 2015 various*
Cancer Cases 12M 79.7K
KUH Cancer Registry 1950s Jun 2015 labels*
Cardiology Labs 25.6M 359K
KUH/O2/Epic Nov 2007 Jun 2015
Demographics 25.4M 2.13M
KUH Billing (O2 via SMS) 1980s Jun 2015 various*
UKP Billing 2000 Jun 2015
35.7K 35.7K Frontiers participant registry Jun 2009 Jun 2015
198.8K 198.8K Social Security Death Index 1962 Jun 2015
Diagnoses (IDC9) 88.3M 837K
KUH/O2/Epic Nov 2007 Jun 2015 various*
UKP Billing 2000 Jun 2015
University HealthSystem Consortium (UHC) Q4 2008 Mar 2015
History 40.6M 469K
KUH/O2/Epic Nov 2007 Jun 2015
Lab Results 166M 395K
KUH/O2/Epic 2003 Jun 2015 various*
Medications 203M 479K
KUH/O2/Epic (Organized by VA Class) Nov 2007 Jun 2015 various*
Microbiology 3.78M 32.5K
KUH/O2/Epic 2003 (?) Jun 2015 various*
857K 132K Negative 2003 Jun 2015
12.8K 9.2K Positive 2003 Jun 2015
Nursing Observations 939M ?
KUH/O2/Epic Nov 2007 Jun 2015 various*
Procedure Orders 194M 604K
KUH/O2/Epic 2003 (?) Jun 2015 various*
Procedures (CPT) 14.8M 721K
UKP Billing 2000 Jun 2015
REDCap 1.2M 49.2K
REDCap July 2011 Jun 2015
Reports/Notes 82.6M 456K
KUH/O2/Epic ? Jun 2015
Specimens 137K 9.7K
KUMC Biospecimen Repository ? Jun 2015
Visit Details 93M 1M
KUH/O2/Epic Nov 2007 Jun 2015
Hospital Quality Metrics 8.28M 108K
University HealthSystem Consortium (UHC) Q4 2008 Mar 2015 #2911
All 1.97B

Notice

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 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:

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.

No results

Outstanding Problems/Defects/Issues

HERON Jamestown includes drug-drug interaction best practice alerts

Query how many people had a drug-drug interaction best practice alert with the HERON Jamestown release. Go to Alerts -> Med Interaction Checking -> Drug-Drug -> Alphabetic folder based on the first letter of the alert description (e.g., M for Metformin/Cimetidine)

Register for the 3rd Annual HERON Fishing Trip, a training workshop

Date: July 16, 2015, 8:00 AM – 4:30 PM CST

Location: Dykes Library, Room G026

What to expect Workshop will include both classroom and hands-on trainings. Topics for discussion:

  • Data types within HERON
  • Temporal and advanced search capabilities
  • Analysis tools within HERON
  • Data requests: RRRC and DROC
  • Modifiers to narrow your search
  • Data delivery and integration

Can't make the Fishing Trip? 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 Jamestown Contents Summary

This month, our tour of rivers and lakes in Kansas honors the Jamestown Wildlife Area.

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 17.3M 419K
KUH/O2/Epic Nov 2007 May 2015
Allergy 593K 266K
KUH/O2/Epic Nov 2007 May 2015 various*
Cancer Cases 11.9M 79.2K
KUH Cancer Registry 1950s May 2015 labels*
Cardiology Labs 25.3M 357K
KUH/O2/Epic Nov 2007 May 2015
Demographics 25.2M 2.12M
KUH Billing (O2 via SMS) 1980s May 2015 various*
UKP Billing 2000 May 2015
34.9K 34.9K Frontiers participant registry Jun 2009 May 2015
198.4K 198.4K Social Security Death Index 1962 May 2015
Diagnoses (IDC9) 78.8M 829K
KUH/O2/Epic Nov 2007 May 2015 various*
UKP Billing 2000 May 2015
University HealthSystem Consortium (UHC) Q4 2008 Feb 2015
History 39.8M 465K
KUH/O2/Epic Nov 2007 May 2015
Lab Results 165M 392K
KUH/O2/Epic 2003 May 2015 various*
Medications 201M 475K
KUH/O2/Epic (Organized by VA Class) Nov 2007 May 2015 various*
Microbiology 3.72M 32.2K
KUH/O2/Epic 2003 (?) May 2015 various*
850K 131K Negative 2003 May 2015
12.6K 9.1K Positive 2003 May 2015
Nursing Observations 928M ?
KUH/O2/Epic Nov 2007 May 2015 various*
Procedure Orders 192M 599K
KUH/O2/Epic 2003 (?) May 2015 various*
Procedures (CPT) 14.7M 716K
UKP Billing 2000 May 2015
REDCap 1.19M 49.2K
REDCap July 2011 May 2015
Reports/Notes 79.8M 449K
KUH/O2/Epic ? May 2015
Specimens 136K 9.6K
KUMC Biospecimen Repository ? May 2015
Visit Details 91M 99K
KUH/O2/Epic Nov 2007 May 2015
Hospital Quality Metrics 8.13M 104K
University HealthSystem Consortium (UHC) Q4 2008 Feb 2015 #2911
All 1.94B

Notice

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 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:

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.

#2781
Exception report framework to replace tests that halt ETL
#3357
Query by drug-drug interaction alert description (BPA)
#3458
identified data with MRN only; no contact info

Outstanding Problems/Defects/Issues

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

Notice

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 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:

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.

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

Outstanding Problems/Defects/Issues

HERON Cheyenne Bottoms maps laboratory tests to LOINC

LOINC codes are universal identifiers used to facilitate the sharing of laboratory data for research, outcomes management, and clinical care. The Cheyenne Bottoms release includes two folders for labs: LOINC and Hospital. While the majority of labs are mapped to LOINC, future work continues. As a result, the HERON LOINC hierarchy is in draft format. Please send any feedback on this change to heron-admin@….

The new hierarchy structure for HERON laboratory tests is based upon discussions at the GPC Hackathon Two and work by Cerner. Many thanks to Cerner and the GPC Dev team for input and scripts.

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 Cheyenne Bottoms Contents Summary

This month, our tour of rivers and lakes in Kansas honors the Cheyenne Bottoms Refuge.

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

Observation Patients Source Go-Live Snapshot Issues
Alerts 16M 405K
KUH/O2/Epic Nov 2007 Mar 2015
Allergy 579K 261K
KUH/O2/Epic Nov 2007 Mar 2015 various*
Cancer Cases 11.7M 78.3K
KUH Cancer Registry 1950s Mar 2015 labels*
Cardiology Labs 24.5M 351K
KUH/O2/Epic Nov 2007 Mar 2015
Demographics 20.2M 2.11M
KUH Billing (O2 via SMS) 1980s Mar 2015 various*
UKP Billing 2000 Mar 2015
33.3K 33.3K Frontiers participant registry Jun 2009 Mar 2015
197.2K 197.2K Social Security Death Index 1962 Mar 2015
Diagnoses (IDC9) 76.1M 817K
KUH/O2/Epic Nov 2007 Mar 2015 various*
UKP Billing 2000 Mar 2015
University HealthSystem Consortium (UHC) Q4 2008 Feb 2015
History 37.3M 454K
KUH/O2/Epic Nov 2007 Mar 2015
Lab Results 161M 385K
KUH/O2/Epic 2003 Mar 2015 various*
Medications 174M 464K
KUH/O2/Epic (Organized by VA Class) Nov 2007 Mar 2015 various*
Microbiology 3.59M 31.4K
KUH/O2/Epic 2003 (?) Mar 2015 various*
835K 129K Negative 2003 Mar 2015
12.1K 8.87K Positive 2003 Mar 2015
Nursing Observations 899M ?
KUH/O2/Epic Nov 2007 Mar 2015 various*
Procedure Orders 186M 589K
KUH/O2/Epic 2003 (?) Mar 2015 various*
Procedures (CPT) 14.4M 706K
UKP Billing 2000 Mar 2015
REDCap 1.19M 48.8K
REDCap July 2011 Mar 2015
Reports/Notes 77.8M 440K
KUH/O2/Epic ? Mar 2015
Specimens 131K 9.4K
KUMC Biospecimen Repository ? Mar 2015
Visit Details 88M 98K
KUH/O2/Epic Nov 2007 Mar 2015
Hospital Quality Metrics 8.13M 104K
University HealthSystem Consortium (UHC) Q4 2008 Feb 2015 #2911
All 1.85B

Notice

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 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:

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.

#1552
Enhance Dose Modifiers: include data from Medication Administration Records (MAR)
#2868
Document the DUA process
#2947
search HERON labs by LOINC terminology including GPC usability design
#3275
Missing Expected LOS facts (UHC) for patients beginning Oct 2013

Outstanding Problems/Defects/Issues

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

Notice

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 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:

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.

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

Outstanding Problems/Defects/Issues

HERON turns 45 with the Kanopolis Release and includes temporal query reuse fix and new concept, IDX Place of Service

The HERON Kanopolis release marks the 45th update to HERON. Over the past 46 months, HERON has grown in terms of data and functionality. Temporal Queries, ability to filter searches through modifiers, and improvements to the Timeline tool are just a few examples of new functionality. HERON continues to grow through the PCORI Greater Plains Collaborative (GPC) work toward standardization of concept hierarchies, and the amount of medical data within HERON has grown from approximately 300 Million in the early releases to over 1.68 Billion medical observations in this release.

HERON Kanopolis new features (concepts):

  • IDX Place of Service, new concept that identifies the physical setting for outpatient/clinic-based services (office, clinic, inpatient hospital, outpatient hospital, emergency room hospital and others).

HERON Kanopolis fixes:

  • Inability to reuse temporal queries
  • Same financial encounter mapping between UHC and O2 data

HERON Kanopolis known issues:

  • 8300 UHC to O2 encounter mappings are lost. The HERON team is troubleshooting this issue.
  • Flowsheets observations decreased due to data clean-up in O2.

The Kanopolis release includes data through November 2014.

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

This month, our tour of rivers and lakes in Kansas honors the Kanopolis Lake.

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 551K 251K
KUH/O2/Epic Nov 2007 Nov 2014 various*
Cancer Cases 11.4M 76.3K
KUH Cancer Registry 1950s Nov 2014 labels*
Cardiology Labs 22.9M 338K
KUH/O2/Epic Nov 2007 Nov 2014
Demographics 19.9M 2.08M
KUH Billing (O2 via SMS) 1980s Nov 2014 various*
UKP Billing 2000 Nov 2014
31.1K 31.1K Frontiers participant registry Jun 2009 Nov 2014 #2451
195.4K 195.4K Social Security Death Index 1962 Nov 2014
Diagnoses (IDC9) 70.4M 792K
KUH/O2/Epic Nov 2007 Nov 2014 various*
UKP Billing 2000 Nov 2014
University HealthSystem Consortium (UHC) Q4 2008 Sept 2014
History 32.9M 429K
KUH/O2/Epic Nov 2007 Nov 2014
Lab Results 153M 371K
KUH/O2/Epic 2003 Nov 2014 various*
Medications 157M 439K
KUH/O2/Epic (Organized by VA Class) Nov 2007 Nov 2014 various*
Microbiology 3.40M 29.9K
KUH/O2/Epic 2003 (?) Nov 2014 various*
798K 124K Negative 2003 Nov 2014
10.7K 7.94K Positive 2003 Nov 2014
Nursing Observations 853M ?
KUH/O2/Epic Nov 2007 Nov 2014 various*
Procedure Orders 174M 566K
KUH/O2/Epic 2003 (?) Nov 2014 various*
Procedures (CPT) 13.9M 687K
UKP Billing 2000 Nov 2014 #26
REDCap 1.06M 48.7K
REDCap July 2011 Nov 2014
Reports/Notes 70.8M 416K
KUH/O2/Epic ? Nov 2014
Specimens 126K 9.1K
KUMC Biospecimen Repository ? Nov 2014
Visit Details 81.4M 95K
KUH/O2/Epic Nov 2007 Nov 2014
Hospital Quality Metrics 7.22M 97K
University HealthSystem Consortium (UHC) Q4 2008 Sept 2014 #2911
All 1.68B

Notice

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 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:

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.

#1965
align encounters for hospital encouters; e.g. UHC LOS visit details and flow sheet vitals

Outstanding Problems/Defects/Issues

HERON Verdigris: Search laboratory tests by reference ranges

Don't know the exact reference ranges for a certain lab? No problem since you can search a subset of HERON labs by High, Low, or Normal ranges. To search lab ranges:

  • Drag a lab into the search group. The value window will display if a value exists for this lab
  • Select By Flag on the value window
  • Select Normal, High, or Low
  • Click OK and continue building your search.

Note that the value window will not appear for some labs. For example, the influenza laboratory test returns either positive or negative. As a result, you cannot search by value or range.

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

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

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 544K 248K
KUH/O2/Epic Nov 2007 Oct 2014 various*
Cancer Cases 11.3M 75.8K
KUH Cancer Registry 1950s Oct 2014 labels*
Cardiology Labs 22.6M 335K
KUH/O2/Epic Nov 2007 Oct 2014
Demographics 19.8M 2.08M
KUH Billing (O2 via SMS) 1980s Oct 2014 various*
UKP Billing 2000 Oct 2014
30.8K 30.8K Frontiers participant registry Jun 2009 Oct 2014 #2451
195K 195K Social Security Death Index 1962 Oct 2014
Diagnoses (IDC9) 69.1M 787K
KUH/O2/Epic Nov 2007 Oct 2014 various*
UKP Billing 2000 Oct 2014
University HealthSystem Consortium (UHC) Q4 2008 Sept 2014
History 31.8M 423K
KUH/O2/Epic Nov 2007 Oct 2014
Lab Results 151M 368K
KUH/O2/Epic 2003 Oct 2014 various*
Medications 155M 433K
KUH/O2/Epic (Organized by VA Class) Nov 2007 Oct 2014 various*
Microbiology 3.35M 29.5K
KUH/O2/Epic 2003 (?) Oct 2014 various*
790K 123K Negative 2003 Oct 2014
10.5K 7.78K Positive 2003 Oct 2014
Nursing Observations 865M ?
KUH/O2/Epic Nov 2007 Oct 2014 various*
Procedure Orders 171M 561K
KUH/O2/Epic 2003 (?) Oct 2014 various*
Procedures (CPT) 13.8M 683K
UKP Billing 2000 Oct 2014 #26
REDCap 1.05M 48.7K
REDCap July 2011 Oct 2014
Reports/Notes 69.2M 410K
KUH/O2/Epic ? Oct 2014
Specimens 124K 9K
KUMC Biospecimen Repository ? Oct 2014
Visit Details 68.4M 95K
KUH/O2/Epic Nov 2007 Oct 2014
Hospital Quality Metrics 7.22M 97K
University HealthSystem Consortium (UHC) Q4 2008 Sept 2014 #2911
All 1.68B

Notice

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 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:

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.

No results

Outstanding Problems/Defects/Issues

Temporal searching available in HERON Delaware release

Please note: Clear your browser cache if you receive an error when starting the HERON query tool.

Instructions to clear cache for Firefox and Chrome.

HERON Delaware upgrade to i2b2 v1.7.03 introduces the Temporal Query Tool which allows you to narrow your search by a series of events. For example:

  • Define a population
    • create a search for males with hypertension and acute myocardial infarction
  • Define events
    • Event 1 is hypertension
    • Event 2 is acute myocardial infarction
  • Define temporal relationships of the events
    • Event 1 happens before event 2 by greater than 1 day
  • Submit the query.
    • Results include the number of male patients who have had at least 1 acute myocardial infarction diagnosis after a hypertension diagnosis.

HERON issues to note due to recent data clean-up by the O2 team:

  • Deceased per Social Security Master Death File decreased due to the removal of certain Social Security Numbers in the EMR. See #2911 for more details.
  • Nursing data decreased. See #2955 for more details.

To learn more about temporal querying in 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 Delaware Contents Summary

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

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

Observation Patients Source Go-Live Snapshot Issues
Allergy 528K 242K
KUH/O2/Epic Nov 2007 Aug 2014 various*
Cancer Cases 11.1M 74.7K
KUH Cancer Registry 1950s Aug 2014 labels*
Cardiology Labs 21.7M 329K
KUH/O2/Epic Nov 2007 Aug 2014
Demographics 19.7M 2.06M
KUH Billing (O2 via SMS) 1980s Aug 2014 various*
UKP Billing 2000 Aug 2014
297K 29.7K Frontiers participant registry Jun 2009 Aug 2014 #2451
194.1K 194.1K Social Security Death Index 1962 Aug 2014 #2911
Diagnoses (IDC9) 66.2M 774K
KUH/O2/Epic Nov 2007 Aug 2014 various*
UKP Billing 2000 Aug 2014
University HealthSystem Consortium (UHC) Q4 2008 June 2014
History 29.5M 409K
KUH/O2/Epic Nov 2007 Aug 2014
Lab Results 147M 360K
KUH/O2/Epic 2003 Aug 2014 various*
Medications 124M 418K
KUH/O2/Epic (Organized by VA Class) Nov 2007 Aug 2014 various*
Microbiology 3.25M 28.7K
KUH/O2/Epic 2003 (?) Aug 2014 various*
772K 120K Negative 2003 Aug 2014
10K 7.51K Positive 2003 Aug 2014
Nursing Observations 813M ?
KUH/O2/Epic Nov 2007 Aug 2014 various* #2955
Procedure Orders 165M 549K
KUH/O2/Epic 2003 (?) Aug 2014 various*
Procedures (CPT) 13.5M 674K
UKP Billing 2000 Aug 2014 #26
REDCap 1.02M 48.7K
REDCap July 2011 Aug 2014
Reports/Notes 65.5M 396K
KUH/O2/Epic ? Aug 2014
Specimens 120K 8.75K
KUMC Biospecimen Repository ? Aug 2014
Visit Details 65.2M .93M
KUH/O2/Epic Nov 2007 Aug 2014
Hospital Quality Metrics 6.9M 93K
University HealthSystem Consortium (UHC) Q4 2008 June 2014
All 1.6B

Notice

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 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:

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.

#2825
long concept names obscure Timeline data

Outstanding Problems/Defects/Issues

HERON Wakarusa include UHC fix and Fishing Trip update

A University HealthSystem Consortium (UHC) format change for Sept 2013 to June 2014 data resulted in the exclusion of a small portion of UHC data from HERON. This issue is fixed with the HERON Wakarusa release.

The 2nd Annual HERON Fishing trip took place on July 28, 2014. Agenda and recorded sessions are available. A demo of i2b2 version 1.7 gave the attendees a glimpse of upcoming temporal searching capabilities. HERON is built upon i2b2. Look for this new functionality when HERON moves to i2b2 version 1.7 in the future.

To learn more about HERON or REDCap, 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 Wakarusa Contents Summary

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

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

Observation Patients Source Go-Live Snapshot Issues
Allergy 521K 239K
KUH/O2/Epic Nov 2007 July 2014 various*
Cancer Cases 11M 74.2K
KUH Cancer Registry 1950s July 2014 labels*
Cardiology Labs 21.3M 326K
KUH/O2/Epic Nov 2007 July 2014
Demographics 19.6M 2.06M
KUH Billing (O2 via SMS) 1980s July 2014 various*
UKP Billing 2000 July 2014
28.5K 28.5K Frontiers participant registry Jun 2009 July 2014 #2451
193.5K 193.5K Social Security Death Index 1962 July 2014
Diagnoses (IDC9) 64.8M 768K
KUH/O2/Epic Nov 2007 July 2014 various*
UKP Billing 2000 July 2014
University HealthSystem Consortium (UHC) Q4 2008 June 2014
History 28.5M 403K
KUH/O2/Epic Nov 2007 July 2014
Lab Results 145M 356K
KUH/O2/Epic 2003 July 2014 various*
Medications 122M 412K
KUH/O2/Epic (Organized by VA Class) Nov 2007 July 2014 various*
Microbiology 3.19M 28.3K
KUH/O2/Epic 2003 (?) July 2014 various*
764K 119K Negative 2003 July 2014
9.8K 7.37K Positive 2003 July 2014
Nursing Observations 823M ?
KUH/O2/Epic Nov 2007 July 2014 various*
Procedure Orders 162M 544K
KUH/O2/Epic 2003 (?) July 2014 various*
Procedures (CPT) 13.4M 669K
UKP Billing 2000 July 2014 #26
REDCap 1.02M 48.6K
REDCap July 2011 July 2014
Reports/Notes 63.8M 390K
KUH/O2/Epic ? July 2014
Specimens 115K 8.46K
KUMC Biospecimen Repository ? July 2014
Visit Details 63.7M 885K
KUH/O2/Epic Nov 2007 July 2014
Hospital Quality Metrics 6.9M 93K
University HealthSystem Consortium (UHC) Q4 2008 June 2014 #2911
All 1.6B

Notice

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 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:

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.

No results

Outstanding Problems/Defects/Issues

HERON Hackberry release includes emergency, inpatient and outpatient encounter data

Encounter types, such as inpatient, outpatient and emergency, are located within the Visit Details folder. Including or excluding specific encounter types increases your search precision, especially for common items such as an A1C test, by narrowing your search to a specific type of visit. Procedure tool tips are once again visible in this release.

Join us for the 2nd Annual HERON Fishing Trip, a training workshop on July 28, 2014, 8:00AM - 5:00PM in Dykes Library, Room G026. The workshop will include both classroom and hands-on training covering data types, basic and advanced searching, analysis tools, and future work. Register for the event.

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

HERON Hackberry Contents Summary

This month, our tour of rivers and lakes in Kansas honors the Hackberry Creek.

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 512K 236K
KUH/O2/Epic Nov 2007 June 2014 various*
Cancer Cases 10.9M 73.8K
KUH Cancer Registry 1950s June 2014 labels*
Cardiology Labs 20.9M 323K
KUH/O2/Epic Nov 2007 June 2014
Demographics 19.6M 2.05M
KUH Billing (O2 via SMS) 1980s June 2014 various*
UKP Billing 2000 June 2014
28.5K 28.5K Frontiers participant registry Jun 2009 June 2014 #2451
193.5K 193.5K Social Security Death Index 1962 June 2014
Diagnoses (IDC9) 63.1M 762K
KUH/O2/Epic Nov 2007 June 2014 various*
UKP Billing 2000 June 2014
University HealthSystem Consortium (UHC) Q4 2008 March 2014
History 27.5M 396K
KUH/O2/Epic Nov 2007 June 2014
Lab Results 143M 353K
KUH/O2/Epic 2003 June 2014 various*
Medications 120M 405K
KUH/O2/Epic (Organized by VA Class) Nov 2007 June 2014 various*
Microbiology 3.14M 27.9K
KUH/O2/Epic 2003 (?) June 2014 various*
754K 117K Negative 2003 June 2014
9.6K 7.23K Positive 2003 June 2014
Nursing Observations 785M ?
KUH/O2/Epic Nov 2007 June 2014 various*
Procedure Orders 159M 538K
KUH/O2/Epic 2003 (?) June 2014 various*
Procedures (CPT) 13.2M 663K
UKP Billing 2000 June 2014 #26
REDCap .99M 48.5K
REDCap July 2011 June 2014
Reports/Notes 62M 382K
KUH/O2/Epic ? June 2014
Specimens 113K 8.35K
KUMC Biospecimen Repository ? June 2014
Visit Details 62.2M 826K
KUH/O2/Epic Nov 2007 June 2014
Hospital Quality Metrics 5.92M 80.2K
University HealthSystem Consortium (UHC) Q4 2008 March 2014
All 1.5B

Notice

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 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:

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.

#2759
Tooltips undefined for procedures in CPT folder

Outstanding Problems/Defects/Issues

HERON Marmaton introduces Cardiology labs and BMI percentile data

The HERON Marmaton includes two new data types.

  • Cardiology lab data - search for lab orders such as Ejection Fraction, Vascular Ultrasounds, Echocardiogram, and more.
  • BMI Percentile - search BMI by CDC defined ranges for the KUMC pediatric population.

Join us for the 2nd Annual HERON Fishing Trip, a training workshop on July 28, 2014, 8:00AM - 5:00PM in Dykes Library, Room G026. The workshop will include both classroom and hands-on training covering data types, basic and advanced searching, analysis tools, and future work. Register for the event.

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

HERON Marmaton Contents Summary

This month, our tour of rivers and lakes in Kansas honors the Marmaton 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 499K 231K
KUH/O2/Epic Nov 2007 May 2014 various*
Cancer Cases 10.8M 73.3K
KUH Cancer Registry 1950s May 2014 labels*
Demographics 19.5M 2.05M
KUH Billing (O2 via SMS) 1980s May 2014 various*
UKP Billing 2000 May 2014
28.3K 28.3K Frontiers participant registry Jun 2009 May 2014 #2451
193.2K 193.2K Social Security Death Index 1962 May 2014
Diagnoses (IDC9) 62M 757K
KUH/O2/Epic Nov 2007 May 2014 various*
UKP Billing 2000 May 2014
University HealthSystem Consortium (UHC) Q4 2008 March 2014
History 26.5M 385K
KUH/O2/Epic Nov 2007 May 2014
Lab Results 141M 349K
KUH/O2/Epic 2003 May 2014 various*
Medications 118M 395K
KUH/O2/Epic (Organized by VA Class) Nov 2007 May 2014 various*
Microbiology 3.10M 27.5K
KUH/O2/Epic 2003 (?) May 2014 various*
737K 115K Negative 2003 May 2014
9.2K 6.97K Positive 2003 May 2014
Nursing Observations 772M ?
KUH/O2/Epic Nov 2007 May 2014 various*
Procedure Orders 157M 533K
KUH/O2/Epic 2003 (?) May 2014 various*
Procedures (CPT) 13.1M 661K
UKP Billing 2000 May 2014 #26
REDCap .97M 46.5K
REDCap July 2011 May 2014
Reports/Notes 60.4M 376K
KUH/O2/Epic ? May 2014
Specimens 113K 8.33K
KUMC Biospecimen Repository ? May 2014
Visit Details 57.1M 820K
KUH/O2/Epic Nov 2007 May 2014
Hospital Quality Metrics 5.92M 80.2K
University HealthSystem Consortium (UHC) Q4 2008 March 2014
All 1.5B

Notice

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 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:

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.

#2473
Query by BMI percentile (among children)

Outstanding Problems/Defects/Issues

HERON Kirwan release announces new location and time for HERON Training Clinic

Exciting changes are coming for the Frontiers Clinical and Translational Informatics Clinic. This walk-in training clinic will be held over the lunch hour on the first and third Tuesday monthly starting May 6th. Register ahead of time or drop-in with specific questions or general training for HERON and REDCap.

Where: 3001D Student Center
When: 1st and 3rd Tuesdays monthly from 12:00-1:30 PM
What: Learn about HERON and REDCap

Note: Bring your laptop to follow online. Lunch will be provided to those who register for the clinic.

HERON Kirwan Contents Summary

This month, our tour of rivers and lakes in Kansas honors Kirwan Reservior.

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

Observation Patients Source Go-Live Snapshot Issues
Allergy 486K 226K
KUH/O2/Epic Nov 2007 March 2014 various*
Cancer Cases 10.7M 72.6K
KUH Cancer Registry 1950s March 2014 labels*
Demographics 19.4M 2.04M
KUH Billing (O2 via SMS) 1980s March 2014 various*
UKP Billing 2000 March 2014
26.9K 26.9K Frontiers participant registry Jun 2009 March 2014 #2451
192.4K 192.4K Social Security Death Index 1962 March 2014
Diagnoses (IDC9) 59.4M 744K
KUH/O2/Epic Nov 2007 March 2014 various*
UKP Billing 2000 March 2014
University HealthSystem Consortium (UHC) Q4 2008 September 2013
History 24.8M 374K
KUH/O2/Epic Nov 2007 March 2014
Lab Results 137M 342K
KUH/O2/Epic 2003 March 2014 various*
Medications 114M 384K
KUH/O2/Epic (Organized by VA Class) Nov 2007 March 2014 various*
Microbiology 3.01M 26.7K
KUH/O2/Epic 2003 (?) March 2014 various*
Nursing Observations 745M ?
KUH/O2/Epic Nov 2007 March 2014 various*
Procedure Orders 151M 522K
KUH/O2/Epic 2003 (?) March 2014 various*
Procedures (CPT) 12.8M 648K
UKP Billing 2000 March 2014 #26
REDCap .94M 43.5K
REDCap July 2011 March 2014
Reports/Notes 57.1M 364K
KUH/O2/Epic ? March 2014
Specimens 106K 7.89K
KUMC Biospecimen Repository ? March 2014
Visit Details 54.6M 807K
KUH/O2/Epic Nov 2007 March 2014
Hospital Quality Metrics 5.91M 80.2K
University HealthSystem Consortium (UHC) Q4 2008 September 2013
All 1.4B

Notice

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 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:

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.

#2505
Bring Discharge Disposition for Inpatients

Outstanding Problems/Defects/Issues

HERON Arkansas release includes new discharge and risk pool data

Discharge disposition information is available in the HERON Arkansas release. New risk pool codes for roughly 1000 patients are added to HERON. The new codes are found in the University HealthSystem Consortium folder.

HERON Arkansas Contents Summary

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

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

Observation Patients Source Go-Live Snapshot Issues
Allergy 480K 224K
KUH/O2/Epic Nov 2007 Feb 2014 various*
Cancer Cases 10.6M 72.4K
KUH Cancer Registry 1950s Feb 2014 labels*
Demographics 19.4M 2.03M
KUH Billing (O2 via SMS) 1980s Feb 2014 various*
UKP Billing 2000 Feb 2014
26.6K 26.6K Frontiers participant registry Jun 2009 Feb 2014 #2451
192K 192K Social Security Death Index 1962 Feb 2014
Diagnoses (IDC9) 58.3M 739K
KUH/O2/Epic Nov 2007 Feb 2014 various*
UKP Billing 2000 Feb 2014
University HealthSystem Consortium (UHC) Q4 2008 September 2013
History 24M 368K
KUH/O2/Epic Nov 2007 Feb 2014
Lab Results 135M 339K
KUH/O2/Epic 2003 Feb 2014 various*
Medications 112M 379K
KUH/O2/Epic (Organized by VA Class) Nov 2007 Feb 2014 various*
Microbiology 2.97M 26.4K
KUH/O2/Epic 2003 (?) Feb 2014 various*
Nursing Observations 733M ?
KUH/O2/Epic Nov 2007 Feb 2014 various*
Procedure Orders 148M 517K
KUH/O2/Epic 2003 (?) Feb 2014 various*
Procedures (CPT) 12.7M 645K
UKP Billing 2000 Feb 2014 #26
REDCap .93M 43.4K
REDCap July 2011 Feb 2014
Reports/Notes 55.6M 358K
KUH/O2/Epic ? Feb 2014
Specimens 97K 7.29K
KUMC Biospecimen Repository ? Feb 2014
Visit Details 53.1M 801K
KUH/O2/Epic Nov 2007 Feb 2014
Hospital Quality Metrics 5.89M 80.2K
University HealthSystem Consortium (UHC) Q4 2008 September 2013
All 1.4B

Notice

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.

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:

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.

#1378
HERON executives are not allowed to make sponsorship requests
#2285
HERON performance page doesn't include timeline queries
#2468
Some ICD9 codes with 2 digits before the dot (e.g. 41.12) missing from HERON concepts
#2546
Some new UHC risk pool codes with ~1000 patients not searchable from i2b2
#2564
large jump in Frontiers patient numbers between Beaver and Lovewell
#2569
Incremental IDX updates each month results in data inconsistencies
#2589
new 'Antimicrobial...' REDCap project
#2607
few_missing_dx_ids fails due to multiple values in current_icd9_list column

Outstanding Problems/Defects/Issues

HERON Beaver release includes outpatient clinical services and negative microbiology improvements

Searching clinical services in HERON is no longer limited to inpatient with the introduction of ambulatory clinical services in the Beaver release. To search on a specific outpatient clinical service, go to Visit Details -> Clinical Services -> Outpatient Visits.

HERON Beaver release makes searching negative microbiology data easier with an improved hierarchy of terms.

HERON Beaver Contents Summary

This month, our tour of rivers and lakes in Kansas honors Beaver Lake.

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

Observation Patients Source Go-Live Snapshot Issues
Allergy 475K 222K
KUH/O2/Epic Nov 2007 January 2014 various*
Cancer Cases 10.5M 71.7K
KUH Cancer Registry 1950s January 2014 labels*
Demographics 19.3M 2.03M
KUH Billing (O2 via SMS) 1980s January 2014 various*
UKP Billing 2000 January 2014
26K 26K Frontiers participant registry Jun 2009 January 2014 #2451
191.7K 191.7K Social Security Death Index 1962 January 2014
Diagnoses (IDC9) 57.3M 733K
KUH/O2/Epic Nov 2007 January 2014 various*
UKP Billing 2000 January 2014
University HealthSystem Consortium (UHC) Q4 2008 September 2013
History 23.3M 364K
KUH/O2/Epic Nov 2007 January 2014
Lab Results 134M 336K
KUH/O2/Epic 2003 January 2014 various*
Medications 111M 375K
KUH/O2/Epic (Organized by VA Class) Nov 2007 January 2014 various*
Microbiology 2.93M 26.1K
KUH/O2/Epic 2003 (?) January 2014 various*
Nursing Observations 721M ?
KUH/O2/Epic Nov 2007 January 2014 various*
Procedure Orders 146M 512K
KUH/O2/Epic 2003 (?) January 2014 various*
Procedures (CPT) 12.5M 640K
UKP Billing 2000 January 2014 #26
REDCap .92M 43.4K
REDCap July 2011 January 2014
Reports/Notes 54.3M 353K
KUH/O2/Epic ? January 2014
Specimens 97K 7.29K
KUMC Biospecimen Repository ? January 2014
Visit Details 48.9M 795K
KUH/O2/Epic Nov 2007 January 2014
Hospital Quality Metrics 5.91M 80.2K
University HealthSystem Consortium (UHC) Q4 2008 September 2013
All 1.4B

Notice

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.

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:

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.

#2167
Load the microbiology results with a fact for a negative result
#2398
Query by clinical service information from IDX for Ambulatory services

Outstanding Problems/Defects/Issues

HERON Lovewell improves navigation and fixes Frontiers patient count issue

HERON Lovewell release facilitates navigation by introducing changes to the abridged Cancer Cases Identifier structure. Date ranges are added to AJCC concepts, and folders are rearranged into an intuitive order. The issue of inaccurate Frontiers Research Participant Registry patient counts ((see #2451)) is resolved. Searches will return the correct patient count when searching with the Frontiers Research Participant Registry concept.

HERON Lovewell Contents Summary

This month, our tour of rivers and lakes in Kansas honors Lovewell Lake.

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

Observation Patients Source Go-Live Snapshot Issues
Allergy 468K 219K
KUH/O2/Epic Nov 2007 December 2013 various*
Cancer Cases 10.5M 71.6K
KUH Cancer Registry 1950s December 2013 labels*
Demographics 19.2M 2.02M
KUH Billing (O2 via SMS) 1980s December 2013 various*
UKP Billing 2000 December 2013
21.4K 21.4K Frontiers participant registry Jun 2009 December 2013 #2451
191.3K 191.3K Social Security Death Index 1962 December 2013
Diagnoses (IDC9) 54M 727K
KUH/O2/Epic Nov 2007 December 2013 various*
UKP Billing 2000 December 2013
University HealthSystem Consortium (UHC) Q4 2008 September 2013
History 22.5M 359K
KUH/O2/Epic Nov 2007 December 2013
Lab Results 132M 336K
KUH/O2/Epic 2003 December 2013 various*
Medications 109M 369K
KUH/O2/Epic (Organized by VA Class) Nov 2007 December 2013 various*
Microbiology 2.88M 25.7K
KUH/O2/Epic 2003 (?) December 2013 various*
Nursing Observations 706M ?
KUH/O2/Epic Nov 2007 December 2013 various*
Procedure Orders 143M 507K
KUH/O2/Epic 2003 (?) December 2013 various*
Procedures (CPT) 11.8M 624K
UKP Billing 2000 December 2013 #26
REDCap 867K 43.4K
REDCap July 2011 December 2013
Reports/Notes 52.7M 347K
KUH/O2/Epic ? December 2013
Specimens 93K 7.01K
KUMC Biospecimen Repository ? December 2013
Visit Details 37.4M 613K
KUH/O2/Epic Nov 2007 December 2013
Hospital Quality Metrics 5.89M 80.2K
University HealthSystem Consortium (UHC) Q4 2008 September 2013
All 1.3B

Notice

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.

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:

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.

No results

Outstanding Problems/Defects/Issues

HERON Toronto update powered by newer, faster hardware and load process

With HERON Toronto we are on newer and faster hardware. Users will likely notice faster query response times. We have also streamlined our monthly process of loading data from various sources into HERON so that we can deliver the data to users faster.

With this release, data in REDCap SQL fields will also be loaded into HERON. The browsing experience for these fields will be indistinguishable from multiple choice fields. To add your REDCap project to HERON, register your project after going over the directions for readying your project.

Please note: Searches involving Frontiers Research Participant Registry patients will return an incorrect number. See #2451 for more information.

HERON Toronto Contents Summary

This month, our tour of rivers and lakes in Kansas honors Toronto Lake.

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

Observation Patients Source Go-Live Snapshot Issues
Allergy 464K 218K
KUH/O2/Epic Nov 2007 November 2013 various*
Cancer Cases 10.4M 71.0K
KUH Cancer Registry 1950s November 2013 labels*
Demographics 19.2M 2.02M
KUH Billing (O2 via SMS) 1980s November 2013 various*
UKP Billing 2000 November 2013
13.5K 13.5K Frontiers participant registry Jun 2009 November 2013 #2451
190.9K 190.9K Social Security Death Index 1962 November 2013
Diagnoses (IDC9) 53.3M 722K
KUH/O2/Epic Nov 2007 November 2013 various*
UKP Billing 2000 November 2013
University HealthSystem Consortium (UHC) Q4 2008 September 2013
History 21.9M 354K
KUH/O2/Epic Nov 2007 November 2013
Lab Results 131M 332K
KUH/O2/Epic 2003 November 2013 various*
Medications 107M 364K
KUH/O2/Epic (Organized by VA Class) Nov 2007 November 2013 various*
Microbiology 2.84M 25.3K
KUH/O2/Epic 2003 (?) November 2013 various*
Nursing Observations 695M ?
KUH/O2/Epic Nov 2007 November 2013 various*
Procedure Orders 140M 502K
KUH/O2/Epic 2003 (?) November 2013 various*
Procedures (CPT) 11.6M 622K
UKP Billing 2000 November 2013 #26
REDCap 762K 21.7K
REDCap July 2011 November 2013
Reports/Notes 51.4M 342K
KUH/O2/Epic ? November 2013
Specimens 88.5K 6.69K
KUMC Biospecimen Repository ? November 2013
Visit Details 36.6M 608K
KUH/O2/Epic Nov 2007 November 2013
Hospital Quality Metrics 5.89M 80.2K
University HealthSystem Consortium (UHC) Q4 2008 September 2013
All 1.3B

Notice

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.

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:

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.

#1967
Inpatient procedure order query uses outdated CLARITY column; returns zero counts
#2313
Navigating HERON term hierarchy is slow for users with REDCap access

Outstanding Problems/Defects/Issues

HERON Milford simplifies the Cancer Cases folder

A new folder, Cancer Cases (Abridged), debuts with the Milford release. This folder contains the frequently searched concepts from the Cancer Cases folder. Advanced searchers can still search the entire tumor registry in the unabridged folder.

The Milford release marks the 8th REDCap database integrated into HERON. When you add a REDCap patient registry to HERON, you enhance your HERON searching capabilities while at the same time enhancing your REDCap registry.

Integration of REDCap project data into HERON is driven by our desire to empower the researcher to:

  • look at a richer data picture of their project population.
  • look for disparities in data in the EMR versus the data in REDCap projects.

Since July 2012, REDCap projects that model breast cancer, Alzheimer's, Sepsis management registries among others have been integrated into HERON.

To add your REDCap project to HERON, register your project.

HERON Milford Contents Summary

This month, our tour of rivers and lakes in Kansas honors Milford Lake.

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

Observation Patients Source Go-Live Snapshot Issues
Allergy 457K 215K
KUH/O2/Epic Nov 2007 October 2013 various*
Cancer Cases 10.3M 70.6K
KUH Cancer Registry 1950s October 2013 labels*
Demographics 19.1M 2.01M
KUH Billing (O2 via SMS) 1980s October 2013 various*
UKP Billing 2000 October 2013
20K 20K Frontiers participant registry Jun 2009 October 2013
190.6K 190.6K Social Security Death Index 1962 October 2013
Diagnoses (IDC9) 52.1M 716K
KUH/O2/Epic Nov 2007 October 2013 various*
UKP Billing 2000 October 2013
University HealthSystem Consortium (UHC) Q4 2008 June 2013
History 21M 349K
KUH/O2/Epic Nov 2007 October 2013
Lab Results 129M 328K
KUH/O2/Epic 2003 October 2013 various*
Medications 105M 359K
KUH/O2/Epic (Organized by VA Class) Nov 2007 October 2013 various*
Microbiology 2.8M 25K
KUH/O2/Epic 2003 (?) October 2013 various*
Nursing Observations 682M ?
KUH/O2/Epic Nov 2007 October 2013 various*
Procedure Orders 138M 496K
KUH/O2/Epic 2003 (?) October 2013 various*
Procedures (CPT) 11.3M 617K
UKP Billing 2000 October 2013 #26
REDCap 756K 21.7K
REDCap July 2011 October 2013
Reports/Notes 49.8M 335K
KUH/O2/Epic ? October 2013
Specimens 83.6K 6.36K
KUMC Biospecimen Repository ? October 2013
Visit Details 35.7M 601K
KUH/O2/Epic Nov 2007 October 2013
Hospital Quality Metrics 5.60M 77.3K
University HealthSystem Consortium (UHC) Q4 2008 June 2013
All 1.3B

Notice

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.

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:

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.

#2082
build REDCap CRF summary data from HERON Identified Data Use Requests (DUA)
#2112
tumor registry terminology hierarchy simplified for cancer study feasibility
#2201
automate, refine building HERON DUA data sets
#2251
query by last lab value
#2298
Some REDCap fields are missing from the HERON concept tree
#2326
query for ">60" labs in, e.g. GFR Estimated
#2346
Query excluding deceased patients shows dead people in demographics plugin
#2363
De-id DUA/REDCap fulfillment has identified age.

Outstanding Problems/Defects/Issues

HERON Solomon marks the 32nd consecutive release

Over the past 32 releases, HERON grew in data, functionality, and use. New data types include REDCap projects, Biospecimen Repository, Tumor Registry information, and much more. In response to this increase, the Medical Informatics team lead the HERON Fishing Trip, an extended training workshop in August 2013. This two day event consisted of hands-on and classroom trainings with attendance both in person and online.

Since that workshop, monthly searches have surpassed 1000, Frontiers Research Participant Registry requests increased, and clinics are steadily attended. Researchers, study coordinators, students, and administrators from multiple areas of KUMC and KU Hospital search HERON. Thirty-two releases after the initial launch and HERON continues to grow.

The Solomon release includes clinical data through September 2013.

HERON Solomon Contents Summary

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

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

Observation Patients Source Go-Live Snapshot Issues
Allergy 450K 212K
KUH/O2/Epic Nov 2007 September 2013 various*
Cancer Cases 10.2M 70.1K
KUH Cancer Registry 1950s September 2013 labels*
Demographics 19.1M 2.00M
KUH Billing (O2 via SMS) 1980s August 2013 various*
UKP Billing 2000 September 2013
18.8K 18.8K Frontiers participant registry Jun 2009 September 2013
189.9K 189.9K Social Security Death Index 1962 September 2013
Diagnoses (IDC9) 51M 708K
KUH/O2/Epic Nov 2007 September 2013 various*
UKP Billing 2000 September 2013
University HealthSystem Consortium (UHC) Q4 2008 June 2013
History 20.2M 343K
KUH/O2/Epic Nov 2007 September 2013
Lab Results 94M 323K
KUH/O2/Epic 2003 September 2013 various*
Medications 103M 352K
KUH/O2/Epic (Organized by VA Class) Nov 2007 September 2013 various*
Microbiology 2.75M 24.6K
KUH/O2/Epic 2003 (?) September 2013 various*
Nursing Observations 671M ?
KUH/O2/Epic Nov 2007 September 2013 various*
Procedure Orders 135M 488K
KUH/O2/Epic 2003 (?) September 2013 various*
Procedures (CPT) 11.4M 614K
UKP Billing 2000 September 2013
REDCap 282K 4.69K
REDCap July 2011 September 2013
Reports/Notes 48.1M 328K
KUH/O2/Epic ? September 2013
Specimens 79.8K 6.12K
KUMC Biospecimen Repository ? September 2013
Visit Details 34.6M 593K
KUH/O2/Epic Nov 2007 September 2013
Hospital Quality Metrics 5.60M 77.3K
University HealthSystem Consortium (UHC) Q4 2008 June 2013
All 1.28B

Notice

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.

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:

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.

No results

Outstanding Problems/Defects/Issues

HERON Crooked Creek release introduces the HERON performance page

The performance page displays the status of searches, those complete versus incomplete, and performance times within HERON. A link to this page is located below the start query tool link.

General fixes in this release include:

  • The disappearing shared folder issue for those users with REDCap project access within HERON is resolved by allowing the user to choose between a REDCap HERON and a general HERON instance (e.g., in this month the Crooked Creek instance). The shared folder will not appear in the REDCap instance, but users can switch back and forth between the 2 HERON instances access the shared folder.
  • The Survival Analysis tools work in Internet Explorer. Previously, patient sets could not be dropped into this tool in the IE Browser.

Note: The latest University HealthSystems? Consortium (UHC) data remains at December 2012. The inability to pull new data into HERON is due to a table change within the database which the team is working to resolve.

This month, our tour of rivers and lakes in Kansas honors Crooked Creek.

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

Observation Patients Source Go-Live Snapshot Issues
Allergy 436K 207K
KUH/O2/Epic Nov 2007 July 2013 various*
Cancer Cases 10.1M 69.2K
KUH Cancer Registry 1950s July 2013 labels*
Demographics 18.9M 1.99M
KUH Billing (O2 via SMS) 1980s July 2013 various*
UKP Billing 2000 July 2013
18.1K 18.1K Frontiers participant registry Jun 2009 July 2013
189.6K 189.6K Social Security Death Index 1962 July 2013
Diagnoses (IDC9) 48.9M 694K
KUH/O2/Epic Nov 2007 July 2013 various*
UKP Billing 2000 July 2013
University HealthSystem Consortium (UHC) Q4 2008 Dec 2012
History 18.7M 332K
KUH/O2/Epic Nov 2007 July 2013
Lab Results 92M 313K
KUH/O2/Epic 2003 July 2013 various*
Medications 100M 341K
KUH/O2/Epic (Organized by VA Class) Nov 2007 July 2013 various*
Microbiology 2.66M 23.9K
KUH/O2/Epic 2003 (?) July 2013 various*
Nursing Observations 647M ?
KUH/O2/Epic Nov 2007 July 2013 various*
Order Sets 348K 44.5K
KUH/O2/Epic 2003 (?) July 2013 various*
Procedure Orders 130M 475K
KUH/O2/Epic 2003 (?) July 2013 various*
Procedures (CPT) 11M 604K
UKP Billing 2000 July 2013
REDCap 47.8K 362
REDCap July 2011 July 2013
Reports/Notes 45.3M 316K
KUH/O2/Epic ? July 2013
Specimens 71.0K 5.55K
KUMC Biospecimen Repository ? July 2013
Visit Details 32.8M 571K
KUH/O2/Epic Nov 2007 July 2013
Hospital Quality Metrics 5M 69.2K
University HealthSystem Consortium (UHC) Q4 2008 Dec 2012
All 1.18B

Notice

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.

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:

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.

No results

Outstanding Problems/Defects/Issues

HERON Big Blue release introduces allergy and reaction data

Search allergy and reaction data in the Big Blue release. This release also includes a fix for the issue of laboratory times rounding to midnight. This month, our tour of rivers and lakes in Kansas honors Big Blue River.

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

Observation Patients Source Go-Live Snapshot Issues
Allergy 425K 203K
KUH/O2/Epic Nov 2007 June 2013 various*
Cancer Cases 10.1M 68.8K
KUH Cancer Registry 1950s June 2013 labels*
Demographics 18.8M 1.98M
KUH Billing (O2 via SMS) 1980s June 2013 various*
UKP Billing 2000 June 2013
17.7K 17.7K Frontiers participant registry Jun 2009 June 2013
189.1K 189.1K Social Security Death Index 1962 June 2013
Diagnoses (IDC9) 48M 689K
KUH/O2/Epic Nov 2007 June 2013 various*
UKP Billing 2000 June 2013
University HealthSystem Consortium (UHC) Q4 2008 Dec 2012
History 18M 327K
KUH/O2/Epic Nov 2007 June 2013
Lab Results 90M 309K
KUH/O2/Epic 2003 June 2013 various*
Medications 98M 336K
KUH/O2/Epic (Organized by VA Class) Nov 2007 June 2013 various*
Microbiology 2.62M 23.5K
KUH/O2/Epic 2003 (?) June 2013 various*
Nursing Observations 636M ?
KUH/O2/Epic Nov 2007 June 2013 various*
Order Sets 334K 43K
KUH/O2/Epic 2003 (?) June 2013 various*
Procedure Orders 127M 470K
KUH/O2/Epic 2003 (?) June 2013 various*
Procedures (CPT) 11.2M 602K
UKP Billing 2000 June 2013
REDCap 40.4K 351
REDCap July 2011 June 2013 #2000
Reports/Notes 44.1M 311K
KUH/O2/Epic ? June 2013 #1955
Specimens 65.5K 5.18K
KUMC Biospecimen Repository ? June 2013
Visit Details 32M 565K
KUH/O2/Epic Nov 2007 June 2013
Hospital Quality Metrics 5M 69.2K
University HealthSystem Consortium (UHC) Q4 2008 Dec 2012
All 1.18B

Notice

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.

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:

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.

No results

Outstanding Problems/Defects/Issues

HERON Sappa release improves performance and microbiology

This release includes behind the scenes fixes to HERON. Performance speed increased in diagnosis and the timeline. Microbiology hierarchy is enhanced for improved browsing.

HERON Sappa Summary

This month, our tour of rivers and lakes in Kansas honors Sappa Creek.

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

Observation Patients Source Go-Live Snapshot Issues
Cancer Cases 10.1M 68.4K
KUH Cancer Registry 1950s May 2013 labels*
Demographics 18.8M 1.97M
KUH Billing (O2 via SMS) 1980s May 2013 various*
UKP Billing 2000 May 2013
17.1K 17.1K Frontiers participant registry Jun 2009 May 2013
188.9K 188.9K Social Security Death Index 1962 May 2013
Diagnoses (IDC9) 47.2M 684K
KUH/O2/Epic Nov 2007 May 2013 various*
UKP Billing 2000 May 2013
University HealthSystem Consortium (UHC) Q4 2008 Dec 2012
History 17.4M 322K
KUH/O2/Epic Nov 2007 May 2013
Lab Results 89.3M 306K
KUH/O2/Epic 2003 May 2013 various*
Medications 97M 332K
KUH/O2/Epic (Organized by VA Class) Nov 2007 May 2013 various*
Microbiology 2.58M 23.2K
KUH/O2/Epic 2003 (?) May 2013 various*
Nursing Observations 625M ?
KUH/O2/Epic Nov 2007 May 2013 various*
Order Sets 322K 41.7K
KUH/O2/Epic 2003 (?) May 2013 various*
Procedure Orders 125M 466K
KUH/O2/Epic 2003 (?) May 2013 various*
Procedures (CPT) 11.1M 598K
UKP Billing 2000 May 2013
REDCap 40.2K 348
REDCap July 2011 May 2013 #2000
Reports/Notes 42.9M 307K
KUH/O2/Epic ? May 2013 #1955
Specimens 59.4K 4.79K
KUMC Biospecimen Repository ? May 2013
Visit Details 31.3M 560K
KUH/O2/Epic Nov 2007 May 2013
Hospital Quality Metrics 5M 69.2K
University HealthSystem Consortium (UHC) Q4 2008 Dec 2012
All 1.13B

Notice

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.

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:

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.

No results

Outstanding Problems/Defects/Issues

HERON Smoky Hill release enhances the timeline tool and limits REDCap access

Name and value (if applicable) are now available in the Timeline tool when hovering over an event. This enhancement expands the data analysis capabilities within HERON. For example, if you are interested in when antineoplastics were received in a patient set, you can add the antineoplastics folder to the timeline tool. Upon hovering over each event tic name of the antineoplastic and value if provided is displayed. Previously, users could easily see when the antineoplastic was administered in relation to a diagnosis, but the addition of these labels and values allows the users to see if a patient received more than one antineoplastic type and when that change occurred.

Access to REDCap projects in HERON is now limited to only those users defined in the REDCap project. If a user is not a member of the project, the project will not be visible within the HERON navigation tree to that user. It will be visible to project members who can add the project to queries within HERON.

HERON Smoky Hill Contents Summary

This month, our tour of rivers and lakes in Kansas honors Smoky Hill River.

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

Observation Patients Source Go-Live Snapshot Issues
Demographics 18.6M 1.96M
KUH Billing (O2 via SMS) 1980s March 2013 various*
UKP Billing 2000 March 2013
16.2K 16.2K Frontiers participant registry Jun 2009 March 2013
188.1K 188.1K Social Security Death Index 1962 March 2013
Diagnoses (IDC9) 45M 672K
KUH/O2/Epic Nov 2007 March 2013 various*
UKP Billing 2000 March 2013
University HealthSystem Consortium (UHC) Q4 2008 Dec 2012
History 15.7M 308K
KUH/O2/Epic Nov 2007 March 2013
Medications 92M 318K
KUH/O2/Epic (Organized by VA Class) Nov 2007 March 2013 various*
Nursing Observations 597M ?
KUH/O2/Epic Nov 2007 March 2013 various*
Lab Results 86.4M 298K
KUH/O2/Epic 2003 March 2013 various*
Order Sets 289K 38.1K
KUH/O2/Epic 2003 (?) March 2013 various*
Procedure Orders 120M 455K
KUH/O2/Epic 2003 (?) March 2013 various*
Procedures (CPT) 10.9M 589K
UKP Billing 2000 March 2013
REDCap 37.4K 328
REDCap July 2011 March 2013 #2000
Reports/Notes 13.4M 276K
KUH/O2/Epic ? March 2013
Specimens 49.2K 4.12K
KUMC Biospecimen Repository ? March 2013
Visit Details 29.3M 545K
KUH/O2/Epic Nov 2007 March 2013
Cancer Cases 9.9M 67.6K
KUH Cancer Registry 1950s March 2013 labels*
Hospital Quality Metrics 5.08M 69.2K
University HealthSystem Consortium (UHC) Q4 2008 Dec 2012
All 1.09B

Notice

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.

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:

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.

#1880
Simultaneous access to multiple REDCap projects in i2b2

Outstanding Problems/Defects/Issues

HERON Neosho includes same financial encounter search optimization and text labels for tumor registry

The Neosho update replaces numerical codes with text labels for tumor registry primary site and histology. Support for user-selected outcomes in the multi-cohort analysis tool has been fixed (though initialization issues remain). New UHC data includes low socioeconomic status and admission source.

Previously, limiting searches to the same financial encounter meant increased query times. This release fixes the issue resulting in quicker queries.

HERON Neosho Contents Summary

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

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

Observation Patients Source Go-Live Snapshot Issues
Demographics 18.6M 1.95M
KUH Billing (O2 via SMS) 1980s Jan 2013 various*
UKP Billing 2000 Jan 2013
15.4K 15.4K Frontiers participant registry Jun 2009 Jan 2013
187.5K 187.5K Social Security Death Index 1962 Jan 2013
Diagnoses (IDC9) 43.2M 662K
KUH/O2/Epic Nov 2007 Jan 2013 various*
UKP Billing 2000 Jan 2013
University HealthSystem Consortium (UHC) Q4 2008 Sept 2012
History 14.3M 297K
KUH/O2/Epic Nov 2007 Jan 2013
Medications 79.9M 307K
KUH/O2/Epic (Organized by VA Class) Nov 2007 Jan 2013 various*
Nursing Observations 573M ?
KUH/O2/Epic Nov 2007 Jan 2013 various*
Lab Results 84.1M 292K
KUH/O2/Epic 2003 Jan 2013 various*
Procedure Orders 115M 446K
KUH/O2/Epic 2003 (?) Jan 2013 various*
Procedures (CPT) 10.7M 581K
UKP Billing 2000 Jan 2013
Reports/Notes 36.8M 283K
KUH/O2/Epic ? Jan 2013
Specimens 45.4K 3.88K
KUMC Biospecimen Repository ? Jan 2013
Visit Details 27.8M 533K
KUH/O2/Epic Nov 2007 Jan 2013
Cancer Cases 9.7M 66.8K
KUH Cancer Registry 1950s Jan 2013 labels*
Hospital Quality Metrics 4.75M 65.2K
University HealthSystem Consortium (UHC) Q4 2008 Sept 2012
Triple Negative Breast Cancer Registry (BRCA) 27.6K 161
REDCap July 2011 Jan 2013 #1741
All 1B

Notice

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.

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:

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.

#1492
Include dose (discrete/range) in Medication Order Facts in DUA results
#1694
harvest past surgical history
#1720
get the Low Socioeconomic Status (low SES) flag from UHC into HERON
#1727
Add missing concepts for medical and family history
#1739
History hierarchy doesn't have patient counts
#1743
multi-cohort survival plugin "run analysis" button unresponsive when "other" outcome is selected
#1745
Patients that die 1 day before their 91st birthday on a leap year will have a calculated age of 91 in deid
#1767
De-id birthdate incorrectly adjusted for people over 90 who are dead according to Epic
#1775
Create top-level medication concept for NO HOME MEDICATIONS

Outstanding Problems/Defects/Issues

HERON Council Grove update includes histories, encounter vitals and expanded smart notes

The Council Grove release introduces family and social histories within the HERON tool. Family history can be searched by all or by a particular family member type (e.g., Maternal Grandmother). Additionally, a new modifier allows searching by medical history within the clinical diagnosis folders. Other data changes within HERON include encounter vitals, which are searchable under the Visit Detail folder, and smart data notes, which are expanded to include ambulatory in addition to the previously released inpatient notes.

HERON Council Grove Contents Summary

This month, our tour of rivers and lakes in Kansas honors Council Grove Lake.

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

Observation Patients Source Go-Live Snapshot Issues
Demographics 18.5M 1.95M
KUH Billing (O2 via SMS) 1980s Dec 2012 various*
UKP Billing 2000 Dec 2012
15K 15K Frontiers participant registry Jun 2009 Dec 2012
187K 187K Social Security Death Index 1962 Dec 2012
Diagnoses (IDC9) 42.4M 657K
KUH/O2/Epic Nov 2007 Dec 2012 various*
UKP Billing 2000 Dec 2012
University HealthSystem Consortium (UHC) Q4 2008 Sept 2012
History 10.9M
KUH/O2/Epic Nov 2007 Dec 2012
Medications 78.7M 302K
KUH/O2/Epic (Organized by VA Class) Nov 2007 Dec 2012 various*
Nursing Observations 563M ?
KUH/O2/Epic Nov 2007 Dec 2012 various*
Lab Results 83M 289K
KUH/O2/Epic 2003 Dec 2012 various*
Procedure Orders 113M 441K
KUH/O2/Epic 2003 (?) Dec 2012 various*
Procedures (CPT) 10.6M 578K
UKP Billing 2000 Dec 2012
Reports/Notes 35.7M 278K
KUH/O2/Epic ? Dec 2012
Specimens 44.3K 3.79K
KUMC Biospecimen Repository ? Dec 2012
Visit Details 27M 527K
KUH/O2/Epic Nov 2007 Dec 2012
Cancer Cases 9.8M 66.4K
KUH Cancer Registry 1950s Dec 2012 labels*
Hospital Quality Metrics 4.43M 65.2K
University HealthSystem Consortium (UHC) Q4 2008 Sept 2012
Triple Negative Breast Cancer Registry (BRCA) 20.9K 122
REDCap July 2011 Dec 2012 #1741
All 1B

Notice

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.

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:

Enhancements and Problems/Defects/Issues Addressed in this Release

#178
Query for encounter vitals in HERON
#766
Query for social history (e.g. tobacco use) in HERON
#826
some flowsheet observations are not connected to the relevant encounter
#1515
Query past medical and family history from Epic for ambulatory and inpatient
#1516
query smart data note concepts from the ambulatory environment
#1655
realistic date-of-death exposed details about ages > 90

Outstanding Problems/Defects/Issues

HERON Melvern update allows search by category and enhanced medication dose modifiers

Melvern update includes a new way to narrow a term search. Within the "Find Terms" tab, you can limit your "Search by Names" to a specific category, such as flowsheets or diagnosis. Additionally, you may notice the top-level folder (entitled HERON) is removed to allow less clicks to browse for terms.

Additional dose types are added to medication modifiers.

HERON Melvern Contents Summary

This month, our tour of rivers and lakes in Kansas honors Melvern Lake.

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

Observation Patients Source Go-Live Snapshot Issues
Demographics 18.4M 1.94M
KUH Billing (O2 via SMS) 1980s Oct 2012 various*
UKP Billing 2000 Oct 2012
13.8K 13.8K Frontiers participant registry Jun 2009 Oct 2012
186.2K 186.2K Social Security Death Index 1962 Oct 2012
Diagnoses (IDC9) 34.2M 644K
KUH/O2/Epic Nov 2007 Oct 2012 various*
UKP Billing 2000 Oct 2012
University HealthSystem Consortium (UHC) Q4 2008 June 2012
Medications 75.9M 289K
Organized by VA Class Nov 2007 Oct 2012
KUH/O2/Epic Nov 2007 Oct 2012 various*
Nursing Observations 536M ?
KUH/O2/Epic Nov 2007 Oct 2012 various*
Lab Results 80.3M 282K
KUH/O2/Epic 2003 Oct 2012 various*
Procedure Orders 53.9M 431K
KUH/O2/Epic 2003 (?) Oct 2012 various*
Procedures (CPT) 10.5M 571K
UKP Billing 2000 Oct 2012
Reports/Notes 24.7M 218K
KUH/O2/Epic ? Oct 2012
Specimens 41.1K 3.57K
KUMC Biospecimen Repository ? Oct 2012
Visit Details ? ?
KUH/O2/Epic Nov 2007 Oct 2012 #1514
Cancer Cases 9.5M 65.7K #1600
KUH Cancer Registry 1950s Oct 2012 labels*
Hospital Quality Metrics 4.12M 60.9K
University HealthSystem Consortium (UHC) Q4 2008 June 2012
Triple Negative Breast Cancer Registry (BRCA) 17.8K 133
REDCap July 2011 Sept 2012
All 816M

Notice

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.

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:

Enhancements and Problems/Defects/Issues Addressed in this Release

No results

Outstanding Problems/Defects/Issues

HERON Waconda update introduces new searching modifiers for Medications and Diagnosis

Searching with the Medical Administration Record (MAR) concepts limit your search to only medication administered in a specific way. For example, you can search for bolus in a bag or exclude medications denied. Diagnosis modifiers allow you to specify whether to search electronic medical record(O2), billing (IDX), or quality measures (UHC) diagnosis data. Both types of modifiers offer you the flexibility to narrow your search criteria when desired thus increasing the precision of search results.

HERON Waconda Contents Summary

This month, our tour of rivers and lakes in Kansas honors Waconda Lake.

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

Observation Patients Source Go-Live Snapshot Issues
Demographics 18.3M 1.93M
KUH Billing (O2 via SMS) 1980s Aug 2012 various*
UKP Billing 2000 Aug 2012
12.8K 12.8K Frontiers participant registry Jun 2009 Aug 2012
185.5K 185.5k Social Security Death Index 1962 Aug 2012
Diagnoses (IDC9) 33.1M 632K
KUH/O2/Epic Nov 2007 Aug 2012 various*
UKP Billing 2000 Aug 2012
University HealthSystem Consortium (UHC) Q4 2008 June 2012
Medications
66.8M 277K Organized by Hospital Hierarchy Nov 2007 Aug 2012
65.9M 277K Organized by VA Class Nov 2007 Aug 2012 #1246
KUH/O2/Epic Nov 2007 Aug 2012 various*
Nursing Observations 515M ?
KUH/O2/Epic Nov 2007 Aug 2012 various*
Lab Results 78.1M 275K
KUH/O2/Epic 2003 Aug 2012 various*
Procedure Orders 51.6M 420K
KUH/O2/Epic 2003 (?) Aug 2012 #1363, various*
Procedures (CPT) 10.3M 563K
UKP Billing 2000 Aug 2012
Reports/Notes 2.40M 191K
KUH/O2/Epic ? Aug 2012 #1363
Specimens 34.6K 3.22K
KUMC Biospecimen Repository ? Aug 2012
Visit Details 2.34M 308K
KUH/O2/Epic Nov 2007 Aug 2012
Cancer Cases 9.5M 64.8K
KUH Cancer Registry 1950s Aug 2012 labels*
Hospital Quality Metrics 4.12M 60.9K
University HealthSystem Consortium (UHC) Q4 2008 June 2012 #1359, #1364
Triple Negative Breast Cancer Registry (BRCA) 17.8K 133
REDCap July 2011 Aug 2012
All 816M

Notice

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.

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:

Enhancements and Problems/Defects/Issues Addressed in this Release

#280
search for diagnosis by source: encounter, problem list, UKP IDX billing, UHC

Outstanding Problems/Defects/Issues

HERON: Marion release increases UHC and medication data

The Marion release adds ICD-9 codes for both procedures and diagnosis, in addition to increasing year range to include 2009-2012 for UHC data. Inpatient and outpatient medication orders are now available. Marion release also includes two bug fixes: searching with the exclude limit now returns the correct results and password issues no longer make the system hang.

Since February 2012, search performance is slower than expected in HERON.  We are working to resolve this issue (#1069).

HERON Marion Contents Summary

This month, our tour of rivers and lakes in Kansas honors Marion County Lake, which has, unfortunately, been overcome with blue algae.

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

Observation Patients Source Go-Live Snapshot Issues
Demographics 18.1M 1.91M
KUH Billing (O2 via SMS) 1980s Apr 2012 various*
UKP Billing 2000 Apr 2012
9.5K 9.5K Frontiers participant registry Jun 2009 Apr 2012
183K 183k Social Security Death Index 1962 Apr 2012
Diagnoses (IDC9) 19.8M 607K
KUH/O2/Epic Nov 2007 Apr 2012 various*
UKP Billing 2000 Apr 2012
Medications 98M 250K
KUH/O2/Epic Nov 2007 Apr 2012 various*
Nursing Observations 468M ?
KUH/O2/Epic Nov 2007 Apr 2012 various*
Lab Results 73.5M 260K
KUH/O2/Epic 2003 Apr 2012 various*
Procedures (CPT) 9.9M 547K
UKP Billing 2000 Apr 2012
Specimens 29.4K 2.92K
KUMC Biospecimen Repository ? Apr 2012
Cancer Cases 9.2M 63.1K
KUH Cancer Registry 1950s Apr 2012 labels*
Hospital Quality Metrics 3.04M 53.8K
University HealthSystem Consortium (UHC) N/A Apr 2011
All 725M

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:

Enhancements and Problems/Defects/Issues Addressed in this Release

No results

Outstanding Problems/Defects/Issues

Health of the Public poster session shows time-saving benefits of Informatics Tools

The most recent Health of the Public (HOP) student poster session in April provided another glimpse into student research at KUMC. I am continually impressed by the hard work of these students to create a project, collect data, analyze the data, and present within four weeks. The best part of the HOP poster sessions, for me, is speaking with the students to learn how they employ our informatics tools, what worked or didn’t, and seeing the impact of our tools on student research in general. In this session, the majority of the posters mentioned REDCap, and a few highlighted HERON. Many students praised our tools and in particular, the time saved in collecting and analyzing the data. Each poster session presents new questions regarding public health, new ways in which the data is collected and analyzed, and an increased role for informatics tools. I am looking forward to seeing what the next poster session in October holds.

HERON Clinton Release includes Race/Ethnicity fix

In this release the long-standing race/ethnicity issue is resolved. Previously, both were erroneously combined. With this fix, race and ethnicity can be searched individually.

HERON Clinton Contents Summary

This month, our tour of rivers and lakes in Kansas honors lake Clinton.

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

Observation Patients Source Go-Live Snapshot Issues
Demographics 16.4M 1.89M
KUH Billing (O2 via SMS) 1980s Jan 2012 various*
UKP Billing 2000 Jan 2012
8.36K 8.36K Frontiers participant registry Jun 2009 Jan 2012
182K 182k Social Security Death Index 1962 Jan 2012
Diagnoses (IDC9) 18.1M 590K
KUH/O2/Epic Nov 2007 Jan 2012 various*
UKP Billing 2000 Jan 2012
Medications 28.3M 104K
KUH/O2/Epic Nov 2007 Jan 2012 various*
Nursing Observations 439M ?
KUH/O2/Epic Nov 2007 Jan 2012 various*
Lab Results 70.3M 250K
KUH/O2/Epic 2003 Jan 2012 various*
Procedures (CPT) 9.5M 535K
UKP Billing 2000 Jan 2012
Specimens 26.2K 2.71K
KUMC Biospecimen Repository ? Jan 2012
Cancer Cases 8.96M 61.9K
KUH Cancer Registry 1950s Jan 2012 labels*
All 614M

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:

Enhancements and Problems/Defects/Issues Addressed in this Release

No results

Outstanding Problems/Defects/Issues