This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Last revision Both sides next revision | ||
documentation:cdm:cdm_source [2014/11/17 19:26] cgreich |
documentation:cdm:cdm_source [2015/08/13 20:03] ericavoss corrected misspelling in CDM_SOURCE_ABBREVIATION |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== CDM_SOURCE ===== | + | ===== CDM_SOURCE table ===== |
The CDM_SOURCE table contains detail about the source database and the process used to transform the data into the OMOP Common Data Model. | The CDM_SOURCE table contains detail about the source database and the process used to transform the data into the OMOP Common Data Model. | ||
^Field^Required^Type^Description^ | ^Field^Required^Type^Description^ | ||
|cdm_source_name|Yes|varchar(255)|The full name of the source| | |cdm_source_name|Yes|varchar(255)|The full name of the source| | ||
- | |cdm_source_abbrevation|No|varchar(25)|An abbreviation of the name| | + | |cdm_source_abbreviation|No|varchar(25)|An abbreviation of the name| |
|cdm_holder|No|varchar(255)|The name of the organization responsible for the development of the CDM instance| | |cdm_holder|No|varchar(255)|The name of the organization responsible for the development of the CDM instance| | ||
|source_description|No|CLOB|A description of the source data origin and purpose for collection. The description may contain a summary of the period of time that is expected to be covered by this dataset.| | |source_description|No|CLOB|A description of the source data origin and purpose for collection. The description may contain a summary of the period of time that is expected to be covered by this dataset.| | ||
Line 20: | Line 20: | ||
* The version of the vocabulary can be obtained from the vocabulary_name field in the VOCABULARY table for the record where vocabulary_id='None'. | * The version of the vocabulary can be obtained from the vocabulary_name field in the VOCABULARY table for the record where vocabulary_id='None'. | ||
- | ~~DISQUS~~ |