Before data export, you need to create the tables through SQL table statements. You can do this using the built-in function of the HIPAA Claim Payment Master. Creating these tables is a quite intimidating task. Once you have your connection defined and tested, follow the instructions below.
| 1. | Select the Data Export  835 Table Creation in the main menu.  The "835 Table Creation" menu |
| 2. | The following window will be displayed. The "Create Tables" window |
| 3. | Define the following options: |
Database
| • | Microsoft SQL Server |
| • | MySQL/Genetic |
Tabs
On the following tabs there are SQL scripts used to create the appropriate tables:
| • | Payment |
| • | Claims |
| • | Claim Level Adj |
| • | Claim Lines |
| • | Claim Line Adj |
| • | Provider Level Adj |
Tip: You can modify the scripts so that they run on your specific database.
On each tab, click "Save."
The "Save" button
On each tab, click "Execute Script" to create the corresponding table in the database.
The "Execute Script" button
Once the table has been created successfully, you will see the following notification:
The success message
The following screen-shots displays MySQL script to create tables.
The "Payments" tab
The "Claims" tab
The "Claim Level Adj" tab
The "Claim Lines" tab
The "Claim Line Adj" tab
The "Provider Level Adj" tab