Creating a Database for the United Kingdom Patient Solution

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

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

To Create a Database for the United Kingdom Patient Solution

Before You Begin

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

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

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

   ---

   Tip –

   Run the create.sql script first.

   ---

   • create.sql

   • codelist.sql

   • systems.sql

   • createIndexes.sql

   • createUserCodeData.sql

See Also

• United Kingdom Patient Solution Using MDM

• Benefits of the United Kingdom Patient Solution

• United Kingdom Patient Solution Template

• United Kingdom Patient Solution Uses