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 [2020/12/09 09:30] ptalapova |
documentation:vocabulary:mapping [2020/12/09 09:34] ptalapova [Table] |
||
|---|---|---|---|
| Line 6: | Line 6: | ||
| * 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 ^ Features ^ | + | ^ 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** | 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 | |
| - | | **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 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: 2024/09/02 09:42 by jcruz
Page Tools
