-
Notifications
You must be signed in to change notification settings - Fork 213
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Finding start and end time for infused drugs from the eICU infusionDrug table #230
Comments
Hi @lasiadhi, I think we need to do some more work understanding this. @obadawi may be able to provide insight here. For most of the studies we have conducted thus far we have focused on presence/absence of drugs, but knowing dosage/duration is of course important too. Working through your example, I would read it this way (keep in mind, I could be wrong!):
The precision of the measurements and offsets is largely going to depend on the way the data is collected. If this is charted data, then it's not surprising that everything is done at hourly intervals, and the numbers only roughly work out. If the data is automatically collected, then the durations are probably much more accurate. AFAIK there is no way to determine which is the case, other than exploring the data and drawing your own inferences. Indeed, the data is difficult to work with. I would recommend focusing on a single hospital and a single drug first, and then trying to generalize to other hospitals and other drugs. Jesse |
Thank you very much @jraffa for the explanation and for taking the time to do all the calculations! I really appreciate it. In the Nitroglycerin example, as you mentioned, the patient got 3 hours @ 10mcg/min and 3h @ 20mcg/min. That means the total drug amount given was 5400 mcg within 6 hours. If I am correct, that is equal to 5.4mg (?) (not 54mg). Then I am not sure how to relate that to the 50mg drug amount. Anyway, I will go through more examples as you recommended. This is very helpful. Thank you, Jesse! -- Lasith |
Hi @jraffa, @alistairewj , @obadawi and all, If we revisit the Heparin example above, the infusion starts at 59min and ends at 1379min according to the infusionDrug table. However, if we look at the same patient stay in the medication table (see below), the Heparin drug was started at 19min and ended at 1425min. |
The medications table will represent the "order" as it was verified by the
pharmacist. The pharmacists will generally estimate the start time or round
to standard times such as 8am and 8pm. For oral medications, this will be
the closest assumption you can make as there is no other record of the
actual medication administration time. For a continuous infusion like
heparin, the nurse will chart the time the medication is actually started
in the flowsheet and this should be considered the most accurate time. The
provided example seems very reasonable that the pharmacists may have
provided an immediate start time while verifying the order at 19 minutes
but it took another 40 minutes for the medication to actually be dispensed
and initiated for the patient at 59 minutes. Then the heparin was likely
decided to be discontinued at the bedside and stopped at 1379 with the
pharmacist shortly after verifying the stop order.
…On Wed, Sep 6, 2023 at 10:49 AM Lasith Adhikari ***@***.***> wrote:
Hi @jraffa <https://github.com/jraffa>, @alistairewj
<https://github.com/alistairewj> , @obadawi <https://github.com/obadawi>
and all,
If we revisit the Heparin example above, the infusion starts at 59min and
ends at 1379min according to the infusionDrug table. However, if we look at
the same patient stay in the medication table (see below), the Heparin drug
was started at 19min and ended at 1425min.
Which offset time should be considered more reliable for determining the
start and end of this drug? Are there any other concerns related to time
offsets in the medication table for infused drugs? Thank you!
[image: image]
<https://user-images.githubusercontent.com/20522961/266094027-1bb68379-ca27-402b-ac8d-ba65bcb7e9e2.png>
—
Reply to this email directly, view it on GitHub
<#230 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/AD6USVFQADUJLN5CWJQHILDXZCZSXANCNFSM6AAAAAA32FE4VM>
.
You are receiving this because you were mentioned.Message ID:
***@***.***>
|
Thanks, Omar (@obadawi) for the explanation! This is very helpful to understand the big picture here and how these tables are linked to each other. I believe the last Heparin 5000 UNIT/ML order [not cancelled] is not in the infusionDrug table because it was not continuously administered (?). Thanks again! -- Lasith |
In the infusion drug table, we have only one timestamp: infusionOffset (see table schema below). I am wondering how to find the start and end offset time for each infused drug in the table.
![image](https://private-user-images.githubusercontent.com/20522961/262408633-1d18875c-5559-46ef-bc12-e83b0b60f539.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjQ3NzkzNDYsIm5iZiI6MTcyNDc3OTA0NiwicGF0aCI6Ii8yMDUyMjk2MS8yNjI0MDg2MzMtMWQxODg3NWMtNTU1OS00NmVmLWJjMTItZTgzYjBiNjBmNTM5LnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNDA4MjclMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjQwODI3VDE3MTcyNlomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTdkYjIwZDk2ODIzMWNkODI2ODI3NmFlN2ZjNzA3MmFkODQ1MDgzNzc1NDEyNjI4N2ViNWY1MGQxZjYzMGE4NDImWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0JmFjdG9yX2lkPTAma2V5X2lkPTAmcmVwb19pZD0wIn0.KKeujAUw4vRznTc36kWF7SNsYprBE7qhICUu4SLPD8k)
It is not clear if the given infusionOffset is for the start of the infusion or the end of the infusion. Assuming it is the endoffset time, I am wondering how to calculate the start offset using drugRate, infusionRate, drugAmount, or/and volumeOfFluid, etc. Since a patient can have multiple records of the same drug, it is not clear if it is completed/stopped/in progress before the next drug entry. See the example below for the patientUnitStayID = 242380:
Please let me know if you have any idea how to use/read this eICU-infusion drug table to find start and end times. Thank you!
The text was updated successfully, but these errors were encountered: