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

balance ethnicitybal_ethn

The self-reported or assigned ethnicity of the patient or guarantor associated with an outstanding balance. Used in healthcare financial analytics and population health reporting to identify disparities in patient payment obligations, billing outcomes, and financial assistance program eligibility across demographic groups.

balance expiration datebal_exp_dt

The date after which an outstanding balance is no longer eligible for collection, payment plan enrollment, or financial assistance consideration, often tied to billing policy or statute of limitations rules. Used in revenue cycle systems to manage account aging thresholds and trigger write-off workflows.

balance external identifierbal_ext_id

A reference identifier assigned by an external system, such as a clearinghouse, collections agency, or payer platform, to track an outstanding balance outside the originating billing system. Used in revenue cycle integrations to reconcile accounts, match remittance data, and coordinate cross-system payment resolution.

balance faxbal_fax

The facsimile number associated with the guarantor, payer, or responsible party for an outstanding patient balance. Used in revenue cycle and billing operations to transmit paper-based billing statements, payment requests, or collection notices to parties who require or prefer fax-based financial correspondence.

balance feebal_fee

A specific charge or service fee component contributing to the total outstanding patient or claim balance, such as a late payment fee, administrative fee, or unbundled service charge. Used in revenue cycle billing systems to itemize balance composition and ensure accurate patient statement and payer invoice generation.

balance first namebal_first_nm

The given name of the patient, guarantor, or responsible party associated with an outstanding financial balance. Used in revenue cycle and patient billing systems to personalize statements, verify account ownership, and accurately address collection communications to the correct individual responsible for the unpaid amount.

balance flagbal_flg

A binary or coded indicator used to mark an outstanding balance record with a specific status, such as in dispute, sent to collections, or eligible for financial assistance. Used in revenue cycle systems to filter, prioritize, and route balance accounts through appropriate billing and collections workflows.

balance frequencybal_freq

The scheduled interval at which billing statements or payment reminders are generated and sent to the responsible party for an outstanding balance, such as monthly or bi-weekly. Used in revenue cycle management to configure patient communication cadence, manage billing cycles, and optimize collections outreach timing.

balance full namebal_full_nm

The complete legal name of the patient, guarantor, or responsible party associated with an outstanding financial balance. Used in revenue cycle billing and collections systems to ensure accurate identification on statements, legal correspondence, credit reporting submissions, and payment plan agreements for unpaid accounts.

balance genderbal_gndr

The sex classification of the individual associated with an outstanding balance in billing or accounts receivable systems. Used to link demographic data to financial records, supporting patient-level balance tracking, reporting, and coordination of benefits processing.

balance glucosebal_gluc

The blood sugar level for a outstanding amount owed. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for balance management and reporting.

balance hemoglobinbal_hgb

The blood hemoglobin level for a outstanding amount owed. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for balance management and reporting.

balance identifierbal_id

The unique alphanumeric key assigned to a specific outstanding balance record in healthcare billing or accounts receivable systems. Enables accurate tracking, reconciliation, and cross-system reference of patient or claim-level financial obligations across revenue cycle workflows.

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.

PreviousPage 7 of 65Next