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

cardiology account numbercard_acct_nbr

A unique identifier assigned to a cardiology department or service line account within healthcare financial or billing systems. Used to track charges, costs, and reimbursements specific to cardiac care services such as echocardiography, catheterization, and electrophysiology for cost center reporting and revenue analysis.

cardiology costcard_cst

The total expenses incurred in delivering cardiology services, including physician fees, diagnostic testing, interventional procedures, and device costs. Used in healthcare financial systems to monitor cardiac service line profitability, benchmark against reimbursement rates, and support cardiovascular program budgeting and resource planning.

carrier account numbercarr_acct_nbr

A unique identifier assigned to a health insurance carrier or payer within claims processing and enrollment systems. Used to link member eligibility, premium payments, and claim submissions to a specific insurer, enabling accurate remittance reconciliation and payer contract management across billing platforms.

carrier costcarr_cst

The total cost attributed to a specific health insurance carrier, including administrative fees, claims paid, and capitation payments. Used in financial and actuarial systems to evaluate payer contract performance, analyze per-member cost trends, and support negotiations with commercial, Medicare, or Medicaid carriers.

case mix indexcmi

A numeric measure of the relative clinical complexity and resource intensity of a hospital inpatient population, calculated as the average Medicare Severity Diagnosis Related Group weight across all discharges during a measurement period. The case mix index reflects the severity of illness and treatment complexity of patients treated by a hospital — a higher CMI indicates a more complex patient population requiring greater resources and generating higher Medicare reimbursement per case. CMS publishes annual case mix index values for all Medicare-participating hospitals. CMI is used in financial planning to project inpatient revenue, in staffing analysis to justify nurse-to-patient ratios for complex patients, and in benchmarking to compare resource intensity across hospitals. Healthcare data teams calculate CMI by multiplying each discharge DRG weight by the case count, summing the weighted values, and dividing by total discharges, tracking CMI trends over time to identify clinical documentation improvement opportunities and measure the financial impact of coding specificity initiatives.

case ratecase_rt

A fixed payment amount for a complete episode of care defined by a diagnosis or procedure, encompassing all services related to the episode regardless of the number of visits, procedures, or days involved. Case rates are used in bundled payment arrangements for defined surgical procedures such as joint replacements and cardiac surgery, and create financial incentives for providers to deliver efficient, coordinated care within the episode without ordering unnecessary services that increase costs above the fixed case payment.

cash collection ratecash_coll_rt

The percentage of billed charges that a healthcare organization actually collects as cash receipts during a specific time period, representing the real-world cash conversion efficiency of the revenue cycle. Cash collection rate differs from net collection rate in that it measures actual cash receipts against gross charges rather than against net collectible revenue after contractual adjustments. Cash collection rate is used in short-term cash flow management and forecasting, helping healthcare organizations project actual cash receipts from current billing activity. Industry average cash collection rates vary significantly by payer mix and provider type, typically ranging from 20 to 40 percent of gross charges when contractual adjustments are considered. Healthcare data teams calculate cash_coll_rt by period, payer category, and service line to support treasury management cash flow forecasting, evaluate collection trend changes that may signal revenue cycle performance shifts, and model cash receipt projections under different payer mix and volume scenarios.

catastrophic claimcatas_clm

A healthcare claim or series of related claims for a single member that exceeds a defined high-cost threshold, typically $100,000 or more, associated with complex medical conditions such as premature neonates, cancer treatments, major trauma, or organ transplants. Catastrophic claims have disproportionate impact on small group or self-insured plan financials, driving stop-loss insurance adoption, and are analyzed separately in actuarial models because their low frequency and high severity make them statistically volatile and difficult to predict using standard trend methodologies.

charge account numberchrg_acct_nbr

A unique identifier linking a billable service charge to a specific patient account or cost center within the hospital chargemaster or billing system. Used in revenue cycle management to associate individual procedure and supply charges with encounters, supporting claim generation, charge capture audits, and accounts receivable tracking.

charge capturechrg_capt

The process of accurately recording all billable healthcare services, supplies, and procedures delivered to a patient during a clinical encounter to ensure complete and compliant claim submission. Effective charge capture is the foundation of healthcare revenue integrity — services that are delivered but not captured result in permanent revenue loss that cannot be recovered after the timely filing deadline expires. Charge capture occurs through multiple mechanisms including automated charges triggered by orders in the electronic health record, manual charge entry by clinical staff, charge reconciliation comparing scheduled versus billed procedures, and charge capture audits identifying missing or undercoded services. Healthcare data teams build charge capture analytics that compare volumes of ordered versus billed procedures by service type, identify providers with statistically low charge counts suggesting incomplete capture, and measure the revenue impact of charge capture improvement initiatives across clinical departments.

charge costchrg_cst

The gross billed amount for a healthcare service or supply before payer discounts, adjustments, or contractual allowances. Recorded in revenue cycle and cost accounting systems to compare chargemaster rates against actual reimbursement, evaluate pricing strategy, and fulfill cost reporting requirements for CMS and other regulators.

charge masterchrg_mstr

