Creating Tables

How to Create Tables

1.Go to Data Base > Create SQL Tables in the main menu window.

The "Create SQL Tables" menu.

The following window will be displayed.

5.2 999m table window

2.Define the following options:

Database

The "Database" box with the four database options.

Within the "Database" box, the user may select one of four Database options, as listed below:

oMicrosoft SQL Server

oMySQL/Generic

oOracle

oDB2

What if I do not have the Databases mentioned in the next sections?

There are four Database types the HIPAA 999 Master supports:

oMicrosoft SQL Server

oMySQL/Generic

oOracle

oDB2

In the following sections, you will see the scripts for each Database type. If you have a database that is not mentioned here, we recommend two options:

oHave a database administrator change the scripts to work.

oCreate the fields in your database administration tool according to the specifications in the scripts.

Scripts

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

·ImplementationAck Tables Script

·TransactionResponse Tables Script

·SegmentErrors Tables Script

·ElementNotes Tables 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."

The "Save" button.

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

Warning: If the database tables already exist, executing the “Create Table” scripts will drop and recreate those tables. This means:

·All existing data in those tables will be permanently lost.

·Any customizations made to the table structure will be overwritten.

Table already exists.

The "Execute Script" button.

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

5.7 999m success window