Vexing issues with CDM v5 vocabulary files

[Christian_Reich]

@Christophe_Lambert

restores my faith in the CDM (yes it was shaken)

How could you!!!

@Christophe_Lambert

there are no NDC->RxNorm 1-to-many mappings

We did a lot of clean up in the past months.

@Christophe_Lambert

There are, however, 20 HCPCS codes with 2 map entries …

Working on it as we speak, actually. Should be clean in upcoming release, and stay that way going forward. Since we don’t always know what the exact product is we sometimes have to map to several Ingredients or Clinical Drug Components, if they are combination drugs.

@Christophe_Lambert

numerous HCPCS codes with an empty invalid_reason, but no “Maps to” record to itself in the CONCEPT_RELATIONSHIP table

These are all procedure drugs. They have no mapping today. Some of them will get one (like 45890798 “Injection, epoetin beta, 1 microgram, (for non esrd use)”), others will not and therefore end up in a record with concept_id=0 (e.g. 2718685 “Contraceptive supply, hormone containing patch, each”).