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

microbiology costmicro_cst

The internal laboratory cost incurred to perform microbiology testing, including culture media, reagents, technician labor, and equipment usage. Used in lab cost accounting to evaluate the financial performance of microbiology services and support charge capture and pricing decisions for pathogen identification procedures.

minimum fee schedulemin_fee_sched

The lowest reimbursement rate that a health plan will pay to a provider for a specific service regardless of the provider contract terms, typically set as a floor based on a percentage of Medicare fee schedule rates to prevent extremely low payments that could be considered inadequate compensation or create access issues. Minimum fee schedules are used in provider contract management to establish payment floors below which contract rates will not fall during negotiation or as a result of fee schedule updates.

modifier codemod_cd

A two-digit alphanumeric code appended to a CPT or HCPCS procedure code on a healthcare claim to provide additional information about the circumstances of the service without changing the definition of the code itself. Modifiers communicate important billing information including that a service was performed bilaterally, that multiple procedures were performed during the same session, that only part of a service was performed, that a service was performed by a different provider than the billing provider, or that a service was performed in a distinct encounter from other same-day services. Common modifiers include 25 for significant separately identifiable evaluation and management service, 51 for multiple procedures, 59 for distinct procedural service, and RT and LT for right and left side identification. Healthcare data teams analyze modifier usage patterns in claims data to detect potentially improper modifier application that inflates payment, validate modifier combinations against CCI edits, and identify providers with outlier modifier rates requiring compliance review.

morbidity account numbermorb_acct_nbr

The unique account identifier linked to a morbidity record, condition tracking entry, or disease burden measure within a population health or epidemiological data system. Used to associate diagnosed conditions, complication rates, or chronic disease prevalence data with the correct patient or reporting cohort for analysis.

morbidity costmorb_cst

The total dollar amount of healthcare expenditures attributed to a specific disease or condition within a population. Used in actuarial and population health analytics to quantify the financial burden of illness, support risk adjustment modeling, and inform benefit design decisions.

mortality account numbermort_acct_nbr

The unique numeric identifier assigned to a mortality-related record or event within a claims or population health system. Used to track death-related encounters, link mortality events to member records, and support actuarial analysis of death rates across insured populations.

mortality costmort_cst

The total dollar amount of healthcare expenditures associated with end-of-life care, death-related claims, or mortality events within an insured population. Used in actuarial modeling and population health analytics to quantify financial exposure related to member death rates.

mri account numbermri_acct_nbr

The unique numeric identifier assigned to a magnetic resonance imaging service event within a claims or utilization management system. Used to track MRI utilization across members, link imaging claims to episodes of care, and support radiology cost and frequency analysis.

mri costmri_cst

The total dollar amount paid or incurred for magnetic resonance imaging services across claims. Used in utilization management and medical cost analytics to assess radiology spend, benchmark MRI pricing against contracted rates, and identify high-cost imaging utilization patterns.

national coverage determinationncd_cd

A formal CMS decision that defines whether a specific medical item, service, treatment, or technology is covered under Medicare nationwide, establishing the evidence-based criteria under which Medicare will pay for the service across all Medicare Administrative Contractor jurisdictions. NCDs are developed through a formal evidence review process and published in the Medicare Coverage Database, representing the highest level of Medicare coverage policy. NCDs may establish coverage with evidence development requirements for emerging technologies, specify covered indications, or determine that a service is not covered by Medicare. Healthcare data teams maintain NCD reference tables linked to HCPCS and CPT procedure codes, incorporate NCD criteria into pre-billing claim editing workflows to validate covered indications before submission, track NCD-related denial rates in claims analytics, and monitor CMS NCD updates that may affect coverage policies for services billed by the organization.

nephrology account numberneph_acct_nbr

The unique numeric identifier assigned to a nephrology specialty care event within a claims or care management system. Used to track kidney-related specialist encounters, link nephrology claims to chronic kidney disease or renal failure episodes, and support specialty cost reporting.

