Notifications
Clear all
Topic starter
Has anyone applied for MU lately? There is a big question where I work about report #6 which is the patient education report. GE half baked this one and the report doesn't actually meet the CMS guidelines and GE admitted that to us. They said they coded it the way they did because it was easy. The report should be looking for all handouts printed and not just the medication handouts. We are looking into possibly creating our our report. Have any of you ran into this? Did this effect your certification? Please let me know. Thanks.
Posted : October 5, 2012 1:33 am
I think they didn't include the other handouts in the report because the data schema doesn't allow them to (not consistently anyway). When printing a handout from the patient chart (without being in an update), it lets you check a box that says “Record handout printing in chart” and it then lets you select a provider. Once you click print, 2 separate audit events are created. One that records creating the document with the providers name and one that records the printing of the handout. Unfortunately, there is nothing that links the 2 audit events together. So, if a nurse prints an education handout for a patient, there is nothing that links that event to a specific provider. GE must have run into the same road block when creating the meaningful use reports and decided to only capture medication handouts.
If you always print the education handouts from within an update, you can create a report. I stopped working on my version of this report when I realized this was the case, since it's mostly our nurses that print education materials. Here's the table linking for the report I was working on. I used grouping and summaries (a lot like GEs reports) to tally visits and reports printed for each doc.
Posted : October 8, 2012 1:23 am
I don't think it let me upload the image. Here's the linking in text format:
AUDIT_EVENT.SDID --> DOCUMENT.SDID
AUDIT_EVENT.EVENT_TYPE_ID --> AUDIT_EVENT_TYPE.EVENT_TYPE_ID
DOCUMENT.USRID --> USRINFO.PVID
DOCUMENT.DOCTYPE --> DOCTYPES.DTID
Posted : October 8, 2012 1:31 am
At CHUG there was a session related to this topic. It was VOC session1. Everyone was disappointed in the way this was presented for MU 1 with only the medication handout being applied. It did sound as if they are reworking this entire process and report.
Let's keep our fingers crossed!
Posted : October 10, 2012 2:11 am
Hi All,
Please help me with crystal report to count number of handouts printed per provider. I dont know what field to pull from the Audit_Event table. If you have done this report, please help me.
Thanks,
Sa
Posted : September 3, 2013 5:56 am
Sa,
Are your providers the ones that print the handouts or is it the staff? I've investigated this thoroughly and there is no way to capture this data unless the provider is the one printing the education handouts.
Bob
Posted : September 3, 2013 6:36 am
Hi Bob,
Yes, only providers print the handout.
Thanks,
Sa
Posted : September 3, 2013 10:47 pm
sango said:
Hi Bob,
Yes, only providers print the handout and printing using a button on the form during an update.
Thanks,
Sa
Posted : September 3, 2013 11:03 pm
You can extract this via SQL or a Crystal Report. To add 'providers' only, you could edit the MU Crystal Report -- change the code on the sub-report.
Below is Oracle Code showing the links; I've got various things commented out depending upon what I'm going for:
select *
from audit_event_type
where event_type_id = 111;
--Audit Tables
select count(*) from audit_event_type;
select count(*) from audit_event_detail;
select count(*) from audit_event;
select count(*) from audit_profile;
--Counting Handout prints by LOC; enter date below
select ad.event_value_1,lo.abbrevname,ui.searchname,count(*)
--pe.searchname,
--lo.abbrevname,
--ui.lastname,
--ae.event_id,ae.profile_id,ae.event_timestamp,
--ae.event_type_id,ae.pid,ae.sdid,ae.user_role_id,
--ae.pidlink,ae.outcome,ae.exported,ae.userisrequestor,
--ad.event_id,ad.event_detail_id,ad.event_param,ad.event_value_1_param,
--ad.event_value_1,ad.event_value_2_param,ad.event_value_2,ad.event_note
from audit_event ae,audit_event_detail ad,
audit_profile ap,locreg lo,usrinfo ui,
---usrinfo ui
person pe
---,locreg lo
---audit_profile ap,
where
ae.event_id=ad.event_id
and ae.pid=pe.pid
and ae.profile_id=ap.profile_id
and ap.locid=lo.locid
and ap.pvid=ui.pvid
and ae.event_type_id = 111
and ae.event_timestamp >= '01-JAN-12'
and ad.event_value_1 like '%Handout%'
--and (ad.event_value_1 not like '%Clinical Visit Summary%')
--and (ad.event_value_1 not like '%Selected Document%%')
--and (ad.event_value_1 not like '%Current Document View%')
--and (ad.event_value_1 not like '%Update Pages%')
--and (ad.event_value_1 not like '%Complete Chart%')
--and (ad.event_value_1 not like '%Internal Correspondence%')
group by ad.event_value_1,lo.abbrevname,ui.searchname
order by count(*) desc,ad.event_value_1;
Posted : September 5, 2013 10:53 pm
