HERON Sunset includes Clincial Service Department
HERON Sunset includes Clinical Service Department information, which allows you to limit your search to a specific clinic. For example, searches can be limited to include only patients seen at Mid-America Cardiology (MAC). Clinical Service Department data is from the electronic medical record, O2, while the data in the Clinical Services folder is derived from the billing system, IDX.
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 Sunset Contents Summary
Our tour of rivers and lakes expands to include bodies of water within the Greater Plains Collaborative states. This month honors Sunset Lake in Wisconsin.
The HERON repository contains over 2 billion real observations from the hospital, clinics, and research systems:
Observation | Patients | Source | Go-Live | Snapshot | Issues | |
---|---|---|---|---|---|---|
Alerts | 25.2M | 495K | ||||
KUH/O2/Epic | Nov 2007 | Apr 2016 | ||||
Allergy | 672K | 295K | ||||
KUH/O2/Epic | Nov 2007 | Apr 2016 | various* | |||
Cancer Cases | 19.0M | 84.1K | ||||
KUH Cancer Registry | 1950s | Apr 2016 | labels* #3927 | |||
Cardiology Labs | 29.7M | 390K | ||||
KUH/O2/Epic | Nov 2007 | Apr 2016 | ||||
Demographics | 29.8M | 2.19M | ||||
KUH Billing (O2 via SMS) | 1980s | Apr 2016 | various* | |||
UKP Billing | 2000 | Apr 2016 | ||||
43.8K | 43.8K | Frontiers participant registry | Jun 2009 | Apr 2016 | ||
204.9K | 204.9K | Social Security Death Index | 1962 | Apr 2016 | ||
Diagnoses (IDC9, ICD10) | 80.6M | 900K | ||||
KUH/O2/Epic | Nov 2007 | Apr 2016 | various* | |||
UKP Billing | 2000 | Apr 2016 | #4093 | |||
University HealthSystem Consortium (UHC) | Q4 2008 | Dec 2015 | ||||
History | 52.5M | 531K | ||||
KUH/O2/Epic | Nov 2007 | Apr 2016 | ||||
Lab Results | 188M | 431K | ||||
KUH/O2/Epic | 2003 | Apr 2016 | various* | |||
Medications | 235M | 539K | ||||
KUH/O2/Epic (Organized by VA Class) | Nov 2007 | Apr 2016 | various* | |||
Microbiology | 4.46M | 36.7K | ||||
KUH/O2/Epic | 2003 (?) | Apr 2016 | various* | |||
950K | 147K | Negative | 2003 | Apr 2016 | ||
15.7K | 11.0K | Positive | 2003 | Apr 2016 | ||
National Cardiovascular Data Registry | 1.63M | 13.7K | ||||
NCDR | (?) | Sep 2015 | ||||
National Trauma Data Registry | 28.4K | 478 | ||||
NTDS | Apr 2015 | June 2015 | ||||
Nursing Observations | 1.12B | ? | ||||
KUH/O2/Epic | Nov 2007 | Apr 2016 | various* | |||
Procedure Orders | 227M | 661K | ||||
KUH/O2/Epic | 2003 (?) | Apr 2016 | various* | |||
Procedures (CPT) | 16.2 | 771K | ||||
UKP Billing | 2000 | Apr 2016 | #4093 #4100 | |||
REDCap | 1.72M | 52.7K | ||||
REDCap | July 2011 | Apr 2016 | ||||
Reports/Notes | 116M | 512K | ||||
KUH/O2/Epic | ? | Apr 2016 | ||||
Specimens | 137K | 9.7K | ||||
KUMC Biospecimen Repository | ? | Jun 2015 | ||||
Visit Details | 111M | 1.07M | ||||
KUH/O2/Epic | Nov 2007 | Apr 2016 | ||||
Hospital Quality Metrics | 9.5M | 122K | ||||
University HealthSystem Consortium (UHC) | Q4 2008 | Dec 2015 | various* | |||
All | 2.27B |
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:
- date shifting, part of our DeIdentificationStrategy
- age searching (#158)
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
Ticket Summary Keywords #2301 constraining birth-date by date doesn't work - HERON uses sysdate for start_date in demographics public-web wrong-results training #2617 Saved searches not updated in REDCap projects after Arkansas release public-web redcap-to-heron
HERON Rolling Stone includes de-identified Flowsheet notes and alert status
HERON Rolling Stone release introduces de-identified flowsheet notes. When pulling a flowsheet note into a group within your search, you will be prompted to enter a value. Selecting no value will search for any patient with a note documented. To search for a string of text, enter it in the value box. These notes are de-identified so you cannot search on a date, name, or other PHI element within the note.
Rolling Stone also includes alert status to see how often an alert is fired or overridden.
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 Rolling Stone Contents Summary
Our tour of rivers and lakes expands to include bodies of water within the Greater Plains Collaborative states. This month honors Rolling Stone Lake in Wisconsin.
The HERON repository contains over 2 billion real observations from the hospital, clinics, and research systems:
Observation | Patients | Source | Go-Live | Snapshot | Issues | |
---|---|---|---|---|---|---|
Alerts | 24.4M | 488K | ||||
KUH/O2/Epic | Nov 2007 | Mar 2016 | ||||
Allergy | 665K | 292K | ||||
KUH/O2/Epic | Nov 2007 | Mar 2016 | various* | |||
Cancer Cases | 18.5M | 82.2K | ||||
KUH Cancer Registry | 1950s | Mar 2016 | labels* #3927 | |||
Cardiology Labs | 29.3M | 387K | ||||
KUH/O2/Epic | Nov 2007 | Mar 2016 | ||||
Demographics | 29.6M | 2.18M | ||||
KUH Billing (O2 via SMS) | 1980s | Mar 2016 | various* | |||
UKP Billing | 2000 | Mar 2016 | ||||
43.4K | 43.4K | Frontiers participant registry | Jun 2009 | Mar 2016 | ||
204.2K | 204.2K | Social Security Death Index | 1962 | Mar 2016 | ||
Diagnoses (IDC9, ICD10) | 79.2M | 894K | ||||
KUH/O2/Epic | Nov 2007 | Mar 2016 | various* | |||
UKP Billing | 2000 | Mar 2016 | #4093 | |||
University HealthSystem Consortium (UHC) | Q4 2008 | Dec 2015 | ||||
History | 51.1M | 525K | ||||
KUH/O2/Epic | Nov 2007 | Mar 2016 | ||||
Lab Results | 185M | 427K | ||||
KUH/O2/Epic | 2003 | Mar 2016 | various* | |||
Medications | 232M | 533K | ||||
KUH/O2/Epic (Organized by VA Class) | Nov 2007 | Mar 2016 | various* | |||
Microbiology | 4.39M | 36.2K | ||||
KUH/O2/Epic | 2003 (?) | Mar 2016 | various* | |||
940K | 145K | Negative | 2003 | Mar 2016 | ||
15.5K | 10.8K | Positive | 2003 | Mar 2016 | ||
National Cardiovascular Data Registry | 1.63M | 13.7K | ||||
NCDR | (?) | Sep 2015 | ||||
National Trauma Data Registry | 11K | 478 | ||||
NTDS | Apr 2015 | June 2015 | ||||
Nursing Observations | 1.04B | ? | ||||
KUH/O2/Epic | Nov 2007 | Mar 2016 | various* | |||
Procedure Orders | 224M | 655K | ||||
KUH/O2/Epic | 2003 (?) | Mar 2016 | various* | |||
Procedures (CPT) | 16.1 | 768K | ||||
UKP Billing | 2000 | Mar 2016 | #4093 #4100 | |||
REDCap | 1.70M | 52.1K | ||||
REDCap | July 2011 | Mar 2016 | ||||
Reports/Notes | 113M | 506K | ||||
KUH/O2/Epic | ? | Mar 2016 | ||||
Specimens | 137K | 9.7K | ||||
KUMC Biospecimen Repository | ? | Jun 2015 | ||||
Visit Details | 109M | 1.06M | ||||
KUH/O2/Epic | Nov 2007 | Mar 2016 | ||||
Hospital Quality Metrics | 9.5M | 122K | ||||
University HealthSystem Consortium (UHC) | Q4 2008 | Dec 2015 | various* | |||
All | 2.27B |
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:
- date shifting, part of our DeIdentificationStrategy
- age searching (#158)
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
Ticket Summary Keywords #2301 constraining birth-date by date doesn't work - HERON uses sysdate for start_date in demographics public-web wrong-results training #2617 Saved searches not updated in REDCap projects after Arkansas release public-web redcap-to-heron
HERON Paradise introduces study enrollment and trauma registry data
New data types in the HERON Paradise release include registry and study enrollment data.
- Study enrollment information: Want to find out how many people in your patient set are already enrolled in a study at KUMC? Go to the Research Enrollment folder. You can search by status for patients actively enrolled, pre-enrolled and more. Additionally, you can search the status in a specific trial.
- Trauma registry: Search for patients seen at the KU trauma department. This is the first phase for incorporating this registry into HERON, and future work will include incorporating the outstanding trauma registry fields.
This release includes enhancements to the tumor registry and diagnosis fields.
- Labels added for site specific factors: Prior to this release, searching the CS Site Specific Factors within the tumor registry required an understanding of the SEER coding structure. This release replaces the numeric codes with text labels making it easier to search items such as ER positive breast cancer patients.
- Medical History: Previously HERON included any diagnosis added to the medical history field. In this release, the medical history diagnosis is limited to only the most recent recording of medical history.
Save time submitting your next identified data request by searching for team members by your approved IRB number. Searching by IRB number as opposed to a team member name will avoid a request denial due to unauthorized team members listed on the data request.
Feedback on new data sources or enhancements are always welcome.
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 Paradise Contents Summary
Our tour of rivers and lakes expands to include bodies of water within the Greater Plains Collaborative states. This month honors Paradise Lake in Wisconsin.
The HERON repository contains over 2 billion real observations from the hospital, clinics, and research systems:
Observation | Patients | Source | Go-Live | Snapshot | Issues | |
---|---|---|---|---|---|---|
Alerts | 23.7M | 481K | ||||
KUH/O2/Epic | Nov 2007 | Feb 2016 | ||||
Allergy | 658K | 290K | ||||
KUH/O2/Epic | Nov 2007 | Feb 2016 | various* | |||
Cancer Cases | 18.5M | 82.2K | ||||
KUH Cancer Registry | 1950s | Feb 2016 | labels* | |||
Cardiology Labs | 28.8M | 384K | ||||
KUH/O2/Epic | Nov 2007 | Feb 2016 | ||||
Demographics | 29.3M | 2.18M | ||||
KUH Billing (O2 via SMS) | 1980s | Feb 2016 | various* | |||
UKP Billing | 2000 | Feb 2016 | ||||
42.1K | 42.1K | Frontiers participant registry | Jun 2009 | Feb 2016 | ||
203.3K | 203.3K | Social Security Death Index | 1962 | Feb 2016 | ||
Diagnoses (IDC9, ICD10) | 97M | 881K | ||||
KUH/O2/Epic | Nov 2007 | Feb 2016 | various* | |||
UKP Billing | 2000 | Feb 2016 | ||||
University HealthSystem Consortium (UHC) | Q4 2008 | Mar 2016 | ||||
History | 49.8M | 519K | ||||
KUH/O2/Epic | Nov 2007 | Feb 2016 | ||||
Lab Results | 183M | 423K | ||||
KUH/O2/Epic | 2003 | Feb 2016 | various* | |||
Medications | 229M | 527K | ||||
KUH/O2/Epic (Organized by VA Class) | Nov 2007 | Feb 2016 | various* | |||
Microbiology | 4.33M | 35.9K | ||||
KUH/O2/Epic | 2003 (?) | Feb 2016 | various* | |||
930K | 144K | Negative | 2003 | Feb 2016 | ||
15.1K | 10.6K | Positive | 2003 | Feb 2016 | ||
National Cardiovascular Data Registry | 1.57M | 13.2K | ||||
NCDR | (?) | Sep 2015 | ||||
National Trauma Data Registry | 11K | 478 | ||||
NTDS | Apr 2015 | June 2015 | ||||
Nursing Observations | 1.08B | ? | ||||
KUH/O2/Epic | Nov 2007 | Feb 2016 | various* | |||
Procedure Orders | 221M | 650K | ||||
KUH/O2/Epic | 2003 (?) | Feb 2016 | various* | |||
Procedures (CPT) | 16.3M | 761K | ||||
UKP Billing | 2000 | Feb 2016 | ||||
REDCap | 1.68M | 51.9K | ||||
REDCap | July 2011 | Feb 2016 | ||||
Reports/Notes | 111M | 501K | ||||
KUH/O2/Epic | ? | Feb 2016 | ||||
Specimens | 137K | 9.7K | ||||
KUMC Biospecimen Repository | ? | Jun 2015 | ||||
Visit Details | 107M | 1.06M | ||||
KUH/O2/Epic | Nov 2007 | Feb 2016 | ||||
Hospital Quality Metrics | 9.2M | 117K | ||||
University HealthSystem Consortium (UHC) | Q4 2008 | Mar 2016 | various* | |||
All | 2.23B |
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:
- date shifting, part of our DeIdentificationStrategy
- age searching (#158)
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
Ticket Summary Keywords #2301 constraining birth-date by date doesn't work - HERON uses sysdate for start_date in demographics public-web wrong-results training #2617 Saved searches not updated in REDCap projects after Arkansas release public-web redcap-to-heron
HERON Plum upgrades to the latest i2b2 version
HERON Plum release includes an upgrade to the latest i2b2 version (1.7.07). New features available in this i2b2 version include:
- Search your previous queries by name
- Delete temporal constraints
- Restrict dates at the item level in addition to group level
- Access plugins quickly from the find patient page
- Print query report
- Display query by right click on search
Trying to recruit patients for a study through Pioneers? Currently you can search Pioneers patients based on self reported medical history. Go to REDCap -> Pioneers -> Pioneers Survey -> Pioneers Medical History Survey to search on conditions specified in the medical history form. Future enhancements will include the ability to search across all data sources in HERON for patients who consent.
In a move to improve the medication data within HERON, this release includes an update to the RxNorm. Newer medications previously not found in HERON are now visible in the hierarchy.
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 Plum Contents Summary
Our tour of rivers and lakes expands to include bodies of water within the Greater Plains Collaborative states. This month honors Plum Lake.
The HERON repository contains over 2 billion real observations from the hospital, clinics, and research systems:
Observation | Patients | Source | Go-Live | Snapshot | Issues | |
---|---|---|---|---|---|---|
Alerts | 22.9M | 474K | ||||
KUH/O2/Epic | Nov 2007 | Jan 2016 | ||||
Allergy | 650K | 287K | ||||
KUH/O2/Epic | Nov 2007 | Jan 2016 | various* | |||
Cancer Cases | 18.2M | 82.2K | ||||
KUH Cancer Registry | 1950s | Jan 2016 | labels* | |||
Cardiology Labs | 28.4M | 380K | ||||
KUH/O2/Epic | Nov 2007 | Jan 2016 | ||||
Demographics | 29.1M | 2.17M | ||||
KUH Billing (O2 via SMS) | 1980s | Jan 2016 | various* | |||
UKP Billing | 2000 | Jan 2016 | ||||
41.5K | 41.5K | Frontiers participant registry | Jun 2009 | Jan 2016 | ||
202.5K | 202.5K | Social Security Death Index | 1962 | Jan 2016 | ||
Diagnoses (IDC9, ICD10) | 97M | 881K | ||||
KUH/O2/Epic | Nov 2007 | Jan 2016 | various* | |||
UKP Billing | 2000 | Jan 2016 | ||||
University HealthSystem Consortium (UHC) | Q4 2008 | Dec 2015 | ||||
History | 48.5M | 513K | ||||
KUH/O2/Epic | Nov 2007 | Jan 2016 | ||||
Lab Results | 181M | 420K | ||||
KUH/O2/Epic | 2003 | Jan 2016 | various* | |||
Medications | 225M | 521K | ||||
KUH/O2/Epic (Organized by VA Class) | Nov 2007 | Jan 2016 | various* | |||
Microbiology | 4.26M | 35.5K | ||||
KUH/O2/Epic | 2003 (?) | Jan 2016 | various* | |||
920K | 142K | Negative | 2003 | Jan 2016 | ||
14.7K | 10.4K | Positive | 2003 | Jan 2016 | ||
National Cardiovascular Data Registry | 1.57M | 13.2K | ||||
NCDR | (?) | Sep 2015 | ||||
Nursing Observations | 1.08B | ? | ||||
KUH/O2/Epic | Nov 2007 | Jan 2016 | various* | |||
Procedure Orders | 217M | 644K | ||||
KUH/O2/Epic | 2003 (?) | Jan 2016 | various* | |||
Procedures (CPT) | 15.8M | 757K | ||||
UKP Billing | 2000 | Jan 2016 | ||||
REDCap | 1.65M | 51.8K | ||||
REDCap | July 2011 | Jan 2016 | ||||
Reports/Notes | 109M | 495K | ||||
KUH/O2/Epic | ? | Jan 2016 | ||||
Specimens | 137K | 9.7K | ||||
KUMC Biospecimen Repository | ? | Jun 2015 | ||||
Visit Details | 105M | 1.05M | ||||
KUH/O2/Epic | Nov 2007 | Jan 2016 | ||||
Hospital Quality Metrics | 9.2M | 117K | ||||
University HealthSystem Consortium (UHC) | Q4 2008 | Dec 2015 | various* | |||
All | 2.17B |
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:
- date shifting, part of our DeIdentificationStrategy
- age searching (#158)
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
Ticket Summary Keywords #2301 constraining birth-date by date doesn't work - HERON uses sysdate for start_date in demographics public-web wrong-results training #2617 Saved searches not updated in REDCap projects after Arkansas release public-web redcap-to-heron
HERON Pike: MI team attends GPC Hackathon 3
HERON Pike release includes data through December 2015. During this release, the Medical Informatics team hosted the GPC Hackathon 3 in Kansas City, KS. Thirteen institutions came together to develop and test code for future GPC work. See agendaandmeeting notes for additional meeting information.
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 Pike Contents Summary
Our tour of rivers and lakes expands to include bodies of water within the Greater Plains Collaborative states. This month honors Pike Lake.
The HERON repository contains over 2 billion real observations from the hospital, clinics, and research systems:
Observation | Patients | Source | Go-Live | Snapshot | Issues | |
---|---|---|---|---|---|---|
Alerts | 22.2M | 467K | ||||
KUH/O2/Epic | Nov 2007 | Dec 2015 | ||||
Allergy | 643K | 284K | ||||
KUH/O2/Epic | Nov 2007 | Dec 2015 | various* | |||
Cancer Cases | 18.2M | 82.2K | ||||
KUH Cancer Registry | 1950s | Dec 2015 | labels* | |||
Cardiology Labs | 28M | 378K | ||||
KUH/O2/Epic | Nov 2007 | Dec 2015 | ||||
Demographics | 27.3M | 2.16M | ||||
KUH Billing (O2 via SMS) | 1980s | Dec 2015 | various* | |||
UKP Billing | 2000 | Dec 2015 | ||||
40.3K | 40.3K | Frontiers participant registry | Jun 2009 | Dec 2015 | ||
202K | 202K | Social Security Death Index | 1962 | Dec 2015 | ||
Diagnoses (IDC9, ICD10) | 95M | 875K | ||||
KUH/O2/Epic | Nov 2007 | Dec 2015 | various* | |||
UKP Billing | 2000 | Dec 2015 | ||||
University HealthSystem Consortium (UHC) | Q4 2008 | Dec 2015 | ||||
History | 47.4M | 507K | ||||
KUH/O2/Epic | Nov 2007 | Dec 2015 | ||||
Lab Results | 179M | 416K | ||||
KUH/O2/Epic | 2003 | Dec2015 | various* | |||
Medications | 222M | 515K | ||||
KUH/O2/Epic (Organized by VA Class) | Nov 2007 | Dec 2015 | various* | |||
Microbiology | 4.2M | 35.1K | ||||
KUH/O2/Epic | 2003 (?) | Dec 2015 | various* | |||
910K | 141K | Negative | 2003 | Dec2015 | ||
14.4K | 10.2K | Positive | 2003 | Dec 2015 | ||
National Cardiovascular Data Registry | 1.5M | 12.8K | ||||
NCDR | (?) | Dec 2014 | ||||
Nursing Observations | 1.01B | ? | ||||
KUH/O2/Epic | Nov 2007 | Dec 2015 | various* | |||
Procedure Orders | 214M | 638K | ||||
KUH/O2/Epic | 2003 (?) | Dec 2015 | various* | |||
Procedures (CPT) | 15.7M | 751K | ||||
UKP Billing | 2000 | Dec 2015 | ||||
REDCap | 1.63M | 51.6K | ||||
REDCap | July 2011 | Dec 2015 | ||||
Reports/Notes | 107M | 490K | ||||
KUH/O2/Epic | ? | Dec 2015 | ||||
Specimens | 137K | 9.7K | ||||
KUMC Biospecimen Repository | ? | Jun 2015 | ||||
Visit Details | 103M | 1.04M | ||||
KUH/O2/Epic | Nov 2007 | Dec 2015 | ||||
Hospital Quality Metrics | 9.2M | 117K | ||||
University HealthSystem Consortium (UHC) | Q4 2008 | Dec 2015 | various* | |||
All | 2.17B |
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:
- date shifting, part of our DeIdentificationStrategy
- age searching (#158)
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
Ticket Summary Keywords #2301 constraining birth-date by date doesn't work - HERON uses sysdate for start_date in demographics public-web wrong-results training #2617 Saved searches not updated in REDCap projects after Arkansas release public-web redcap-to-heron
HERON Butternut marks 56th HERON release
HERON Butternut is the last release for 2015 and marks the 56th release of HERON. This release involves back-end maintenance. While not visible most users, the fixes will improve the future release processes.
Since the beta release of HERON in March 2011, HERON data has grown to over 2.14 billion clinical observations. This table provides an overview of the growth in data from the March 2011 to December 2015 releases. You will note that only 5 data types were available in March 2011. See the Butternut Content Summary for a listing of currently available data types, including those added since the inaugural release.
2011 Observations | 2011 Patients | 2015 Observations | 2015 Patients | |
Demographics | 7.2M | 1.8M | 27.1M | 2.16M |
Diagnosis | 2.2M | 190K | 94M | 869K |
Medications | 18M | 60K | 219M | 509K |
Nursing Flowsheets | 390M | 240K | 1B | * |
Lab results | 25M | 120K | 177M | 413K |
*Note Total patient counts for Nursing observations are not available due to the amount of time necessary to compile statistics on over 1 billion clinical observations. The patient numbers are available in the nursing flowsheets at the search concept level.
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 Butternut Contents Summary
Our tour of rivers and lakes expands to include bodies of water within the Greater Plains Collaborative states. This month honors Butternut Lake.
The HERON repository contains over 2 billion real observations from the hospital, clinics, and research systems:
Observation | Patients | Source | Go-Live | Snapshot | Issues | |
---|---|---|---|---|---|---|
Alerts | 21.4M | 460K | ||||
KUH/O2/Epic | Nov 2007 | Nov 2015 | ||||
Allergy | 635K | 282K | ||||
KUH/O2/Epic | Nov 2007 | Nov 2015 | various* | |||
Cancer Cases | 18.1M | 81.8K | ||||
KUH Cancer Registry | 1950s | Nov 2015 | labels* | |||
Cardiology Labs | 27.5M | 374K | ||||
KUH/O2/Epic | Nov 2007 | Nov 2015 | ||||
Demographics | 27.1M | 2.16M | ||||
KUH Billing (O2 via SMS) | 1980s | Nov 2015 | various* | |||
UKP Billing | 2000 | Nov 2015 | ||||
39.9K | 39.9K | Frontiers participant registry | Jun 2009 | Nov 2015 | ||
207.1K | 207.1K | Social Security Death Index | 1962 | Nov 2015 | ||
Diagnoses (IDC9, ICD10) | 94M | 869K | ||||
KUH/O2/Epic | Nov 2007 | Nov 2015 | various* | |||
UKP Billing | 2000 | Nov 2015 | ||||
University HealthSystem Consortium (UHC) | Q4 2008 | Aug 2015 | ||||
History | 46.1M | 501K | ||||
KUH/O2/Epic | Nov 2007 | Nov 2015 | ||||
Lab Results | 177M | 413K | ||||
KUH/O2/Epic | 2003 | Nov 2015 | various* | |||
Medications | 219M | 509K | ||||
KUH/O2/Epic (Organized by VA Class) | Nov 2007 | Nov 2015 | various* | |||
Microbiology | 4.13M | 34.6K | ||||
KUH/O2/Epic | 2003 (?) | Nov 2015 | various* | |||
900K | 139K | Negative | 2003 | Nov 2015 | ||
14.1K | 10K | Positive | 2003 | Nov 2015 | ||
National Cardiovascular Data Registry | 1.45M | 12.3K | ||||
NCDR | (?) | Dec 2014 | ||||
Nursing Observations | 1B | ? | ||||
KUH/O2/Epic | Nov 2007 | Nov 2015 | various* | |||
Procedure Orders | 211M | 632K | ||||
KUH/O2/Epic | 2003 (?) | Nov 2015 | various* | |||
Procedures (CPT) | 15.5M | 747K | ||||
UKP Billing | 2000 | Nov 2015 | ||||
REDCap | 1.4M | 50.2K | ||||
REDCap | July 2011 | Nov 2015 | ||||
Reports/Notes | 104M | 485K | ||||
KUH/O2/Epic | ? | Nov 2015 | ||||
Specimens | 137K | 9.7K | ||||
KUMC Biospecimen Repository | ? | Jun 2015 | ||||
Visit Details | 102M | 1.03M | ||||
KUH/O2/Epic | Nov 2007 | Nov 2015 | ||||
Hospital Quality Metrics | 8.78M | 112K | ||||
University HealthSystem Consortium (UHC) | Q4 2008 | Aug 2015 | various* | |||
All | 2.14B |
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:
- date shifting, part of our DeIdentificationStrategy
- age searching (#158)
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
Ticket Summary Keywords #2301 constraining birth-date by date doesn't work - HERON uses sysdate for start_date in demographics public-web wrong-results training #2617 Saved searches not updated in REDCap projects after Arkansas release public-web redcap-to-heron
HERON Menomonee includes Pioneers Research Registry participants
Pioneers Recruitment Registry is now included in HERON. The Pioneers registry allows searches to be limited only to those members of the public who consented to be contacted regarding clinical trials at KUMC, This month the registry is only available in HERON to the Pioneers administrators. It will be searchable by all HERON users in the future.
Labs within the LOINC folder are now searchable by lab value. LOINC codes are universal identifiers used to facilitate the sharing of laboratory data for research, outcomes management, and clinical care.
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 Menomonee Contents Summary
Our tour of rivers and lakes expands to include bodies of water within the Greater Plains Collaborative states. This month honors Menominee River.
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.8M | 454K | ||||
KUH/O2/Epic | Nov 2007 | Oct 2015 | ||||
Allergy | 629K | 279K | ||||
KUH/O2/Epic | Nov 2007 | Oct 2015 | various* | |||
Cancer Cases | 18M | 81.7K | ||||
KUH Cancer Registry | 1950s | Oct 2015 | labels* | |||
Cardiology Labs | 27.2M | 372K | ||||
KUH/O2/Epic | Nov 2007 | Oct 2015 | ||||
Demographics | 26.8M | 2.15M | ||||
KUH Billing (O2 via SMS) | 1980s | Oct 2015 | various* | |||
UKP Billing | 2000 | Oct 2015 | ||||
39.3K | 39.3K | Frontiers participant registry | Jun 2009 | Oct 2015 | ||
207.1K | 207.1K | Social Security Death Index | 1962 | Oct 2015 | ||
Diagnoses (IDC9, ICD10) | 92M* | 864K* | ||||
KUH/O2/Epic | Nov 2007 | Oct 2015 | various* | |||
UKP Billing | 2000 | Oct 2015 | ||||
University HealthSystem Consortium (UHC) | Q4 2008 | Jun 2015 | ||||
History | 45.2M | 496K | ||||
KUH/O2/Epic | Nov 2007 | Oct 2015 | ||||
Lab Results | 175M | 410K | ||||
KUH/O2/Epic | 2003 | Oct 2015 | various* | |||
Medications | 216M | 504K | ||||
KUH/O2/Epic (Organized by VA Class) | Nov 2007 | Oct 2015 | various* | |||
Microbiology | 4.07M | 34.3K | ||||
KUH/O2/Epic | 2003 (?) | Oct 2015 | various* | |||
894K | 138K | Negative | 2003 | Oct 2015 | ||
13.9K | 9.9K | Positive | 2003 | Oct 2015 | ||
National Cardiovascular Data Registry | 1.45M | 12.3K | ||||
NCDR | (?) | Dec 2014 | ||||
Nursing Observations | 1B | ? | ||||
KUH/O2/Epic | Nov 2007 | Oct 2015 | various* | |||
Procedure Orders | 208M | 628K | ||||
KUH/O2/Epic | 2003 (?) | Oct 2015 | various* | |||
Procedures (CPT) | 15.4M | 742K | ||||
UKP Billing | 2000 | Oct 2015 | ||||
REDCap | 1.4M | 49.6K | ||||
REDCap | July 2011 | Oct 2015 | ||||
Reports/Notes | 103M | 480K | ||||
KUH/O2/Epic | ? | Oct 2015 | ||||
Specimens | 137K | 9.7K | ||||
KUMC Biospecimen Repository | ? | Jun 2015 | ||||
Visit Details | 100M | 1.03M | ||||
KUH/O2/Epic | Nov 2007 | Oct 2015 | ||||
Hospital Quality Metrics | 8.78M | 112K | ||||
University HealthSystem Consortium (UHC) | Q4 2008 | Jun 2015 | #2911 | |||
All | 2.12B |
* 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:
- date shifting, part of our DeIdentificationStrategy
- age searching (#158)
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
Ticket | Summary | Keywords |
---|---|---|
#2301 | constraining birth-date by date doesn't work - HERON uses sysdate for start_date in demographics | public-web wrong-results training |
#2617 | Saved searches not updated in REDCap projects after Arkansas release | public-web redcap-to-heron |
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:
- date shifting, part of our DeIdentificationStrategy
- age searching (#158)
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
Ticket | Summary | Keywords |
---|---|---|
#2301 | constraining birth-date by date doesn't work - HERON uses sysdate for start_date in demographics | public-web wrong-results training |
#2617 | Saved searches not updated in REDCap projects after Arkansas release | public-web redcap-to-heron |
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:
- date shifting, part of our DeIdentificationStrategy
- age searching (#158)
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
Ticket | Summary | Keywords |
---|---|---|
#2301 | constraining birth-date by date doesn't work - HERON uses sysdate for start_date in demographics | public-web wrong-results training |
#2617 | Saved searches not updated in REDCap projects after Arkansas release | public-web redcap-to-heron |
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:
- date shifting, part of our DeIdentificationStrategy
- age searching (#158)
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.
Outstanding Problems/Defects/Issues
Ticket | Summary | Keywords |
---|---|---|
#2301 | constraining birth-date by date doesn't work - HERON uses sysdate for start_date in demographics | public-web wrong-results training |
#2617 | Saved searches not updated in REDCap projects after Arkansas release | public-web redcap-to-heron |
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:
- date shifting, part of our DeIdentificationStrategy
- age searching (#158)
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
Ticket | Summary | Keywords |
---|---|---|
#2301 | constraining birth-date by date doesn't work - HERON uses sysdate for start_date in demographics | public-web wrong-results training |
#2617 | Saved searches not updated in REDCap projects after Arkansas release | public-web redcap-to-heron |
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:
- date shifting, part of our DeIdentificationStrategy
- age searching (#158)
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.
Outstanding Problems/Defects/Issues
Ticket | Summary | Keywords |
---|---|---|
#2301 | constraining birth-date by date doesn't work - HERON uses sysdate for start_date in demographics | public-web wrong-results training |
#2617 | Saved searches not updated in REDCap projects after Arkansas release | public-web redcap-to-heron |
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:
- date shifting, part of our DeIdentificationStrategy
- age searching (#158)
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.
Outstanding Problems/Defects/Issues
Ticket | Summary | Keywords |
---|---|---|
#2301 | constraining birth-date by date doesn't work - HERON uses sysdate for start_date in demographics | public-web wrong-results training |
#2617 | Saved searches not updated in REDCap projects after Arkansas release | public-web redcap-to-heron |
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:
- date shifting, part of our DeIdentificationStrategy
- age searching (#158)
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.
Outstanding Problems/Defects/Issues
Ticket | Summary | Keywords |
---|---|---|
#2301 | constraining birth-date by date doesn't work - HERON uses sysdate for start_date in demographics | public-web wrong-results training |
#2617 | Saved searches not updated in REDCap projects after Arkansas release | public-web redcap-to-heron |
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:
- date shifting, part of our DeIdentificationStrategy
- age searching (#158)
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.
Outstanding Problems/Defects/Issues
Ticket | Summary | Keywords |
---|---|---|
#2301 | constraining birth-date by date doesn't work - HERON uses sysdate for start_date in demographics | public-web wrong-results training |
#2617 | Saved searches not updated in REDCap projects after Arkansas release | public-web redcap-to-heron |
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:
- date shifting, part of our DeIdentificationStrategy
- age searching (#158)
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
Ticket | Summary | Keywords |
---|---|---|
#2301 | constraining birth-date by date doesn't work - HERON uses sysdate for start_date in demographics | public-web wrong-results training |
#2617 | Saved searches not updated in REDCap projects after Arkansas release | public-web redcap-to-heron |
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:
- date shifting, part of our DeIdentificationStrategy
- age searching (#158)
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
Ticket | Summary | Keywords |
---|---|---|
#2301 | constraining birth-date by date doesn't work - HERON uses sysdate for start_date in demographics | public-web wrong-results training |
#2617 | Saved searches not updated in REDCap projects after Arkansas release | public-web redcap-to-heron |
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:
- date shifting, part of our DeIdentificationStrategy
- age searching (#158)
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
Ticket | Summary | Keywords |
---|---|---|
#2301 | constraining birth-date by date doesn't work - HERON uses sysdate for start_date in demographics | public-web wrong-results training |
#2617 | Saved searches not updated in REDCap projects after Arkansas release | public-web redcap-to-heron |
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:
- date shifting, part of our DeIdentificationStrategy
- age searching (#158)
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
Ticket | Summary | Keywords |
---|---|---|
#2301 | constraining birth-date by date doesn't work - HERON uses sysdate for start_date in demographics | public-web wrong-results training |
#2617 | Saved searches not updated in REDCap projects after Arkansas release | public-web redcap-to-heron |
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:
- date shifting, part of our DeIdentificationStrategy
- age searching (#158)
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
Ticket | Summary | Keywords |
---|---|---|
#2301 | constraining birth-date by date doesn't work - HERON uses sysdate for start_date in demographics | public-web wrong-results training |
#2617 | Saved searches not updated in REDCap projects after Arkansas release | public-web redcap-to-heron |
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:
- date shifting, part of our DeIdentificationStrategy
- age searching (#158)
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
Ticket | Summary | Keywords |
---|---|---|
#2301 | constraining birth-date by date doesn't work - HERON uses sysdate for start_date in demographics | public-web wrong-results training |
#2617 | Saved searches not updated in REDCap projects after Arkansas release | public-web redcap-to-heron |
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:
- date shifting, part of our DeIdentificationStrategy
- age searching (#158)
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
Ticket | Summary | Keywords |
---|---|---|
#2301 | constraining birth-date by date doesn't work - HERON uses sysdate for start_date in demographics | public-web wrong-results training |
#2617 | Saved searches not updated in REDCap projects after Arkansas release | public-web redcap-to-heron |
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:
- date shifting, part of our DeIdentificationStrategy
- age searching (#158)
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
Ticket | Summary | Keywords |
---|---|---|
#2301 | constraining birth-date by date doesn't work - HERON uses sysdate for start_date in demographics | public-web wrong-results training |
#2617 | Saved searches not updated in REDCap projects after Arkansas release | public-web redcap-to-heron |
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:
- date shifting, part of our DeIdentificationStrategy
- age searching (#158)
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
Ticket | Summary | Keywords |
---|---|---|
#2301 | constraining birth-date by date doesn't work - HERON uses sysdate for start_date in demographics | public-web wrong-results training |
#2617 | Saved searches not updated in REDCap projects after Arkansas release | public-web redcap-to-heron |
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:
- date shifting, part of our DeIdentificationStrategy
- age searching (#158)
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
Ticket | Summary | Keywords |
---|---|---|
#2301 | constraining birth-date by date doesn't work - HERON uses sysdate for start_date in demographics | public-web wrong-results training |
#2617 | Saved searches not updated in REDCap projects after Arkansas release | public-web redcap-to-heron |
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:
- date shifting, part of our DeIdentificationStrategy
- age searching (#158)
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
Ticket | Summary | Keywords |
---|---|---|
#2301 | constraining birth-date by date doesn't work - HERON uses sysdate for start_date in demographics | public-web wrong-results training |
#2617 | Saved searches not updated in REDCap projects after Arkansas release | public-web redcap-to-heron |
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:
- date shifting, part of our DeIdentificationStrategy
- age searching (#158)
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.
Outstanding Problems/Defects/Issues
Ticket | Summary | Keywords |
---|---|---|
#2301 | constraining birth-date by date doesn't work - HERON uses sysdate for start_date in demographics | public-web wrong-results training |
#2617 | Saved searches not updated in REDCap projects after Arkansas release | public-web redcap-to-heron |
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:
- date shifting, part of our DeIdentificationStrategy
- age searching (#158)
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
Ticket | Summary | Keywords |
---|---|---|
#2301 | constraining birth-date by date doesn't work - HERON uses sysdate for start_date in demographics | public-web wrong-results training |
#2617 | Saved searches not updated in REDCap projects after Arkansas release | public-web redcap-to-heron |
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:
- date shifting, part of our DeIdentificationStrategy
- age searching (#158)
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.
Outstanding Problems/Defects/Issues
Ticket | Summary | Keywords |
---|---|---|
#2301 | constraining birth-date by date doesn't work - HERON uses sysdate for start_date in demographics | public-web wrong-results training |
#2617 | Saved searches not updated in REDCap projects after Arkansas release | public-web redcap-to-heron |
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:
- date shifting, part of our DeIdentificationStrategy
- age searching (#158)
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
Ticket | Summary | Keywords |
---|---|---|
#2301 | constraining birth-date by date doesn't work - HERON uses sysdate for start_date in demographics | public-web wrong-results training |
#2617 | Saved searches not updated in REDCap projects after Arkansas release | public-web redcap-to-heron |
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:
- date shifting, part of our DeIdentificationStrategy
- age searching (#158)
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
Ticket | Summary | Keywords |
---|---|---|
#2301 | constraining birth-date by date doesn't work - HERON uses sysdate for start_date in demographics | public-web wrong-results training |
#2617 | Saved searches not updated in REDCap projects after Arkansas release | public-web redcap-to-heron |
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:
- date shifting, part of our DeIdentificationStrategy
- age searching (#158)
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
Ticket | Summary | Keywords |
---|---|---|
#2301 | constraining birth-date by date doesn't work - HERON uses sysdate for start_date in demographics | public-web wrong-results training |
#2617 | Saved searches not updated in REDCap projects after Arkansas release | public-web redcap-to-heron |
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:
- date shifting, part of our DeIdentificationStrategy
- age searching (#158)
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
Ticket | Summary | Keywords |
---|---|---|
#2301 | constraining birth-date by date doesn't work - HERON uses sysdate for start_date in demographics | public-web wrong-results training |
#2617 | Saved searches not updated in REDCap projects after Arkansas release | public-web redcap-to-heron |
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:
- date shifting, part of our DeIdentificationStrategy
- age searching (#158)
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
Ticket | Summary | Keywords |
---|---|---|
#2301 | constraining birth-date by date doesn't work - HERON uses sysdate for start_date in demographics | public-web wrong-results training |
#2617 | Saved searches not updated in REDCap projects after Arkansas release | public-web redcap-to-heron |
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:
- date shifting, part of our DeIdentificationStrategy
- age searching (#158)
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
Ticket | Summary | Keywords |
---|---|---|
#2301 | constraining birth-date by date doesn't work - HERON uses sysdate for start_date in demographics | public-web wrong-results training |
#2617 | Saved searches not updated in REDCap projects after Arkansas release | public-web redcap-to-heron |
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:
- date shifting, part of our DeIdentificationStrategy
- age searching (#158)
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
Ticket | Summary | Keywords |
---|---|---|
#2301 | constraining birth-date by date doesn't work - HERON uses sysdate for start_date in demographics | public-web wrong-results training |
#2617 | Saved searches not updated in REDCap projects after Arkansas release | public-web redcap-to-heron |
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:
- date shifting, part of our DeIdentificationStrategy
- age searching (#158)
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
Ticket | Summary | Keywords |
---|---|---|
#2301 | constraining birth-date by date doesn't work - HERON uses sysdate for start_date in demographics | public-web wrong-results training |
#2617 | Saved searches not updated in REDCap projects after Arkansas release | public-web redcap-to-heron |
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:
- date shifting, part of our DeIdentificationStrategy
- age searching (#158)
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
Ticket | Summary | Keywords |
---|---|---|
#2301 | constraining birth-date by date doesn't work - HERON uses sysdate for start_date in demographics | public-web wrong-results training |
#2617 | Saved searches not updated in REDCap projects after Arkansas release | public-web redcap-to-heron |
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:
- date shifting, part of our DeIdentificationStrategy
- age searching (#158)
Enhancements and Problems/Defects/Issues Addressed in this Release
No results
Outstanding Problems/Defects/Issues
Ticket | Summary | Keywords |
---|---|---|
#2301 | constraining birth-date by date doesn't work - HERON uses sysdate for start_date in demographics | public-web wrong-results training |
#2617 | Saved searches not updated in REDCap projects after Arkansas release | public-web redcap-to-heron |
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:
- date shifting, part of our DeIdentificationStrategy
- age searching (#158)
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
Ticket | Summary | Keywords |
---|---|---|
#2301 | constraining birth-date by date doesn't work - HERON uses sysdate for start_date in demographics | public-web wrong-results training |
#2617 | Saved searches not updated in REDCap projects after Arkansas release | public-web redcap-to-heron |
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:
- date shifting, part of our DeIdentificationStrategy
- age searching (#158)
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
Ticket | Summary | Keywords |
---|---|---|
#2301 | constraining birth-date by date doesn't work - HERON uses sysdate for start_date in demographics | public-web wrong-results training |
#2617 | Saved searches not updated in REDCap projects after Arkansas release | public-web redcap-to-heron |
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:
- date shifting, part of our DeIdentificationStrategy
- age searching (#158)
Enhancements and Problems/Defects/Issues Addressed in this Release
No results
Outstanding Problems/Defects/Issues
Ticket | Summary | Keywords |
---|---|---|
#2301 | constraining birth-date by date doesn't work - HERON uses sysdate for start_date in demographics | public-web wrong-results training |
#2617 | Saved searches not updated in REDCap projects after Arkansas release | public-web redcap-to-heron |
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:
- date shifting, part of our DeIdentificationStrategy
- age searching (#158)
Enhancements and Problems/Defects/Issues Addressed in this Release
Outstanding Problems/Defects/Issues
Ticket | Summary | Keywords |
---|---|---|
#2301 | constraining birth-date by date doesn't work - HERON uses sysdate for start_date in demographics | public-web wrong-results training |
#2617 | Saved searches not updated in REDCap projects after Arkansas release | public-web redcap-to-heron |
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:
- date shifting, part of our DeIdentificationStrategy
- age searching (#158)
Enhancements and Problems/Defects/Issues Addressed in this Release
No results
Outstanding Problems/Defects/Issues
Ticket | Summary | Keywords |
---|---|---|
#2301 | constraining birth-date by date doesn't work - HERON uses sysdate for start_date in demographics | public-web wrong-results training |
#2617 | Saved searches not updated in REDCap projects after Arkansas release | public-web redcap-to-heron |
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:
- date shifting, part of our DeIdentificationStrategy
- age searching (#158)
Enhancements and Problems/Defects/Issues Addressed in this Release
No results
Outstanding Problems/Defects/Issues
Ticket | Summary | Keywords |
---|---|---|
#2301 | constraining birth-date by date doesn't work - HERON uses sysdate for start_date in demographics | public-web wrong-results training |
#2617 | Saved searches not updated in REDCap projects after Arkansas release | public-web redcap-to-heron |
HERON: Big Hill release adds home medications, other medication orders, and expands UHC data
The Big Hill release adds support for home medications and expands UHC coverage. Previously, we only had medications that are dispensed by the hospital pharmacy; now, you'll be able to see
- medications that the patient reports taking at home (so called "historical medications"), as well as
- all other orders, which includes prescriptions, inpatient medication orders, and discharge medication orders.
- data for an additional 100K patients
The UHC data, although primarily administrative, provides a new view on a patient's interaction at the hospital. New UHC concepts include:
- ICU length of stay: Search on time spent in ICU.
- Admission and Discharge status concepts: Search where patients came from prior to admission or went to upon discharge.
- Readmission concept: Helps you search for patients readmitted after discharge to their home, allowing specification to a desired number of days.
- Clinical Classification Software (CCS) ICD-9: These codes provided by AHRQ collapse ICD-9 diagnosis and procedure codes into a smaller number of categories useful in analyzing data. See AHRQ web site.
- All Patient Refined Diagnosis Related Groups (APR DRGs): DRG codes expanded to include 4 subclasses in severity of illness and mortality subgroups for each code. See web site.
- Major Diagnostic Categories (MDCs): Search these diagnosis categories created by combining ICD-9 diagnosis codes into 25 MDCs. These codes, which are used primarily for administrative and billing purposes, provide another view on patient data.
- Comorbidity: Search 29 comorbidity categories.
Currently the UHC data is limited to a 1-year time period (Nov. 2010-Nov. 2011). Look for additional years in future releases. This data is limited to hospital encounters and lacks clinic data.
HERON Big Hill Contents Summary
This month, our tour of rivers and lakes in Kansas honors lake Big Hill.
The HERON repository contains approximately 630 million real observations from the hospital, clinics, and research systems:
Observation | Patients | Source | Go-Live | Snapshot | Issues | |
---|---|---|---|---|---|---|
Demographics | 18.0M | 1.90M | ||||
KUH Billing (O2 via SMS) | 1980s | Feb 2012 | various* | |||
UKP Billing | 2000 | Feb 2012 | ||||
9.5K | 9.5K | Frontiers participant registry | Jun 2009 | Feb 2012 | ||
183K | 183k | Social Security Death Index | 1962 | Feb 2012 | ||
Diagnoses (IDC9) | 18.7M | 602K | ||||
KUH/O2/Epic | Nov 2007 | Feb 2012 | various* | |||
UKP Billing | 2000 | Feb 2012 | ||||
Medications | 78.1M | 245K | ||||
KUH/O2/Epic | Nov 2007 | Feb 2012 | various* | |||
Nursing Observations | 463M | ? | ||||
KUH/O2/Epic | Nov 2007 | Feb 2012 | various* | |||
Lab Results | 72.6M | 257K | ||||
KUH/O2/Epic | 2003 | Feb 2012 | various* | |||
Procedures (CPT) | 9.6M | 542K | ||||
UKP Billing | 2000 | Feb 2012 | ||||
Specimens | 27.8K | 2.80K | ||||
KUMC Biospecimen Repository | ? | Jan 2012 | ||||
Cancer Cases | 9.1M | 62.8K | ||||
KUH Cancer Registry | 1950s | Jan 2012 | labels* | |||
Hospital Quality Metrics | .97M | 19.7K | ||||
University HealthSystem Consortium (UHC) | N/A | Nov 2011 | #997 | |||
All | 630M |
Beta Disclaimer
We are providing this early access to obtain feedback from you, the research community. While we are actively working on validating the data loaded into the system with hospital and clinic technical staff, there may be problems with our translation of data from our source systems (HospitalEpicSource and ClinicIdxSource) into HERON.
Please email us at heron-admin@kumc.edu if you discover information you believe may be erroneous.
We are actively working on enhancing the types of data included. Stay tuned to our roadmap to track progress toward upcoming releases.
Various Issues Still Apply
Keep in mind the issues noted in the original HERON beta notice, including:
- date shifting, part of our DeIdentificationStrategy
- age searching (#158)
Enhancements and Problems/Defects/Issues Addressed in this Release
No results
Outstanding Problems/Defects/Issues
Ticket | Summary | Keywords |
---|---|---|
#2301 | constraining birth-date by date doesn't work - HERON uses sysdate for start_date in demographics | public-web wrong-results training |
#2617 | Saved searches not updated in REDCap projects after Arkansas release | public-web redcap-to-heron |
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:
- date shifting, part of our DeIdentificationStrategy
- age searching (#158)
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
Ticket | Summary | Keywords |
---|---|---|
#2301 | constraining birth-date by date doesn't work - HERON uses sysdate for start_date in demographics | public-web wrong-results training |
#2617 | Saved searches not updated in REDCap projects after Arkansas release | public-web redcap-to-heron |
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:
- date shifting, part of our DeIdentificationStrategy
- age searching (#158)
Enhancements and Problems/Defects/Issues Addressed in this Release
No results
Outstanding Problems/Defects/Issues
Ticket | Summary | Keywords |
---|---|---|
#2301 | constraining birth-date by date doesn't work - HERON uses sysdate for start_date in demographics | public-web wrong-results training |
#2617 | Saved searches not updated in REDCap projects after Arkansas release | public-web redcap-to-heron |
HERON Bow Creek Release brings Cancer Survival Analysis, R integration
The highlights for this release include:
- interactive cancer survival analysis plotting plug-in, building on our initial tumor registry integration.
- "same visit" queries (#790), building on our initial i2b2 1.6 upgrade
Our cancer survival analysis plug-in is based on work by Segagni et. al.:
- J Am Med Inform Assoc. 2011 May 1;18(3):314-7. Epub 2011 Jan 24. R engine cell: integrating R into the i2b2 software infrastructure. Segagni D, Ferrazzi F, Larizza C, Tibollo V, Napolitano C, Priori SG, Bellazzi R.
- i2b2-r-engine-project on google code
- R Engine Cell in Orbit
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:
- date shifting, part of our DeIdentificationStrategy
- age searching (#158)
Enhancements and Problems/Defects/Issues Addressed in this Release
No results
Outstanding Problems/Defects/Issues
Ticket | Summary | Keywords |
---|---|---|
#2301 | constraining birth-date by date doesn't work - HERON uses sysdate for start_date in demographics | public-web wrong-results training |
#2617 | Saved searches not updated in REDCap projects after Arkansas release | public-web redcap-to-heron |
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:
CATEGORY | FACTS | PATIENTS |
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
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.
Analysis tools, Social Security Death Index, 50% more Labs arrive as HERON visits Cheney Lake
This month, the release of our HERON research data repository honors Cheney Lake. In addition to our regularly monthly refresh of the data, we're excited about the three big enhancements in this release:
No results
Unfortunately, we broke something so we know longer know race regarding our population (#637). That data was suspect so we will be exploring how to incorporate race and ethnicity with greater fidelity.
Join us at the Frontiers Clinical/Translational Informatics Clinic for full demonstration and discussion. The next one is Tuesday, Oct 4 at 4pm in 1040 Dykes Library.
Meanwhile, see:
- Using i2b2 Timeline and other analysis plug-ins in HERON
- Social Security Death Index integration expands vital statistics available in HERON
Contents Summary: 50% more Labs
The HERON repository contains approximately 516 million real observations from the hospital and clinics:
Observation | Patients | Source | Go-Live | Snapshot | Issues | |
---|---|---|---|---|---|---|
Demographics | 14.7M | 1.87M | ||||
KUH Billing (O2 via SMS) | 1980s | Aug 2011 | various* | |||
UKP Billing | 2000 | Aug 2011 | ||||
6.09K | 6.09K | Frontiers participant registry | Jun 2009 | Aug 2011 | ||
Diagnoses (IDC9) | 16.7M | 558K | ||||
KUH/O2/Epic | Nov 2007 | Aug 2011 | various* | |||
UKP Billing | 2000 | Aug 2011 | ||||
Medications | 245.0M | 91K | ||||
KUH/O2/Epic | Nov 2007 | Aug 2011 | various* | |||
Nursing Observations | 386M | ? | ||||
KUH/O2/Epic | Nov 2007 | Aug 2011 | various* | |||
Lab Results | 65.2M | 234K | ||||
KUH/O2/Epic | Nov 2007 | Aug 2011 | various* | |||
Procedures (CPT) | 8.94M | 515K | ||||
UKP Billing | 2000 | Aug 2011 | ||||
All | 516M |
We have loaded was was referred to in O2/Epic as "conversion labs". These were lab results recorded prior to Epic system implementation from 2004 through 2007. Note that because we shift dates back in time (0 to 365 days) for de-identifcation, some of these results in HERON are noted as resulted in 2003. The table below provides a comparison of laboratory results by year for our current Cheney release versus last month's release
Year | Cottonwood (last month) | Cheney (current) | |
---|---|---|---|
2011- release date | 13,905 | 16,886 | |
2010- 2011 | 51,722 | 53,173 | |
2009- 2010 | 50,405 | 50,449 | |
2008- 2009 | 45,864 | 45,830 | |
2007- 2008 | 33,265 | 38,757 | |
2006- 2007 | 3,484 | 35,358 | |
2005- 2006 | 0 | 32,447 | |
2004- 2005 | 0 | 30,018 | |
2003- 2004 | 0 | 16,886 | |
2002- 2003 | 0 | 3 | |
2001- 2002 | 0 | 0 |
Beta Disclaimer
We are providing this early access to obtain feedback from you, the research community. While we are actively working on validating the data loaded into the system with hospital and clinic technical staff, there may be problems with our translation of data from our source systems (HospitalEpicSource and ClinicIdxSource) into HERON. Please email us at heron-admin@kumc.edu if you discover information you believe may be erroneous. We are actively working on enhancing the types of data included. Stay tuned to our roadmap to track progress toward upcoming releases.
Various Issues Still Apply
Keep in mind the issues noted in the original HERON beta notice, including:
- date shifting, part of our DeIdentificationStrategy
- age searching (#158)
Problems/Defects/Issues Addressed in this Release
no major issues.
Outstanding Problems/Defects/Issues
No results
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:
- date shifting, part of our DeIdentificationStrategy
- age searching (#158)
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:
- date shifting, part of our DeIdentificationStrategy
- age searching (#158)
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:
- date shifting, part of our DeIdentificationStrategy
- age searching (#158)
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:
- Try REDCap now
- REDCap video training
- Register your project with the Biostatistics Department to go beyond just trying it out.
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.
Approaches to data integration for health care research: i2b2, SHRINE, SPARQL and OWL
A couple of us are off to Boston this week for the i2b2 Academic Users' Group First Annual Conference to present a poster and soak up all kinds of good stuff.
i2b2 is the basis of HERON, our health care research data repository, which stores clinical observations into a fairly traditional datamart. I've done database application development of various kinds for decades, but the scale and operational challenges are new to me. I'm particularly happy that the extract/transform/load (ETL) process for our last release ran for 37 hours, lights-out, loading 450 million clinical observations from various sources, primarily, a copy of Epic's Clarity store from the KU Hospital.
While i2b2 includes a modern Ajax web front-end, it makes no use of web-style linked data, let alone OWL or realist ontology, for medical terminology alignment, which is a big part of the challenge in making HERON an effective platform for research and for data integration beyond the KUMC enterprise.
While I'm taking a break from heads-down development mode for this conference, and while I'm in Boston, I hope to take time to look more closely at developments such as:
- Anzo Connect: Semantic Web ETL in 5 Minutes, a SemTech? conference presentation from the guys at Cambridge Semantics
- Stardog and Pellet 3: Semantics for the Enterprise, a June presentation from the guys at Clark & Parsia, with eye-opening performance numbers for query and reasoning with the size of data we deal with.
Our Oracle database on SAS drives handles simple user queries in a few seconds, but in some cases it takes a minute or two or fails altogether. After evaluating fusion-io's solid state storage, we ordered 4 fairly large units. We're still working through the operational details of setting it up, but we hope to see considerable performance improvements for both ETL and end-user queries.
I'm also interested to catch up on some W3C stuff: RDF/SQL mapping (no RIF?! darn.), and the Semantic Web Health Care and Life Sciences (HCLS) Interest Group. It should be interesting to compare SPARQL1.1 federated query with the corresponding i2b2 approach: SHRINE.
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
Completed tasks, Resolved Design Issues
For a more detailed account of the development of this release, see milestone:heron-update.
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_cd | encounter_num | patient_num | start_date | ... |
DEM|AGE:5 | 123123 | 321 | 2005-01-01 | ... |
Then the concept_cd
is related to a longer path in the concept_dimension
table:
concept_cd | concept_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_dimcode | c_name | ... |
\i2b2\Demographics\ | Demographics | ... |
\i2b2\Demographics\Age\ | Age | ... |
\i2b2\Demographics\Age\0-10\ | Ages 0-10 | ... |
\i2b2\Demographics\Age\0-10\5 | Age 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
- leave out stats regarding fewer than 10 patients (per HIPAA regulations, as part of our DeIdentificationStrategy)
- 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.