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 CSV / CSA

Validation Execution Data Integrity Checklist

A tester-facing checklist for data integrity during validation execution: what to confirm before you start, the recording rules to hold during execution, and the reconciliation and audit trail checks to complete after, with Pass/Fail/NA, references, and signoff.

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. Replace every <<FILL: ...>> placeholder with your own specifics, set your document numbers and dates, and route it through your normal document control, review, and approval. A worked filled specimen follows the template so you can see how a completed version reads. Verify each cited regulation against the current published source before you rely on it, and treat this as an educational reference to adapt rather than as legal or regulatory advice.

This checklist is written for the person executing the protocol, not for the person auditing it afterwards. It is short enough to complete honestly and specific enough to be worth completing. The governing process for anything that fails a check sits in SOP: Validation Test Incident Management.

How to use this checklist

  • Section A is completed once, before the first test step of an execution session or campaign. If any item fails, execution does not start until it is resolved.
  • Section B is the standing rule set held throughout execution. Complete it at the end of each execution session, or at the end of each protocol, whichever your procedure specifies.
  • Section C is completed once, after execution is finished and before the summary report is drafted.
  • Mark every item Pass, Fail, or NA. NA needs a reason in the comment column. A blank is not an answer.
  • Any Fail is raised as a test incident under your incident management procedure before execution continues.
FieldEntry
Checklist number and version<<FILL: CL-ID and version>>
Protocol number, title, version<<FILL>>
Validation phaseDQ / IQ / OQ / PQ / UAT / method validation / process validation / cleaning validation
System, equipment, method, or process<<FILL>>
Execution session or campaign reference<<FILL>>
Executor (name, role, unique user ID)<<FILL>>
Date range covered<<FILL>>

Section A: Before execution

Complete before the first test step. Every item is a precondition, not an aspiration.

#CheckWhat good looks likeReferencePass / Fail / NAComment
A1The protocol you are executing is the approved, current, effective versionYou can name the version and see its approval signatures. The copy in your hand matches the controlled master<<FILL: protocol no. and version>>
A2The copy you are executing is a controlled issueControlled copy number recorded, or the electronic record opened from the controlled system, not a local file or an emailed PDF<<FILL: copy no.>>
A3Any protocol addendum or correction in force is in your hands before you startAddenda are attached and approved. You are not executing a step someone told you verbally has changed<<FILL: addendum ref>>
A4The environment or instance is confirmed and recordedEnvironment name captured from the system itself, not from the project plan<<FILL: environment>>
A5The build, version, or firmware is confirmed and recorded with evidenceVersion screen captured, or deployment record referenced. Exact version string, not “latest”<<FILL: build>>
A6The environment matches the intended qualified target, or every difference is documented and justifiedDifferences between the test environment and the target production environment are listed and their effect on the conclusion is stated<<FILL>>
A7The configuration set, recipe, or method under test is identified and under configuration controlConfiguration baseline or export reference recorded, so what you tested can be identified later<<FILL>>
A8Test data is controlled, identified, and fit for the testTest data set has an identifier and a controlled state. You know which values exercise boundaries and error paths<<FILL: test data set>>
A9Test data does not contain real patient, subject, or donor identifiers unless approved and controlledWhere real data is used, its use is approved and its handling meets your privacy and data protection controls<<FILL>>
A10Your user account, role, and permissions for the test are correct and attributable to you personallyYou are not executing under a shared, generic, or borrowed account. Nobody else is using your credentials<<FILL: user ID and role>>
A11The system clock and time zone are confirmed correct and are not user-alterableTime source verified. You know what time zone the timestamps you are about to generate will carry<<FILL>>
A12The audit trail is enabled, complete, and cannot be disabled by an ordinary user for the execution periodConfirmed at the system, and the confirmation is evidenced<<FILL>>
A13The evidence capture method is agreed before the first stepYou know what counts as evidence for each step: screenshot, printout, log extract, chart, photograph, and what metadata each must carry<<FILL>>
A14Evidence naming, numbering, and storage location are definedAn evidence numbering scheme exists so an attachment can be tied back to a step months later<<FILL>>
A15The test incident log is open, accessible, and ready to receive an entryBlank log initialised with the next incident number known. Not a blank page you will create when something goes wrong<<FILL: log ref>>
A16The escalation criteria are approved and you have read themYou know, before you see a failure, which failures become deviations and which do not<<FILL: plan section>>
A17You are trained and qualified on the protocol, the system, and the recording rulesTraining record current, including on the good documentation practice convention used for corrections<<FILL: training ref>>
A18Prerequisites for the test cases you will run are met and evidencedCalibration current, IQ complete before OQ starts, interfaces available, materials available<<FILL>>
A19You know who to call and how fast when something failsValidation lead and QA contact points known, and the expected notification timing<<FILL>>

