OMOP COMMON DATA MODEL AND STANDARD VOCABULARIES – VERSION 4.0
Observational data needs to adhere to a common format and content to enable the application of standardized analytical methods that are empirically tested for their performance characteristics, or their ability to detect relationships between treatment and outcome despite the strong bias in the data. The Common Data Model (CDM) standardizes the format, and the Standard Vocabulary contains the content or coding schemes used across disparate data sources and types. Please contact OMOP to share with us your experience implementing the CDM and Standard Vocabularies.

ETL Specifications Document - Share your completed ETL with the OMOP Community! Email your ETL documentation to welebob@omop.org and it will be posted on the OMOP public website with other ETL documents.

• Scalable Architecture for Federated Therapeutic Inquiries Network (SAFTINet)

Common Data Model – Version 4.0
As part of the OMOP platform, an enhanced CDM is available in Version 4.0. It now supports health economics use cases and medical treatment outcome studies, including medical device safety, comparative effectiveness, and healthcare quality. Note: If you have implemented CDM v4.0, use Observational Source Characteristics Analysis Report (OSCAR) for CDM v4.0 otherwise, use OSCAR for CDM v2.0.

Click on the document titles below to obtain the OMOP Common Data Model Specifications and companion documents (Version 4.0).

• OMOP Common Data Model Specifications
• ETL Mapping Template - Word version
• ETL Mapping Template - PDF version
• CDM Tables DDL

To execute the Generalized ERA Logic Developer (GERALD) for the creation of typical eras for CDM V4.0:

• Gerald source code for CDM V4.0

ETL Specification Documents

• GE ETL Mapping V4.0
• GE ETL Code V4.0
• Truven Source to Concept Map
• CCAE ETL Mapping V4.0
• CCAE ETL Code V4.0
• MDCD ETL Mapping V4.0
• MDCD ETL Code V4.0
• MDCR ETL Mapping V4.0
• MDCR ETL Code V4.0
• MSLR ETL Mapping V4.0
• MSLR ETL Code V4.0

All this material is licensed under the Apache License Version 2.0, making it available to the public as Open Source with minimal restrictions. To learn more about what you need to do to use the CDM, please review the License.

Standard Vocabularies – Version 4.0
The Standard Vocabulary contains all of the terminologies and classifications and the corresponding mapping from commonly used coding schemes that are required for:

• Creating the transformed (i.e., standardized) data from the raw data sets,
• Searching and querying the transformed data, and browsing and navigating the hierarchies of classes and abstractions inherent in the transformed data, and
• Interpreting the meanings of the data.

Click on the document titles below to obtain the OMOP Standard Vocabulary Implementation Specification and companion tools (Version 4.0).

• Vocabulary Specification Document
• Vocabulary tables DDL
• Only unrestricted vocabulary data - CSV format
• Only unrestricted vocabulary data - SAS format

• All vocabulary data including licensed material - CSV format (see below)
• All vocabulary data including licensed material - SAS format (see below)

The specifications, DDL and a subset of the Standard Vocabularies are available to the public as Open Source, licensed under the Apache License Version 2.0. However, some third party vocabularies are only available to be used for certain research purposes and an End User License Agreement (EULA) has to be executed. Please contact OMOP if you need access to the restricted licensed material (see table below).