1.2 Profile Table

If requested in the Query Request Package (QRP) using the [QRP Parameters] input file, users can output a “profile” table in the QRP Reporting Tool to show the number of patients and episodes that qualify for combinations of characteristics in the user-defined evaluation window. This table is available for all descriptive analyses, including Background Rates (Type 1), Exposures and Follow-up Time (Type 2), Medical Product Use in Pregnancy (Type 4), Medical Product Utilization (Type 5), and Medical Product Switching Pattern (Type 6) analyses. Using the appropriate parameter in Baseline File, users can specify which patient characteristics to include in the profile table.

1.2.1 Output

Users are required to specify which cohorts, analytical groups, or mother-infant linkage groups to output in the Profile Table using the Baseline File input file. For Type 1, Type 2, and Type 5 analyses, one table is output per cohort group. For Type 6 analyses, one table is output for each switch evaluation step such that up to three tables can be output per analysis group.

In Type 4 analyses, users can specify whether the non-pregnant cohort created in QRP should be included in the Profile Table by setting the appropriate parameter in baseline File. If specified, separate tables are output for the pregnant and non-pregnant comparator cohorts; otherwise a table is only output for the pregnant cohort. For mother-infant linkage analyses, one table is output per unique exposure-reference pair, with separate columns for the exposure and reference groups. If there are multiple exposure-reference pairs defined in the same mother-infant linkage group, they are output in separate tables.

Rows in the Profile Table correspond to each unique combination of user-defined characteristics. For example, in a study with three defined patient characteristics, the following rows are output:

  • Characteristic A only
  • Characteristic B only
  • Characteristic C only
  • Characteristic A and Characteristic B
  • Characteristic A and Characteristic C
  • Characteristic B and Characteristic C
  • All characteristics present
  • No characteristics present

For each row, the number and percent of patients, as well as the number and percent of episodes, with that unique code combination is displayed.1


  1. Please Note: If a combination is not present in the data—i.e., if there are zero counts for a combination—a row will not be returned in the Profile table for that combination.↩︎