Skip Navigation Bar
NLM logo

Unified Medical Language System® (UMLS®)

NDDF Source Information

Click on a topic below the Source Synopsis section to display details.

Source Synopsis

Web site:
http://www.fdbhealth.com/fdb-medknowledge/

Authority
FDB MedKnowledge, formerly National Drug Data File (NDDF) Plus, is produced by First DataBank.

Purpose
FDB MedKnowledge combines a comprehensive set of drug database elements, drug pricing and clinical information with multiple types of unique drug identifiers to allow flexibility in representing drugs and health conditions, enhancing clinical decision support.

Description
FDB MedKnowledge encompasses medications approved by the U.S. Food and Drug Administration, and information on commonly-used over-the-counter and alternative therapy agents such as herbals, nutraceuticals and dietary supplements.

RxNorm Scope
The RxNorm representation of FDB MedKnowledge includes only generic clinical drugs, dose forms, and ingredients.

Update Frequency
FDB MedKnowledge is updated weekly.

RxNorm Update Frequency
FDB MedKnowledge is updated in each RxNorm monthly release.

Sites Consulted

  1. FDB MedKnowledge. South San Francisco (CA): First Databank, Inc. FDB MedKnowledge; [cited 2019 April 24]. Available from: http://www.fdbhealth.com/fdb-medknowledge/

Metadata

Field Value
Short NameFDB MedKnowledge
FamilyNDDF
Source Restriction Level3
LanguageENG
License ContactFirst Databank Customer Support
701 Gateway Blvd, Suite 600
South San Francisco
CA
United States
94080
800-633-3453
cs@fdbhealth.com
Content ContactFirst Databank Customer Support
701 Gateway Blvd, Suite 600
South San Francisco
CA
United States
94080
800-633-3453
cs@fdbhealth.com

Source Representation (currently unavailable)

RxNorm Representation (currently unavailable)

Data Examples with Sample Database Queries

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;

Last Reviewed: March 31, 2020