User Tools

Site Tools


documentation:vocabulary:atc

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
documentation:vocabulary:atc [2021/10/04 13:28]
ptalapova [The OMOP conversion of ATC Administation Routes]
documentation:vocabulary:atc [2021/10/06 15:54]
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) ​ |
documentation/vocabulary/atc.txt · Last modified: 2021/10/06 15:54 by ptalapova