Field	Value
Short Name	DrugBank
Family	DRUGBANK
Source Restriction Level	0
Language	ENG
License Contact	OMx Personal Health Analytics Inc. 301 - 10359 104 St. Edmonton Alberta Canada T5J 1B9 312-440-7742 support@omx.io http://www.drugbank.ca
Content Contact	OMx Personal Health Analytics Inc. Edmonton Alberta Canada T5J 1B9 312-440-7742 support@omx.io http://www.drugbank.ca

This section lists specific source data elements and provides information on their representation in RxNorm.

Summary of Changes

There are no changes to the original data format or to RxNorm source processing.

Source Provided Files:

The file is available at https://portal.drugbankplus.com/

The following file is used for RxNorm source processing.

File Name	Description
Drugs.json	Json File

Source-Provided Files: Details

The following is a list of fields in the DrugBank source file used in RxNorm:

File name: Drugs.json

Field Name	Description
Primary_accession_number	Unique DrugBank accession number consisting of a 2-letter prefix (DB) and a 5-number suffix. This ID is used to access the drug entry via the URL. If an entry is deleted, it's DrugBank ID will not be reused.
Secondary_accession_number	It consists of the 4-letter prefix and a 5-number suffix. Each accession number is unique to the drug's generic name. The 4-letter suffix (APRD, EXPT, BIOD, NUTR) indicates the type of drug (APRD=approved small molecule drug, EXPT=experimental drug, BIOD=biotech drug, NUTR=nutraceutical or natural product).
Name	Standard name of drug as provided by drug manufacturer.
Synonym	Alternate names of the drug
UNII	FDA UNII code
Language	Language of Synonym

DrugBank Field Representation in RxNorm Files:

Field	RxNorm Representation
Primary_accession_number	RXNCONSO.CODE
Secondary_accession_number	RXNSAT.ATN = SID
Name	RXNCONSO.STR CODE = Primary_accession_number TTY = "IN" SUPPRESS = "N"
Synonym	RXNCONSO.STR CODE = Primary_accession_number TTY = "SY" or "FSY" (TTY = SY when Language field is "English"; TTY = FSY when Language field is not "English") SUPPRESS = "N"
UNII	RXNSAT.ATN = FDA_UNII_CODE
Language	Not represented in RxNorm but used to process TTY = "SY" or "FSY"

This section lists RxNorm data elements and traces them back to the specific DrugBank data that populates them.

Summary of Changes

There are no changes to the original data format or to RxNorm source processing.

Source Provided Files:

The file is available at https://portal.drugbankplus.com/

The following file is used for RxNorm source processing.

File Name	Description
Drugs.json	Json File

RxNorm Identifiers:

Identifiers are assigned as follows:

Identifier	Origin
CODE	Primary_accession_number
SAUI	Not applicable
SCUI	Not applicable
SDUI	Not applicable

Atoms (RXNCONSO):

Term Type	Origin
IN	Name
SY	Synonym (Language = "English")
FSY	Synonym (Language = foreign language such as Latin)

Relationships (RXNREL):

No relationships are provided for this source.

Attributes (RXNSAT):

ATN	Origin
SID	Secondary_accession_number
FDA_UNII_CODE	UNII

This section lists source terminology specific data examples and sample database queries using Structured Query Language (SQL) to obtain the data. For more information about RxNorm data and files, see the RxNorm Technical Documentation.

Names and Codes in RXNCONSO.RRF

Here are sample source terminology code, source string, RxNorm Concept Unique Identifier (RXCUI), RxNorm string, RxNorm term type (TTY), and suppress values.

SOURCE_CODE	SOURCE_STR	RXCUI	RXNORM_STR	RXNORM_TTY	SUPPRESS
DB01050	(RS)-ibuprofen	5640	Ibuprofen	IN	N
DB01050	(4-isobutylphenyl)-α-methylacetic acid	5640	Ibuprofen	IN	N
DB01050	Ibuprofeno	5640	Ibuprofen	IN	N

Here is a sample database query to retrieve the data above:

SELECT distinct rc1.code as source_code, rc1.str as source_str, rc1.rxcui, rc2.str as rxnorm_str, rc2.tty as rxnorm_tty, rc2.suppress
FROM rxnconso rc1, rxnconso rc2
WHERE rc1.code = 'DB01050'
     AND rc1.sab = 'DRUGBANK'
     AND rc1.rxcui = rc2.rxcui
     AND rc2.sab = 'RXNORM';

Names and Relationships in RXNCONSO.RRF and RXNREL.RRF

Here are sample source terminology code, source string, RXCUI, relationship name, RxNorm term type (TTY), brand name, and suppress values.

SOURCE_CODE	SOURCE_STR	RXCUI	RELA	RXNORM_TTY	BN	SUPPRESS
DB01050	α-(4-isobutylphenyl)propionic acid	5640	has_tradename	BN	Motrin PM	N
DB01050	(±)-ibuprofen	5640	has_tradename	BN	Motrin PM	N
DB01050	(±)-α-methyl-4-(2-methylpropyl)benzeneacetic acid	5640	has_tradename	BN	Addaprin	N
DB01050	(±)-p-isobutylhydratropic acid	5640	has_tradename	BN	Addaprin	N

Here is a sample database query to retrieve the data above:

SELECT distinct rc1.code as source_code, rc1.str as source_str, rc1.rxcui, rr.rela, rc2.tty as rxnorm_tty, rc2.str as bn, rc2.suppress
FROM rxnconso rc1, rxnrel rr, rxnconso rc2
WHERE rc1.code = 'DB01050'
     AND rc1.sab = 'DRUGBANK'
     AND rc1.rxcui = rr.rxcui2
     AND rr.rela = 'has_tradename'
     AND rr.rxcui1 = rc2.rxcui
     AND rc2.sab = 'RXNORM'
     AND rc2.tty = 'BN'
     ORDER BY suppress;