Medical Query Risk Report

This process screens medical query terms by performing Cochran-Mantel-Haenszel (CMH) tests on all 2 x 2 tables constructed from event incidence and treatment arm. Output is a two-sided plot with a dot plot showing percent occurrence and forest plot showing risk measurement. Additionally there are 4 tables for narrow queries with dictionary-derived terms , broad queries with dictionary-derived terms, broad and narrow queries, and queries by System Organ Class (SOC).

FDA Medical Query terms (FMQs) are similar to SMQs and are the default version used in JMP Clinical. They are being promulgated by the FDA to further consolidate and standardize descriptions of medical conditions. Excel files containing FMQs can be downloaded from here. Downloaded files should be saved to $DOCUMENTS\FMQ. When there are multiple versions of the FMQs in the specified folder, you can use the Version of FDA Medical Query Files/Version of Standardized Medical Query Files widget on the Set Study Preferences window to specify which version of the FMQs to use.

Excel files containing FMQs can be downloaded from https://downloads.regulations.gov/FDA-2022-N-1961-0001/attachment_1.xlsm.

Report Results Description

Running Medical Query Risk Report for the Nicardipine study using FDA Medical Query files, the planned treatment ARM, and narrow search queries, generates the Report shown below.

The Report contains the following elements:

Plots

There are four plots shown here: a group of two plots for broad scope queries and a group of two plots for narrow scope queries. Medical queries are shown on the y axis. The dot plot on the left of each group shows the percentile occurrence of subjects in each arm exhibiting the queries. The Forest plot on the right of each group shows the risk difference for subjects to exhibit events covered by each query.

Forest Plots display relative strength of treatment effects as horizontal lines representing the 95% confidence interval of the effect observed in that trial. The confidence interval is normally for the relative likelihood of a given nominal-level outcome for the intervention group compared to the control group. In this example, the forest plot shown below, represents the risk difference for developing the specified event relative to exposure to Nicardipine.

Tables

Four tables were generated for this example.

Narrow Medical Queries and Terms

This table lists each narrow query with its associated dictionary-derived terms, the number (percentile) of subjects exhibiting the event, and the risk difference between the treatment arms.

Broad Medical Queries and Terms

This table lists each broad query with its associated dictionary-derived terms, the number (percentile) of subjects exhibiting the event, and the risk difference between the treatment arms.

Medical Queries

This table summarizes each query without the associated dictionary-derived terms for the number (percentile) of subjects exhibiting the event, and the risk difference between the treatment arms.

System Organ Class

This table lists the number (percentile) of subjects exhibiting each SOC and the risk difference between the treatment arms.

Note: When SMQs are selected, SOCs are thos contained in the AEBODSYS columnfrom either AE or ADAE . Alternatively, when FMQs are selected, the SOCs are those matched to the FMQ in the FMQ References tab of the Excel file.

You can click on the subjects displaying specific events described by the medical queries to bring up the Drill-downs tab that provides more details about the specific subjects and medical query along with several additional tables with more details.

Options

Data

Medical Query Type

This widget enables you to specify whether you are using the FDA medical queries or standard medical queries. FDA medical queries are used by default. Refer to Medical Query Type for more information.

Event Type

Analysis can consider all events or only those that emerge at specific times before, during, or after the trial period. For example, selecting On treatment events as the Event Type includes only those events that occur on or after the first dose of study drug and at or before the last dose of drug (+ the offset for end of dosing).

Ignore available treatment emergent flags

If you choose to Ignore available treatment emergent flags, the analysis includes all adverse events that occur on or after day 1 of the study when the event type is Treatment emergent events.

Risk Measurement

Use the Risk Measurement, option to specify the measure you want to use for defining risk.

Display Risk Difference as:

Use this widget to specify whether to display the risk difference values as either percentages or proportions.

Sort Risk Report plot and tables by:

Use the Sort Risk Report plot and tables by: widget to specify how the rows in the Risk Report plot and tables are to be sorted.

Treatment Value for Sort by

Use this widget to specify the treatment value to sort the plots and tables by. This is especially useful when there are multiple treatment regimes. Refer to Treatment Value for Sort by for more information.

Additional Filters - Adverse Events

This filter lets you restrict your analysis to only those subjects that meet specific criteria at the AE domain level. See Adverse Events for more information.

Report Data Filters

These filters enable you to subset and view subjects based on demographic characteristics and other criteria. Refer to Data Filter for more information.

General and Drill Down Buttons

Action buttons, provide you with an easy way to drill down into your data. The following action buttons are generated by this report:

Click to rerun the report using default settings.

General and Drill Down Buttons

Action buttons, provide you with an easy way to drill down into your data. The following action buttons are generated by this report:

Click to reset all report options to default settings.
Click to view the associated data tables. Refer to Show Tables/View Data for more information.
Click to generate a standardized pdf- or rtf-formatted report containing the plots and charts of selected sections.
Click to generate a JMP Live report. Refer to Create Live Report for more information.
Click to take notes, and store them in a central location. Refer to Add Notes for more information.
Click to read user-generated notes. Refer to View Notes for more information.

Default Settings

Refer to Set Study Preferences for default Subject Level settings.

Methodology

To run this report, at least two treatment levels are needed and the treatment control level preference must not be set to None.

Patients are assessed for each medical query they experience and Percent Occurrence and Risk Difference are calculated for each query by treatment group. Percent Occurrence is simply the percentage of patients in a treatment group who experience the query at least once during the trial period. Risk difference is calculated by subtracting the number of patients exhibiting the query in the control group from the number of patients exhibiting the query in the treatment arm. Relative Risk or Odds Ratios may also be calculated.