I was recently asked to create a report for a group of users, in regards to how many Orders this group of people is "Completing". I am using the Orders table to look for records with a Status of "C" and then I am pulling information based on the PubUser matching one of the employees in my employee group and then checking to see if the PubTime is within my date range.
I am being told that my numbers seem way too low and so I was wondering if anyone else has created a similar report? I don't know, but maybe I am using the wrong table to pull this data? Any help will be much appreciated.
What you describe seems correct. Is it the numbers that are low, or the percentage of overall Orders?
I am told that the numbers for the total Orders being completed by this group are too low, both at the individual user level and the final total.
I was recently told that this group of people also use a product called OnBase to close some of their Orders and we are now wondering if this is where the issue lies. Trying to find out how OnBase logs the closing of the Orders inside the CentricityPS database.
Depending how that is configured you may find that the "pubuser" for those orders is linklogic. We have a few different PM systems and when trying to report on patient demographic changes we find that anything changed by an inbound ADT from the PM system is associated to the linklogic user.
Makes finding out who is blanking out emails really fun...
Not sure if that is due to how we are configured or not though.