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

dispense timestampdisp_ts

The combined date and time value recording the exact moment a medication dispense event was completed or recorded in the pharmacy system, used for precise sequencing of dispense records, audit trail documentation, and reconciliation of pharmacy claims data.

dispense titledisp_ttl

The formal name or label assigned to a dispense record or dispensed drug product, used in pharmacy documentation systems to identify the medication by its official drug name, formulation description, or prescription label designation for clinical and administrative records.

dispense totaldisp_tot

The complete calculated cost amount for a dispense event, representing the aggregate of all charge components including ingredient cost, dispensing fees, and applicable adjustments, used in pharmacy claims adjudication and prescription benefit financial reporting.

dispense total countdisp_tot_cnt

The aggregate number of dispense events recorded within a defined scope, such as per member, drug, or time period, used in pharmacy utilization reporting, drug trend analysis, and population health metrics to quantify prescription fill volume and medication usage patterns.

dispense typedisp_typ

Classifies the method or channel of medication dispensing in pharmacy operations, such as retail, mail-order, specialty, or long-term care. Used in pharmacy claims processing and PBM systems to route adjudication rules, apply formulary logic, and support utilization reporting across dispensing channels.

dispense unitdisp_unt

Specifies the unit of measure applied to a dispensed medication quantity, such as tablets, milliliters, grams, or patches. Used in pharmacy claims and medication management systems to standardize quantity calculations, support days-supply verification, and ensure accurate drug utilization reporting.

dispense updated datedisp_upd_dt

Records the most recent date on which a pharmacy dispense record was modified in the system, such as after a claim reversal, quantity adjustment, or data correction. Used in pharmacy claims audit trails to track record changes and ensure data integrity across adjudication cycles.

dispense urgencydisp_urg

Indicates the clinical or operational time-sensitivity of a medication dispense event, such as routine, urgent, or emergent. Used in pharmacy workflow systems to prioritize dispensing queues, coordinate with prescribers on fill timelines, and ensure timely medication delivery for acute or critical patient needs.

dispense valuedisp_val

Captures a quantitative measurement associated with a pharmacy dispense transaction, such as the quantity dispensed, ingredient cost, or reimbursement amount. Used in pharmacy claims and PBM reporting to support drug cost analysis, utilization management, and financial reconciliation across payer and pharmacy records.

dispense versiondisp_ver

Tracks the iteration number of a pharmacy dispense record, incrementing with each update such as claim adjustments, reversals, or corrections. Used in pharmacy claims processing systems to maintain a complete audit history, identify the most current record version, and support downstream reconciliation processes.

dispense zipdisp_zip

Records the ZIP code of the pharmacy location or delivery address where a medication was dispensed. Used in pharmacy claims and PBM systems to support geographic analysis of drug utilization, identify network pharmacy locations, and comply with state-level pharmacy reporting and regulatory requirements.

document copay amountdoc_cpay_amt

Captures the fixed patient cost-sharing amount applied to a clinical document transaction, such as a visit summary or diagnostic report tied to a billable encounter. Used in healthcare billing systems to record patient financial responsibility at the document level and support explanation of benefits reconciliation.

dose copay amountdose_cpay_amt

Records the patient cost-sharing liability assessed for a specific medication dose, particularly in specialty drug or infusion therapy billing. Used in pharmacy and medical claims processing to capture per-dose patient responsibility, support member cost transparency, and reconcile drug administration charges.

drug account numberdrg_acct_nbr

Unique number used to track, bill and manage therapeutic compound or medication. Usually internal number to trace inventory control and drug utilization with the pharmacy settings.

drug active indicatordrg_actv_ind

A binary flag indicating whether a drug record is currently active within a formulary, drug master file, or clinical database. Used in pharmacy benefit management and clinical decision support systems to filter eligible medications, suppress inactive drugs from dispensing workflows, and maintain formulary accuracy.

drug active statusdrg_actv_sts

Describes the current lifecycle state of a drug within a pharmacy or clinical system, such as active, inactive, discontinued, or pending approval. Used in formulary management and drug master files to control prescribing eligibility, dispensing permissions, and integration with clinical decision support rules.

drug addressdrg_addr

In pharmacy management, "drug address" refers to the specific, designated storage location (aisle, shelf, bin) where a medication is stored, often used in automated systems.

drug adjustment amountdrg_adj_amt

Records the financial modification applied to a drug claim transaction, such as a price correction, formulary rebate, or utilization management adjustment. Used in pharmacy claims adjudication and PBM financial reconciliation to reflect net drug cost after contractual, regulatory, or clinical adjustments are applied.

drug admission datedrg_admn_dt

Incase of outpatient pharmacy its the date of prescription filled. It could mean the date when patient was admitted incase of inpatient pharmacy. Drug filled date is the best bet.

drug agedrg_age

Represents the time elapsed since a drug product was first approved, introduced to market, or added to a formulary. Used in pharmacy analytics and formulary management to assess drug lifecycle stage, evaluate generic availability timelines, and support utilization strategy decisions around branded versus generic alternatives.

PreviousPage 36 of 97Next