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

Audit Event 505 to MUActivityLog 510

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

5 Posts

3 Users

0 Reactions

88 Views

RSS

gfishback

(@gfishback)

Posts: 70

Estimable Member

Topic starter

We never have used the PIN workflow and as such our MU numbers are way off for patient portal access. We have a 96% adoption as it is part of our on-boarding process. Apparently a script was written to repair this scenario (according to my contacts at Kryptiq) but GE is unable to locate it and knows nothing about it. A little research shows that a event log entry was made when a portal account was linked to a chart. I created a script that will make a 510 entry in the MUActivityLog table for each occurrence of that 505 entry in the Audit_Event table. No guarantees and use this at your own risk. Don't run this without customizing it to your needs and knowing what it is doing. But for reference should you need it (seeing how GE can't seem to get around to it)...

insert into MUActivityLog
(MUActivityLogID,Event_Timestamp,DB_Create_Timestamp,MUActivityLogTypeId,PID,PVID,UserAccessIdentifier,Access_Device,Access_Source,DeliveryMethod,Exported,IsEnabled)
select dbo.[Convert_Date_to_ID] (Getdate()) + next value for dbo.SeqGenerator,AE.Event_Timestamp,AE.Event_Timestamp,'510',ae.pid,'PROVIDER_PVID','[email protected]','Kryptic PatientPortal','IP ADDRESS ','Electronic','N','Y'
from Audit_Event ae
where AE.Event_Type_id = 505
and event_Timestamp = (select min(event_timestamp)from Audit_Event where event_type_ID = 505 and pid=AE.pid)
and AE.pid not in (select pid from muActivityLog where MUActivityLogTypeID = 510)

Greg

Posted : June 17, 2015 5:29 am

ronmoses

(@ronmoses)

Posts: 158

Estimable Member

It's a nifty script, but I'm not sure our auditors would be too happy to learn we'd manipulated the MUActivityLog table.

Posted : June 19, 2015 2:50 am

jamesedward

(@jamesedward)

Posts: 257

Reputable Member

The GE/Kryptiq patch was released in September 2014, although if memory serves, it applies more to things which happened prior to 9.8. CQR should pick up the 9.8 stuff now regardless.

Patient Access script

This script is used to propagate data from the PATPORTALPIN observation term used to identify a patient that was granted
access to a patient portal to the MU Activity Log in order to calculate the Patient Access MU measure. This should be
used by customers documenting patient portal access via chart updates and populating the PATPORTALPIN observation term.

If you are using a PatPortalPin workflow to register patients with you portal, data is not sent correctly to CQR
resulting in lower than expected numerator values. This patch will generate the required data in the MUActivityLog
table. The nightly MU Functional Measure feed will send this new data to CQR. No change is required to the MU data feed.

GE recommends that you run this script in your test system first, if available. This script may be run during clinic
hours, however for best performance, we recommend you run this during off hours, before your next scheduled MU Functional
Measure job (usually 2am).

Follow these instructions in order to run this script:

Extract the attached zip file to a temporary directory on your database server.

If you are using CPS, login to SQL Server Management Studio
In Object Explorer, select your database name.
Open PatPortalPinCps.sql
Select "Execute"

If you are using CEMR, login using SQLPlus (e.g. sqlplus ml/ml@databasename)
At the SQL> prompt, type @c:\temp\PatPortalPinEMR.sql, where c:\temp\ is the directory where you extracted the zip file.
Once the script has completed running, the result will display how many patients were affected.
You may now exit as the process is complete.

The next nightly update for MU Functional measures will send the data to CQR.
Allow 24 hours for this data to process.
You may verify that data has processed in CQR on the "Insight" dashboard. There should be no unnprocessed files.

Once files have processed, select your provider in the CQR dashboard and rerun your calculations for affected providers.

Posted : June 19, 2015 3:52 am

jamesedward

(@jamesedward)

Posts: 257

Reputable Member

CPS:

************************************************************************************************************

-- Author : Mike Cohen

-- Purpose : SPR 60316 - PATPORTALPIN not logging to MUActivityLog

-- Description : Temporary script used to fill the MU Activitylog before the Functional Measure

-- : Use existing OBS of type PATPORTALPIN to populate the MUActivityLog on demand

-- Create Date : 26-Sep-2014

-- Notes : CPS version.

---

Posted : June 19, 2015 3:53 am

jamesedward

(@jamesedward)

Posts: 257

Reputable Member

CEMR:

--************************************************************************************************************

-- Author : Mike Cohen

-- Purpose : SPR 60381 - PATPORTALPIN not logging to MUActivityLog

-- Description : Temporary script used to fill the MU Activitylog before the Functional Measure

-- : Use existing OBS of type PATPORTALPIN to populate the MUActivityLog on demand

-- Create Date : 26-Sep-2014

-- Notes : EMR version

---

Posted : June 19, 2015 3:53 am

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