EMR Data Retrieval for Research
UC Davis researchers can acquire patient data for research from the electronic medical record (EMR). The source and type of data needed dictate the process to access the data. It is necessary to understand the types of data available, sources of data, and process to gain access to data.
After required training, researchers may request access to Cohort Discovery, a self-service tool that can be used to conduct queries based on database fields in a repository of de-identified patient data. The output of this tool is a numeric count of patients that match the criteria identified in the query, sorted by site (as appropriate). The numeric counts can be used to assess the feasibility of a study or hypotheses by identifying whether there are sufficient prospective subjects based upon the criteria input during the query process. Researchers subsequently requiring identified data from the EMR must gain the regulatory approval required for the database that best serves their needs (as described below). In addition, researchers must create a request in the UC Davis Health IT Service Hub (ServiceNow) by following these instructions.
Cohort Discovery is an informatics tool that enables researchers to query a repository of patient information from UC Davis Health patients gathered from multiple sources, including electronic medical records, lab results, and demographic data. UC Davis researchers who complete the Cohort Discovery introductory training session (course code: DAHS-ITR-50081) will receive a Login ID and password for Cohort Discovery after completing and submitting the Cohort Discovery Confidentiality Agreement (PDF) to firstname.lastname@example.org.
If you have questions or need assistance with Cohort Discovery, send an email to email@example.com.
Data Explorer - Retired
With over six years of service, thousands of queries, and a dataset of over 14 million patients, Data Explorer (also known as University of California Research eXchange, or UC ReX) was taken offline on July 1st, 2019. This step was taken in preparation for the adoption of a new national data sharing platform, the ACT (Accrual to Clinical Trials) Network, which will be going live for UC Davis investigators on July 31st.
Please contact firstname.lastname@example.org if you wish to be notified by email when ACT goes live.
ACT (Accrual to Clinical Trials) Network - Coming Soon
The UC Davis Clinical and Translational Science Center has partnered with the ACT Network to expand the reach of its real-time cohort exploration and discovery tool. ACT is funded by the NIH through the National Center for Advancing Translational Sciences (NCATS) and was developed by members of the Clinical and Translational Science Awards (CTSA) Program consortium. ACT offers open-access to a national network of leading academic medical research centers and generates aggregate patient count data from an investigator's real-time, iterative searches. The ACT Network contains over 125 million patient records, and by the end of 2019 will include ~90% of the CTSA consortium. The extracted dataset will indicate the number of patients who meet the established criteria at each medical center. ACT will be available to UC investigators on July 31, 2019. At that time, we will add a link to the UC Davis ACT Network website.
If you have questions or need assistance with ACT, send an email to email@example.com.
Data Request Process
De-identified data contains no PHI or HIPAA identifiers and be used for hypothesis testing and sample size determination. Researchers can access de-identified data through self-service use of UC Davis Cohort Discovery (UC Davis Health EMR data).
Figure 1. How to access de-identified data from the UC Davis EMR.
Identified data contains one or more HIPAA/PHI identifiers and requires regulatory approval to access it. The following elements are required to access identified data from UC medical records:
- Regulatory approval is required for access to all identified datasets.
- To develop or refine a research question before you have a protocol requires Preparatory to Research Application approval by the UC Davis Health Compliance Office. Data accessed for this purpose may NOT be used for study recruitment or for publication. The investigator serves as an “honest broker” for the data accessed (see Figure 2), OR
- Detailed data review or a cohort for prospective recruitment once you have a protocol requires UC Davis IRB approval. (UC Davis Health EMR data). The CTSC Informatics team serves as the “honest broker” for the data delivered (see Figure 3).
- Assistance from the CTSC Biomedical Informatics staff is required for access to all identified datasets.
Figure 2. How to access identified data from the UC Davis EMR without a protocol.
Figure 3. How to access identified data from the UC Davis Health or UC Health EMR with a protocol.