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

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 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

Source Representation

File: RDOSED2_DOSE_DESC

Dosage Form Description Table

Relates the various dosage form codes to their descriptions/abbreviations.

GCDF

Dosage Form Code (2-character)

RXNCONSO.CODE for DF atom

DOSE

Dosage Form Description

N/A

GCDF_DESC

Dosage Form Code Description

RXNCONSO.STR for DF atom

Segment/subfield 4 of CDA, CDC and CDD atoms

File: RGCNSEQ4_GCNSEQNO_MSTR

Clinical Formulation ID Table

Provides attributes of a Clinical Formulation ID (GCN_SEQNO) drug formulation.

1	GCN_SEQNO	Clinical Formulation ID (Stable ID)	MRCONSO.CODE for CDA, CDC, CDD atoms
2	HIC3	Hierarchical Specific Therapeutic Class Code (Stable ID)	N/A
3	HICL_SEQNO	Ingredient List Identifier (formerly the Hierarchical Ingredient Code LIst Sequence Number) (Stable ID)	N/A
4	GCDF	Dosage Form Code (2-character)	N/A
5	GCRT	Route of Administration Code (1-character)	N/A
6	STR	Drug Strength Description	N/A
7	TC	Therapeutic Class Code, Generic	N/A
9	DCC	Drug Category Code	N/A
10	GCN_SEQ_GI	GCN_SEQNO-Level Multi-Source/Single Source Indicator	N/A
11	GENDER	Gender-Specific Drug Indicator	N/A
12	HIC3_SEQN	Hierarchical Specific Therapeutic Class Code Sequence Number (Stable ID)	N/A
13	STR60	Drug Strength Description	RXNCONSO.STR; segment/subfield 2 of CDA, CDC, and CDD atoms

File: RHICD5_HIC_DESC

Hierarchical Ingredient Code Description Table|

Relates the HIC_SEQN to its text description and provides attributes of that relationship.

1	HIC_SEQN	Hierarchical Ingredient Code Sequence Number (Stable ID)	RXNCONSO.CODE for IN atoms
2	HIC	Hierarchical Ingredient Code	N/A
3	HIC_DESC	Hierarchical Ingredient Code Description	RXNCONSO.STR for IN atoms
4	HIC_ROOT	Hierarchical Ingredient Parent HIC4 Sequence Number	N/A
5	HIC_POTENTIALLY _INACTV_IND	Hierarchical Ingredient Code Sequence Number Potentially Inactive Indicator	N/A
6	ING_STATUS_CD	Ingredient Status Code	N/A

File: RHICLSQ1_HICLSEQNO_MSTR

Ingredient List Identifier Description Table v1

Relates the HICL_SEQNO to the generic drug ingredient list.

HICL_SEQNO

Ingredient List Identifier (Stable ID)

Join field

GNN

Generic Name - Short Version

RXNCONSO.STR

Segment/subfield 1 of CDA atoms

GNN60

Generic Name - Long Version

RXNCONSO.STR

Segment/subfield 1 of CDC, CDD atoms

File: RNDC14_NDC_MSTR

NDC Table

Provides attributes of a packaged product.

