PEDSnet Common Data Model, v5.7
Created
Submission Date
Data Collection
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 v5.7
(1) Update to 1.6 Visit_Occurrence Guidance
Beginning in version 5.7, the PEDSnet data model will now allow visits marked as cancelled in source EHR systems if the following conditions are held:
- The visit has a source value in the EHR containing terms such as “
cancel”, “no show”, “not seen”, etc.- The visit’s
visit_occurrence_idis a foreign key in at least 1 clinical fact record in at least one of the following PEDSnet CDM tables:
- condition_occurrence
- procedure_occurrence
- drug_exposure
- measurement
- immunization
- device_exposure
- observation
- adt_occurrence
- measurement_organism
The previously underutilized visit_source_concept_id field will be leveraged to distinguish between cancelled and non-cancelled visits.
For cancelled visits, please set
visit_source_concept_id=2000001590“Visit flagged as cancelled in source EHR system”.For all other visits, please set
visit_source_concept_id=0.
Additional Notes:
Internal analyses concluded that generally, if a canceleld visit still has clinical facts associated, then most likely a patient interaction with a provider occurred. The visit may have been incorrectly categorized as cancelled due to administrative error or post-visit quirks in billing.
Do not include cancelled visits that only have a foreign key reference from a visit_payer record. Payment information may be captured prior to a visit occurring. Without any other clinical fact records linked, it is not likely that a patient interaction with a provider actually occurred (I.E. the visit is correctly marked as cancelled.
(2) Introduction of the Continuous Infusion Volume Derivation Pilot
In order for the PEDSnet DCC to derive total administered volumes for continuous IV infusions, we are asking sites pilot the following:
- Extract ALL MAR actions for continuous administrations.
- Load the MAR actions into the
drug_iv_pilottesting table added to the PEDSnet DDL for version 5.7.The
drug_iv_pilottable duplicates the structure of thedrug_exposuretable with three additional fields necessary for the derivation:
dose_infusion_rate- Numerical value of the bag’s infusion rate.
dose_infusion_rate_units- Unit associated with the bag’s infusion rate.
order_group_id- ID for grouping MAR actions for the same ordered bag together.
Please refer to the Continuous IV Fluid Volume Guidance documentation for for full details.
NOTE that this pilot should be separate from your current loading of drug administrations in the
drug_exposuretable. Please still load drug administrations intodrug_exposureas normal.We would like to be able to compare between currently loaded
effective_drug_dosevalues and our derivedeffective_drug_dosevalues.
(3) Guidance on Modeling New OMB Race and Ethnicity Categories
If your institution has begun collecting race and ethnicity information utilizing the updated OMB categories, to align with OHDSI guidelines, please utilize the following guidance for modeling these categories in the PEDSnet Data Model:
- If a patient has a single Race category:
- Utilize corresponding
race_concept_idoptions in thepersontable.- Addition of new
race_concept_idoption for “Middle Eastern or North African”concept_id=38003615.
- If a patient has multiple Race categories:
- set
race_concept_id=44814659“Multiple Races” in thepersontable.- Insert 1 record for each selected race category into the
Observationtable whereobservation_concept_id=3050381(“Race or Ethnicity”) andvalue_as_concept_idequals the concept_id representing the individual category.- Accepted concepts can be found in the concept table where
vocabulary_id in ("Race","Ethnicity").- If date of encounter is available for the race and ethnicity information, use that date to populate
observation_date. Otherwise, setobservation_date= patient’s birth date
(4) Update to 1.12 Measurement Guidance
To align the vocabulary of the measurement_concept_id used for “Inspired Oxygen Concentration” to LOINC, we ask to change the measurement_concept_id used from the SNOMED concept_id = 4353936 “Inspired oxygen concentration” to the LOINC concept_id = 3020716 “Inhaled oxygen concentration”.
Vocabulary
Related Publications
Creative Commons license
Version History
| Version | Date | Summary |
|---|---|---|
7* | 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 |