Posts in category feature

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 Ray Hubbard Features Search Diagnoses by ICD10

It is now possible to search diagnoses by either ICD9 or ICD10. ICD10 has been used in O2 since the Epic 2014 upgrade early in 2015. GE IDX will move to ICD10 in October of this year.

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 Ray Hubbard 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 Ray Hubbard located in Dallas, Texas.

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

Observation Patients Source Go-Live Snapshot Issues
Alerts 19.4M 440K
KUH/O2/Epic Nov 2007 Aug 2015
Allergy 608K 272K
KUH/O2/Epic Nov 2007 Aug 2015 various*
Cancer Cases 12.1M 80.7K
KUH Cancer Registry 1950s Aug 2015 labels*
Cardiology Labs 26.4M 366K
KUH/O2/Epic Nov 2007 Aug 2015
Demographics 26.0M 2.14M
KUH Billing (O2 via SMS) 1980s Aug 2015 various*
UKP Billing 2000 Jun 2015
37.7K 37.7K Frontiers participant registry Jun 2009 Aug 2015
199.6K 199.6K Social Security Death Index 1962 Aug 2015
Diagnoses (IDC9, ICD10) 88.1M* 851K*
KUH/O2/Epic Nov 2007 Aug 2015 various*
UKP Billing 2000 Aug 2015
University HealthSystem Consortium (UHC) Q4 2008 Mar 2015
History 42.9M 482K
KUH/O2/Epic Nov 2007 Aug 2015
Lab Results 171M 403K
KUH/O2/Epic 2003 Aug 2015 various*
Medications 210M 493K
KUH/O2/Epic (Organized by VA Class) Nov 2007 Aug 2015 various*
Microbiology 3.94M 33.5K
KUH/O2/Epic 2003 (?) Aug 2015 various*
877K 135K Negative 2003 Aug 2015
13.4K 9.6K Positive 2003 Aug 2015
National Cardiovascular Data Registry 1.33M 11.3K
NCDR (?) Aug 2015
Nursing Observations 970M ?
KUH/O2/Epic Nov 2007 Aug 2015 various*
Procedure Orders 201M 616K
KUH/O2/Epic 2003 (?) Aug 2015 various*
Procedures (CPT) 15.1M 732K
UKP Billing 2000 Aug 2015
REDCap 1.25M 49.5K
REDCap July 2011 Aug 2015
Reports/Notes 86.6M 469K
KUH/O2/Epic ? Aug 2015
Specimens 137K 9.7K
KUMC Biospecimen Repository ? Jun 2015
Visit Details 96M 1.01M
KUH/O2/Epic Nov 2007 Aug 2015
Hospital Quality Metrics 8.28M 108K
University HealthSystem Consortium (UHC) Q4 2008 Mar 2015 #2911
All 2.03B

* 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 Webster release finely tunes data fulfillment and fixes search timeout issue

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

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

Questions about HERON? Join the Frontiers Lunch and Learn which meets the 1st and 3rd Tuesdays of each month from 12:00 - 1:30 PM in room 3001D Student Center. Register in advance if possible but drop-ins are welcome.

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

HERON Webster Contents Summary

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

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

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

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.

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

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

HERON Saline Release integrates 1.6 billion observations from 8 data sources

The HERON Saline release includes data from the KU Hospital EMR, tumor registry etc. through September, 2014.

Having trouble creating complex searches in HERON? Seeking support for your grant or proposal? Note HERON Team offers support for complex searching, data access on an hourly fee-for-service basis.

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

HERON Saline Contents Summary

This month, our tour of rivers and lakes in Kansas honors the Saline 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 537K 246K
KUH/O2/Epic Nov 2007 Sept 2014 various*
Cancer Cases 11.1M 75K
KUH Cancer Registry 1950s Sept 2014 labels*
Cardiology Labs 22.2M 333K
KUH/O2/Epic Nov 2007 Sept 2014
Demographics 19.8M 2.07M
KUH Billing (O2 via SMS) 1980s Sept 2014 various*
UKP Billing 2000 Sept 2014
30.2K 30.2K Frontiers participant registry Jun 2009 Sept 2014 #2451
194.5K 194.5K Social Security Death Index 1962 Sept 2014
Diagnoses (IDC9) 67.7M 781K
KUH/O2/Epic Nov 2007 Sept 2014 various*
UKP Billing 2000 Sept 2014
University HealthSystem Consortium (UHC) Q4 2008 June 2014
History 30.8M 417K
KUH/O2/Epic Nov 2007 Sept 2014
Lab Results 149M 364K
KUH/O2/Epic 2003 Sept 2014 various*
Medications 126M 425K
KUH/O2/Epic (Organized by VA Class) Nov 2007 Sept 2014 various*
Microbiology 3.31M 29.1K
KUH/O2/Epic 2003 (?) Sept 2014 various*
782K 121K Negative 2003 Sept 2014
10.3K 7.68K Positive 2003 Sept 2014
Nursing Observations 852M ?
KUH/O2/Epic Nov 2007 Sept 2014 various*
Procedure Orders 169M 556K
KUH/O2/Epic 2003 (?) Sept 2014 various*
Procedures (CPT) 13.6M 678K
UKP Billing 2000 Sept 2014 #26
REDCap 1.04M 48.7K
REDCap July 2011 Sept 2014
Reports/Notes 67.6M 404K
KUH/O2/Epic ? Sept 2014
Specimens 121K 8.83K
KUMC Biospecimen Repository ? Sept 2014
Visit Details 67M 940K
KUH/O2/Epic Nov 2007 Sept 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.

#3034
portable Data Builder

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 Republican: searching by lab value fixed and microbiology positive results available

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

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

HERON Republican Contents Summary

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

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

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

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.

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

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

KUMC receives PCORI award to lead Greater Plains Collaborative

