User Tools

Site Tools


documentation:cdm:cdm_source

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
documentation:cdm:cdm_source [2014/11/17 19:24]
cgreich created
documentation:cdm:cdm_source [2017/09/25 14:59] (current)
clairblacketer
Line 1: Line 1:
-===== CDM_SOURCE =====+===== CDM_SOURCE ​table ===== 
 +**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** 
 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 18:
 ==== 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~~ 
documentation/cdm/cdm_source.1416252241.txt.gz · Last modified: 2014/11/17 19:24 by cgreich