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

prescription timestamprx_ts

The combined date and time value capturing when a medication order was written, transmitted, or processed in EHR, claims, or pharmacy dispensing systems. Used by data engineers for event sequencing, audit trail construction, and SLA monitoring across pharmacy workflows.

prescription titlerx_ttl

The formal name or label assigned to a medication order, such as the drug name, formulation, and strength designation. Used in pharmacy management and EHR systems to standardize medication identification across dispensing, billing, and clinical documentation workflows for accurate drug tracking.

prescription totalrx_tot

The aggregate monetary or quantity value associated with a medication order in PBM and pharmacy claims systems, encompassing ingredient cost, dispensing fees, and copay. Used in cost analysis, formulary modeling, and reconciliation of adjudicated versus billed pharmacy claims.

prescription total countrx_tot_cnt

The cumulative number of prescription orders associated with a patient, encounter, drug, or time period. Used in pharmacy analytics, utilization management, and population health reporting to assess medication burden, adherence patterns, polypharmacy risk, and prescribing volume trends.

prescription typerx_typ

A categorical classification of a medication order in pharmacy and PBM systems, distinguishing types such as new, refill, compound, controlled substance, or electronic. Used by data engineers to segment claims data, apply formulary rules, and support regulatory reporting across EHR and dispensing platforms.

prescription unitrx_unt

The standardized unit of measure applied to a dispensed medication quantity in pharmacy, PBM, and EHR systems, such as tablets, milliliters, or grams. Used in claims adjudication, days-supply calculations, and drug utilization review to ensure dispensing accuracy and billing compliance.

prescription updated daterx_upd_dt

The most recent date on which a medication order record was modified, including changes to dosage, directions, refill authorization, or clinical status. Used in pharmacy and EHR audit trails to track prescription lifecycle events, support compliance reviews, and maintain accurate medication history records.

prescription urgencyrx_urg

Indicates the clinical time sensitivity of a medication order, such as routine, urgent, or stat, directing dispensing prioritization and patient notification workflows. Used in pharmacy systems and EHRs to ensure time-critical medications like antibiotics or analgesics are dispensed and administered without delay.

prescription valuerx_val

A discrete data point representing a clinical, financial, or operational attribute of a medication order in pharmacy, PBM, or EHR systems. Used by data engineers to populate claims fields, support drug cost benchmarking, and enable analytics on utilization patterns across formulary tiers.

prescription versionrx_ver

Tracks the sequential revision number of a medication order record, distinguishing the original prescription from amended or updated versions. Used in pharmacy and EHR systems to maintain a complete audit history of changes, support regulatory compliance, and prevent dispensing errors from outdated order versions.

prescription ziprx_zip

The postal ZIP code associated with a medication order, typically representing the dispensing pharmacy's or patient's location. Used in pharmacy claims and drug utilization systems to support geographic analysis, network adequacy reporting, mail-order pharmacy routing, and state-level regulatory compliance tracking.

prior authorization approval ratepa_appr_rt

The percentage of pharmacy prior authorization requests that are approved upon initial review, used as a pharmacy utilization management operational metric and as an indicator of prior authorization criteria appropriateness. Low approval rates may indicate overly restrictive criteria creating unnecessary barriers to medication access while very high rates may suggest criteria are not adequately managing formulary access.

prior authorization pharmacypa_pharm

A utilization management process requiring prescribers to obtain advance approval from a health plan or pharmacy benefit manager before a non-formulary, high-cost, or restricted drug will be covered under the pharmacy benefit, used to ensure clinical appropriateness, verify step therapy compliance, and manage specialty drug costs. Pharmacy prior authorization criteria are developed by pharmacy and therapeutics committees and must be clinically based.

problem copay amountprob_cpay_amt

The fixed dollar amount a member is responsible for paying at the point of care for a visit or service tied to a documented active health problem or chronic condition. Used in claims adjudication and benefits administration systems to apply diagnosis-specific cost-sharing rules per the member's plan design.

prosthetic copay amountpros_cpay_amt

The fixed member cost-sharing amount applied to claims for prosthetic devices, such as limb prostheses or ocular prosthetics, under a health plan's durable medical equipment benefit. Used in claims adjudication to calculate patient financial responsibility based on prosthetic-specific benefit tier rules.

pulmonology copay amountpulm_cpay_amt

The fixed member cost-sharing amount applied when a patient receives specialty care services from a pulmonologist for conditions such as asthma, COPD, or pulmonary fibrosis. Used in claims adjudication systems to apply specialist-tier copay rules defined in the member's health plan benefit structure.

quantity limitqty_limit

A pharmacy benefit management restriction limiting the maximum quantity of a medication that will be covered per fill or per defined time period, used to align dispensing with FDA-approved dosing, prevent stockpiling of controlled substances, and manage costs for high-utilization medications. Quantity limits are expressed as maximum units per day, maximum units per fill, or maximum fills per period and are enforced during pharmacy claims adjudication.

questionnaire copay amountqstn_cpay_amt

The member cost-sharing amount applied to clinical services that involve structured patient questionnaires, such as depression screenings or health risk assessments billed as distinct services. Used in claims processing to determine patient financial liability based on preventive versus diagnostic service classification rules.

queue copay amountque_cpay_amt

The member cost-sharing amount associated with services or encounters held in a claims or authorization processing queue, pending adjudication or clinical review. Used in healthcare financial systems to track and apply the correct patient liability once the queued service is fully processed and adjudicated.

radiologist copay amountrad_cpay_amt

The fixed member cost-sharing amount applied to professional claims submitted by radiologists for interpretation of imaging studies such as X-rays, MRIs, or CT scans. Used in claims adjudication to apply specialist-tier copay rules separately from facility or technical component charges under the member's benefit plan.

PreviousPage 82 of 100Next