Notifications
Clear all
Topic starter
We are having difficulty finding a way to identify patients with "uncoded medicattions" on their list after a monthly KB update is done. If the patent had the med previously prescribed when it was "coded" and now becomes "uncoded" we can't identify those easily to remove from the patient chart. Any suggestions on how to manage this?
Thx
Posted : October 20, 2014 8:02 am
GE does not provide a way for you to identify which Patients have UnCoded Medications on their Problem List. The only report that you can run for Uncoded Medications is the Uncoded Medications on Custom Lists.
Below is the query that I run against the database to identify which patients have those Un-Coded Medications on their Problem List:
select pp.searchname, pp.Birthdate, m.DESCRIPTION, m.NDCLABPROD, u.LOGINNAME as prescriber, lc.ABBREVNAME as Facility from vActiveMedicate m inner join PatientProfile pp on pp.PId = m.PID inner join USR u on u.PVID = m.PUBUSER inner join LOCREG lc on lc.LOCID = pp.LocationId where m.NDCLABPROD is null and pp.pstatus = 'A'
order by pp.PId
I hope this helps.
Posted : October 20, 2014 8:18 am
Topic starter
Thank you. I couldn't find any report for the actual patient chart either. We already run the Uncoded Meds report, but that doesn't help identify the pts with the uncoded med.
Posted : October 20, 2014 8:33 am
Do you have access to crystal reports? Basically all you would need to do is link the MEDICATE and PERSON table via the PID field and then add a filter that you'd like. The biggest overarching filter would be:
Isnull({MEDICATE.NDCLABPROD}) and
{MEDICATE.CHANGE} in [1,2]
That would basically say "show me any medications on a patient that do not have an NDC number".
you could add additional filters based on preference (like date ranges).
Posted : October 20, 2014 9:08 am
pardon my ignorance but why is this something that would need to be done?
Posted : October 20, 2014 9:18 am
Topic starter
Scott, Each month that a KB update is done, the system removes medications that become uncoded, but if the patient was prescribed the medication prior to it being removed the medication does not indicate that it is now uncoded. Therefore the provider can continue to prescribe it without knowing that it is not a coded medication any longer.
Hope that makes sense. Thx
Posted : October 20, 2014 12:49 pm
Here is a great thread on this topic. Also discusses adding a pop-up to indicate uncoded meds in a patient's Medication list.
https://centricityusers.com/forum/how-to-know-when-patient-has-uncoded-meds/
Posted : October 28, 2014 4:15 am
Topic starter
Good morning abulsara, I had given the query you posted above to our DB experts but they had a problem with setting this up (see response below). We are on EMR9.8, should this query work in our system?
The SQL query mentioned contains 4 tables i.e. [vActiveMedicate, PatientProfile, USR, LOCREG] but vActiveMedicate, PatientProfile tables don’t exist on database EMR where USR and LOCREG exist on database. So, when I tried to run this query, it gave the error.
So, could you please confirm the exact query you need by which we can work upon it as per the requirement?
Posted : November 24, 2014 5:31 am
Here is the query transformed for EMR
select pp.searchname, pp.dateofbirth, m.DESCRIPTION, m.NDCLABPROD, u.LOGINNAME as prescriber, lc.ABBREVNAME as Facility from ml.medicate m inner join ml.person pp
on pp.PId = m.PID inner join ml.USRinfo u on u.PVID = m.PUBUSER inner join ml.LOCREG lc on lc.LOCID = pp.homelocation
where m.NDCLABPROD is null and pp.pstatus = 'A'
and m.xid = 1.e+035 and m.stopdate > sysdate
order by pp.pid
The line and m.xid = 1.e+035 and m.stopdate > sysdate keeps you from getting inactive medications.
Posted : December 1, 2014 1:05 pm
Topic starter
Thank you David. I will send this to them.
Posted : December 1, 2014 1:28 pm
