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

debit marital statusdb_mar_sts

The marital status of the individual responsible for a debit balance in healthcare billing or member accounts. This demographic attribute may influence coordination of benefits determinations, dependent coverage eligibility, or financial responsibility assignments when processing outstanding charges in enrollment or billing systems.

debit master identifierdb_mstr_id

The enterprise-level unique identifier assigned to a debit record across healthcare financial systems, enabling consistent tracking of an outstanding balance across billing platforms, claims systems, and accounts receivable databases. Used for cross-system reconciliation, audit trails, and financial reporting of charges owed.

debit maximumdb_max

The upper threshold amount applicable to a debit balance or charge category in healthcare billing or benefit plan design. Used to cap patient financial liability, define out-of-pocket maximums, or establish ceiling values for debit transactions within insurance, accounts receivable, or member billing management systems.

debit middle namedb_mid_nm

The middle name or initial of the individual associated with a debit transaction in healthcare billing or accounts receivable. Used alongside first and last name fields to improve accuracy in identifying the responsible party or guarantor, reducing duplicate records and misapplied payments in financial systems.

debit minimumdb_min

The lower threshold amount applicable to a debit balance or charge category in healthcare billing systems. Used to define floor values for debit transactions, minimum payment requirements, or eligibility thresholds for collection activity within accounts receivable, benefit plan administration, or member billing workflows.

debit mobiledb_mob

The mobile phone number associated with the individual responsible for a debit balance in a healthcare billing or accounts receivable system. Used to facilitate outreach for payment collection, billing notifications, and financial counseling communications related to outstanding charges owed by a member or guarantor.

debit modified bydb_mod_by

The user ID or system identifier of the individual or automated process that last updated a debit record in a healthcare billing or accounts receivable system. Supports audit trail requirements by capturing who made changes to outstanding charge records, ensuring accountability in financial data management workflows.

debit modified datedb_mod_dt

The calendar date on which a debit record was most recently updated in a healthcare billing or accounts receivable system. Used in audit trails and financial reconciliation to track when changes were made to outstanding charge amounts, payment statuses, or responsible party information associated with a debit transaction.

debit modified timedb_mod_tm

The precise time at which a debit record was most recently updated in a healthcare billing or accounts receivable system. Used alongside the modified date field to create a complete audit timestamp, supporting financial compliance, dispute resolution, and data integrity monitoring for outstanding charge records.

debit namedb_nm

The descriptive label assigned to a debit transaction or charge category in a healthcare billing or accounts receivable system. Used to clearly identify the nature of an outstanding balance — such as a copay, coinsurance, or service charge — in member statements, financial reports, and billing communications.

debit numberdb_nbr

The unique reference number assigned to a debit transaction in a healthcare billing or accounts receivable system. Used to track, retrieve, and reconcile specific outstanding charges across claims processing, member billing, and financial reporting workflows, enabling accurate payment application and dispute resolution.

debit onset datedb_onset_dt

The date on which a debit obligation or outstanding charge first originated in a healthcare billing or accounts receivable system. Used to calculate aging buckets, assess timely filing compliance, and prioritize collection activity for balances owed by members, patients, or guarantors within financial management workflows.

debit oxygen saturationdb_o2sat

The blood oxygen level for a charge or 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 debit management and reporting.

debit paid amountdb_pd_amt

The dollar amount received as payment toward a debit balance in a healthcare billing or accounts receivable system. Used to update outstanding charge records, calculate remaining balances, and reconcile member or patient accounts after partial or full payments are applied against billed charges or assessed financial obligations.

debit paid datedb_pd_dt

The date on which a payment was applied to a debit balance in a healthcare billing or accounts receivable system. Used to update account status, calculate days-to-pay metrics, and support financial reporting on collections activity and cash flow timing associated with member or patient outstanding charges.

debit parentdb_prnt

The higher-level debit record or account to which a subordinate debit transaction belongs within a hierarchical healthcare billing or accounts receivable structure. Used to group related charges under a master account, enabling consolidated balance reporting, coordinated collections activity, and accurate financial roll-up across billing systems.

debit percentagedb_pct

The proportional rate applied to calculate or distribute a debit balance in a healthcare billing or accounts receivable system. Used to determine member cost-sharing amounts such as coinsurance, split financial responsibility across multiple payers, or allocate outstanding charges as a percentage of total billed or allowed amounts.

debit perioddb_prd

The billing cycle or time interval during which a debit transaction applies in healthcare financial systems. Used in patient accounting to define the service period associated with a charge, ensuring accurate posting to the correct fiscal or billing period for revenue cycle management.

debit phonedb_ph

The telephone contact number associated with a debit transaction or account in healthcare billing systems. Used in patient financial services to facilitate collections, payment inquiries, or dispute resolution related to outstanding charges on a patient or payer account.

debit preferred namedb_pref_nm

The preferred display label assigned to a debit transaction or charge type in healthcare financial systems. Used in patient accounting and billing workflows to present charge descriptions in a standardized, human-readable format on statements, remittance reports, and financial reconciliation documents.

PreviousPage 32 of 69Next