This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
documentation:vocabulary:atc [2021/10/04 13:28] ptalapova [The OMOP conversion of ATC Administation Routes] |
documentation:vocabulary:atc [2021/10/06 15:54] (current) ptalapova [Sources] |
||
---|---|---|---|
Line 4: | Line 4: | ||
==== Sources ===== | ==== Sources ===== | ||
- | ATC source codes are obtained from [[https://www.whocc.no/atc_ddd_index|WHOCC ATC/DDD Index 2021]] and, in OMOP, stored in the table of [[https://drive.google.com/file/d/1CJY739Obztme3mlnk89TttbT0_1zQ1rS/view?usp=sharing|class_drugs_scraper]] | + | ATC source codes are obtained from [[https://www.whocc.no/atc_ddd_index|WHOCC ATC/DDD Index 2021]] and, in OMOP, stored in the table of [[https://drive.google.com/file/d/1VX2HRw71Wac7BIN_gh5EOUxNwAF-DqwW/view?usp=sharing|class_drugs_scraper]] |
==== Transformation ===== | ==== Transformation ===== | ||
Line 51: | Line 51: | ||
^ relationship_id ^ reverse ^ target\\ vocabulary_id ^ description ^ | ^ relationship_id ^ reverse ^ target\\ vocabulary_id ^ description ^ | ||
- | | ATC - RxNorm | RxNorm - ATC | RxNorm, RxNorm Extension | ■ connects ATC Classes and Drug Products, but not Ingredients\\ ■ technically non-hierarchical, however, semantically it resembles 'Subsumes' - 'Is a' | | + | | ATC - RxNorm | RxNorm - ATC | RxNorm, RxNorm Extension | ■ connects ATC Classes and Drug Products, but not Ingredients\\ ■ technically non-hierarchical, however, semantically it resembles the 'Subsumes' relationship_id with the reverse of 'Is a' | |
- | | ATC - RxNorm pr lat | RxNorm - ATC pr lat | RxNorm, RxNorm Extension | ■ //ATC - RxNorm primary lateral// connects:\\ -- Monocomponent ATC Classes with their full semantic equivalents in the form of main active Standard Ingredients\\ -- the 1st Active Ingredient of Multicomponent ATC Classes with Standard Ingredients\\ ■ used as a Primary unambiguous link for ATC Classes with a clear and well-defined Ingredient \\ ■ non-hierarchical \\ ■ semantically, it is an equivalent to ‘Maps to’ relationship_id, and usually (except for exemptions) has such a pair in concept_relationship_stage | | + | | ATC - RxNorm pr lat | RxNorm - ATC pr lat | RxNorm, RxNorm Extension | ■ //ATC - RxNorm primary lateral// connects:\\ -- Monocomponent ATC Classes with their full semantic equivalents in the form of main active Standard Ingredients\\ -- the 1st Active Ingredient of Multicomponent ATC Classes with Standard Ingredients\\ ■ used as a Primary unambiguous link for ATC Classes with a clear and well-defined Ingredient \\ ■ non-hierarchical \\ ■ semantically, it is an equivalent to ‘Maps to’ relationship_id, and usually (except for exemptions) has such a pair in concept_relationship | |
| ATC - RxNorm sec lat | RxNorm - ATC sec lat | RxNorm, RxNorm Extension | ■ //ATC - RxNorm secondary lateral// connects the 2nd Active Ingredient OR any subsequent Active Ingredient of a Multicomponent ATC Class to Rx/RxN Standard Ingredient\\ ■ non-hierarchical\\ ■ used as a Secondary unambiguous link for ATC Classes with clear and well-defined Ingredient(s)\\ ■ the presence of this link is a prerequisite for creating a ‘Maps to’ relationship_id | | | ATC - RxNorm sec lat | RxNorm - ATC sec lat | RxNorm, RxNorm Extension | ■ //ATC - RxNorm secondary lateral// connects the 2nd Active Ingredient OR any subsequent Active Ingredient of a Multicomponent ATC Class to Rx/RxN Standard Ingredient\\ ■ non-hierarchical\\ ■ used as a Secondary unambiguous link for ATC Classes with clear and well-defined Ingredient(s)\\ ■ the presence of this link is a prerequisite for creating a ‘Maps to’ relationship_id | | ||
| ATC - RxNorm pr up | RxNorm - ATC pr up | RxNorm, RxNorm Extension | ■ //ATC - RxNorm primary upward// connects the 1st Ingredient Groups of Multicomponent ATC Classes to respective Rx/RxN Standard Ingredients\\ ■ applied to Multicomponent ATC Classes, which names:\\ -- starts either from the Ingredient Group or the word of combinations\\ -- contains only one Ingredient Group, which is mentioned somewhere in the middle\\ ■ hierarchical (applied at the post-processing, gives +1 level of separation)\\ ■ used as Primary ambiguous link, in which ATC Class is represented with a particular group of Ingredients with a common trait\\ ■ can be used for a well-defined but diverse group of ingredients (e.g. diastase, tree pollen, feather) | | | ATC - RxNorm pr up | RxNorm - ATC pr up | RxNorm, RxNorm Extension | ■ //ATC - RxNorm primary upward// connects the 1st Ingredient Groups of Multicomponent ATC Classes to respective Rx/RxN Standard Ingredients\\ ■ applied to Multicomponent ATC Classes, which names:\\ -- starts either from the Ingredient Group or the word of combinations\\ -- contains only one Ingredient Group, which is mentioned somewhere in the middle\\ ■ hierarchical (applied at the post-processing, gives +1 level of separation)\\ ■ used as Primary ambiguous link, in which ATC Class is represented with a particular group of Ingredients with a common trait\\ ■ can be used for a well-defined but diverse group of ingredients (e.g. diastase, tree pollen, feather) | |