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 generates comprehensive fault study reports, protection coordination analyses, and compliance documentation for electrical power systems. It systematically documents fault scenarios, relay settings, coordination curves, and technical specifications required for grid operations and regulatory compliance. You produce production-ready documentation that meets industry standards—IEEE, NERC, and regional RTO requirements.
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
Create comprehensive tool specifications tailored to your manufacturing process, material combinations, and performance requirements. Analyze cutting speeds, feeds, tool life, and thermal behavior to predict tool performance and identify optimization opportunities. You can compare design alternatives, predict failure modes, and generate compliance documentation for production tooling decisions.
by kody-w
You can prepare complete site monitoring visit documentation, including source document verification (SDV) checklists tailored to specific case report forms, comprehensive findings reports from visit notes, and structured data query forms for identified discrepancies. This skill standardizes compliance documentation, identifies protocol deviations systematically, and creates actionable remediation plans to maintain data integrity and GCP compliance across investigator sites.
by kody-w
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 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
Systematically evaluate ingredient compatibility against your active pharmaceutical ingredients, predict formulation behavior and stability risks, and troubleshoot phase separation, incompatibility, and irritation issues in real time. Generate ICH-aligned stability protocols, excipient safety summaries, and regulatory-ready documentation that accelerates IND, NDA, and ANDA submissions without replacing lab validation.
by kody-w