We're working on adding all of our packages. Stay tuned or get in touch if you don't see what you're looking for!
3rd PartyAHFS Therapeutic Classification
AHFS Therapeutic Classification
AHFS® Pharmacologic/Therapeutic Classification System© Module
The AHFS Pharmacologic/Therapeutic Classification System consists of several pipe-delimited ASCII files. The primary table is tblAHFSClass.txt, which is the Classification. The remaining tables map the Classification to various external data sets, i.e., AHFS Drug Information, RxNorm, and NDC.
mapAHFSClass_DIN
Maps Health Canada DIN to the AHFS Therapeutic Classes.
HC_DIN | HC_BrandName | AHFSClassNum | AHFSClassText |
|---|---|---|---|
00000809 | ISOPTO TEARS 0.5% | 52:92 | EENT Drugs, Miscellaneous |
00000817 | ISOPTO TEARS 1% | 52:92 | EENT Drugs, Miscellaneous |
00000868 | ISOPTO CARPINE | 52:40.20 | Miotics |
00000884 | ISOPTO CARPINE | 52:40.20 | Miotics |
00000981 | MYDRIACYL | 52:24 | Mydriatics |
00001007 | MYDRIACYL | 52:24 | Mydriatics |
00001147 | ALBALON | 52:32 | Vasoconstrictors |
00001694 | XYLOCAINE JELLY 2% | 84:08 | Antipruritics and Local Anesthetics |
00001732 | XYLOCAINE 1% | 72:00 | Local Anesthetics |
Want all 12,851 rows? Let's connect you to sales.
mapAHFSClass_NDC2_Obsolete
Maps inactive NDC codes to AHFS Therapeutic Classes.
NDC | NDC_STR | IsBrand | GenericsAvailable | AHFSClassNum | AHFSClassText | PrintClass |
|---|---|---|---|---|---|---|
00002001801 | CAPASTAT SULFATE 500 MG/ML Injectable Solution | True | False | 8:16.04 | Antituberculosis Agents | True |
00002001901 | Seromycin 250 MG Oral Capsule | True | False | 8:16.04 | Antituberculosis Agents | True |
00002020201 | nortriptyline HCl 10 MG in 5 mL Oral Solution | False | 28:16.04.28 | Tricyclics and Other Norepinephrine-reuptake Inhibitors | True | |
00002020301 | opium tincture 10 MG (as morphine equivalent) in 1 mL Oral Solution | False | 28:08.08 | Opiate Agonists | True | |
00002020301 | opium tincture 10 MG (as morphine equivalent) in 1 mL Oral Solution | False | 56:08 | Antidiarrhea Agents | True | |
00002020302 | opium tincture 10 MG (as morphine equivalent) in 1 mL Oral Solution | False | 56:08 | Antidiarrhea Agents | True | |
00002020302 | opium tincture 10 MG (as morphine equivalent) in 1 mL Oral Solution | False | 28:08.08 | Opiate Agonists | True | |
00002030310 | AMYTAL SODIUM 0.5 GM Injection | True | False | 28:24.04 | Barbiturates | True |
00002030325 | AMYTAL SODIUM 0.5 GM Injection | True | False | 28:24.04 | Barbiturates | True |
Want all 326,481 rows? Let's connect you to sales.
mapAHFSClass_NDC2
Maps active NDC codes to AHFS Therapeutic Classes.
NDC | NDC_STR | IsBrand | GenericsAvailable | AHFSClassNum | AHFSClassText | PrintClass | FDAAppNo |
|---|---|---|---|---|---|---|---|
00002021301 | HumuLIN R 100 UNT/ML Injectable Solution | True | False | 68:20.08.12 | Intermediate-acting Insulins | False | BLA018780 |
00002021301 | HumuLIN R 100 UNT/ML Injectable Solution | True | False | 68:20.08.08 | Short-acting Insulins | True | BLA018780 |
00002143301 | Trulicity 0.75 MG in 0.5 ML Auto-Injector | True | False | 68:20.06 | Incretin Mimetics | True | BLA125469 |
00002143361 | Trulicity 0.75 MG in 0.5 ML Auto-Injector | True | False | 68:20.06 | Incretin Mimetics | True | BLA125469 |
00002143380 | Trulicity 0.75 MG in 0.5 ML Auto-Injector | True | False | 68:20.06 | Incretin Mimetics | True | BLA125469 |
00002143401 | Trulicity 1.5 MG in 0.5 ML Auto-Injector | True | False | 68:20.06 | Incretin Mimetics | True | BLA125469 |
00002143461 | Trulicity 1.5 MG in 0.5 ML Auto-Injector | True | False | 68:20.06 | Incretin Mimetics | True | BLA125469 |
00002143480 | Trulicity 1.5 MG in 0.5 ML Auto-Injector | True | False | 68:20.06 | Incretin Mimetics | True | BLA125469 |
00002143601 | Emgality 120 MG in 1 ML Auto-Injector | True | False | 28:32.12 | Calcitonin Gene-related Peptide (CGRP) Antagonists | True | BLA761063 |
Want all 352,918 rows? Let's connect you to sales.
mapAHFSClass_SCDF
Maps the RxNorm Semantic Clinical Drug Form (SCDF) concept unique identifier (CUI) to AHFS Therapeutic Classes.
SCDF_CUI | SCDF_STR | AHFSClassNum | AHFSClassText |
|---|---|---|---|
1000084 | alcaftadine Ophthalmic Solution | 52:02 | Antiallergic Agents |
1000088 | alcaftadine Ophthalmic Solution [Lastacaft] | 52:02 | Antiallergic Agents |
1001436 | caffeine / magnesium salicylate Oral Tablet | 28:08.04.24 | Salicylates |
1001436 | caffeine / magnesium salicylate Oral Tablet | 28:20.32 | Respiratory and CNS Stimulants |
1001475 | aspirin Delayed Release Oral Tablet [Ecpirin] | 28:08.04.24 | Salicylates |
1001569 | levothyroxine Oral Solution | 68:36.04 | Thyroid Agents |
1001687 | magnesium sulfate / potassium sulfate / sodium sulfate Oral Solution | 56:12 | Cathartics and Laxatives |
1001717 | sulfacetamide / sulfur Medicated Liquid Soap [Zencia Wash] | 84:04.04 | Antibacterials |
1001717 | sulfacetamide / sulfur Medicated Liquid Soap [Zencia Wash] | 84:28 | Keratolytic Agents |
Want all 12,813 rows? Let's connect you to sales.
mapNDC_SCDF_UN
Maps the RxNorm Semantic Clinical Drug Form (SCDF) concept unique identifier (CUI) to AHFS Drug Information monographs.
NDC | SCDF_CUI | UN |
|---|---|---|
00002021301 | 362622 | 384041 |
00002143301 | 1649586 | 315021 |
00002143361 | 1649586 | 315021 |
00002143380 | 1649586 | 315021 |
00002143401 | 1649586 | 315021 |
00002143461 | 1649586 | 315021 |
00002143480 | 1649586 | 315021 |
00002143601 | 2058875 | 318050 |
00002143611 | 2058875 | 318050 |
Want all 225,892 rows? Let's connect you to sales.
tblAHFSClass
This main classification table provides all the AHFS Class attributes for each individual AHFS Classification.
AHFSClassID | AHFSClassNum | AHFSClass6 | AHFSClass8 | AHFSClassText | AHFSClassText-fr-ca | AHFSClassParentID | AHFSClassHasSubclass | AHFSRootParentID | AHFSSeqNum | AHFSHierarchyLevel | AHFSPrint | AHFSPrintOrder | AHFSRetired | AHFSRetiredDate | AHFSAddDate | AHFSCxDate | AHFSCxDesc |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 4:00 | 040000 | 04000000 | Antihistamine Drugs | Antihistaminiques | 0 | 1 | 0 | 1 | 1 | 1 | 1 | 0 | 20030101 | |||
2 | 4:04 | 040400 | 04040000 | First Generation Antihistamines | Antihistaminiques de première génération | 1 | 1 | 1 | 1 | 2 | 1 | 2 | 0 | 20040101 | 20040101 | New subclass | |
3 | 4:04.04 | 040404 | 04040400 | Ethanolamine Derivatives | Dérivés d'éthanolamine | 2 | 0 | 1 | 1 | 3 | 1 | 3 | 0 | 20040101 | 20040101 | New subclass | |
4 | 4:04.08 | 040408 | 04040800 | Ethylenediamine Derivatives | Dérivés d'éthylènediamine | 2 | 0 | 1 | 2 | 3 | 1 | 4 | 0 | 20040101 | 20040101 | New subclass | |
5 | 4:04.12 | 040412 | 04041200 | Phenothiazine Derivatives | Dérivés de phénothiazine | 2 | 0 | 1 | 3 | 3 | 1 | 5 | 0 | 20040101 | 20040101 | New subclass | |
6 | 4:04.16 | 040416 | 04041600 | Piperazine Derivatives | Dérivés de pipérazine | 2 | 0 | 1 | 4 | 3 | 1 | 6 | 0 | 20040101 | 20040101 | New subclass | |
7 | 4:04.20 | 040420 | 04042000 | Propylamine Derivatives | Dérivés de propylamine | 2 | 0 | 1 | 5 | 3 | 1 | 7 | 0 | 20040101 | 20040101 | New subclass | |
8 | 4:04.92 | 040492 | 04049200 | Miscellaneous Derivatives | Dérivés divers | 2 | 0 | 1 | 6 | 3 | 1 | 8 | 0 | 20040101 | 20040101 | New subclass | |
9 | 4:08 | 040800 | 04080000 | Second Generation Antihistamines | Antihistaminiques de seconde génération | 1 | 0 | 1 | 2 | 2 | 1 | 9 | 0 | 20040101 | 20040101 | New subclass |
Want all 680 rows? Let's connect you to sales.
tblAHFSClassExtended
Displays AHFS Therapeutic Classes expanded to the fourth tier.
AHFSClass8 | AHFSClassNum | AHFSClassText_1 | AHFSClassText_2 | AHFSClassText_3 | AHFSClassText_4 |
|---|---|---|---|---|---|
04000000 | 4:00 | Antihistamine Drugs | |||
04040000 | 4:04 | Antihistamine Drugs | First Generation Antihistamines | ||
04040400 | 4:04.04 | Antihistamine Drugs | First Generation Antihistamines | Ethanolamine Derivatives | |
04040800 | 4:04.08 | Antihistamine Drugs | First Generation Antihistamines | Ethylenediamine Derivatives | |
04041200 | 4:04.12 | Antihistamine Drugs | First Generation Antihistamines | Phenothiazine Derivatives | |
04041600 | 4:04.16 | Antihistamine Drugs | First Generation Antihistamines | Piperazine Derivatives | |
04042000 | 4:04.20 | Antihistamine Drugs | First Generation Antihistamines | Propylamine Derivatives | |
04049200 | 4:04.92 | Antihistamine Drugs | First Generation Antihistamines | Miscellaneous Derivatives | |
04080000 | 4:08 | Antihistamine Drugs | Second Generation Antihistamines |
Want all 632 rows? Let's connect you to sales.
tblAHFSDrugs
Maps generic names to AHFS classifications and AHFS monographs.
GenDrugName | UN | AHFSClassID | PrintClass |
|---|---|---|---|
1-Nitroso-2-Naphthol (Fluorometric), Free Tyrosine | 1 | 498 | 1 |
2,4-Dinitrofluorobenzene (Spectroscopic), Nitrogen | 1 | 498 | 1 |
2,4-Dinitrophenylhydrazine, Lactate Dehydrogenase | 1 | 498 | 1 |
5-Amp-Phosphate Release (Colorimetric Test), 5'-Nu | 1 | 498 | 1 |
Abacavir | 399012 | 66 | 1 |
Abaloparatide | 317036 | 666 | 1 |
Abaloparatide | 317036 | 686 | 0 |
Abametapir | 321014 | 333 | 1 |
Abatacept | 306003 | 372 | 0 |
Want all 7,119 rows? Let's connect you to sales.
tblAHFSTradenames
Maps trade names to AHFS monographs.
UN | Tradename | Type |
|---|---|---|
323063 | Elevidys | tn |
323062 | Avacincaptad Pegol | gn |
323062 | Izervay | tn |
323061 | Elranatamab | gn |
323061 | Elranatamab-bcmm | syn |
323061 | Elrexfio | tn |
323060 | Palovarotene | gn |
323060 | Sohonos | tn |
323059 | Somatrogon | gn |
Want all 10,452 rows? Let's connect you to sales.
This is a standalone, third-party package that does not connect to DrugBank data or packages.