Health1st AI Logo
CDISC & Biostatistics

Automating CDISC: From CDASH to Define-XML

How to compress the SDTM and ADaM timeline while preserving end-to-end traceability, with a continuous-validation approach that keeps Pinnacle 21 findings from piling up before database lock.

Health1st AI ResearchMay 31, 202613 min read24 pages

Key takeaways

  • Conformance is decided at CRF design, not at database lock. The cheapest moment to fix an SDTM issue is before it is ever collected, so a late first Pinnacle 21 run is the most expensive way to find problems.
  • The chain is directional and must stay traceable: CDASH collection flows into SDTMIG v3.4 tabulation, which is derived into ADaM analysis datasets, which feed the tables, listings, and figures. Break the order and you break traceability.
  • Define-XML 2.1 and the annotated CRF are the metadata backbone. They are required deliverables for FDA and PMDA and the map reviewers use to navigate every dataset and derivation.
  • Because CDASH is engineered to flow into SDTM, a CRF built on standard collection metadata already carries most of the mapping intent, which is exactly where automation earns its keep.
  • Continuous validation beats a single end-of-study run. Draft datasets validated against Pinnacle 21 early and often turn a wall of findings into a short, triaged, mostly-justified list.
  • Automation drafts; humans decide. Mapping specs, Define-XML, and aCRF annotations should be machine-generated but reviewed by a data-standards lead, and every remaining finding needs a documented rationale in the reviewer's guide.

The scramble nobody schedules, but everyone lives through

You know the shape of the last eight weeks before database lock. The clinical data is finally clean, the statistician is ready, and now the entire CDISC chain has to be built, or rebuilt, all at once: SDTM mapped, ADaM derived, tables and listings run, the annotated CRF finished, Define-XML assembled, and Pinnacle 21 run in anger for the first time. That first real validation report lands with hundreds of findings. The ones you least want to see are the structural ones, because they trace back to decisions made at study start-up eighteen months ago. Fixing them now means touching SDTM, which means re-deriving ADaM, which means re-running every table and re-annotating the CRF. The submission clock does not move.

The frustration is not that the standards are hard. It is that the work gets treated as a downstream, end-of-study event when the decisions that determine conformance are made at the very beginning, on the case report form. By the time a validator tells you something is wrong, the cheapest moment to have fixed it has long since passed.

It does not have to run this way. Imagine the validation report as a living artifact you have been watching since first-patient-in, not a verdict delivered at the end. Imagine walking into database lock with a conformance list that is already short, already triaged, and already mostly explained. That shift, from a single terminal scramble to a continuous discipline, is what this paper is about, and it is what modern automation finally makes practical.

Why the order is the point: CDASH to SDTM to ADaM to TLF

The CDISC foundational standards are not four independent formats. They are one directional pipeline, and the direction is the whole point.

CDASH (the Clinical Data Acquisition Standards Harmonization Implementation Guide, CDASHIG v2.1) governs collection. It standardizes what the CRF asks and how, and it is deliberately designed to feed the tabulation model downstream. SDTM (SDTMIG v3.4) governs tabulation: the collected data reorganized into standard domains, one observation per row, in the structure regulators expect. ADaM (the Analysis Data Model) governs analysis: datasets built so that a result is one procedure away, each derivation documented and each value traceable back to its SDTM source. Those analysis datasets then feed the tables, listings, and figures that become the study's reported results.

The CDISC Pipeline: Collect, Tabulate, Analyze, Report
CDASHCollect on the CRF (CDASHIG v2.1)
SDTMTabulate into domains (SDTMIG v3.4)
ADaMDerive analysis datasets (ADaMIG)
TLFTables, listings, figures

Each stage has a defined relationship to the one before it, and that relationship is called traceability. ADaM values must trace to SDTM records; SDTM records must trace to the collected field via the annotated CRF. This is not a stylistic preference. FDA's Study Data Technical Conformance Guide, which consolidates the agency's data specifications, common issues, and validation rules into one document, treats traceability as a core expectation, and CDISC standards have been required for new drug, biologics, and abbreviated applications for studies initiated after the agency's phase-in dates. When you rebuild SDTM late, everything derived from it is invalidated at once. That is why the end-of-study scramble is so brutal: a single upstream fix ripples through every downstream layer.

Define-XML and the annotated CRF: the metadata backbone

If the datasets are the body of a submission, Define-XML and the annotated CRF are its skeleton. They are what let a reviewer navigate thousands of variables without guessing.

Define-XML 2.1, published by CDISC in 2019, is the machine-readable metadata that describes every dataset, variable, controlled-term codelist, computational method, and value-level detail in the package. It is not optional polish. Define-XML is required by both the FDA and Japan's PMDA for every study in an electronic submission, and it is the first file a reviewer opens to understand what they are looking at.

The annotated CRF (aCRF) is its companion: a PDF of the blank CRF with each collected field annotated to show the SDTM domain and variable it maps to. Done well, it demonstrates traceability between the CRF, the datasets, and Define-XML, and its annotations must agree with the Define-XML mapping. Binding these together is Controlled Terminology, the codelists that CDISC publishes with the National Cancer Institute's Enterprise Vocabulary Services on a quarterly cycle, so that terms mean the same thing across studies.

