Medication table: drugstartoffset greater than drugstopoffset

[momarsaad]

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

[goolelike]

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]

@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]

”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