Creating Database Tables
Create a database table for each code source you want to import into Module for HIPAA in Integration Server Administrator. webMethods provides database scripts to create database tables for storing the imported data.
To create a database table
1. Verify that the database instance to which Trading Networks is configured to connect, is running.
2. Navigate to the directory location, Integration Server_directory \instances\default\packages\WmHipaa\config\dbscripts and locate CodeSourceDBCreateTable.sql script file.
3. Edit the CodeSourceDBCreateTable.sql script file to create tables using SQL queries. Create a table for each code source you want to import.
The table should contain the following columns.
a. "CODE" VARCHAR(column-length) NOT NULL PRIMARY KEY
b. "SHORT_DESCRIPTION" VARCHAR(column-length)
c. "LONG_DESCRIPTION" VARCHAR(column-length)
d. "CUSTOM" CHAR
e. "DELETED" CHAR
For example, to create a table that holds the list of codes from a code source 51, type the following SQL query.
CREATE TABLE "WMHIPAA_CODE_SET_51" ( "CODE" VARCHAR(255) NOT NULL PRIMARY KEY,
"SHORT_DESCRIPTION" VARCHAR(255),
"LONG_DESCRIPTION" VARCHAR(255),
"CUSTOM" CHAR, "DELETED" CHAR )
4. Run the SQL script file using the appropriate database client.
5. When prompted, connect to the same database instance that you configured when installing Trading Networks.