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

How to know what components were imported to make an office visit

Trading Post

Last Post by Anonymous 1 second ago

4 Posts

2 Users

0 Reactions

72 Views

RSS

joeg1962

(@joeg1962)

Posts: 843

Noble Member

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

DavidShower

(@davidshower)

Posts: 1255

Noble Member

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

joeg1962

(@joeg1962)

Posts: 843

Noble Member

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

DavidShower

(@davidshower)

Posts: 1255

Noble Member

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

Share:

24 Forums
9,940 Topics
39.9 K Posts
0 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