Notifications
Clear all
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
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
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
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
