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 Last revision Both sides next revision | ||
|
documentation:vocabulary:bdpm [2016/07/15 14:05] dimshitc1 |
documentation:vocabulary:bdpm [2016/07/21 13:26] 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 | + | |
| + | |||
| + | 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. | ||
| 2.Brand Names rules | 2.Brand Names rules | ||
| Line 24: | Line 26: | ||
| 61546829 solution 9745 NORADRÉNALINE 1 mg 1 ml de solution à diluer pour perfusion FT 1 | 61546829 solution 9745 NORADRÉNALINE 1 mg 1 ml de solution à diluer pour perfusion FT 1 | ||
| - | keep only those ingredients that are standard, so in drug_strength we'll have only | + | keep only those ingredients that are standard, so in drug_strength we'll have only standard ingredient and it's dosage |
| 61546829 solution 9745 NORADRÉNALINE 1 mg 1 ml de solution à diluer pour perfusion FT 1 | 61546829 solution 9745 NORADRÉNALINE 1 mg 1 ml de solution à diluer pour perfusion FT 1 | ||
| - | 7.**non-drugs**// | + | 7.**non-drugs**\\ |
| - | defined by the rules defined here, //http://www.ohdsi.org/web/wiki/doku.php?id=documentation:vocabulary:domains// | + | defined by the rules defined here, \\ http://www.ohdsi.org/web/wiki/doku.php?id=documentation:vocabulary:domains\\ |
| for example OLICLINOMEL N7-1000 E, émulsion pour perfusion is a parenteral nuntition that is non-drug | for example OLICLINOMEL N7-1000 E, émulsion pour perfusion is a parenteral nuntition that is non-drug | ||
| + | |||
| + | 8. **Brand Names**// | ||
| + | We create mappings for Brands, mostly we find direct equivalents like | ||
| + | BREVIBLOC maps to 19021087 Brevibloc | ||
| + | BREVOXYL maps to 19056868 Brevoxyl | ||
| + | BRICANYL maps to 19021117 Bricanyl | ||
| + | BRIDION maps to 35604510 Bridion | ||
| + | \\ | ||
| + | also make relationships if there is a little difference | ||
| + | SERC maps to 19052958 Serc-8 | ||
| + | DALACINE maps to 19054051 Dalacin T | ||
| + | ESTRADERM TTS maps to 19100516 Estraderm TTS 25 | ||
| + | ORALAIR maps to 45776959 Oralair 100 | ||
| + | STRIVERDI RESPIMAT maps to 45775118 Striverdi | ||
| + | NERISONE C maps to 19053642 Nerisone | ||
| + | \\ | ||
| + | 9. Homeopathic Drugs having din_7 don't have relationships and drug_strength, they exists only in drug_concept_stage. | ||
| + | \\ | ||
| + | 10. Dosage recalculation rules: | ||
| + | -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.txt · Last modified: 2016/07/21 13:55 by dimshitc1
Page Tools
