[MEDITECH-L] need help speeding up an NPR report

[Lambert, Barbara]

I have an NPR report looking for all patients IN HOUSE currently on
Coumadin. This reports takes at least 15 minutes to run, no matter what
index I try.

I have tried these - and all run slowly.

I have a macro with the drug mnemonic and the locations and the status
of the RX is "AC".

Any hints to help make this run faster so that it can be used by the
Dieticians? They have the pharmacy search capability, but would rather
have a regular NPR report to run.

Thanks in advance.

Barb Lambert

Sr. Systems Analyst

Sinai Health System

Chicago

[Lawrence, Mitchell]

Since you are doing it for inhouse patients, why not start in ADM.PAT,
use the room.bed.index (inhouse patients) and just check each patients
RX? Seems like that would be a lot faster.

Thank you,
Mitch Lawrence
Lead Applications Analyst
Technical Support - NPR/Automation
CHRISTUS Information Management
(tm): Mitchell...@CHRISTUSHealth.org

Send a "thank you" to someone!

[Thompson, Jeff]

Try writing it out of the PHA.PAT using pha.patient.room.index and then
look at those RXs. That will greatly reduce the amount of patients you
are looking at.

Jeff Thompson,RPh
Newman Regional Health
Emporia, KS

-----Original Message-----
From: meditech-...@mtusers.com
[mailto:meditech-...@mtusers.com] On Behalf Of Lambert, Barbara
Sent: Friday, October 26, 2007 7:41 AM
To: medit...@MTUsers.com
Subject: [MEDITECH-L] need help speeding up an NPR report

[Roger Beverly]

Here is a report that I use to search for pts on a list of meds. I loop
through the pha.pat room.bed index with a start macro to build a list of
patients. Then search for the meds entered at runtime. Hope this helps.

Roger
Roger Beverly, PharmD
Clinical Coordinator, Pharmacy Dept
Conway Medical Center
Conway, SC
843.347.8120
rbev...@cmc-sc.com

-----Original Message-----
From: meditech-...@mtusers.com
[mailto:meditech-...@mtusers.com] On Behalf Of Lambert, Barbara
Sent: Friday, October 26, 2007 8:41 AM
To: medit...@MTUsers.com
Subject: [MEDITECH-L] need help speeding up an NPR report

Thanks in advance.

Barb Lambert

Sr. Systems Analyst

Sinai Health System

Chicago

Conway Medical Center Disclaimer
The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you
T20070801

[cea...@hsd.cccounty.us]

I think that if you write the report in PHA.RX with the detail segment of pha.rx.file and the index file of pha.rx.active.index. Then you need to have your
SELECT
on page 2 set up to include dc.date.or.active EQ "~". This is because all orders in Meditech only have a status of Active or DC'd (THey have different
STATUS FLAGS but only 2 status's) IF the order is not DC'd or CANCELed, it is ACTIVE. An order on hold (deactivated) is ACTIVE). I have one written with
status = "AC" and one written like above and this one runs faster, but they are slightly different reports.

This e-mail message, including its attachments, is for the sole use of the intended recipient(s) and may contain confidential or privileged information. Any
unauthorized review, use, disclosure or distribution
is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

"Lambert, Barbara" <la...@sinai.org>
Sent by: meditech-...@mtusers.com
To
<medit...@MTUsers.com>
10/27/2007 11:41 AM cc

Subject
[MEDITECH-L] need help speeding up an NPR report

Thanks in advance.

Barb Lambert

Sr. Systems Analyst

Sinai Health System

Chicago

(See attached file: image004.jpg)(See attached file: image005.jpg)(See attached file: image006.jpg)

[Bill Mullins]

Yes, see attached report, takes around 5 seconds to run.

-----Original Message-----
From: meditech-...@mtusers.com
[mailto:meditech-...@mtusers.com] On Behalf Of