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