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 sexbal_sex

The biological sex of the patient associated with an outstanding balance record. Captured in revenue cycle and patient financial services contexts to support demographic reporting, match records across systems, and ensure accurate patient identity verification during collections.

balance sourcebal_src

Identifies the originating system, transaction type, or billing event that generated an outstanding patient or claim balance. Common sources include insurance underpayments, patient responsibility determinations, claim denials, or coordination of benefits adjudication results.

balance start datebal_start_dt

The date on which an outstanding patient or claim balance was first established in the billing or revenue cycle system. Marks the beginning of the balance aging period and is used to calculate days outstanding, trigger collection workflows, and report on financial liability timelines.

balance start timebal_start_tm

The specific time of day at which an outstanding patient or claim balance record was initiated in the billing system. Combined with the balance start date, this timestamp supports precise audit trails, same-day transaction sequencing, and reconciliation of real-time payment postings.

balance statebal_st

The U.S. state or territory associated with the patient or payer responsible for an outstanding balance. Used in revenue cycle reporting to apply state-specific billing regulations, collection laws, and Medicaid balance billing rules relevant to patient financial liability.

balance statusbal_sts

A coded value indicating the current lifecycle stage of an outstanding patient or claim balance, such as open, pending insurance, in collections, resolved, or written off. Drives workflow routing in billing systems and is essential for accounts receivable aging and financial reporting.

balance subtotalbal_subtot

A partial sum representing a subset of charges or adjustments within an outstanding patient or claim balance, such as the amount owed by a specific payer or for a defined service category. Used in multi-payer billing scenarios to itemize financial responsibility before computing the total balance due.

balance targetbal_tgt

The intended recipient or responsible party designated to satisfy an outstanding balance, such as the patient, a primary insurer, a secondary payer, or a guarantor. Used in revenue cycle systems to route billing statements and collection activities to the correct financial party.

balance taxonomy codebal_tax_cd

The NUCC provider taxonomy code associated with the billing provider or service type linked to an outstanding balance. Used in claim adjudication and revenue cycle systems to validate provider specialty eligibility, apply correct fee schedules, and resolve payer-specific balance disputes.

balance temperaturebal_temp

A metaphorical or system-defined urgency indicator applied to an outstanding patient or claim balance, reflecting how actively it is being pursued for collection. May also capture the patient body temperature at the time of a visit when stored in an integrated clinical-financial record.

balance termination datebal_term_dt

The date on which an outstanding patient or claim balance was officially closed, written off, or transferred out of the active accounts receivable ledger. Used in revenue cycle reporting to calculate collection cycle length, measure recovery rates, and support financial period-end close processes.

balance timebal_tm

The time of day recorded against an outstanding patient or claim balance event, such as payment posting, adjustment entry, or account transfer. Used in revenue cycle audit trails to sequence intraday financial transactions and support reconciliation of high-volume billing operations.

balance timestampbal_ts

A combined date and time value capturing when a specific action was recorded against an outstanding patient or claim balance, such as creation, adjustment, or resolution. Used in revenue cycle and billing systems to maintain precise audit logs and support real-time financial reconciliation.

balance titlebal_ttl

A descriptive label or formal name assigned to an outstanding patient or claim balance record, such as patient responsibility, insurance pending, or deductible balance. Used in billing systems and patient financial communications to clearly identify the nature and category of the amount owed.

balance totalbal_tot

The aggregate sum of all outstanding amounts owed on a patient account, claim, or billing record. Used in revenue cycle management to calculate total financial liability across multiple charges, adjustments, and payments within a billing period.

balance total countbal_tot_cnt

The total number of outstanding balance occurrences on a patient account or billing record. Used in revenue cycle reporting to quantify how many individual unpaid charges or balance line items exist within an account for collections and reconciliation workflows.

balance typebal_typ

A classification code identifying the category of outstanding balance, such as patient responsibility, insurance pending, bad debt, or charity care. Used in revenue cycle management to segment and route unpaid amounts through appropriate collections or adjustment processes.

balance updated datebal_upd_dt

The most recent date on which an outstanding balance record was modified, reflecting payment posting, adjustment, or correction activity. Used in revenue cycle management to track account aging and ensure timely follow-up on unpaid patient or payer balances.

balance urgencybal_urg

A priority classification indicating the time sensitivity level assigned to an outstanding balance, such as immediate, high, or routine. Used in revenue cycle and collections workflows to prioritize follow-up actions on unpaid patient or payer balances based on account aging or dollar threshold.

balance versionbal_ver

A sequential version number tracking revisions to an outstanding balance record over time, reflecting changes due to payment posting, payer adjustments, or billing corrections. Used in revenue cycle management to maintain audit trails and ensure data integrity across balance updates.

PreviousPage 10 of 65Next