DOMAIN Character Domain
REPORTKEY Character Primary key
--Job Fields
CNETJOB Character ChartNet Job number
ORIGJOB Character Original job number
DOCTOR Character Dictating doctor code
DOCNAME Character Doctor name as it appears in Signature line (First Last, Title)
DICT_DATE Date Dictation date
DICT_TIME Character Dictation time
DICTRECVDT Date Dictation file received date
DICTRECVTM Character Dictation file received time
DICTLOC Character Dictation location
DEPARTMENT Character Dictation department code
PRIORITY Character Priority (0-3)
DICT_ID Character Dictator ID
WORKTYPE Character Work type code
DICTLEN Numeric Dictation length (seconds)
DUEDATE Date Due date
DUETIME Character Due time
TURNGOAL Numeric Turnaround time goal
DICTMETHOD Character Dictation method (Unknown, Traditional, CDSLive, CDSInteractive)
DICTTYPE Character Dictation type (Unknown, Normal, SelfEdited, SentToMT, AuthorTyped)
-- Status fields
STATUS Character Report status
STATUSDESC Character Report status description
CHKOUTFLAG Logical Report is checked out
CHKOUTDATE Date Checked out date
CHKOUTTIME Character Checked out time
CHKOUTUSER Character Checked out scribe
CHKOUTRECV Logical Checked out received flag - Set to TRUE after user downloads report
-- Voice Rec Fields
VRCode Character Voice rec - Vendor code
VRRating Numeric Voice rec - returned recognition quality rating (0.00 - 1.00)
VRREPORT Logical Voice rec - report done by VR vendor flag
VRCdsLive Logical Report created via MModal CDS Live using CVSolo
-- Report Fields
REPORT_ID Character Unique report id (Addendums have same Report ID as parent)
OTHER_ID Character Extra ID
ADDENDUM Character Addendum number (addendum report only)
ADDENDUMS Numeric Number of addendums (parent only)
SERIALNO Character ChartNet serial number
SERVCTR Character Service Center
SITEGROUP Character Site group code
FACILITY Character Facility code
SITE Character Site code
ACCTMGR Character Account manager
SCRIBE Character Person who typed the report
SCRIBEMGR Character User's manager
USERTYPE Character User type code (employee, contractor, site user)
TRANS_DATE Date Date transcription started (addendums have same date as parent)
TRANS_TIME Character Time transcription started (addendums have same time as parent)
REPT_TYPE Character Report type code
REPT_DESC Character Report description
USER1 Character User-defined field 1
USER2 Character User-defined field 2
USER3 Character User-defined field 3
USER4 Character User-defined field 4
EDITDATE Date Last edit date
EDITTIME Character Last edit time
EDITBY Character Last edit scribe code
INCMARKERS Numeric Number of initial incomplete markers for QA purposes (gets set just once)
-- Patient fields
PTNAME Character Patient name
BIRTHDT Date Date of birth
SEX Character Patient gender code
ACCTNO Character Account number
MRUN Character Med rec number
VISITDT Date Visit date (if inpatient, then admit date)
DISDT Date Discharge date
SERVDT Date Service date
SURGDATE Date Surgery date
LOCATION Character Patient location (room/bed)
PATSERV Character Patient service
PATTYPE Character Patient type (I,O,E)
ATTDR Character Attending Doctor
ATTDRNAME Character Doctor name as it appears in Signature line (First Last, Title)
ADMDR Character Admitting Doctor
ADMDRNAME Character Doctor name as it appears in Signature line (First Last, Title)
REFDR Character Referring Doctor
REFDRNAME Character Doctor name as it appears in Signature line (First Last, Title)
CONSULT Character Consult Doctor
CONSULTDRNAME Character Doctor name as it appears in Signature line (First Last, Title)
ORDERDR Character Ordering Doctor
ORDERDRNAME Character Doctor name as it appears in Signature line (First Last, Title)
SURGDR Character Surgery Doctor
SURGDRNAME Character Doctor name as it appears in Signature line (First Last, Title)
DOCTOR1 Character Other doctor 1
DOCTOR2 Character Other doctor 2
DICTFOR Character Dictated for
ORDERNO Character Order number
ORDERDATE Date Order date
ORDERTIME Character Order time
ORDERNO2 Character Other order number
EXAMCODE Character Exam code
EXAMDESC Character Exam description
EXAMDATE Date Exam date
EXAMTIME Character Exam time
ABNORMAL Character Abnormal Result flag (Y or N)
-- Review fields
INCOMPLETE Logical Report has incomplete markers
MISSINGDAT Logical Report has missing demographics
ASSIGNED Character Report is assigned to this review bin
REVQUEUE Character Current review queue
FIRSTREVDT Date First reviewed date
FIRSTREVTM Character First reviewed time
FIRSTREVBY Character First reviewed by (used for QA)
REVIEWDATE Date Reviewed date
REVIEWTIME Character Reviewed time
REVIEWEDBY Character Reviewed by (scribe code)
REVIEWEDNM Character Reviewed by name
INCMKRREV Numeric Number of incomplete markers after review
SITEREVDT Date Site reviewed date
SITEREVTM Character Site reviewed time
SITEREVBY Character Site reviewed by
-- Stat fields
STAT Logical Stat report flag (i.e. priority = 0)
DE_CHARS Numeric Date entry characters
TRANELAP Extended Transcription elapsed time in hours
EDITELAP Extended Editing elapsed time in hours
VREDITELAP Extended VR Editing elapsed time in hours
PROOFELAP Extended Proofing elapsed time in hours
-- These fields represent the raw document character counts
VBCHARS Numeric Visual black characters
SPACES Numeric Spaces
RETURNS Numeric Carriage returns
TABS Numeric Tabs
PROTECTED Numeric Protected chars
-- These fields represent the MT who typed the report, used for payroll
TRAN_CALC Character Transcription calculation code
CHARS Numeric Transcription chars (99999999)
LINES Extended Transcription quantity (9999999.99999999)
AMOUNT Extended Transcription amount (9999.99999999)
UNITS Character Transcription units
-- These site fields contain the current stats for the site
SITE_CALC Character Site calculation code
SITE_CHARS Numeric Site billing characters (999999)
SITE_LINES Extended Site billing quantity (9999999.99999999)
SITE_AMT Extended Site billing amount (9999.99999999)
SITE_UNITS Character Site billing units (lines, words, gross, etc)
-- These fields get updated at billing time and don't change after that (future use)
BILL_DATE Date Site billing date
BILL_CHARS Numeric Site billing characters (99999999)
BILL_LINES Extended Site billing quantity (9999999.99999999)
BILL_AMT Extended Site billing amount (9999.99999999)
BILL_CAT Character Site billing category (who typed report) (IN HOUSE, VOICE REC, SITE USER)
-- Cost fields
VRAMT Extended Voice rec cost amount
EDITAMT Extended Editing cost amount
VREDITAMT Extended VR Editing cost amount (cumulative)
PROOFAMT Extended Proofing cost amount
TOTCOST Extended Total cost (AMOUNT + VRAMT + EDITAMT + PROOFAMT)
PROFIT Extended Profit or loss (if negative)
DISTDATE Date Distribution pending date
DISTTIME Character Distribution pending time
DELIVERED Logical Document Delivered flag
DELIVDATE Date Document Delivery date (replaces BatchDate)
DELIVTIME Character Document Delivery time (replaces BatchTime)
TATDATE Date TAT ending date
TATTIME Character TAT ending time
TURNTIME Extended Turnaround time (hours)
TURNDIFF Extended Turnaround time difference
GOALMET Logical Turnaround goal met flag
BATCHDATE Date Batch print date
BATCHTIME Character Batch print time
-- Elapsed Times for Key Events
DICTTAT Extended Dictation TAT (dict_time to dictrecvtm)
TRANBEGTAT Extended Transcription begin TAT (dictrecvtm to trans_time)
TRANTAT Extended Transcription TAT (trans_time to tranendtm)
REVIEWTAT1 Extended First review TAT (tranendtm - firstrevtm)
REVIEWTAT2 Extended Last review TAT (firstrevtm - reviewtime)
DELIVTAT Extended Report delivery turnaround time (disttime to delivtime)
SITEREVTAT Extended Site review turnaround time (reviewtime to siterevtm)
SIGNTAT Extended E-signed turnaround time ([tranendtm/reviewtime/siterevtm] to signtime)
SIGNTAT2 Extended E-signed turnaround time 2 (signtime to signtime2)
-- E-sign fields
ESIGSTATUS Character E-sign status (P=Prelim, F=Final)
ESIGDOC Character Provider who is next to sign
ESIGDOCNM Character Provider who is next to sign name
ESIGGROUP Character Provider e-sign group code
SIGNDATE Date E-signed date
SIGNTIME Character E-signed time
SIGNDOC Character E-signed provider (dictating)
SIGNDATE2 Date E-signed date 2
SIGNTIME2 Character E-signed time 2
SIGNDOC2 Character E-signed provider 2 (attending)
-- QA fields
QADATE Date Date report was audited (so that we don't select it again)
QATIME Character Time report was audited
-- Extra fields
EXTRASTR Character Extra string (reserved for cnetjob in 3.31)
EXTRASTR2 Character Extra string 2
EXTRASTR3 Character Extra string 3
-- STATS-Only fields
TURNCAT Character Turnaround category
REPTCOUNT Numeric 1=non-stat report
STATCOUNT Numeric 1=stat report
GOALCOUNT Numeric 1=TAT goal met
DOC20 Character For backwards compat (RR)
SITE20 Character For backwards compat (RR)
SCRIBE20 Character For backwards compat (RR)
DOCDEPT Character Doctor department code
DOCLOC Character Doctor location
MANAGER Character **OBSOLETE**
-- Fields for late penalty billing accounts (i.e. invoice1.rrw)
LATEHOURS Extended Number of hours late
RATE Extended Billing rate (from calcs)
LATERATE Extended Late penalty per hour rate (from forms)
LATEPEN Extended Total late penalty (latehours * laterate)
NETRATE Extended Net per-line charge rate (rate - latpen)
NETAMT Extended Total charges for lines
FROMDATE Date From date
TODATE Date To date