[MI/URSA-CORE] NDC-HCPCS Crosswalk

Prev Next

Object Description

One record per unique NDC and HCPCS code combination.

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_107
  • Layer: METADATA_AND_INTEGRATION
  • Object Type: Ursa Reference
  • Temporal Class: Entity
  • Case ID: NDC Code 11-Digit, HCPCS Code
  • Primary Key: NDC Code 11-Digit, HCPCS Code

Published Fields

  • [No Field Group]
    • NDC Code 11-Digit -- The standard 11-digit National Drug Code; e.g., 00045012400 = Tylenol 500 mg.
    • HCPCS Code -- The Healthcare Common Procedure Coding System (HCPCS) code associated with a service. Includes both HCPCS Level I codes (commonly called CPT codes) and Level II codes (which includes products, supplies, and services not included in CPT). Level II codes consist of a letter followed by four numeric digits. Current Dental Terminology codes are included in the Level II codes as HCDT. (See also [URSA-CORE] HCPCS Description)