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 engineers & architects.

Back to Glossary

Domain

Pharmacy

NDC codes, dispensing, PBM, RxNorm and formulary management

1,921 pharmacy terms

Discard AfterDA

A pharmacy or laboratory data field specifying the expiration or beyond-use date after which a medication, compound, or specimen should not be used, captured in dispensing and lab information systems. Data engineers use this field to enforce date validation rules, flag expired medication records, and support compliance reporting in pharmacy data pipelines.

Disintegrantdsntgrnt

Refers to an inactive pharmaceutical excipient ingredient recorded in drug formulary and pharmacy benefit management databases that promotes tablet or capsule dissolution, used in NDC-level drug composition data to support clinical decision support, allergy screening, and formulary equivalence analysis.

DispenseDISP

The act of preparing and releasing a prescribed medication to a patient or caregiver by a licensed pharmacist. Captured in pharmacy and PBM systems as a dispensing event record, triggering adjudication, claims submission, and inventory updates in dispensing workflow tables.

Dispensing Feedispns_fee

The reimbursement amount paid to a pharmacy by a PBM or payer for the professional service of filling a prescription, separate from ingredient cost. Stored in pharmacy claims tables as a distinct fee component used in total reimbursement calculations and contract reconciliation audits.

DiureticDIUR

A pharmacological drug class that increases urinary output to reduce excess fluid retention, commonly prescribed for hypertension, heart failure, and edema. Classified by therapeutic category in EHR formulary tables, pharmacy claims systems, and PBM drug classification hierarchies using GPI or therapeutic class codes.

Doctor of PharmacyPharmD

A pharmacist who has earned a Doctor of Pharmacy degree from an accredited college of pharmacy. The PharmD is the standard entry-level professional degree for pharmacists in the United States. PharmD credentials are verified during provider credentialing and pharmacy network enrollment processes.

Dosedose

In EHR, pharmacy, and medication administration systems, a dose is the precisely measured quantity of a drug or therapeutic agent prescribed for administration at a single time or defined interval. Stored in medication order records with unit of measure, route, and frequency attributes, and used in clinical decision support, drug utilization review, and claims billing validation.

Downstream ProcessingDSP

In healthcare data pipelines, refers to ETL stages, analytics workflows, and reporting systems that consume and transform data originating from EHR, claims, pharmacy, or PBM source systems. Critical for data lineage tracking and dependency management in healthcare data engineering.

Drive-Thru Pharmacydrvthru_pharm

Healthcare service model allowing patients to pick up prescriptions, over-the-counter medications, and receive pharmacist consultation without leaving their vehicles. Verifies if the pharmacy has drive through services.

Dropgtt

Unit of measure abbreviation 'gtt' (from Latin gutta) used in pharmacy dispensing systems, EHR medication administration records, and clinical documentation to denote a single liquid drop. Commonly mapped in pharmacy benefit management and clinical dosing tables.

Dropsgtts

Plural unit of measure abbreviation 'gtts' used in pharmacy dispensing systems, EHR medication administration records, and clinical documentation to denote multiple liquid drops. Standardized in pharmacy benefit management dosing and sig code translation tables.

Drug AllergyAllergy

A documented sensitivity or immune system reaction to a specific medication that can cause adverse effects ranging from rash to anaphylaxis. Drug allergies are recorded in EHR systems and checked during prescription processing and pharmacy dispensing to prevent dangerous drug exposures.

Drug Destructiondrug_destruct

The safe disposal process for expired, unused, or unwanted medications including controlled substances. Pharmacies are authorized collection sites under DEA regulations. Drug destruction records are maintained in pharmacy compliance systems and DEA controlled substance registrant inventories.

Drug Enforcement AdministrationDEA

The federal agency responsible for enforcing controlled substance laws and regulations in the United States. Assigns DEA registration numbers to authorized prescribers and pharmacies. DEA numbers are required on all controlled substance prescriptions and are validated in pharmacy claims adjudication systems.

Drug InteractionDI

A clinically significant reaction recorded in EHR and pharmacy systems when two or more drugs, or a drug and food substance, alter each other's pharmacological effects. Data engineers use drug interaction tables from sources like First Databank or Multum within clinical decision support and claims adjudication systems to flag unsafe combinations.

Drug PedigreePedigree

A documented history of a prescription drug product from manufacturer through distribution to dispensing. Required under the Drug Supply Chain Security Act for tracking and tracing prescription drug products. Used in pharmacy compliance systems to verify drug authenticity and prevent counterfeit medications.

Drug RecallRecall

A formal removal or correction action for a marketed pharmaceutical product that violates FDA regulations or poses patient safety risks. Tracked in pharmacy and EHR systems to trigger dispensing halts, patient notifications, and NDC-level data suppression across claims and medication administration records.

Drug ShortageShortage

A supply-side condition where the available quantity of a pharmaceutical product is insufficient to meet patient demand, tracked in pharmacy and PBM systems via NDC-level inventory flags. Triggers formulary substitution workflows, prior authorization overrides, and shortage reporting integrations with FDA and health system procurement platforms.

Drug Supply Chain Security ActDSCSA

A federal law requiring electronic tracking of prescription drug products through the supply chain from manufacturer to dispenser. Pharmacies must verify trading partner licenses and respond to drug tracing requests. Implemented in pharmacy inventory and compliance systems to ensure drug authenticity.

Drug Take-Backdrug_tkbk

A program allowing patients to return unused or expired medications to authorized collection sites for safe disposal. Supported by DEA authorized pharmacies and law enforcement. Drug take-back participation is tracked in pharmacy compliance reporting and community health programs.

PreviousPage 6 of 97Next