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

Need "on hold" data for SQL query.

Trading Post

Last Post by Anonymous 1 second ago

3 Posts

2 Users

0 Reactions

60 Views

RSS

gfishback

(@gfishback)

Posts: 70

Estimable Member

Topic starter

I've been tasked with putting together some baseline metrics around how much time clinicians actually spend "charting". Now, in SQL I can pull when an update was started, when it is contributed to but nowhere can i link when it was put on hold. The Audit_Event table and DocContb table don't log anything about when a document is put on hold. I've bound these two tables together and have a formidable query that shows me the steps they've taken from the time it is started to the time it is signed but the data is inaccurate unless I can subtract the time the document is on hold. Has anyone tackled anything like this? I've just about decided that it isn't tracked anywhere but figured I'd run it out past the group in case I'm missing something.

Greg Fishback | Director of I.T. for GreenField Health

Posted : May 12, 2014 8:57 am

gibsonmi

(@gibsonmi)

Posts: 827

Prominent Member

Audit events changed a bit in CPS 12, but we have an audit event labeled "Place document on hold", what version are you on and do you have that event enabled?

Posted : May 12, 2014 10:50 pm

gfishback

(@gfishback)

Posts: 70

Estimable Member

Topic starter

I had completely forgotten about that. Unfortunately when I looked, "Place Document on Hold" is set to be logged but it is not recording in the Audit_Event table. There are no Event_Type_ID's of 118 anywhere in my entire Audit_Event table. Looks like a potential bug in CPS-11. I'll fling it past GE. Thanks for the use of your brain!

Greg Fishback | Director of I.T. for GreenField Health

Posted : May 13, 2014 4:39 am

Share:

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

Powered by wpForo Powered by wpForo version 2.4.0