Skip Headers
Oracle® Healthcare Master Person Index Working With HPD Profile Application User's Guide
Release 3.0

E62313-01
Go to Table of Contents
Contents
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

3 Creating MPI and HPD Database Tables

This chapter provides procedures that lead you through creating HPD Application databases and tables.

Creating MPI and HPD Application Database Tables

After installing OHMPI, you need to create database tables for both Individual/Organizational Provider MPI and HPD Application. You must create these tables before you can work with the HPD Application. You can either create the database tables through OHMPI design-time (which is recommended), or create them manually.

For instructions on creating databases and tables using OHMPI design-time, see Creating MPI and HPD Database Tables Automatically.

For instructions on creating database tables manually, see Creating Individual Provider MPI Database Tables Manually.

Creating MPI and HPD Database Tables Automatically

The following three database schemas are created:

  • Schema for Individual Provider MPI (default: hpd_ip)

  • Schema for Organizational Provider MPI (default: hpd_op)

  • Schema for HPD Relationship (default: hpd)

  1. Right-click the name of your HPD Project in the left panel of the NetBeans IDE and choose Create Database.

    The Create Database dialog appears. Provide the credentials for an existing Oracle server.

  2. With the Root Connection tab selected, do the following to configure the database:

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

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

    • SID/Service Name: Oracle System Identifier or service name

    • Root User: The login name of the root user to the database.

    • SQL URL: The URL for the database (This is automatically generated.)

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

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

  5. With the Schema-Ind Provider tab selected, do the following to configure the database user for the Individual Provider MPI:

    • Accept the default database user for the Individual Provider MPI or type a new user.

    • Accept the default password or type a new password.

    • Click View to view a selected database script. A database script (for example, adding/removing MPI source systems) has to be edited from the corresponding Individual Provider MPI Project.

    • Click Run All to run all the database scripts in the current tab.

  6. Repeat step 5 for Schema-Org Provider and Schema-HPD.

    The Privileges tab identifies the Oracle privileges given to each created user and it is for information only.

Creating Individual Provider MPI Database Tables Manually

Before you begin, make sure you have Oracle installed as a service with remote host access enabled.

To Create the Individual Provider MPI Database Tables

To create the individual Provider MPI Database tables, perform the following:

  1. Create an Oracle environment and user (for example, hpd_ip) for the Individual Provider MPI 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 source systems with which you will be sharing data.

    See step 5 for the location of systems.sql file.

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

  3. (Optional) Open codelist.sql in a text editor, and add any common code information you need for the Individual Provider MPI Project.

    See step 5 for the location of codelist.sql file.

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

    The default configuration does not use common code tables. Adding this feature will cause additional validations to be performed against incoming data.

  4. Log in to the hpd_ip schema as the user you created above.

  5. Run the following SQL files against the hpd_ip schema (<hpd_project_name>\<hpd_project_name>-IndProvider\src\DatabaseScript).

    The create.sql file must be run first.

    • create.sql

    • systems.sql

    • codelist.sql

    • create-index.sql

To Create the Organizational Provider MPI Database Tables

The procedure to create the Organizational Provider MPI Database tables is similar to the procedure in To Create the Individual Provider MPI Database Tables. Replace Individual Provider by Organizational Provider, and replace hpd_ip by hpd_op.

To Create the HPD Relationship Database Tables

Before you begin, create the individual provider MPI database tables and organizational provider MPI database tables. For instructions, see To Create the Individual Provider MPI Database Tables and To Create the Organizational Provider MPI Database Tables.

  1. Create an Oracle environment and user (for example, hpd) for the HPD relationship 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. Navigate to the directory to which you created the HPD Project, and then navigate to the src\DatabaseScripts folder.

    • create_hpd_ohmpi_tables.sql - creates all the HPD relationship tables.

    • drop_hpd_ohmpi_tables.sql - drops all the HPD relationship tables.

  3. Log in to the hpd schema as the user you created above.

  4. Run create_hpd_ohmpi_tables.sql against the hpd schema.