juggernautsei wrote on Wednesday, March 02, 2016:
Working with an anesthesiologist that needs to show morphine drug decreasage over time. I have looked into the prescrition table and the system does not insert a new line, it only updates the existing prescrition for that drug.
The anesthesiologist is unable to use newcrops in his state TN.
UPDATE:
I finally thought to look into the log table and there I found the order-replace entry for the prescrition.
(wish there was a way to delete entries)
sunsetsystems wrote on Wednesday, March 02, 2016:
Similarly with changes to patient attributes and other things. There’s definitely work that needs to be done with respect to saving past information. The log is not a replacement for this, something more integrated is needed.
juggernautsei wrote on Friday, March 04, 2016:
While I am working over here. Is there any suggestion you could make to spark a path.
I was able to find the information needed but there is gonig to be a lot of work to make it usable in a graph. Once I manually go through and pull out the data and import it into a new table. I will attempt to automate the process.
As far as the drug table go, I have been poking around to see where I can redirect the change capture into the prescription log table directly.
Appreciate the feed back.
fsgl wrote on Friday, March 04, 2016:
The G option of a LBV form is good way to plot values over time.
Track Anything has additional features if drug dose is the ordinate while date/time is the abscissa.
sunsetsystems wrote on Friday, March 04, 2016:
I would start by looking up all code that accesses the prescriptions table and understanding how it works, including the Newcrop stuff. There’s probably a reasonable way to store historical versions of each Rx in there, but all the code needs to cooperate.
juggernautsei wrote on Tuesday, March 08, 2016:
This looks like a great tool for LBF’s but unfortunately the prescriptions are not an LBF and won’t work for what I desired. I wish it did. This would end my quest.
fsgl wrote on Wednesday, March 09, 2016:
It is not necessary to have a LBV form to use Track Anything. In fact you probably don’t even need the Prescription module if the task is to graph doses of a particular med over time.
For example Morphine can have one graph, Hydrocodone another & Fentanyl still another.
The titles of the graphs will appear under Prescription.
.
I’m not aware of a method of having all 3 graphs superimposed onto one graph.