mapping-scenarios

Map raw clinical trial data to SDTM using a nine-scenario framework.

Updated Aug 27, 2026
One-click install
npx skills add https://github.com/siddharthchauhan/ETL --skill mapping-scenarios
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: mapping-scenarios
Source: https://github.com/siddharthchauhan/ETL/tree/main/sdtm_pipeline/deepagents/skills/mapping-scenarios
Command: npx skills add https://github.com/siddharthchauhan/ETL --skill mapping-scenarios

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill provides a structured framework to understand and apply the nine essential SDTM mapping scenarios, enabling data teams to transform raw clinical trial data into SDTM-compliant datasets with accuracy and efficiency.

Core Features & Use Cases

  • Defines the 9 SDTM mapping scenarios (Direct Carry Forward, Rename, Attribute Change, Combine, Split, Derivation, Value Mapping, Structure Transformation, Supplemental Qualifiers).
  • Provides example-guided templates and a workflow to generate mapping specifications and apply transformations.
  • Supports validation and documentation of mapping decisions for regulatory submissions.

Quick Start

  1. Provide your source data schema and target SDTM domains.
  2. Run the mapping workflow to generate a specification using the nine-scenario framework.
  3. Execute transformations, validate results, and iterate on mappings as needed.

Frequently Asked Questions about mapping-scenarios

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
What are the standard SDTM mapping scenarios for transforming raw clinical trial data?

The standard SDTM mapping scenarios include direct carry forward, rename, attribute change, combine, split, derivation, value mapping, structure transformation, and supplemental qualifiers. These nine patterns provide a structured framework to map raw clinical trial data accurately into SDTM-compliant datasets.

How do I generate a mapping specification for clinical data domains?

To generate a mapping specification, provide your source data schema and target SDTM domains. Apply the nine-scenario framework workflow to define transformation functions, specify mapping tooling, and document validation steps required to implement the clinical data transformations.

When do I need to use supplemental qualifiers during SDTM data transformation?

Supplemental qualifiers are needed during SDTM data transformation when raw clinical trial data contains variables that cannot fit into standard domain structures. This mapping scenario preserves non-standard variables by mapping them to supplemental qualifier records compliant with regulatory submission standards.

What is the best way to handle structure transformation and value mapping in SDTM?

The best way to handle structure transformation and value mapping in SDTM is applying the defined nine-scenario framework. This approach standardizes converting data from wide to long formats and remapping raw clinical trial values to controlled terminology for regulatory submissions.

Can I validate derivation and split mappings for SDTM domains without external dependencies?

Yes, you can validate derivation and split mappings without external dependencies. The framework specifies validation steps and documentation procedures directly within the workflow to verify transformation accuracy and ensure SDTM compliance for regulatory submissions.

Does this SDTM mapping framework support direct carry forward across all clinical data domains?

Yes, the SDTM mapping framework supports direct carry forward across all clinical data domains. It provides example-guided templates and transformation functions that apply universally, enabling data teams to standardize raw clinical trial data into compliant datasets.