CDM v5.3 Release

General
1

CDM v5.3 is live! For this release we used the Sql Render package to generate the DDLs rather than doing them by hand so you will see a few changes, the biggest of which being the addition of BigQuery, Netezza, and Parallel Data Warehouse. We did test each script but please log an issue if you find anything and we will be sure to address it.

This version includes the following changes:

  • #64 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
5 Likes
2

Very nice, @clairblacketer.

3

Great job! @clairblacketer

4

Thank you @clairblacketer

5

This is a great addition, very needed. Great job, @clairblacketer

6

Hi @clairblacketer,
Thank you for the updates.

I would like to ask you - where I could find the omop cdm specifications for the previous versions? Like v5.0, v5.0.1, v5.1 and v.5.2?

Thank you,
Tatiana

7

Hi @TBanokina!

On github, if you go to the code tab and then click ‘releases’ it will take you to the releases page with all the code and specifications for each version.

Clair

8

thank you!

9

Great!

10

Hi CDM builders,

I would like to ask about the new fields in cdm payer_plan_period table.

  1. Which filters on domain_id and vocabulary_id needs to be applied to see the list of possible concepts in the fields: payer_concept_id, plan_concept_id, sponsor_concept_id, stop_reason_concept_id ?
  2. And if those concepts are in the newest vocabulary version?

Thank you in advance!

11

We need to create new concepts for payer plan period It was proposed here https://github.com/OHDSI/CommonDataModel/issues/120

We need to put it in form that @Dymshyts may use to put in OMOP Vocabulary

12

Hi CDM Builders!

I am trying to populate cdm METADATA table and would like to ask you a couple of questions:

  1. I see that in the proposal METADATA_CONCEPT_ID populated with non-standard concepts. Can it be populated with non-standard concepts?
  2. What are the possible values for METADATA_TYPE_CONCEPT_ID field?
  3. How to populate VALUE_AS_CONCEPT_ID field?

Thank you in advance!

13

Hi all!

I am also interested in answers for Tatiana’s questions. I look at examples here https://github.com/OHDSI/CommonDataModel/issues/79 and see non-standard concepts.
Questions 2 and 3 are also actual for me.

Thanks!