The Stats Table contains statistical details of all jobs processed in Chartnet including billing and payroll statistics. There is one record per document number in the stats table.
ACCTNO |
Account number |
AMOUNT |
Transcription amount (9999.99999999) |
ASSIGNED |
Report is assigned to this review queue |
ATTDR |
Attending doctor code |
ATTDRNAME |
Doctor name as it appears in Signature line (First Last, Title) |
BILL_AMT |
Site billing amount (9999.99999999) |
BILL_CAT |
Site billing category (who typed report) (IN HOUSE, VOICE REC, SITE USER) |
BILL_CHARS |
Site billing characters (99999999) |
BILL_LINES |
Site billing quantity (9999999.99999999) |
BIRTHDT |
Date of birth |
CHARS |
Transcription chars (99999999) |
CHKOUTFLAG |
Report is checked out |
CHKOUTRECV |
Checked out received flag - Set to TRUE after user downloads report |
CNETJOB |
ChartNet Job number |
DE_CHARS |
Date entry characters |
DELIVDATE |
Document Delivery date |
DELIVERED |
Document Delivered flag (True or False) |
DELIVTAT |
Report delivery turnaround time (disttime to delivtime) |
DELIVTIME |
Document Delivery time |
DICT_DATE |
Dictation date |
DICT_ID |
Dictator ID |
DICT_TIME |
Dictation time |
DICTLEN |
Dictation length (seconds) |
DICTRECVDT |
Dictation file received date |
DICTRECVTM |
Dictation file received time |
DICTTAT |
Dictation TAT (dict_time to dictrecvtm) |
DISDT |
Discharge date |
DISTDATE |
Distribution pending date |
DISTTIME |
Distribution pending time |
DOCNAME |
Doctor name as it appears in Signature line (First Last, Title) |
DOCTOR |
Dictating doctor code |
DUEDATE |
Due date |
DUETIME |
Due time |
EDITAMT |
VR Editing cost amount (Labor) |
EDITBY |
Last edit scribe code |
EDITDATE |
Last edit date |
EDITELAP |
Editing elapsed time in hours |
EDITTIME |
Last edit time |
FIRSTREVBY |
First reviewed by (used for QA) |
FIRSTREVDT |
First reviewed date |
FIRSTREVTM |
First reviewed time |
GOALMET |
Turnaround goal met flag |
INCMARKERS |
Number of initial incomplete markers for QA purposes (gets set just once) |
INCOMPLETE |
Report has incomplete markers (True or False) |
LINES |
Transcription quantity (9999999.99999999) |
MISSINGDAT |
Report has missing demographics (True of False) |
MRUN |
Med rec number |
ORIGJOB |
Original job number |
PATSERV |
Patient service |
PATTYPE |
Patient type (I,O,E) |
PRIORITY |
Priority (0-3) |
PROFIT |
Profit or loss (if negative) |
PROOFELAP |
Proofing elapsed time in hours |
PROTECTED |
Protected chars |
PTNAME |
Patient name |
QUAL_LINES |
|
REPORT_ID |
Unique report id (Addendums have same Report ID as parent) |
REPT_DESC |
Report description |
REPT_TYPE |
Report type code |
RETURNS |
Carriage returns |
REVIEWDATE |
Reviewed date |
REVIEWEDBY |
Reviewed by (scribe code) |
REVIEWEDNM |
Reviewed by name |
REVIEWTAT2 |
Last review TAT (firstrevtm - reviewtime) |
REVIEWTIME |
Reviewed time |
REVQUEUE |
Current review queue |
SCRIBE |
Person who typed the report |
SEX |
Patient gender code (M or F) |
SITE |
Site code |
SITE_AMT |
Site billing amount (9999.99999999) |
SITE_CHARS |
Site billing characters (999999) |
SITE_LINES |
Site billing quantity (9999999.99999999) |
SITE_UNITS |
Site billing units (lines, words, gross, etc) |
SPACES |
Spaces |
STAT |
Stat report flag (True of False) |
STATUS |
Report status |
STATUSDESC |
Report status description |
TABS |
Tabs |
TATDATE |
TAT ending date |
TATTIME |
TAT ending time |
TOTCOST |
Total cost (AMOUNT + VRAMT + EDITAMT + PROOFAMT) |
TRANBEGTAT |
Transcription begin TAT (dictrecvtm to trans_time) |
TRANELAP |
Transcription elapsed time in hours |
TRANS_DATE |
Date transcription started (addendums have same date as parent) |
TRANS_TIME |
Time transcription started (addendums have same time as parent) |
TURNCAT |
Turnaround category - Used for TAT reports to group reports |
TURNDIFF |
Turnaround time difference |
TURNGOAL |
Turnaround time goal |
TURNTIME |
Turnaround time (hours) |
UNITS |
Transcription units |
USERTYPE |
User type code (employee, contractor, site user) |
VBCHARS |
Visual black characters |
VISITDT |
Visit date (if inpatient, then admit date) |
VRRATOMG |
Voice rec - returned recognition quality rating (0.00 - 1.00) |
VRREPORT |
Voice rec - report done by VR vendor flag |