This shows you the differences between two versions of the page.
Next revision | Previous revision Last revision Both sides next revision | ||
documentation:cdm:cdm_source [2014/11/17 19:24] cgreich created |
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 16: | Line 16: | ||
==== Conventions ==== | ==== Conventions ==== | ||
- | * If a source database is derived from multiple data feeds, the integration of those disparate sources is expected to be documented in the ETL specifications. The source information for each of the databases can be represented as separate record in the CDM_SOURCE table. | + | * If a source database is derived from multiple data feeds, the integration of those disparate sources is expected to be documented in the ETL specifications. The source information on each of the databases can be represented as separate records in the CDM_SOURCE table. |
- | * Currently, there is no mechanism to link individual records in the CDM tables to the source. | + | * Currently, there is no mechanism to link individual records in the CDM tables to their source record in the CDM_SOURCE table. |
- | * 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~~ |