Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

Uncoded Medication

General Discussion

Last Post by relliott 10 years ago

10 Posts

5 Users

0 Reactions

88 Views

RSS

relliott

(@relliott)

Posts: 145

Estimable Member

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

abulsara

(@abulsara)

Posts: 150

Estimable Member

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

relliott

(@relliott)

Posts: 145

Estimable Member

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

bruins1986

(@bruins1986)

Posts: 233

Reputable Member

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

Scott Forest

(@sforest)

Posts: 527

Honorable Member

pardon my ignorance but why is this something that would need to be done?

Posted : October 20, 2014 9:18 am

relliott

(@relliott)

Posts: 145

Estimable Member

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

DavidShower

(@davidshower)

Posts: 1255

Noble Member

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

relliott

(@relliott)

Posts: 145

Estimable Member

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

DavidShower

(@davidshower)

Posts: 1255

Noble Member

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

relliott

(@relliott)

Posts: 145

Estimable Member

Topic starter

Thank you David. I will send this to them.

Posted : December 1, 2014 1:28 pm

Share:

24 Forums
9,940 Topics
39.9 K Posts
2 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo Powered by wpForo version 2.4.0