I apologize for any duplication of effort, but I have been researching the forums looking for the topic on the accurate population of the prescribed dosage from a drug order. I have seen references to attributes coming and going over the past 3 years. The existing posts have solutions that rely on columns such as effective_drug_dose or dose_unit_concept_id that were removed only to be requested again later.
We are taking prescriptions from the order entry system in the pharmacy and ultimately persisting them into OMOP in real time. In this type of live processing we don’t have the ability to perform extensive ETL that brings in other sources and possibly human intervention. The goal is to land the data and then post-process the data to prepare it for analysis.
The drug_exposure table as of V5.3 (current version is 6) included quantity (which is not dose) and dose_unit_source_value (which is not the unit associated with quantity).
The effective_drug_dose and dose_unit_concept_id were removed. By association the dose_unit_source_value should have also been removed because it was associated with dose_unit_concept_id. There has been discussion of a field called quantity_unit_concept_id but I have never found such a field in any historical CDM documentation.
While I can add fields and populate them locally, it won’t help downstream processing because the Atlas tooling in any release relies on the OMOP core schema.
In case you are curious, my sources are HL7v2 RDE Medication Orders, HL7v2 RAS Medication Administrations, HL7v2 DFT Detailed Financial Transactions (for MAR events), HL7 FHIR MedicationRequest and MedicationAdministration resources. All of these HL7 source standards have a medication dose, rate, and quantity as individual elements with related units. I’m looking for how these map to the Drug_Exposure table and I am having problems.