8/15

3 Creating MPI and IHE Databases and Tables

This chapter provides procedures for creating Master Person Index and IHE Profiles Application databases and tables.

This chapter includes the following section:

• Creating the IHE Profiles Application Databases and Tables

Creating the IHE Profiles Application Databases and Tables

After installing Oracle Healthcare Master Person Index (OHMPI), you need to create the Master Person Index tables and IHE Profiles Application database tables. You must create these tables before you can work with the IHE Profiles Application. You can either create the databases and tables through OHMPI design-time (which is recommended), or create them manually.

Note:

Creating a database is optional; if desired you can create your own database.

To create databases and table manually, see Creating Master Person Index Databases and Tables for Oracle Manually.

To create databases and tables using OHMPI design-time, see Creating the Database and Tables Automatically.

To configure optional connecting information, see Maintaining Subscriptions to Patient Updates.

Creating Master Person Index Databases and Tables for Oracle Manually

Before you begin, ensure that you have Oracle installed as a service with remote host access enabled. Perform the following to create all databases:

To Create the Master Person Index Database

1. Create an Oracle environment and user for the Master Person Index tables by running the following command:

   grant CREATE SESSION, CREATE TABLE, CREATE TRIGGER, CREATE PROCEDURE, UNLIMITED TABLESPACE, CREATE TYPE to <USER_NAME> identified by <PASSWORD>

2. Open systems.sql in a text editor, and add the HL7 systems with which you will be sharing data.

   Note:

   See Step 5 for the location of this file.

   For more information about modifying this file, see Oracle Healthcare Master Person Index User's Guide.

3. Open codelist.sql in a text editor, and add any common code information you need for the Master Person Index system.

   Note:

   See Step 5 for the location of this file.

   For more information about code lists and modifying this file, see Oracle Healthcare Master Person Index User's Guide.

   Note:

   This step is optional. The default configuration does not use common code tables. Adding this feature causes additional validations to be performed against incoming data.

4. Log in to the mpi schema as the user you created earlier.

5. Run the following SQL files against the mpi schema (<project_name>\ihe-mpi\src\DatabaseScript). The create.sql file must be run first.

   • create.sql

   • systems.sql

   • codelist.sql

   • create-index.sql

Note:

To drop MPI tables, run the following SQL files against the mpi schema:

• drop-index.sql

• drop.sql

To Create the IHE Profiles Application Database Tables

Before you begin, complete To Create the Master Person Index Database.

1. Navigate to the directory to which you created the IHE Profiles <project_name> Application projects, and then navigate to the \src\DatabaseScripts folder.

   • create_ihe_ohmpi_tables.sql creates all the IHE Profiles Application tables.

   • create_ihe_ohmpi_sample_data.sql creates sample domain configuration data.

   • clean_ihe_ohmpi_tables.sql cleans all the records from IHE Profiles Application tables and MPI tables.

2. Open create_ihe_ohmpi_sample_data.sql in a text editor, comment out all existing insert statements, and add any systems you added to the systems.sql file in To Create the Master Person Index Database.

   You need to insert the corresponding namespace ID, universal ID, universal ID type and a description for each new system; for example:

   insert into IHE_DOMAINS (NAMESPACEID, UNIVERSALID, UNIVERSALIDTYPE, DESCRIPTION) values ('HOSPITAL1', '1.4.5.2.6.2.23455', 'ISO', 'HOSPITAL1 DESCRIPTION');

3. (Optional) To configure patient update notification, see Maintaining Subscriptions to Patient Updates.

4. Save and close the file.

5. Log in to the mpi schema as the user you created earlier.

6. Run the following scripts against the mpi schema.

   • create_ihe_ohmpi_tables.sql

   • create_ihe_ohmpi_sample_data.sql

Creating the Database and Tables Automatically

1. Right-click the name of your IHE Profiles Application project in the left panel of the NetBeans IDE (for example, IHEProject1) and select Create Database.

   The Create Database dialog box appears. Here you provide the credentials for an existing Oracle database.

2. Click the Root Connection tab and perform the following to configure the database:

   • Server Host: The name of the server where the database is located.

   • Root User - The login name to the database.

   • Root Password: The password used to log in to the database.

   • Server Port: The port number of the server where the database is located.

   • SQL URL: The URL for the database.

3. After the Connection requirements for the database are set, click Test Connection.

4. When satisfied with the Connection settings, click the User-Schema tab.

5. Click the User-Schema tab and perform the following to configure the database user:

   • View the user for the database from the list.

   • Accept the default password or enter a new password.

   • Click Apply.

6. Click the Database Scripts tab to view the scripts and then perform the following:

   • To run the scripts, click Run.

   • After the scripts complete running, click Close.

Maintaining Subscriptions to Patient Updates

The IHE Profiles Application was designed to be implemented with minimal required customizations. You can customize and extend the functionality of OHMPI's connectivity information for a product environment.

In order for a PIX Consumer to receive PIX Update Notifications from a source domain, add a subscription record to the IHE_PIXUPDATE_SUBSCRIPTIONS table. For example,

insert into IHE_PIXUPDATE_SUBSCRIPTIONS (CONSUMERID, SOURCENAMESPACEID, ACTIVE) values ('CONSUMER1', 'IHEGHCADT', 'T');

where CONSUMER1 identifies a PIX Consumer that receives updates and IHEGHCADT is the source domain that sends updates.

For each PIX Consumer that is interested in receiving PIX Update Notifications, a record describing the PIX Consumer's endpoint should be added to the IHE_PIXCONSUMER_ENDPOINTS table first.

Ensure that the following are correct when configuring PIX Consumer Endpoints:

• The identifier of the PIX Consumer. This needs to match the CONSUMERID in the IHE_PIXUPDATE_SUBSCRIPTIONS table.

• The endpoint type (either HL7V2 or HL7V3).

• The LLPType (applicable only if the endpoint type is HL7V2).

• The receiving URL for the PIX Consumer.

• The name of the HL7 application or device.

• The name of the facility or organization (organization is optional).

The following is an example describing a PIXv2 Consumer:

insert into IHE_PIXCONSUMER_ENDPOINTS (CONSUMERID, ENDPOINTTYPE, LLPTYPE, ADDRESS, APPL_DEV, FACL_ORG, DESCRIPTION) values ('CONSUMER1', 'HL7V2', 'MLLPv1', 'hl7://localhost:9906', 'SUNPIXPDQRAD', NULL, 'Test domain');

The following is an example describing a PIXv3 Consumer:

insert into IHE_PIXCONSUMER_ENDPOINTS (CONSUMERID, ENDPOINTTYPE, LLPTYPE, ADDRESS, APPL_DEV, FACL_ORG, DESCRIPTION) values ('CONSUMER2', 'HL7V3', NULL, 'http://localhost:8080/PIXConsumer2_Service/PIXConsumer2', '1.2.840.114350.1.13.99997.2.3412', NULL, 'Test domain');