Load WHO Drug Dictionary Format C

For information about format C, go to http://who-umc.org.

1. Open the Dictionary Management Tool and click Who Drug Loader.
2. Enter the SYSTEM or DBA user password, the database name, and click OK.
3. In the WHO Drug Dictionary Loader dialog box, do the following:
   1. To load the dictionary into a separate schema, click Load New Tables.
   2. Select Dictionary Format—Format C or Format C3.

      Note:

      • For Dictionary Format, Format C3, WHODrug schema will have the table named WHO_DRUG_C3_MASTER and WHO_DRUG_C3_MEDICINAL_PRODUCT, instead of table WHO_DRUG_C_MASTER and WHO_DRUG_C_MEDICINAL_PRODUCT. These table will have the DRUG_NAME as Varchar2 (1500).

        Besides, this schema will also have views as WHO_DRUG_C_MASTER and WHO_DRUG_C_MEDICINAL_PRODUCT which will point to the tables WHO_DRUG_C3_MASTER and WHO_DRUG_C3_MEDICINAL_PRODUCT but the Drug Name is updated to Varchar2 (250).

      • For Dictionary Format, Format B3, WHODrug schema will have the table named WHO_B3_DRUG_DICT and WHO_B3_ATC_CODE, instead of table WHO_DRUG_DICT and WHO_ATC_CODE. These table will have the DRUG_NAME as Varchar2 (1500) and ATC_TEXT Varchar2 (110).

        Besides, this schema will also have views as WHO_DRUG_DICT and WHO_ATC_CODE which will point to the tables WHO_B3_DRUG_DICT and WHO_B3_ATC_CODE but the Drug Name is updated to Varchar2 (250) and Varchar2 (110).

   3. To create new user, click Create User. Enter the parameters and click OK.
   4. To create a new role, click Create Role. Enter the parameters and click OK.
   5. From the drop-down, select the Dictionary Version.
   6. Click Browse, navigate to the dictionary files and click Select.
4. Click Load.
5. From the Tablespace and Index drop-downs, select a table and an index.
6. Enter the SYSTEM or DBA user password, the database name, and click OK.
7. When the dictionary is loaded successfully, click OK.