Notifications
Clear all
Topic starter
In our large practice, many doctors (we think) are still using older form components. For instance, there is something called "Basic Visit 1" which asks some questions, but a new version was recently released called "Basic Visit 2014". There are many more examples like this.
Now, I want to be able to write a report to learn what older form components might still be used. But, I am having difficulty determining this as I read thru the DOCUMENT file, DOCDATA file [where I thought I would be able to learn this].
So, does anyone know a table and/or field name that stores the components used in making the document?
Thanks.
Posted : September 29, 2014 11:28 pm
Joseph, do you think they are pulling them from their Favorites? If so, here is how to find out-of-date favorites. Been a long-standing issue that when forms are updated, those same forms are not updated in user favorites:
select u.loginname ,f.title, u.lastname, u.firstname, u.middlename, fs.active, fs.description from ml.usrfavcomps f, ml.usrinfo u, ml.formset fs where f.usrid = u.pvid and f.comp_id = fs.fsid and u.status = 'A' and fs.active = 'X' order by f.title, u.lastname
If you want to look at form insertion, DOCCONTB is the table you want. The CONTB_ACTION field contains code 25 when a form is inserted and 26 when a text component is inserted. NEW_VAL will have the name of the form.
DOCCONTB is basically what you see when you right-click a document and choose View Contributors List. If you don't have the document inserts, you may have to up your level of auditing.
Hope this helps,
Posted : October 6, 2014 2:44 am
Topic starter
Thanks David.
Can you (or anyone else) think of a reason why the Contributor Action only seems to record some of the possible choices?
I see 0 = create, 2 = contribute, 7 = final signature.
However, no matter if I create a document from a template (with forms defined) or manually right-click to add a form, I do not see the CONTB_ACTION = 25.
Hmmmm.
Thanks.
Posted : October 6, 2014 3:27 am
If you don't see the inserts when you right-click on a document and look at View Contributors List, you don't have a high enough level of auditing turned on. If you see a lot of data you can filter it down by checking the "Don't show changes to document temporary symbols" box.
Look and see what you have in Go, Setup, Settings, System, Auditing. We have Log clinical data contributions to documents on. Warning - will chew up disk space recording this information. There are 3 check boxes to reduce the amount of data logged. We have the top two checked.
Posted : October 6, 2014 4:14 am
