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
Checklist Plug-and-play starting point Clinical & GCP

Checklist: SAP Prespecification and Database-Lock Readiness

A plug-and-play checklist protecting the prespecification firewall in a clinical trial: SAP finalization and version control before unblinding, estimand and analysis-population definitions, multiplicity and missing-data alignment, unblinding controls, and database-lock readiness, with a filled specimen.

Document type: Checklist

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 checklist to protect prespecification, the firewall that stops data-driven analysis choices from inflating false-positive rates. It confirms the statistical analysis plan (SAP) was finalized and version-controlled before unblinding, that the estimand and analysis rules are unambiguous, and that database lock and unblinding are controlled, evidenced events. Replace every <<FILL: ...>> placeholder, mark each item Pass / Fail / NA, and sign it. A filled specimen follows. This is educational reference content, not regulatory advice.

Why this checklist earns its place

Prespecification is an inspectable fact: the SAP version history and its timing relative to unblinding are exactly what an inspector examines. A SAP finalized after database lock or after unblinding, even if benign, removes the firewall and invites the question of whether choices were data-driven. See ICH E8(R1) and E9 trial design and statistics.

FieldEntry
Checklist number<<FILL: CL-ID>>
Protocol / SAP reference<<FILL>>
MilestoneDatabase lock readiness / Unblinding readiness (<<FILL>>)
Date<<FILL>>

Section A: SAP prespecification

#ItemPass / Fail / NAEvidence
A1SAP finalized and approved before unblinding<<FILL: SAP version, approval date>>
A2SAP under formal version control; version history retained
A3Primary estimand fully specified (five attributes) and in the SAP<<FILL: link to estimand spec>>
A4ICE handling strategy defined per anticipated event
A5Analysis populations (FAS, PPS, Safety) defined with unambiguous classification rules
A6Primary estimator and missing-data method aligned to the ICE strategy
A7Multiplicity strategy prespecified (hierarchy / gatekeeping / alpha allocation)
A8Sensitivity analyses for the primary estimand prespecified

Section B: Unblinding and lock controls

#ItemPass / Fail / NAEvidence
B1Unblinding timestamp is a controlled, evidenced event
B2No SAP change after unblinding without a flagged, justified, documented exception
B3Patient classification into analysis populations finalized before unblinding, per prespecified rule (no post-unblinding reclassification)
B4DMC access to unblinded data governed by a charter that does not compromise the prespecified analysis
B5Database lock criteria met (queries resolved, reconciliations complete, CtQ data complete)
B6Audit trail on SAP and EDC supports the prespecification timeline

Section C: Data readiness

#ItemPass / Fail / NAEvidence
C1Estimand-critical (CtQ) data complete to the prespecified tolerance<<FILL: missing rate vs limit>>
C2Post-ICE data collected where the estimand requires it (casebook did not close on discontinuation)
C3Key reconciliations complete (SAE, external lab, IRT)

Sign-off

RoleNameSignatureDate
Biostatistician<<FILL>>
Data management<<FILL>>
Clinical QA<<FILL>>

Filled specimen

Example at database-lock readiness for a phase 3 trial.

#ItemResultEvidence
A1SAP finalized before unblindingPassSAP v3.0 approved 12-May; unblinding scheduled post-lock
A3Estimand fully specifiedPassPrimary estimand, five attributes, SAP section 4
A6Estimator aligned to ICE strategyPassMMRM, MAR consistent with treatment policy
A7Multiplicity prespecifiedPassFixed hierarchy, SAP section 7
B3No post-unblinding reclassificationPassPopulation classification locked in a dated pre-unblinding memo
C1CtQ data complete to tolerancePassWeek-24 primary endpoint missing rate 5.1%, below the 8% limit
C2Post-ICE data collectedPass96% of discontinued patients have a week-24 measurement

The two rows that carry the most weight in an inspection are A1 and C2: the SAP was locked before unblinding (the firewall held), and the post-discontinuation data the treatment-policy estimand demands were actually collected (the estimand was not quietly broken). Both are objective, dated facts.

Common inspection findings this checklist prevents

  • SAP finalized after database lock or after unblinding, removing the prespecification firewall.
  • Patients reclassified between analysis populations after unblinding, with no prespecified rule.
  • A missing-data method chosen independently of the ICE strategy.
  • Post-ICE data not collected, so the treatment-policy estimand cannot be estimated as defined.
  • No evidence trail linking the SAP version to the unblinding timestamp.

How to adapt this checklist

  1. Run Section A before you approach unblinding; A1 and A2 are the firewall.
  2. Treat the unblinding timestamp as a controlled event and evidence it (B1).
  3. Check estimand-critical data completeness against the numeric tolerance from your CtQ register (C1).
  4. Keep the signed checklist with the SAP version history and the database-lock package.
Use madhadi.com as an app Full screen, works offline, one tap from your home screen.