Mutiple ingredients in DRUG_STRENGTH table

Implementers
1

HI,

We are implementing OMOP data model 5.0 on our data warehouse, I have a question about drug table which need your help:
Drug_strength table requires each row for each ingredient, so I wonder if there are existing solutions to map the medications with multiple ingredients? does anybody has such an experience?

Thanks.
Min

2

Hi Min: DRUG_STRENGTH is a table that is included with the vocabulary.
You do not need to populate it yourself and it does not contain any source
information, you can simply download and import it as a reference file.
Then, when you are running analyses that require standardized dose
informaiton, you can use this information to join to your DRUG_EXPOSURE
table.

Cheers,

Patrick

3

Hi Patric, thanks a lot for your quick reply, your suggestion would be very helpful.

Thanks,

4

Hi Patric

I cannot find the reference file for drug_strength table, insteadly, I found a SQL statement in PostgreSQL to generate
the table, if there is no file to download, then I wonder if there is SQL in MS SQL server?

Thanks.
Min

5

Min:

Sorry for the slow response. The file is currently stored here.