Gate A. Execution does not begin with an open Fail in section A. If a Fail is discovered after execution has started, execution stops, the item is raised as an incident, and everything executed under the failed condition is assessed for validity.


Section B: During execution

These are the standing rules. Confirm each at the end of the session or protocol, and be honest, because the audit trail records the same facts whether or not you do.

#CheckWhat good looks likeReferencePass / Fail / NAComment
B1Every result was recorded at the time it was observedEntries made as the step ran, not reconstructed from notes at the end of the day<<FILL>>
B2No result was recorded on scrap paper, a whiteboard, a phone note, or a personal file and transcribed laterThe controlled record is the original record. If a working note existed, it is retained and attached<<FILL>>
B3Every failing result was recorded before any retry, reload, refresh, restart, or re-entryThe first observation is on the record. No step was attempted a second time before the first attempt was written down<<FILL>>
B4Every failed step remains marked FAIL with an incident referenceNo failed step was erased, blanked, obliterated, overwritten, or changed to PASS<<FILL>>
B5No expected result was edited to match an observed actual resultWhere an expected result was genuinely wrong, it was corrected through an approved, justified protocol correction and the step was re-executed against the corrected expectation<<FILL>>
B6No acceptance criterion was relaxed, reinterpreted, or paraphrased during executionThe criterion you tested against is the criterion the protocol states<<FILL>>
B7There are no blank required fields on any execution pageEvery required field carries an entry or a documented NA with a reason<<FILL>>
B8There are no erased, obliterated, correction-fluid, or over-written entriesPaper corrections use a single line through, initial, date, and reason, with the original entry still legible<<FILL>>
B9Every correction carries a reason”Transcription error”, “wrong step number”, “value corrected per attached evidence”. Not an unexplained change<<FILL>>
B10Every entry is attributable to a single identified personSigned or initialled with a legible identity, or made under a unique user account. No shared logins, no signing on behalf of another person<<FILL>>
B11Evidence was captured for every step that requires it, with a visible timestamp and the identity of who captured itScreenshots show the system time and the logged-in user where the system displays them. Printouts are signed and dated by the capturer<<FILL>>
B12Every evidence item is numbered and cross-referenced from the step it supportsYou can go from any step to its evidence and back<<FILL>>
B13No evidence was cropped, edited, annotated over, or re-created after the factAnnotations, where needed, are added as a separate labelled layer or a separate note, leaving the original capture intact<<FILL>>
B14Every unplanned event during execution was recorded, not only failing resultsPower interruptions, network drops, interrupted sessions, a step run out of order, a change to the environment mid-session<<FILL>>
B15Every re-execution ran only after an approved re-execution authorizationYou did not re-run a step because the fix “was obviously done”. The authorization existed and was signed first<<FILL>>
B16Every re-execution was recorded as a new, separately dated and signed record referencing its incidentThe original failed record and the re-execution record both exist and are both in the package<<FILL>>
B17No entry was back-dated or forward-datedThe date and time on the record is the date and time the work was done<<FILL>>
B18Where an entry was genuinely made late, it is recorded as a late entry with the reason and both datesDate of the observation and date of the entry, both visible, with the reason for the delay<<FILL>>
B19Steps were executed in the sequence the protocol specifies, or the departure was recorded as an incidentOut-of-sequence execution is a documented event, not a silent one<<FILL>>
B20Nobody signed a step they did not personally execute or personally witnessThe signature means what it says<<FILL>>
B21No execution page was removed, replaced, or reprinted without a controlled reissue recordPage counts intact. If a page was reissued, the reissue is recorded and the original retained<<FILL>>
B22Where a second-person review or witness was required, it was performed at the time by a qualified personNot signed in a batch at the end of the week by someone who did not observe the work<<FILL>>

Gate B. Any Fail in section B is raised as a test incident. Items B3, B4, B5, B10, B13, B17, and B20 are data integrity items; a Fail on any of these is notified to QA the same working day and assessed under your data integrity investigation procedure.


Section C: After execution

Complete after execution finishes and before the validation summary report is drafted.

