List of Database Tables

Navigation:  Appendix >

List of Database Tables

Previous pageReturn to chapter overviewNext page

ChartNet data tables

 

FOLDER Codes:

Sites ---> \system\sites\[sitecode]

System --> \system\shared

Users --> \system\users\[user id]

Logs --> \system\logs\[program]\

 

 

TABLE NAME

FOLDER

DESCRIPTION

Address

sites

Address table for referring physicians

Alerts

system

Configuration for MTALERT

Audits

system

QA audit results

Authors

users

Authors that use the MTRDR voice reader

Backup

system

Backup log

Batch

system

Batch Print queues

Batchprt

system

Batch Print definitions

Batchque

system

Batch Print detail

Calcs

system

Calculation records

ChartNetShared.ADD

system

Database Data Dictionary

[log files]

logs

Application log files

Commitment

system

Transcriptionist commitments

Config

system

Program configuration profiles

CrossRef

system

Used for cross-referencing ChartNet identifiers with exterminal system identifiiers. Used in the iKnowmed interface.

CurrentUsers

system

Current active users accessing the system

Deleted

sites

Deleted site reports

Device

system

Devices table

Distlog

system

Distribution log table

Distrib

system

Distribution queue

Doctors

sites

Site doctors table

Events

system

Used by MTALERTS and all

Faxq

system

Fax recipients table

FaxDtl

system

Fax details table - one record per report

Fields

system

Data entry fields table. Used to build RDS screen.

Forms

system

Site forms table

GenDict

system

Site Generic Dictionary. Used to hold any coded fields

JobCtrl

system

Job Control table used by the Service Controller (mtctrl)

MiscData

system

Used to store misc data. Used in the iKnowmed interface.

MPI

sites

Site Master Patient Index

Orders

sites

Site orders table

NetMon

system

* No longer used. Marked for deletion

Params

system

Program parameter definitions

QAProfiles

system

QA Sampling profiles

QASamples

system

Results of the QA sampling runs

Rates

system

Calculation override table for payroll

RepComp

users

Working table to hold completed reports log

RepHist

users

Working table to hold a history of reports accessed by the client

RepIndex

system

Reports index

Reports

sites

Site master Reports table

ReptCat

system

Reports catalog for R&R report writer

Schedule

system

Schedule table used for the Mobile application

Scripts

system

Scripts for the file Wizard to use.

Servers

system

List of servers and their purpose

Sites

system

Master list of sites

ExpandType

users

Text expander (speed typing)

Stats

system

Statistics master file

Statsarchive

system

Archived Stats table

Statssum

system

Compiled statistics for daily, weekly, monthly trending

Sys

system

System table. Contains just one record.

Template

system

Site Templates table

Usergrp

system

User Groups table

Userlog

system

User activity log table

User

system

Users table

VImport

system

Voice Import Profiles table

Voice

system

Voice Jobs table

Vociearchive

system

Archived Voice table

VRAuthors

system

Voice Rec authors table

VRVendors

system

Voice Rec vendors table

Workflow

system

Work flow table

Workpool

system

Work pools table