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

bill mobilebill_mob

The mobile phone number of the guarantor or responsible party associated with the billing account. Used by patient financial services for statement delivery via text notification, payment reminders, and collections outreach in compliance with communication consent and TCPA regulations.

bill modified bybill_mod_by

The system user ID or username of the individual who last updated the billing record. Captured in the audit trail to support compliance, dispute resolution, and charge integrity reviews within revenue cycle and patient financial services workflows.

bill modified datebill_mod_dt

The calendar date on which the billing record was most recently updated, including charge corrections, payment posting adjustments, or status changes. Used in revenue cycle audit trails to track edit history, monitor timely filing compliance, and support billing dispute investigations.

bill modified timebill_mod_tm

The timestamp indicating when the billing record was last modified, capturing the exact hour and minute of the update. Combined with bill modified date to create a full audit record of changes made during charge entry, coding corrections, or payment reconciliation processes.

bill namebill_nm

The display name associated with the billing account or responsible party as it appears on statements and correspondence. Used in patient financial services to personalize billing communications, identify accounts in the revenue cycle system, and present charges on itemized billing statements.

bill numberbill_nbr

A unique alphanumeric identifier assigned to a specific billing statement or invoice within the revenue cycle system. Used to track the lifecycle of charges from initial generation through payment, denial, or write-off, and referenced in payer correspondence and patient communications.

bill onset datebill_onset_dt

The date on which the condition, injury, or illness associated with the billed services first began, as documented on the claim. Required for workers compensation, liability, and certain payer claims to establish medical necessity, coordinate benefits, and determine coverage applicability.

bill oxygen saturationbill_o2sat

The blood oxygen level for a service charge statement. 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 bill management and reporting.

bill paid amountbill_pd_amt

The total dollar amount received as payment against a billing statement, including insurance reimbursements and patient payments. Used in revenue cycle management to calculate outstanding balances, reconcile remittance advice, and determine the remaining patient financial responsibility after adjudication.

bill paid datebill_pd_dt

The date on which payment was received and applied to a healthcare service charge statement. Used in revenue cycle management to reconcile accounts receivable, track payment timelines, and measure days-to-payment performance across payers and claim types.

bill parentbill_prnt

The identifier of the higher-level billing record to which a subordinate charge or statement belongs. Used in hospital billing systems to link line-item charges to a parent claim or encounter, supporting hierarchical bill structures such as split claims or consolidated statements.

bill percentagebill_pct

The proportional share expressed as a percentage applied to a healthcare charge statement. Used in revenue cycle and payer contract management to calculate patient responsibility, coordination of benefits splits, contractual adjustments, or provider reimbursement allocation across multiple payers.

bill periodbill_prd

The defined start and end date range covered by a healthcare service charge statement. Used in institutional and professional billing to identify the span of services rendered, supporting Medicare, Medicaid, and commercial payer claim submissions that require explicit billing period dates.

bill phonebill_ph

The telephone contact number associated with the billing entity or guarantor responsible for a healthcare service charge statement. Used in patient financial services and collections workflows to facilitate follow-up communications regarding outstanding balances, payment arrangements, or billing inquiries.

bill preferred namebill_pref_nm

The preferred display name associated with the billing account or guarantor on a healthcare service charge statement. Used in patient financial services to ensure billing correspondence and statements reflect the patient or responsible party's chosen name, supporting person-centered billing practices.

bill pricebill_prc

The gross or net monetary amount charged for services rendered on a healthcare billing statement prior to adjustments, discounts, or payer contractual allowances. Used in revenue cycle management to establish the billed charge amount submitted to insurance payers or presented to patients.

bill primary indicatorbill_prim_ind

A flag identifying whether a billing record is designated as the primary statement among multiple bills for the same encounter or account. Used in revenue cycle systems to determine sequencing for payer submission, ensuring the primary insurer is billed before secondary or tertiary coverage is applied.

bill prioritybill_prty

A ranking value that determines the order in which a healthcare bill or charge is processed, submitted, or worked within revenue cycle queues. Used in billing workflow management to prioritize high-value claims, time-sensitive payer deadlines, or accounts approaching filing limit thresholds.

bill pulsebill_pulse

The heart rate value for a service charge statement. 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 bill management and reporting.

bill quantitybill_qty

The numeric count of units, services, or items represented on a healthcare charge statement. Used in claims processing and charge capture to specify the number of procedures, supply units, or service days billed, directly impacting reimbursement calculations under fee schedules and per-unit pricing contracts.

PreviousPage 15 of 69Next