#CheckWhat good looks likeReferencePass / Fail / NAComment
C1Every FAIL annotation on an execution page maps to a logged test incident numberReconciliation performed and recorded. No orphan FAIL marks, no orphan incidents<<FILL: reconciliation ref>>
C2Every logged test incident has a confirmed classificationClassification confirmed by QA, not assigned by the executor alone<<FILL: incident log>>
C3Every incident has a documented dispositionClosed-resolved, closed with a justified open item, or accept-with-justification with residual risk recorded<<FILL>>
C4Every incident requiring a QMS deviation has one, and the two registers reconcileThe count in the test incident log and the count in the QMS deviation register agree, and the reconciliation is recorded<<FILL>>
C5Every re-execution is a separate, dated, signed record referencing its incidentNo re-execution recorded over the top of an original<<FILL>>
C6Every re-execution authorization is dated on or before its re-executionApproval precedes execution. Check the dates, do not assume them<<FILL>>
C7The number of re-execution attempts per step is visible in the recordIf a step took three attempts, the record shows three attempts, not one<<FILL>>
C8Every scope and impact assessment required by classification is complete and approvedNo C3 to C6 incident closed without one<<FILL>>
C9Every previously passed test identified as affected by a defect has been re-executed or explicitly retained with a stated basisNo test left as PASS by default because nobody looked<<FILL>>
C10The system audit trail for the execution period has been reviewed against the documented execution timelineRecord creation and modification times sit inside the documented window<<FILL: audit trail review ref>>
C11No test record was created or modified by an identity other than the documented executorAny such entry is explained and, if unexplained, raised as an incident<<FILL>>
C12No re-execution timestamp precedes its corrective action completion dateThe timeline in the paper and the timeline in the audit trail tell the same story<<FILL>>
C13There are no audit trail gaps or disabled periods across the execution windowContinuity confirmed, or the gap raised as an incident<<FILL>>
C14All evidence referenced from execution pages exists, is legible, and is stored where the protocol saysSpot check at minimum, full check where the protocol requires it<<FILL>>
C15All required signatures are present, legible, and dated, with no signature applied by one person on behalf of anotherSignature review complete against the specimen signature register<<FILL>>
C16No person approved a document they prepared, executed, or correctedSignature review against the authority matrix<<FILL>>
C17Every open item carries a description, a risk position, a compensating control where relevant, a named owner, and a target dateNo open item listed as “to be resolved” with nothing behind it<<FILL>>
C18No item is open and unassessedAn open item is permitted. An unassessed one is not<<FILL>>
C19The complete open-item list is reproduced in the validation summary reportThe report reflects the log, and both were reconciled before issue<<FILL: report ref>>
C20Executed protocol, incident log, evidence, and authorizations are collated, indexed, and archived per the retention scheduleThe package can be retrieved and read by someone who was not on the project<<FILL: archive ref>>

Gate C. The validation summary report is not drafted with an open Fail in section C. See Validation summary report and release.


Signoff

RoleNameSignatureDateStatement
Executor<<FILL>>I completed the checks in sections A and B and the responses are accurate
Validation lead<<FILL>>I reviewed sections A to C and confirm the reconciliations in section C were performed
Second-person reviewer<<FILL>>I independently reviewed the executed package against this checklist
Quality Assurance<<FILL>>I reviewed the completed checklist and the disposition of any Fail
FieldEntry
Total items<<FILL>>
Pass<<FILL>>
Fail<<FILL>>
NA (with reason)<<FILL>>
Test incidents raised from this checklist<<FILL: list numbers, or none>>

References

21 CFR 211.68, 211.188, 211.194, and 211.192, for automatic equipment controls, batch record content, laboratory record content, and the investigation of unexplained discrepancies. 21 CFR Part 11, for electronic records and electronic signatures, including the requirement that record changes do not obscure previously recorded information. EU GMP Annex 11, Computerised Systems (2011, the version currently in force), for audit trail, access control, and data integrity expectations. The draft revision published 7 July 2025, consultation closed 7 October 2025, is not final. EU GMP Annex 15, Qualification and Validation (2015), which requires deviations from validation protocols to be documented with appropriate justification. EU GMP Chapter 4, Documentation, for good documentation practice expectations applied to the execution record. FDA guidance on data integrity and compliance with drug CGMP (2018), MHRA GxP Data Integrity Guidance and Definitions (2018), and PIC/S PI 041-1, for the ALCOA+ principles applied in sections A to C. FDA guidance “Computer Software Assurance for Production and Quality Management System Software”, issued 3 February 2026, for the risk-based assurance context. ISPE GAMP 5 Second Edition (2022), for the validation lifecycle context. Reference only.

