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

Finance

Revenue, costs, budgets, invoices and capitation

1,379 finance terms

mammogram billed amountmammo_bill_amt

The gross charge submitted to a payer or patient for a mammography screening or diagnostic breast imaging procedure. Represents the full chargemaster rate before contractual adjustments, insurance payments, or patient responsibility calculations are applied in the revenue cycle.

mammogram costmammo_cst

The internal cost incurred by a healthcare facility to perform a mammography imaging procedure, including equipment, radiology staff, and operational overhead. Used in cost accounting and financial analysis to assess profitability and resource utilization of breast imaging services.

mammogram frequencymammo_freq

The interval or cadence at which mammography screenings are ordered or performed for a patient, such as annually or biennially. Used in preventive care tracking and quality reporting to ensure compliance with evidence-based breast cancer screening guidelines for defined patient populations.

managed care contractmgd_care_cntrct

A provider agreement with a managed care organization such as an HMO, PPO, or ACO that establishes network participation terms, negotiated reimbursement rates, utilization management requirements, quality metrics, and value-based payment arrangements governing how the provider is compensated for delivering care to the managed care plan members. Managed care contracts may include fee-for-service rate schedules, capitation arrangements, bundled payment provisions, shared savings opportunities, and quality bonus incentives tied to performance on defined metrics. Contract negotiation leverage depends on provider market position, specialty type, quality reputation, and the payer network adequacy needs in the service area. Healthcare data teams support managed care contracting through analytics that calculate current reimbursement rates as a percentage of Medicare, model proposed rate changes against current volumes to project revenue impact, analyze service line profitability under different rate scenarios, and track contract performance against quality and utilization benchmarks.

material account numbermatl_acct_nbr

The unique account identifier assigned to a medical supply, device, or consumable item used in patient care. Used in supply chain and charge capture systems to track procurement, inventory usage, and billing of materials to specific patient encounters or cost centers within a healthcare facility.

material costmatl_cst

The purchase or production cost of a medical supply, device, or consumable used in clinical care delivery. Captured in supply chain and cost accounting systems to support departmental expense reporting, procedure-level costing, and margin analysis for materials consumed during patient encounters.

medical claims paidmed_clm_paid

The total dollar amount of healthcare service claims disbursed to providers or members during a defined accounting period, representing the largest expense category for health plans and the primary component of medical loss ratio calculations. Medical claims paid must be reconciled against claims adjudicated and claims payable balances to verify financial statement accuracy, and are segmented by service category, provider type, member population, and line of business for medical cost analytics and reporting.

medical claims payablemed_clm_payable

The balance sheet liability representing the estimated total amount owed to providers for healthcare services rendered to members but not yet paid, including claims in adjudication, approved but not yet disbursed payments, and IBNR reserves for incurred but unreported claims. Medical claims payable is one of the largest and most scrutinized liabilities on a health plan balance sheet, requiring actuarial sign-off and subject to regulatory reserve adequacy requirements that specify minimum reserve levels as a percentage of annual claims expense.

medical codingmed_coding

The process of translating clinical documentation of patient diagnoses, procedures, services, and supplies into standardized alphanumeric codes from established code sets including ICD-10-CM for diagnoses, ICD-10-PCS for inpatient procedures, CPT for outpatient procedures, HCPCS Level II for supplies and drugs, and revenue codes for facility billing. Medical coding is performed by certified medical coders who review clinical documentation and assign the most accurate and complete codes supported by the record. Accurate and complete coding directly affects claim payment amounts, risk adjustment scores, quality measure performance, and clinical data analytics. Undercoding results in revenue loss and understated disease burden while overcoding creates compliance risk and overpayment liability. Healthcare data teams build coding analytics that measure coder productivity and accuracy, track code distribution shifts over time, identify providers with atypical coding patterns, and support clinical documentation improvement programs that increase coding specificity.

medical cost trendmed_cost_trend

