OHDSI Home | Forums | Wiki | Github

How do I translate the type concept id between domains?

Hi all.

I am a data engineer from Columbia and involved in the allofus project. One of the tasks I am working on right now is to reroute the rows that are in the wrong domain table. If the domain_id does not match the domain in which the concept is found, then the row should be moved to the appropriate domain.

However, I realized that type_concept_id needs to be translated between domains during rerouting. For example, when I rerouted records from condition_occurrence to procedure_occurrence, I assumed that the type_concept_id ‘Primary Condition’ would be translated into ‘Primary Procedure’.

  • Are there existing mappings for type_concept_ids between domains?
  • If not, is there a general strategy for translating the type_concept_ids?

Any guidance and help would be very much appreciated!

CC @cukarthik @Christian_Reich @aostropolets

Cheers,
Chao

@ChaoPang:

Ouch. Nobody answered. Sorry about that.

Answer: Currently, each domain has their own Type Concepts, and there are equivalent ones across the Domains. But that is not consistent. We are working on making the Type Concepts Domain-independent, so there is only one “Primary”. Please stay tuned.

t