OHDSI/CommonDataModel

Name: CommonDataModel

Owner: Observational Health Data Sciences and Informatics

Description: Definition and DDLs for the OMOP Common Data Model (CDM)

Created: 2014-10-14 20:20:22.0

Updated: 2018-01-11 16:31:53.0

Pushed: 2018-01-08 18:21:00.0

Homepage:

Size: 3560

Language: Batchfile

GitHub Committers

User	Most Recent Commit	# Commits
Tom White	2017-07-06 08:48:01.0	4
Patrick Ryan	2016-10-26 21:26:27.0	8
Christian Reich	2017-09-09 18:23:57.0	8
rsjaffe	2017-09-09 16:21:37.0	3
Sigfried Gold	2017-09-26 10:55:42.0	1
Jon Duke	2015-08-19 02:21:57.0	1
Martijn Schuemie	2018-03-21 08:30:53.0	11
Rae Woong Park	2016-11-06 14:18:54.0	1
Peter Rijnbeek	2017-03-08 14:59:33.0	1
Vojtech Huser	2017-09-28 02:32:46.0	8
Ajit Londhe	2017-07-20 04:12:04.0	1
Lee Evans	2015-03-20 18:08:48.0	2
Alexey Arestenko	2016-02-05 19:02:53.0	1
Anthony Sena	2017-06-09 13:57:23.0	13
clairblacketer	2018-02-22 20:22:27.0	173
cukarthik	2017-06-05 02:28:15.0	2
Gowtham Rao	2017-11-06 10:29:17.0	16
Richard Starr	2016-04-29 21:00:01.0	2

Other Committers

User	Email	Most Recent Commit	# Commits
Karthik Natarajan	kan7003@knatarajan.cpmc.columbia.edu	2017-01-12 21:15:00.0	2
Karthik Natarajan	kan7003@nyp.org	2017-01-03 00:27:35.0	3
Karthik Natarajan	kan7003@nyp.org	2017-01-03 00:27:35.0	3
Blacketer	mblacke@its.jnj.com	2017-12-01 18:38:22.0	3
pbr6cornell	pryan4@wprdusr98rggcr.wks.jnj.com	2014-10-14 20:35:46.0	1

README

Common Data Model v5.3

See full CDM specification file on our github wiki or in the CDM V5.3 PDF

Release Notes for v5.3

This version is based on the pull requests and CDM proposals:

• #64 This removes the datetime fields from OBSERVATION_PERIOD
• #70 Adds the VISIT_DETAIL table
• #79 Adds the METADATA table
• #92 Fixes qualifier typo in PROCEDURE_OCCURRENCE
• #120 Adds the following fields to PAYER_PLAN_PERIOD:
  • PAYER_CONCEPT_ID
  • PAYER_SOURCE_CONCEPT_ID
  • PLAN_CONCEPT_ID
  • PLAN_SOURCE_CONCEPT_ID
  • SPONSOR_CONCEPT_ID
  • SPONSOR_SOURCE_CONCEPT_ID
  • STOP_REASON_CONCEPT_ID
  • STOP_REASON_SOURCE_VALUE
  • STOP_REASON_SOURCE_CONCEPT_ID

Additional Updates

• There is a development branch now available with the DDLs and documentation for tables and/or changes that have been accepted into a future version of the CDM. Please use these with caution as they are subject to change upon formal release
• BigQuery, Netezza, and Parallel Data Warehouse DDLs are now available

---

This repo contains the definition of the OMOP Common Data Model. It supports the SQL technologies: BigQuery, Impala, Netezza, Oracle, Parallel Data Warehouse, Postgres, Redshift, and SQL Server. For each, the DDL, constraints and indexes (if appropriate) are defined.

Versions are defined using tagging and versioning. Full versions (V6, 7 etc.) are usually released each year (1-Jan) and are not backwards compatible. Minor versions (V5.1, 5.2 etc.) are not guaranteed to be backwards compatible though an effort is made to make sure that current queries will not break. Micro versions (V5.1.1, V5.1.2 etc.) are released irregularly and often, and contain small hot fixes or backward compatible changes to the last minor version.