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 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
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-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
Conduct comprehensive job risk assessments in minutes, generate detailed task analysis reports with biomechanical findings, and develop prioritized ergonomic interventions backed by OSHA and NIOSH guidelines. You'll identify risk factors, quantify hazard severity, and produce actionable recommendations that reduce worker injury rates and improve compliance documentation.
by kody-w
You can automate the validation of clinical trial data against protocol specifications, identify discrepancies including missing values, out-of-range results, protocol violations, and CRF inconsistencies. The skill generates audit-ready query documentation, categorizes anomalies by severity and type, resolves root causes systematically, and produces FDA inspection-ready reports that trace every data decision and corrective action for CDISC and regulatory submission.
by kody-w
Analyze your power system topology, coordinate protective devices for optimal selectivity and speed, and generate comprehensive arc flash hazard analyses compliant with IEEE 1584. You get fault current calculations, device coordination plots, and hazard risk assessments that guide equipment upgrades and safety training.
by kody-w
You can rapidly diagnose why your solid dose formulations are failing—whether due to poor flowability, insufficient hardness, moisture sensitivity, dissolution issues, or API degradation. The skill walks you through structured root-cause analysis, maps chemical interactions between your drug substance and excipients across pH, temperature, and moisture conditions, then prioritizes excipient replacements based on regulatory precedent and manufacturing feasibility. You'll document all decisions with clear rationale ready for CMC submissions.
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-w