OHDSI Home | Forums | Wiki | Github

Mapping classfication concept to standard concept

Vocabulary Users
#1

Hello.
I am trying to map an ATC concept id(classification concept-21603256) to its omop standard concept. Using the maps to relationship i get nothing. But there is a Non-standard to Standard map (OMOP) relationship that gets me a result.
1- what is the difference between those 2 relationships (maps to and Non-standard to Standard map (OMOP)) ?
2-As i am trying to implement an ETL automatically, wich relationship will best map the source concept ids to the standard ones without issue ?

Thank you

#2

@matt_sew:

Welcome to the family.

They are the same. “Maps to” is the relationship_id, and “Non-standard to Standard map (OMOP)” is the relationship_name, which is the long version of the same thing.

ATC concepts are drug classification concepts, combining one or more active ingredients into a larger bucket. You can’t have a classification in a patient record.

Except for ATC 5th level. Like in your case, 21603256, which is salbutamol; inhalant (European name), stands for the drug ingredient albuterol (American name of the same thing). Nominally, it is only the inhalant dose form, but that, again, is a classification. So, the mapping drops it and maps it to the ingredient (uphill mapping).

So, when ETLing just follow the “Maps to” blindly and place the resulting concept into the table that is indicated by the domain_id (DRUG_EXPOSURE in this case).

What’s odd is that you don’t have that “Maps to” relationship. When you downloaded the Vocabularies, did you click on ATC?

1 Like
t