Observational Health Data Sciences and Informatics

This is an old revision of the document!

---

1. Ingredients all Ingredients and VTMs Maps to RxNorm or RxNorm Extension Ingredients if there is VTM containing several ingredients, we map them to each ingredient 18035211000001104 Co-dydramol → 1125315 Acetaminophen (RxNorm) 18035211000001104 Co-dydramol → 1189596 dihydrocodeine (RxNorm)

–example with RxNorm Extension when it will be build

some ingredients don't have exact mapping because RxNorm uses more precise version, like

10157211000001104 Melissa extract 44507591 Melilotus indicus whole extract 1 10157211000001104 Melissa extract 42904087 Melilotus officinalis top extract 2 10157211000001104 Melissa extract 42899425 Melissa officinalis extract 3 10157211000001104 Melissa extract 46234336 Melissa officinalis flowering top extract 4

then anlysing drugs containing these ingredients we find out wich ingredient RxNorm uses more often –can give an example only after script run

2. Concept Classes Original dm+d classes (VTM, AMP, AMPP, etc.) are placed in column source_concept_class_id. Concept_class_id is standardized and defined by the rules described here: http://www.ohdsi.org/web/wiki/doku.php?id=documentation:vocabulary:drug

3. Brand Names Dm+d doesn't provide Brand Name as a separate concept, so we parsed drug descriptions in order to get Brand names for example “Vastarel MR 35mg tablets (Imported (France))” →HAS Brand_name (Has ing)→ “OMOP246916 Vastarel MR” (RxE) OR

Stromectol 3mg tablets (Imported (France)) 20 tablet → HAS Brand_name (Has ing)→ 19081723 Stromectol (RxNorm)

4. Drug Packs: built Drug Packs with RxNorm like relationships

5. Dm+d vocabulary contains devices such as bandages, syringes, food supplements, etc. Please see http://www.ohdsi.org/web/wiki/doku.php?id=documentation:vocabulary:domains for Domain rules definition. Devices don't have RxNorm Extension equivalents and relationships, they present in OMOP vocabulary as standard concepts

6. Supplier

7.