Update obs_clin script
Closed this issue · 1 comments
burrowse commented
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
burrowse commented
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