[MEDITECH-L] EDM TAT report for Physician Assignment

[Akhtar, Sohail]

Hi All,

I am trying to create EDM TAT report based on Physician Assignment date
and time. We want to check time between patient arrival to seen by
physician. Our physicians after completing the medical screening click
on Assignment tab on the tracker to place their name as ERDOC. I want to
capture this time when they place their name after clicking Assign tab.
Problem is our Nurses use the same Assign tab to place their name as
staff nurse. They both are setup respectively as PHYSICIAN and NURSE as
staff type. How can I include this as if the staff type who click on
Assign tab is PHYSICIAN then give me the time otherwise ignore it.
Following is the Macro I have so far and it is giving me the first time
which obviously would be the NURSE time. I know it would be simple for
most of you but I just have my 40's moment and cannot come up with the
solution. We are C/S 5.55. Thanks in advance for any help.

"PHYS"^staff.hx.type,

""^/STAFF.DATE^/STAFF.TIME^staff.hx.edit.time,

DO{@Next(staff.hx.edit.time)&'/STAFF.DATE IF{'@staff.hx.user;

@staff.hx.old.value="ERPHYS" @GET.DATE.TIME;

@GET.DATE.TIME}}

GET.DATE.TIME

%Z.date.in.magic(staff.hx.edit.time)^/STAFF.DATE,

%Z.time.out(staff.hx.edit.time)^/STAFF.TIME

Sohail Akhtar

Systems Analyst

West Virginia University Hospital East

Jefferson Memorial Hospital

Ph: 304 724-3552

Cell:304 268-2331

sak...@jeffmem.com <mailto:sak...@jeffmem.com>

====================================

Please do NOT send messages that ask "Please post to the list" These are useless messages that just waste the email server's resources. Instead, email the original requester and ask that they send you or post the results of their question.

To UNSUBSCRIBE, go to http://MTUSers.net
for information.

The meditech-l archives (and other tips) can be found at
http://mtusers.net/zarchives

Job opportunities in the Meditech community can be found at
http://mtusers.net/zjobs

[Christensen, Katherine A.]

Does anyone have a report that groups information by patient age range?
Such as average length of stay for patient 0-17 years old. Similar to
the ABS standard statically report.

I need to write a bucket report out of BAR.PAT but if you have something
similar in a different module, I would like to see it. I am not sure
how to get the report to group by age.

Thank you,

Kathy Christensen, M.S.
Application Support Specialist
Information Systems
Phone: 507-385-5673
Email: Christense...@mayo.edu
________________________________
Immanuel St. Joseph - Mayo Health System
1025 Marsh Street
Mankato, MN 56001

[Borg, Jeannie]

We accomplish measuring this metric by using status events.

Receiving the patient auto advances to a status event of RECPT.
When the doc signs up the status event automatically advances to the status event of C MRP (with MRP).
We are able to easily measure between the two using the GPA tool right in Meditech.

This has the added advantage of alerting the nurse that at least the doc has pick up the chart and is headed to the patient sooner than later.

We also have our physicians marking when they place ORDERS and D/C ORDERS because they wanted to measure these two time stamps. These are manual but we have about 85% compliance. We have very few status events. We really only have status events for time stamps that we want to measure, so that they become important to the staff.

Have a great weekend.

Jeannie Borg, RN ENC(C)
Professional Practice Lead - EDM
Joseph Brant Memorial Hospital
1230 North Shore Blvd.
Burlington, Ontario L7R 4C4
' 905-632-3730 ext 3466
Ê 905-681-4832
7 jb...@jbmh.com
Best People, Best Care, Healthiest Community

[Joe Cocuzzo]

Create a computed sort field like this:

xx.age.bucket
DAT=INT
LEN=3
VAL=IF{%Z.age.in.years(@birthdate,@bar.adm.ser)^AGE<18 1;
VAL=AGE<30 2;
VAL=AGE<60 3;
VAL=AGE<90 4;
VAL=AGE 5}

Then your report will sort pts by age in years in buckets and you can do whatever calculations you need to. Make the breakpoints of the IF statement appropriate for the buckets you would like to use. Don't forget that if you use < the endpoints are not included, so the IF statement above is doing 0-17, 18-29, 30-59, 60-89, and over 90

If any patients lack a dob, they will get a xx.age.bucket of nil and the report writer will sort them at the top (by a space in the temp sort file, actually).

Using the %Z.age.in.years program avoids the problem with ages under 6 years, which MT represents in years and months, or months and days, which can mess up the ASCII sorting of values.

If you need to have the data go across the page, the programming gets quite a bit more complicated because you cannot use the standard FNC=AVG kinds of fields as the denominator of the group isn't the record count anymore.

Hope this helps.

Joe Cocuzzo
Vice President
NPR Services
Iatric Systems, Inc.
Phone/Fax: (978) 805-4115
Email: mailto:Joe.C...@iatric.com
Web: http://www.iatric.com/

Iatric Systems is a leading provider of integrated software applications, interfaces and reporting solutions for hospitals and healthcare systems.
__________

-----Original Message-----
From: meditech-...@mtusers.com [mailto:meditech-...@mtusers.com] On Behalf Of Christensen, Katherine A.
Sent: Friday, July 03, 2009 11:31 AM
To: medit...@mtusers.com

[Gail Hardie]

Hi Sohail,

When our MDs sign up the Status Event autoadvances to C DOCTOR (and only
files once).
To get each patient's time I use:

DAT=HHMM
JFY=L
LEN=4
VAL=IF{%Z.time.out(@event.start.time[urn,"C DOCTOR"])}

To get the average for each doctor I use this in a trailor.
CON=IF{@event.start.time[urn,"C <CON=IF%7...@event.start.time[urn,%22C>DOCTOR"]}
DAT=DEC2
FNC=AVG
JFY=R
LEN=5
VAL=IF{@urn's.er.doctor="ABB <VAL=IF%7B@urn's.er.doctor=%22ABB>"
%Z.elapsed.time
VAL=(%Z.date.in.magic(@event.start.time[urn,"C DOCTOR"]),
VAL=%Z.time.out(@event.start.time[urn,"C
DOCTOR"]),@MIS.PAT.arrival.date[urn],
VAL=@MIS.PAT.arrival.time[urn],"hh.hh")*60<VAL=@MIS.PAT.arrival.time[urn],%22hh.hh%22)*60>
}

and this to get the avg door to doc time in report trailor:
CON=IF{@event.start.time[urn,"C <CON=IF%7...@event.start.time[urn,%22C>DOCTOR"]}
DAT=DEC2
FNC=AVG
JFY=R
LEN=5
VAL=%Z.elapsed.time(%Z.date.in.magic(@event.start.time[urn,"C DOCTOR"]),
VAL=%Z.time.out(@event.start.time[urn,"C
DOCTOR"]),@MIS.PAT.arrival.date[urn],
VAL=@MIS.PAT.arrival.time[urn],"hh.hh")*60<VAL=@MIS.PAT.arrival.time[urn],%22hh.hh%22)*60>

Gail

Gail Hardie, RN
Informatics Nurse
Morehead Memorial Hospital
Eden, NC 27288
336-623-9711 ext.2889
gha...@morehead.org

> To UNSUBSCRIBE, go to http://MTUSers.net <http://mtusers.net/>