OHDSI Home | Forums | Wiki | Github

SQL script for populating Era tables

CDM Builders
#1

Hello,

The SQL scripts for populating Era tables on CDM’s github site has a note that says “This query only works with 5.3 and below.” (sqlScripts.knit)

We are building a OMOP with CDM 5.4. Will there be a concern?

Thanks,
Jack

#2

I think the drug era script will work with v5.4. However I suggest a change in the initial query.

Change " ```
WHERE c.vocabulary_id = ‘RxNorm’ —8 selects RxNorm from the vocabulary_id

to
" ```
 WHERE c.vocabulary_id IN( 'RxNorm', 'RxNorm Extension' )
...
Reply after running if it worked or not.
t