To work on the quality of the database I am trying to find easy tools, but the system is a little primitive. In our office one physician was asking the MA's to enter the medications. This resulted in the database being corrupted as 'lasix' and 'furosemide' are both entered. To identify those patients, (to be forwarded back to the guilty party) we can search for Lasix, then for furosemide, then compare the lists manually and pull the chart numbers that appear twice. Not ideal.
I am trying to understand the problem. Are you saying that there are patients whose medication list contains both Lasix and furosemide, as if they were two separate medications?