The Greater Plains Collaborative award from the Patient-Centered Outcomes Research Institute (PCORI) provides $7 million for a project that will establish a new network of nine medical centers in seven states committed to building a data set from electronic medical records that will be used to contribute to new research in the fields of breast cancer, obesity and amyotrophic lateral sclerosis (also known as ALS, or Lou Gehrig's disease).

The principal investigator of the project is Russ Waitman, director of medical informatics at KU Medical Center. The HERON technology developed by the medical informatics team plays a prominent role.

Further reading:

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 Chikaskia release introduces HERON DUA to REDCap & KU ADC data

When you request data from HERON you can receive the data via a REDCap project. The data will be pivoted into a user-friendly format and available in REDCap CRFs. The data will reside on REDCap servers cutting down the use of email in sharing data.

Data from University of Kansas Alzheimer's Disease Center(KU ADC) REDCap project is now part of HERON. This project has a richly characterized cohort of over 300 Alzheimer's patients. You can access this data only if you have the permissions to the related REDCap project. Please contact Dr.Jeff Burns (jburns2@…) if you would like to look at these patients in HERON.

HERON is now on i2b2 v1.6.09. Queries including concepts with symbols like < are now working.

General fixes in this release include:

  • HERON databases are now running on a newer version of Oracle.
  • UHC data is now under the folder University HealthSystem Consortium
  • HERON help button is functional again.

Note: The latest University HealthSystems Consortium (UHC) is current through June 2013.

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

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

Observation Patients Source Go-Live Snapshot Issues
Allergy 442K 210K
KUH/O2/Epic Nov 2007 August 2013 various*
Cancer Cases 10.2M 69.7K
KUH Cancer Registry 1950s August 2013 labels*
Demographics 19.0M 2.00M
KUH Billing (O2 via SMS) 1980s August 2013 various*
UKP Billing 2000 August 2013
18.8K 18.8K Frontiers participant registry Jun 2009 August 2013
189.9K 189.9K Social Security Death Index 1962 August 2013
Diagnoses (IDC9) 50M 701K
KUH/O2/Epic Nov 2007 August 2013 various*
UKP Billing 2000 August 2013
University HealthSystem Consortium (UHC) Q4 2008 June 2013
History 19.4M 337K
KUH/O2/Epic Nov 2007 August 2013
Lab Results 93M 318K
KUH/O2/Epic 2003 August 2013 various*
Medications 102M 346K
KUH/O2/Epic (Organized by VA Class) Nov 2007 August 2013 various*
Microbiology 2.71M 24.2K
KUH/O2/Epic 2003 (?) August 2013 various*
Nursing Observations 659M ?
KUH/O2/Epic Nov 2007 August 2013 various*
Procedure Orders 132M 482K
KUH/O2/Epic 2003 (?) August 2013 various*
Procedures (CPT) 11.1M 608K
UKP Billing 2000 August 2013
REDCap 266K 4.51K
REDCap July 2011 August 2013
Reports/Notes 46.7M 322K
KUH/O2/Epic ? August 2013
Specimens 76.6K 5.91K
KUMC Biospecimen Repository ? August 2013
Visit Details 33.7M 586K
KUH/O2/Epic Nov 2007 August 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.

#1833
Searching for some concepts (e.g. VANCOMYCIN(<5KG/NICU) INJ 5MG/ML) results in error
#2186
visit-oriented REDCap CRFs for HERON Data Use Requests (DUA)
#2227
Delete Concept in I2B2 web app naively deletes the first occurrence of the concept, not the one selected
#2250
dragging ChrisMackaySolidTumorProgressed from shared folder to query tool hangs

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 Medicine Lodge introduces Microbiology Lab results

Microbiology laboratory results are searchable by source, organism, antibiotic, or sensitivity levels. Patient statistics are corrected to diagnosis display the correct number, and patients will no longer appear in ICU Length of Stay results unless they have an ICU stay of 1 day or greater.

HERON Smoky Hill Contents Summary

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

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 10M 67.9K
KUH Cancer Registry 1950s April 2013 labels*
Demographics 18.7M 1.96M
KUH Billing (O2 via SMS) 1980s April 2013 various*
UKP Billing 2000 April 2013
16.7K 16.7K Frontiers participant registry Jun 2009 April 2013
188.5K 188.5K Social Security Death Index 1962 April 2013
Diagnoses (IDC9) 45.9M 677K
KUH/O2/Epic Nov 2007 April 2013 various*
UKP Billing 2000 April 2013
University HealthSystem Consortium (UHC) Q4 2008 Dec 2012
History 16.4M 314K
KUH/O2/Epic Nov 2007 April 2013
Lab Results 87.6M 298K
KUH/O2/Epic 2003 April 2013 various*
Medications 94.6M 324K
KUH/O2/Epic (Organized by VA Class) Nov 2007 April 2013 various*
Microbiology 2.5M 22.7K
KUH/O2/Epic 2003 (?) April 2013 various*
Nursing Observations 609M ?
KUH/O2/Epic Nov 2007 April 2013 various*
Order Sets 303K 39.6K
KUH/O2/Epic 2003 (?) April 2013 various*
Procedure Orders 122M 460K
KUH/O2/Epic 2003 (?) April 2013 various*
Procedures (CPT) 11M 593K
UKP Billing 2000 April 2013
REDCap 37.4K 328
REDCap July 2011 March 2013 #2000
Reports/Notes 41M 299K
KUH/O2/Epic ? April 2013 #1955
Specimens 52K 4.32K
KUMC Biospecimen Repository ? April 2013
Visit Details 30.1M 551K
KUH/O2/Epic Nov 2007 April 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 Cow Creek release includes order sets and analysis tool enhancements

Previously, the Multi-Cohort Survival Analysis tool had the option to limit by 5 years, 10 years or All. This release expands that option to weeks, days, or hours in addition to years. The Timeline analysis tool increases granularity to display by the hour as opposed to day as in previous releases.

The Cow Creek release introduces order sets as a new searchable data type. This release also kicks off the ability to limit MAR by dose.

HERON Cow Creek Contents Summary

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

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 Feb 2013 various*
UKP Billing 2000 Feb 2013
15.8K 15.8K Frontiers participant registry Jun 2009 Feb 2013
187.8K 187.8K Social Security Death Index 1962 Feb 2013
Diagnoses (IDC9) 44.1M 667K
KUH/O2/Epic Nov 2007 Feb 2013 various*
UKP Billing 2000 Feb 2013
University HealthSystem Consortium (UHC) Q4 2008 Dec 2012
History 15M 302K
KUH/O2/Epic Nov 2007 Feb 2013
Medications 91M 313K
KUH/O2/Epic (Organized by VA Class) Nov 2007 Feb 2013 various*
Nursing Observations 585M ?
KUH/O2/Epic Nov 2007 Feb 2013 various*
Lab Results 85.2M 295K
KUH/O2/Epic 2003 Feb 2013 various*
Order Sets 275K
KUH/O2/Epic 2003 (?) Feb 2013 various*
Procedure Orders 117M 450K
KUH/O2/Epic 2003 (?) Feb 2013 various*
Procedures (CPT) 10.8M 585K
UKP Billing 2000 Feb 2013
Reports/Notes 38M 288K
KUH/O2/Epic ? Feb 2013
Specimens 47.4K 4K
KUMC Biospecimen Repository ? Feb 2013
Visit Details 28.5M 539K
KUH/O2/Epic Nov 2007 Feb 2013
Cancer Cases 9.8M 67.1K
KUH Cancer Registry 1950s Feb 2013 labels*
Hospital Quality Metrics 5.10M 69.2K
University HealthSystem Consortium (UHC) Q4 2008 Dec 2012
Triple Negative Breast Cancer Registry (BRCA) 27.6K 161
REDCap July 2011 Jan 2013 #1741
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.

#1526
Load Orderset Usage into HERON
#1685
Add sponsor, title, and description to HERON Usage Audit Report
#1742
multi-cohort survival plugin fails to initialize after the 1st time
#1835
HERON uses ICD-O-2 labels for ICD-O-3 morphology/histology cancer tumor registry codes
#1849
flexible time windows for HERON Multi-cohort survival analysis tool
#1891
handle times, not just dates, in i2b2 timeline in HERON

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 Elk City updates to i2b2 v1.6.07 and includes Ambulatory Nursing Documentation and Orders

The Elk City HERON release includes an upgrade to the i2b2 software version 1.6.07. Width of the Query Tool and Navigate Terms workspaces can be resized by dragging the vertical bar between the areas. Query within query fixed to provide correct patient numbers. We have also incorporated nursing/multidisciplinary flowsheet data from the ambulatory clinics (an additional 20 million facts) as well as procedure orders (from 54 million to 110 million).  For the flowsheet data, check out the "UKP" folder and the "KU AMB" and "KU GEN CARD" subfolders under "KU" in the ontology for many of the new types of data now exposed by HERON for clinic visits.  This release also includes many fixes behind the scenes not visible through the interface.

Note that this month, the Smart Data elements contained within physician notes were not loaded due to a data inconsistency detected by our loading process. We are investigating the root cause but do not want this fairly new data source to delay the release of the database for this month. See ticket 1516 for details.

HERON Elk City Contents Summary

This month, our tour of rivers and lakes in Kansas honors Elk City Reservoir.

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

Observation Patients Source Go-Live Snapshot Issues
Demographics 18.5M 1.94M
KUH Billing (O2 via SMS) 1980s Nov 2012 various*
UKP Billing 2000 Nov 2012
14.3K 14.3K Frontiers participant registry Jun 2009 Nov 2012
186.6K 186.6K Social Security Death Index 1962 Nov 2012
Diagnoses (IDC9) 34.7M 649K
KUH/O2/Epic Nov 2007 Nov 2012 various*
UKP Billing 2000 Nov 2012
University HealthSystem Consortium (UHC) Q4 2008 June 2012
Medications 77.2M 295K
KUH/O2/Epic (Organized by VA Class) Nov 2007 Nov 2012 various*
Nursing Observations 557M ?
KUH/O2/Epic Nov 2007 Nov 2012 various*
Lab Results 81.6M 285K
KUH/O2/Epic 2003 Nov 2012 various*
Procedure Orders 110M 436K
KUH/O2/Epic 2003 (?) Nov 2012 various*
Procedures (CPT) 10.5M 574K
UKP Billing 2000 Nov 2012
Reports/Notes 9.5M 222K
KUH/O2/Epic ? Nov 2012
Specimens 41.9K 3.63K
KUMC Biospecimen Repository ? Nov 2012
Visit Details 14.5M 521K
KUH/O2/Epic Nov 2007 Nov 2012 #1514
Cancer Cases 9.7M 66K #1600
KUH Cancer Registry 1950s Nov 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 955M

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

#833
multicohort survival analysis plugin
#914
HERON patients seem to age after they die
#1304
drag-and-drop entrance criteria, outcome, censor for survival analysis plug-in
#1317
Query HERON procedure orders by inpatient/outpatient modifiers
#1319
some detailed diagnoses from Epic are hidden under ICD9 leaves
#1380
flatten top of UMLS ICD9 Diagnosis hierarchy
#1512
Harvest ambulatory nursing flowsheet data
#1598
names in HERON "reports" hierarchy are long and redundant
#1613
Explosion of diagnosis codes leads to poor performance

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 Walnut update introduces O2 smart phrases, medication by dose and age at visit searching

In O2, smart phrases, commonly used words or phrases, are used to expedite patient documentation. Find these phrases under Reports->Visit Notes->Note Concepts.

Search medications by dose for inpatient medication orders. When constructing a search, drag "Cumulative Daily Dose of Single Inpatient Order" and you will be prompted to enter desired dose criteria.

Age at visit is searchable for patient visits. Please note this is based on de-identified dates. See HERON training for more information on how dates are shifted.

Need help using HERON? Learn how to Sponsor a HERON user, request data, and perform a search on the Informatics training video page.

HERON Walnut Contents Summary

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

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.3M 1.93M
KUH Billing (O2 via SMS) 1980s Sept 2012 various*
UKP Billing 2000 Sept 2012
13.2K 13.2K Frontiers participant registry Jun 2009 Sept 2012
185.9K 185.9K Social Security Death Index 1962 Sept 2012
Diagnoses (IDC9) 33.6M 638K
KUH/O2/Epic Nov 2007 Sept 2012 various*
UKP Billing 2000 Sept 2012
University HealthSystem Consortium (UHC) Q4 2008 June 2012
Medications 71.9M 283K
Organized by VA Class Nov 2007 Sept 2012
KUH/O2/Epic Nov 2007 Sept 2012 various*
Nursing Observations 524M ?
KUH/O2/Epic Nov 2007 Sept 2012 various*
Lab Results 79.2M 278K
KUH/O2/Epic 2003 Sept 2012 various*
Procedure Orders 52.7M 425K
KUH/O2/Epic 2003 (?) Sept 2012 various*
Procedures (CPT) 10.4M 566K
UKP Billing 2000 Sept 2012
Reports/Notes 24M 214K
KUH/O2/Epic ? Sept 2012
Specimens 34.6K 3.22K
KUMC Biospecimen Repository ? Sept 2012
Visit Details ? ?
KUH/O2/Epic Nov 2007 Sept 2012 #1514
Cancer Cases 9.6M 65.2K
KUH Cancer Registry 1950s Sept 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

#1246
Approximately 2% of Medication Facts are Not Covered by our VA Med Hierarchy

Outstanding Problems/Defects/Issues

"In-Home Monitoring in Support of Caregivers for Patients with Dementia" obtains NSF US-Ignite grant

The U.S. National Science Foundation (NSF) awarded us an exploratory research (EAGER) grant for In-Home Monitoring in Support of Caregivers for Patients with Dementia. The investigator team is:

  • Dr. Russ Waitman, Principal Investigator, is Director of Biomedical Informatics at KU Medical Center.
  • Dr. Kristine Williams, Co-Investigator, is Associate Professor of Nursing and Associate Scientist of Gerontology at the University of Kansas.
  • Dr. James Sterbenz, Co-Investigator, is the lead PI of an NSF GENI project: The Great Plains Environment for Network Innovation (GpENI).

This project develops, integrates, and tests advanced video and networking technologies to support family caregivers in managing behavioral symptoms of individuals with dementia, a growing public health problem that adds to caregiver stress, increases morbidity and mortality, and accelerates nursing home placement. The project builds upon a recent University of Kansas Medical Center (KUMC) clinical pilot study that tested the application of video monitoring in the home to support family caregivers of persons with Alzheimer’s disease who exhibited disruptive behaviors. The proposed project focuses on expanding the in-home technological tools available to strengthen the linkage between patients and caregivers with their healthcare team via multi-camera full-motion/high definition video monitoring. Google’s deployment this year of a 1 Gpbs fiber network throughout Kansas City provides the ideal environment for measuring the impact that ultra-high speed networking will have on health care.

fig 2 from US Ignite_FINAL_EAGERv_14.docx from Russ 30 Aug 2012

In a January NSF press release, the National Science Foundation (NSF) "announced that it will serve as the lead federal agency for a White House Initiative called US Ignite, which aims to realize the potential of fast, open, next-generation networks."

Our new connection with US Ignite provides access to resources in that community such as Mozilla Ignite and the GENI network lab. If you'd like to get involved, email Dan Connolly and Russ Waitman.

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 Cedar Bluff release incorporates procedure orders, note types, ICD9CM update

Cedar Bluff release includes bug fixes and introduces new data types to the repository. 

  • Procedure orders searchable. This included all procedure orders in O2, not just those ordered and fulfilled.
  • Note types allows you to limit searches to only records with a particular type of note.
  • Expected length of stay is a new quality measure added to the Length of Stay folder.
  • Thanks to Oregon Health & Science University for help with Diagnosis Mapping from ICD9-CM in UMLS. (#441)

HERON Cedar Bluff Contents Summary

This month, our tour of rivers and lakes in Kansas honors Cedar Bluff Reservoir.

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

Observation Patients Source Go-Live Snapshot Issues
Demographics 18.2M 1.92M
KUH Billing (O2 via SMS) 1980s July 2012 various*
UKP Billing 2000 July 2012
12.3K 12.3K Frontiers participant registry Jun 2009 July 2012
185K 185k Social Security Death Index 1962 July 2012
Diagnoses (IDC9) 32.4M 626K
KUH/O2/Epic Nov 2007 July 2012 various*
UKP Billing 2000 July 2012
University HealthSystem Consortium (UHC) Q4 2008 June 2012
Medications 120M 269K
KUH/O2/Epic Nov 2007 July 2012 various*
Nursing Observations 502M ?
KUH/O2/Epic Nov 2007 July 2012 various*
Lab Results 76.8M 271K
KUH/O2/Epic 2003 July 2012 various*
Procedure Orders 50.5M ?
KUH/O2/Epic 2003 (?) July 2012 #1363, various*
Procedures (CPT) 10.2M 559K
UKP Billing 2000 July 2012
Reports/Notes 2.32M ?
KUH/O2/Epic ? July 2012 #1363
Specimens 33.4K 3.13K
KUMC Biospecimen Repository ? July 2012
Visit Details 2.28M
KUH/O2/Epic Nov 2007 July 2012
Cancer Cases 9.4M 64.3K
KUH Cancer Registry 1950s July 2012 labels*
Hospital Quality Metrics 3.64M 56.9K
University HealthSystem Consortium (UHC) Q4 2008 June 2012 #1359, #1364
Triple Negative Breast Cancer Registry (BRCA) 16.6K 126
REDCap July 2011 July 2012
All 851M

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

UHC Core measures, Standard Medication Terms, and REDCap integration added to HERON in Cimarron release

Cimarron release includes a new structure for browsing data (medications), addition of a new data repository (REDCap), and new data concepts (UHC) plus bug fixes.

  • We can now import data from selected REDCap projects into HERON. This integration effort was piloted with a Cancer Registry.
  • Medication navigation improved due to organization by RxNorm based on GCN or NDC codes instead of clinical drug level, such as pill size. 89% of medication is mapped to RxNorm and we continue to work on the remaining 11%.
  • Visit details for inpatient visits provides insight into what services were assigned to a patient during their hospital stay.
  • Three important new types of UHC data available
    • Physician role and specialty are available to search in the UHC Visit Details folder.
    • Core Measures are standardized, evidenced based measures used by UHC to evaluate hospitals. These measures were designed by the Joint Commission to permit more rigorous comparisons of hospitals.
    • Numerator or denominator only case flag is added to AHRQ. See more information on AHRQ.

HERON Cimarron Contents Summary

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

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

Observation Patients Source Go-Live Snapshot Issues
Demographics 18.2M 1.92M
KUH Billing (O2 via SMS) 1980s June 2012 various*
UKP Billing 2000 June 2012
11.6K 11.6K Frontiers participant registry Jun 2009 June 2012
184.6K 184.6k Social Security Death Index 1962 June 2012
Diagnoses (IDC9) 20.5M 618K
KUH/O2/Epic Nov 2007 June 2012 various*
UKP Billing 2000 June 2012
Medications 100M 263K
KUH/O2/Epic Nov 2007 June 2012 various*
89.8M 250K Medications by VA Class/Clinical? Dose Form (DRAFT) Nov 2007 June 2012 various*
Nursing Observations 491M ?
KUH/O2/Epic Nov 2007 June 2012 various*
Lab Results 75.8M 268K
KUH/O2/Epic 2003 June 2012 various*
Procedures (CPT) 10.1M 555K
UKP Billing 2000 June 2012
Specimens 31.3K 3.06K
KUMC Biospecimen Repository ? June 2012
Visit Details 2.24M
KUH/O2/Epic Nov 2007 June 2012
Cancer Cases 9.3M 63.8K
KUH Cancer Registry 1950s June 2012 labels*
Hospital Quality Metrics 3.90M 56.9K
University HealthSystem Consortium (UHC) Q4 2008 June 2012
Triple Negative Breast Cancer Registry (BRCA) 15.9K 123
REDCap July 2011 June 2012
All 755M

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

#1048
Navigate Medications by National Standard hierarchy (RxNorm, NDFRT, VA)
#1243
Load UHC Core measures observations into HERON
#1244
Load UHC physician specialty and roles

Outstanding Problems/Defects/Issues

HERON: Hillsdale release incorporates usage statistics and bug fixes

The Hillsdale release makes usage statistics available to HERON users. By clicking on 'Usage Report' you can view monthly query counts and queries by users over time. Average query time improved and we will continue our work on optimization. Marital status now displays correct patient count.

HERON Hillsdale Contents Summary

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

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 May 2012 various*
UKP Billing 2000 May 2012
10.6K 10.6K Frontiers participant registry Jun 2009 May 2012
184K 184k Social Security Death Index 1962 May 2012
Diagnoses (IDC9) 20.1M 612K
KUH/O2/Epic Nov 2007 May 2012 various*
UKP Billing 2000 May 2012
Medications 100M 256K
KUH/O2/Epic Nov 2007 May 2012 various*
Nursing Observations 479M ?
KUH/O2/Epic Nov 2007 May 2012 various*
Lab Results 74.6M 264K
KUH/O2/Epic 2003 May 2012 various*
Procedures (CPT) 10M 551K
UKP Billing 2000 May 2012
Specimens 30.9K 3.03K
KUMC Biospecimen Repository ? May 2012
Cancer Cases 9.3M 63.5K
KUH Cancer Registry 1950s May 2012 labels*
Hospital Quality Metrics 3.23M 56.9K
University HealthSystem Consortium (UHC) N/A May 2012
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

Hello to the R User Community

Russ and I are at the R users's conference, useR! 2012 at Vanderbilt in Nashville.

We enjoyed the short course by Bill Venables, the guy who literally wrote the book on modern applied statistics.

I'm about to give my talk on HeronStatsPlugins. Wish me luck!

And stay tuned to KUBMIPresentations for slides and such.

If you'd like our contact info, see the biostatistics faculty and staff.

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.

Want to swim in Big Data? We are seeking summer interns

The Division of Medical Informatics, in the Department of Biostatistics, at the University of Kansas Medical seeks highly motivated individuals with a passion for software development, scientific discovery, and improving healthcare.  We are offering a paid student intern position for students in engineering and science to develop software and systems to support clinical and medical informatics research.  Our environment and topics include:

·         our clinical data warehouse which contains over 600 million facts for over 1.9 million patients

·          integrating statistical analysis and machine learning with data warehousing

·         understanding the impact of electronic medical records on patient care

·         clinical trial management systems and integration of biospecimens to support personalized medicine

·         developing methods for increasing clinical research participation in the community.

You will gain experience working in a software engineering environment using open source technologies.

 

Desirable skills include:  Experience programming a higher level language (C, C++, Java) and with scripting languages (Python). Proficiency with Microsoft Office products (Word, Excel). Experience developing in a LINUX/UNIX environment and working as part of a team using code management systems (ex: Subversion, Hg). Experience developing relational database driven applications (Oracle, MySQL), database design and SQL.   Experience programming dynamic web pages (such as JSP, PHP, Drupal, or cgi script based). Client side scripting experience with Javascript. Apache web server administration, and LINUX or UNIX system administration. Experience in knowledge discovery in databases (KDD) and data mining is also desirable: especially data preprocessing and transformation and frameworks for analysis. Previous experience in or knowledge of medicine, biology, and healthcare systems.

 

To learn more about what medical informatics is doing, visit: http://informatics.kumc.edu and our blog http://informatics.kumc.edu/work/blog

 

If you are interested in a position, please forward your resume and a cover letter to: rwaitman@…

 

HERON: Big Hill release adds home medications, other medication orders, and expands UHC data

The Big Hill release adds support for home medications and expands UHC coverage. Previously, we only had medications that are dispensed by the hospital pharmacy; now, you'll be able to see

  • medications that the patient reports taking at home (so called "historical medications"), as well as
  • all other orders, which includes prescriptions, inpatient medication orders, and discharge medication orders.
  • data for an additional 100K patients

The UHC data, although primarily administrative, provides a new view on a patient's interaction at the hospital. New UHC concepts include:

  • ICU length of stay: Search on time spent in ICU.
  • Admission and Discharge status concepts: Search where patients came from prior to admission or went to upon discharge.
  • Readmission concept: Helps you search for patients readmitted after discharge to their home, allowing specification to a desired number of days.
  • Clinical Classification Software (CCS) ICD-9: These codes provided by AHRQ collapse ICD-9 diagnosis and procedure codes into a smaller number of categories useful in analyzing data. See AHRQ web site.
  • All Patient Refined Diagnosis Related Groups (APR DRGs): DRG codes expanded to include 4 subclasses in severity of illness and mortality subgroups for each code. See web site.
  • Major Diagnostic Categories (MDCs): Search these diagnosis categories created by combining ICD-9 diagnosis codes into 25 MDCs. These codes, which are used primarily for administrative and billing purposes, provide another view on patient data.
  • Comorbidity: Search 29 comorbidity categories.

Currently the UHC data is limited to a 1-year time period (Nov. 2010-Nov. 2011). Look for additional years in future releases. This data is limited to hospital encounters and lacks clinic data.

HERON Big Hill Contents Summary

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

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

Observation Patients Source Go-Live Snapshot Issues
Demographics 18.0M 1.90M
KUH Billing (O2 via SMS) 1980s Feb 2012 various*
UKP Billing 2000 Feb 2012
9.5K 9.5K Frontiers participant registry Jun 2009 Feb 2012
183K 183k Social Security Death Index 1962 Feb 2012
Diagnoses (IDC9) 18.7M 602K
KUH/O2/Epic Nov 2007 Feb 2012 various*
UKP Billing 2000 Feb 2012
Medications 78.1M 245K
KUH/O2/Epic Nov 2007 Feb 2012 various*
Nursing Observations 463M ?
KUH/O2/Epic Nov 2007 Feb 2012 various*
Lab Results 72.6M 257K
KUH/O2/Epic 2003 Feb 2012 various*
Procedures (CPT) 9.6M 542K
UKP Billing 2000 Feb 2012
Specimens 27.8K 2.80K
KUMC Biospecimen Repository ? Jan 2012
Cancer Cases 9.1M 62.8K
KUH Cancer Registry 1950s Jan 2012 labels*
Hospital Quality Metrics .97M 19.7K
University HealthSystem Consortium (UHC) N/A Nov 2011 #997
All 630M

Beta Disclaimer

We are providing this early access to obtain feedback from you, the research community. While we are actively working on validating the data loaded into the system with hospital and clinic technical staff, there may be problems with our translation of data from our source systems (HospitalEpicSource and ClinicIdxSource) into HERON.

Please email us at heron-admin@kumc.edu if you discover information you believe may be erroneous.

We are actively working on enhancing the types of data included. Stay tuned to our roadmap to track progress toward upcoming releases.

Various Issues Still Apply

Keep in mind the issues noted in the original HERON beta notice, including:

Enhancements and Problems/Defects/Issues Addressed in this Release

No results

Outstanding Problems/Defects/Issues

See Cornell Lab of Ornitology's Great Blue Heron Nest Web Cam!

We are very excited as one of our mascots, the Great Blue Heron, is currently in nesting season. Cornell has a terrific web cam

http://www.allaboutbirds.org/page.aspx?pid=2433

HERON El Dorado Release incorporates searching by MSDRG and LOS

This release includes hospital quality measures (UHC) data integration which enhances search capabilities by introducing new concepts, such as length of stay and MSDRG. 109K UHC observations from the November 2010 - November 2011 are included in this release. This is our first step in making UHC data available. Look forward to additional UHC data in future releases.

HERON El Dorado Contents Summary

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

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

Observation Patients Source Go-Live Snapshot Issues
Demographics 18.0M 1.90M
KUH Billing (O2 via SMS) 1980s Feb 2012 various*
UKP Billing 2000 Feb 2012
9.1K 9.1K Frontiers participant registry Jun 2009 Feb 2012
183K 183k Social Security Death Index 1962 Feb 2012
Diagnoses (IDC9) 18.4M 596K
KUH/O2/Epic Nov 2007 Feb 2012 various*
UKP Billing 2000 Feb 2012
Medications 29.1M 107K
KUH/O2/Epic Nov 2007 Feb 2012 various*
Nursing Observations 452M ?
KUH/O2/Epic Nov 2007 Feb 2012 various*
Lab Results 71.5M 253K
KUH/O2/Epic 2003 Feb 2012 various*
Procedures (CPT) 9.5M 539K
UKP Billing 2000 Feb 2012
Specimens 27.3K 2.77K
KUMC Biospecimen Repository ? Jan 2012
Cancer Cases 9.1M 62.6K
KUH Cancer Registry 1950s Jan 2012 labels*
Hospital Quality Metrics 109K 19.7K
University HealthSystem Consortium (UHC) N/A Nov 2011 #997
All 630M

Beta Disclaimer

We are providing this early access to obtain feedback from you, the research community. While we are actively working on validating the data loaded into the system with hospital and clinic technical staff, there may be problems with our translation of data from our source systems (HospitalEpicSource and ClinicIdxSource) into HERON.

Please email us at heron-admin@kumc.edu if you discover information you believe may be erroneous.

We are actively working on enhancing the types of data included. Stay tuned to our roadmap to track progress toward upcoming releases.

Various Issues Still Apply

Keep in mind the issues noted in the original HERON beta notice, including:

Enhancements and Problems/Defects/Issues Addressed in this Release

#834
query by MSDRG, length of stay, service line from UHC 1-year snapshot

Outstanding Problems/Defects/Issues

We are recruiting for a Research Assistant Professor in Medical Informatics

Position Summary This Research Assistant Professor Faculty position is in the Division of Medical Informatics, Department of Biostatistics, within the School of Medicine.

The division of medical informatics seeks highly motivated individuals with a passion for software development, scientific discovery, and improving healthcare. Be part of a rapidly growing team developing informatics to further translational research (KUMC just received a NIH Clinical and Translational Science Award beginning June 2011) and serving a dynamic community (Kansas City was selected by Google as the first ultra high-speed fiber connected community).

Responsibilities will include developing informatics infrastructure capabilities, conducting research, and especially collaborative research. The position is expected to engage in collaborative research with other faculty from programs and departments within the School and University. The candidate will also be expected to collaborate with the State of Kansas and affiliate organizations such as the University of Kansas Hospital. The candidate may also be expected to teach courses for graduate students in biostatistics and other disciplines.

Key Roles and Responsibilities:

  • Work as an independent informatician to provide collaborate research support related to the development of informatics solutions for KUMC researchers and affiliates.
  • Possess the ability to design/develop key components of the informatics infrastructure, including terminology, data models, knowledge resources, dynamic end-user interfaces, and aggregations of data designed to support research.
  • Participate in team based software development and system management.
  • Evaluate clinical and research information systems and interventions at KUMC and affiliate organizations.
  • Contribute to the writing of grants to support new projects and the writing of manuscripts to publish findings from ongoing project and system evaluations.
  • Teach informatics courses for graduate students in biostatistics and other disciplines.
  • Perform other duties as may be assigned by the division director or chair.

Required Qualifications:

PhD., M.D., or D.O. and training in biomedical informatics through advanced degree programs, fellowship training, or comparable experiences in knowledge management, clinical decision support, translational informatics and relevant informatics standards. The ability to promote effective teamwork in a rapidly changing multidisciplinary research environment. Superior interpersonal and communications skills as demonstrated by excellence in speaking, writing and listening. Informatics research experience with clinical, public health, and medical administrative systems.

Preferred Qualifications:

The individuals expertise should draw from the broader field of biomedical informatics to complement and expand the department's capabilities. Desirable experiences and domains include: clinical information system and clinical decision support public health informatics quantitative/qualitative informatics evaluation methods statistics, biostatistics and quality management methods Database and application development HL7 data integration/system architecture ontology management (UMLS, LOINC, SNOMED, FDB, RxNORM) data warehousing; the division's HERON clinical repository utilizes i2b2 (over 500 million observations) to store information from our affiliate clinical organizations clinical research informatics; both Velos and REDCap are used for clinical research information systems knowledge discovery and statistical learning methods natural language processing laboratory/pathology information systems especially in support of tissue management and cancer research

Feel free to contact me, rwaitman@… to learn more, visit the rest of this wiki to learn about our work.  Or, just go ahead and apply for position M0203705: Research Assistant Professor in Medical Informatics.

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

HERON Bow Creek Release brings Cancer Survival Analysis, R integration

The highlights for this release include:

Our cancer survival analysis plug-in is based on work by Segagni et. al.:

HERON Bow Creek Contents Summary

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

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.0M 1.89M
KUH Billing (O2 via SMS) 1980s Dec 2011 various*
UKP Billing 2000 Dec 2011
8.18K 8.18K Frontiers participant registry Jun 2009 Dec 2011
182K 182k Social Security Death Index 1962 Dec 2011
Diagnoses (IDC9) 17.9M 586K
KUH/O2/Epic Nov 2007 Dec 2011 various*
UKP Billing 2000 Dec 2011
Medications 28.0M 103K
KUH/O2/Epic Nov 2007 Dec 2011 various*
Nursing Observations 434M ?
KUH/O2/Epic Nov 2007 Dec 2011 various*
Lab Results 69.8M 248K
KUH/O2/Epic 2003 Dec 2011 various*
Procedures (CPT) 9.4M 531K
UKP Billing 2000 Dec 2011
Specimens 25.5K 2.66K
KUMC Biospecimen Repository ? Dec 2011
Cancer Cases 8.96M 61.9K
KUH Cancer Registry 1950s Dec 2011 labels*
All 606M

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

Our Executive Vice Chancellor has an amazing bird.

Another feathered friend of our informatics initiative.

KUMC's Barbara Atkinson, MD, and Buddy the "Rock Chalk"-singing parrot

HERON Pawnee release paves the way to a richer data repository

Our Pawnee release is the first to use i2b2 1.6. This allows us to take advantage of i2b2 1.6 features in future releases:

  • visit information, such as length of stay, age at visit
  • provider information
  • primary diagnosis vs secondary; billing vs clinical
  • medication routes, frequency

We are still in the process of re-verifying data integrity and functionality after the upgrade, so consider these statistics provisional:

CATEGORYFACTSPATIENTS
i2b2 464M
Demographics 14.1M 1.88M
HICTR Participant 7.65K 7.65K
Diagnoses 17.5M 578K
Flowsheet 328M
Labtests 68.3M 244K
Medications 27.0M 99K
Procedures 9.2M 527K
Specimens 24.1K 2.56K

Note: our statistics regarding total number of flowsheet observations is reduced significantly from 470 million to 328 million. We are investigating the cause as the we think the data is intact (see ticket #789). Please give us feedback if you notice discrepancies with any prior queries where the counts are down significantly relative to last month's build.

Notice in the right hand side of the user interface that i2b2 1.6 allows you constrain observations to the same encounter. For example, you might require that patients have drug exposure (furosemide) and laboratory monitoring (serum potassium) during the same encounter while another observation like "diagnosis of diabetes" can be treated independently of encounter. Right now, we are not sure we have this working (see defect #790) but we are looking into it.

This release also fixed several outstanding bugs:

No results

HERON Tuttlecreek release brings initial Tumor Registry integration

This month's HERON release integrates data from the KUH Tumor Registry, with 65,000 cases dating back to the 1950s(#547). We have also added support for finding patients in KCK county school districts (#531).

Russ regularly gives presentations on our work, describing the integration of various sources into HERON. Since this diagram from How Medical Informatics and HERON Can Help Your Research?, given on November 17, we have integrated the Social Security death master file as well as the tumor registry:

HERON Tuttlecreek Contents Summary

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

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

Observation Patients Source Go-Live Snapshot Issues
Demographics 15.9M 1.88M
KUH Billing (O2 via SMS) 1980s Oct 2011 various*
UKP Billing 2000 Oct 2011
6.64K 6.64K Frontiers participant registry Jun 2009 Oct 2011
Diagnoses (IDC9) 17.2M 571K
KUH/O2/Epic Nov 2007 Oct 2011 various*
UKP Billing 2000 Oct 2011
Medications 26.3M 96K
KUH/O2/Epic Nov 2007 Oct 2011 various*
Nursing Observations 407M ?
KUH/O2/Epic Nov 2007 Oct 2011 various*
Lab Results 67.2M 240K
KUH/O2/Epic Nov 2007 Oct 2011 various*
Procedures (CPT) 9.1M 523K
UKP Billing 2000 Oct 2011
Specimines 23.1K 2.48K
KUMC Biospecimine Repository ? Oct 2011
Cancer Cases 6.21M 60.4K
KUH Cancer Registry 1950s Aug 2011 labels*
All 570M

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:

Problems/Defects/Issues Addressed in this Release

No major issues addressed.

Outstanding Problems/Defects/Issues

No results

Perry is here with data through September 2011

This month, the release of our HERON research data repository honors Perry Lake for our regular monthly refresh of the data.

Join us at the Frontiers Clinical/Translational Informatics Clinic for full demonstration and discussion. We have it bi-weekly in 1040 Dykes Library from 4 -5 pm. Next workshop will be on Nov 1st, 2011.

The HERON repository contains approximately 551 million real observations from the hospital and clinics:

Observation Patients Source Go-Live Snapshot Issues
Demographics 15.4M 1.8728M
KUH Billing (O2 via SMS) 1980s Sep 2011 various*
UKP Billing 2000 Sep 2011
6.4K 6.4K Frontiers participant registry Jun 2009 Sep 2011
Diagnoses (IDC9) 16.9M 564K
KUH/O2/Epic Nov 2007 Sep 2011 various*
UKP Billing 2000 Sep 2011
Medications 25.6M 93.7K
KUH/O2/Epic Nov 2007 Sep 2011 various*
Nursing Observations 396.7M ?
KUH/O2/Epic Nov 2007 Sep 2011 various*
Lab Results 66.2M 237K
KUH/O2/Epic Nov 2003 Sep 2011 various*
Procedures (CPT) 9.02M 519K
KUH/O2/Epic Nov 2007 Sep 2011
Specimen 22.2K 2.4K
KUMC Bio Specimen Repository Apr 1996 Sep 2011
Death Index
24K 24k KUH Hospital Data Nov 2007 Sep 2011
178K 178k Social Security Administration Apr 1996 Jan 1962
All 551M

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:

Problems/Defects/Issues Addressed in this Release

no major issues.

Outstanding Problems/Defects/Issues

No results

Using i2b2 Timeline and other analysis plug-ins in HERON

We recently worked out the technical and regulatory issues to take you beyond counting to detailed analysis of the data in HERON (#314).

Consider this example from my recent Internal Medicine Research Committee Presentation on HERON:

To access these capabilities, choose to check the box to also create a "patient set" when you run your query. Then, use the analysis tools tab at the top which takes you to a series of i2b2 plugins. We have found that the "Demographics (1 Patient Set)", "Demographics (2 Patient Sets)", and "Timeline" plugins to be very illuminating.

Stay tuned for more training materials or join us at the bi-weekly informatics clinic for help.

Heron Cottonwood release includes early Biospecimen Repository integration

In addition to a monthly data refresh to include data from July, this Cottonwood release of HERON brings an early integration of the KUMC/KUCC Biospecimen repository.

No results

HERON Cottonwood Contents Summary

The HERON repository contains approximately 480 million real observations from the hospital and clinics:

Observation Patients Source Go-Live Snapshot Issues
Demographics 15.4M 1.86M
KUH Billing (O2 via SMS) 1980s July 2011 various*
UKP Billing 2000 July 2011
5.94K 5.94K HICTR? participant registry Jun 2009 July 2011
Diagnoses (IDC9) 16.4M 551K
KUH/O2/Epic Nov 2007 July 2011 various*
UKP Billing 2000 July 2011
Medications 24.4M 88.1K
KUH/O2/Epic Nov 2007 July 2011 various*
Nursing Observations 375M ?
KUH/O2/Epic Nov 2007 July 2011 various*
Lab Results 40.0M 158K
KUH/O2/Epic Nov 2007 July 2011 various*
Procedures (CPT) 8.86M 511K
UKP Billing 2000 July 2011
All 480M

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:

Problems/Defects/Issues Addressed in this Release

No results

Outstanding Problems/Defects/Issues

No results

Heron visits Wilson river, brings June data to feed on

Wilson River is the second place our HERON visits since organizing our roadmap as a tour of lakes and rivers in Kansas.

As well as a monthly refresh of source data, in this release we loaded the June data:

HERON Wilson Contents Summary

The HERON repository contains approximately 490 million real observations from the hospital and clinics:

Observation Patients Source Go-Live Snapshot Issues
Demographics 15M 1.852M
KUH Billing (O2 via SMS) 1980s May 2011 various*
UKP Billing 2000 May 2011
5622 HICTR? participant registry Jun 2009 May 2011
Diagnoses (IDC9) 16.2M 547K
KUH/O2/Epic Nov 2007 May 2011 various*
UKP Billing 2000 May 2011
Medications 23.8M 85.7K
KUH/O2/Epic Nov 2007 May 2011 various*
Nursing Observations 366M ?
KUH/O2/Epic Nov 2007 May 2011 various*
Lab Results 39.1M 154K
KUH/O2/Epic Nov 2007 May 2011 various*
Procedures (CPT) 8.79M 508K
UKP Billing 2000 May 2011
All 490M

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:

Outstanding Problems/Defects/Issues

No results

Heron visits Lake Pomona, brings May data and performance increase

Lake Pamona is the first place our HERON visits since organizing our roadmap as a tour of lakes and rivers in Kansas.

As well as a monthly refresh of source data, in this release we deployed solid state storage to address performance issues:

No results

HERON Pomona Contents Summary

The HERON repository contains approximately 475 million real observations from the hospital and clinics:

Observation Patients Source Go-Live Snapshot Issues
Demographics 10.7M 1.85M
KUH Billing (O2 via SMS) 1980s May 2011 various*
UKP Billing 2000 May 2011
5622 HICTR? participant registry Jun 2009 May 2011
Diagnoses (IDC9) 16.1M 546K
KUH/O2/Epic Nov 2007 May 2011 various*
UKP Billing 2000 May 2011
Medications 23.3M 83.2K
KUH/O2/Epic Nov 2007 May 2011 various*
Nursing Observations 356M ?
KUH/O2/Epic Nov 2007 May 2011 various*
Lab Results 38.9M 154K
KUH/O2/Epic Nov 2007 May 2011 various*
Procedures (CPT) 8.71M 505K
UKP Billing 2000 May 2011
All 475M

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:

Outstanding Problems/Defects/Issues

No results

First Frontiers Clinical/Translational Informatics Clinic

We'd like to thank everyone who came to the first Frontiers Clinical/Translational Informatics Clinic yesterday.

The clinic is scheduled for 4pm every other Tuesday in Library Room 1040. As the announcement said:

The Frontiers Clinical/Translational Informatics Clinic exists for investigators needing assistance using informatics tools for data exploration, cohort discovery, and data collection. The clinic is a brainstorming session and an education forum for investigators and informatics to share knowledge, provide feedback, and optimize the use of systems such as: - REDCap for data collection - the HERON clinical data repository and its i2b2 application - and other systems developed as part of Frontiers: Kansas City's Clinical and Translational Science Award.

It was interesting to chat with everybody, from investigators with proposals in development to research nurses, study coordinators, etc. We introduced our systems and talked about how they can be used to support research.

CRIS? is KUMC's custom installation of Velos eResearch, the highly-regarded clinical research information system chosen by 20 medical institutions with top 25 ratings.

For those doing a clinical trial, specially for cancer or an investigational drug where adverse event reporting is requred, CRIS is the way to go:

REDCap allows you to build and manage online surveys and databases quickly and securely. It's used by thousands of projects at hundreds of institutions.

If you are building a patient registry or a lightweight trial at KUMC, try REDCap:

HERON allows you to explore de-identified data from Epic/O2 (the hospital electronic medical records) and IDX (the clinical billing system). We talked about capabilities and access rules for HERON, using some HERONTrainingMaterials? for reference.

Access to de-identified data is non-human subjects research and does not require approval by the HSC/IRB. For qualified faculty who want view-only access to do patient count queries, executing a system access agreement is the only requirement.

A Data Request Oversight Committee (DROC) oversees requests to:

  • sponsor collaborators and research team members
  • extract de-identified data sets

For access to identified data, you will need an IRB approved protocol.

We look forward to meeting with our user community again in two weeks.

Dan, Kahlia, Arvinder, and Russ

Announcing CTSA funding from NIH to KUMC

We're proud of our role in this week's announcement:

KUMC receives $20 million Clinical and Translational Science Award

June 14, 2011

Kansas City, Kan. — Patients will gain faster access to the benefits of health research throughout the region thanks to a grant announced today.

The University of Kansas Medical Center has received a $19,794,046 Clinical and Translational Science Award from the National Institutes of Health (NIH). The five-year grant puts the medical center among an elite, 60-member group of universities collaborating on clinical and translational research, which transforms laboratory discoveries into treatments and cures.

Launched by the NIH in 2006, the Clinical and Translational Science Awards (CTSA) program goals are to speed laboratory discoveries into treatments for patients, to work with communities in clinical research efforts, and to train a new generation of researchers to bring cures and treatments to patients faster. With its new grant, KU Medical Center will create a program called Frontiers, greatly expanding the reach of its existing Heartland Institute for Clinical and Translational Research, which has been the center of clinical and translational research for Kansas and the greater Kansas City region.

Scientists at KU have been doing translational research for years. For example, clinical trials are now being held for an ovarian cancer drug that KU researchers have reformulated so that it can be delivered in a patient's abdomen instead of intravenously, which caused negative side effects. Other scientists have discovered that DHA, the omega-3 fatty acid common in fish oil, may help infants develop better attention skills. In part, as a result of this research, DHA is now added to many infant formulas. Other researchers are studying whether exercise can slow the progression of Alzheimer's disease.

...

In fact, a big part of what's new about translational research at KUMC this year is our very own biomedical informatics division:

Biomedical Informatics accelerates scientific discovery and improves patient care by converting data into actionable information. Pharmacologists and biologists use informatics to understand how drugs and cells interact at a molecular level; scientists use software to determine what kind of patients may most benefit from a clinical trial; doctors view risk models to help individualize therapies for patients.

The specific aims from our section of the grant are:

  1. Provide a HICTR portal for investigators to access clinical and translation research resources, track usage and outcomes, and provide informatics consultation services.
  2. Create a platform, HERON (Healthcare Enterprise Repository for Ontological Narration), to integrate clinical and biomedical data for translational research.
  3. Advance medical innovation by linking biological tissues to clinical phenotype an pharmacokinetic and pharmacodynamic data generated by research in phase I and II clinical trials (address T1 translational research).
  4. Leverage an active, engaged statewide telemedicine and Health Information Exchange (HIE) to enable community based translational research (Addressing T2 translational research).

Presentation materials from Dr. Waitman's talk from last September, Developing Clinical and Translational Informatics Capabilities for Kansas University go into more detail on those aims.

The focus of our development work for the past year or so has been on the HERON data repository, but starting with milestone:RavenCTSA, the plan is to broaden the portal from just informatics tools for use within KUMC to a variety of tools for investigators in our community.

Want to join the fun? We're hiring.

HERON April update brings revised Lab terminology, performance increase

Since the HERON Feb 2011 snapshot release, the major enhancements are:

No results

HERON Contents Summary

The HERON repository contains approximately 445 million real observations from the hospital and clinics:

Facts Patients Source Go-Live Snapshot Issues
Demographics 10.6M 1.84M
KUH Billing (O2 via SMS) 1980s Apr 2011 various*
UKP Billing 2000 Apr 2011 #406
5622 HICTR? participant registry Jun 2009 Apr 2011
Diagnoses (IDC9) 15.7M 540K
KUH/O2/Epic Nov 2007 Apr 2011 various*
UKP Billing 2000 Apr 2011
Medications 22.8M 81.1K
KUH/O2/Epic Nov 2007 Apr 2011 various*
Nursing Observations 349M ?
KUH/O2/Epic Nov 2007 Apr 2011 various*
Lab Results 37.6M 150K
KUH/O2/Epic Nov 2007 Apr 2011 various*
Procedures (CPT) 8.62M 501K
UKP Billing 2000 Apr 2011
All 445M

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:

Status of Problems/Bugs

Problems/Bugs addressed in this milestone

No results

Outstanding Problems/Defects/Issues

No results

Completed tasks, Resolved Design Issues

For a more detailed account of the development of this release, see milestone:heron-apr-update.

We have a great opportunity for a Biomedical Informatics Software Engineer!

The division of medical informatics seeks highly motivated individuals with a passion for software development, scientific discovery, and improving healthcare. This position is responsible for developing and maintaining medical informatics applications to support Kansas University Medical Center. This includes developing/interacting with clinical systems (Ex. EPIC, Cerner), data warehouses and analytics, national terminology vocabularies (UMLS, RxNorm, LOINC, FDB), clinical research systems (Ex. VELOS), and external registries and state/national datasets.

-- Job J0084846

HERON Update Integrates UKP Clinic data with KUH Hospital Data

This second beta release of the HERON repository includes billing diagnoses and procedures from the UKP clinics (ClinicIdxSource), integrated with data from the hospital (HospitalEpicSource) (#306). The data is current through February 2011 for both sources.

This release also supports querying by whether a patient is in the HICTR? participant registry (#155).

HERON Contents Summary

The repository contains approximately 300 million real observations from the hospital and clinics.

This is down from 470 million due to a defect in the way nursing flowsheet was loaded (#456). We will fix this defect in our next release which will incorporate April data.

Facts/Patients Source Go-Live Snapshot Issues
Demographics 10M/1.8M
KUH Billing (O2 via SMS) 1980s Feb 2011 various*
UKP Billing 2000 Feb 2011
Diagnoses (IDC9) 14M/521K
KUH/O2/Epic Nov 2007 Feb 2011 various*
UKP Billing 2000 Feb 2011
Medications 20M/70K
KUH/O2/Epic Nov 2007 Feb 2011 various*
Nursing Observations 217M*/?
KUH/O2/Epic Nov 2007 Feb 2011 various*
Lab Results 28M/132K
KUH/O2/Epic Nov 2007 Feb 2011 various*
Procedures (CPT) 8.4M/491K
UKP Billing 2000 Feb 2011

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 previous HERON update notice.

Status of Problems/Bugs

Problems/Bugs addressed in this milestone

No results

Outstanding Problems/Defects/Issues

#2301
constraining birth-date by date doesn't work - HERON uses sysdate for start_date in demographics
#2617
Saved searches not updated in REDCap projects after Arkansas release

Completed tasks, Resolved Design Issues

For a more detailed account of the development of this release, see milestone:heron-update.

KUMC HERON is now in beta status and undergoing testing

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 (Epic and IDX) 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.

Update Jan 2012 to acknowledge data provider for geographic de-identification

HERON Contents Summary

The repository contains approximately half a billion real observations from the hospital and clinics (KUH, UKP).

Facts/Patients Source Go-Live Snapshot Issues
Demographics 7.2M/1.8M
KUH Billing (O2 via SMS) 1980s* Sep 2010 de-identification*, historical*
UKP Billing 2000 Planned*
Diagnoses (IDC9) 2.2M/190K
KUH/O2/Epic Nov 2007 Sep 2010 various*
UKP Billing 2000 Planned*
Medications 18M/60K
KUH/O2/Epic Nov 2007 Sep 2010 various*
Nursing Observations 390M/240K
KUH/O2/Epic Nov 2007 Sep 2010 various*
Lab Results 25M/120K
KUH/O2/Epic Nov 2007 Sep 2010 various*
Procedures (CPT) 0/0
UKP Billing 2000 Planned*

HERON, KUH EHR Coverage Varies Over Time

Epic (O2) electronic medical record is the main source of our data. It is the EMR for KUH and increasingly the clinics.

  • Epic went live at KUH on November 12, 2007.
    • It started with the pharmacy, medication administration, and flowsheet modules
    • Physician Clinical Documentation was added in May of 2009.
    • Computerized Provider Order Entry (CPOE) began in November of 2010.
    • Some outpatient clinics owned by the hospital (ex: Jayhawk clinics, outpatient cancer center treatment) began using Epic as earlier but the main UKP clinic rollout of Epic started in Fall 2010. It is planned to complete in 2013.
  • Epic also contains Admission, Discharge Transfer and Patient Registration information from the Hospital Billing System (Seimens SMS). As a result, we have basic demographics on patients going back to the 1980s. But, we lack the rich clinical detail available since 2007.

We receive periodic copies of the Epic Clarity database to use as the foundation of our repository. Our current copy is from September 22, 2010, which, for example, pre-dates rollout of CPOE.

Date-Shifting

Our DeIdentificationStrategy includes shifting the dates of each patient record by up to one year. For example, if a patient was born July 1, 1960 their birth date is shifted back in time between 0 and 365 days, and and all subsequent observations are shifted by the same number of days.

Plans to add Outpatient Billing data to HERON

We plan to incorporate outpatient billing data from GE IDX in our next release. (#306) The IDX data goes back to the 2000 and will include CPT procedure codes and ICD9 diagnoses codes.

De-Identification of Patient Health Information

We have taken several steps to de-identify the patient records so they may be deemed non-human subjects research. This includes:

  • shifting dates as above
  • Removing address identifiers
  • Only providing gross geographic indicators (state and radius from KUMC) (#51)
    • with thanks to geonames for data relating zip codes to latitude/longitude

By default you have obfuscated counting access. This means the exact counts returned by queries are perturbed by a random number of patients. Obfuscation access also means you can't take advantage of analysis tools and timelines. We will work with our clinical partners on providing this greater level of access for our research community. (#314)

See also details regarding our DeIdentificationStrategy.

Diagnosis Issues

These come from the Epic PAT_ENC_DX table which is populated by the problem list and from tests which are ordered that require a diagnosis. We currently organize the data by ICD9.

  • There are many opinions on this as a source of information. One perspective is that they may be more clinically relevant but lack the completeness of professionally coded diagnoses.
  • In our next release we plan to extract the full ICD9 augmented with SNOMED concepts from the IMO hierarchies stored within Epic. (#273)

Laboratory Results Issues

We have loaded the top 500 most frequently resulted lab tests

  • These are results that were "finalized" by the lab.
  • These do not include microbiology, blood bank, pathology. Only the general laboratory results.
  • The LOINC coding was not validated by laboratory personnel. We will work towards using the local Epic categorization until the laboratory has time to map their results to national standards.

Medication Issues

  • Medications are the dispensed medications by pharmacy. We believe this data is not accurate and are working towards loading the administered medications from the MAR.
    • For now, you can use medications for exploratory activities but don't take any overall volumes as truth. We believe the medication exposure is underreported.
    • The classification of medications follows the internal Epic categories (based on First Databank).

Nursing Flowsheet Data Issues

  • We have loaded all the nursing flowsheet data with the exception of some dates. (#363)
  • Strings are not visible for privacy preservation but you will at least know that the observation was recorded. (#299)
  • The ontologies for flowsheets is an area of research for us. As a first step we are displaying the internal flowsheet organization within Epic at KUH.
    • Keep in mind that one observation which was documented on one flowsheet may appear on many different flowsheets. The best examples of this are height/weight and vital signs.

Other Data Issues

  • We haven't really loaded procedures and CPTs yet though the ontology hierarchy might lead you to think they are loaded.
  • Searching by age is an interesting topic in i2b2 (#158)
    • For the most part, you are searching based upon the patients current age for events that have occurred in the past.
    • Future releases of i2b2 should allow you to specify search criteria for the age at time of event (more relevant to infant/pediatric queries).

I2B2 Software Platform Issues

For the most part, we are not modifying the i2b2 software. Any defects found may be already shared with the i2b2 development team at Partners.

  • We haven't developed training materials beyond what is provided at the i2b2 home page.
  • We are currently running i2b2 version 1.4. Keep this in mind as you compare current functionality with current and planned i2b2 releases (1.5 and 1.6rc3).
    • We will plan to upgrade to version 1.6 of i2b2 when it is official released by their developers and when we can sequence the upgrade with our production release of HERON. (#165)

Note: we have modified the i2b2 software to display the number of facts at each level of the ontology and in some cases also display the distinct number of patients at each level. (#211)

Address any suggestions or feedback to heron-admin@kumc.edu

Getting ahead of the ball with service monitoring

In the earliest phases of development of our HERON clinical research repository, the only users were us developers and a handful of friendly alpha testers, so it was fine to discover problems as we used the system.

But one of the features included in milestone:EpicBetai2b2 is more proactive monitoring (#150), using the popular open source opsview toolset, built on nagios.

Once it was in place for HERON, I showed it to a guy who supports CRIS?, and he figured out how to get nagios working on Windows servers etc.

CRIS is a long-standing production service. Its user community consists of clinical researchers. When CRIS acts up, they don't see it as an interesting technical puzzle to solve; they just see it as the darned computer getting between them and their research goals again.

The database under the CRIS service acted up over the weekend, but this time, instead of a call from a frustrated researcher on Monday morning, the CRIS support team got an automated notice right when the problem started and had it cleaned up before any users noticed.

It's so much nicer to be ahead of the ball in the customer support game.

Concept stats: how many needles are in which parts of our i2b2 haystack?

For the HERON research data repository we're building, we're Using I2B2, which involves navigating a huge vocabulary of medical terminology. We found ourselves wishing that the terms were tagged with some clues about how often they occur in our database. Now that the enhancement ticket is done, we find it really does help.

I2B2 lets researchers identify patient cohorts by querying a database of "observation facts" about patients. All the facts are collected in one table, indexed by concept. Concepts may be demographics (age, gender, etc.), diagnoses, labs, medications, or procedures, and the tool supports hierarchical navigation and text search:

About 14,000 concepts are included with the I2B2 software. As we extract concepts from health records at KU Medical center, some obviously match the i2b2 concepts but many do not. For example, we have not yet determined the relationship between local medication codes and the NDC system. This complicates the already daunting task of navigating the hierarchy of medical terminology. It's quite frustrating to poke around in the dark, running query after query, not knowing which concepts have real data attached to them.

We find that pre-computing the number of facts and the number of associated patients and including these statistics in the hierarchy makes navigation much more efficient:

We can see at a glance that we have no records of dispensing ANTI-OBESITY drugs, at least by that exact categorization.

We can also see that we only have rich data (diagnoses, labs, meds, ...) about roughly 10% of the 2 million patients in our database; this is due to rather recent deployment of an electronic medical record system compared to the long-standing use of computerized billing systems.

How we did it

In the observation_fact table, each of the facts carries a concept_cd; for example:

concept_cdencounter_numpatient_numstart_date...
DEM|AGE:51231233212005-01-01...

Then the concept_cd is related to a longer path in the concept_dimension table:

concept_cdconcept_path...
DEM|AGE:5\i2b2\Demographics\Age\0-10\5...

And these paths are used in the i2b2 table that is used to build the hierarchical navigation display:

c_dimcodec_name...
\i2b2\Demographics\Demographics...
\i2b2\Demographics\Age\Age...
\i2b2\Demographics\Age\0-10\Ages 0-10...
\i2b2\Demographics\Age\0-10\5Age 5...

So we join each i2b2 row with the concept_dimension rows under it, and then join with observation_fact on concept_cd, and store the stats in a temporary table:

create global temporary table stats
        on commit preserve rows as
        select c.super_path,
               count(*) facts,
               count(distinct f.patient_num) patients
         from
           (select distinct super.c_dimcode super_path,
                   sub.concept_cd sub_code
            from blueheronmetadata.i2b2 super
            join blueherondata.concept_dimension sub
             on sub.concept_path like (super.c_dimcode || '%')) c
           join blueherondata.observation_fact f
             on f.concept_cd = c.sub_code
        group by super_path

To compute this efficiently, we added an index on i2b2.c_dimcode; you can see that the whole thing runs in just under 22 minutes:

2010-12-09 15:20:17.357337 starting statement:  
      CREATE INDEX blueheronmetadata.metadata_by_path
        ON blueheronmetadata.i2b2 (c_dimcode)
    
2010-12-09 15:20:18.649760 finished after 0:00:01.292423; rows affected: -1
2010-12-09 15:20:18.649852 starting statement:  create global temporary table stats
        on commit preserve rows as
        select c.super_path,
               count(*) facts,
               count(distinct f.patient_num) patients
         from
           (select distinct super.c_dimcode super_path,
                   sub.concept_cd sub_code
            from blueheronmetadata.i2b2 super
            join blueherondata.concept_dimension sub
             on sub.concept_path like (super.c_dimcode || '%')) c
           join blueherondata.observation_fact f
             on f.concept_cd = c.sub_code
        group by super_path
explain plan result:
Plan hash value: 539913617
 
-------------------------------------------------------------------------------------------------------------------
| Id  | Operation                        | Name                   | Rows  | Bytes |TempSpc| Cost (%CPU)| Time     |
-------------------------------------------------------------------------------------------------------------------
|   0 | CREATE TABLE STATEMENT           |                        |   206 | 34196 |       |   175M  (2)|584:12:42 |
|   1 |  LOAD AS SELECT                  | STATS                  |       |       |       |            |          |
|   2 |   SORT GROUP BY                  |                        |   206 | 34196 |       |   131M  (2)|438:09:33 |
|*  3 |    HASH JOIN                     |                        |  8398M|  1298G|  2207M|   129M  (1)|433:18:21 |
|   4 |     INDEX FAST FULL SCAN         | FACT_CNPT_PAT_ENCT_IDX |    59M|  1528M|       | 78907   (2)| 00:15:47 |
|   5 |     VIEW                         |                        |    28M|  3780M|       |   129M  (1)|431:40:01 |
|   6 |      HASH UNIQUE                 |                        |    28M|  6501M|   444G|   116M  (1)|386:55:49 |
|   7 |       TABLE ACCESS BY INDEX ROWID| CONCEPT_DIMENSION      |  9826 |  1161K|       |   257   (0)| 00:00:04 |
|   8 |        NESTED LOOPS              |                        |  1837M|   409G|       |    48M  (1)|160:23:14 |
|   9 |         INDEX FAST FULL SCAN     | METADATA_BY_PATH       |   187K|    21M|       |   753   (1)| 00:00:10 |
|* 10 |         INDEX RANGE SCAN         | CONCEPT_DIMENSION_PK   |  1769 |       |       |    56   (0)| 00:00:01 |
-------------------------------------------------------------------------------------------------------------------
 
Predicate Information (identified by operation id):
---------------------------------------------------
 
   3 - access("F"."CONCEPT_CD"="C"."SUB_CODE")
  10 - access("SUB"."CONCEPT_PATH" LIKE "SUPER"."C_DIMCODE"||'%')
       filter("SUB"."CONCEPT_PATH" LIKE "SUPER"."C_DIMCODE"||'%')
2010-12-09 15:42:12.129193 finished after 0:21:53.479341; rows affected: -1

We then used an expedient hack of updating the concept labels to include the stats:

update blueheronmetadata.i2b2 m
      set m.c_name = (
        select distinct
          case when tots.facts > 0 then
            case when instr(m.c_name, '[') > 0 then
              regexp_replace(m.c_name, '\[.*', '')
            else m.c_name || ' ' end
            || '['
            || (case when tots.facts < 10 then '<10'
                else to_char(tots.facts) end) || ' facts'
            || (case when tots.patients < 10 then ''
                  else '; ' || tots.patients || ' patients' end)
            || ']'
         else m.c_name end
         from stats tots
           where tots.super_path = m.c_dimcode)
      where m.c_dimcode in
        (select super_path from stats)

That code is complicated because it has to

  1. leave out stats regarding fewer than 10 patients (per HIPAA regulations, as part of our DeIdentificationStrategy)
  2. replace any stats that were already there

That's probably enough detail for others using i2b2 to do likewise, but if you're curious, the script that manages the process is source:heron_load/concepts_stats.py and the ticket (#211) tells the whole saga of approaches that don't work and such.

Informatics at KU Med Center

A person working in partnership with an information resource is "better" than that same person unassisted.

-- Friedman 2009

We referenced that "fundamental theorem" of biomedical informatics to introduce the discipline in his recent clinical research presentation:

http://www.ncbi.nlm.nih.gov/pmc/articles/PMC2649317/bin/169.S1067502708002417.gr1.jpg

Friedman goes on to explain that informatics is more about people than technology:

NOT: information resource > person

One can view the whole EHR as one giant intervention where the healthcare system (providers, nurses, pharmacists, allied health) are the subjects. Will it be a chewable Flintstone vitamin or a barium enema?