Stats Table Fields

Navigation:  Ad Hoc Grid >

Stats Table Fields

Previous pageReturn to chapter overviewNext page

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