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] 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. | ||
+ |