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