This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
documentation:vocabulary:mapping [2018/07/09 11:06] dimshitc1 |
documentation:vocabulary:mapping [2019/12/13 14:29] ptalapova [Table] |
||
---|---|---|---|
Line 5: | Line 5: | ||
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 done through records in the CONCEPT_RELATIONSHIP table. They connect each Concept to a Standard Concept through a number of special relationship_id: | ||
- | ^Relationship ID^Purpose^ | + | ^ Relationship ID ^ Purpose ^ Features ^ |
- | |Maps to|Mapping Concept to Standard Concept to be placed in the *_concept_id| | + | | **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|Special mapping between a Concept and a Standard Concept to be placed into the value_as_concept field of the MEASUREMENT and OBSERVATION tables| | + | | **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 78: | Line 78: | ||
- 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". | ||
- | - IC10 M07.47 concept_id 42616699 "Arthropathy in Crohn disease [regional enteritis], ankle and foot" has two "Maps to" relationships to 4116143 "Arthropathy in Crohn's disease" and 4117687 "Rheumatoid arthritis - ankle and/or foot". | + | - IC10CM F12.22 concept_id 45591098 "Cannabis dependence with intoxication" has two "Maps to" relationships to 4052690 "Cannabis intoxication" and 440387 "Cannabis dependence". |
- ICD10 L02.0 concept_id 45596354 "Cutaneous abscess, furuncle and carbuncle of face" has a single "Maps to" relationship_id to 400082007 Disorder of skin of head. | - ICD10 L02.0 concept_id 45596354 "Cutaneous abscess, furuncle and carbuncle of face" has a single "Maps to" relationship_id to 400082007 Disorder of skin of head. | ||