Creating a Database for the United States Patient Solution

This topic provides an example on how to create a user called usa. To create a different user, edit the createuser–usa.sql file. For links to instructions on the various tasks when setting up your healthcare solution, see United States Patient Solution Uses.

To see the United States Patient Solution template, go to https://open-dm-mi.dev.java.net/docs/solutions/usa-patient.html.

To Create a Database for the United States Patient Solution

Before You Begin

The Oracle scripts that come with the solution create a user identified as usa. They are located in the Solutions\NB\MI\project\USAPatient\sca\source\DatabaseScript directory.

1. As a SYSDBA user run the createuser-usa.sql script.

2. As the usa user, with a password of usa, run the following scripts.

   ---

   Tip –

   Run the create.sql script first.

   ---

   • create.sql

   • codelist.sql

   • systems.sql

   • createIndexes.sql

   • createUserCodeData.sql

See Also

• United States Patient Solution Using MDM

• Benefits of the United States Solution

• United States Patient Solution Template

• United States Patient Solution Uses