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

Track Form Use Through Database

CPS, C-EMR, PM

Last Post by Anonymous 1 second ago

3 Posts

2 Users

0 Reactions

64 Views

RSS

vrdlc

(@vrdlc)

Posts: 135

Estimable Member

Topic starter

We're trying to determine how many of our forms are actually in use and how often specific ones are used. We put a trigger on the DOCUMENT table that fires on document sign. This pulls all the data from the Document Template, cuts out the "[MLI-", and writes the form name and a count for its usage to a custom table.

The only issue is when large encounters (~10-15 forms) are completely written out, it will either:

Freeze Centricity (must force quit, but all data is saved in the chart)
Crash Centricity (the document is held and half of the data is lost)
Throw a weird popup about how other users changed the summary line in the database (clicking "Yes" signs the document, but not on all of our larger encounters)

First off, I don't know what is causing these errors. I've tried a TRY CATCH and no error is saved in the error table in the CATCH. I also only get the weird popups when using a TRY CATCH, even though it doesn't even do anything.

Second, there has GOT to be an easier way to track this, right? We could get a ton of OBS terms and jam them into every form, but that is really time consuming and messy.

I did see two columns that used to perform this task in the Data Dictionary, but they're not in use anymore! Why would these get taken away with no replacement?!?

I'm completely baffled and frustrated. Does anyone have any ideas?

Posted : November 18, 2019 11:31 am

DavidShower

(@davidshower)

Posts: 1255

Noble Member

I know we had a level of auditing turned on that when you right-clicked a document and did "View Contributors List", it would show the insertion of forms. In the DOCCONTB table, you can look for CONTB_ACTION 25 and NEW_VAL will have the name of the form. From Security, I believe you want to be logging "Add Encounter form" and "Add HTML Encounter form" and have "log clinical data contributions to documents" checked. Heed the warnings about database size increasing as you begin to log more things if you go this route.

Posted : November 19, 2019 11:51 am

vrdlc

(@vrdlc)

Posts: 135

Estimable Member

Topic starter

Apparently this has been on for the last three years and I had no idea. Thanks for pointing me to the right table!

Posted : November 20, 2019 11:50 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