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

mammogram copay amountmammo_cpay_amt

The fixed out-of-pocket dollar amount a health plan member owes for a mammography imaging service, including screening and diagnostic breast imaging procedures. Applied during claims adjudication based on the member's benefit plan, with many plans waiving the copay for preventive screening mammograms under ACA-compliant coverage requirements.

metric copay amountmtr_cpay_amt

The fixed out-of-pocket dollar amount tied to a specific performance or utilization metric used within a value-based or incentive-driven health plan benefit design. Applied during claims adjudication to enforce cost-sharing rules aligned with quantitative thresholds such as quality scores, utilization rates, or care compliance measurements.

morbidity copay amountmorb_cpay_amt

The fixed dollar amount a member pays out-of-pocket for healthcare services related to disease burden or chronic condition management. Used in claims adjudication to track patient cost-sharing obligations tied to morbidity-coded encounters and risk adjustment reporting.

mortality copay amountmort_cpay_amt

The fixed dollar amount a member is responsible for paying on claims associated with end-of-life or terminal condition services. Used in claims processing to capture patient cost-sharing on encounters classified under mortality-related diagnosis codes for actuarial and financial reporting.

mri copay amountmri_cpay_amt

The fixed out-of-pocket dollar amount a member owes at the time of service for a Magnetic Resonance Imaging procedure. Applied during claims adjudication based on the member's benefit plan design, determining patient responsibility for MRI diagnostic imaging services.

ndc account numberndc_acct_nbr

The unique account identifier associated with a National Drug Code in pharmacy billing and drug dispensing systems. Used to link NDC-level drug transactions to a specific payer, pharmacy, or billing account for reconciliation, claims processing, and pharmacy benefit management reporting.

ndc active indicatorndc_actv_ind

A binary flag indicating whether a specific National Drug Code is currently active and eligible for dispensing, billing, or formulary inclusion. Used in pharmacy benefit management systems to filter valid NDCs during claims adjudication, drug pricing lookups, and formulary administration.

ndc active statusndc_actv_sts

The current lifecycle state of a National Drug Code, indicating whether the drug product is active, discontinued, or inactive within drug reference databases such as FDA NDC Directory. Used in pharmacy systems to validate NDC eligibility during prescription processing and claims adjudication.

ndc addressndc_addr

The physical or mailing address associated with the labeler segment of a National Drug Code, typically referencing the drug manufacturer or repackager registered with the FDA. Used in pharmacy data management to verify labeler identity and support drug supply chain compliance reporting.

ndc adjustment amountndc_adj_amt

The dollar value applied to modify the original billed or allowed amount on a pharmacy claim for a specific National Drug Code. Adjustments may reflect pricing corrections, rebate recalculations, or coordination of benefits changes processed during pharmacy claims adjudication or post-adjudication reconciliation.

ndc agendc_age

The elapsed time in years since a National Drug Code was first assigned or approved by the FDA. Used in drug reference and formulary management systems to assess product maturity, patent lifecycle stage, and eligibility transitions between branded and generic drug classifications.

ndc allowed amountndc_alwd_amt

The maximum dollar amount a payer will reimburse for a drug product identified by its National Drug Code, based on contracted rates or drug pricing benchmarks such as AWP or MAC pricing. Used in pharmacy claims adjudication to calculate plan liability and member cost-sharing obligations.

ndc amountndc_amt

The total monetary value associated with a pharmacy transaction for a specific National Drug Code, representing either the billed, allowed, or paid amount depending on context. Used in pharmacy claims processing and drug spend analytics to track financial exposure at the NDC level.

ndc approval statusndc_appr_sts

The regulatory or formulary authorization state of a National Drug Code, indicating whether the drug has received FDA marketing approval and payer formulary acceptance. Used in pharmacy benefit management to determine dispensing eligibility, prior authorization requirements, and step therapy compliance.

ndc approved byndc_appr_by

The identifier of the individual, system, or regulatory body that authorized a National Drug Code for formulary inclusion, prior authorization, or dispensing. Used in pharmacy benefit management workflows to maintain audit trails for drug approval decisions and formulary exception processing.

ndc arrival timendc_arrv_tm

The timestamp recording when a drug product associated with a specific National Drug Code arrived at a dispensing location such as a pharmacy or healthcare facility. Used in pharmacy inventory management and drug supply chain tracking to monitor delivery timeliness and stock replenishment cycles.

ndc arrived datendc_arrv_dt

The calendar date on which a drug product identified by its National Drug Code was received at a dispensing pharmacy or healthcare facility. Used in pharmacy inventory and supply chain management systems to track shipment receipt, expiration dating, and drug availability for dispensing.

ndc assessmentndc_asmt

A structured clinical or formulary evaluation associated with a National Drug Code, documenting the therapeutic review, safety profile, or coverage determination for a drug product. Used in pharmacy benefit management and formulary committee workflows to support drug tier placement and coverage policy decisions.

ndc balancendc_bal

The remaining dollar amount outstanding on a pharmacy claim or account for a specific National Drug Code after payments, adjustments, and credits have been applied. Used in pharmacy billing and accounts receivable systems to track unresolved financial obligations at the drug transaction level.

ndc billed amountndc_bill_amt

The total dollar amount submitted by a pharmacy or drug supplier on a claim for a specific National Drug Code prior to adjudication and payer adjustments. Used in pharmacy claims processing to establish the initial charge basis for allowed amount calculations and member cost-sharing determinations.

PreviousPage 53 of 97Next