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,921 pharmacy terms

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.

geriatric copay amountger_cpay_amt

The fixed out-of-pocket dollar amount a health plan member owes per geriatric care encounter, including comprehensive geriatric assessments, elder care consultations, and age-related chronic condition management visits. Applied during claims adjudication per the member's specific benefit plan cost-sharing structure.

group copay amountgrp_cpay_amt

The fixed out-of-pocket dollar amount a health plan member must pay per service encounter under a specific group benefit plan, such as an employer-sponsored or union group contract. Applied during claims adjudication to reflect the cost-sharing terms negotiated at the group contract level for the member's enrolled plan.

guarantor copay amountguar_cpay_amt

The fixed out-of-pocket dollar amount owed by the financially responsible party designated on a patient account, who may or may not be the patient themselves. Used in patient financial services and billing systems to correctly assign and collect cost-sharing obligations from the individual legally responsible for the account balance.

guideline copay amountgdln_cpay_amt

The fixed out-of-pocket dollar amount assigned to services or treatments rendered in accordance with established clinical practice guidelines. Used in health plan benefit design to apply differentiated cost-sharing that incentivizes members to receive evidence-based, guideline-compliant care as defined within the plan's clinical policy framework.

hcpcs copay amounthcpcs_cpay_amt

The fixed out-of-pocket dollar amount a health plan member owes for a service or supply billed under a specific Healthcare Common Procedure Coding System code. Applied during claims adjudication to assign member cost-sharing based on the HCPCS Level I CPT or Level II code reported on the medical or durable medical equipment claim.

implant copay amountimpl_cpay_amt

The fixed out-of-pocket dollar amount a health plan member owes for a procedure involving a surgically placed medical device, such as a pacemaker, cochlear implant, or joint prosthesis. Applied during claims adjudication based on the implant-specific benefit tier defined within the member's health plan cost-sharing structure.

indicator copay amountind_cpay_amt

The fixed out-of-pocket dollar amount associated with services flagged by a specific quality or utilization indicator within a health plan's benefit or care management program. Used in value-based benefit design to track and apply cost-sharing rules to services identified through clinical quality measurement criteria.

instrument copay amountinst_cpay_amt

The fixed out-of-pocket dollar amount a health plan member is responsible for when a medical instrument or diagnostic device is used during a covered procedure or examination. Applied during claims adjudication to reflect cost-sharing obligations tied to instrument-based services within the member's benefit plan.

insurer copay amountins_cpay_amt

The fixed out-of-pocket dollar amount assigned to a health plan member based on the specific insurance carrier or plan type through which their coverage is administered. Used in claims adjudication and benefit configuration to apply carrier-specific cost-sharing rules that reflect contractual terms between the insurer and the health plan.

intervention copay amountintv_cpay_amt

The fixed out-of-pocket dollar amount a health plan member owes for a specific clinical intervention such as a therapeutic procedure, preventive treatment, or disease management service. Applied during claims adjudication to enforce cost-sharing obligations tied to intervention type as defined in the member's benefit plan structure.

intolerance copay amountintol_cpay_amt

The fixed out-of-pocket dollar amount a health plan member is required to pay for services related to the diagnosis or management of a documented food, drug, or environmental intolerance. Applied during claims adjudication when the encounter or prescription is associated with a non-allergic adverse response condition on the member's health record.

PreviousPage 52 of 97Next