Notifications
Clear all
General Discussion
3
Posts
2
Users
0
Reactions
139
Views
Topic starter
Hi,
We are currently on 9.8.6 CEMR and working on a Crystal Report where we need to make calculations from the time a note is opened, to when it is signed. We have noticed that the Document table PUBTIME is slightly off (1-2min) from the timestamp noted in the application. Does anyone know the cause for this? Is there another item in the tables that is an exact match on the initial signature date/time to what is displayed in the document text and document contributors info? Sometimes the PUBTIME is right on the mark and sometimes off by a couple min. Thank you!
Posted : January 28, 2015 8:39 am
I would look at the DOCCONTB table (document contributors). You will want to look for the CONTB_ACTION field. These 3 values (from the data dictionary):
6 Initial signature
7 Final signature
8 Additional signature
The CONTBID field is one of those fields like CLINICALDATE (workstation/timestamp), a USRID that is the PVID and linked to DOCUMENT via SDID.
Posted : January 28, 2015 10:57 am
Topic starter
Thank you David!
Posted : January 29, 2015 6:23 am
