I have a question about how I can map an OHDSI concept id to a UMLS concept. What I know is (learned from the recent OHDSI tutorial), given a concept name, I can retrieve its OHDSI concept id from the concept table and also find its ID in the source vocabulary ( e.g. a LOINC vocabulary id), and then I can retrieve this source concept id in the UMLS database to get its UMLS id.
This would mean multiple joins. Is there some table in OHDSI that has the mapping from OHDSI concept id to UMLS concept id directly?
Thanks for your help.