User Tools

Site Tools


documentation:vocabulary:bdpm

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
Last revision Both sides next revision
documentation:vocabulary:bdpm [2016/07/19 15:56]
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 47: Line 49:
 NERISONE C  maps to 19053642 Nerisone ​ NERISONE C  maps to 19053642 Nerisone ​
 \\ \\
-9. Homeopathic Drugs - what did we build for them, what didn't+9. Homeopathic Drugs having din_7 don'​t ​have relationships and drug_strength,​ they exists only in drug_concept_stage.
 \\ \\
 10. Dosage recalculation rules: 10. Dosage recalculation rules:
 -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.txt · Last modified: 2016/07/21 13:55 by dimshitc1