Dear all,
Finalising the first iteration our new ICU OMOP ETL, I’ve gotten stuck on an issue that is perhaps quite idiosyncratic to emergency, intensive and peri-operative medicine: fluids as drugs. Fluids are both given in their own right for volume expansion but relatively large volumes actually come from the solvents in infusions of active ingredients. One prominent example is patients with septic shock who, often, receive vast amounts of intravenous fluids (see, e.g., table 2 (p. 2464) here: https://www.nejm.org/doi/pdf/10.1056/NEJMoa2202707). Thus, in our setting (intensive care), the need to capture and express this in our CDM is real as it’s an important aspect of our patient’s phenotype.
I believe the administration of intravenous fluids should yield one drug exposure (and the unit should be mL or L), while every administration of a drug infusion should yields two drugs exposures: the active ingredient (unit something like mg, mmol or IU) and a certain solvent volume given to the patient. Here are a few simple examples that represent our source administration data:
drug_name | start | end | amount | amount_unit | volume_ml | solvent |
---|---|---|---|---|---|---|
norepinephrine | 2023-01-01 06:00:00 | 2023-01-01 07:00:00 | 4.8 | mg | 6 | Isotonic saline |
ringer_lactate | 2023-01-01 06:00:00 | 2023-01-01 10:00:00 | NA | NA | 1000 | NA |
novorapid | 2023-01-01 07:00:00 | 2023-01-01 08:00:00 | 10 | IU | 10 | 5% in NaCl |
Essentially, these 3 source rows should produce 5 drug exposure rows (2 for the active ingredients and 3 for the given volumes). Having queried drug_strength
(also through concept_ancestor
) and concept_relationship
(looking for any relationships involving units that are standard concepts), I cannot find a good way to do this as the quantity of e.g. NaCl would resolve to mmol, it seems, which isn’t what I want to represent.
There are some threads around regarding infusions, but they focused more on how to capture infusion rates which is distinct from this challenge; since we have those data as well, I’d be happy to know if the community landed on any conventions in this regard as the threads didn’t really seem to suggest so.
I’m aware I might be missing something obvious, and in that case I hope to be enlightened. If we do turn out to be the first ones with this challenge, I’d be happy to chip in with a proposed solution and would greatly appreciate if you could point me to the good people with whom I should discuss this. Also, if others have similar data, I’d love to hear from you–especially if new community conventions are to be devised.
Cheers,
Ben