[MI/URSA-CORE] NDC Reference

  • Published on Apr 10, 2026
  • 8 minute(s) read
Prev Next

Object Description

One record per NDC code.

The source for this object is Merative™ Micromedex® RED BOOK (formerly IBM Micromedex RED BOOK).

Ursa Studio Update Cadence: Quarterly

Metadata

  • Table Name: ursa.mi_ursa_core_106
  • Layer: METADATA_AND_INTEGRATION
  • Object Type: Ursa Reference
  • Temporal Class: Entity
  • Case ID: NDC Code 11-Digit
  • Primary Key: NDC Code 11-Digit

Published Fields

  • Medication Fields

    • NDC Code 11-Digit -- The standard 11-digit National Drug Code; e.g., 00045012400 = Tylenol 500 mg.
    • Label Description -- Supplies the name given to the product by the manufacturer.
    • Active Ingredients Description -- A natural language description of the medication's biologically active ingredient(s). For medications with multiple active ingredients, the active ingredients should be listed in alphabetical order.
    • Primary Agent Description -- The primary active ingredient in the medication. In medications with multiple active ingredients, this identifies by name only the primary agent.
    • Strength Description -- A natural language description of the medication strength. For medications with multiple active ingredients, the standard convention is to list strength values in the alphabetical order of the active ingredients. (See also [URSA-CORE] Medication Strength)
    • Duration Description
    • Form Description -- The natural language description of the medication's form. (See also [URSA-CORE] Medication Form)
    • Red Book Form Code
    • Route of Administration Description -- The natural language description of the medication's route of administration.
    • Red Book Route of Administration Code
    • Package Unit Quantity
    • Manufacturer Description -- Identifies the name of the company that markets the product. The name appearing in this field corresponds to the FDA-registered labeler name identified by the five-digit labeler code on the NDC number. Therefore, names appearing in this field will include distributors and repackagers in addition to original manufacturers.
    • Is Product Type Medication -- Binary flag where 1 indicates a product type of medication. Default qualification for all records that are not classified as a device (Is Product Type Device = 0) or as a product type of other (Is Product Type Other = 0).
    • Is Product Type Compound Chemical
    • Is Product Type Device -- A Medi-Span binary flag where 1 indicates that the Dispensable Drug is a device.
    • Is Product Type Other -- Binary flag with a value of 1 where the Medi-Span Drug Group Description is a Diagnostic Product, a Pharmaceutical Adjuvant, a Chemical, or an Allergenic Extract / Biological.
    • Is Single Source -- Indicates that the medication is considered to be available from only one source, often a brand-name product with no available generic alternatives or a generic for which a single company holds the patent and has sole rights to sell to consumers. (See also [URSA-PHARM] Is Generic)
    • Is Brand -- Derived from the multi-source code and brand name code from Medi-Span using logic from page 2-19 and 2-20 from the Medi-Span documentation manual. This flag generally indicates that a medication is sold by one manufacturer, sold under a trademarked name, and one drug product exist for the GPI. Exceptions to this are multi-source and brand name combinations of OT and YT. For OT, more than one manufacturer sells the product, but the manufacturer on that NDC is the original seller of the product. For YT, more than one manufacturer sells the product and that manufacturer is not the original seller of the product, but it is sold under a Brand name (common for OTC drugs).
    • Is Generic -- Derived from the multi-source code and brand name code from Medi-Span using logic from page 2-19 and 2-20 from the Medi-Span documentation manual. This flag generally indicates that a medication is sold by more than one manufacturer, sold under a generic name, and multiple drug products exist for the GPI. Exceptions to this are multi-source and brand name code combinations of MG, NG, MB, and NB. These are products where only one company manufacturers them, but they are sold under a generic name.
    • Is Red Book Branded Generic
    • Is OTC -- Indicates that the medication is an over-the-counter (OTC) drug that does not require a prescription.
    • Is Repackaged -- A Medi-Span code that identifies products that have been repackaged for use by mail order suppliers, home health care agencies, nursing homes, physicians, and others. Includes both brand name and generic products.
    • AHFS Therapeutic Class Code 6-Digit -- The standard 6-digit AHFS Pharmacologic-Therapeutic Class Code, representing the first 3 tiers of the AHFS Pharmacologic-Therapeutic Classification system. The code is expressed as 6 numbers, without special characters delimiting the tiers, with leading and trailing zeros as needed. (See also [URSA-CORE] AHFS Pharmacologic-Therapeutic Classification System)
    • AHFS Therapeutic Class Tier 1 Description -- The natural language description of the first-tier category within the AHFS Therapeutic Classification System that the medication is assigned to. (See also [URSA-CORE] AHFS Pharmacologic-Therapeutic Classification System)
    • AHFS Therapeutic Class Tier 2 Description -- The natural language description of the second-tier category within the AHFS Therapeutic Classification System that the medication is assigned to. (See also [URSA-CORE] AHFS Pharmacologic-Therapeutic Classification System)
    • AHFS Therapeutic Class Tier 3 Description -- The natural language description of the third-tier category within the AHFS Therapeutic Classification System that the medication is assigned to. (See also [URSA-CORE] AHFS Pharmacologic-Therapeutic Classification System)
    • DEA Schedule Description -- Drugs, substances, and certain chemicals used to make drugs are classified into five (5) distinct categories or schedules by the US Drug Enforcement Agency (DEA) depending upon the drug’s acceptable medical use and the drug’s abuse or dependency potential. The abuse rate is a determinate factor in the scheduling of the drug; for example, Schedule I drugs have a high potential for abuse and the potential to create severe psychological and/or physical dependence. As the drug schedule changes-- Schedule II, Schedule III, etc., so does the abuse potential-- Schedule V drugs represents the least potential for abuse. A Listing of drugs and their schedule are located at Controlled Substance Act (CSA) Scheduling or CSA Scheduling by Alphabetical Order. See more at https://www.dea.gov/drug-information/drug-scheduling (See also [URSA-CORE] Is DEA Schedule 1, [URSA-CORE] Is DEA Schedule 2, [URSA-CORE] Is DEA Schedule 3, [URSA-CORE] Is DEA Schedule 4, [URSA-CORE] Is DEA Schedule 5)
    • Is DEA Schedule 1 -- Schedule I drugs, substances, or chemicals are defined as drugs with no currently accepted medical use and a high potential for abuse. Some examples of Schedule I drugs are: heroin, lysergic acid diethylamide (LSD), marijuana (cannabis), 3,4-methylenedioxymethamphetamine (ecstasy), methaqualone, and peyote. (See also [URSA-CORE] DEA Schedule Description)
    • Is DEA Schedule 2 -- Schedule II drugs, substances, or chemicals are defined as drugs with a high potential for abuse, with use potentially leading to severe psychological or physical dependence. These drugs are also considered dangerous. Some examples of Schedule II drugs are: Combination products with less than 15 milligrams of hydrocodone per dosage unit (Vicodin), cocaine, methamphetamine, methadone, hydromorphone (Dilaudid), meperidine (Demerol), oxycodone (OxyContin), fentanyl, Dexedrine, Adderall, and Ritalin (See also [URSA-CORE] DEA Schedule Description)
    • Is DEA Schedule 3 -- Schedule III drugs, substances, or chemicals are defined as drugs with a moderate to low potential for physical and psychological dependence. Schedule III drugs abuse potential is less than Schedule I and Schedule II drugs but more than Schedule IV. Some examples of Schedule III drugs are: Products containing less than 90 milligrams of codeine per dosage unit (Tylenol with codeine), ketamine, anabolic steroids, testosterone (See also [URSA-CORE] DEA Schedule Description)
    • Is DEA Schedule 4 -- Schedule IV drugs, substances, or chemicals are defined as drugs with a low potential for abuse and low risk of dependence. Some examples of Schedule IV drugs are: Xanax, Soma, Darvon, Darvocet, Valium, Ativan, Talwin, Ambien, Tramadol (See also [URSA-CORE] DEA Schedule Description)
    • Is DEA Schedule 5 -- Schedule V drugs, substances, or chemicals are defined as drugs with lower potential for abuse than Schedule IV and consist of preparations containing limited quantities of certain narcotics. Schedule V drugs are generally used for antidiarrheal, antitussive, and analgesic purposes. Some examples of Schedule V drugs are: cough preparations with less than 200 milligrams of codeine or per 100 milliliters (Robitussin AC), Lomotil, Motofen, Lyrica, Parepectolin (See also [URSA-CORE] DEA Schedule Description)
    • Is Red Book Exceptional Drug -- Indicates that the medication meets the Red Book "Exceptional Drug" criteria, which "identifies products that may be excluded from coverage by certain third party programs."
    • Is FDA DESI Ineffective
    • Red Book Generic Cross Reference Code -- A unique 6-digit code assigned to all products that contain the same set of active ingredients. By extracting all records containing this code, users can identify comparable products regardless of trade or generic name. (See also [URSA-CORE] Red Book Generic Formulation Code)
    • Red Book Generic Formulation Code -- A unique 6-digit code identifying drugs with common active ingredients, master dosage form, strength, and route of administration. The GFC is not manufacturer or package size specific, and can therefore be used in preparation of drug utilization reports and analysis of generic alternatives for substitution and formulary development. The GFC may also be used within pharmacy and claims administration systems as an efficient means of linking NDC numbers to clinical screening functions. (See also [URSA-CORE] Red Book Generic Cross Reference Code)
    • Is Red Book Generic Formulation Code Active

  • Financial Fields

    • Unit AWP
    • Unit FUL
    • Unit DP

  • Metadata Fields

    • Is NDC Inactive -- A binary field where 1 indicates that the NDC is currently listed as inactive.
    • Current AWP Start Date
    • Current FUL Start Date
    • Current DP Start Date
    • Source Data Effective Datetime -- The "as of" date and time of the original source data system at the moment the current record was extracted. For example, if a snapshot of the data in a production system is taken at 12:05 AM on the first of each month and used to generate a package of flat files that are eventually loaded into the Ursa Studio client database later that month, the Source Data Effective Datetime of all records in that month's package will be 12:05 AM on the first. Not to be confused with Record Last Updated Datetime. (See also [URSA-CORE] Record Last Updated Datetime)

  • Data Model Keys

    • Source ID -- The identifier for the original source data system from which the current record originated.