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
OHDSI Home | Forums | Wiki | Github |
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
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.