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,293 finance terms

appointment billed amountappt_bill_amt

The total charges submitted for services rendered during a scheduled patient visit. Represents the gross billed amount before insurance adjudication or patient payment, used in revenue cycle management to track charge capture accuracy, measure collections performance, and analyze revenue by appointment type or care setting.

appointment costappt_cst

The monetary expense associated with delivering care during a scheduled patient visit, including clinical labor, supplies, and overhead. Used in ambulatory cost accounting and value-based care analytics to assess per-visit cost efficiency, support contract modeling, and benchmark resource utilization across appointment types and specialties.

appointment frequencyappt_freq

The rate or count of scheduled patient visits within a defined time period, per patient, provider, or care program. Used in utilization management, care gap analysis, and population health reporting to monitor care adherence, identify high-utilization patterns, and support panel management decisions in primary and specialty care settings.

approval account numberappr_acct_nbr

Unique identifier assigned to a prior authorization or service approval record within a payer or utilization management system. Used to link authorization decisions to claims, member records, and clinical documentation, supporting adjudication accuracy, audit readiness, and coordination of care across payer and provider systems.

approval costappr_cst

The monetary expense associated with processing a prior authorization or service approval request within a payer or utilization management system. Captures administrative costs of clinical review, approval workflows, and system processing, used in operational cost analysis and cost-of-care reporting for utilization management programs.

assessment account numberasmt_acct_nbr

Unique account identifier assigned to a clinical assessment encounter or evaluation record. Used to link assessment activities to billing, tracking, and reporting workflows across revenue cycle and clinical documentation systems, ensuring accurate reconciliation of assessment-related charges.

assessment balanceasmt_bal

The remaining unpaid dollar amount associated with a clinical assessment after payments, adjustments, and credits have been applied. Tracked in revenue cycle systems to manage outstanding patient or payer obligations resulting from diagnostic or clinical evaluation services rendered.

assessment billed amountasmt_bill_amt

The total charged dollar amount submitted to a payer or patient for a clinical assessment or evaluation service. Represents the gross charge before insurance adjustments, contractual discounts, or payments are applied, as recorded in claims and revenue cycle systems.

assessment costasmt_cst

The internal cost incurred by a healthcare facility to deliver a clinical assessment or evaluation service. Used in cost accounting and financial analytics to measure the difference between the expense of performing assessments and the reimbursement or revenue received.

assessment frequencyasmt_freq

The scheduled interval or recurrence rate at which a clinical assessment or evaluation is performed for a patient. Used in care management and clinical documentation systems to define how often assessments such as fall risk, pain, or functional status evaluations are conducted.

assistant account numberasst_acct_nbr

Unique account identifier associated with a clinical or surgical assistant involved in a patient encounter or procedure. Used in billing and credentialing systems to track assistant-rendered services, link claims to the assisting provider, and support accurate reimbursement processing.

assistant balanceasst_bal

The outstanding dollar amount remaining unpaid for services rendered by a clinical or surgical assistant after applicable payments and adjustments. Tracked in revenue cycle systems to manage open receivables tied specifically to assistant-performed or assistant-supported services.

assistant billed amountasst_bill_amt

The total dollar amount charged for services performed or supported by a clinical or surgical assistant during a patient encounter. Represents the gross claim amount submitted to a payer before contractual adjustments or payments are applied in the revenue cycle.

assistant costasst_cst

The internal expense attributed to employing or contracting a clinical or surgical assistant for a patient encounter or procedure. Used in healthcare cost accounting to assess labor and service delivery costs associated with assistant-level care in financial reporting systems.

assistant frequencyasst_freq

The rate or interval at which a clinical or surgical assistant is utilized across patient encounters or procedures within a defined period. Used in operational and workforce analytics to monitor assistant deployment, scheduling patterns, and resource utilization across care settings.

authorization account numberauth_acct_nbr

Unique account identifier linked to a prior authorization or pre-approval request for a healthcare service, procedure, or medication. Used in utilization management and claims systems to associate approved services with the corresponding member account, ensuring coverage validation before care delivery.

authorization costauth_cst

The internal administrative or service cost associated with processing a prior authorization request for a healthcare service or procedure. Used in utilization management analytics to evaluate the financial burden of authorization workflows and identify opportunities to streamline approval processes.

bad debtbad_debt_amt

Patient account balances that a healthcare organization has determined are uncollectible after reasonable collection efforts, written off from accounts receivable as a financial loss. Bad debt arises when patients with insurance coverage fail to pay their out-of-pocket obligations including deductibles, copays, and coinsurance, as well as from self-pay patients who do not qualify for financial assistance but do not pay their bills. Rising patient cost-sharing under high-deductible health plans has significantly increased healthcare bad debt in recent years as more financial responsibility shifts to patients. Healthcare organizations report bad debt separately from charity care in their financial statements. Healthcare data teams analyze bad_debt_amt by service type, payer category, patient demographics, and collection touchpoint to evaluate collection strategy effectiveness, model bad debt reserve requirements for financial planning, and identify patient populations where proactive financial counseling and payment plan arrangements could reduce bad debt conversion rates.

balance account numberbal_acct_nbr

Unique account identifier assigned to track an outstanding financial balance within the revenue cycle. Used in patient accounting and billing systems to link unpaid amounts to specific encounter records, enabling accurate aging, collections follow-up, and account reconciliation activities.

balance agebal_age

The number of days an outstanding balance has remained unpaid since the original bill date or service date. Used in revenue cycle management to categorize receivables into aging buckets, prioritize collections efforts, and monitor financial performance across payer and patient segments.

PreviousPage 4 of 65Next