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

balance indexbal_idx

The sequential position number assigned to an outstanding balance record within a dataset or transaction set. Used in revenue cycle and billing systems to order and retrieve multiple balance records associated with a single patient account or claim.

balance indicatorbal_ind

A flag or boolean value that signals a specific condition related to an outstanding balance, such as whether a balance is active, delinquent, written off, or subject to collections. Drives workflow routing and financial status reporting in revenue cycle management systems.

balance keybal_key

A lookup or surrogate reference value used to join outstanding balance records to related tables within healthcare billing, claims, or accounts receivable systems. Supports relational data integrity and efficient retrieval of balance details across revenue cycle data warehouses.

balance languagebal_lang

The preferred written or spoken language of the individual associated with an outstanding balance. Used in patient billing and collections workflows to ensure that statements, payment notices, and communications are delivered in the patient's preferred language per regulatory requirements.

balance last namebal_last_nm

The family surname of the patient or guarantor associated with an outstanding balance record in a healthcare billing or accounts receivable system. Used to identify and match individuals to their financial obligations during payment posting, collections, and account reconciliation.

balance legal namebal_legal_nm

The official registered full name of the patient or guarantor tied to an outstanding balance, as recorded for billing, collections, or legal correspondence. Ensures accurate identity verification when issuing statements, pursuing collections, or resolving billing disputes.

balance levelbal_lvl

The classification tier of an outstanding balance, indicating whether it is tracked at the patient, account, claim, or service-line level within a healthcare billing or revenue cycle system. Determines how balances are aggregated, reported, and assigned for collection or write-off.

balance license numberbal_lic_nbr

The professional or facility license number associated with the provider or entity linked to an outstanding balance record. Used in billing and claims adjudication to validate rendering or billing provider credentials when reconciling financial obligations and payer reimbursements.

balance marital statusbal_mar_sts

The marital status of the patient or guarantor associated with an outstanding balance, captured as part of demographic data in billing systems. May be used in coordination of benefits determination, eligibility verification, and dependent coverage assessment during accounts receivable processing.

balance master identifierbal_mstr_id

The enterprise master record identifier linking an outstanding balance to a patient or account across multiple systems within a health system or revenue cycle platform. Supports enterprise-wide balance consolidation, duplicate detection, and accurate reporting across billing and financial data warehouses.

balance maximumbal_max

The upper threshold value defined for an outstanding balance, such as the maximum allowable patient responsibility or the cap applied within a benefit plan or payment arrangement. Used in revenue cycle and benefits administration systems to enforce financial limits and trigger escalation workflows.

balance middle namebal_mid_nm

The middle name or initial of the patient or guarantor associated with an outstanding balance record. Used in healthcare billing and collections systems to improve identity matching accuracy and distinguish individuals with similar first and last names during account reconciliation.

balance minimumbal_min

The lower threshold value for an outstanding balance, such as the minimum dollar amount that triggers a billing statement, collections action, or payment plan offer. Used in revenue cycle management systems to define financial workflow rules and prioritize accounts receivable activity.

balance mobilebal_mob

The mobile phone number of the patient or guarantor associated with an outstanding balance. Used in healthcare billing and collections workflows to deliver payment reminders, text-based statements, and account notifications in compliance with patient communication preferences and applicable regulations.

balance modified bybal_mod_by

The user ID or system identifier of the individual or automated process that last updated an outstanding balance record. Provides an audit trail in revenue cycle and accounts receivable systems to support accountability, error investigation, and compliance with financial data governance standards.

balance modified datebal_mod_dt

The calendar date on which an outstanding balance record was most recently updated in the billing or accounts receivable system. Used for audit tracking, reconciliation scheduling, and identifying stale or recently adjusted balances within revenue cycle reporting and data governance workflows.

balance modified timebal_mod_tm

The timestamp indicating the exact time an outstanding balance record was last updated within a billing or accounts receivable system. Supports precise audit logging, sequencing of concurrent updates, and change history tracking in revenue cycle data management and financial compliance reporting.

balance namebal_nm

The descriptive label assigned to an outstanding balance record or balance type within a healthcare billing or accounts receivable system. Used to categorize and display financial obligations such as patient responsibility, deductible balances, or copay amounts in statements and revenue cycle reporting.

balance numberbal_nbr

Unique identifier assigned to a specific outstanding amount owed within billing and accounts receivable systems. Used to track, reference, and reconcile unpaid balances across revenue cycle management, claims adjudication, and patient financial services workflows.

balance onset datebal_onset_dt

The date on which an outstanding financial balance originated or was first established in the billing system. Used in revenue cycle management to calculate aging buckets, measure collection timelines, and determine when an amount became due following claims adjudication or patient billing.

PreviousPage 8 of 69Next