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

formulation strengthform_str

Specifies the concentration or amount of active ingredient within a drug formulation, such as milligrams per tablet or milligrams per milliliter. Used across pharmacy dispensing, prescribing, and drug database systems to ensure accurate dose selection, substitution decisions, and therapeutic equivalence determinations.

formulation subtotalform_subtot

Represents a partial sum of costs, quantities, or units associated with a drug formulation prior to applying final adjustments such as taxes, discounts, or additional fees. Used in pharmacy billing systems, drug procurement invoicing, and formulary cost analysis to support financial reporting and contract pricing validation.

formulation system identifierform_sys_id

A unique system-generated identifier assigned to a specific drug formulation record within a pharmacy or clinical data system. Used to consistently reference and track the formulation across dispensing platforms, drug databases, EHR integrations, and supply chain systems throughout its active lifecycle.

formulation targetform_tgt

Specifies the intended destination system, patient population, or therapeutic endpoint associated with a drug preparation type. Referenced in PBM and pharmacy data systems to align drug formulations with formulary tiers, clinical protocols, or specific dispensing channels.

formulation taxonomy codeform_tax_cd

A structured classification code used to categorize a drug formulation within a pharmaceutical taxonomy framework, such as drug class, therapeutic category, or dosage form hierarchy. Used in pharmacy benefit management, formulary design, and clinical drug databases to organize and retrieve formulations by standardized classification.

formulation temperatureform_temp

Records the required storage, preparation, or administration temperature for a specific drug formulation, such as refrigerated, room temperature, or body temperature ranges. Used in pharmacy storage management, cold chain compliance tracking, and compounding documentation to maintain formulation stability and patient safety.

formulation termination dateform_term_dt

The date on which a drug formulation is officially discontinued, removed from a formulary, or expired within a pharmacy or drug management system. Used in pharmaceutical lifecycle management, formulary maintenance, and drug database administration to retire outdated formulations and trigger substitution or replacement workflows.

formulation timeform_tm

Captures the specific time of day associated with a drug preparation event, such as compounding, dispensing, or administration of a formulation. Used in pharmacy management systems and EHR medication administration records to support time-sensitive clinical and operational workflows.

formulation timestampform_ts

Records the precise date and time at which a drug preparation type event occurred, such as compounding, verification, or formulary update. Used in pharmacy, PBM, and EHR audit trails to ensure traceability, regulatory compliance, and accurate medication history documentation.

formulation titleform_ttl

The official or formal name assigned to a drug formulation, which may include the drug name, strength, dosage form, and route of administration. Used in pharmacy systems, drug databases, and clinical documentation to precisely identify and communicate the formulation in prescribing, dispensing, and medication reconciliation workflows.

formulation totalform_tot

Represents the aggregate sum of a measured attribute associated with a drug preparation type, such as total quantity dispensed, total doses per formulation batch, or total cost. Used in pharmacy and PBM reporting systems to support utilization analysis and formulary cost management.

formulation total countform_tot_cnt

The total number of distinct drug formulation records within a pharmacy or medication management system. Used in pharmaceutical data analysis to quantify the variety of preparation types such as tablets, capsules, liquids, and injectables tracked across a formulary or drug database.

formulation typeform_typ

Classifies a drug preparation into a standardized category such as tablet, capsule, suspension, injectable, patch, or inhaler. Used in EHR, pharmacy, and PBM systems to drive dispensing logic, formulary tier assignment, clinical decision support rules, and drug interaction screening.

formulation updated dateform_upd_dt

The most recent date on which a drug formulation record was modified in the pharmacy or clinical data system. Used in pharmaceutical data governance to track changes to preparation type specifications, dosage instructions, or ingredient compositions and ensure formulary accuracy.

formulation urgencyform_urg

A coded value indicating the time sensitivity or priority level assigned to a drug formulation request or compounding order. Used in pharmacy operations to triage preparation workflows, distinguishing routine formulations from urgent or emergent medication preparation needs requiring expedited processing.

formulation valueform_val

Stores a specific measured data point associated with a drug preparation type, such as strength, concentration, volume, or potency. Referenced in pharmacy, EHR, and PBM systems to support accurate drug dispensing, dose calculation, clinical decision support, and claims adjudication.

formulation versionform_ver

A sequential numeric or alphanumeric identifier that tracks the iteration of a drug formulation record through its lifecycle of updates. Used in pharmacy data systems to maintain audit trails, support regulatory compliance, and distinguish current preparation specifications from prior versions in the formulary.

formulation zipform_zip

The postal code associated with the pharmacy, compounding facility, or dispensing location responsible for a specific drug formulation. Used in pharmacy logistics and geographic reporting to identify regional preparation sources and support drug distribution network analysis across coverage areas.

frequency copay amountfreq_cpay_amt

The fixed out-of-pocket dollar amount a member owes per visit or service based on how often a specific benefit type is accessed within a defined period. Used in health plan benefit administration to apply cost-sharing rules tied to administration frequency schedules, such as daily, weekly, or monthly service intervals.

gastroenterology copay amountgi_cpay_amt

The fixed out-of-pocket dollar amount a health plan member is required to pay at the time of a gastroenterology service, including visits for digestive system conditions such as colonoscopies, endoscopies, or GI specialist consultations. Applied during claims adjudication based on the member's benefit plan design.

PreviousPage 53 of 100Next