Data table descriptions

Top  Previous  Next

 

Data Table Descriptions

 

 

Here is a listing of some databases and data tables that may be of interest. If this list is missing something you need, let us know.

 

Database container

Data table

Description

 

 

 

\Share\ptshare

m6nmco

insurance companies / payers

 

m6nmem

employers

 

m6nmfc

facilities / service locations

 

m6nmgu

guarantors

 

m6nmlb

laboratories

 

m6nmpt

patient demographics

 

m6nmptal

patient allergies

 

m6nmptph

patient phone numbers & email addresses

 

m6nmpv

rendering provider

 

m6nmrf

referring persons

 

m6nmsp

supervising persons

 

m6nmsu

subscribers

 

m6veac

financial classes

 

m6verc

recalls

 

m6vers

research

 

 

 

\Data\ptdata

m6ptdx

patient default diagnosis codes

 

m6ptif

patient information (notes on the main patient screen)

 

m6ptin

patient insurance information

 

m6ptnote

patient EMR

 

m6ptp1

patient billing accounts

 

m6ptp2

patient notes

 

m6ptrc

patient recall notes

 

m6pttrch

patient charges (service transactions)

 

m6pttrnc

patient non-charges (payments, adjustments, memos)

 

 

 

\ssipub\ptpub

m6dx

lookup diagnosis codes

 

m6mo

lookup procedure code modifiers

 

m6pc

lookup procedure codes

 

m6st

lookup states

 

m6thsf

lookup tooth & surfaces (dental database)

 

m6zp

lookup zip codes

 

m670pc

lookup dental procedure codes