OpenRIMS-RPM - Configuration Part 1

This section describes how to use the WHO ATC/DDD standard in OpenRIMS-RPM.

In the Anatomical Therapeutic Chemical (ATC) classification system, the active substances are divided into different groups according to the organ or system on which they act and their therapeutic, pharmacological, and chemical properties. Drugs are classified at five different levels.

Details and tutorials can be found here https://www.who.int/tools/atc-ddd-toolkit/atc-classification.

WHO provides a free online actual electronic list of internationally recognized ATC here https://www.whocc.no/atc_ddd_index/.

In addition, https://www.whocc.no/atc_ddd_index_and_guidelines/order/ the ATC data can be ordered in MS Excel format at a cost.

Along with ATC codes and active substances, the ATC list contains Defined Daily Dosage (DDD) for active substances. The DDD provides Units of Measurement (UOM) and Routes of Administration dictionaries.

Thus, the electronic list from WHO provides to Pharmadex 2:

• Active ingredients, recognized by WHO and grouped by ATC codes (who.atc.human)
• WHO Dosage units dictionary (dictionary.who.uom)
• WHO route of administration dictionary (dictionary.who.adminroute)

This manual intends for the OpenRIMS-RE supervisor user that is responsible for data maintenance.

Source Data

The data supported by WHO can be ordered here  https://www.whocc.no/atc_ddd_index_and_guidelines/order/. This data contains English and Spanish versions of actual ATC/DDD registered in WHO. The data is in MS Excel (xlsx) format.

Import data

Figure 1 Import the WHO ATC-DDD file

1. Download the non-official MS Excel file of WHO online data for 2021-12-03 only if you do have not the official data https://www.whocc.no/atc_ddd_index_and_guidelines/order/.
2. Upload the MS Excel file to import
3. Press “Save” to start the import. The import process will be run in the background. It is possible to do another job, however, the content of the ATC component will be locked.
4. Press “Reload” to check the status – how many imported, how many are left
5. Intermediate and final statuses will be found under the “dataimport_result”
6. The result of the importing will be available here (Figure 2)

Figure 2 The result of the importing

In addition, such dictionaries will be created:

• dictionary.who.uom – Units of measures
• dictionary.who.adminroute – administrate routes

The values of these dictionaries are from DDD columns in the Excel file. These values are abbreviations that are not clear for a plain user. After the import, it will be recommended to add descriptions of them manually using the official WHO sources https://www.whocc.no/atc_ddd_index/.

Re-import

The complete data file should be used for re-import. Follow the same procedure as for the initial import. The re-import procedure:

1. Makes unusable all ATC records that are not present in the Excel file
2. Add new ATC records to the database that is present in the Excel file, but not present in the database

The e-import software determines the ATC record in the Excel file and the database as the same when all the following conditions will occur:

• ATC codes are equals
• DDD, UoM, and Admin Route are equal or empty in the both

For dictionaries  dictionary.who.uom and dictionary.who.adminroute:

• The existing data will not be re-written
• The new abbreviations will be added

Country specific data

It is possible when a country uses active ingredients, UoMs, and routes of administration, that are not listed in the WHO data. In this case, this data should be added manually.

• For the active ingredients, country-specific records should be added to the end of the WHO data. The coding and description should follow rules for a particular country.
• UOMs should be added to the dictionary.who.uom
• Route of Administration should be added to the dictionary.who.adminroute

Languages

For current, it is no way to determine ATC and active ingredient data in the national language. This feature will be added soon.

For dictionary.who.uom and dictionary.who.adminroute it is possible to add data in the national language like to any other dictionary.

Usage

Component “ATC”

The “ATC” component is dedicated to selecting ATC codes. Details can be found here http://redmine.inka.in.ua/documents/129. From November 2022 this component will be deprecated in favor of the “links” component.

Figure 3 ATC component

Figure 4 ATC component configuration

Component “links”

The “links” is a universal component that allows adding references to the:

• Application's data
• Imported legacy data
• Imported ATC codes

Details can be found here http://redmine.inka.in.ua/documents/129. The usage of this component is strongly recommended instead of the ATC component.

Figure 5 Usage of component "links" for active ingredient references

Figure 6 The configuration of the component above

The value of the field “Name” is “Yes, thus the selection will be copied to literals:

• prefLabel - selected ingredient
• description - selected ingredient along with ATC, DDD, and notes
• atc - ATC code