documentation:vocabulary:dmd
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | |||
|
documentation:vocabulary:dmd [2016/07/06 11:54] dimshitc1 |
documentation:vocabulary:dmd [2016/07/14 12:23] (current) dimshitc1 |
||
|---|---|---|---|
| Line 6: | Line 6: | ||
| RxNorm and RxNorm extended concept then have all usual relationships and drug_strenght tables (between Ingredient and Drug, Brand Name and Branded Drug and other) | RxNorm and RxNorm extended concept then have all usual relationships and drug_strenght tables (between Ingredient and Drug, Brand Name and Branded Drug and other) | ||
| - | **1. Ingredients** | + | **1. Ingredients**\\ |
| all Ingredients and VTMs Maps to RxNorm or RxNorm Extension 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 | if there is VTM containing several ingredients, we map them to each ingredient | ||
| Line 24: | Line 24: | ||
| --can give an example only after script run | --can give an example only after script run | ||
| - | **2. Concept Classes** | + | **2. Concept Classes**\\ |
| Original dm+d classes (VTM, AMP, AMPP, etc.) are placed in column source_concept_class_id. | 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: | Concept_class_id is standardized and defined by the rules described here: | ||
| http://www.ohdsi.org/web/wiki/doku.php?id=documentation:vocabulary:drug | http://www.ohdsi.org/web/wiki/doku.php?id=documentation:vocabulary:drug | ||
| - | **3. Brand Names** | + | **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. | Dm+d doesn't provide Brand Name as a separate concept, so we parsed drug descriptions in order to get Brand names. | ||
| We use here not a clear Brand Name but any Name differs from Dose Form and Ingredient but used as a part of Drug name by Supplier, for example | We use here not a clear Brand Name but any Name differs from Dose Form and Ingredient but used as a part of Drug name by Supplier, for example | ||
| Line 39: | Line 39: | ||
| -- add example of RxNorm extension Brand Name concept when it'll be done | -- add example of RxNorm extension Brand Name concept when it'll be done | ||
| - | **4. Drug Packs:** | + | **4. Drug Packs:**\\ |
| built Drug Packs with RxNorm like relationships | built Drug Packs with RxNorm like relationships | ||
| - | **5. Devices** | + | **5. Devices**\\ |
| Dm+d vocabulary contains devices such as bandages, syringes, food supplements, etc. | 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. | 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 | Devices don't have RxNorm Extension equivalents and relationships, they present in OMOP vocabulary as standard concepts | ||
| - | **6. Supplier** | + | **6. Supplier**\\ |
| Supplier info added, made relationships between Marketed Drug Product and Supplier: relationships 'Has supplier' и 'Supplier of' as discribed | Supplier info added, made relationships between Marketed Drug Product and Supplier: relationships 'Has supplier' и 'Supplier of' as discribed | ||
| and between Marketed Drug Product and related Drug-concept relationship_id in ('Has marketed form', 'Marketed form of') | and between Marketed Drug Product and related Drug-concept relationship_id in ('Has marketed form', 'Marketed form of') | ||
| - | **7. Drug_strength issues** | + | **7. Drug_strength issues**\\ |
| Most part of the drugs are parsed into ds_stage and then into drug_strenght tables but some of them can't be, some examples of these unparsable drugs | Most part of the drugs are parsed into ds_stage and then into drug_strenght tables but some of them can't be, some examples of these unparsable drugs | ||
| No dosage given: | No dosage given: | ||
| Line 70: | Line 69: | ||
| so this 8.09g is totally useless in purpose of drug_strenght building | so this 8.09g is totally useless in purpose of drug_strenght building | ||
| + | **8. Percents recalculation** | ||
| + | mostly is obvious, but \\ | ||
| + | sometimes they don't give exact quantitative factor info so define it by the Drug form, for example | ||
| + | "Avoca 95% silver nitrate applicators (Bray Group Ltd) 100 applicator 10 x 10 applicators" | ||
| + | and this is "95% w/w (weight / weight) silver nitrate pencil " , in other words 0,95 mg / mg. | ||
| + | |||
documentation/vocabulary/dmd.1467806070.txt.gz · Last modified: 2016/07/06 11:54 by dimshitc1
Page Tools
