OHDSI Home | Forums | Wiki | Github

Some of the concept_id's of Vocabulary_id 'UCUM' is missing in Vocabularies Version 5.x compared to Vacabularies 4.5

Vocabulary Users
#1

Hi,
I am trying to use Vocabualries version 5.x in converting Truven Marketscan data. Some of the concept_id’s of Vocabulary_id ‘UCUM’ is missing in Vocabularies Version 5.x compared to Vacabularies 4.5.
Truven Data uses some of these units. Can I add these missing concepts in Vocabularies version 5.x from Vacabularies Version 4.5 or should I stop using these missing concepts from Vocabularies version 5.x .
Please suggest.

#2

@Akash:

Hm. Nothing should be missing. The version numbers 4.5 and 5 are merely a formatting spec, the content is identitical. What do you find is missing?

#3

@Akash, yes, please report what’s missing and I’ll check

#4

image.png528×1161 22.4 KB

#5

#6

#7

#8

#9

just take the one random concept from your list:

select * from v5.concept where concept_code = ‘mL/h’ – concept_id = 44777613
;
select * from v4.concept where concept_code = ‘mL/h’ – concept_id = 44777613
;
it’s present both in 5th and 4th versions.

@Akash, what query do you use to get these concepts?

t