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

refill descriptionrfll_desc

Provides a textual explanation of the prescription refill type, status, or characteristics in PBM, pharmacy, and EHR systems. Data engineers use this field to enhance data lineage documentation, support code-to-description mapping in reference tables, and improve interpretability of refill classification codes in analytics pipelines.

refill detailrfll_dtl

Contains granular information about a specific prescription refill transaction in PBM, pharmacy, and claims systems, including dispensing specifics, override reasons, or adjudication notes. Data engineers use this field to support detailed claims audits, resolve adjudication exceptions, and enrich refill records in analytical data models.

refill due daterfll_due_dt

The projected date by which a patient is expected to require their next prescription refill based on days supply dispensed and fill date. Used by pharmacy systems to trigger automated refill reminders, proactive outreach programs, and medication adherence monitoring workflows.

refill durationrfll_dur

The number of days a dispensed prescription refill supply is intended to last the patient, as determined by the prescribed dosage and quantity dispensed. Used to calculate next refill due dates, assess medication adherence, and evaluate days supply adequacy for the prescribed regimen.

refill effective daterfll_eff_dt

Indicates the date on which a prescription refill authorization or coverage becomes active in PBM, pharmacy benefit, and member enrollment systems. Data engineers use this field to validate refill eligibility windows, enforce formulary effective dates, and align pharmacy claims records with benefit plan coverage periods.

refill emailrfll_eml

Stores the electronic mail address associated with a prescription refill request or notification in pharmacy and PBM systems. Data engineers use this field to support digital refill reminder workflows, validate member contact information against enrollment records, and track communication channel usage in pharmacy engagement analytics pipelines.

refill end daterfll_end_dt

Captures the date on which a prescription refill authorization or coverage period concludes in PBM, pharmacy, and benefit management systems. Data engineers use this field to enforce refill expiration logic, close out open refill records, and validate that dispensing activity does not extend beyond authorized prescription periods.

refill end timerfll_end_tm

The timestamp marking when a prescription refill dispensing activity was completed. Used in pharmacy systems to track workflow duration, measure dispensing turnaround times, and ensure medication was prepared and released within required service windows.

refill entered byrfll_ent_by

The user identifier of the pharmacy staff member or clinician who entered the prescription refill request into the system. Used in pharmacy workflow auditing, accountability tracking, and identifying the data entry source for refill transactions in dispensing and claims records.

refill ethnicityrfll_ethn

The patient's ethnic background as recorded at the time of a prescription refill transaction. Captured in pharmacy systems to support health equity reporting, population health analytics, and identifying medication adherence or access disparities across ethnic groups.

refill expiration daterfll_exp_dt

Records the date after which a prescription refill is no longer valid for dispensing in pharmacy, PBM, and EHR systems. Data engineers use this field to enforce refill cutoff logic during adjudication, flag expired prescription attempts, and support regulatory compliance reporting around controlled substance dispensing timelines.

refill external identifierrfll_ext_id

A unique reference number assigned by an external system, such as a pharmacy benefits manager or trading partner, to identify a prescription refill transaction. Enables cross-system reconciliation of refill records between dispensing platforms, PBM systems, and payer adjudication systems.

refill faxrfll_fax

The facsimile number associated with a prescription refill transaction, typically belonging to the prescribing provider or receiving pharmacy. Used in pharmacy workflows to route refill authorizations, prior authorization requests, and refill approval confirmations between care sites.

refill feerfll_fee

The monetary charge applied to a prescription refill, which may include dispensing fees, copayments, or administrative costs. Used in pharmacy billing and claims adjudication to calculate patient cost-sharing and reconcile reimbursement amounts from payers and pharmacy benefit managers.

refill first namerfll_first_nm

The given name of the patient or individual associated with a prescription refill record. Used in pharmacy dispensing systems to verify patient identity at point of pickup, match refill requests to member enrollment records, and ensure accurate medication dispensing.

refill flagrfll_flg

A binary indicator field in PBM, pharmacy, and claims systems that marks whether a prescription transaction represents a refill versus a new fill. Data engineers use this field to segment dispensing records, filter adherence cohorts, apply differential adjudication rules, and distinguish initial versus subsequent fill events in analytics pipelines.

refill frequencyrfll_freq

The prescribed administration schedule for a medication being refilled, such as once daily or every eight hours. Captured in pharmacy dispensing systems to validate that refill quantities align with the prescribed dosing regimen and to detect early or excessive refill patterns.

refill full namerfll_full_nm

The complete name of the patient associated with a prescription refill, combining first, middle, and last name components. Used in pharmacy systems for patient identity verification at dispensing, matching refill records to member enrollment data, and audit documentation.

refill genderrfll_gndr

The patient's sex or gender identity as recorded at the time of a prescription refill transaction. Used in pharmacy and clinical data systems to support clinical appropriateness reviews, drug utilization analysis, and health equity reporting across medication dispensing populations.

refill glucoserfll_gluc

The blood sugar level for a prescription renewal. 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 refill management and reporting.

PreviousPage 93 of 100Next