This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
documentation:vocabulary:changes_from_version_4 [2015/01/20 01:54] cgreich |
documentation:vocabulary:changes_from_version_4 [2024/09/04 13:01] (current) jcruz Depreciation of page and posting of corresponding link in Github wiki |
||
---|---|---|---|
Line 1: | Line 1: | ||
===== Changes from Vocabulary Version 4.0 ===== | ===== 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. | + | Thank you for visiting the wiki! This page has moved to https://github.com/OHDSI/Vocabulary-v5.0/wiki/Historical-Versions. |
- | + | ||
- | ** Changes to Tables ** | + | |
- | + | ||
- | ^Table^Nature of change^ | + | |
- | |[[documentation:cdm:domain|DOMAIN]]|Newly created reference table for all Domains. Please refer to the [[documentation:vocabulary:domains_and_vocabularies|discussion]] of the Domains.| | + | |
- | |[[documentation:cdm:concept_class|CONCEPT_CLASS]]|Newly created reference table for all Concept Classes of Concepts. Please refer to the discussion of the individual Vocabularies for detais.| | + | |
- | |[[documentation:cdm:source_to_concept_map|SOURCE_TO_CONCEPT_MAP]]|No longer used for mapping of source codes to Standard Vocabularies. Instead, source codes have now a representation in the [[documentation:cdm:concept|CONCEPT]] table, and these Source Concepts are mapped to Standard Concepts using records in the [[documentation:cdm:concept_relationship|CONCEPT_RELATIONSHIP]] table "Maps to" and "Mapped from". Please refer to the [[documentation:vocabulary:mapping|discussion]] of the mapping and the individual Vocabularies for detais.| | + | |
- | |[[documentation:cdm:cohort_definition|COHORT_DEFINITION]]|Newly created reference table for the definition of Cohorts in the COHORT table. This table is not supported with standardized content, but for internal use at each CDM instance.| | + | |
- | |[[documentation:cdm:attribute_definition|ATTRIBUTE_DEFINITION]]|Newly created reference table for the definition of Cohort Attributes in the COHORT_ATTRIBUTE table. This table is not supported with standardized content, but for internal use at each CDM instance.| | + | |
- | + | ||
- | ** Changes to Fields ** | + | |
- | + | ||
- | ^Table^Field^Nature of change^ | + | |
- | |[[documentation:cdm:concept|CONCEPT]] and [[documentation:cdm:vocabulary|VOCABULARY]]|vocabulary_id|This is no longer a numerical but a character identifier of length 20. The character string refers to the Vocabulary in a human readable format for convenience of the analyst during querying. E.g., vocabulary_id 1 became vocabulary "SNOMED", vocabulary_id 2 became "ICD9CM". Please refer to the [[documentation:vocabulary:vocabularies|discussion]] of the Vocabularies.| | + | |
- | |[[documentation:cdm:concept|CONCEPT]]|concept_class_id|This used to be a character field called concept_class containing Concept Class as a string. Now, it contains a 20 character identifier referring to the [[documentation:cdm:concept_class|CONCEPT_CLASS]] table, similar to how Vocabularies are referred to in the vocabulary_id field. Please refer to the discussion of the individual Vocabularies for details.| | + | |
- | |[[documentation:cdm:concept|CONCEPT]]|domain_id|This is a newly added field for a 20 character identifier referring to the [[documentation:cdm:domain|DOMAIN]] table, similar to how Vocabularies are referred to in the vocabulary_id field. Please refer to the [[documentation:domains_and_vocabularies:domains|discussion]] of the Domains.| | + | |
- | |[[documentation:cdm:concept|CONCEPT]]|standard_concept|This is a newly added field designating whether the Concept is a Standard Concept ("S"), a Classification Concept ("C") or a Source Concept (NULL). Please refer to the [[documentation:vocabulary:standard_classification_and_source_concepts|discussion]] of how the Concept designation is used in practice.| | + | |
- | |[[documentation:cdm:concept|CONCEPT]]|concept_level|This field used to designate the hierarchical level within a Vocabulary or Domain, and is no longer available. Hierarchical levels only work for strictly stratified hierarchies such as RxNorm or MedDRA, and are no longer supported. Concept Level 0 used to designate non-Standard Concepts, which now is captured in the standard_concept field and explained [[documentation:vocabulary:standard_classification_and_source_concepts|here]].| | + | |
- | |[[documentation:cdm:vocabulary|VOCABULARY]]|vocabulary_reference|This is a newly added field referring to external documentation of the Vocabulary.| | + | |
- | |[[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 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.| | + | |
- | |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.| | + | |
- | |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.| | + |