The OUHSC Clinical Research Data Warehouse contains data from multiple EHR and related data systems in support of clinical research. The CRDW team provides project-specific datasets to researchers based on project specifications (inclusion criteria, date ranges, etc.).
CRDW EHR data sources include:
- Epic
- Legacy Centricity/athenaFlow
- Legacy Meditech
- Legacy Billing and Claims
For a more detailed description of the process or to submit a request, please visit the CRDW webpage.
Reporting Workbench is a tool within Epic allowing users to perform custom, real-time queries on patient data, and patients identified in these queries may be contacted (one at a time) via MyChart. Workbench Reports display basic patient contact information and links directly to charts so they may be quickly reviewed to manage tasks or further review the chart for eligibility and identify exclusion criteria.
SlicerDicer is an intuitive, robust point-and-click method of rapidly identifying patients meeting study criteria. Data can be viewed visually in graphic formats, and patient lists can be viewed directly for chart review and patient contact (if IRB is approved, and use of SlicerDicer/self-service EHR extraction is specified in the IRB application and protocol). Using the SlicerDicer tool in Epic, users may select criteria (e.g., diagnoses, age ranges, lab results, etc.) and perform some basic analyses on the populations selected, such as counts, percentages, demographic breakdowns, etc. These analyses can be viewed in aggregate by any Epic user (cells < 10 are censored). This can support Feasibility evaluation without exposing PHI.
We encourage researchers who plan to use SlicerDicer for research to attend training to obtain proficiency in using the tool. Please email EpicTraining@ouhealth.com to request training. Additionally, we also encourage newer users of SlicerDicer to request an Epic Research Analyst to review your SlicerDicer report to ensure accuracy. For this support, please submit an OU Health IT ticket routed to Epic Research.
BPAs are a decision support tool used to support better patient outcomes, and they can be tailored to a specific audience. When a patient meeting the BPA criteria presents for an encounter, the provider will be presented with a summary of the study and why the patient qualifies. If a provider indicates patient interest, this will send inbox alert to a research coordinator to let them know that the patient is eligible for the study and interested. This is useful for identifying research subjects eligible for a study, and allowing a provider who already has a relationship with the patient to make the initial contact and request permission for a member of the study team to contact them about the study.
Users should submit a ServiceNow request routed to Epic Research. An Epic Research Analyst will contact you to discuss study requirements. Once the BPA is activated, providers/research coordinators will automatically be notified of eligible patients, and authorized individuals will be able to access reports of BPAs, similarly to Workbench Reports.
Data from 2023-06-02 onward are entered in Epic for OU Health services. Some parts of legacy EHR systems, including encounters from the 3 years prior to Epic Go-Live are available to view within the patient chart. Other legacy EHR data are still available where needed (i.e., for research chart abstraction) are available.
athenaFlow/Centricity and CribNotes OU Health EHR data have been migrated to the LK Oasis (ELLKAY data lake). These data are accessible within Epic by clicking 'Historical Data' on the top right (next to 'Need Help'). All data from patient records are accessible using legacy patient MRNs or patient name and DOB combinations.
Meditech and other legacy sources are still available to access directly as Read Only. If you need access, or if you need to restore access, please submit a ServiceNow request to OU Health for access to these systems.
If you need a data extract pulled (a custom dataset, as opposed to access for manual chart review), you may benefit from working with the Clinical Research Data Warehouse team.
The REDCap on FHIR interface connects Epic to REDCap and allows for transfer of EHR data to REDCap records in a convenient structured format.
Use of REDCap on FHIR must be clearly documented in the project's IRB protocol, and a complete list of requested fields should be uploaded to application attachments. Further rules and best practices for use of REDCap on FHIR are pending approval.
For more details, please visit our REDCap on FHIR knowledge base article.
Coming soon to OUHSC...
Chart Abstraction Made Easy
EMERSE (Electronic Medical Record Search Engine) is software that helps researchers accurately find and extract important patient details like diagnoses, medications, procedures, and complications from clinical notes. EMERSE is easy for non-technical people to use and enables health research that was previously inefficient or nearly impossible. The functionality enables users to quickly and easily search notes in Epic (similar to a Google search) and retrieve data (terms are highlighted within the notes for rapid concept identification) that are not otherwise available in structured fields, such as ICD codes and lab values. EMERSE has the potential to save study personnel hours on chart review for data collection.
EMERSE cohorts can be created in Epic and exported to REDCap via the REDCap on FHIR interface.
EMERSE use cases:
- Feasibility study/Preparatory to research – estimate counts of patients meeting eligibility criteria
- Rare diseases – quickly find mentions of rare diseases, especially helpful when diagnosis codes are too broad or used incorrectly.
- Eligibility determination – Quickly evaluate complicated eligibility criteria to check free text documents for mentions of specific criteria
- Data abstraction – For research subjects, treatment courses, side effects, etc. can be abstracted with ease
- Quality improvement
- Risk Management – rapidly identify patients with device/implant recalls
- Clinical chart review as a part of patient care (e.g., searching chart to locate a medication taken multiple years ago for a specific condition)
For more details about EMERSE, please visit https://project-emerse.org/
For the EMERSE user guide, please visit https://project-emerse.org/documentation/user_guide.html