documentation:vocabulary:mapping
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | Next revision Both sides next revision | ||
|
documentation:vocabulary:mapping [2018/07/09 11:55] 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 === | ||
documentation/vocabulary/mapping.txt · Last modified: 2020/12/09 10:56 by ptalapova
Page Tools