1	NDC	National Drug Code	RXNSAT.ATN = NDC
2	LBLRID	Labeler Identifier	N/A
3	GCN_SEQNO	Clinical Formulation ID (Stable ID)	The NDC attribute is attached to the AUI of the CDC or MTH_RXN_CDC atom with this CODE
4	PS	Package Size	N/A
5	DF	Drug Form Code	N/A
6	AD	Additional Descriptor	N/A
7	LN	Label Name	N/A
8	BN	Brand Name	N/A
9	PNDC	Previous National Drug Code	N/A
10	REPNDC	Replacement National Drug Code	N/A
11	NDCFI	NDC Format Indicator	N/A
12	DADDNDC	Date of Add—NDC	N/A
13	DUPDC	Date of Update—NDC	N/A
14	DESI (not populated)	DESI Drug Indicator	N/A
15	DESDTEC	DESI Status Change Effective Date	N/A
16	DESI2 (not populated)	DESI2 Drug Indicator	N/A
17	DES2DTEC	DESI2 Status Change Effective Date	N/A
18	DEA	Drug Enforcement Administration Code	N/A
19	CL	Drug Class	N/A
20	GPI	Generic Price Indicator (not currently used)	N/A
21	HOSP	Hospital Selection Indicator	N/A
22	INNOV	Innovator Indicator	N/A
23	IPI	Institutional Product Indicator	N/A
24	MINI	Mini Selection Indicator	N/A
25	MAINT	Maintenance Drug Indicator	N/A
26	OBC	Orange Book Code	N/A
27	OBSDTEC	Obsolete Date	Used in determining atom and attribute suppressibility
28	PPI	Patient Package Insert Indicator	N/A
29	STPK	Standard Package Indicator	N/A
30	REPAC	Repackaged Indicator	N/A
31	TOP200	Top 200 Drugs Indicator	N/A
32	UD	Unit Dose Indicator	N/A
33	CSP	Case Pack	N/A
34	NDL_GDGE	Needle Gauge	N/A
35	NDL_LNGTH	Needle Length	N/A
36	SYR_CPCTY	Syringe Capacity	N/A
37	SHLF_PCK	Shelf Pack	N/A
38	SHIPPER	Shipper Quantity	N/A
39	HCFA_FDA	HCFA FDA Therapeutic Equivalency Code ?	N/A
40	HCFA_UNIT	HCFA Unit Indicator	N/A
41	HCFA_PS	HCFA Units Per Package	N/A
42	HCFA_APPC	HCFA FDA Approval Date	N/A
43	HCFA_MRKC	HCFA Market Entry Date	N/A
44	HCFA_TRMC	HCFA Termination Date	N/A
45	HCFA_TYP	HCFA Drug Type Code	N/A
46	HCFA_DESC1	HCFA DESI Effective Date	N/A
47	HCFA_DESI1	HCFA DESI Code	N/A
48	UU	Unit of Use Indicator	N/A
49	PD	Package Description	N/A
50	LN25	Not currently used	N/A
51	LN251	Label Name - 25/Generic Name Use Indicator	N/A
52	GPIDC	This column is not currently being used	N/A
53	BBDC	This column is not currently being used	N/A
54	HOME	Home Health Selection Indicator	N/A
55	INPCK1	Inner Package Indicator	N/A
56	OUTPCKI	Outer Package Indicator	N/A
57	OBC_EXP	Expanded Orange Book Code	N/A
58	PS_EQUIV	Package Size Equivalent Value	N/A
59	PLBLR	Private Labeler Indicator	N/A
60	TOP50GEN	Top 50 Generics	N/A
61	OBC3	Orange Book Code; three-byte version	N/A
62	GMI	Generic Manufacturer Indicator	N/A
63	GNI	Generic Name Indicator	N/A
64	GSI	This column is not currently being used	N/A
65	GTI	Generic Therapeutic Equivalence Indicator	N/A
66	NDCGI1	Multi-Source/Single Source Indicator (NDC-Level)	N/A
67	HCFA_DC	HCFA Drug Category	N/A
68	LN60	Label Name - 60	N/A

File: RROUTED3_ROUTE_DESC

Route of Administration Description Table

Relates the various routes of administration codes to their descriptions/abbreviations.

1	GCRT	Route of Administration Code (1-character)	N/A
2	RT	Route Description	RXNCONSO.STR Segment/subfield 2 of CDA, CDC, CDD atoms
3	GCRT2	Route of Administration Code (2-character)	N/A
4	GCRT_DESC	Route Code Interpretation	N/A
5	SYSTEMIC	Systemic Route Indicator	N/A

Not for public documentation:

Below this line is a listing of tables that I think are used in the inversion (e.g. for joining fields) but the data doesn’t directly get represented. I don’t think we need to document them for external users, but I am leaving this list here in case I need to go back to these files.