A comprehensive price list containing the standard charges for every service, supply, procedure, and item that a healthcare organization provides, used as the starting point for claim billing before contractual adjustments are applied. Also known as the chargemaster or CDM (Charge Description Master), this database contains hundreds of thousands of line items for hospitals and serves as the basis for claim generation. Each chargemaster entry includes a description, revenue code, CPT or HCPCS code, and standard charge amount. The CMS Price Transparency Rule effective January 2021 requires hospitals to publish their standard chargemaster prices and payer-negotiated rates publicly. Healthcare data teams maintain chrg_mstr databases that link charge codes to revenue codes, procedure codes, and contract rates, supporting charge capture workflows, claim generation, price transparency compliance, and net revenue modeling that projects actual collections based on payer mix and contracted rates.

charity carechrty_care_amt

Free or discounted healthcare services provided by a healthcare organization to patients who meet defined income and financial need criteria, representing a community benefit obligation for nonprofit hospitals and a patient assistance program for other providers. Charity care is distinct from bad debt — charity care is intentionally provided at no or reduced cost to qualifying patients while bad debt represents services provided with expectation of payment that was not collected. The IRS requires nonprofit hospitals to maintain and publicize written financial assistance policies and to screen patients for financial assistance eligibility before pursuing extraordinary collection actions. Community benefit reporting requirements mandate disclosure of charity care amounts provided annually. Healthcare data teams track chrty_care_amt by service type, payer category, and patient demographics to measure community benefit program impact, ensure compliance with financial assistance policy requirements, and distinguish charity care write-offs from bad debt in financial reporting.

charity write offchrty_wo_amt

The dollar amount of patient financial obligations forgiven by a healthcare organization under its financial assistance policy for patients who qualify based on income, assets, or other financial hardship criteria. Charity write-offs are recorded separately from bad debt write-offs in healthcare financial statements and reported as community benefit for nonprofit hospital tax-exempt status compliance. The distinction between charity care and bad debt is made at the time of write-off — charity care is intentional forgiveness of qualified patients while bad debt is uncollected balances from patients who had the ability but not the willingness to pay. IRS Form 990 Schedule H requires nonprofit hospitals to report charity care amounts annually. Healthcare data teams track chrty_wo_amt by patient income category, service line, and facility to measure community benefit program scope, ensure financial assistance policy compliance, and produce accurate community benefit reports for nonprofit hospital regulatory and board reporting.

chart account numberchrt_acct_nbr

A unique identifier linking a patient medical record or clinical documentation set to a specific financial account within hospital information systems. Used to reconcile clinical encounter data with billing records, ensuring that documented diagnoses, procedures, and orders are accurately captured in charge submission and coding workflows.

chart costchrt_cst

The expenses associated with creating, maintaining, or processing patient medical record documentation, including health information management labor, transcription, and storage costs. Used in healthcare operational finance to allocate HIM department costs, support cost-per-chart benchmarking, and evaluate documentation efficiency initiatives.

chemistry account numberchem_acct_nbr

A unique identifier assigned to the clinical chemistry laboratory department or cost center within healthcare financial and billing systems. Used to track charges and costs for serum, plasma, and urine chemical analysis tests such as metabolic panels and lipid profiles, supporting lab revenue reporting and cost allocation.

chemistry costchem_cst

The total expenses incurred in performing clinical chemistry laboratory tests, including reagents, instrumentation, and technical labor for analyses such as comprehensive metabolic panels, glucose, and electrolytes. Used in lab financial systems to monitor cost per reportable test, evaluate analyzer efficiency, and manage laboratory supply budgets.

claim adjudicationclm_adjud

The process by which a health insurance payer reviews a submitted claim, applies benefit plan rules and contract terms, and determines the amount to be paid to the provider. Claim adjudication involves multiple sequential steps including eligibility verification confirming the member was covered on the date of service, medical necessity review validating that the billed services were clinically appropriate, coordination of benefits processing when multiple payers are involved, contract rate application calculating the allowed amount based on the provider network contract, and member cost-sharing calculation determining deductible, copay, and coinsurance obligations. The adjudication result is communicated to providers through the HIPAA 835 electronic remittance advice transaction. Healthcare data teams build adjudication analytics that track claim processing times, adjudication accuracy rates, payment variance between billed and allowed amounts, and adjudication outcome distributions across payer and service type combinations.

claim appealclm_appeal

The formal process by which a healthcare provider challenges a payer determination to deny, reduce, or inappropriately process a claim, seeking reconsideration and payment of the disputed amount. Claim appeals follow structured processes defined by each payer with specific timelines, documentation requirements, and escalation levels. First-level appeals are typically reviewed internally by the payer clinical staff and must be filed within 90 to 180 days of the denial determination date depending on payer requirements. Unsuccessful first-level appeals may be escalated to second-level internal review, external independent review organizations, or administrative law judges for Medicare appeals. Healthcare data teams build appeal tracking systems that monitor appeal submission dates against deadlines, track appeal outcomes by denial reason and payer, calculate appeal overturn rates to measure the financial return on appeal investment, and identify denial categories with high overturn rates that should be appealed systematically rather than written off.

PreviousPage 18 of 69Next