How to identify/remove obsolete and not current RXCUI from RXNCONSO?

[yunmai]

Hi,

I am new to OMOP and currently are doing concept mapping. I mapped a list of local drug names to RXCUI. But I found that 1/3 of the RXCUI is either “obsolete” or “is not current” when I did quality control by searching in RxNAV. For example, 1000717 (seb-prev 10 % topical gel) and 83018 (dynabac) are obsolete, 644844 (influenza virus vaccine trivalent 2006-2007) and 476598 (monoamylamine) are not current.

But the status of these RXCUIs in the recently released RXNCONSO (07062020) are NOT suppressed. Then I searched in the retired, archived, and changed RXCUI tables but none of them could be found in those tables except 1000717 is archived.

I have two questions:

1. Should I NOT used the RXCUI that is “obsolete” or “is not current”?

2. If I should not use RXCUI that is “obsolete” or “is not current”, could anybody tell me how to identify all the “obsolete” or “is not current” RXCUI in RXNCONSO table instead of searching one by one on RxNAV?

Any help is Wellcome. Thank you very much in advance.

[Christian_Reich]

@yunmai:

Hm. Not sure I am following.

But I found that 1/3 of the RXCUI is either “obsolete” or “is not current” when I did quality control by searching in RxNAV

That is because “current” and non-“obsolete” defines the drugs you can actually order from the pharmacy today. That is not our problem. We have data from the past when they were perfectly current.

644844 (influenza virus vaccine trivalent 2006-2007) and 476598 (monoamylamine)

I cannot find such RXCUIs, neither in the CONCEPT table nor in RxNav. What is that?

Should I NOT used the RXCUI that is “obsolete” or “is not current”?

You should use any RxNorm concept that is standard (and therefore also valid) in the CONCEPT table. You can save yourself the effort trying to second guess what we pick and what we discard. In other words, don’t use the RXCONSO table.

If I should not use RXCUI that is “obsolete” or “is not current”, could anybody tell me how to identify all the “obsolete” or “is not current” RXCUI in RXNCONSO table instead of searching one by one on RxNAV?

Again, use the CONCEPT table.

SELECT * FROM concept WHERE vocabulary_id='RxNorm' AND standard_concept='S*

[yunmai]

@Christian_Reich

Thanks for your prompt reply. I really appreciate it.

I was trying to map medication to RXCUI in RXCONSO table downloaded from UMLS.

So not everything from RXNORM table are imported in the CONCEPT table, some are kept and some are discarded when picking the concepts from RXNORM for CONCEPT table. Do I take it right? If so, I’d better to use CONCEPT table instead of RXCONSO table?

[Christian_Reich]

Correct.

In fact, you can make it easier on yourself and just map the ingredients, units and dose forms, and we have a machinery that will do the rest for you:

[yunmai]

@Christian_Reich

Thank you so much to point me to the resources. That saves me a lot of time. I am checking it out and may need to come back here to read the posts about RxNORM Extension later.