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
This skill systematically analyzes your product designs to identify manufacturability issues early, saving costly revisions and manufacturing delays. It evaluates geometry, material selection, tolerances, assembly feasibility, and production process constraints. You get actionable feedback on cost drivers, process risks, and design optimizations before committing to production.
by kody-w
You can submit tool designs—drawings, specifications, or descriptions—and Claude will evaluate manufacturability constraints, identify potential failure modes using structured frameworks, and recommend cost-reduction opportunities. You'll receive a prioritized report covering structural analysis, production feasibility, material efficiency, and design trade-offs.
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-wThis skill interprets your FEA simulation results and extracts actionable design improvements. You can pinpoint stress concentrations, validate designs against safety factors and material limits, and receive specific geometry recommendations to reduce weight or improve performance. By automating FEA post-processing, you compress design iteration cycles and make engineering decisions faster.
by kody-w
Get comprehensive PCB design analysis covering power delivery networks, signal integrity, thermal management, and manufacturing constraints. Claude identifies potential issues early and provides specific, actionable optimization recommendations to reduce cost, improve reliability, and accelerate time-to-market. Suitable for designs from initial concept through production-ready layouts.
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
Analyze your PLC code and ladder logic to identify logic errors, safety violations, and inefficiencies before they reach production. You'll get detailed diagnostics of control system failures, safety compliance verification against IEC 61131 standards, and optimization recommendations for automation sequences. This skill helps you prevent costly downtime, ensure worker safety, and improve system performance across manufacturing operations.
by kody-w
You can analyze equipment sensors, operational logs, and historical maintenance data to predict failures weeks in advance. Claude generates actionable maintenance schedules, identifies high-risk assets, and calculates the financial impact of preventive vs. reactive maintenance. This skill transforms raw operational data into strategic maintenance decisions that minimize downtime and extend asset life.
by kody-w