User Tools

Site Tools


documentation:vocabulary:mapping

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:mapping [2019/12/13 16:02]
ptalapova
documentation:vocabulary:mapping [2020/12/09 10:56] (current)
ptalapova
Line 1: Line 1:
 ===== Mapping of Concepts ===== ===== Mapping of Concepts =====
  
 +  * **Mapping**,​ also known as **a map**, is an association between a particular concept in one code system or 
 +  *  dataset and code in another, rarely the same, code system that has the same (or similar) meaning.
 +  * Also, **Mapping** is the process to transform one concept into a Standard one. The Standardized Clinical Data Tables allow only Standard Concepts, thus all other codes used in the source databases have to be translated to Standard Concepts.
 +  * Mapping is done through records in the CONCEPT_RELATIONSHIP table. They connect each Concept to a Standard Concept through a number of special relationship_id:​
  
-**Mapping** is the process to transform one Concept to another. The clinical data tables of the CDM allow only Standard Concepts. All other codes used in the source databases have to be translated to Standard Concepts.  +^ Relationship ID    ^ Purpose ​                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            ​^ Features ​                                                                                                                                                             ^ 
- +| **Maps to**        | Mapping a Source Concept to a Standard Concept to be placed into the following fields of :​[[https://​github.com/​OHDSI/​CommonDataModel/​wiki/​Standardized-Clinical-Data-Tables|Standardized Clinical Data Tables]]:\\ • **condition_concept_id**\\ • **observation_concept_id**\\ • **measurement_concept_id**\\ • **drug_concept_id**\\ • **procedure_concept_id**\\ • **device_concept_id** ​etc. \\ \\ Note, that this relationship is also used for mapping of concepts to populate **value_as_concept_id**. ​ | • stands for either a full equivalence or an “uphill” mapping (mapping to a more general semantic category)\\ \\ • can be single or multiple for each Source Concept ​ | 
-Mapping is done through records in the CONCEPT_RELATIONSHIP table. They connect each Concept to a Standard Concept through a number of special relationship_id:​ +| **Maps to value** ​ | A special mapping between a Source Concept and a Standard Concept to be placed into the **value_as_concept_id** field of the MEASUREMENT and OBSERVATION tables ​                                                                                                                                                                                                                                                                                                                                                    ​| • points to a concept, indicating the value of Measurements or content of Observations\\ \\ • is used only in combination with a single “Maps to”                     |
- +
-^ Relationship ID    ^ Purpose ​                                                                                                                                                                                                                                                                                                                                                                                          ​^ Features ​                                                                                                                                                             ^ +
-| **Maps to**        | Mapping a Source Concept to a Standard Concept to be placed into the following fields of :​[[https://​github.com/​OHDSI/​CommonDataModel/​wiki/​Standardized-Clinical-Data-Tables|Standardized Clinical Data Tables]]:\\ • **condition_concept_id**\\ • **observation_concept_id**\\ • **measurement_concept_id**\\ • **drug_concept_id**\\ • **procedure_concept_id**\\ • **device_concept_id** ​ | • stands for either a full equivalence or an “uphill” mapping (mapping to a more general semantic category)\\ \\ • can be single or multiple for each Source Concept ​ | +
-| **Maps to value** ​ | A special mapping between a Source Concept and a Standard Concept to be placed into the **value_as_concept_id** field of the MEASUREMENT and OBSERVATION tables ​                                                                                                                                                                                                                                  ​| • points to a concept, indicating the value of Measurements or content of Observations\\ \\ • is used only in combination with a single “Maps to”                     |+
  
 === "Maps to" Relationships === === "Maps to" Relationships ===
Line 14: Line 14:
   * Concepts participating in the “Maps to” mapping are Source (Non-standard) Concepts and Standard Concepts. ​   * Concepts participating in the “Maps to” mapping are Source (Non-standard) Concepts and Standard Concepts. ​
   * The mapping always attempts to reflect the semantics of a Source Concept by an Equivalent Standard Concept. ​   * The mapping always attempts to reflect the semantics of a Source Concept by an Equivalent Standard Concept. ​
-  * Equivalent carries the same meaning, covers the same semantic space and, importantly,​ has the same parents and children in the hierarchy (if there are any) as well. If an equivalent Concept is not available, the mapping matches to a more generic Standard Concept(s). This ensures that a query in the target vocabulary will retrieve the same records as if they were queried in the original source vocabulary.+  * Equivalent carries the same meaning, covers the same semantic spaceand, importantly,​ has the same parents and children in the hierarchy (if there are any) as well. If an equivalent Concept is not available, the mapping matches to a more generic Standard Concept(s). This ensures that a query in the target vocabulary will retrieve the same records as if they were queried in the original source vocabulary.
   * Source Concepts are mapped or may be mapped to one or several Standard Concepts. If they are mapped to more than one Standard Concept, in the resulting CDM table, there is more than one record for each record in the source.   * Source Concepts are mapped or may be mapped to one or several Standard Concepts. If they are mapped to more than one Standard Concept, in the resulting CDM table, there is more than one record for each record in the source.
   * Standard Concepts are also mapped to Standard Concepts via "Maps to", this is a mapping to itself.   * Standard Concepts are also mapped to Standard Concepts via "Maps to", this is a mapping to itself.
 +  * If there are 2 or more similar Standard concepts in the OMOP vocabulary, please, report about it at the [[https://​forums.ohdsi.org/​c/​vocabulary-users|OHDSI Forum]] and unless it is fixed, as the first-line choice, use LOINC for Measurements and SNOMED for everything else.
 +  * If there are 2 similar Standard concepts within SNOMED, look at the domain (Morphologic abnormality is an Observation,​ Clinical finding is a Condition), revise attributes and hierarchy of both concepts (its number, fullness, and correctness). It is not necessary to compare the amount of relationships/​children precisely, just verify that all seems appropriate and the hierarchy is rich enough. If it does for both concepts, then choose concepts belonging to SNOMED International (short concept codes) rather than SNOMED US/UK Editions (long concept codes). If the length of concept codes is identical, then choose the one with a smaller number of concept_id.
  
 //**NB!** Classification Concepts (standard_concept='​C'​) do not have a mapping to a Standard Concept//. //**NB!** Classification Concepts (standard_concept='​C'​) do not have a mapping to a Standard Concept//.
  
 Examples of usage: Examples of usage:
-^ source ​ concept code                                                                                                  ^ source concept name                                                                    ^ relationship ID  ^ standard concept ID  ^ standard concept code  ^ standard concept name                                                                            ^ +^ source ​ concept code                                                                                                ^ source concept name                                                                    ^ relationship ID  ^ standard concept ID  ^ standard concept code  ^ standard concept name                                                                            ^ 
-^  Single ​ “Maps to” for mapping to an Equivalent Standard Concept ​                                                                                                                                                                                                                                                                                                             |||||| +^  Single ​ “Maps to” for mapping to an Equivalent Standard Concept ​                                                                                                                                                                                                                                                                                                             |||||| 
-| M65.3                                                                                                                 ​| Trigger finger ​                                                                        | Maps to          | 763891 ​              | 448251000124102 ​       | Trigger finger ​                                                                                  | +| M65.3                                                                                                               ​| Trigger finger ​                                                                        | Maps to          | 763891 ​              | 448251000124102 ​       | Trigger finger ​                                                                                  | 
-| A06                                                                                                                   ​| Amebiasis ​                                                                             | Maps to          | 438959 ​              | 111910009 ​             | Amebic infection ​                                                                                | +| A06                                                                                                                 ​| Amebiasis ​                                                                             | Maps to          | 438959 ​              | 111910009 ​             | Amebic infection ​                                                                                | 
-^  Single ​ “Maps to” for mapping to a Non-equivalent Standard Concept ​                                                                                                                                                                                                                                                                                                          ​|||||| +^  Single ​ “Maps to” for mapping to a Non-equivalent Standard Concept ​                                                                                                                                                                                                                                                                                                          ​|||||| 
-| D46.5                                                                                                                 ​| Refractory anaemia with multi-lineage dysplasia ​                                       | Maps to          | 4003185 ​             | 109996008 ​             | Refractory anemia ​                                                                               | +| D46.5                                                                                                               ​| Refractory anaemia with multi-lineage dysplasia ​                                       | Maps to          | 4003185 ​             | 109996008 ​             | Refractory anemia ​                                                                               | 
-| M81.50 ​                                                                                                               | Idiopathic osteoporosis,​ multiple sites                                                | Maps to          | 81390                | 3345002 ​               | Idiopathic osteoporosis ​                                                                         | +| M81.50 ​                                                                                                             | Idiopathic osteoporosis,​ multiple sites                                                | Maps to          | 81390                | 3345002 ​               | Idiopathic osteoporosis ​                                                                         | 
-^  Multiple “Maps to” for mapping to several Standard Concepts fully covering semantic space of a Source Concept ​                                                                                                                                                                                                                                                               |||||| +^  Multiple “Maps to” for mapping to several Standard Concepts fully covering semantic space of a Source Concept ​                                                                                                                                                                                                                                                               |||||| 
-| S61.1                                                                                                                 ​| Open wound of finger(s) with damage to nail                                            | Maps to          | 4054063 ​             | 125653000 ​             | Open wound of finger ​                                                                            | +| S61.1                                                                                                               ​| Open wound of finger(s) with damage to nail                                            | Maps to          | 4054063 ​             | 125653000 ​             | Open wound of finger ​                                                                            | 
-| :::                                                                                                                   ​| :::                                                                                    | Maps to          | 4167909 ​             | 275320004 ​             | Injury of nail                                                                                   | +| :::                                                                                                                 ​| :::                                                                                    | Maps to          | 4167909 ​             | 275320004 ​             | Injury of nail                                                                                   | 
-| I26.0                                                                                                                 ​| Pulmonary embolism with mention of acute cor pulmonale ​                                | Maps to          | 440417 ​              | 59282003 ​              | Pulmonary embolism ​                                                                              | +| I26.0                                                                                                               ​| Pulmonary embolism with mention of acute cor pulmonale ​                                | Maps to          | 440417 ​              | 59282003 ​              | Pulmonary embolism ​                                                                              | 
-| :::                                                                                                                   ​| :::                                                                                    | Maps to          | 312927 ​              | 49584005 ​              | Acute cor pulmonale ​                                                                             | +| :::                                                                                                                 ​| :::                                                                                    | Maps to          | 312927 ​              | 49584005 ​              | Acute cor pulmonale ​                                                                             | 
-| G44.311 ​                                                                                                              ​| Acute post-traumatic headache, intractable ​                                            | Maps to          | 42535403 ​            | 290431000119101 ​       | Intractable headache following trauma ​                                                           | +| G44.311 ​                                                                                                            ​| Acute post-traumatic headache, intractable ​                                            | Maps to          | 42535403 ​            | 290431000119101 ​       | Intractable headache following trauma ​                                                           | 
-| :::                                                                                                                   ​| :::                                                                                    | Maps to          | 44782681 ​            | 122751000119105 ​       | Acute posttraumatic headache ​                                                                    | +| :::                                                                                                                 ​| :::                                                                                    | Maps to          | 44782681 ​            | 122751000119105 ​       | Acute posttraumatic headache ​                                                                    | 
-^  Multiple “Maps to” for mapping to several Standard Concepts partially covering semantic space of a Source Concept ​                                                                                                                                                                                                                                                           |||||| +^  Multiple “Maps to” for mapping to several Standard Concepts partially covering semantic space of a Source Concept ​                                                                                                                                                                                                                                                           |||||| 
-| V01.11 ​                                                                                                               | Pedestrian on roller-skates injured in collision with pedal cycle in traffic accident ​ | Maps to          | 442247 ​              | 215142005 ​             | Pedal cycle accident involving collision between pedal cycle and pedestrian, pedestrian injured ​ | +| V01.11 ​                                                                                                             | Pedestrian on roller-skates injured in collision with pedal cycle in traffic accident ​ | Maps to          | 442247 ​              | 215142005 ​             | Pedal cycle accident involving collision between pedal cycle and pedestrian, pedestrian injured ​ | 
-| :::                                                                                                                   ​| :::                                                                                    | Maps to          | 441188 ​              | 32906002 ​              | Victim, pedestrian in vehicular AND/OR traffic ​acciden ​                                          +| :::                                                                                                                 ​| :::                                                                                    | Maps to          | 441188 ​              | 32906002 ​              | Victim, pedestrian in vehicular AND/OR traffic ​accident ​                                         ​
-| T36.1x4 ​                                                                                                              ​| Poisoning by cephalosporins and other beta-lactam antibiotics,​ undetermined ​           | Maps to          | 4303975 ​             | 419347003 ​             | Poisoning by antibacterial drug                                                                  | +| T36.1x4 ​                                                                                                            ​| Poisoning by cephalosporins and other beta-lactam antibiotics,​ undetermined ​           | Maps to          | 4303975 ​             | 419347003 ​             | Poisoning by antibacterial drug                                                                  | 
-| :::                                                                                                                   ​| :::                                                                                    | Maps to          | 4055774 ​             | 242975003 ​             | Poisoning of undetermined intent by drug                                                         |+| :::                                                                                                                 ​| :::                                                                                    | Maps to          | 4055774 ​             | 242975003 ​             | Poisoning of undetermined intent by drug                                                         |
  
 === "Maps to value" Relationships === === "Maps to value" Relationships ===
Line 52: Line 54:
   - Personal history of medical treatment or procedure   - Personal history of medical treatment or procedure
   - Status of a transplant/​prosthesis presence   - Status of a transplant/​prosthesis presence
-  - Persons'​encountering ​procedures, not carried out+  - Patient encounter ​procedures, not carried out
  
 Examples of usage: Examples of usage:
Line 75: Line 77:
 | :::     | :::                  | :::                                                                                        | Maps to value    | 105480006 ​             | Refusal of treatment by patient ​                                | Observation ​                | | :::     | :::                  | :::                                                                                        | Maps to value    | 105480006 ​             | Refusal of treatment by patient ​                                | Observation ​                |
  
-==== Data loss in Mapping ==== +==== "​Losses" ​in Mapping ====
-There is significant concern about the effect of mapping from one vocabulary to another on the quality of the data and the ability to reliably identify patients for a cohort given inclusion and exclusion criteria. This effect can have a variety of reasons, which are categorized into the following groups:+
  
-  ​Mapping is missingPlease report missing mappings to the [[http://​forums.ohdsi.org/​c/​cdm-builders|OHDSI Forum]], so they can be added. +**1The hierarchical discrepancy between ​Source and Standard Vocabularies**
-  * Source ​code is ill-defined,​ for example, ICD9CM 799 "Other ill-defined ​and unknown causes of morbidity and mortality"​ +
-  ​Negative assertion, for example, ICD9CM V64.0 "​Vaccination not carried out" +
-  ​Code irrelevant to the patient, for example, ICD9CM V65 "Other persons seeking consultation"​ +
-  * Source and target hierarchies incongruent+
  
-The latter effect ​is not uncommon for heavily pre-coordinated Concepts (complex and fine grained Concepts that are combinations of different dimensions), the coordination depends on the structure of topology of the vocabularies from and to which the Concept is mapped. If they are not equivalent, no direct mapping can be established. But in order to maintain the ability to retrieve these Concepts when searching using hierarchical Concepts, two or more mappings are provided instead. ​+It is not uncommon for heavily pre-coordinated Concepts (complex and fine-grained Concepts that are combinations of different dimensions). The coordination depends on the structure of the topology of the vocabularies from and to which the Concept is mapped. If they are not equivalent, no direct mapping can be established. But in order to maintain the ability to retrieve these Concepts when searching using hierarchical Concepts, two or more mappings are provided instead.
  
-For example, ​ICD10 Concept 45755355 "Non-insulin-dependent diabetes mellitus with coma" (code E10.0) cannot directly map to SNOMED:+For example, ​in ICD-10-CM diabetic complications are a part of the disorder of Diabetes Mellitus, while in SNOMED ​Diabetes Mellitus and its complications reside in distinct hierarchical branches.
  
-{{ :​documentation:​vocabulary:​diabetesmapping.png?nolink ​|Mapping of ICD10 E10.0}}+{{ :​documentation:​vocabulary:​5_-_diabetes-related_case_3_.png?400 |}}
  
-The target hierarchy in SNOMED has a different topology to the organizational structure in ICD10. Heretype 1 (insulin-dependent, E10) and type 2 (insulin-independent,​ E11) diabetes ​are the primary distinctive features. The combination ​of type 2 diabetes with its combination coma E11.0 defines type 2 diabetes with its complication coma. In SNOMEDdiabetic complications ​has its own hierarchy, which branches into the Concept ​of diabetes with comaor type 1 or 2 diabetes with complication. On the next level the distinctive forms of coma (hypoglycemic,​ hyperosmolar ​and ketoacidotic) ​are distinguished. However, there is no combination of diabetes type 2 with coma+As another exampleICD-10 codes indicating complications of pregnancy ​are in the chapter ​of "​Pregnancychildbirth and the puerperium"​ that has a semantic relation to the fact of pregnancywhile in SNOMED denoting pregnancy conditions ​and their complications ​are in the separate hierarchical branches
  
-The solution is to map E11.0 to both 44054006 Type 2 diabetes mellitus and 420662003 Coma associated with diabetes mellitus. Even though there is no distinct equivalent in SNOMED, hierarchical queries for either diabetes 2 in combination with coma will retrieve the correct records.+{{ :​documentation:​vocabulary:​6_-_pregnancy-related_case_1_.png?400 |}}
  
-=== Rules for Condition Mapping ​=== +The solution for both examples is to map Non-standard concepts to several standard ones. Even though there is no distinct equivalent in SNOMED, hierarchical queries will retrieve the correct records. 
-In general, Conditions are records suggesting the presence of a disease or medical condition stated as a diagnosis, a sign or a symptom. However, there are a lot of conditions that are not originating in the biological function of the human bodybut still require medical attention. Or they are true Conditions, but not at the time of the recording (History of) or in the person itself (Family history of). The mapping rules for these are as follows:+ 
 +**2. Missing Source Concept equivalent** 
 + 
 +This is possible due to the following reasons: ​  
 +| source concept code                                                     | source concept name                                                     | relationship ID  | standard concept ID  | standard concept code  | standard concept name                   | 
 +^  1. Vague formulation of a Source Concept ​                                                                                                                                                                                                                ​|||||| 
 +| M99.9                                                                   | Biomechanical lesion, unspecified ​                                      | Maps to          | 4244662 ​             | 928000 ​                | Disorder of musculoskeletal system ​     | 
 +| A28.9                                                                   | Zoonotic bacterial disease, unspecified ​                                | Maps to          | 432545 ​              | 87628006 ​              | Bacterial infectious disease ​           | 
 +^  2. Source Concept excessive granularity ​                                                                                                                                                                                                                 |||||| 
 +| B33.4                                                                   | Hantavirus (cardio-)pulmonary syndrome [HPS] [HCPS] ​                    | Maps to          | 441784 ​              | 359761005 ​             | Disease due to Hantavirus ​              | 
 +| I12.9                                                                   | Hypertensive renal disease without renal failure ​                       | Maps to          | 201313 ​              | 38481006 ​              | Hypertensive renal disease ​             | 
 +| S06.4x9 ​                                                                | Epidural hemorrhage with loss of consciousness of unspecified duration ​ | Maps to          | 4306943 ​             | 82999001 ​              | Epidural hemorrhage ​                    | 
 +| :::                                                                     | :::                                                                     | Maps to          | 372448 ​              | 419045004 ​             | Loss of consciousness ​                  | 
 +| S35.415 ​                                                                | Laceration of left renal vein                                           | Maps to          | 4124868 ​             | 234084003 ​             | Venous laceration ​                      | 
 +| :::                                                                     | :::                                                                     | Maps to          | 195125 ​              | 5753006 ​               | Injury of renal vein                    | 
 +^  3. Classification difference between Source and Standard Vocabularies ​                                                                                                                                                                                   |||||| 
 +| I48                                                                     | Atrial fibrillation and flutter ​                                        | Maps to          | 4068155 ​             | 17366009 ​              | Atrial arrhythmia ​                      | 
 +| G06.0                                                                   | Intracranial abscess and granuloma ​                                     | Maps to          | 4181187 ​             | 363176004 ​             | Inflammatory disorder of head           | 
 +| J38.0                                                                   | Paralysis of vocal cords and larynx ​                                    | Maps to          | 4233244 ​             | 89927005 ​              | Paralysis of larynx ​                    | 
 +| U82.1                                                                   | Resistance to methicillin ​                                              | Maps to          | 37017452 ​            | 713728002 ​             | Drug resistance to antibacterial agent  | 
 + 
 + 
 +**Other possible issues that one could encounter:​**  
 +  * Mapping has to exist and it can be built, but it is missing. Please report to [[https://​forums.ohdsi.org/​|the OHDSI Forum]], so it can be added. 
 +  * Code irrelevant to the patient, for example, ICD-9-CM V65 “Other persons seeking consultation” 
 +  * Source code is ill-defined,​ for example, ICD-9-CM 799 “Other ill-defined and unknown causes of morbidity and mortality” 
 + 
 +=== RULES FOR CONDITION MAPPING ​=== 
 +In general, Conditions are records suggesting the presence of a disease or medical condition stated as a diagnosis, a sign or a symptom. However, there are a lot of conditions that are not originating in the biological function of the human body but still require medical attention. Or they are true Conditions, but not at the time of the recording (History of) or in the person itself (Family history of). The mapping rules for these are as follows:
  
 **Aftercare after procedures.** **Aftercare after procedures.**
-Those are mapped to a single concept 413467001 "​Aftercare",​ and with a second "Maps to value" relationship to the adequante ​procedure. For example, ICD10CM Z47.1 "​Aftercare following joint replacement surgery"​ maps to both 413467001 "​Aftercare"​ and to the procedure 4189532 "​Implantation of joint prosthesis"​. Note that "​Aftercare"​ is itself not a condition, but belons ​to the Observation Domain.+Those are mapped to a single concept 413467001 "​Aftercare",​ and with a second "Maps to value" relationship to the adequate ​procedure. For example, ICD10CM Z47.1 "​Aftercare following joint replacement surgery"​ maps to both 413467001 "​Aftercare"​ and to the procedure 4189532 "​Implantation of joint prosthesis"​. Note that "​Aftercare"​ is itself not a condition, but belongs ​to the Observation Domain.
  
 **Late effects or sequelae of other conditions.** **Late effects or sequelae of other conditions.**
Line 107: Line 132:
  
 **Family history of a condition.** **Family history of a condition.**
-These, too, have a dual mapping to 4167217 "​Family history of clinical finding"​ and a to the actual condition through a "Maps to value" relationship. For example, ICD10/​ICD10CM Z80.0 concept_id 45542462 "​Family history of malignant neoplasm of digestive organs"​ maps to 4167217 "​Family history of clinical finding"​ as well as 443568 "​Malignant neoplasm of gastrointestinal tract"​. ​+These, too, have a dual mapping to 4167217 "​Family history of clinical finding"​ and a to the actual condition through a "Maps to value" relationship. For example, ICD10/​ICD10CM Z80.0 concept_id 45542462 "​Family history of malignant neoplasm of digestive organs"​ maps to 4167217 "​Family history of clinical finding"​ as well as 443568 "​Malignant neoplasm of the gastrointestinal tract"​. ​
  
 **History of medical treatment.** **History of medical treatment.**
-Similary, these are mapped to Observation Concept 4207283 "​History of drug therapy",​ and through a "Maps to value" link to the actual therapy. For example, ICD10 Z92.0 concept_id 45605174 "​Personal history of contraception"​ goes to 4207283 "​History of drug therapy"​ history of drug therapy and 4027509 "​Contraception"​. If the exact Ingredient or Clinical/​Branded Drug is known, the map would direct to these Drug Concepts. But that is not typical.+Similarly, these are mapped to Observation Concept 4207283 "​History of drug therapy",​ and through a "Maps to value" link to the actual therapy. For example, ICD10 Z92.0 concept_id 45605174 "​Personal history of contraception"​ goes to 4207283 "​History of drug therapy"​ history of drug therapy and 4027509 "​Contraception"​. If the exact Ingredient or Clinical/​Branded Drug is known, the map would direct to these Drug Concepts. But that is not typical.
  
 **Adverse effect of medication.** **Adverse effect of medication.**
-If possible, these are mapped to a direct equivalent. However, that usually does not exist, and then they are treated ​like the above history of medical treatments. For example, both ICD10CM T36.8X5A concept_id 45551127 "​Adverse effect of other systemic antibiotics,​ initial encounter"​ and T36.8X5D "​Adverse effect of other systemic antibiotics,​ subsequent encounter"​ map to 437191 "​Antibacterial drug adverse reaction",​ while ICD10CM T36.8X5S concept_id 45560654 "​Adverse effect of other systemic antibiotics,​ sequela"​ maps to 4207283 "​History of drug therapy"​.+If possible, these are mapped to a direct equivalent. However, that usually does not exist, and then they are treated ​as the above history of medical treatments. For example, both ICD10CM T36.8X5A concept_id 45551127 "​Adverse effect of other systemic antibiotics,​ initial encounter"​ and T36.8X5D "​Adverse effect of other systemic antibiotics,​ subsequent encounter"​ map to 437191 "​Antibacterial drug adverse reaction",​ while ICD10CM T36.8X5S concept_id 45560654 "​Adverse effect of other systemic antibiotics,​ sequela"​ maps to 4207283 "​History of drug therapy"​.
  
 **Underdosing of medication.** **Underdosing of medication.**
 This information is handled similarly to the adverse effects, and the equivalent SNOMED concepts generally do not exist. For example, ICD10CM T36.0X6A concept_id 45565479 "​Underdosing of penicillins,​ initial encounter"​ and T36.0X6D concept_id 45565480 "​Underdosing of penicillins,​ subsequent encounter"​ go to 40488434 "​Medication dose too low", while T36.0X6S concept_id 45565481 "​Underdosing of penicillins,​ sequela"​ points at 4207283 "​History of drug therapy"​. This information is handled similarly to the adverse effects, and the equivalent SNOMED concepts generally do not exist. For example, ICD10CM T36.0X6A concept_id 45565479 "​Underdosing of penicillins,​ initial encounter"​ and T36.0X6D concept_id 45565480 "​Underdosing of penicillins,​ subsequent encounter"​ go to 40488434 "​Medication dose too low", while T36.0X6S concept_id 45565481 "​Underdosing of penicillins,​ sequela"​ points at 4207283 "​History of drug therapy"​.
  
-**Status of organ absence or transplant/prostetic ​presence.**+**Status of organ absence or transplant/prosthetic ​presence.**
 Absent organs are due to a procedure having removed them (unless they are inborn conditions, which are mapped as such). Therefore, they are mapped to 4215685 "Past history of procedure"​ and the appropriate procedure that removed the organ through a "Maps to value" link. For example, ICD10CM Z94.0 concept_id 35225404 "​Kidney transplant status"​ maps to 4215685 "Past history of procedure"​ and 4322471 "​Transplant of kidney"​. Z95.5 concept_id 35225418 "​Presence of coronary angioplasty implant and graft" is pointed to 4215685 "Past history of procedure"​ and 4184832 "​Coronary angioplasty"​. ​ Absent organs are due to a procedure having removed them (unless they are inborn conditions, which are mapped as such). Therefore, they are mapped to 4215685 "Past history of procedure"​ and the appropriate procedure that removed the organ through a "Maps to value" link. For example, ICD10CM Z94.0 concept_id 35225404 "​Kidney transplant status"​ maps to 4215685 "Past history of procedure"​ and 4322471 "​Transplant of kidney"​. Z95.5 concept_id 35225418 "​Presence of coronary angioplasty implant and graft" is pointed to 4215685 "Past history of procedure"​ and 4184832 "​Coronary angioplasty"​. ​
  
Line 128: Line 153:
   -  To the most common ancestor   -  To the most common ancestor
  
-Examples for these 3 possibilites ​are:+Examples for these 3 possibilities ​are:
  
     - ICD10 A01 concept_id 45576225 "​Typhoid and paratyphoid fevers"​ has a single "Maps to" relationship to 4022808 "Human typhoid AND/OR paratyphoid fever"​.     - ICD10 A01 concept_id 45576225 "​Typhoid and paratyphoid fevers"​ has a single "Maps to" relationship to 4022808 "Human typhoid AND/OR paratyphoid fever"​.
Line 138: Line 163:
  
 **Need for immunization.** **Need for immunization.**
-These Concepts are mapped to an Observation indicating such immunity gap. A second mapping with the relationship_id "Maps to value" is then directed to the Condition (represented as a SNOMED Concept) the immunization is inocculating ​against. Note that it is not mapped to the vaccine itself (which would be represented as a RxNorm Concept). For example, ICD10 Z23 concept_id 45556822 "Need for immunization against single bacterial diseases"​ maps to 170536002 "​Vaccination required"​ and maps to value 87628006 "​Bacterial infectious disease"​. ​+These Concepts are mapped to an Observation indicating such an immunity gap. A second mapping with the relationship_id "Maps to value" is then directed to the Condition (represented as a SNOMED Concept) the immunization is inoculating ​against. Note that it is not mapped to the vaccine itself (which would be represented as a RxNorm Concept). For example, ICD10 Z23 concept_id 45556822 "Need for immunization against single bacterial diseases"​ maps to 170536002 "​Vaccination required"​ and maps to value 87628006 "​Bacterial infectious disease"​. ​
  
 **Conditions indicating abnormal levels of a test.** **Conditions indicating abnormal levels of a test.**
Line 145: Line 170:
 **Conditions resulting from the use of Devices.** **Conditions resulting from the use of Devices.**
 Adverse or other outcomes of the exposure to a device are mapped to 473023007 "​Complication associated with device and with another "Maps to value" relationship to the device itself, if possible. For example, ICD10 Y73.0 concept_id 45590664 "​Gastroenterology and urology devices associated with adverse incidents, diagnostic and monitoring devices"​ has a "Maps to value" link to 45767866 "​Gastro-urological device"​. Adverse or other outcomes of the exposure to a device are mapped to 473023007 "​Complication associated with device and with another "Maps to value" relationship to the device itself, if possible. For example, ICD10 Y73.0 concept_id 45590664 "​Gastroenterology and urology devices associated with adverse incidents, diagnostic and monitoring devices"​ has a "Maps to value" link to 45767866 "​Gastro-urological device"​.
 +
 +
 +=== CONDITION MAPPING ALGORITHM ===
 +{{ :​documentation:​vocabulary:​mapping_of_concepts_2_1_5_.png?​600 |}}
 +
  
documentation/vocabulary/mapping.1576252961.txt.gz · Last modified: 2019/12/13 16:02 by ptalapova