Question again: I used concept_relationship table with relationship ‘RxNorm-ATC’, ‘Primary lateral’, ‘Primary up’ and ancestor table to create a thorough mapping from RxNorm to ATC. It’s working great in general! However, when we tested it with the lipids RxNorm codes generated by lipid domain experts, we noticed that below RxNorm weren’t able to map to ATC2 lipids modifying agents.
Couple answers (or definite challenge to your domain experts. )
Cetirizine (Zyrtec) is not listed under ATC2 C10 “LIPID MODIFYING AGENTS”, but under ATC2 R06 “ANTIHISTAMINES FOR SYSTEMIC USE”. No connection to lipid medications.
Simvastatin/sitagliptin combos are not listed under ATC2 C10 “LIPID MODIFYING AGENTS”, but under ATC2 A10 “DRUGS USED IN DIABETES”. This is the only one where you could argue with ATC that it is also a lipid modifier.
Topiramate is not listed under ATC2 C10 “LIPID MODIFYING AGENTS”, but under ATC2 N03 “ANTIEPILEPTICS”. Not sure why they think it is lipid lowering. The only association I can see is that it causes weight loss, and could be used for that.
Calcium gluconate is not listed under ATC2 C10 “LIPID MODIFYING AGENTS”, but under ATC2 A12 “MINERAL SUPPLEMENTS”. Why that should be lipid lowering beats me.
Glyburide (known as glibenclamide in Europe) is not listed under ATC2 C10 “LIPID MODIFYING AGENTS”, but under ATC2 A10 “DRUGS USED IN DIABETES”. It has nothing to do with the lipids.
Pentobarbital is not listed under ATC2 C10 “LIPID MODIFYING AGENTS”, but under ATC2 N05 “PSYCHOLEPTICS”. Seriously? Pentobarbital? It’s not even sold in the US anymore. It’s nasty. A drug from the 60ies, today only used for assisted suicide and execution of the death penalty. Nothing to do with lipids.
All the other calcium and sodium salts are all not lipid modifying drugs by any stretch of the imagination.
Hydrocodone is not listed under ATC2 C10 “LIPID MODIFYING AGENTS”, but under ATC2 R05 “COUGH AND COLD PREPARATIONS”. It’s an opioid used to supress cough (but doesn’t give you the high). Lipids? Beats me.
Amitriptyline is not listed under ATC2 C10 “LIPID MODIFYING AGENTS”, but under ATC2 N06 “PSYCHOANALEPTICS”. It’s an antidepressant. It can cause weight gain. I don’t know if it does it through the lipid metabolism, but certainly the effect is in the wrong direction.
Pantothenic acid is vitamin B5. Not even going there.
Ha! I forgot that one. It actually is a lipid modifier, and it is listed under C02 “LIPID MODIFYING AGENTS” (but spelled colestyramine in Europe). However, in combination with diclofenac they consider the latter the main ingredient, which makes the combo ATC5 M01AB55 “diclofenac, combinations”, listed under ATC2 M01 “ANTIINFLAMMATORY AND ANTIRHEUMATIC PRODUCTS”. But actually that combination makes no sense, and there is no NDC listed for it. No idea why RxNorm even has it.
Bottom line: ATC works fairly well, and you can trust it. Not sure about those friends of yours.