Ohio is now requiring that the duration be printed on prescriptions for controlled substances. Although that information is specified when entering a prescription by typing a number and selecting either days, weeks, or months, I don't see a place where it is housed in either the Medicate or Prescrib table. Is it stored in a place that is not obvious so that I can modify the Ohio prescription form to include it, or is our only option to put that information in the instructions field?
EMR 9.8.13
I don't believe it is saved anywhere. I think it is just an option for populating the stopdate field in medicate, just sort of a calculator.
You could do a calculation, datediff() with prescribe.clinicaldate (should be effective date of controlled substance or clinicaldate of document for everything else) and medicate.stopdate (could be 4700-12-31 00:00:00.000 if no duration or stopdate was added so you have to account for that), and display the number of days. I think that should work but the I would double check with your data.
Thank you for the tip. I think I can work with that.