ID

35550

Description

OMOP Common Data Model (CDM) CDM Source The CDM_SOURCE table contains detail about the source database and the process used to transform the data into the OMOP Common Data Model. OMOP Common Data Model Version 6.0 Specifications 11October2018. The Observational Medical Outcomes Partnership (OMOP) was a public-private partnership established to inform the appropriate use of observational healthcare databases for studying the effects of medical products. © 2014 Observational Health Data Sciences and Informatics. Version updated on 08.03.2019, from https://github.com/OHDSI/CommonDataModel/wiki/CDM_SOURCE 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.

Link

https://github.com/OHDSI/CommonDataModel/wiki/CDM_SOURCE

Keywords

Versions (2)
  1. 1/4/17 1/4/17 -
  2. 3/8/19 3/8/19 -
Copyright Holder

Observational Medical Outcomes Partnership (OMOP)

Uploaded on

March 8, 2019

DOI

To request one please log in.

License

Creative Commons BY-NC 3.0
Model comments :

You can comment on the data model here. Via the speech bubbles at the itemgroups and items you can add comments to those specificially.

Back to model comments
Itemgroup comments for :

Item comments for :

In order to download data models you must be logged in. Please log in or register for free.

OMOP Common Data Model (CDM)

English

CDM Source

1 forms  
  1. StudyEvent: ODM
    1. CDM Source
CDM Source
Description

CDM Source

Alias
UMLS CUI-1
C1521917
UMLS CUI-2
C3161035
UMLS CUI-3
C0449416
CDM Source name
Description

The full name of the source. (Type varchar(255))

Data type

text

Alias
UMLS CUI [1,1]
C1521917
UMLS CUI [1,2]
C3161035
UMLS CUI [1,3]
C0449416
UMLS CUI [1,4]
C0027365
CDM Source abbrevation
Description

An abbreviation of the name. (Type varchar(25))

Data type

text

Alias
UMLS CUI [1,1]
C1521917
UMLS CUI [1,2]
C3161035
UMLS CUI [1,3]
C0449416
UMLS CUI [1,4]
C0000723
CDM Holder
Description

The name of the organization responsible for the development of the CDM instance. (Type varchar(255))

Data type

text

Alias
UMLS CUI [1,1]
C1521917
UMLS CUI [1,2]
C3161035
UMLS CUI [1,3]
C1555310
Source description
Description

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. (Type CLOB)

Data type

text

Alias
UMLS CUI [1,1]
C0449416
UMLS CUI [1,2]
C0678257
Source documentation reference
Description

URL or other external reference to location of source documentation. (Type varchar(255))

Data type

text

Alias
UMLS CUI [1,1]
C1706462
UMLS CUI [1,2]
C0450429
UMLS CUI [1,3]
C0449416
UMLS CUI [1,4]
C0920316
UMLS CUI [1,5]
C3272380
CDM ETL Reference
Description

URL or other external reference to location of ETL specification documentation and ETL source code. (Type varchar(255))

Data type

text

Alias
UMLS CUI [1,1]
C1706462
UMLS CUI [1,2]
C1521917
UMLS CUI [1,3]
C3161035
UMLS CUI [1,4]
C0450429
UMLS CUI [2]
C1710131
Source release date
Description

The date for which the source data is most current, such as the last day of data capture

Data type

date

Alias
UMLS CUI [1,1]
C0449416
UMLS CUI [1,2]
C0011008
CDM Release date
Description

The date when the CDM was instantiated

Data type

date

Alias
UMLS CUI [1,1]
C1521917
UMLS CUI [1,2]
C3161035
UMLS CUI [1,3]
C0011008
CDM Version
Description

The version of CDM used. (Type varchar(10))

Data type

text

Alias
UMLS CUI [1,1]
C1521917
UMLS CUI [1,2]
C3161035
UMLS CUI [1,3]
C0333052
Vocabulary version
Description

The version of the vocabulary used. The version of the vocabulary can be obtained from the vocabulary_name field in the VOCABULARY table for the record where vocabulary_id='None'. (Type varchar(20))

Data type

text

Alias
UMLS CUI [1,1]
C0042926
UMLS CUI [1,2]
C0333052
Back to the top of the page

Similar models

CDM Source

1 forms
  1. StudyEvent: ODM
    1. CDM Source
Name
Type
Description | Question | Decode (Coded Value)
Data type
Alias
Item Group
CDM Source
C1521917 (UMLS CUI-1)
C3161035 (UMLS CUI-2)
C0449416 (UMLS CUI-3)
CDM Source name
Item
CDM Source name
text
C1521917 (UMLS CUI [1,1])
C3161035 (UMLS CUI [1,2])
C0449416 (UMLS CUI [1,3])
C0027365 (UMLS CUI [1,4])
CDM Source abbrevation
Item
CDM Source abbrevation
text
C1521917 (UMLS CUI [1,1])
C3161035 (UMLS CUI [1,2])
C0449416 (UMLS CUI [1,3])
C0000723 (UMLS CUI [1,4])
CDM Holder
Item
CDM Holder
text
C1521917 (UMLS CUI [1,1])
C3161035 (UMLS CUI [1,2])
C1555310 (UMLS CUI [1,3])
Source description
Item
Source description
text
C0449416 (UMLS CUI [1,1])
C0678257 (UMLS CUI [1,2])
Source documentation reference
Item
Source documentation reference
text
C1706462 (UMLS CUI [1,1])
C0450429 (UMLS CUI [1,2])
C0449416 (UMLS CUI [1,3])
C0920316 (UMLS CUI [1,4])
C3272380 (UMLS CUI [1,5])
CDM ETL Reference
Item
CDM ETL Reference
text
C1706462 (UMLS CUI [1,1])
C1521917 (UMLS CUI [1,2])
C3161035 (UMLS CUI [1,3])
C0450429 (UMLS CUI [1,4])
C1710131 (UMLS CUI [2])
Source release date
Item
Source release date
date
C0449416 (UMLS CUI [1,1])
C0011008 (UMLS CUI [1,2])
CDM Release date
Item
CDM Release date
date
C1521917 (UMLS CUI [1,1])
C3161035 (UMLS CUI [1,2])
C0011008 (UMLS CUI [1,3])
CDM Version
Item
CDM Version
text
C1521917 (UMLS CUI [1,1])
C3161035 (UMLS CUI [1,2])
C0333052 (UMLS CUI [1,3])
Vocabulary version
Item
Vocabulary version
text
C0042926 (UMLS CUI [1,1])
C0333052 (UMLS CUI [1,2])
Back to the top of the page 

Contact

Please use this form for feedback, questions and suggestions for improvements.

Fields marked with * are required.

Help

Do you need help on how to use the search function? Please watch the corresponding tutorial video for more details and learn how to use the search function most efficiently.

Watch Tutorial