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

Crystal report vs inquiry for patients due for protocols

CPS, C-EMR, PM

Last Post by Anonymous 1 second ago

4 Posts

3 Users

0 Reactions

62 Views

RSS

JBell

(@jbell)

Posts: 285

Honorable Member

Topic starter

Does anyone have a Crystal report or other report that can pull a list for patients due for certain tests/exams listed in their protocols?

Thanks!

Posted : January 23, 2015 11:16 am

joeg1962

(@joeg1962)

Posts: 843

Noble Member

I am not sure that this is possible. Protocols seem to only be determined within the application, and the MEL {LISTPROTOCOLDUE()}

Posted : January 29, 2015 5:02 am

JillSnider

(@jillsnider)

Posts: 110

Estimable Member

It's DEFINITELY possible. 🙂 You can put all sorts of logic into Crystal Reports. Any SQL query can be incorporated into a CR.

First, you will need to know the obs term ID for the test. This is found in the obshead table. Example: Colonoscopy HDID = 2323 (in our database and used on our forms).

Below is a query I used (I didn't make into a CR but, if you're familiar with CR, it's not hard). This is for folks of a certain age (50-70) who have not had a colonoscopy in the past year.

select p.lastname, p.firstname, p.dateofbirth, p.address1, p.address2, p.city, p.state, p.zip, p.altphone, obsdate, o.obsvalue
from person p, obs o
and p.ispatient = 'Y'
and p.dateofbirth between (sysdate - numtoyminterval(70, 'YEAR')) AND (sysdate - numtoyminterval(50, 'YEAR'))
and p.pid = o.pid
and o.hdid = 2323
and obsdate = (select max(o.obsdate)
from obs o
where o.pid = p.pid
and o.hdid = 2323)
and obsdate < sysdate-3650
Order by p.lastname

Posted : February 4, 2015 3:32 pm

joeg1962

(@joeg1962)

Posts: 843

Noble Member

Thanks Jill. Yes, very possible to re-create the logic of protocols with Crystal - I have many examples. However, none of these are running the very same logic as GE, and I cannot simply to a "LISTPROTOCOLSHORT" command. That is what we are trying to figure out.

Thanks.

~Joe

Posted : February 6, 2015 10:02 am

Share:

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