The common data model (CDM) has been successfully applied across multiple disparate data sources within the OMOP data community. This section contains specifications and other associated materials for how source data was extracted, loaded, and transformed (ETL) into the CDM.

The OMOP Common Data Model Specifications and companion documents (Version 2.0) are available. Click on the document titles below to obtain the following:

• OMOP Common Data Model Specifications
• OMOP ETL Mapping Specifications
• OMOP ETL Mapping Template
• OMOP CDM Release Notes
• OMOP CDM Tables DDL

Licensed under the Apache License, Version 2.0 (the "License"); you may not use these documents except in compliance with the License. You may obtain a copy of the License at http://omop.fnih.org/publiclicense.

ETL Process

Observational Medical Dataset Simulator (OSIM)

• OSIM ETL Specification

GE Healthcare

• GE Healthcare ETL Specification
• GE Healthcare ETL Source Code

i3 Drug Safety

• i3 Drug Safety ETL Specification

Indiana University / Regenstrief Institute

• Indiana University / Regenstrief Institute ETL Specification

Partners Healthcare System

• Partners HealthCare System ETL Specification

SDI Health

• SDI Health ETL Specification

Thomson Reuters

• Thomson Reuters ETL Specification
• Thomson Reuters ETL Source Code

University of Miami-Humana Health Services Research Center

• University of Miami-Humana Health Services Research Center ETL Specification

Department of Veterans Affairs Center for Medication Safety/Outcomes Research, Pharmacy Benefits Management Services

• VA Center for Medication Safety ETL Specification

Other Data sources ETLs contributed by the OMOP Extended Consortium

Attached are the final materials from GSK for the translation of GPRD into the OMOP CDM

• GSK ETL Specification, Programs, GPRD Mappings and installation instructions