Confirm the current version and clause numbers of each reference before issue.


Filled specimen

The following shows selected lines completed for an OQ execution session on a chromatography data system in a biologics QC laboratory. The company, system, names, and numbers are illustrative.

FieldEntry
Checklist number and versionCL-VAL-004 v1.0
ProtocolOQ-CDS-011, Operational Qualification of the Chromatography Data System, v2.0
Validation phaseOQ
SystemChromatography data system, instance CDS-QUAL, instruments HPLC-04 and HPLC-09
Execution sessionSession 3, test cases TC-019 to TC-027
ExecutorN. Haddad, QC Analyst, user ID nhaddad
Date range13 to 16 July 2026

Section A, selected lines

#CheckPass / Fail / NAComment
A1Approved current protocol versionPassOQ-CDS-011 v2.0, approved 02 July 2026
A2Controlled copyPassControlled copy 03 of 04, issued 10 July 2026
A5Build confirmed with evidencePassCDS build 8.3.1, version screen captured as EV-A05, 13 July 08:02
A6Environment matches qualified targetFailCDS-QUAL runs on Windows Server build one patch level behind the production target. Raised as TI-OQ-CDS-006. Execution held
A10Personal attributable accountPassnhaddad, role QC_ANALYST. No shared account used
A11Clock and time zone confirmedPassTime source synchronised to the site NTP server, UTC+02:00, users cannot alter. Evidence EV-A11
A12Audit trail enabled and not user-disableablePassConfirmed at the system and evidenced EV-A12. Administrator role can disable; ordinary analyst role cannot
A13Evidence capture method agreedPassScreenshots must show system clock and logged-in user; chromatograms printed to PDF from the CDS with the audit-trail footer enabled
A15Incident log openPassTIL-OQ-CDS-011, next number TI-OQ-CDS-006
A16Escalation criteria readPassValidation plan VP-CDS-2026-01 section 7.3
A18Prerequisites metPassIQ-CDS-011 closed 08 July 2026. HPLC-04 and HPLC-09 calibration current to 30 September 2026

A6 failed. Execution was held for two days while the environment patch level was reconciled with the production target under CR-CDS-2026-044, and TI-OQ-CDS-006 recorded the hold. That is the correct outcome. The alternative, executing anyway and noting the difference in the report, would have left every result open to the question of whether it applied to the environment actually released.

Section B, selected lines

#CheckPass / Fail / NAComment
B1Contemporaneous recordingPass
B3Failures recorded before any retryPassTC-023 step 4 failed at 11:47 on 15 July. Recorded and TI-OQ-CDS-008 raised at 11:52 before any re-injection
B4Failed steps remain FAILPassTC-023 step 4 remains FAIL on page 31 with “see TI-OQ-CDS-008”
B5No expected result edited to match actualPass
B7No blank required fieldsFailThree steps on pages 27 and 28 had the “evidence reference” field blank because the screenshots were saved but not numbered at the time. Completed on 15 July with a late-entry annotation per B18, both dates shown, reason recorded. TI-OQ-CDS-009 raised
B8No erased or obliterated entriesPassTwo corrections on page 24, both single line through, initialled NH, dated, reason “transposed step number”
B10Attributable entriesPass
B11Evidence with timestamp and identityPassAll screenshots show the CDS clock and the nhaddad session banner
B13Evidence not editedPassTwo screenshots carry a separate annotation layer identifying the field of interest; originals retained unaltered as EV-B13a and EV-B13b
B14Unplanned events recordedPassNetwork interruption 14 July 13:20 to 13:35 interrupted TC-021. Recorded as TI-OQ-CDS-007, TC-021 re-executed in full under RTA-007
B15Re-executions ran only after approved authorizationPassRTA-007 approved 14 July 16:10; TC-021 re-executed 15 July 08:30
B16Re-executions are separate recordsPassOQ-CDS-011 addendum 1 pages A1 to A4
B20Nobody signed work they did not performPass
B22Second-person review performed at the timePassR. Silva witnessed the TC-023 failure at 11:47 and countersigned the observation

B7 failed and was handled correctly: the omission was found, corrected as a late entry with both dates and a reason, and raised as an incident rather than quietly backfilled. A reviewer reading page 27 sees exactly what happened and when.

Section C, selected lines

