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

Daily desktop document count

General Discussion

Last Post by gpincomb 8 years ago

4 Posts

4 Users

0 Reactions

62 Views

RSS

jessicaw

(@jessicaw)

Posts: 434

Prominent Member

Topic starter

Administration has asked if I could give them a count on the number of documents that are routed to our Triage desktop on a daily basis. We have multiple users that work off of this desktop.

I have not been able to come up with a way to track that. Any one have any suggestions on how this could be done? If it can be done......

Posted : March 9, 2017 2:59 am

rwilliams

(@rwilliams)

Posts: 454

Honorable Member

I do not believe that this is possible. From what I can tell, there is no audit event type for routing a document and the docroute table only has an entry in it while a document is sitting on a desktop. As soon as it is removed, the entry is removed.

The only way I think you could approach this is to either periodically (ever minute or less) query the docroute table and save the results to another table and report off of that. The correct way to do something like this would be to actually setup a database trigger to add a record somewhere, but I would not be daring enough to add a trigger to an EMR table.

Posted : March 9, 2017 5:11 am

caswelljm

(@caswelljm)

Posts: 80

Trusted Member

This isn't logged in the database. The best option you have is to run a report to see how many documents are currently routed to triage.

select COUNT(*) from DOCROUTE where USRID = 'Triageuserspvid'
select pvid from USR where LOGINNAME like 'Triage'

Or if there is a specific workflow for the people working the triage desktop you can get a general idea. (Eg. if the users sign the document or fill out an obsterm, base the report off of that.)

Hopefully this helps in some manner.

-James Caswell

Posted : March 9, 2017 5:33 am

gpincomb

(@gpincomb)

Posts: 278

Reputable Member

I agree with Ryan, in part, at least. You do not want to use the DocRoute table because if the document is subsequently routed somewhere else then it will look like it never was routed to your Triage desktop or as Ryan notes if the document is removed from the desktop then it just simply drops out of the DocRoute table.

I did, however, run across something recently that may help you out. I swear when I first started working here, GE did not track this, but the other day I was looking for something else and lo and behold there this was. In the Document table there is a field named "ROUTE_IDS". The Data Dictionary describes it as:

A comma-separated list of ROUTE IDs for person to whom the document has been routed. Each ROUTE ID is a PVID in the USR table.

I have not had much of a chance to look into this, but I think that if you build a query that looks for the PVID of your Triage desktop within this field then you will be able to identify all documents that have been routed to it. Again, since I have not worked with it yet, I can only guess that if a document is removed from a desktop then I believe it should not affect this field at all. I also have no idea if there is a limit to the number of route locations that are tracked in this field.

So please if this works for you, then let us know.

Posted : March 15, 2017 6:19 am

Share:

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