How to calculate dose info from inputevents using (missing) drugs prescribed

[SSMK-wq]

Prerequisites

• Put an X between the brackets on this line if you have done all of the following:
  • Checked the online documentation: https://mimic.physionet.org/about/mimic/
  • Checked that your issue isn't already addressed: https://github.com/MIT-LCP/mimic-code/issues?utf8=%E2%9C%93&q=

Description

Hello Everyone,

I am trying to extract the dose of sedation drugs which are not available directly under dose_val_rx column in prescriptions. Instead it is stored as 100,250 etc. I referred the doc and this related post to find out that we have to refer the inputevents_mv/cv tables to find the actual dose (drugs are mixed with solutions etc). The below screenshot shows the drugs in prescription table with not desired dose value (for me). When I tried looking for these items in d_items and d_labitems table, I couldn't find the items marked in red.

Please note that the below is an example. The dose value might be acceptable for modafinil. But what I am trying to know is how to handle missing items like chlorpromazine?

Questions

1. How do I find the dose for the missing items? They are present in prescriptions but the drug item is missing in d_items or d_labitems. So without itemid, I may not be able to look up for it in inputevents table to find out the rate information. what should I do to find the dose of these drug items?

Thanks

[alistairewj]

The input tables will only have intravenous medications. The examples you gave are probably oral medications. As such, the only place they will be documented is in the prescriptions table (as that is essentially a medication orders table). The care providers tend not to document non-IV drugs in the ICU information system (though some exceptions do exist).

[SSMK-wq]

Thank you. got it. Appreciate your inputs.