PEDSnet Common Data Model, v5.8

Created

2025-05-05

Submission Date

Data Collection

Files

1 Download↓
ETL Conventions for use with PEDSnet CDM v5.8 OMOP V5.4.pdf (1 MB)
↓

Data Source

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)

PEDSnet Data Coordinating Center

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 v5.8

(1) Additional Guidance for 1.11 Drug Exposure:

Begininng in PEDSnet version 5.5, we specified the new drug_type_concept_id = 32865 “Patient self-report” to represent Patient Reported Drugs (in clarity where order_med.order_class_c represents "Historical Med").

When providing patient reported drugs, in order to delineate the difference between the date range the patient reported taking the drug from the date the drug history was recorded in the EHR system, please use the following guidance:

  • Set drug_exposure_order_date/datetime to the date in which the patient reported drug was recorded in the EHR system.

  • Use drug_exposure_start_date/datetime and drug_exposure_end_date/datetime to specify the date range in which the patient reported taking the drug. Leave drug_exposure_end_date/datetime NULL if no end date is specified.

  • If the patient reported drug record does not specify a date range or start date, then also set drug_exposure_start_date/datetime to the date in which the patient reported drug was recorded in the EHR system in order to fulfill the field’s Non Null Constraint.

(2) Continuation of the Continuous Infusion Volume Derivation Pilot

We are continuing the Continuous Infusion Volume Derivation Pilot introduced in PEDSnet version 5.7. Based on the results from the first pilot cycle, we made slight changes and included some additional guidance:

  1. DDL changes to the drug_iv_pilot table:

    • Changing the name of table’s primary key from drug_exposure_id to drug_pilot_id in order to differentiate from the drug_exposure table’s drug_exposure_id.
    • Inclusion of mar_action_name field.

  2. Guidance Clarification on MAR action extraction

    • When targeting which drug admins’ MARs to extract, we are interested in intravenous administrations, particularly continuous frequencies and boluses. If easier, the site can submit all actions from intravenous administrations without filtering and the DCC can filter. * Please extract ALL MAR actions for such administration events, including STOPPED actions.

  3. Guidance Clarification on MAR action loading to the drug_iv_pilot table

  • At minimum, please populate the following fields in the table when present:
  • drug_pilot_id (Arbitrary ID for Table’s Primary Key)
  • person_id
  • visit_occurrence_id
  • drug_exposure_start_date (The MAR action’s taken_time)
  • drug_exposure_start_datetime (The MAR action’s taken_time)
  • drug_concept_id
  • drug_source_value
  • drug_type_concept_id
  • order_group_id (MAR action’s ORDER_MED_ID used to link actions to the same order)
  • mar_action_name (Text value for the action type like New Bag, Rate Verify, etc.)
  • dose_infusion_rate(Numerical value for the infusion rate of that action)
  • dose_infusion_rate_units (Text for the infusion rate unit, most likely a “volume / time” unit)
  • Please still load drug administrations into drug_exposure as normal.
  • Please keep the MARs loaded to drug_iv_pilot separate from your current loading of drug administrations in the drug_exposure table. You are not required to perform any mapping or referencing between the drug_iv_pilotand drug_exposure tables.

Please refer to the Continuous IV Fluid Volume Guidance documentation for for full details.

(3) Fix to 1.16 ADT Occurrence DDL:

It was identified that the PEDSnet DDL did not have Foreign Key Constraints on prior_adt_occurrence_id and next_adt_occurrence_id referencing adt_occurrence_id despite the foreign key relationship being explicitly definted in the ETL Specifications.

Going forward, prior_adt_occurrence_id and next_adt_occurrence_id will have a Foreign Key Constraint applied and reference other adt_occurrence_id values in the adt_occurence table.

Populating these two fields are optional and the enforcement of the foreign key should not impact sites who are already populating them per ETL specification guidance.

Development Code

https://github.com/PEDSnet/Data_Models_Public/blob/master/PEDSnet/docs/Conventions%20Docs/v5.8_PEDSnet_CDM_ETL_Conventions.md

Vocabulary

Related Publications

Creative Commons license

a CC-BY Attribution 4.0 License.
Except where otherwised noted, this item's license is described as a CC-BY Attribution 4.0 License.

Settings

Search Results

Version History

Now showing 1 - 8 of 8
VersionDateSummary
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