PEDSnet Common Data Model ETL Conventions
Created
Submission Date
Data Collection
Files
Tags
Abstract
This document provides the ETL processing assumptions and conventions developed by the PEDSnet data partners that a data partner should use to ensure common ETL business rules.
Affiliation(s)
Provenance
Description
The PEDSnet Common Data Model is an evolving specification, based in structure on the OMOP Common Data Model, but expanded to accommodate requirements of both the PCORnet Common Data Model and the primary research cohorts established in PEDSnet. This version of the PEDSnet CDM reflects the ETL processes developed after several iterations of network development. As such, it proposes to align with the current version of the PCORnet CDM.
This document provides the ETL processing assumptions and conventions developed by the PEDSnet data partners that a data partner should use to ensure common ETL business rules. This document will be modified as new situations are identified, incorrect business rules are identified and replaced, as new analytic use cases impose new/different ETL rules, and as the PEDSnet CDM continues to evolve.
**** NEW in PEDSnet CDM v6.1 ****
There are no DDL or ETL Convention Changes between PEDSnet version 6.0 and 6.1.
**** Reminders ****
Please ensure the following ETL enhancements from this past year are implemented for PEDSnet version 6.1 if not yet completed:
1. Inclusion of patient-reported medication history records in DRUG_EXPOSURE:
- Utilize
drug_type_concept_id=32865to flag Patient Reported Medication records. - See Note 9 of DRUG_EXPOSURE for additional details.
2. Inclusion of additional “raw” PRO/SIOH survey records in OBSERVATION:
- Utilize
observation_type_concept_id=32862to flag patient survey records. - See Note 10 of OBSERVATION for guidance details.
- See this GitHub Issue as an additional implementation resource.
3. Inclusion of mother-baby linkage in FACT_RELATIONSHIP:
- Please refer to the following guidance for modeling a mother-baby relationship:
| Field | Value |
|---|---|
domain_concept_id_1 |
56 (person) |
fact_id_1 |
person_id for the Child |
domain_concept_id_2 |
56 (person) |
fact_id_2 |
person_id for the Mother |
Relationship_concept_id |
581437 (Child to Parent Measurement) |
4. Inclusion of IV fluid MAR actions in DRUG_EXPOSURE:
- Utilize
drug_type_concept_id=2000001594to flag IV Fluid MAR Action records. - See Continuous IV Fluid Volume Guidance and Note 9 of DRUG_EXPOSURE for details.
5. Inclusion of external drug records in DRUG_EXPOSURE:
- Utilize
drug_type_concept_id=32849for Medications sourced from a Health Information Exchange. - Utilize
drug_type_concept_id=32810for Medications sourced from a Claims source. - See Note 9 of DRUG_EXPOSURE for additional details.
Vocabulary
Related Publications
Creative Commons license
Cite this Documentation
Version History
| Version | Date | Summary |
|---|---|---|
12* | 2026-02-02 16:00:01 | Version 6.1 of the PEDSnet CDM ETL Conventions |
| 2026-02-02 15:37:26 | Version 6.0 of the PEDSnet CDM ETL Conventions | |
| 2025-07-16 12:29:21 | Version 5.9 of the PEDSnet CDM ETL Conventions | |
| 2025-07-16 12:22:41 | Version 5.8 of the PEDSnet CDM ETL Conventions | |
| 2025-03-11 10:39:21 | Version 5.7 of the PEDSnet CDM ETL Conventions | |
| 2024-11-15 10:52:12 | Version 5.6 of the PEDSnet CDM ETL Conventions | |
| 2024-08-13 15:01:37 | Version 5.5 of the PEDSnet CDM ETL Conventions | |
| 2024-08-13 14:58:18 | Version 5.4 of the PEDSnet CDM ETL Conventions | |
| 2024-08-13 14:53:47 | Version 5.3 of the PEDSnet CDM ETL Conventions | |
| 2024-08-01 11:39:29 | Version 5.2 of the PEDSnet CDM ETL Conventions |