#CheckPass / Fail / NAComment
C1FAIL marks reconcile to logged incidentsPass4 FAIL marks, 4 incidents. Reconciliation record REC-OQ-CDS-011 dated 17 July 2026
C4Incident and deviation registers reconcilePass4 incidents, of which 2 escalated to VAL-DEV-2026-058 and VAL-DEV-2026-059. Counts agree with the QMS register
C6Authorizations precede re-executionsPassRTA-007 approved 14 July 16:10 versus execution 15 July 08:30; RTA-008 approved 16 July 09:15 versus execution 16 July 13:00
C7Attempt counts visiblePassTC-023 step 4 shows one failure and one re-execution. No hidden attempts
C9Affected previously passed tests re-executed or retained with a basisPassSIA-008 identified TC-019 and TC-020 as affected. Both re-executed under addendum 1
C10Audit trail reviewed against documented timelinePassAudit trail review ATR-OQ-CDS-011, 17 July 2026. All record creation times fall between 13 and 16 July, inside the documented window
C11No records created by other identitiesFailTwo records show creation by user “cdsadmin” on 14 July at 17:40. Investigated: the administrator restored a sequence after the network interruption, which was documented in TI-OQ-CDS-007 but not cross-referenced to the audit trail entries. Cross-reference added; no unexplained activity. Closed
C12Re-execution timestamps follow corrective action completionPass
C17Open items completePassOne open item: a low-impact report formatting defect, VAL-DEV-2026-059, risk position documented, owner CDS system owner, target 30 September 2026
C18No unassessed open itemPass
C19Open-item list reproduced in the summary reportPassVSR-CDS-2026-03 section 8

C11 is the check that earns its place. The activity was legitimate and was already documented in an incident, but nothing tied the incident to the two audit trail entries an inspector would find first. Adding the cross-reference took ten minutes at the desk. Explaining it cold in a back room, two years later, without the cross-reference, takes considerably longer and looks worse.

Common inspection findings this checklist prevents

  • Execution begun against a superseded protocol version, or against an uncontrolled printed copy.
  • The build or environment under test not recorded, so the package does not establish what was actually qualified.
  • Test results transcribed into the protocol at the end of the day from working notes, with the working notes discarded.
  • A failing step retried before it was recorded, so only the passing attempt exists.
  • Failed steps blanked, obliterated, or overwritten so the failure is invisible on the page.
  • Expected results edited to match observed system behaviour and the step then marked PASS.
  • Blank required fields across executed pages, later backfilled with no late-entry annotation.
  • Corrections made with no reason recorded, or with the original entry rendered illegible.
  • Execution performed under a shared or generic account, so entries cannot be attributed to a person.
  • Screenshots with no visible timestamp or user identity, or evidence that was cropped or re-created after the fact.
  • Re-executions performed before the authorization that permits them was approved, evidenced by the audit trail.
  • Witness or second-person signatures applied in a batch after the fact by someone who did not observe the work.
  • Audit trail entries showing record creation outside the documented execution window, with no explanation in the package.
  • A summary report issued while incidents in the log carry no disposition, or open items carry no owner and no date.

How to adapt this checklist

  1. Set your checklist number, and align the section A items to the prerequisites your protocols actually specify. Add rows for anything unique to your technology, such as instrument calibration status, reference standard traceability, or a controlled data set checkout.
  2. Decide the completion cadence for section B and state it once. Per session works for multi-day campaigns; per protocol works for short executions. Mixed practice produces gaps.
  3. Mark your own data integrity items in section B and tie them to your notification timing. The set flagged here (B3, B4, B5, B10, B13, B17, B20) is a starting point, not a fixed list.
  4. For paper execution, write your good documentation practice correction convention into the B8 and B9 rows in your own words so the executor reads the rule at the moment of use rather than recalling a training slide.
  5. For fully electronic execution, replace the paper-specific rows with the equivalent electronic controls: no shared accounts, no local file copies, e-signature meaning applied correctly, and a record-level audit trail that captures the change and the reason.
  6. Where your protocols already carry an execution cover sheet, fold section A into it rather than issuing a second document, so the executor completes one thing well instead of two things quickly.
  7. Add your specimen signature register reference to the C15 row so the signature review has something to check against.
  8. Confirm every regulation in the references section against the current published version before issue, in particular the status of the EU GMP Annex 11 revision, which was still in draft at the time of writing.
Use madhadi.com as an app Full screen, works offline, one tap from your home screen.