File: RAPPLSL0_FDA_NDC_NDA_ANDA

NDC to FDA NDA/ANDA Table

Links an NDC to its FDA NDA/ANDA application status, FDA trade name, and FDA unique identifier.

1	National Drug Code
2	NDA Status Indicator
3	ANDA Status Indicator
4	FDA Listing Sequence Number
5	FDA Trade Name

File: RAPPLTD0_FDA_APPL_TYPE

FDA Drug Application Type Table

Provides the text description for an FDA Drug Application Type Code.

1	FDA Drug Application Type Code
2	FDA Drug Application Type Code	Actual column name?

File: RHICL1_HIC_HICLSEQNO_LINK

HICL_SEQNO/HIC Relation Table

Links individual ingredients to an ingredient list.

1	Ingredient List Identifier (formerly the Hierarchical Ingredient Code List Sequence Number) (Stable ID)
2	Hierarchical Ingredient Code Sequence Number (Stable ID)
3	Hierarchical Ingredient Code Relative Number
4	Hierarchical Ingredient Code

File: RLBLRID3_LBLR_DESC

Labeler Identifier Description Table

Relates the Labeler Identifier to its text description and provides attributes of that association.

1	Labeler Identifier
2	Manufacturer Name
3	Labeler Indicator Code

File: RMEDMGL0_MED_GENERIC_MED_LINK

MED MED Concept/Generic MED Relation Table

Links a MED Concept to its generically named companion.

1	MED Concept ID
2	MED Concept ID Type
3	Generically Named MED Concept
4	MED Concept Obsolete Date

File: RMIDEAD1_REF_FED_DEA_DESC

MED Reference Federal DEA Class Code Description Table

Relates the Reference Federal DEA Class Code to its text description.

1	MED Reference Federal DEA Class Code
2	MED Reference Federal DEA Class Code Description

File: RMIDESD1_REF_DESI_IND_DESC

MED Reference DESI Indicator Description Table

Relates the Reference DESI Indicator to its text description.

1	MED Reference DESI Indicator
2	MED Reference DESI Indicator Description

File: RMIDFID1_ROUTED_DOSE_FORM_MED

MED Routed Dosage Form Medication Table

Provides the attributes of the routed dosage form medication.

1	MED Routed Dosage Form Medication ID (Stable ID)
2	MED Routed Medication ID (Stable ID)
3	MED Dosage Form ID
4	MED Routed Dosage Form Medication Description
5	MED Medication Status Code

File: RMIGECD1_REF_GEN_THERAP_DESC

MED Reference Generic Therapeutic Equivalence Code Description Table

Relates the Reference Generic Therapeutic Equivalence Code to its text description.

1	MED Reference Generic Therapeutic Equivalence Code
2	MED Reference Generic Therapeutic Equivalence Code Description

File: RMILGND1_REF_FED_LGND_DESC

MED Reference Federal Legend Indicator Description Table

Relates the Reference Federal Legend Indicator to its text description.

1	MED Reference Federal Legend Indicator
2	MED Reference Federal Legend Indicator Description

File: RMINMID1_MED_NAME

MED Medication Name Table

Provides attributes of the medication name.

1	MED Medication Name ID (Stable ID)
2	MED Medication Name
3	MED Medication Name Type Code
4	MED Medication Status Code

File: RMIRMID1_ROUTED_MED

MED Routed Medication Table

Provides attributes of the routed medication.

1	MED Routed Medication ID (Stable ID)
2	MED Medication Name ID (Stable ID)
3	MED Route ID
4	MED Routed Medication Description
5	MED Medication Status Code

File: RMISCD1_STATUS_DESC

MED Status Code Description Table

Relates the Medication Status Code to its text description.

1	MED Medication Status Code
2	MED Medication Status Code Description

File: RMIID1_MED *** BDs come from here but aren’t released

MED Medication Table

