Notifications
Clear all
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
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
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
