CDM_SOURCE table

THIS IS OUTDATED. All documentation is now on the github wiki. Please refer there or to the 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.

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