Field	Value
Short Name	FDA Structured Product Labels
Family	MTHSPL
Source Restriction Level	0
Language	ENG
License Contact	RxNorm Customer Service U.S. National Library of Medicine 8600 Rockville Pike Bethesda MD United States 20894 (888) FIND-NLM rxnorminfo@nlm.nih.gov https://www.nlm.nih.gov/research/umls/rxnorm/
Content Contact	RxNorm Customer Service U.S. National Library of Medicine 8600 Rockville Pike Bethesda MD United States 20894 (888) FIND-NLM rxnorminfo@nlm.nih.gov https://www.nlm.nih.gov/research/umls/rxnorm/

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, term type (TTY), and suppress values.

SOURCE_CODE	SOURCE_STR	RXCUI	RXNORM_STR	RXNORM_TTY	SUPPRESS
50844-993	IBUPROFEN 200 mg ORAL TABLET, FILM COATED	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 = '50844-993'
     AND rc1.sab = 'MTHSPL'
     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
WK2XYI10QM	IBUPROFEN	5640	has_tradename	BN	Advil Cold and Sinus	N
WK2XYI10QM	Ibuprofen	5640	has_tradename	BN	Advil Sinus Congestion and Pain	N
WK2XYI10QM	ibuprofen	5640	has_tradename	BN	Proprinal	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 = 'WK2XYI10QM'
     AND rc1.sab = 'MTHSPL'
     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, TTY, RxNorm string, and suppress values.

NDC	RXCUI	RXNORM_TTY	RXNORM_STR	SUPPRESS
55910-392-12	310965	SCD	Ibuprofen 200 MG Oral Tablet	N
62207-365-41	310965	SCD	Ibuprofen 200 MG Oral Tablet	N
62207-365-48	310965	SCD	Ibuprofen 200 MG Oral Tablet	N
0363-0292-12	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 = 'MTHSPL'
     AND rs.rxcui = rc.rxcui
     AND rc.sab = 'RXNORM'
     AND rc.tty in ('SCD','SBD','GPCK','BPCK')
     AND rc.rxcui = '310965'
     ORDER BY suppress;