Before Creating Tables...

The scripts that are supplied with the HIPAA Claim Master will generate every field that is available for import. These are more than 260 fields in the claim header. You will not need all these fields. You can edit the scripts to only use the fields that your adjudication system requires. System performance will be better if you only select the needed fields.

Not all databases are supported. Most likely only Microsoft SQL server and MYSQL scripts are supplied. And even here different versions of the database behave differently. If you have database expertise, please modify the scripts accordingly. We invite you to submit improvements and requests.

If you encounter persistent errors with the script, we recommend you to work with the scripts within the database environment. SQL Server Enterprise Manager or SQLyog for example have an SQL query analyzer that helps you tweak the scripts until they run.

Also, feel free to contact us if you have any problems.

 

How to Create Tables

In order to facilitate the development, HIPAA Claim Master allows you to create the staging tables for your database where HIPAA Claim Master will export the claim data.

Before data export, you need to create the tables through SQL table statements. You can do it using the built-in function of the HIPAA Claim Master. Creating these tables is a quite intimidating task. Once you have your connection defined and tested, follow the instructions below.

Note: The tables are created via the "Drop Table" and "Create Table" commands. The scripts come from two files: EDI_Claims.sql and EDI_ClaimDetail.sql that are distributed with the application. Please, contact HIPAAsuite if you need help with the database setup.

1.Select the Data Base arrow Create SQL Table in the main menu.
 
create-table
The "Create SQL Table" menu
2.The following window will be displayed.
 
create-tables1
The "Create SQL Tables" window
3.Define the following options:

Database

Microsoft SQL Server
MySQL/Genetic
Oracle

Environment

Live Database
Test Database

Scripts

On the following tabs there are SQL scripts used to create the appropriate tables:

Claim Header Tables Script
Claim Detail Table Script

Tip: You can modify the scripts so that they run on your specific database and to conform to your database's specific SQL syntax. For each script, click "Save."

save-button
The "Save" button

For each script, click "Execute Script" to create the corresponding table in the database.

Warning: Executing the scripts will wipe out any previous tables that you created and you will loose all data.

execute
The "Execute Script" button

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

created
The success message