This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Last revision Both sides next revision | ||
documentation:cdm:concept_synonym [2014/12/02 01:51] jduke |
documentation:cdm:concept_synonym [2017/08/17 15:20] clairblacketer |
||
---|---|---|---|
Line 1: | Line 1: | ||
===== CONCEPT_SYNONYM table ===== | ===== CONCEPT_SYNONYM table ===== | ||
+ | **The CDM documentation is now being housed on [[https://github.com/OHDSI/CommonDataModel/wiki|github]]. The most recent release is [[https://github.com/OHDSI/CommonDataModel/releases/tag/v5.2.-bugfix.1|v5.2]]** | ||
The CONCEPT_SYNONYM table is used to store alternate names and descriptions for Concepts. | The CONCEPT_SYNONYM table is used to store alternate names and descriptions for Concepts. | ||
Line 10: | Line 11: | ||
==== Conventions ==== | ==== Conventions ==== | ||
- | * The content of the concept_name is one of the Synonyms, i.e. each Concept has at least one Synonym in the CONCEPT_SYNONYM table. As an example, for a SNOMED-CT Concept, if the fully specified name is stored as the concept_name of the CONCEPT table, then the Preferred Term and Synonyms associated with the Concept are stored in the CONCEPT_SYNONYM table. | + | * The concept_name field contains a valid Synonym of a concept, including the description in the concept_name itself. I.e. each Concept has at least one Synonym in the CONCEPT_SYNONYM table. As an example, for a SNOMED-CT Concept, if the fully specified name is stored as the concept_name of the CONCEPT table, then the Preferred Term and Synonyms associated with the Concept are stored in the CONCEPT_SYNONYM table. |
* Only Synonyms that are active and current are stored in the CONCEPT_SYNONYM table. Tracking synonym/description history and mapping of obsolete synonyms to current Concepts/Synonyms is out of scope for the Standard Vocabularies. | * Only Synonyms that are active and current are stored in the CONCEPT_SYNONYM table. Tracking synonym/description history and mapping of obsolete synonyms to current Concepts/Synonyms is out of scope for the Standard Vocabularies. | ||
* Currently, only English Synonyms are included. | * Currently, only English Synonyms are included. | ||