documentation:vocabulary:bdpm
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
documentation:vocabulary:bdpm [2016/07/20 12:04] dimshitc1 |
documentation:vocabulary:bdpm [2016/07/21 13:55] (current) dimshitc1 |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | All the drug concepts have only relationship_id = 'Maps to' relates to RxNorm Extended or RxNorm concepts | + | Overall Structure of vocabulary is meets criteria described here:\\ http://www.ohdsi.org/web/wiki/doku.php?id=documentation:vocabulary:drug |
| - | 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) | + | All the drug concepts have only relationship_id = 'Maps to' relates to RxNorm Extended or RxNorm concepts. |
| - | bla-bla | + | RxNorm and RxNorm extended concepts have all usual relationships (between Ingredient and Drug, Brand Name and Branded Drug and other) and drug_strenght information. |
| - | 1.standard / non-standard ingredients | + | |
| - | 2.Brand Names rules | + | **We use active substance as Ingredient **\\ |
| + | 1. CIS_COMPO_bdpm table (containing drug and Ingredient dosages) contains both precise ingredient dosage (acting ingredient and base or salt it exists wiht) and dosage of active ingredient if such ambigousness is possible. We put in OMOP tables only active substance dosage. | ||
| - | 3.Forms | + | **2.Brand Names ** |
| + | Take from Drug_descr everything written by capital letter and use it as Brand Name | ||
| - | 4.Only DIN_7 as a concept_code | + | **3.Forms**\\ |
| + | There are drug form and route of administration defined in source tables. | ||
| + | So we used a combination of drug form and route of administration as Dose Form, translated that to English and fixed some inaccuracies occur in the source table | ||
| - | 5. concept_synonym table with original names | + | **4.Unique drug identifier/drug_code**\\ |
| + | DIN_7 used in CIS_CIP_bdpm table (packaging info) is used as unique drug identifier/drug_code; | ||
| + | But some Homeopathic drugs don't have packaging info and don't have din_7 code that is unique identifier, so we don't put it into our tables, | ||
| + | and "VACCIN RABIQUE INACTIVE MERIEUX", drug_code = '60253264' also doesn't have packaging info but anyway we put it to all our tabkes using drug_code as concept_code | ||
| + | |||
| + | **5. concept_synonym table**\\ | ||
| + | **concept_synonym** table contains original names and English translations,\\ | ||
| + | **concept table** contains only English translations of concepts | ||
| 6. packaging / ingredient combination as a way of ds_stage creation | 6. packaging / ingredient combination as a way of ds_stage creation | ||
| Line 52: | Line 62: | ||
| -take maximal dosage if interval | -take maximal dosage if interval | ||
| - | 11. Some Homeopathic drugs don't have packaging info and don't have din_7 code that is unique identifier, so we don't put in all our tables, | + | |
| - | and "VACCIN RABIQUE INACTIVE MERIEUX", drug_code = '60253264' also doesn't have packaging info but anyway we put it to all our tabkes using drug_code as concept_code | + | |
documentation/vocabulary/bdpm.1469016288.txt.gz · Last modified: 2016/07/20 12:04 by dimshitc1
Page Tools
