CDM v5.4.1

This is OMOP CDM v5.4, the current latest release of the OMOP Common Data Model. The zipped folder contains the files to instantiate the CDM tables for all supported SQL dialects. For information relating to this release please see:

• OMOP CDM v5.4 specifications
• Changes from CDM v5.3

This bugfix incorporates some minor fixes and includes synapse and snowflake ddls.

CDM v5.4

This is OMOP CDM v5.4, the current latest release of the OMOP Common Data Model. The zipped folder contains the files to instantiate the CDM tables for all supported SQL dialects. For information relating to this release please see:

• OMOP CDM v5.4 specifications
• Changes from CDM v5.3

CDM v5.3.2

This is a bug-fix update to CDM v5.3 that includes fixes identified during the course of preparing v5.4. This also brings CDM v5.3 up-to-date with v5.4 by releasing the DDLs in a zip file.

• OMOP CDM v5.3 Specifications
• Fixed vocabulary version to be nullable
• Fixed datetime2 issue with postgres DDLs
• Link to v5.3 bug fixes

Pre-release CDM v6.0.1

This is a bug-fix version of CDM v6.0 PLEASE NOTE THAT CDM v6.0 IS NOT SUPPORTED BY OHDSI TOOLS OR METHODS. If you are looking for the latest, supported version of the OMOP Common Data Model please use CDM v5.4.

• Fixes #81 and updates the COST table
• Adds back the COHORT table that was erroneously removed
• Link to v6.0 bug fixes

CDM v6.0.0

This version address the following issues/pull requests:

CDM

• #81 Adds the COST table
• #137 Adds the SURVEY_CONDUCT table
• #181 Adds the LOCATION_HISTORY table
• #91 Latitude and longitude added to LOCATION table
• #107 Contract owner information added to PAYER_PLAN_PERIOD
• #120 New fields added to PAYER_PLAN_PERIOD (PAYER_CONCEPT_ID, PLAN_CONCEPT_ID)
• #166 Record inserted into METADATA to document CDM version
• #172 NOTE_EVENT_ID and NOTE_DOMAIN_ID (NOTE_EVENT_TABLE_CONCEPT_ID) added to NOTE
• #198 Change IDs to BIGINT
• #153 ADMISSION_SOURCE_CONCEPT_ID changed to ADMITTED_FROM_CONCEPT_ID
• #214 All CONCEPT_IDs are mandatory except for UNIT_CONCEPT_ID, VALUE_AS_CONCEPT_ID, and OPERATOR_CONCEPT_ID
• #164 Any reference to DOMAIN_ID was switched to EVENT_FIELD_CONCEPT_ID
• #212 CDM Results schema created with tables COHORT and COHORT_DEFINITION
• #210 DEATH table removed and cause of death now stored in CONDITION_OCCURRENCE
• #166 Record inserted into METADATA identifying the CDM version
• #172 Added NOTE_EVENT_ID and EVENT_FIELD_CONCEPT_ID to NOTE table

Vocabulary

• #186 Keep deprecated CPT concepts active and standard
• #85 NOTE_NLP concepts added

Wiki

• #188 Added foreign key description to wiki files
• All THEMIS rules added to wiki

Additional Updates

• DATE fields are now optional and DATETIME fields are mandatory

CDM v5.2.2

This release is in continued support of older CDM versions. This closes issue #191 and fixes a discrepancy between the DDL and specification.

CDM v5.3.1

This version address the following issues/pull requests:

• #183 Fixes VISIT_DETAIL documentation, 'required' and 'type' columns were switched
• #169 Data type changes for BigQuery
• #171 Datetime formats in Sql Server changed to Datetime2
• #173 Impala reserved words
• #177 Postgres readme
• #140, #144, #135
  • Typos in readme and documentation
• #158 VOCABULARY.VOCABULARY_VERSION no longer a required field
• #157 Added MEASUREMENT.MEASUREMENT_TIME back to DDL for backwards compatibility
• #147 PAYER_PLAN_PERIOD.STOP_REASON_SOURCE_VALUE varchar instead of integer
• #120 PAYER_PLAN_PERIOD documentation
• #160 Removed errant semicolon in license header
• #145 VISIT_DETAIL naming convention
  • This is the change with the most potential impact as column names were updated
• #67 Removed COHORT_DEFINITION_ID foreign key constraint from COHORT table
• #16 Added additional foreign key constraints that were missing
• #12 .csv file is now delivered with each version
• Additional BigQuery updates for compatibility
• A portion of #112 was addressed
  • VISIT_DETAIL and documentation typos

CDM v5.3.0

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 modifier 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

CDM v5.2 Bug Fix 1

This release incorporates some DDL bugfixes that were logged as issues #96, #97, and #98 and addressed by pull request #99. There was no change to the model itself or the documentation.

CDM v5.2.0

This version is based on the CDM working group proposals:

• #71 Adds the field VERBATIM_END_DATE to DRUG_EXPOSURE and makes DRUG_EXPOSURE_END_DATE a required field
• #73 Removes EFFECTIVE_DRUG_DOSE and DOSE_UNIT_CONCEPT_ID from DRUG_EXPOSURE
• #75 Adds the field BOX_SIZE to DRUG_STRENGTH
• #83 Adds the following fields to VISIT_OCCURRENCE:
  • ADMITTING_SOURCE_CONCEPT_ID
  • ADMITTING_SOURCE_VALUE
  • DISCHARGE_TO_CONCEPT_ID
  • DISCHARGE_TO_SOURCE_VALUE
  • PRECEDING_VISIT_OCCURRENCE_ID
• #84 Adds the following fields to CONDITION_OCCURRENCE:
  • CONDITION_STATUS_CONCEPT_ID
  • CONDITION_STATUS_SOURCE_VALUE
• #69 Adds the following fields to COST:
  • DRG_CONCEPT_ID
  • DRG_SOURCE_VALUE
• #85 Adds the NOTE_NLP table and the following fields to NOTE:
  • NOTE_CLASS_CONCEPT_ID
  • NOTE_TITLE
  • ENCODING_CONCEPT_ID
  • LANGUAGE_CONCEPT_ID