This is an old revision of the document!
All the drug concepts have only relationship_id = 'Maps to' relates to RxNorm Extended or RxNorm concepts
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)
bla-bla 1.standard / non-standard ingredients
2.Brand Names rules
3.Forms
4.Only DIN_7 as a concept_code
5. concept_synonym table with original names
6. packaging / ingredient combination as a way of ds_stage creation
/ concept table with translations …
61546829 solution 2487 TARTRATE DE NORADRÉNALINE 2 mg 1 ml de solution à diluer pour perfusion SA 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
61546829 solution 9745 NORADRÉNALINE 1 mg 1 ml de solution à diluer pour perfusion FT 1
7.non-drugs
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
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 - what did we build for them, what didn't?