|
<< Click to Display Table of Contents >> Creating 999 Files Tables |
  
|
|
<< Click to Display Table of Contents >> Creating 999 Files Tables |
|
999 files are acknowledgment documents that confirm if a file was received, as well as if whether the transmission was accepted or rejected.
Similar to creating database tables, you can create tables with a provided set of scripts you may modify to your specific needs. Follow the steps below to create 999 file tables:
1.Go to EDI Exchange > Create 999 Files Tables in the main menu window.
The "Create 999 Files Tables" is under the "EDI Exchange" tab.
2.The "Create Tables for 999 Files" window will open. Here, you can manage the creation and modification of your tables in the database.
The "Create Tables for 999 Files" window.
3.Select the database type you use for your host HIPAAsuite application. There are four database options:
oMicrosoft SQL Server
oMySQL
oOracle
oDB2
Note: If your database is not listed, you may modify the scripts as needed or ask your database administrator to make the necessary modifications.
4.Below the database options are four tabs with the different table script categories. See the details for each below:
This table contains information about Acknowledgment in SQL statements to create the "ImplementationAck" table in your database.
This table contains individual transactions contained in 999 files as SQL statements to create the "TransactionResponse" table in your database.
This table contains individual erroneous segments contained within 999 transactions as SQL statements to create the "SegmentErrors" table in your database.
The table contains the elements in error in a specific segment as SQL statements to create the "ElementNotes" table in your database.
5.Click on the tab with the script you wish to create. You can modify the scripts so that they run on your specific database. Once you have modified the script, click "Save."
Note: Every database system has syntax idiosyncrasies, thus the scripts might require tweaking. You may edit the table scripts and save your modified scripts. For example, if "date," "time," or "money" data types do not exist in the SQL Server, you can rename those types to '"datetime" and save your script to run it.
The "Save" button.
6.If you are ready to apply the script you just saved, click on "Execute Script." Please ensure that you both save and then click on "Execute Script" before changing and/or closing any tab. Otherwise, any changes you make will not take effect and will not be stored in the database.
The "Execute Script" button.
7.HIPAAsuite products go through continual development and improvements. Often these changes lead to new fields in the database. While it is easy to drop a table and regenerate it with the new fields, you will lose all existing data in the table. To avoid this, click "Compare Script with existing Table." If you click this, the table structure in your database will be compared with the current script. This will also prevent any double-execution, which could wipe out any previous existing data. Remove the script files once you have created the tables so nobody can destroy previous tables by accident.
The "Caution" window warning about a possible double-execution.
8.If the table is up to date, you will see this message:
A notification will pop up if the table is up to date.
If your table is missing recently added fields, you will see a window showing an "Alter Table" script with which you can add those fields to the table without interfering with existing data:
The "Changes to your table" window will show if there are missing or altered fields.
9.After you make the changes, click the "Execute Script" button and the field will be added and a message will confirm your changes:
The message window if a table was modified successfully.
10.Once the table has been created successfully without any errors, you will see the following message:
The success message window if a table was created.