nephrology costneph_cst

The total dollar amount paid or incurred for nephrology specialty services, including kidney disease management, dialysis coordination, and renal specialist visits. Used in medical cost analytics to monitor spending trends for members with chronic kidney disease or end-stage renal disease.

net collection ratenet_coll_rt

A key revenue cycle performance metric measuring the percentage of net collectible revenue actually collected by a healthcare organization, calculated by dividing collections by net charges after subtracting contractual adjustments. Net collection rate measures how effectively a revenue cycle captures the revenue it is entitled to receive and is considered one of the most important indicators of overall revenue cycle performance. A net collection rate of 96 percent or above is generally considered best practice, meaning the organization collects 96 cents of every dollar it is contractually owed. Lower net collection rates indicate revenue leakage from uncollected patient balances, unresolved denials, missed filing deadlines, or ineffective collection processes. Healthcare data teams calculate net_coll_rt at the organization, payer, service line, and facility level to benchmark performance against industry standards, identify revenue cycle improvement priorities, and measure the financial impact of revenue cycle optimization initiatives over time.

net incomenet_inc

The total profit or loss of a health plan after deducting all operating expenses including medical claims, administrative costs, and quality improvement programs from total revenues including premium revenue, investment income, and other income, and after accounting for income taxes. Net income is the bottom-line financial performance metric for health plan reporting to shareholders, regulators, and rating agencies, and is used to assess long-term financial sustainability and the ability to build surplus capital reserves.

net revenuenet_rev_amt

The actual amount of revenue a healthcare organization expects to collect for services rendered after deducting contractual adjustments, charity care write-offs, and bad debt allowances from gross patient service revenue. Net revenue represents the realistic revenue amount that will be collected in cash and is the primary revenue metric used in healthcare financial reporting, budgeting, and performance management. The difference between gross revenue and net revenue is substantial in healthcare — large health systems may have gross-to-net ratios where they collect only 25 to 40 cents of every dollar of billed charges due to contractual adjustments. Healthcare data teams calculate net_rev_amt by applying expected reimbursement rates from each payer contract to the mix of services delivered, tracking actual collections against net revenue expectations, analyzing gross-to-net ratios by payer and service line, and producing net revenue forecasts used in financial planning, capital budgeting, and strategic decision-making.

network adequacy penaltynetwrk_penalty

A financial sanction imposed by CMS or state regulators on health plans that fail to meet network adequacy standards requiring sufficient provider availability within defined geographic distance and appointment wait time standards for various provider types and specialties. Network adequacy penalties may include fines, enrollment freezes, required network expansion, and in severe cases plan termination. CMS publishes network adequacy requirements for Medicare Advantage and ACA marketplace plans with annual compliance monitoring.

network discountnetwrk_disc

The percentage reduction from provider billed charges achieved through health plan contracted rates with in-network providers, representing the negotiating power of the health plan network relative to provider chargemaster prices. Network discounts vary significantly by geography, provider type, and health plan market share, with larger health plans able to negotiate larger discounts. Network discount analytics compare contracted allowed amounts against billed charges across provider types to assess contracting effectiveness and identify renegotiation opportunities.

neurology account numberneuro_acct_nbr

The unique numeric identifier assigned to a neurology specialty care event within a claims or care management system. Used to track nervous system disorder encounters, link neurology claims to conditions such as epilepsy, multiple sclerosis, or stroke, and support specialty utilization reporting.

neurology costneuro_cst

The total dollar amount paid or incurred for neurology specialty services, including diagnosis and treatment of brain, spinal cord, and peripheral nerve disorders. Used in medical cost analytics to monitor spending for high-cost neurological conditions and evaluate specialist utilization trends.

note account numbernt_acct_nbr

The unique numeric identifier assigned to a clinical documentation entry or note-related service event within a healthcare data system. Used to link narrative clinical documentation to specific encounters, episodes of care, or billing records for audit, compliance, and care coordination purposes.

PreviousPage 56 of 69Next