September Release - 09/03/2013
This release of RxNorm is consistent with the 2013AA UMLS Metathesaurus release. For additional information about RxNorm releases, including scripts for loading the RxNorm data into Oracle and MySQL databases, read the RxNorm technical documentation.
Sources
The following sources have been updated since the previous RxNorm release:
Source Name | SAB | Date Updated |
---|---|---|
Gold Standard Drug Database | GS | 08/05/2013 |
Medi-Span Master Drug Data Base | MDDB | 08/07/2013 |
Multum MediSource Lexicon | MMSL | 08/01/2013 |
Micromedex RED BOOK | MMX | 08/05/2013 |
FDA Structured Product Labels | MTHSPL | 08/29/2013 |
FDB MedKnowledge (formerly NDDF Plus) | NDDF | 08/07/2013 |
Veterans Health Administration National Drug File - Reference Terminology | NDFRT | 09/03/2013 |
US Edition of SNOMED CT (drug information) | SNOMEDCT_US | 07/31/2013 |
Veterans Health Administration National Drug File | VANDF | 07/19/2013 |
The following sources have not been updated in this release:
Source Name | SAB | Date Updated |
---|---|---|
Anatomical Therapeutic Chemical Classification System | ATC | 2013 |
Medical Subject Headings (MeSH) | MSH | 01/21/2013 |
FDA National Drug Code Directory | MTHFDA | 06/01/2011 |
Data Changes
With this release, RxNorm now includes information from the US Edition of SNOMED CT, which combines the SNOMED CT International Release and the US Extension to SNOMED CT. For this reason, we changed the source abbreviation (SAB) for SNOMED CT from 'SNOMEDCT' to 'SNOMEDCT_US'.
Due to the switch from SNOMED CT International to the US Edition of SNOMED CT, we increased the size of some data fields in the RxNorm database load scripts:
Oracle
- RXNCUI.ctl
- ver_start from char(20) to char(40)
- ver_end from char(20) to char(40)
- RXNSAB.ctl
- VSAB from char(20) to char(40)
- RxNormDDL.sql
- RXNCUI - ver_start from varchar2(20) to varchar2(40)
- RXNCUI - ver_end from varchar2(20) to varchar2(40)
- RXNSAB - VSAB from varchar2(20) to varchar2(40)
MySQL
- Table_scripts_mysql_rxn.sql
- RXNCUI - ver_start from varchar(20) to varchar(40)
- RXNCUI - ver_end from varchar(20) to varchar(40)
- RXNSAB - VSAB from varchar(20) to varchar(40)
If you are using your own load scripts, you need to update these data fields.
Data Counts
Term Type or Attribute | Number |
---|---|
Active GPCK forms | 337 |
Active BPCK forms | 413 |
Active SCD forms | 20,094 |
Active SBD forms | 11,068 |
Active RXNORM MIN atoms | 3,848 |
Active RXNORM IN atoms | 9,237 |
Active RXNORM PIN atoms | 2,184 |
Active RXNORM BN atoms | 6,992 |
Active RXNORM DF atoms | 104 |
Obsolete GPCK forms | 118 |
Obsolete BPCK forms | 95 |
Obsolete SCD forms | 13,791 |
Obsolete SBD forms | 9,595 |
Obsolete RXNORM MIN atoms | 0 |
Obsolete RXNORM IN atoms | 0 |
Obsolete RXNORM PIN atoms | 0 |
Obsolete RXNORM BN atoms | 8,762 |
Obsolete RXNORM DF atoms | 51 |
Editor-suppressed SCD forms | 1,100 |
Editor-suppressed SBD forms | 912 |
OCD atoms | 311,857 |
Source-asserted NDC codes | 1,252,381 |
Distinct Source-asserted NDC codes | 561,996 |
SAB=RXNORM NDC codes | 194,357 |
Distinct SAB=RXNORM NDC codes | 194,357 |
Last Reviewed: September 3, 2013