Clinical Trial CRF Data Validation & Query Workflow
Validate CRF data against protocols and auto-generate audit-ready data query forms
What You Can Do
You can validate eCRF and paper CRF datasets against protocol-defined rules, automatically identify data discrepancies (missing fields, out-of-range values, date inconsistencies), generate structured Data Query Forms (DQFs) for site clarification, track resolution status, and create audit-ready compliance documentation that meets FDA 21 CFR Part 11 and GCP requirements. This workflow reduces manual validation time while ensuring 100% traceability and regulatory readiness for inspections.
Features
define and apply site-specific validation criteria (range checks, mandatory fields, date logic, data type verification) to catch discrepancies early
create standardized Data Query Forms directly from validation failures, formatted for site submission with required fields, priority levels, and deadlines
monitor open/closed queries by site, subject, and data field with resolution timestamps and audit trail documentation
generate SDV forms tied to protocol-critical variables and regulatory safety endpoints for systematic site verification
document all data changes, queries, resolutions, and reviewer approvals with electronic signature placeholders for CFR Part 11 compliance
produce pre-lock validation summaries showing data completeness %, query resolution %, and any remaining compliance gaps
aggregate query metrics across trial sites (response rates, resolution times, common error types) for sponsor oversight and trending analysis
customizable protocol validation rules, DQF formats, and SDV checklists for fast implementation across trials and therapeutic areas
Example Output
Example 1: Validation Report
- Subject 101: Missing Visit 2 labs (Protocol requires ALT/AST by Day 14) → DQF generated, priority HIGH
- Subject 156: Dosing date (2024-01-15) before enrollment (2024-02-01) → Date logic error flagged, auto-query created
- Site 05: 8 incomplete AE severity fields across 12 subjects → Batch DQF issued to site coordinator
Example 2: DQF Output
Data Clarification Form (DCF-2024-001)
Site: Boston Clinical Research | Subject: 101 | Query Date: 2024-03-15
Variable: Lab Result - ALT (alanine aminotransferase)
Issue: Missing value at Visit 2 (Day 14 ±2)
Protocol Requirement: All safety labs mandatory per Section 5.2.1
Site Response Required By: 2024-03-22
Reviewer Signature: _____ | Date: _____
Example 3: Audit Trail Entry
- 2024-03-15 10:23 AM: CRA Jane Smith flagged ALT missing (Subject 101)
- 2024-03-18 02:15 PM: Site responded with post-hoc lab value (22 U/L) + source document copy
- 2024-03-18 03:45 PM: Medical Monitor approved value for database lock
- Status: RESOLVED | Lock-ready: YES
What's Included
- SKILL.md: complete instruction set for workflow implementation
- Protocol Validation Rules Template: customizable checklist for defining site-specific validation logic by data field and visit
- Data Query Form (DQF) Template: standardized format with priority levels, response deadlines, and signature blocks
- Query Tracking Log: spreadsheet for monitoring open/closed queries by subject, site, and resolution status
- Pre-Lock Readiness Checklist: validation summary template covering data completeness, query resolution rates, and CFR Part 11 compliance gaps
- Source Data Verification (SDV) Checklist: protocol-critical variable verification form for systematic site audits
Who It's For
- Clinical Research Associates (CRAs) — managing site data collection, query resolution, and interim monitoring for multi-site trials
- Data Managers — validating datasets before lock, generating regulatory-compliant audit documentation, and tracking query metrics
- Regulatory & Compliance Specialists — preparing FDA inspection evidence, audit trail documentation, and 21 CFR Part 11 compliance exhibits
- Clinical Trial Sponsors/Monitors — overseeing data quality across sites, identifying trending validation issues, and assessing lock-readiness
- Quality Assurance & Audit Teams — conducting internal audits, validating CRF workflows, and documenting compliance evidence
Best For
- Pre-Lock Data Validation — systematic validation of 100+ subjects before database lock to ensure 100% accuracy and regulatory readiness
- Interim Safety Monitoring — flagging out-of-range or missing safety data (labs, vitals, AEs) with rapid site queries during ongoing trials
- Site Data Query Management — auto-generating and tracking DQFs across multiple sites, monitoring response rates, and escalating overdue queries
- Source Data Verification (SDV) Planning — identifying protocol-critical variables requiring site verification and generating SDV checklists
- FDA Inspection Readiness — creating audit-ready documentation (validation rules, query logs, resolution evidence, signature trails) for regulatory inspection
You might also like
You can design and execute bioanalytical method validations aligned with FDA Guidance for Industry and ICH guidelines, interpret complex validation data against regulatory acceptance criteria, and systematically troubleshoot analytical failures to identify root causes and corrective actions. This skill accelerates validation timelines by 20–30%, minimizes regulatory rework, and provides structured decision trees for problems that typically require expert consultation.
by kody-w
You can architect end-to-end bioinformatics analysis pipelines by translating your research question into algorithmic approaches, selecting and optimizing appropriate tools and parameters for your dataset, and validating results against biological expectations. This skill guides you through the complete decision tree from raw data to publication-ready interpretation, helping you avoid parameter overfitting, misinterpreted statistical thresholds, and algorithm selection errors that compromise research validity.
by kody-w
You consolidate parallel data streams from preclinical toxicology studies (clinical pathology, histopathology, body weight changes, organ weights, clinical observations, mortality) into coherent regulatory-compliant narratives. This skill synthesizes findings across 6–12 endpoints simultaneously, identifies NOAEL/LOAEL with biological justification, determines safety margins, interprets species-specific or sex-specific signals, and produces Results & Discussion sections that satisfy FDA/EMA reviewers while supporting appropriate dosing decisions for IND-enabling studies.
by kody-wClaude reviews your injection mold, stamping die, or precision tool designs for manufacturability, cost reduction opportunities, and tolerance optimization. You provide CAD specifications, material details, and production volume—Claude identifies specific design modifications, material alternatives, and tolerance adjustments that reduce tooling complexity and unit costs without compromising performance.
by kody-w
You can upload or describe product designs and receive a comprehensive analysis of manufacturing feasibility, cost drivers, and prioritized optimization recommendations. The skill identifies design inefficiencies, material waste opportunities, assembly complexity challenges, and supply chain risks—giving you actionable steps to reduce costs and prevent production delays before they happen.
by kody-w
This skill organizes complex toxicology datasets, clinical adverse events, and mechanistic findings into structured, FDA/EMA-compliant safety narratives. You input raw safety data—adverse event summaries, laboratory results, animal study findings, vital signs—and receive draft safety summaries, detailed safety assessments, and expedited safety reports ready for regulatory submission. It handles IND applications, annual safety updates, clinical development safety overviews, and urgent safety communications with proper MedDRA coding and regulatory formatting.
by kody-w
You can take unstructured monitoring visit observations and convert them into formal, audit-ready reports that categorize findings by risk level (Critical, Major, Minor), validate protocol compliance, and generate actionable follow-up items with assigned owners and resolution dates. The skill ensures your documentation meets FDA inspection standards and ICH-GCP requirements while creating clear escalation pathways for high-risk issues.
by kody-w
You can design experiments with appropriate controls, replicate structures, and sample sizes before conducting any bench work. This skill helps you establish clear endpoints, identify confounding variables, select the right statistical tests, and create reproducible data collection protocols—preventing costly failed experiments and increasing publishability.
by kody-w