Skip Navigation Bar
NLM logo

Unified Medical Language System® (UMLS®)

MTHSPL (FDA Structured Product Labeling) Source Information

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

Source Synopsis

Web site:
http://www.fda.gov/ForIndustry/DataStandards/StructuredProductLabeling/default.htm

Authority
The U.S. National Library of Medicine (NLM) produces the Metathesaurus FDA Structured Product Labels (MTHSPL), which is based on the Food and Drug Administration (FDA) Structured Product Labeling (SPL). Information for this source is extracted from the NLM DailyMed Web site.

Purpose
Concept names with this source abbreviation were created by NLM to provide contextual information for FDA SPL terms.

SPL is a document markup standard approved by Health Level Seven (HL7) and adopted by the FDA as a mechanism for exchanging medication information.

RxNorm Scope
MTHSPL includes drug product and substance terminology used in Structured Product Labels.

Update Frequency
MTHSPL is updated daily.

RxNorm Update Frequency
MTHSPL is updated in each RxNorm weekly and monthly release.

Additional Information
Drug labels and the most recently updated information are available on DailyMed. Health information suppliers can download drug labels in SPL format from DailyMed. Drug labeling on DailyMed is the most recent submitted to the FDA and currently in use.

Sites Consulted

  1. FDA Data Standards Council. Rockville (MD): Food and Drug Administration (US). Structured product labeling resources; [cited 2008 Oct 01]. Available from: http://www.fda.gov/ForIndustry/DataStandards/StructuredProductLabeling/default.htm

Metadata

Field Value
Short NameFDA Structured Product Labels
FamilyMTHSPL
Source Restriction Level0
LanguageENG
License ContactRxNorm 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 ContactRxNorm 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/

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

Last Reviewed: March 31, 2020