Menu-Driven Queries (MDQs)
Menu-Driven Queries (MDQs) utilize a simple point-and-click interface to add terms to the request criteria that are joined through logical operations (and/or), associations, and then grouped according to the chosen stratification(s). A major benefit is that users do not need programming expertise to create and execute MDQs. MDQs output a count of patients based on the criteria entered and currently only execute against data stored within the PCORnet Common Data Model.
MDQ Deep Dive Presentation
Below is a presentation that is a deeper dive into MDQs and how they work within a PopMedNet distributed network. The tool translates the MDQ into SQL syntax that is specific to multiple relational database management systems (RDBMS). One query can be sent and executed against data stored in Oracle, SQL Server, or Postgres.
The Terms and Stratifications Available
The following document lists the terms and stratifications available for creating the MDQ criteria as of May 2020.
ADAPTABLE Supplement Project
The ADAPTABLE trial is the first major randomized comparative effectiveness trial to be conducted by the National Patient-Centered Clinical Research Network (PCORnet). ADAPTABLE encompasses several key features, including enrollment of 15,000 patients across 40 health care systems and health plans; a web portal for collecting patient-reported outcomes (PRO) data (e.g. medications and experiences); and reliance on existing EHR (Electronic Health Record) data for baseline characteristics and outcomes. Longitudinal data on patient-reported information, not readily available in the EHR, is collected and provides the opportunity to evaluate the level of concordance between PRO and EHR data. The ADAPTABLE Supplement project was a unique opportunity to develop, pilot and evaluate methods to compare PRO data and EHR data stored in the PCORnet Common Data Model (CDM).
In collaboration with Duke University and Vanderbilt University Medical Center, we extended MDQs to enable investigators to quickly and efficiently compare patient-reported and clinical data. Enhancements to MDQs included expanding the querying capability to the Trial and Patient Reported Outcome tables within the PCORnet CDM, as well as developing temporal functionality that enables us to query for encounters that are within a specified time window of a patient-reported hospitalization date. All features developed for the ADAPTABLE Supplement study have been designed with the ability to re-use the tool for future studies.
To learn more about the functionality developed for ADAPTABLE in particular, please see the ADAPTABLE User Guide:
