We upgraded from CEMR 9.8 to 9.12.2 back in October. Our providers absolutely do not like the new Rx Renewal Tab and the new Prescriptions refill form.
One thing that we did notice is that the "Requested Date" on the Renewal tab seems to be updating every day. It looks like the DB_UPDATED_DATE from the erxrefillrequest table is updated from maybe a nightly job? and this is what is being pulled to be displayed as the "Requested Date" on the Renewal tab.
We have a SPR created with GE but I just wanted to see if anyone else is experiencing the same issue?
Thanks.
Your exactly right, it's looking at the DB_UPDATED_DATE. Ideally, it would be showing the DB_CREATED_DATE.
We have discovered there is a trigger on that table which updates the DB_UPDATED_DATE.
There could possibly be a job that is running but it would have been custom to your clinic. We came across the same issue and modified the job to just touch the renewals that come in during the current day.
We just upgraded to CPS 12.3 SP2 (Chart Only with Group Management) and we are also seeing this issue. What's strange is that it doesn't affect all of our providers- we have 1 that the renewal form drops off correctly after filling. We've ran the eSM configuration utility but that had no effect. A few other issues we are having--
- Last refill date error in eSM console.
- Rx Renewal form component not updating but the text does (when changing directions / instructions, clicking the 'Renewal' button, etc). Upon putting the document on hold and opening again it does refresh.
- Medication name mismatch so we get a 700 pubtime error.
- Address Line 1 issue. I guess this is specific to Group Management and how it sends over demographics in Line 2 instead of Line 1 in Registration.
- Sign Rx button not working (intermittent).
Console is filled with 700 and 900 errors daily.