We are in process of implementing an in-house vocabulary repository which will be supported by an User interface to search different vocabularies. Our source of data for the Vocabulary is Concept Table which we downloaded from Athena and our data model follows OMOP CDM. While working on getting the vocabularies for drug domain, we are experiencing this scenario where we cannot populate the generic /drug name and its difficult to identify using existing fields available in concept table. We currently have the information as part of a bigger description field. Please see snapshot below. We wanted to understand if we can reverse engineer this to extract the generic name, or there any queries or other data dictionaries/databases that can be leveraged for this implementation.
Thanks and regards,