Differences

This shows you the differences between two versions of the page.

--- documentation:cdm:concept [2015/01/20 02:15] – cgreich
+++ documentation:cdm:concept [2017/09/25 14:57] (current) – clairblacketer
@@ Line 1: / Line 1: @@
 ===== CONCEPT table =====
+**THIS IS OUTDATED. All documentation is now on the [[https://github.com/OHDSI/CommonDataModel/wiki|github wiki]]. Please refer there or to the [[projects:workgroups:cdm-wg|CDM working group]] for more information**
 The Standardized Vocabularies contains records, or Concepts, that uniquely identify each fundamental unit of meaning used to express clinical information in all domain tables of the CDM. Concepts are derived from vocabularies, which represent clinical information across a domain (e.g. conditions, drugs, procedures) through the use of codes and associated descriptions. Some Concepts are designated Standard Concepts, meaning these Concepts can be used as normative expressions of a clinical entity within the OMOP Common Data Model and within standardized analytics. Each Standard Concept belongs to one domain, which defines the location where the Concept would be expected to occur within data tables of the CDM.
@@ Line 11: / Line 13: @@
 |domain_id|Yes|varchar(20)|A foreign key to the [[documentation:cdm:domain|DOMAIN]] table the Concept belongs to.|
 |vocabulary_id|Yes|varchar(20)|A foreign key to the [[documentation:cdm:vocabulary|VOCABULARY]] table indicating from which source the Concept has been adapted.|
-|concept_class_id|Yes|varchar(20)|The attribute or concept class of the Concept. Examples are “Clinical Drug”, “Ingredient”, “Clinical Finding” etc.  Please refer to the specification of each [[documentation:vocabulary:vocabularies|Vocabulary]] for details.|
+|concept_class_id|Yes|varchar(20)|The attribute or concept class of the Concept. Examples are “Clinical Drug”, “Ingredient”, “Clinical Finding” etc.|
 |standard_concept|No|varchar(1)|This flag determines where a Concept is a Standard Concept, i.e. is used in the data, a Classification Concept, or a non-standard Source Concept. The allowables values are 'S' (Standard Concept) and 'C' (Classification Concept), otherwise the content is NULL.|
 |concept_code|Yes|varchar(50)|The concept code represents the identifier of the Concept in the source vocabulary, such as SNOMED-CT concept IDs, RxNorm RXCUIs etc. Note that concept codes are not unique across vocabularies.|
@@ Line 24: / Line 26: @@
   * The concept_id of a Concept is persistent, i.e. stays the same for the same Concept between releases of the Standardized Vocabularies.
   * A descriptive name for each Concept is stored as the Concept Name as part of the [[documentation:cdm:concept|CONCEPT]] table. Additional names and descriptions for the Concept are stored as Synonyms in the [[documentation:cdm:concept_synonym|CONCEPT_SYNONYM]] table.
-  * Each Concept is assigned to a Domain. For Standard Concepts, these is always a single Domain. Source Concepts can be composite or coordinated entities, and therefore can belong to more than one Domain. The domain_id field of the record contains the abbreviation of the Domain, or Domain combination. Please refer to the [[documentation:vocabulary:domains|Standardized Vocabularies Specification]] for details of the Domain Assignment.
+  * Each Concept is assigned to a Domain. For Standard Concepts, these is always a single Domain. Source Concepts can be composite or coordinated entities, and therefore can belong to more than one Domain. The domain_id field of the record contains the abbreviation of the Domain, or Domain combination. Please refer to the Standardized Vocabularies [[documentation:vocabulary:domains|Specification]] for details of the Domain Assignment.
-  * For details of the Vocabularies adopted for use in the OMOP CDM refer to the [[documentation:vocabulary:vocabularies|Standardized Vocabularies Specification]].
+  * For details of the Vocabularies adopted for use in the OMOP CDM refer to the Standardized Vocabularies [[documentation:vocabulary:vocabularies|Specification]].
   * Concept Class designation are attributes of Concepts. Each Vocabulary has its own set of permissible Concept Classes, although the same Concept Class can be used by more than one Vocabulary. Depending on the Vocabulary, the Concept Class may categorize Concepts vertically (parallel) or horizontally (hierarchically). See the specification of each [[documentation:vocabulary:vocabularies|Vocabulary]] for details.
- * Concept Class attributes should not be confused with Classification Concepts. These are separate Concepts that have a hierarchical relationship to Standard Concepts or each other.
+  * Concept Class attributes should not be confused with Classification Concepts. These are separate Concepts that have a hierarchical relationship to Standard Concepts or each other, while Concept Classes are unique Vocabulary-specific attributes for each Concept.
   * For Concepts inherited from published terminologies, the source code is retained in the concept_code field and can be used to reference the source vocabulary.
-  * Standard Concepts (designated as 'S' in the standard_concept field) may appear in CDM tables in all <domain>_concept_id fields, whereas Classification Concepts ('C') should not appear in the CDM data, but participate in the construction of the [[documentation:cdm:concept_ancestor|CONCEPT_ANCESTOR]] table and can be used to identify Descendants that may appear in the data. See [[documentation:cdm:cdm:concept_ancestor|CONCEPT_ANCESTOR]] table. Non-standard Concepts can only appear in *_source_concept_id fields and are not used in CONCEPT_ANCESTOR table. Please refer to the [[documentation:vocabulary:standard_classification_and_source_concepts|Specifications]] for details of the Standard Concept designation.
+  * Standard Concepts (designated as 'S' in the standard_concept field) may appear in CDM tables in all *_concept_id fields, whereas Classification Concepts ('C') should not appear in the CDM data, but participate in the construction of the [[documentation:cdm:concept_ancestor|CONCEPT_ANCESTOR]] table and can be used to identify Descendants that may appear in the data. See [[documentation:cdm:cdm:concept_ancestor|CONCEPT_ANCESTOR]] table. Non-standard Concepts can only appear in *_source_concept_id fields and are not used in CONCEPT_ANCESTOR table. Please refer to the Standardized Vocabularies [[documentation:vocabulary:standard_classification_and_source_concepts|Specifications]] for details of the Standard Concept designation.
   * All logical data elements associated with the various CDM tables (usually in the <domain>_type_concept_id field) are called Type Concepts, including defining characteristics, qualifying attributes etc. They are also stored as Concepts in the [[documentation:cdm:concept|CONCEPT]] table. Since they are generated by OMOP, their is no meaningful concept_code.
   * The lifespan of a Concept is recorded through its valid_start_date, valid_end_date and the invalid_reason fields. This allows Concepts to correctly reflect at which point in time were defined. Usually, Concepts get deprecatd if their meaning was deamed ambigous, a duplication of another Conncept, or needed revision for scientific reason. For example, drug ingredients get updated when different salt or isomer variants enter the market. Usually, drugs taken off the market do not cause a deprecation by the terminology vendor. Since observational data are valid with respect to the time they are recorded, it is key for the Standardized Vocabularies to provide even obsolete codes and maintain their relationships to other current Concepts .