mdatool
Healthcare Data Dictionary for the Modern Data Stack
LibraryBlogPricing
mdatool
mdatool

The healthcare data dictionary for dbt, Snowflake, Databricks, and BigQuery. 100,000+ ISO-11179 standard terms, free SQL tools, and AI data modeling.

HIPAA-AlignedEnterprise Ready

Tools

  • SQL Linter
  • DDL Converter
  • Bulk Sanitizer
  • Naming Auditor
  • Name Generator
  • AI Data Modeling
  • HCC Calculator
  • Data Model Canvas

Library

  • Glossary
  • Guides
  • Blog

Company

  • About
  • Contact
  • Pricing

Account

  • Sign Up Free
  • Sign In
  • Upgrade to Pro
  • Dashboard

Legal

  • Privacy Policy
  • Terms of Service

© 2026 mdatool. All rights reserved.

Built for healthcare data teams.

Back to Glossary

Domain

Pharmacy

NDC codes, dispensing, PBM, RxNorm and formulary management

1,921 pharmacy terms

ndc last namendc_last_nm

In pharmacy reference data contexts, this field likely captures the manufacturer or labeler surname or trailing segment of a drug product name associated with a National Drug Code, used to support drug name parsing, display, and search functionality in pharmacy systems.

ndc legal namendc_legal_nm

The official FDA-registered name of a drug product as it appears on the approved labeling associated with a National Drug Code. Used in regulatory reporting, pharmacy benefit management, and drug reference databases to ensure accurate and compliant drug product identification.

ndc levelndc_lvl

A hierarchical classification value assigned to a National Drug Code indicating its position within a drug product hierarchy, such as labeler, product, or package level. The 11-digit NDC structure distinguishes these levels for formulary management and pharmacy claims processing.

ndc license numberndc_lic_nbr

A regulatory license or registration identifier linked to a National Drug Code, typically referencing the manufacturer or labeler license issued by the FDA or state pharmacy board. Used to verify drug product authorization and manufacturing compliance in pharmacy data systems.

ndc marital statusndc_mar_sts

A data element of uncertain direct applicability to a National Drug Code; in pharmacy or clinical contexts, this may represent a patient demographic attribute captured alongside NDC prescription data for population health analysis or eligibility-based drug coverage determination.

ndc master identifierndc_mstr_id

The enterprise-level master identifier assigned to a National Drug Code across integrated pharmacy and healthcare data systems. Used to reconcile NDC records from multiple source systems into a single authoritative drug product reference within a master drug data management framework.

ndc maximumndc_max

The upper threshold value defined for a National Drug Code, representing limits such as maximum daily dose, maximum quantity per dispensing event, or maximum reimbursable units. Applied in pharmacy benefit management during claims adjudication to enforce clinical and coverage policy rules.

ndc medical record numberndc_mrn

The patient medical record number associated with a prescription or dispensing event linked to a specific National Drug Code. Used to connect pharmacy claims or medication history records to a patient's clinical record in integrated healthcare data environments for care coordination.

ndc middle namendc_mid_nm

The middle name or initial component of the drug product name associated with a National Drug Code. Used in pharmacy systems and drug databases to fully identify a medication by its complete name, distinguishing it from similarly named formulations.

ndc minimumndc_min

The lower threshold value associated with a National Drug Code record, such as minimum dispensable quantity, minimum reimbursable dose, or minimum package size. Used in pharmacy benefit management and drug formulary systems to enforce dispensing rules and reimbursement limits.

ndc mobilendc_mob

The mobile phone number associated with a contact linked to a National Drug Code record, such as a drug manufacturer or pharmacy representative. Used in pharmaceutical data management systems to facilitate outreach regarding drug recalls, shortages, or formulary changes.

ndc modified byndc_mod_by

The system user identifier or username of the individual who last updated a National Drug Code record. Used in pharmacy and drug reference databases to maintain audit trail accountability, supporting data governance and regulatory compliance for drug information management.

ndc modified datendc_mod_dt

The calendar date on which a National Drug Code record was most recently updated in the system. Used in pharmacy databases and drug reference systems to track when drug attributes such as pricing, dosage, or formulary status were last changed, supporting audit and compliance requirements.

ndc modified timendc_mod_tm

The timestamp indicating the exact time a National Drug Code record was last updated. Used alongside the modified date in pharmacy and drug reference systems to provide a precise audit trail of changes to drug attributes, pricing, or formulary classifications.

ndc namendc_nm

The human-readable display name assigned to a National Drug Code, typically including the drug's brand or generic name, strength, and dosage form. Used in pharmacy systems, claims processing, and formulary management to identify and present drug information in a standardized, readable format.

ndc notendc_nt

A free-text annotation field attached to a National Drug Code record, capturing supplemental information such as dispensing restrictions, formulary exceptions, therapeutic equivalence notes, or regulatory flags. Used in pharmacy management systems to document contextual details not captured in structured fields.

ndc numberndc_nbr

The FDA-assigned 10- or 11-digit National Drug Code stored as ndc_nbr in pharmacy claims databases, PBM adjudication systems, and EHR medication dispensing records. Data engineers must account for 10-digit to 11-digit normalization using segment padding rules when joining NCPDP claim data to drug reference files such as First Databank or Medi-Span for accurate drug identification and formulary analytics.

ndc onset datendc_onset_dt

The date on which a National Drug Code became active, effective, or was first introduced into a formulary or drug reference system. Used in pharmacy benefit management and drug database systems to track when a specific drug product became available for dispensing or reimbursement.

ndc oxygen saturationndc_o2sat

The blood oxygen level for a national drug code. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for ndc management and reporting.

ndc paid amountndc_pd_amt

The dollar amount reimbursed or paid for a drug identified by its National Drug Code on a pharmacy claim. Used in pharmacy benefit management and claims adjudication systems to capture the actual payment made to the dispensing pharmacy after plan pricing, copays, and adjustments are applied.

PreviousPage 57 of 97Next