OHDSI Home | Forums | Wiki | Github

Clarifications on the OHDSI CIEL terminology

Developers
#1

Hi everyone,

I’m trying to plan the conversion of our data tables into the CONDITION_OCCURRENCE table. Now, this requires terminology mappings. The OpenMRS dictionary contains MVP CIEL mappings, which were recently added to OHDSI. This will really help in our work (thank you!).

However, I was looking through these mappings in the concept table. Looking at the concept code field, I believe that this is the mapping codes that we need to match the OpenMRS concepts against. However, it seems that these codes are a bit different from what i’ve normally seen. For example, some of these codes are prepended with a '“900000000000*****” which doesnt seem to be right…

Hmmmmm… are we missing something here?

#2

@Suranga:

Not sure. I don’t see any such codes:

select * from concept where concept_code like '9000000%' and vocabulary_id='CIEL';

returns nothing.

Let me know what’s happening.

#3

Hi,

Oops, I do apologize. It seems that I had messed up my database somehow. Everything is indeed fine :sunny:.
Thank you for taking a look, @Christian_Reich

t