PEDSnet/pedsnetcdm_to_pcornetcdm

Update obs_clin script

Closed this issue · 1 comments

Based on #525 and the PCORnet v6.0 conventions it appears the obs_clin script needs to be updated to include some measures:

Current list of elements:

  • previous vital table data (bp, height, weight, tobacco,bmi)
  • Vaping
  • Temperature
  • Respiratory Rate
  • Heart Rate
  • FiO2
  • SpO2

PCORnet Conventions

The OBS_CLIN table is intended to store standardized clinical observations that have been recorded about a patient.
 Examples of the types of observations that can be stored in this table include pulmonary function test results (e.g., FEV1, FVC, FEV1/FVC), echocardiogram results (e.g., left ventricle ejection fraction) and vital signs. 

Candidates of elements to be added from PEDSnet Data:

  • MAP
  • Pulmonary Function Testing
  • SpO2/FiO2 **Combined metric stored in OBS_GEN

Adding details to understand the number of records (estimated from pedsnet_v43) that would be brought in for each site:

MAP

select site,count(*)
from dcc_pedsnet.measurement
where measurement_concept_id
in (
	21490852, --Invasive Mean arterial pressure (MAP)
	21492241) -- Non-Invasive Mean arterial pressure (MAP)
group by site;
  • **Significant amount of records but should not trigger the "persistence increase" flag in PCORnet.
  • Both concept_ids are "Clinical Observations" so obs_clin is appropriate home.
site number of measurements
"chop" 17196139
"colorado" 934569
"nationwide" 15044743
"nemours" 18995701
"seattle" 11190615
"stanford" 29096051

Pulmonary Function Testing

select site,count(*)
from dcc_pedsnet.measurement
where measurement_concept_id
in (
3020158,--		See Note 1	FVC	
3037879,--		See Note 1	FVC pre (if recorded differently)	
3001668,--	See Note 1	FVC post	
3024653,--	See Note 1	FEV 1	
3005025,--	See Note 1	FEV 1 pre (if recorded differently)	
3023550,--		See Note 1	FEV 1 post	
42868460,--		See Note 1	FEF 25-75	
42868461,--		See Note 1	FEF 25-75 pre (if recorded differently)	
42868462,--		See Note 1	FEF 25-75 post	
3023329)-- Peak Flow (PF)
group by site;
  • All concept_ids are "Clinical Observations" so obs_clin is appropriate home.
site number of measurements
"chop" 1405264
"colorado" 132974
"nationwide" 84403
"nemours" 229979
"seattle" 89086
"stanford" 91140

SpO2/FiO2

  • **Combined metric stored in OBS_GEN per PCORnet COVID-19 conventions.
  • We are already populating this data in the PCORnet scrips.
  • No changes needed