I hope I’ve mentioned the right person.
The current code for building the drug_era table only references RxNorm.
WHERE c.vocabulary_id = 8 ---8 selects RxNorm from the vocabulary_id
This results in RxNorm Extension-unique ingredients to be left out in the final drug_era table. Shouldn’t we be adding another vocabulary_id to include RxNorm Extension-unique ingredients as well?
WHERE c.vocabulary_id in (8, 00) ---8 selects RxNorm and 00 selects RxNorm Extension from the vocabulary_id
Thanks in advance!