Independent and not affiliated with the FDA, MHRA, ISPE, PDA, or any agency. Get the appgoutham@madhadi.com
madhadi.comData Integrity & GxP Quality
Browse all topics → Articles Templates & Procedures Learning paths GlossaryScenariosToolsRegulatory ReferencesLearning PathsTopics About Start here
Log Plug-and-play starting point Clinical & GCP

Log: Protocol Deviation Trending Register

A plug-and-play structured register for clinical protocol deviations built so the data can actually be trended by site, category, and rate, with the metrics, denominators, review cadence, and a filled specimen that turns a pile of events into a signal.

Document type: Log

Read and copy the template below into your own quality system. It is a generic starting point for your own internal use, provided as is, with no warranty; see the Terms and License. Adopting it does not by itself create compliance.

This is a ready-to-use register for capturing clinical protocol deviations in a structured, queryable form so they can be trended. Free-text deviation logs cannot be trended, and untrended deviations are a finding by themselves. Keep one per study. Replace every <<FILL: ...>> placeholder, and maintain it in a queryable system rather than prose. A field guide, a metrics section, and a filled specimen follow.

Why structure matters

A single missed visit is an event; the same missed visit at one site fifteen times is a broken process. You can only see the second if the data is structured: category, site, subject, dates, classification as discrete fields, not sentences. This register defines those fields and the metrics computed from them.

Part 1: Deviation register (one row per deviation)

FieldFormatRequiredNotes
Deviation IDTextYesLinks to the deviation record
SiteCodeYesFor per-site rates
Subject IDID onlyYesNo names
CategoryControlled listYese.g. inclusion/exclusion, out-of-window, missed assessment, IP/dosing, consent
ClassificationMinor / ImportantYesDrives the important-rate metric
Serious breach?Y/NYesEU determination
Event date / discovery dateDate / dateYesFor time-to-detect
Report dateDateConditionalFor time-to-report
Close dateDateYes (to close)For time-to-close
Root cause codeControlled listYesProcess / training / protocol / supply / subject
CAPA referenceTextConditionalWhere raised

Register table

Deviation IDSiteSubject IDCategoryClassSerious?Event / discoveryReportCloseRoot causeCAPA
<<FILL>><<FILL>><<FILL>><<FILL>><<FILL>><<FILL>><<FILL>><<FILL>><<FILL>><<FILL>><<FILL>>

Compute on a defined cadence (commonly monthly at study level, per-visit at site level). Use the right denominator so a high-enrolling site is not unfairly flagged.

MetricDefinitionThreshold / action
Deviation rate per siteDeviations / subjects (or / visits) per site<<FILL: e.g. > 1.5x study mean = review>>
Important-deviation rateImportant deviations / subjects, over time<<FILL: rising trend = escalate>>
Rate by categoryDeviations per category<<FILL: top category = candidate amendment>>
Repeated identical deviationsSame category, same site, count<<FILL: >= N = amendment signal>>
Time-to-reportReport date minus discovery date<<FILL: > IRB clock = process issue>>
Time-to-closeClose date minus discovery date<<FILL: target>>
Self-identification shareSite-found / total at site<<FILL: low = site awareness issue>>

Part 3: Review record

FieldEntry
Review period<<FILL>>
Outliers identified<<FILL>>
Decisions (monitoring / retraining / amendment / CAPA)<<FILL>>
Reviewer (name, date)<<FILL>>

Acceptance criteria

  • Deviation data is captured in discrete, queryable fields, not free text.
  • Metrics are computed on the defined cadence with the correct denominator.
  • Site and category outliers are identified against a defined threshold.
  • At least some reviews demonstrably led to action; a register where every review concludes “no action” is not a real review.

References

ICH E6 GCP (risk-based quality management; sponsor oversight of deviation patterns). FDA guidance on a risk-based approach to monitoring of clinical investigations. ICH E3 (important protocol deviations in the CSR).

Confirm current versions before issue.


Filled specimen

A trending review that found a real signal, illustrative.

Register (excerpt)

Deviation IDSiteSubject IDCategoryClassSerious?Event / discoveryReportCloseRoot causeCAPA
PD-014-03114S-014-007Out-of-window primary drawImportantN03 Jun / 17 Jun23 Jun30 JunProcess (no window check)PD-CAPA-022
PD-014-03314S-014-011Out-of-window primary drawImportantN10 Jun / 17 Jun23 Jun30 JunProcessPD-CAPA-022
PD-014-03514S-014-014Out-of-window primary drawImportantN14 Jun / 17 Jun23 Jun30 JunProcessPD-CAPA-022
PD-009-01809S-009-004Out-of-window primary drawImportantN12 Jun / 20 Jun27 Jun04 JulProcessPD-CAPA-022

Metric and decision

MetricValueDecision
Repeated identical deviation (out-of-window primary draw)4 across 2 sites in one month (3 at site 14, 1 at site 9)Not unique to one site, points to the scheduling tool, not just site 14
DecisionStudy-wide preventive actionAdd an automated out-of-window alert to the visit-scheduling tool; verify the category rate drops to zero over two cycles

Trending is what turned three separate “important” deviations into one systemic finding and one study-wide fix, instead of three site retrainings that would have left the same broken tool running everywhere. That is the difference between logging deviations and managing them.

Common inspection findings this register prevents

  • Free-text deviation logs that cannot be queried, so trending never happens.
  • A systemic cause fixed at one site while it recurs at the others.
  • Repeated identical deviations that should have triggered a protocol amendment.
  • Trend reviews that always conclude “no action,” signalling the review is theater.

How to adapt this register

  1. Set your controlled category and root-cause lists so the fields stay queryable.
  2. Calibrate the thresholds to your therapeutic area and enrollment; rare-disease trials carry different baselines.
  3. Feed the outputs into the monitoring plan so a flagged site drives targeted monitoring.
Use madhadi.com as an app Full screen, works offline, one tap from your home screen.