documentation:cdm:data_model_conventions
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
documentation:cdm:data_model_conventions [2014/12/02 01:48] jduke |
documentation:cdm:data_model_conventions [2017/09/25 14:56] (current) clairblacketer |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ====== Data Model Conventions ====== | ====== Data Model Conventions ====== | ||
| + | **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** | ||
| There are a number of implicit and explicit conventions that have been adopted in the CDM. Developers of methods that run methods against the CDM need to understand these conventions. | There are a number of implicit and explicit conventions that have been adopted in the CDM. Developers of methods that run methods against the CDM need to understand these conventions. | ||
| Line 30: | Line 31: | ||
| Many tables contain equivalent information multiple times: As a Source Value, a Source Concept and as a Standard Concept. | Many tables contain equivalent information multiple times: As a Source Value, a Source Concept and as a Standard Concept. | ||
| * Source Values contains the codes from public code systems such as ICD-9-CM, NDC, CPT-4 etc. or local controlled vocabularies (such as F for female and M for male) copied from the source data. Source Values are stored in the _source_value field in the data tables. | * Source Values contains the codes from public code systems such as ICD-9-CM, NDC, CPT-4 etc. or local controlled vocabularies (such as F for female and M for male) copied from the source data. Source Values are stored in the _source_value field in the data tables. | ||
| - | * Concepts are CDM-specific entities that represent the meaning of a clinical fact. Most concepts are based on code systems used in healthcare (called Source Concepts), while others were created de-novo. Concepts have unique IDs across all domains. | + | * Concepts are CDM-specific entities that represent the meaning of a clinical fact. Most concepts are based on code systems used in healthcare (called Source Concepts), while others were created de-novo (concept_code = "OMOP generated"). Concepts have unique IDs across all domains. |
| - | * Source Concepts are the concepts that represent the code used in the source. Source Concepts are only used for common healthcare code systems, but not for controlled vocabularies. Source Concepts are stored in the source_concept_id field in the data tables. | + | * Source Concepts are the concepts that represent the code used in the source. Source Concepts are only used for common healthcare code systems, but not for OMOP-generated Concepts. Source Concepts are stored in the source_concept_id field in the data tables. |
| * Standard Concepts are those concepts that are used to define the unique meaning of a clinical entity. For each entity there is one Standard Concept. Standard Concepts are typically drawn from existing public vocabulary sources. Concepts that have the equivalent meaning to a Standard Concept are mapped to the Standard Concept. Standard Concepts are referred to in the concept_id field of the data tables. | * Standard Concepts are those concepts that are used to define the unique meaning of a clinical entity. For each entity there is one Standard Concept. Standard Concepts are typically drawn from existing public vocabulary sources. Concepts that have the equivalent meaning to a Standard Concept are mapped to the Standard Concept. Standard Concepts are referred to in the concept_id field of the data tables. | ||
documentation/cdm/data_model_conventions.1417484938.txt.gz · Last modified: 2014/12/02 01:48 by jduke
Page Tools
