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 expiration datedb_exp_dt

The date after which a debit authorization, payment method, or debit agreement becomes invalid in a healthcare financial system. Used to trigger renewal workflows, prevent failed transactions, and ensure current payment credentials are on file for premium or cost-sharing collections.

debit external identifierdb_ext_id

A reference identifier assigned to a debit transaction or account by an external system, such as a clearinghouse, bank, or third-party billing platform. Enables cross-system reconciliation and tracking of debit records across healthcare financial, claims, and payment processing environments.

debit faxdb_fax

The fax number associated with a debit account holder or billing contact in a healthcare financial system. Used to transmit payment notices, debit authorization forms, or outstanding balance communications to members, employers, or responsible parties managing account obligations.

debit feedb_fee

A charge assessed in connection with processing a debit transaction within a healthcare billing or payment system. May represent administrative fees, transaction processing costs, or penalties applied to a member or account for payment-related activities such as returned payments or plan charges.

debit first namedb_first_nm

The first name of the individual associated with a debit account or payment obligation in a healthcare billing system. Used to identify the account holder, responsible party, or member linked to a specific debit record for correspondence, verification, and financial reporting purposes.

debit flagdb_flg

A binary indicator applied to a debit record in a healthcare billing or accounts receivable system to signal a specific condition such as delinquency, dispute, reversal, or special processing status. Used to trigger workflow actions and filter debit transactions during reporting and reconciliation.

debit frequencydb_freq

The scheduled interval at which a recurring debit is applied to an account in a healthcare billing system, such as monthly premium withdrawals or weekly payment plan installments. Defines the cadence of automated debit transactions tied to member cost-sharing or subscription-based healthcare payments.

debit full namedb_full_nm

The complete name of the individual or entity associated with a debit account or payment obligation in a healthcare billing system. Used for account identification, correspondence, legal documentation, and financial reporting tied to premium collections, cost-sharing, or other healthcare payment transactions.

debit genderdb_gndr

The gender of the individual associated with a debit account in a healthcare billing or enrollment system. Captured to support demographic reporting, health equity analysis, and compliance requirements linked to financial transactions and member account records within payer or billing platforms.

debit glucosedb_gluc

The blood sugar 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 hemoglobindb_hgb

The blood hemoglobin 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 identifierdb_id

The unique system-assigned identifier for a specific debit transaction or debit account record in a healthcare billing or accounts receivable system. Serves as the primary key for referencing, tracking, and reconciling debit entries across financial, claims, and member management platforms.

debit indexdb_idx

A sequential or positional number assigned to a debit record within a healthcare billing or financial system to establish ordering among multiple debit entries. Used for sorting, pagination, and processing priority when managing debit transaction batches or recurring payment schedules.

debit indicatordb_ind

A coded value or boolean field that signals the presence, type, or status of a debit condition on a healthcare account record. Used in billing and accounts receivable systems to distinguish debit transactions from credits, flag payment exceptions, or denote special handling requirements for financial processing.

debit keydb_key

A reference value used to link a debit record to related entities such as a member, claim, or payment plan within a healthcare financial system. Supports relational data integrity and enables cross-referencing of debit transactions across billing, enrollment, and accounts receivable data stores.

debit languagedb_lang

The preferred communication language of the individual associated with a debit account in a healthcare billing system. Used to ensure that payment notices, debit confirmations, and balance statements are delivered in the account holder's preferred language to support compliance and member experience standards.

debit last namedb_last_nm

The surname of the individual associated with a debit transaction in healthcare billing or accounts receivable. Used to identify the responsible party — such as a member, guarantor, or patient — when tracking outstanding charges, balances owed, or payment obligations within financial management systems.

debit legal namedb_legal_nm

The full legally registered name of the individual or entity responsible for a debit balance in healthcare billing systems. Used during collections, billing disputes, and formal financial correspondence to ensure accurate identification of the guarantor or responsible party associated with an outstanding charge.

debit leveldb_lvl

Indicates the hierarchical tier at which a debit transaction is recorded within a healthcare billing or accounts receivable structure, such as claim level, account level, or encounter level. Used to organize and aggregate outstanding balances for financial reconciliation and reporting across billing systems.

debit license numberdb_lic_nbr

The professional or business license number associated with the entity that originated a debit transaction in a healthcare billing system. Used to verify the credentialed status of a billing provider or facility when auditing charges, resolving disputes, or reconciling accounts receivable records.

PreviousPage 31 of 69Next