Skip to content

RPPR Demographic Tables

What this page tells you

Each year, build the NIH RPPR demographic tables (race, ethnicity, gender, age) for the 3T and 7T studies from the REDCap 'Grants' reports: edit the date filters to the past year, update the description, save, and export CSV. Includes a video tutorial and example CSVs.

Every year, we have to submit a recruitment report to the NIH for the 7T and 3T studies covered by Kate's R01 grant. We need to submit a demographics table for the subjects we enrolled which includes: Race, Ethnicity, Gender, and Age. We use our REDCap reports to generate these tables, which are then exported as a csv file and uploaded to the NIH system.

Below is a video tutorial on how to make these demographic tables from a REDCap Report. The video uses the 7T study as an example but the process and formatting for the tables is the same for all studies.

Video Tutorial:

🎬 Video: RPPR_Demographic_Table_Video_Tutorial.mov — kept in Dropbox › NeuroBridge › wiki-media as 8447-rppr-demographic-table-video-tutorial.mov

We use reports in REDCap to generate the numbers for the RPPR for both 3T and 7T. The reports can be found under "Grants" in REDCap.

Create Report:

  1. 7T Table of patients enrolled in the past year from December XX of previous year - December XX of current year

    1. To change this to the current year, open the Report and go into Edit Report.
    2. Scroll to Step 3, and change the date in Filter 2 to > = 12/XX of the previous year and change the date in Filter 3 to < = 12/XX of the current year
    3. Example from 2022 Submission: REDCap report filter setup for 7T consent date range; no records shown

    4. Also, in Description, copy the previous year demographics and add in the current year and number of patients enrolled. Below is an example from what was submitted in 2024 (for the 2023 RPPR):
      RPPR 7T aggregate enrollment counts by year

    5. Save Report

    6. 3T Table of patients enrolled in the past year from 12/XX of previous year - 12/XX of current year
    7. To change this to the current year, open the Report and go into Edit Report.
    8. Scroll to Step 3, and change the date in Filter 2 to > = 12/16 of the previous year and change the date in Filter 3 to < = 12/16 of the current year
    9. Example from 2022 Submission: REDCap report filter setup for 3T consent date range; no records shown
    10. Also, in Description copy the previous year demographics and add in the current year and number of patients enrolled. Below is an example from what was submitted in 2024 (for the 2023 RPPR: RPPR 3T aggregate enrollment counts by year
    11. Save Report

2023 RPPR csv files example

📄 2023_3T_RPPR.csv

📄 2023_7T_RPPR.csv