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

MEL to list past medications stop/start dates for LDL managment

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

3 Posts

3 Users

0 Reactions

51 Views

RSS

czelnick

(@czelnick)

Posts: 31

Trusted Member

Topic starter

Hi, trying to figure out a way to build a (text) table to show LDL-C compared to when medications were begun, changed, etc (to work with guidelines that say LDL should be lowered to 30-50% or pretreatment levels)

ideally it would end up showing something like

LDL value(date) Statin 1 start/stop date

LDL value 2(date) Statin start/stop date

etc.

Does anyone know a function or way to list all the past statins and when they were stopped/started?

Maybe there is a better solution.

Posted : January 21, 2017 3:39 am

jfitzmd

(@jfitzmd)

Posts: 419

Reputable Member

Simplest is to use GPI code to identify statin, initial 4 digits 3940, then retrieve all data into array via Meds_After("delimited"), extract the rows and fields using getfields(), then process the array. If you want a code example, contact me directly.

Posted : January 21, 2017 8:21 am

joeg1962

(@joeg1962)

Posts: 843

Noble Member

Below is a snippet of the Crystal Report I built once before to help with a similar question. And the .rpt definition is included at the very bottom.

Essentially printing one page per patient, and printing a chronological report of LDL labs and statin prescriptions over the past few years. The report only prints for patients 40-75 years old, and with the last LDL >= 110.

Feel free to use the report. Be warned, it may take a while to run. I think I ran for sections of patients (last names A-H for example). And some things like 'Team" were specific to my site.

And let me know any thoughts, suggestions.

d125 Patients LDL tracking 3

Posted : January 23, 2017 2:38 am

Share:

24 Forums
9,940 Topics
39.9 K Posts
0 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