Pareto — Clinical Trial Data Queries
Monitor-raised data queries by case-report-form field for a phase III study against the sponsor's previous one, computing that 5 of 13 fields generate 81.1% of 3,044 queries and that ECG capture entered the vital few this study.
Make it your own.
title "Data queries by CRF field — study CV-311, interim lock"
unit queries
period "CV-311 interim lock"
compare "CV-208 final lock"
threshold 80%
other-below 2%
note "18,430 subject-visits across 74 sites — one query every 6.1 visits"
# quoting a field called "Vital signs…" keeps it a data row, not a directive
"Adverse event onset date" 964 641
"Concomitant med dose" 622 708
"Vital signs out of range" 418 372
"Lab unit mismatch" 274 455
"ECG interval missing" 190 118
"Visit date window" 168 141
"Dosing diary gap" 150 84
"Informed consent version" 140 58
"Randomisation mismatch" 43 36
"Protocol deviation code" 31 47
"Pregnancy test missing" 22 19
"Sample chain of custody" 14 25
"Site signature missing" 8 12