OHDSI Home | Forums | Wiki | Github

NDCs Changing Over Time

@Christian_Reich, hoping you could help us here - I think @Chris_Knoll found a funny issue.

Take these NDCs:

00006000543
00006032540
00006032544
00006032582
00006032545
00006032546
00006032548
00006032550
00006032553
00006033504
00006033508

We are seeing these NDCs coming across in our data in 2006/2007.

None of these CONCEPT_CODES exist in our Vocabulary. But a couple years ago, someone gave a presentation to the OMOP/OHDSI community that said if you don’t get the 11-digit NDC, try for the 9-digit NDC. This logic is implemented in our CDM_BUILDER.

Our CDM builder is picking up these NDCs and translating them to the following. The only problem here is that SUVOREXANT didn’t start until 2014/2015.

000060005 (suvorexant 5mg/1 ORAL TABLET, FILM COATED [belsomra])
000060325 (suvorexant 15mg/1 ORAL TABLET, FILM COATED [belsomra])
000060335 (suvorexant 20mg/1 ORAL TABLET, FILM COATED [belsomra])

What is the best solution here?

  1. Should we be using the VALID_START_DATE/END_DATE now?
  2. Should we not be doing the try 9-digit when 11-digit doesn’t work logic?
  3. Or some other idea I don’t have . . .

@ericaVoss:

The new vocabulary released the other day (but the downloader is down for another reason) contains these entries:

000060005 suvorexant 5mg/1 ORAL TABLET, FILM COATED [belsomra] 9-digit NDC 29-AUG-14
00006000530 Suvorexant 5 MG Oral Tablet [Belsomra] 11-digit NDC 01-NOV-14
00006000513 Suvorexant 5 MG Oral Tablet [Belsomra] 11-digit NDC 01-NOV-14
00006000510 Suvorexant 5 MG Oral Tablet [Belsomra] 11-digit NDC 01-NOV-14
000060325 suvorexant 15mg/1 ORAL TABLET, FILM COATED [belsomra] 9-digit NDC 29-AUG-14
00006032510 Suvorexant 15 MG Oral Tablet [Belsomra] 11-digit NDC 01-NOV-14
00006032530 Suvorexant 15 MG Oral Tablet [Belsomra] 11-digit NDC 01-NOV-14
00006032513 Suvorexant 15 MG Oral Tablet [Belsomra] 11-digit NDC 01-NOV-14
000060335 suvorexant 20mg/1 ORAL TABLET, FILM COATED [belsomra] 9-digit NDC 29-AUG-14
00006033530 Suvorexant 20 MG Oral Tablet [Belsomra] 11-digit NDC 01-NOV-14
00006033513 Suvorexant 20 MG Oral Tablet [Belsomra] 11-digit NDC 01-NOV-14
00006033510 Suvorexant 20 MG Oral Tablet [Belsomra] 11-digit NDC 01-NOV-14

So, these are the NDCs picked up by Dailymed and RxNorm. Their valid_start_date is in 2014. We refurbished the way the dates are set, so you can trust them.

However, the last two digits in your list are 04, 08, 40, 43, 44, 45, 56, 48 50 and 53. I have no answer what these are, and whether they are bogus or not. We collect NDCs now from RxNorm, FDB, Medi-Span and Dailymed. Usually, only OTC (cough syrup, multivitamins) and non-drugs (glucose strips) are slipping through. Google doesn’t know them either, which is usually a strong signal.

This changing a paradigm for us, so need to make sure we get it right . . . when should we be using VALID_START_DATE/END_DATE . . . in all SOURCE_CODE cases or for only certain SOURCE_CODES.

It really is only relevant for codes where the date is relevant because the code is reused. Which is only NDC and DRG. The others are only used for internal life cycle managment, so we know to make a deprecated code non-standard and create a “replaced by” relationship.

1 Like

Mentioned this as issue in the Notes
http://www.ohdsi.org/web/wiki/doku.php?id=documentation:vocabulary:ndc

44865343 “Aminophylline 200 MG Oral Tablet” changed to “Cephalexin 500 MG Oral Capsule”

45092451 “Aluminum Hydroxide 200 MG / Magnesium Hydroxide 200 MG Oral Tablet [Rulox #1]” changed to “Allopurinol 100 MG Oral Tablet”

45084807 “GLIMEPIRIDE 4 MG TABLET” changed to “Naproxen sodium 550 MG Oral Tablet” (number provided is the concept_id)

so these concepts totally changed their meaning during the update

@Dymshyts:

We should open a page in the vocabulary description (the one we need to finish, remember?) and start listing them systematically.

http://www.ohdsi.org/web/wiki/doku.php?id=documentation:vocabulary:ndc
@Christian_Reich, do you mean this one?

just pasting the examples from the OHDSI wiki here

There is a problem that NDC can update the vocabulary using the same concepts for a different drug concepts: in the 18/12/17 release we found out that:

44865343 “Aminophylline 200 MG Oral Tablet” changed to “Cephalexin 500 MG Oral Capsule”

45092451 “Aluminum Hydroxide 200 MG / Magnesium Hydroxide 200 MG Oral Tablet [Rulox #1]” changed to “Allopurinol 100 MG Oral Tablet”

45084807 “GLIMEPIRIDE 4 MG TABLET” changed to “Naproxen sodium 550 MG Oral Tablet” (number provided is the concept_id)

so these concepts totally changed their meaning during the update

t