documentation:vocabulary:changes_from_version_4
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
|
documentation:vocabulary:changes_from_version_4 [2015/01/20 01:23] cgreich |
documentation:vocabulary:changes_from_version_4 [2015/01/20 01:55] cgreich |
||
|---|---|---|---|
| Line 7: | Line 7: | ||
| |[[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: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: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 discussion of the individual Vocabularies for detais of the mapping.| | + | |[[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: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.| | |[[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.| | ||
| Line 14: | Line 14: | ||
| ^Table^Field^Nature of change^ | ^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:domains_and_vocabularies|discussion]] of the Vocabularies.| | + | |[[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]]|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:XXX|discussion]] of the Domains.| | + | |[[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:XXX|discussion]] of how the Concept designation is used in practice.| | + | |[[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:XXX|here]].| | + | |[[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_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_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: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: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.| | |[[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.| |
documentation/vocabulary/changes_from_version_4.txt · Last modified: 2015/01/20 03:13 by cgreich
Page Tools