Provides the attributes of a medication

1	MEDID	MED Medication ID (Stable ID)
2	ROUTED_DOSAGE_FORM_MED_ID	MED Routed Dosage Form Medication ID (Stable ID)
3	MED_STRENGTH	MED Strength
4	MED_STRENGTH_UOM	MED Strength Unit of Measure
5	MED_MEDID_DESC	MED Medication Description
6	GCN_SEQNO	Clinical Formulation ID (Stable ID)
7	MED_GCNSEQNO_ASSIGN_CD	MED GCN_SEQNO Assignment Code
8	MED_NAME_SOURCE_CD	MED Medication Name Source Code
9	MED_REF_FED_LEGEND_IND	MED Reference Federal Legend Indicator
10	MED_REF_DEA_CD	MED Reference Federal DEA Class Code
11	MED_REF_MULTI_SOURCE_CD	MED Reference Multi-Source Code
12	MED_REF_GEN_DRUG_NAME_CD	MED Reference Generic Medication Name Code
13	MED_REF_GEN_COMP_PRICE_CD	MED_REF_GEN_COMP_PRICE_CD
14	MED_REF_GEN_SPREAD_CD	MED_REF_GEN_SPREAD_CD
15	MED_REF_INNOV_IND	MED Reference Innovator Indicator
16	MED_REF_GEN_THERA_EQU_CD	MED Reference Generic Therapeutic Equivalence Code
17	MED_REF_DESI_IND	MED_REF_DESI_IND
18	MED_REF_DESI2_IND	MED_REF_DESI2_IND
19	MED_REF_STATUS_CD	MED Medication Status Code
20	GENERIC_MEDID	MED Generic Medication Identifier

File: RMINDC1_NDC_MEDID

MED NDC to Medication ID Cross-Reference Table

Links a drug product to its brand Medication ID.

1	NDC	National Drug Code
2	MEDID	MED Medication ID (Stable ID)

RxNorm Representation

NDDF includes the following Term Types:

TTY	Description	Notes
CDA	Clinical drug name in abbreviated format	String with "Generic Name - Short Version" - delimiter " " CODE = RGCNSEQ4_GCNSEQNO_MSTR.GCN_SEQNO Clinical Formulation ID (field 1) CDA atoms have the same SUPPRSS value as their CDC atoms with the same CODE
CDC	Clinical drug name in concatenated format	String with "Generic Name - Long Version" - delimiter " " CODE = RGCNSEQ4_GCNSEQNO_MSTR. GCN_SEQNO Clinical Formulation ID (field 1) SUPPRESS = N, O assigned to indicate obsolete drug name SUPPRESS = Y assigned by editors
CDD	Clinical drug name in delimited format	String with "Generic Name - Long Version" - delimiter "@" CODE = RGCNSEQ4_GCNSEQNO_MSTR. GCN_SEQNO Clinical Formulation ID (field 1) CDA atoms have the same SUPPRSS value as their CDC atoms with the same CODE
DF	Dose Form	Dose Form CODE = RDOSED2_DOSE_DESC. Dosage Form Code (2-character) (field 1) SUPPRESS = “N”
IN	Name for an ingredient	Ingredient CODE = RHICD5_HIC_DESC. Hierarchical Ingredient Code Sequence Number (field 1) SUPRESS = N or O
MTH_RXN_CDC	RxNorm Created CDC	Created to resolve NDC conflicts. See: RxNorm Technical Documentation (nih.gov) SUPPRESS = N

TTY = CDA:

Clinical drug name in abbreviated format

RXNCONSO.STR is created by concatenating Generic Name (Short Version) + ' ' + Drug Strength Description - 60 + ' ' + Route Description + ' ' + Dosage Form Description.

CODE = RGCNSEQ4_GCNSEQNO_MSTR.GCN_SEQNO (field 1, Clinical Formulation ID)