The annual percentage rate of increase in per-unit or per-member healthcare costs driven by a combination of unit price inflation from provider contract rate increases, utilization changes from population aging and disease burden shifts, and technology and drug cost inflation from new treatments and specialty medications. Medical cost trend is a primary input to premium rate setting actuarial models, and understanding trend drivers by service category is essential for health plan financial planning, rate filing, and cost management strategy.

medical expense ratiomer

The ratio of incurred medical claims to earned premium revenue for a defined period, equivalent to the claims component of the medical loss ratio before including quality improvement expenses. MER is the primary measure of underwriting profitability for health plans, with ratios below target indicating favorable claims experience and ratios above target indicating adverse experience requiring premium adjustments, utilization management intervention, or provider contract renegotiation to restore profitability.

medical loss ratio reportingmlr_rpt

The annual regulatory filing required of health insurers reporting the proportion of premium revenue spent on medical claims and quality improvement activities, required to be at least 80% for individual and small group markets and 85% for large group markets under the ACA. Health plans failing to meet MLR thresholds must issue rebates to policyholders. MLR reporting requires precise categorization of expenses into medical, quality improvement, and administrative categories using CMS-defined accounting methodologies and is subject to state insurance department audit.

medical necessitymed_nec_ind

A boolean indicator or clinical determination confirming that a healthcare service is appropriate and required for the diagnosis or treatment of illness, injury, or disease based on accepted standards of medical practice and is not primarily for the convenience of the patient or provider. Payers require medical necessity documentation to authorize coverage and payment for most non-routine healthcare services. CMS defines medical necessity for Medicare through National Coverage Determinations, Local Coverage Determinations, and coding and billing guidelines published in the Medicare Benefit Policy Manual. Services determined to lack medical necessity are denied with Claim Adjustment Reason Code 50. Healthcare data teams analyze med_nec_ind in denial analytics to quantify medical necessity denial rates by procedure type and payer, identify providers with high rates of medical necessity denials suggesting documentation or ordering pattern issues, and measure the revenue impact of clinical documentation improvement initiatives that enhance medical necessity documentation specificity.

member cost share accumulatormbr_cost_accum

A member-level tracking record maintaining the year-to-date accumulation of deductible payments, out-of-pocket costs, and cost-sharing amounts applied toward the member annual deductible and out-of-pocket maximum limits. Accurate accumulator maintenance is critical for correct cost-sharing application during claims adjudication, and accumulator synchronization errors between pharmacy benefit manager and medical plan systems are a common source of member billing disputes and regulatory complaints.

metric account numbermtr_acct_nbr

The unique account identifier linked to a specific performance or quality metric tracked within a healthcare analytics or population health system. Used to associate measured outcomes, utilization rates, or clinical indicators with the appropriate reporting entity, program, or financial account for attribution and benchmarking.

metric balancemtr_bal

The remaining or unresolved financial value associated with a tracked healthcare performance metric, such as unrealized incentive payments or outstanding pay-for-performance obligations. Used in value-based care and quality reporting systems to monitor achievement gaps against contractual targets.

metric billed amountmtr_bill_amt

The dollar amount submitted to a payer or program administrator in connection with achieving a defined healthcare quality or performance metric. Used in value-based contracting and pay-for-performance programs to document incentive claims tied to measured clinical or operational outcomes.

metric costmtr_cst

The operational or administrative expense associated with measuring, collecting, and reporting a specific healthcare performance metric. Used in quality program financial analysis to assess the cost-effectiveness of performance tracking initiatives and allocate resources across reporting and improvement activities.

metric frequencymtr_freq

The interval at which a healthcare performance or quality metric is measured and reported, such as monthly, quarterly, or annually. Used in quality management and analytics systems to schedule data collection, align reporting cycles with regulatory requirements, and monitor trend performance over time.

microbiology account numbermicro_acct_nbr

The unique account identifier associated with a microbiology laboratory order or test encounter, such as culture, sensitivity, or pathogen identification studies. Used in laboratory information systems and billing platforms to link specimen processing, results reporting, and associated charges to the correct patient account.

PreviousPage 55 of 69Next