The Userlog Table contains all events of a document including the number of characters/lines added during each event. There can be multiple entries per one job for multiple users.
ACCTNO |
Account number |
ACTIVITY |
Transcribe, review, proof, QA, log in, or log out |
CALCCODE |
Calculation code |
CHARS |
Number of characters |
CNETJOB |
ChartNet job number |
DE_CHARS |
Delivered characters |
DOCTOR |
Dictating doctor code |
EDITORTYPE |
Editor type - CN=ChartNet, MM=MultiModal, CC=Concord |
ELAPHOURS |
Elapsed time (hours) |
ELAPSECS |
Elapsed time (seconds) |
ELAPTIME |
The amount of time the job was checked out (hh:mm:ss) |
END_DATE |
End date of the activity |
END_TIME |
End time of the activity |
INCMARKERS |
Number of initial incomplete markers for QA purposes (gets set just once) |
LINES |
Transcription quantity (9999999.99999999) |
MRUN |
Med rec number |
NAME |
User name |
NETCHARS |
Difference from previous STDCHARS (also takes into account 'Maximum Sequential Blanks" from Calc Code) |
NETLINES |
Difference from previous STDLINES |
ORIGJOB |
Original job number |
ORIGSCRIBE |
Original scribe who typed the report |
PROTECTED |
Protected characters |
PTNAME |
Patient name |
QUAL_LINES |
Protected units (can be lines or characters) |
REPORTKEY |
Unique report ID |
REPT_TYPE |
Report type code |
RETURNS |
The number of returns |
REVQUEUE |
Review queue |
SCRIBE |
Code for the person who typed the report |
SERVCTR |
Service center |
SITE |
Site code |
SPACES |
The number of spaces |
START_DATE |
The date that the document was accessed by a typist |
START_TIME |
The time that the document was accessed by a typist |
STAT |
Stat report flag (True of False) |
STDCHARS |
Standard characters (VBC + spaces + de_chars) |
STDLINES |
Standard lines (stdchars/65) |
TABS |
The number of tab spaces |
TRANS_DATE |
Date transcription started (addendums have same date as parent) |
TRANS_TIME |
Time transcription started (addendums have same time as parent) |
VRREPORT |
Transcribed by voice rec |
|
|