Creating Tables

Top  Previous  Next

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 arrow 835 Table Creation in the main menu.
 
table-menu2
The "835 Table Creation" menu
2.The following window will be displayed.
 
table-window2
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."

table7
The "Save" button

On each tab, click "Execute Script" to create the corresponding table in the database.

table9
The "Execute Script" button

Once the table has been created successfully, you will see the following notification:

table8
The success message

The following screen-shots displays MySQL script to create tables.

table11
The "Payments" tab

table12
The "Claims" tab

table14
The "Claim Level Adj" tab

table13
The "Claim Lines" tab

table15
The "Claim Line Adj" tab

table16
The "Provider Level Adj" tab