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

dispense entered bydisp_ent_by

Identifies the pharmacist, pharmacy technician, or system user who entered the dispense record into the pharmacy management system. Used for pharmacy audit trails, quality assurance reviews, and regulatory compliance documentation to establish accountability for each dispensing transaction.

dispense ethnicitydisp_ethn

Records the patient's self-reported ethnicity associated with a pharmacy dispense event, captured to support health equity analysis and population health reporting. Used in pharmacy and PBM analytics to identify disparities in medication access, adherence rates, and therapeutic outcomes across demographic groups.

dispense expiration datedisp_exp_dt

The manufacturer-assigned or pharmacy-calculated date after which a dispensed medication should not be used, based on drug stability and storage conditions. Recorded in pharmacy dispensing systems to ensure patient safety, support medication disposal programs, and meet regulatory labeling requirements for dispensed prescriptions.

dispense external identifierdisp_ext_id

A unique reference number assigned by an external system, such as a PBM, clearinghouse, or trading partner, to identify a pharmacy dispense transaction across interconnected healthcare systems. Used to reconcile dispense records between pharmacy management platforms, adjudication systems, and claims data warehouses.

dispense faxdisp_fax

The facsimile number used to transmit prescription orders or dispense-related communications between prescribers, pharmacies, or pharmacy benefit administrators. Captured in pharmacy management systems to document the originating transmission channel and support electronic prescription audit trail requirements.

dispense feedisp_fee

The professional fee charged by a dispensing pharmacy for processing and filling a prescription, separate from the drug ingredient cost. Used in pharmacy claims adjudication and reimbursement calculations within PBM systems to determine total claim cost, plan liability, and pharmacy network contract compliance.

dispense first namedisp_first_nm

The given name of the patient for whom a medication was dispensed, used to verify patient identity at point of dispensing and ensure accurate medication attribution. Critical in pharmacy management systems for preventing dispensing errors, supporting patient matching across records, and maintaining accurate prescription histories.

dispense flagdisp_flg

A binary indicator applied to a pharmacy dispense record to denote a specific condition or processing status, such as prior authorization required, formulary exception, or controlled substance alert. Used in pharmacy claims adjudication and clinical review workflows to route transactions requiring additional pharmacist or clinical review.

dispense frequencydisp_freq

The prescribed administration schedule for a dispensed medication, indicating how often the patient should take each dose, such as twice daily or every eight hours. Captured in pharmacy dispensing systems to generate accurate patient medication labels, calculate appropriate days supply, and support medication therapy management programs.

dispense full namedisp_full_nm

The complete name of the dispensing pharmacist or pharmacy associated with a medication distribution event. Captures the full name as recorded on the pharmacy claim or dispensing record, used for audit trails and dispensing accountability in pharmacy benefit management systems.

dispense genderdisp_gndr

The biological sex or gender identity of the patient associated with a pharmacy dispensing event. Used in pharmacy benefit management and drug utilization review to validate gender-specific medication appropriateness, dosing guidelines, and clinical safety edits on pharmacy claims.

dispense glucosedisp_gluc

The blood sugar level for a medication distribution. 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 dispense management and reporting.

dispense group numberdisp_grp_nbr

The insurance group plan identifier associated with the patient at the time a medication was dispensed. Links the pharmacy dispensing event to the correct employer group or benefit plan for adjudication, coordination of benefits, and pharmacy claims processing in pharmacy benefit management systems.

dispense hemoglobindisp_hgb

The blood hemoglobin level for a medication distribution. 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 dispense management and reporting.

dispense history present illnessdisp_hpi

The clinical narrative describing the patient's current medical condition or chief complaint that prompted the medication dispensing event. Captured in pharmacy or clinical records to provide context for drug therapy decisions, medication reconciliation, and clinical appropriateness review.

dispense identifierdisp_id

The unique system-generated or source-assigned identifier for a specific pharmacy dispensing transaction. Used as the primary key to track, link, and reconcile individual medication dispenses across pharmacy systems, claims adjudication platforms, and clinical data repositories.

dispense indexdisp_idx

A sequential or ordinal position number assigned to a medication dispensing event within a series, such as a fill sequence for a recurring prescription. Used in pharmacy data systems to track refill history, dispensing order, and medication adherence patterns across multiple fills.

dispense indicatordisp_ind

A flag or boolean value that denotes a specific condition or status related to a pharmacy dispensing event, such as whether a generic was substituted, a dispense was reversed, or a prior authorization was obtained. Used in pharmacy claims processing and drug utilization management.

dispense instructiondisp_instr

The patient-facing or pharmacist-facing directions associated with a dispensed medication, including dosing frequency, administration route, and special handling requirements. Captured on pharmacy dispensing records to support medication safety, patient counseling, and adherence monitoring.

dispense keydisp_key

A surrogate or natural key value used to uniquely reference a pharmacy dispensing record within a data warehouse or pharmacy information system. Enables efficient joins, lookups, and data integration across pharmacy claims, clinical, and member enrollment datasets.

PreviousPage 32 of 100Next