The Submission Data Package
Annotated CRF (aCRF)Collected field to SDTM variable
SDTM datasetsTabulation, one row per observation
ADaM datasetsAnalysis-ready, derivations documented
Define-XML 2.1Machine-readable metadata map
Reviewer's GuidescSDRG and ADRG narrate decisions

The reviewer's guides sit on top: the clinical Study Data Reviewer's Guide (cSDRG) and the Analysis Data Reviewer's Guide (ADRG), templated by PHUSE, narrate the human context a machine cannot infer, from mapping decisions to known conformance findings and why they are acceptable. Together these layers tell one coherent story. When they disagree, reviewers notice, and questions follow.

Where automation actually helps

Automation does not replace the judgment in this work. It removes the transcription, the re-keying, and the drift between artifacts that should always agree, and it moves conformance checking to the left where fixes are cheap.

  • SDTM mapping from CRF design. Because CDASH is engineered to flow into SDTM, a CRF built on standard collection metadata already carries most of the mapping intent. Automation can read that metadata and propose draft mapping specifications, so the SDTM programmer starts from a structured first pass rather than a blank page.
  • Specification and Define-XML generation. The same metadata that describes collection and tabulation can generate the SDTM and ADaM specifications and the Define-XML itself, keeping the define, the datasets, and the specs derived from a single source rather than maintained by hand in parallel.
  • Annotated CRF synchronization. aCRF annotation is still partly manual at most organizations and drifts easily. Generating annotations from the same mapping metadata keeps the aCRF and Define-XML aligned by construction instead of by a late reconciliation pass.
  • Continuous conformance. Validation can run against draft datasets from the first data extract, not just at the end, turning conformance into a signal you watch rather than an exam you sit once.

The common thread is a single metadata backbone. When collection, tabulation, analysis, and the define are all projections of the same governed metadata, the artifacts cannot silently disagree, and that is most of what a late validation run is actually catching.

A continuous-validation operating model

The tool most teams validate with is Pinnacle 21 (now part of Certara), which publishes both a Community edition and an Enterprise edition. Its rule sets implement FDA and PMDA validation expectations and are refreshed on a regular cadence, at least twice a year, so keeping current matters. The change that pays off is not the tool; it is when you run it.

The Continuous-Validation Loop
Draft datasetsFrom the first data extract
Run Pinnacle 21Conformance and quality checks
Triage by ruleReject, error, warning
Fix or justifyCorrect upstream or document

Run validation on draft SDTM from the earliest usable extract, then repeat every cycle. Triage each finding by severity and by whether it is structural or contextual. Rejects and hard errors that point to a mapping or collection problem should be fixed upstream, at the CRF or the SDTM spec, where the fix is cheapest and does not cascade. Findings that are expected and defensible, a legitimately empty domain or a study-specific value, get a documented rationale that flows straight into the cSDRG or ADRG. Over a study, this converts the terminal wall of findings into a short, familiar list you have already reasoned about, because you have been reading the same report for months.

Human-in-the-loop and submission readiness

None of this removes the expert from the loop; it aims their attention. Automation drafts the mapping specs, the Define-XML, and the aCRF annotations, but a statistical programmer and a data-standards lead own the review. A generated mapping can be structurally valid and still clinically wrong, and only a human who understands the protocol can catch that. Likewise, a validation finding marked not-applicable is not closed until someone has written down why, because at submission a reviewer will ask, and the answer belongs in the reviewer's guide, not in someone's memory.

Submission readiness, in the end, is coherence. The aCRF, the SDTM and ADaM datasets, the Define-XML, and the reviewer's guides all have to tell the same story, and every conformance finding has to be either fixed or explained. You reach that state by treating CDISC as a discipline that runs from CRF design to lock, not as a project that starts at lock. Get the order right, keep one metadata backbone, validate continuously, and keep a human on the decisions that matter, and the end-of-study scramble stops being inevitable.

We would rather show you this on one of your own studies than talk about it in the abstract, including an honest read on where automation still needs a human. If that would be useful, we are glad to help, no pressure either way.

References

  1. CDASHIG v2.1 (Clinical Data Acquisition Standards Harmonization Implementation Guide)cdisc.org
  2. SDTM Implementation Guide (SDTMIG v3.4)cdisc.org
  3. Define-XML v2.1 standard and conformance rulescdisc.org
  4. CDISC Controlled Terminology (published quarterly with NCI EVS)cdisc.org
  5. FDA Study Data Technical Conformance Guidefda.gov
  6. FDA Study Data Standards Resources and Data Standards Catalogfda.gov
  7. Clinical Data Validation with Pinnacle 21 (Community and Enterprise)pinnacle21.com
  8. Clinical Study Data Reviewer's Guide (cSDRG) and ADRG templatesphuse.global

Want a copy to share with your team?

Tell us where to send it and we'll email you the full whitepaper — no obligation, and you can unsubscribe anytime.

Frequently asked questions

Let's see it on your study

No pitch, no pressure — a working walkthrough on your workflow and honest answers, including on the limits. Bring your hardest study.