NDDF Source Information

Field	Value
Short Name	FDB MedKnowledge
Family	NDDF
Source Restriction Level	3
Language	ENG
License Contact	First Databank Customer Support 701 Gateway Blvd, Suite 600 South San Francisco CA United States 94080 800-633-3453 cs@fdbhealth.com
Content Contact	First Databank Customer Support 701 Gateway Blvd, Suite 600 South San Francisco CA United States 94080 800-633-3453 cs@fdbhealth.com

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
008346	ibuprofen@200 mg@ORAL@TABLET	310965	Ibuprofen 200 MG Oral Tablet	SCD	N
008346	ibuprofen 200 mg ORAL TABLET	310965	Ibuprofen 200 MG Oral Tablet	SCD	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 = '008346'
     AND rc1.sab = 'NDDF'
     AND rc1.rxcui = rc2.rxcui
     AND rc2.sab = 'RXNORM'
     AND rc2.tty in ('SCD','SBD','GPCK','BPCK');

Names and Relationships in RXNCONSO.RRF and RXNREL.RRF

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

SOURCE_CODE	SOURCE_STR	RXCUI	RELA	RXNORM_TTY	RXNORM_BN	SUPPRESS
002377	ibuprofen	5640	has_tradename	BN	Dragon Tabs	N
002377	ibuprofen	5640	has_tradename	BN	Nuprin	N
002377	ibuprofen	5640	has_tradename	BN	Samson 8	N
002377	ibuprofen	5640	has_tradename	BN	Motrin	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 rxnorm_bn, rc2.suppress
FROM rxnconso rc1, rxnrel rr, rxnconso rc2
WHERE rc1.code = '002377'
     AND rc1.sab = 'NDDF'
     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;

National Drug Code (NDC) and Names in RXNSAT.RRF and RXNCONSO.RRF

Here are sample source NDC, RXCUI, RxNorm TTY, RxNorm string, and suppress values.

NDC	RXCUI	RXNORM_TTY	RXNORM_STR	SUPPRESS
00904791251	310965	SCD	Ibuprofen 200 MG Oral Tablet	N
00904791570	310965	SCD	Ibuprofen 200 MG Oral Tablet	N
10135018310	310965	SCD	Ibuprofen 200 MG Oral Tablet	N
11383015111	310965	SCD	Ibuprofen 200 MG Oral Tablet	N

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

SELECT distinct rs.atv as ndc, rs.rxcui, rc.tty as rxnorm_tty, rc.str as rxnorm_str, rs.suppress
FROM rxnsat rs, rxnconso rc
WHERE rs.atn = 'NDC'
     AND rs.sab = 'NDDF'
     AND rs.rxcui = rc.rxcui
     AND rc.sab = 'RXNORM'
     AND rc.tty in ('SCD','SBD','GPCK','BPCK')
     AND rc.rxcui = '310965'
     ORDER BY suppress;