Repository navigation
Medication table: drugstartoffset greater than drugstopoffset #251
Description
Hello,
I am working on a project for which I need to extract medications with their start and stop times and use them to calculate the number of administered doses. I noticed that more than half of my extracted medication orders have 'drugstartoffset' value greater than or equal than 'drugstopoffset'.
For one-time orders e.g. frequency=once with equal start /stop, can I assume the dose was given?
What about other scheduled orders e.g. frequency=q 8 or q 6, in case of equal times and start>stop?
Thank you
@obadawi
Activity
goolelike commentedon Jan 11, 2025
I encountered the same issue and wanted to ask if you have already resolved it. Could you let me know the solution to this problem?
momarsaad commentedon Jan 17, 2025
@goolelike I couldn't solve it so I thought I would run a sensitivity analysis excluding those patients. Please let me know if you find any further information about it
goolelike commentedon Mar 30, 2025
”SELECT
patientunitstayid,
CASE
WHEN drugstopoffset = 0 THEN drugstartoffset
WHEN drugstartoffset <= drugstopoffset THEN drugstartoffset
WHEN drugstopoffset < drugstartoffset THEN drugstopoffset
END AS drugstartoffset,
CASE
WHEN drugstopoffset = 0 THEN NULL
WHEN drugstartoffset <= drugstopoffset THEN drugstopoffset
WHEN drugstopoffset < drugstartoffset THEN drugstartoffset
END AS drugstopoffset,
drugorderoffset“The official release shows this