documentation:vocabulary:mapping
Differences
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 [2016/06/04 12:55] cgreich |
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 G06.0 concept_id 45552511 "Intracranial abscess and granuloma" has two "Maps to" relationships to 435509 "Intracranial abscess" and 43530721 "Intracranial granuloma". | + | - 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. | ||
documentation/vocabulary/mapping.txt · Last modified: 2020/12/09 10:56 by ptalapova
Page Tools
