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

drug emergency indicatordrg_emerg_ind

Flag identifying whether a drug order or prescription was initiated under emergency circumstances. Used in pharmacy and clinical systems to track urgent medication dispensing events, support regulatory reporting, and distinguish emergency drug administrations from routine therapeutic orders.

drug end datedrg_end_dt

The date a drug record, prescription, or formulary listing becomes inactive in pharmacy, PBM, or EHR systems. Used in claims adjudication and formulary management to determine coverage eligibility, discontinuation of therapy, and to prevent erroneous drug benefit processing past authorized treatment periods.

drug end timedrg_end_tm

The timestamp recording when a drug administration, infusion, or course of therapy was completed. Used in inpatient clinical systems and pharmacy dispensing records to calculate total administration duration, support medication reconciliation, and audit drug exposure windows.

drug enrollment statusdrg_enrl_sts

Indicates whether a patient is actively enrolled in a drug therapy program, specialty pharmacy program, or medication assistance program. Used in pharmacy benefit management and specialty drug tracking to monitor patient participation status and program eligibility over time.

drug entered bydrg_ent_by

Identifies the user, clinician, or system that entered a drug order, prescription, or medication record into the clinical or pharmacy system. Used in audit trails and medication management workflows to establish accountability and support error investigation in drug ordering processes.

drug ethnicitydrg_ethn

Records the ethnicity of the patient associated with a drug order or medication record. Used in pharmacogenomics research and population health analytics to identify ethnic-based variations in drug metabolism, treatment response, and adverse event rates across patient populations.

drug expiration datedrg_exp_dt

The manufacturer-assigned date after which a drug is no longer guaranteed safe or effective, stored in pharmacy dispensing, PBM, and EHR systems. Critical for claims adjudication, dispensing validation, and regulatory compliance to prevent dispensing of expired medications to plan members.

drug external identifierdrg_ext_id

A reference identifier assigned to a drug record by an external system, such as a pharmacy benefit manager, drug database vendor, or trading partner. Used to cross-reference and reconcile drug records across disparate healthcare and pharmacy systems during data integration workflows.

drug faxdrg_fax

The facsimile number associated with the pharmacy or prescribing location transmitting drug orders or prescription records. Used in pharmacy workflow systems to route electronic and paper prescription transmissions and maintain contact records for prescription verification follow-up.

drug feedrg_fee

The charge assessed for dispensing or administering a specific drug, distinct from the ingredient cost. Used in pharmacy billing, claims adjudication, and pharmacy benefit management to calculate total drug claim amounts and reconcile dispensing fees against contracted pharmacy reimbursement schedules.

drug first namedrg_first_nm

Captures the first name of a patient or contact person associated with a drug record or prescription. Used in pharmacy management systems to link medication records to patient demographic profiles and support prescription verification, outreach, and medication therapy management workflows.

drug flagdrg_flg

Boolean indicator applied to a drug record in claims processing systems to signal special handling requirements such as prior authorization, step therapy, formulary exclusion, or specialty drug status. Used by data engineers to filter, route, and apply adjudication rules across downstream PBM and EHR analytics pipelines.

drug formularydrug_frmly

A list of prescription drugs covered under a health plan pharmacy benefit, organized by therapeutic class and formulary tier, used by prescribers, pharmacists, and members to determine coverage status and cost-sharing for specific medications. Formularies are developed and maintained by pharmacy and therapeutics committees based on clinical evidence, safety profiles, and cost-effectiveness analysis, and are updated quarterly with changes requiring member and provider notification.

drug formulary managementfrmly_mgmt

The systematic processes of developing, maintaining, and optimizing a health plan drug formulary including evaluating new drug applications for formulary inclusion, determining tier placement based on clinical and economic criteria, negotiating manufacturer rebates for preferred placement, implementing utilization management policies, monitoring formulary performance, and communicating formulary changes to members and prescribers.

drug formulary updatefrmly_update

A scheduled or off-cycle change to a health plan drug formulary including additions of new drugs, removals of discontinued drugs, tier changes for existing drugs, and modifications to utilization management requirements, requiring advance notification to affected members and prescribers per CMS and state regulatory requirements. Mid-year formulary changes that increase member cost-sharing or restrict access are generally prohibited except for safety reasons.

drug frequencydrg_freq

Specifies the prescribed dosing interval for a medication, such as once daily or every eight hours. Used in pharmacy dispensing systems, medication administration records, and clinical decision support to ensure proper drug scheduling, calculate days supply, and generate medication adherence alerts.

drug full namedrg_full_nm

The complete descriptive name of a drug, typically including brand or generic name, strength, and dosage form. Used in pharmacy systems, claims processing, and formulary management to uniquely identify a medication for dispensing, billing, and drug utilization review purposes.

drug genderdrg_gndr

Records the biological sex of the patient associated with a drug order or prescription record. Used in clinical pharmacy systems and drug utilization analytics to apply gender-specific dosing guidelines, identify contraindicated medications, and support sex-stratified pharmacoepidemiology reporting.

drug generic equivalentdrug_gen_equiv

A pharmaceutical product containing the same active ingredient, strength, dosage form, and route of administration as a brand-name drug and demonstrated by the FDA to be bioequivalent, meaning it is absorbed at the same rate and to the same extent as the reference drug. Generic equivalents are assigned the same generic product identifier as the brand reference product and are subject to automatic substitution under state pharmacy laws.

drug glucosedrg_gluc

Records a patient's blood glucose measurement in the context of a drug record, relevant for medications such as insulin or antidiabetics. Used in clinical pharmacy and chronic disease management systems to monitor glucose response, guide dose adjustments, and support medication therapy management.

PreviousPage 40 of 100Next