1. Administration Guide
  2. Dictionaries Management
  3. Dictionaries management using the Dictionary Management Tool
  4. WHO Drug dictionaries using the Dictionary Management tool
  5. Load WHO Drug Dictionary

Load WHO Drug Dictionary

Note:

By uploading a version of WHODrug Enhanced, WHODrug Global, WHODrug Chinese, or other UMC products, you confirm holding a valid license granted by the UMC for the uploaded UMC product.
  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. From the Dictionary Format drop-down, select an option.
      • For English dictionaries, select Format B or Format B3, or Format C or Format C3.

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

      • For Chinese dictionaries, select Format B3 Chinese or Format C3 Chinese.

      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.

Parent topic: WHO Drug dictionaries using the Dictionary Management tool