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

Operations

Scheduling, facilities, departments, workflows, and staff

6,492 operations terms

location ziploc_zip

The five or nine digit postal ZIP code associated with a physical healthcare service site. Used in geographic analysis, claims processing, network adequacy assessments, and population health reporting to identify service area coverage and assign regional classifications to facility records.

mail order dispensing flagmail_ord_disp_flg

A flag indicating that a prescription was dispensed through a mail-order pharmacy rather than a retail pharmacy, used in pharmacy operations analytics to track mail-order utilization rates, measure adherence to health plan mail-order incentive programs, and compare medication adherence outcomes between mail-order and retail dispensing channels.

mammogram addressmammo_addr

The full physical address of the facility where a mammogram screening or diagnostic breast imaging procedure was performed or is scheduled. Used in care coordination, radiology referral tracking, and quality reporting to link breast imaging events to specific service locations.

mammogram approval statusmammo_appr_sts

Indicates the prior authorization or clinical approval state of a mammogram service, such as pending, approved, or denied. Used in utilization management workflows to track whether the breast imaging procedure has received required payer or clinical authorization before or after service delivery.

mammogram charge amountmammo_chrg_amt

The billed charge amount associated with a mammogram screening or diagnostic breast imaging procedure. Captured during claims processing or encounter documentation to support billing reconciliation, cost analysis, and reimbursement calculations under applicable fee schedules or contracted rates.

mammogram effective datemammo_eff_dt

The date on which a mammogram order, authorization, or benefit coverage for breast imaging becomes active and clinically valid. Used in care management and claims adjudication to confirm that the service falls within an authorized period and aligns with screening interval guidelines.

mammogram group numbermammo_grp_nbr

The insurance group identifier associated with a member's coverage at the time a mammogram service was rendered or authorized. Links the breast imaging event to a specific employer group or plan contract for claims adjudication, benefit coordination, and population-level HEDIS reporting.

mammogram medical record numbermammo_mrn

The unique patient medical record number assigned by a healthcare facility that identifies the individual associated with a mammogram encounter. Used to link breast imaging results, orders, and claims data back to the correct patient record across radiology and clinical information systems.

mammogram scheduled datemammo_sched_dt

The calendar date on which a mammogram screening or diagnostic breast imaging appointment is planned to occur. Used in care gap closure workflows, patient outreach programs, and HEDIS measure tracking to monitor whether members have scheduled required preventive breast imaging services.

mammogram scheduled timemammo_sched_tm

The specific clock time at which a mammogram appointment is scheduled at a radiology or breast imaging facility. Used alongside the scheduled date in appointment management systems to coordinate patient flow, staffing, and equipment availability for breast imaging services.

mammogram street addressmammo_st_addr

The street-level address line of the facility where a mammogram procedure is scheduled or was performed. Used in patient appointment communications, facility directory lookups, and geographic analysis to identify the exact service site for breast imaging encounters.

mammogram unitmammo_unt

The unit of measure or single service instance associated with a mammogram procedure, such as one bilateral screening study. Used in claims processing and utilization reporting to quantify the volume of breast imaging services rendered and support accurate billing under applicable procedure codes.

material scheduled datematl_sched_dt

The planned date on which a medical supply, device, or clinical material is scheduled for delivery, preparation, or use in a patient care setting. Used in supply chain management and care coordination workflows to align material availability with scheduled procedures or treatment events.

material scheduled timematl_sched_tm

The specific clock time at which a medical supply, device, or clinical material is scheduled for delivery or deployment in support of a patient care procedure. Used in perioperative and supply chain workflows to ensure materials are available at the point of care when needed.

material unitmatl_unt

The unit of measure assigned to a medical supply or clinical material item, such as each, box, or milliliter. Used in inventory management, procurement, and claims processing to quantify consumption, calculate costs, and maintain accurate stock levels across healthcare facilities and departments.

medication therapy management eligibility flagmtm_elig_flg

A flag identifying a Medicare Part D member who qualifies for medication therapy management services based on having multiple chronic conditions, taking multiple Part D drugs, and being likely to incur annual drug costs above a CMS threshold. MTM eligible members are entitled to comprehensive medication reviews and targeted medication reviews from a pharmacist or other qualified provider.

metric addressmtr_addr

The physical or logical address associated with the source system or reporting entity from which a quantified healthcare performance metric is derived. Used in data governance and analytics to identify where metric data originates, supporting traceability and validation across quality reporting programs.

metric approval statusmtr_appr_sts

Indicates the review and approval state of a healthcare performance metric, such as draft, approved, or retired. Used in quality program governance to track whether a metric definition has completed the required validation and endorsement process before being used in clinical or operational reporting.

metric charge amountmtr_chrg_amt

The financial charge value associated with the collection, calculation, or reporting of a specific healthcare performance metric. Used in program cost accounting and vendor contract management to capture expenses tied to quality measurement activities, including data submission fees or analytics platform charges.

metric effective datemtr_eff_dt

The date on which a quantified performance metric becomes active and valid for measurement and reporting purposes. Used in quality management systems to establish the temporal boundary for when a specific performance indicator begins contributing to analytics, benchmarking, or compliance tracking.

PreviousPage 147 of 325Next