test

Working With the PIX/PDQ Manager

Creating the PIX/PDQ and ATNA Databases

If you did not choose to have the Healthcare Pack Installer automatically create the Master Index, PIX/PDQ and ATNA database tables, you need to create them manually before you can work with the PIX/PDQ Manager. Optionally, you can rerun the Healthcare Pack installer and deselect every option except Configure MySQL.

Before you begin, make sure you have MySQL installed as a service with remote host access enabled. Perform the following steps to create all databases:

ProcedureTo Create the Master Index Database

Before You Begin

The PIX/PDQ solution currently supports MySQL 5.1. Before you begin this process, be sure you have MySQL installed as a service with remote host access enabled.

  1. Create a schema in your MySQL environment named midm.

  2. Create a user for the Master Index tables by running the following command:

    grant create, alter, drop, delete, index, insert, select, trigger, update, create routine, alter routine, execute on midm.* to username identified by 'password';

    Substitute an actual user name and password for username and password in the above command. The default user name and password are both midm.

  3. Navigate to the directory to which you downloaded the PIX/PDQ projects during installation, and then navigate to PIXPDQCORE/MDMPIXPDQ/src/DatabaseScript.

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

    For more information about modifying this file, see Step 4: Define Master Index External Systems in Sun Master Index User’s Guide.

  5. Open codelist.sql in a text editor, and add any common code information you need for the master index system.

    For more information about code lists and modifying this file, see Step 5: Define Master Index Code Lists in Sun Master Index User’s Guide.

    Note –

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

  6. Log in to the midm schema as user you created above.

  7. Run the following SQL files against the midm schema. The create.sql file must be run first.

    • create.sql

    • systems.sql

    • codelist.sql

  8. Continue to To Create the PIX/PDQ Database Tables.

ProcedureTo Create the PIX/PDQ Database Tables

Before You Begin

Complete To Create the Master Index Database.

  1. Navigate to the directory to which you downloaded the PIX/PDQ projects during installation, and then navigate to the SQL folder.

  2. Open pixpdq_configuration_data.sql in a text editor, and add any systems you added to the systems.sql file in To Create the Master Index Database.

    You need to insert the corresponding namespace ID, universal ID, and encoding scheme for each new system; for example:

    insert into PIX_PDQ_SYSTEMS (NAMESPACEID, UNIVERSALID, ENCODINGSCHEME) values ('HOSPITAL1', '1.4.5.2.6.2.23455', 'ISO')

  3. Save and close the file.

  4. Log in to the midm schema as the user you created in To Create the Master Index Database.

  5. Run the following scripts against the midm schema in the order given.

    • create_pixpdq_configuration.sql

    • pixpdq_configuration_data.sql

  6. Continue to To Create the ATNA Repository Database.

ProcedureTo Create the ATNA Repository Database

Before You Begin

Complete To Create the PIX/PDQ Database Tables.

  1. Create a schema in your MySQL environment named arrdb.

  2. Create a user for the ATNA tables by running the following command:

    grant create, alter, drop, delete, index, insert, select, trigger, update, create routine, alter routine, execute on arrdb.* to username identified by 'password';

    Substitute an actual user name and password for username and password in the above command. The default user name and password are both arr.

  3. Navigate to the directory to which you downloaded the PIX/PDQ projects during installation, and then navigate to the SQL folder.

  4. Log in to the arrdb schema as the ATNA user you just created.

  5. From a SQL editor, run the arrdb.sql file against the arrdb schema.

  6. To Create the PIX/PDQ Checkpoint Database.

ProcedureTo Create the PIX/PDQ Checkpoint Database

Before You Begin

Complete To Create the ATNA Repository Database.

  1. Create a schema in your MySQL environment named monitor.

  2. Create a user for the checkpoint tables by running the following command:

    grant create, alter, drop, delete, index, insert, select, trigger, update, create routine, alter routine, execute on pixpdqcheckpoint.* to pixpdq identified by 'pixpdq';

  3. Navigate to the directory to which you downloaded the PIX/PDQ projects during installation, and then navigate to the SQL folder.

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

  5. Run the monitor.sql file against the pixpdqcheckpoint schema.

ProcedureTo Remove Existing Data from the Master Index Database

If you run test data through the PIX/PDQ Manager you can clear out the data to start over with a fresh database. This only clears out the master index tables, and does not affect the audit repository database, the PIX checkpoint database, or the PIX/PDQ tables in the master index database.

Note –

This procedure will only work on the default database; if you change the object structure and recreate the database, use the scripts provided in the master index project to drop the database tables. For more information, see Dropping Master Index Database Tables in Sun Master Index User’s Guide.

  1. Navigate to the directory to which you downloaded the PIX/PDQ projects during installation, and then navigate to the SQL folder.

  2. Log in to the midm schema as the midm user.

  3. From a SQL editor, run the clean_mdm.sql file against the midm schema.