Differences

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

--- documentation:vocabulary:changes_from_version_4 [2015/01/20 01:53]
cgreich
+++ documentation:vocabulary:changes_from_version_4 [2015/01/20 03:13] (current)
cgreich
@@ Line 1: / Line 1: @@
 ===== Changes from Vocabulary Version 4.0 =====
 The Standardized Vocabularies are undergoing a constant revision and improvement. Therefore, only significant structural changes are listed in the following.
+** Changes to Conventions **
+  * Concept Designation as [[documentation:vocabulary:standard_classification_and_source_concepts|Standard, Classification and Source]]
+    * **Source Concepts**: In contrast to V4.0 of the Standardized Vocabularies, there is no longer a distinction between source codes and Concepts. All source codes now have their own Concept. However, in order to distinguish between codes that are used to represent a clinical entity in the data tables, Concepts are now designated Standard Concepts or Source Concepts.
+    * For some vocabularies, source codes did have records in the Concept table, such as VA Product, RxNorm Concept Classes "Drug Form", SNOMED Concepts other than Condition and Procedure. These Concept had a concept_level = 0. The concept_id of these non-standard Concepts has been preserved between the versions.
+    * **Standard Concepts**: These Concepts were available in previous versions of the Standardized Vocabularies. They were designated through a concept_level value greater than 0. The concept_id of Standard Concepts has been preserved between the versions.
+    * **Classification Concepts**: Like the Standard Concepts, the Classification Concepts existed in V4.0 of the Standardized Vocabulary. Their concept_level was typically 3 for drug classifications, 1-5 for MedDRA (Condition Classification) and 1-2 for SNOMED Procedure Classifications. Their concept_id has been preserved as well.
+  * [[documentation:vocabulary:mapping|Mapping]] between source and Standard Concepts.
+    * Each source code has now a representation as a Source Concept, and the mapping is achieved through the [[documentation:cdm:concept_relationship|CONCEPT_RELATIONSHIP]] table. A new relationship_id = "Maps to" (reverse_relationship_id = "Mapped from") links the Source to the Standard Concepts.
+    * The [[documentation:cdm:source_to_concept_map|SOURCE_TO_CONCEPT_MAP]] table is no longer used, and therefore no longer populated in the Standardized Vocabularies. However, it still can be used to map local source codes for specific ETL procedures using non-public vocabularies not supported here.
 ** Changes to Tables **
@@ Line 22: / Line 34: @@
 |[[documentation:cdm:vocabulary|VOCABULARY]]|vocabulary_version|This is a newly added field capturing the version of the Vocabulary as indicated in the source.|
 |[[documentation:cdm:vocabulary|VOCABULARY]]|vocabulary_concept_id|This is a newly added field referring to the Concept representing the Vocabulary.|
-|[[documentation:cdm:concept_relationship|CONCEPT_RELATIONSHIP]] and [[documentation:cdm:relationship|RELATIONSHIP]]|relationship_id|This is no longer a numerical but a character identifier of length 20. The character string refers to the Relationship in a human readable format for convenience of the analyst during querying. E.g., relationship_id 10 became "Subsumes", relationship_id 353 became "Maps to". Please refer to the [[documentation:vocabulary:XXX|discussion]] of the Concept Relationships.|
+|[[documentation:cdm:concept_relationship|CONCEPT_RELATIONSHIP]] and [[documentation:cdm:relationship|RELATIONSHIP]]|relationship_id|This is no longer a numerical but a character identifier of length 20. The character string refers to the Relationship in a human readable format for convenience of the analyst during querying. E.g., relationship_id 10 became "Subsumes", relationship_id 353 became "Maps to". Please refer to the discussion of the Vocabularies for details of the Concept Relationships.|
 |[[documentation:cdm:relationship|RELATIONSHIP]]|relationship_concept_id|This is a newly added field referring to the Concept representing the Relationship.|
 |[[documentation:cdm:concept_synonym|CONCEPT_SYNONYM]]|language_concept_id|This is a newly added field referring to the Concept of the language used. Currently, only English is supported in the Standardized Vocabularies.|
-|DRUG_STRENGTH|amount_unit_concept_id|This field used to be called amount_unit containing the unit as a character string. Now, it is a foreign key to the Unit Concept in the [[documentation:cdm:concept|CONCEPT]] table.|
+|[[documentation:cdm:drug_strength|DRUG_STRENGTH]]|amount_unit_concept_id|This field used to be called amount_unit containing the unit as a character string. Now, it is a foreign key to the Unit Concept in the [[documentation:cdm:concept|CONCEPT]] table.|
-|DRUG_STRENGTH|numerator_value|This field used to be called enumerator_value.|
+|[[documentation:cdm:drug_strength|DRUG_STRENGTH]]|numerator_value|This field used to be called enumerator_value.|
-|DRUG_STRENGTH|numerator_unit_concept_id|This field used to be called enumerator_unit containing the unit as a character string. Now, it is a foreign key to the Unit Concept in the [[documentation:cdm:concept|CONCEPT]] table.|
+|[[documentation:cdm:drug_strength|DRUG_STRENGTH]]|numerator_unit_concept_id|This field used to be called enumerator_unit containing the unit as a character string. Now, it is a foreign key to the Unit Concept in the [[documentation:cdm:concept|CONCEPT]] table.|
-|DRUG_STRENGTH|denominator_unit_concept_id|This field used to be called denominator_unit containing the unit as a character string. Now, it is a foreign key to the Unit Concept in the [[documentation:cdm:concept|CONCEPT]] table.|
+|[[documentation:cdm:drug_strength|DRUG_STRENGTH]]|denominator_unit_concept_id|This field used to be called denominator_unit containing the unit as a character string. Now, it is a foreign key to the Unit Concept in the [[documentation:cdm:concept|CONCEPT]] table.|

Observational Health Data Sciences and Informatics

User Tools

Site Tools

Differences

Page Tools