OHDSI Home | Forums | Wiki | Github

Duplicate OMOP CDM field concepts


(Rimma Belenkaya) #1

There are duplicate concepts for many OMOP CDM fields. For example:

|concept_id|concept_name|domain_id|vocabulary_id|concept_class_id|standard_concept|concept_code|valid_start_date|valid_end_date|invalid_reason|
|1,147,127|condition_occurrence.condition_occurrence_id|Metadata|CDM|Field|S|CDM183|11/11/2014|12/31/2099||
|1,147,663|condition_occurrence.condition_occurrence_id|Metadata|CDM|Field|S|CDM709|10/11/2018|12/31/2099||

This looks like a mistake.

Thank you.


(Christian Reich) #2

@rimma:

Thanks for the catch. This is a mistake. Unchanged fields should not repeat. Will get fixed.


(Christian Reich) #3

@rimma:

I stand corrected. It’s not a mistake. The difference is that these are different: The type changed from INT to BIGINT. Each time something changes a new concept will be created. Pick the one that belongs to the version we are working with, which is the latter in this case. There are CONCEPT_RELATIONSHIP records to all the versions a field or table is valid in, and of course there are the valid dates.


t