PEDSnet Common Data Model - ETL Conventions


Simple item page
dc.contributor.authorPEDSnet
dc.contributor.otherPEDSnet Data Coordinating Center
dc.date.accessioned2026-02-02T21:02:05Z
dc.date.created2026-01
dc.descriptionThe 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. <br><br> ## **** 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](https://github.com/PEDSnet/Data_Models/blob/master/PEDSnet/docs/PEDSnet_CDM_ETL_Conventions.md#111-drug-exposure): - Utilize `drug_type_concept_id` = `32865` to flag Patient Reported Medication records. - See [Note 9 of DRUG_EXPOSURE](https://github.com/PEDSnet/Data_Models/blob/v60/PEDSnet/docs/PEDSnet_CDM_ETL_Conventions.md#note-9-1) for additional details. #### 2. Inclusion of additional "raw" PRO/SIOH survey records in [OBSERVATION](https://github.com/PEDSnet/Data_Models/blob/master/PEDSnet/docs/PEDSnet_CDM_ETL_Conventions.md#19-observation-1): - Utilize `observation_type_concept_id` = `32862` to flag patient survey records. - See [Note 10 of OBSERVATION](https://github.com/PEDSnet/Data_Models/blob/master/PEDSnet/docs/PEDSnet_CDM_ETL_Conventions.md#note-10) for guidance details. - See [this GitHub Issue](https://github.com/PEDSnet/Data_Models/issues/499) as an additional implementation resource. #### 3. Inclusion of mother-baby linkage in [FACT_RELATIONSHIP]((https://github.com/PEDSnet/Data_Models/blob/master/PEDSnet/docs/PEDSnet_CDM_ETL_Conventions.md#113-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](https://github.com/PEDSnet/Data_Models/blob/master/PEDSnet/docs/PEDSnet_CDM_ETL_Conventions.md#111-drug-exposure): - Utilize `drug_type_concept_id` = `2000001594` to flag IV Fluid MAR Action records. - See [Continuous IV Fluid Volume Guidance](https://github.com/PEDSnet/Data_Models/blob/master/PEDSnet/docs/Codesets%20%26%20Additional%20Guidance/Continuous%20IV%20Fluid%20Volume%20Guidance.md) and[ Note 9 of DRUG_EXPOSURE](https://github.com/PEDSnet/Data_Models/blob/v60/PEDSnet/docs/PEDSnet_CDM_ETL_Conventions.md#note-9-1) for details. #### 5. Inclusion of external drug records in [DRUG_EXPOSURE](https://github.com/PEDSnet/Data_Models/blob/master/PEDSnet/docs/PEDSnet_CDM_ETL_Conventions.md#111-drug-exposure): - Utilize `drug_type_concept_id` = `32849` for Medications sourced from a Health Information Exchange. - Utilize `drug_type_concept_id` = `32810 ` for Medications sourced from a Claims source. - See [Note 9 of DRUG_EXPOSURE](https://github.com/PEDSnet/Data_Models/blob/v60/PEDSnet/docs/PEDSnet_CDM_ETL_Conventions.md#note-9-1) for additional details.
dc.description.abstractThis 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 record documents the changes for v6.1 or PEDSnet Database 2026-04.
dc.identifier.urihttps://hdl.handle.net/20.500.14642/749.12
dc.publisherPEDSnet
dc.relation.urihttps://github.com/PEDSnet/Data_Models_Public/blob/master/PEDSnet/docs/Conventions%20Docs/v6.1_PEDSnet_CDM_ETL_Conventions.md
dc.rightsa CC-BY Attribution 4.0 License.
dc.rights.urihttp://creativecommons.org/licenses/by/4.0
dc.subjectPEDSnet Data Source
dc.subjectETL Specifications
dc.titlePEDSnet Common Data Model - ETL Conventions
dc.typeOther
dspace.entity.typeDocumentation
relation.isDQResultOfDocumentationee892b6b-89da-458d-853e-5899c3de892d
relation.isDQResultOfDocumentation.latestForDiscoveryee892b6b-89da-458d-853e-5899c3de892d
relation.isDocumentationOfDocumentationb305fdbf-6f8d-4ba6-af9c-7cd29f9ad26d
relation.isDocumentationOfDocumentationd0698db8-b7bd-4fa1-b9be-fb45d0098f52
relation.isDocumentationOfDocumentation.latestForDiscoveryb305fdbf-6f8d-4ba6-af9c-7cd29f9ad26d
relation.isOrgUnitOfDocumentation32f633d4-ee75-467f-a1a2-24c207244346
relation.isOrgUnitOfDocumentationff3cd76b-cf4c-44c1-84a6-368cfd0e9123
relation.isOrgUnitOfDocumentationa118440c-013c-4d44-b7ce-19a9b1441304
relation.isOrgUnitOfDocumentationf17f740b-c35e-4a0e-9d83-7e051d0c64c5
relation.isOrgUnitOfDocumentationcdb3cef9-ebdd-4ca8-9000-14573ba301bf
relation.isOrgUnitOfDocumentationc8e42b1c-6ffb-4b73-b893-ae4b5fe07dfa
relation.isOrgUnitOfDocumentationcc4d0004-ec82-4d55-8a8d-61a3b0e7a09a
relation.isOrgUnitOfDocumentationda598fc2-bed7-4a0d-92d7-fc2517b715de
relation.isOrgUnitOfDocumentation751635c0-bac7-47e0-95ea-c78f3cb31390
relation.isOrgUnitOfDocumentation4a9c59a3-af72-449e-b5c0-2db953ff475a
relation.isOrgUnitOfDocumentation.latestForDiscovery43739abc-f2ca-4c98-9f34-a8e003de29ae

Files

Original bundle

Now showing 1 - 1 of 1
Thumbnail Image
Name:
ETL Conventions for use with PEDSnet CDM v6.1 OMOP V5.4.pdf
Size:
914.71 KB
Format:
Adobe Portable Document Format
Download

License bundle

Now showing 1 - 1 of 1
Thumbnail Image
Name:
license.txt
Size:
1.71 KB
Format:
Item-specific license agreed to upon submission
Description:
Download

Domains

Data Architecture

Version History

Now showing 1 - 10 of 10
VersionDateSummary
12*
 2026-02-02 16:00:01
Version 6.1 of the PEDSnet CDM ETL Conventions
11
 2026-02-02 15:37:26
Version 6.0 of the PEDSnet CDM ETL Conventions
9
 2025-07-16 12:29:21
Version 5.9 of the PEDSnet CDM ETL Conventions
8
 2025-07-16 12:22:41
Version 5.8 of the PEDSnet CDM ETL Conventions
7
 2025-03-11 10:39:21
Version 5.7 of the PEDSnet CDM ETL Conventions
6
 2024-11-15 10:52:12
Version 5.6 of the PEDSnet CDM ETL Conventions
5
 2024-08-13 15:01:37
Version 5.5 of the PEDSnet CDM ETL Conventions
4
 2024-08-13 14:58:18
Version 5.4 of the PEDSnet CDM ETL Conventions
3
 2024-08-13 14:53:47
Version 5.3 of the PEDSnet CDM ETL Conventions
1
 2024-08-01 11:39:29
Version 5.2 of the PEDSnet CDM ETL Conventions
* Selected version