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