Term Segment	Name	Field in Data File
1	Generic Name (Short Version)	RHICLSQ1_HICLSEQNO_MSTR.GNN (Generic Name – Short version; field 2)
2	Strength	RGCNSEQ4_GCNSEQNO_MSTR.STR60 (Drug Strength Description; field 13)
3	Route Description	RROUTED3_ROUTE_DESC.RT (Route Description; field 2)
4	Dosage Form Code Description	RDOSED2_DOSE_DESC.GCDF_DEF (Dosage Form Code Description; field 3)

CDA atoms do not have any relationships with other NDDF atoms.

TTY = CDC (Clinical drug name in concatenated format)

RXNCONSO.STR is created by concatenating Generic Name (Long Version) + ' ' + Drug Strength Description - 60 + ' ' + Route + ' ' + Dose Form.

Term segment	Name	Field in Data File
1	Generic Name(Long Version)	RHICLSQ1_HICLSEQNO_MSTR.GNN60 (Generic Name – Long Version; field 3)
2	Drug Strength Description	RGCNSEQ4_GCNSEQNO_MSTR.STR60 (Drug Strength Description; field 13)
3	Route Description	RROUTED3_ROUTE_DESC.RT (Route Description; field 2)
4	Dosage Form Description	RDOSED2_DOSE_DESC.GCDF_DEF (Dosage Form Code Description; field 3)

CDC atoms have the following relationships with other NDDF atoms:

TTY1	TTY2	RELA	Type of relationships
CDC	DF	has_dose_form	one-to-(one or many)

TTY = CDD

Clinical drug name in delimited format (CDD)

RXNCONSO.STR is created by concatenating Generic Name (Long Version) + '@' + Drug Strength Description - 60 + '@ ' + Route Description + '@ ' + Dosage Form Description.

Term segment	Name	Field in Data File
1	Generic Name(Long Version)	RHICLSQ1_HICLSEQNO_MSTR.GNN60 (Generic Name – Long Version; field 3)
2	Drug Strength Description	RGCNSEQ4_GCNSEQNO_MSTR.STR60 (Drug Strength Description; field 13)
3	Route Description	RROUTED3_ROUTE_DESC.RT (Route Description; field 2)
4	Dosage Form Code Description	RDOSED2_DOSE_DESC.GCDF_DEF (Dosage Form Code Description; field 3)

CDD atoms do not have any relationships with other NDDF atoms.

TTY = DF (Dose Form)

RXNCONSO.STR is created from the Dosage Form Code Description

Name	Field in Data File
Dosage Form Code Description	RDOSED2_DOSE_DESC.GCDF_DEF (Dosage Form Code Description; field 3)

NDDF DF atoms do not have any attributes.

NDDF DF atoms have the following relationships with other NDDF V2 source atoms

TTY1	TTY2	RELA	Type of Relationship
DF	CDC	dose_form_of	one-to-(one or many)

TTY = IN (Name for an ingredient)

NDDF ingredient is a simple description of the generic chemical name of the drug. RXNCONSO.STR is created from the Hierarchical Ingredient Code Description

Field Name	Field in Data File
Hierarchical Ingredient Code Description	RHICD5_HIC_DESC.HIC_DESC (Hierarchical Ingredient Code Description; field 3

NDDF IN atoms do not have any attributes.

RELATIONSHIPS (RXNREL.RRF):

REL/

RELA/inverse RELA

Origin

has_dose_form/dose_form_of

Connects CDC to DF atoms(s)

ATTRIBUTES (RXNSAT.RRF)

ATN

Origin

NDC

RNDC14_NDC_MSTR.NDC (field 1)

Suppressibility (N, O) is based on factors including

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: April 10, 2024

Unified Medical Language System® (UMLS®)

Source Synopsis

Metadata

Source Representation

RxNorm Representation

Data Examples with Sample Database Queries

Names and Codes in RXNCONSO.RRF

Names and Relationships in RXNCONSO.RRF and RXNREL.RRF

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

Unified Medical Language System^® (UMLS^®)