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,993 pharmacy terms

ndc countryndc_ctry

The country associated with the drug labeler or dispensing entity linked to a National Drug Code. Relevant in pharmacy supply chain management and regulatory compliance reporting to identify foreign-manufactured drugs or international dispensing sources within claims and drug master file records.

ndc created byndc_crtd_by

The username or system identifier of the user or automated process that created a National Drug Code record in the pharmacy data system. Used for audit trail purposes to establish accountability, support data governance, and trace the origin of drug master file entries or formulary additions.

ndc created datendc_crtd_dt

The calendar date on which a National Drug Code record was first entered into the pharmacy or drug master file system. Used in data governance, formulary lifecycle management, and audit reporting to establish the timeline of drug record additions and track database currency.

ndc created timendc_crtd_tm

The timestamp recording the exact time a National Drug Code record was created in the pharmacy or drug data system. Combined with the created date to provide a precise audit trail entry, supporting data integrity reviews and system reconciliation in pharmacy benefit management platforms.

ndc creatininendc_cr

The kidney function marker 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 datendc_dt

A general-purpose date field associated with a National Drug Code transaction or record, such as the dispensing date or effective date of a formulary status change. Context-dependent within pharmacy claims and drug utilization systems to capture key drug-related event timing.

ndc datetimendc_dttm

A combined date and time value capturing a specific moment associated with a National Drug Code event, such as a prescription fill timestamp or formulary update. Used in pharmacy operations and claims systems where precise chronological tracking of drug transactions is required for auditing or sequencing.

ndc dea numberndc_dea_nbr

The Drug Enforcement Administration registration number linked to a prescriber or pharmacy associated with a controlled substance identified by its National Drug Code. Required for Schedule II-V drug dispensing validation, controlled substance monitoring programs, and compliance reporting to federal and state regulatory agencies.

ndc death datendc_death_dt

The date of death for a national drug code. Used to track temporal information related to ndc death date. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for ndc management and reporting.

ndc deductible amountndc_ded_amt

The dollar amount applied toward a member's deductible for a pharmacy claim line identified by a specific National Drug Code. Used in pharmacy benefit adjudication to track cost-sharing obligations before insurance coverage begins for drug transactions.

ndc deleted datendc_del_dt

The date on which a National Drug Code record was marked as deleted within the pharmacy reference database or formulary system. Used to maintain audit history and ensure accurate drug code management when NDCs are removed from active use or replaced by updated codes.

ndc deleted indicatorndc_del_ind

A flag identifying whether a National Drug Code has been removed from the active pharmacy formulary or drug reference database. Used in pharmacy benefit management to prevent adjudication of claims submitted with inactive or discontinued NDC codes.

ndc descriptionndc_desc

The human-readable text label associated with a National Drug Code, typically including the drug name, strength, dosage form, and manufacturer. Used in pharmacy claims processing, formulary management, and clinical reporting to clearly identify specific drug products.

ndc detailndc_dtl

Granular product-level information associated with a National Drug Code, including package size, labeler, and product segment identifiers. Used in pharmacy benefit management and drug reference systems to support accurate drug identification, claims adjudication, and utilization reporting.

ndc due datendc_due_dt

The date by which a payment or reimbursement obligation related to a National Drug Code transaction must be settled. Used in pharmacy claims and rebate management workflows to track financial deadlines associated with drug-level billing and manufacturer rebate agreements.

ndc durationndc_dur

The length of time a National Drug Code record remains valid or active within a pharmacy benefit system or drug reference database. Used in formulary management to define the period during which an NDC is eligible for claims adjudication and reimbursement processing.

ndc effective datendc_eff_dt

The date on which a National Drug Code becomes active and eligible for use in pharmacy claims adjudication or formulary benefit processing. Used to manage drug code lifecycle, formulary updates, and pricing schedules within pharmacy benefit management systems.

ndc emailndc_eml

An electronic mail address associated with the contact or administrative record linked to a National Drug Code entry in a pharmacy reference or formulary system. Used for communication and notification purposes in drug code management and pharmacy benefit administration workflows.

ndc emergency indicatorndc_emerg_ind

A flag identifying whether a pharmacy claim or drug transaction associated with a National Drug Code qualifies as an emergency dispensing event. Used in pharmacy benefit adjudication to apply appropriate cost-sharing rules, override restrictions, and support emergency supply dispensing scenarios.

ndc end datendc_end_dt

The date on which a National Drug Code is no longer valid or eligible for pharmacy claims adjudication within a benefit plan or drug formulary. Used in pharmacy benefit management to enforce drug code expiration and prevent reimbursement of discontinued or delisted drug products.

PreviousPage 57 of 100Next