Erx work Queue with stuck patients and blank meds
Open eRx button find where there is no med.
Double click the patient to bring up the chart write down their patient ID number.
Open Dbviewer…………. Pass. GnbV12#
select * from mrpa Where Pat_Ext_ID='xxxxxxxx' - (copy query into dbviewer replace xx with Patient ID”)
Hit run and verify it is the correct patient (can look at patient name fields) Write down the PTID number
select * from mrrxwl Where Status='C' and PTID='xxxxx' - (copy into dbviewer replace xx with PTID )
***NOTE if you get an error do not continue!!!
Highlight entry and press the delete key on the Keyboard
Then hit update in DBVIEWER