search

PennTURBO / semantic-engine

TURBO semantic engine (Drivetrain). Transforms source-dependent RDF data into a source-independent, semantically rich RDF model.
6 stars 0 forks source link

Not all drug_exposures are prescriptions per se #36

Open turbomam opened 5 years ago

turbomam commented 5 years ago

OMOP differentiates prescriptions from dispensations (?), and both cases are present in the Synthea data set

drug_type_concept_id count concept_name
38000177 8468 Prescription written
581452 22798 Dispensed in Outpatient office

We have been saying that prescriptions are the output of an encounter.

Should we say something different/more concreted about the "Dispensed in Outpatient office" cases? It will probably take at least another day to model and will probably require some white-boarding.

turbomam commented 5 years ago

Check if the "Dispensed in Outpatient office" are all vaccines anyway. Prioritize drugs over vaccines.

turbomam commented 5 years ago
Row Labels CVX RxNorm
Dispensed in Outpatient office 14695  
Prescription written   8452 
select
    vc.vocabulary_id,
    tc.concept_name
from
    cdm_synthea10.drug_exposure de
join cdm_synthea10.concept vc on
    de.drug_concept_id = vc.concept_id
join cdm_synthea10.concept tc on
    de.drug_type_concept_id = tc.concept_id