Observational Health Data Sciences and Informatics

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