Support Tools

• EZClaim, EDI, and EZLink Manuals
• Medical Reports with Descriptions

EZClaim Software Updates

• Medical Billing Software Help
• Medical Insurance Support
• Billing Technical Information

Developer Information

We do not provide technical support on importing, exporting or custom programming.

Overview
EZClaim Advanced uses an Access 2000 database but can read both Access 97 and Access 2000 (and higher) databases.  The name of the database file is EZData.mdb and it normally installed in the C:\Program Files\EZClaim directory on XP machines and the C:\Users\Public\Documents\EZClaim directory on Vista.    

Importing and Exporting
To import or export data into EZClaim, you must use software that is able to interface with an Access database.  All ODBC compliant software will be able to provide this functionality.  For most users, Access is your best choice because of the easy to use import capabilities.

About Access 2000 and higher
Since EZClaim is a standalone program (does not need Access to operate correctly), it will work fine even if Access 2000 is not installed on your computer.

EZClaim Database Concept
EZClaim uses multiple tables to store data.  Each of these tables are linked to each other using a record key.  Some tables are simply lookup tables.  We suggest entering a test patient and claim then view the database tables to see where the data is stored.

Field Lists
EZClaim does not provide a database field list, we suggest entering a dummy claim that looks the way you would like to see it then review the database tables.  Field names and table names are self explanatory.

Table Descriptions

Overview

EZClaim is based on the 1500 form.  All fields of the 1500 form are included somewhere in the EZData database with some additional fields used for other purposes.  The field names are descriptive.  The main tables are described below.  EZClaim Advanced uses multiple 'library' tables for data lookup. 

Patient Table

The patient table holds all fields relating to the patient, insurance information, facility information, physician information, etc.  It basically holds all the fields of the 1500 form except for the box 24 line items which are stored in the Billing Item Table.   The primary key 'PatientID' is generated automatically by Access and can not be modified.

Billing Item Table

The billing item table holds the billing detail of a 1500 form sometimes referred to as service line items or dates of service.  Please remember that multiple line items can be associated with one 'claim'.   This is done using the ClaimID to connect with the Claim Form Table.

Claim Form Table

The claim form table links the Patient Table to the Billing Item Table.  It also holds information that needs to be saved with each 'claim'.  This includes data and time stamps as well as other claim data. 

Here is a graphical depictions of the connections.  Please remember that the PatientID in the Patient Table, the ClaimID in the Claim Table and the BillingItemID in the Billing Item Table are all generated by Access.  You can not set these values.