User Tools

Site Tools


documentation:cdm: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.

FieldRequiredTypeDescription
cdm_source_nameYesvarchar(255)The full name of the source
cdm_source_abbreviationNovarchar(25)An abbreviation of the name
cdm_holderNovarchar(255)The name of the organization responsible for the development of the CDM instance
source_descriptionNoCLOBA 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_documentation_referenceNovarchar(255)URL or other external reference to location of source documentation
cdm_etl _referenceNovarchar(255)URL or other external reference to location of ETL specification documentation and ETL source code
source_release_dateNodateThe date for which the source data are most current, such as the last day of data capture
cdm_release_dateNodateThe date when the CDM was instantiated
cdm_versionNovarchar(10)The version of CDM used
vocabulary_versionNovarchar(20)The version of the vocabulary used

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 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 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'.
documentation/cdm/cdm_source.txt · Last modified: 2015/08/13 20:03 by ericavoss