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

invoice hemoglobininv_hgb

The blood hemoglobin level for a payment request document. 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 invoice management and reporting.

invoice history present illnessinv_hpi

Documents the narrative description of the patient's current condition or presenting symptoms as recorded on a billing invoice or associated clinical encounter. Used in healthcare revenue cycle systems to support medical necessity justification, claims adjudication, and audit documentation for services billed to payers or managed care organizations.

invoice identifierinv_id

A unique system-generated or vendor-assigned key that distinctly identifies an invoice record within a financial or claims management system. Stored as inv_id in PBM, provider billing, and payer platforms, this identifier is used to link invoice records across payment, reconciliation, and audit tables, enabling precise tracking of billing transactions and supporting dispute resolution workflows.

invoice indexinv_idx

Represents the sequential or assigned position number of an invoice within a batch, series, or financial dataset. Used in healthcare billing and accounts payable systems to organize, sort, and retrieve invoice records efficiently, supporting bulk payment processing, audit reviews, and financial reporting across revenue cycle management workflows.

invoice indicatorinv_ind

A binary or coded flag associated with an invoice record that signals a specific condition, status, or classification within a financial or claims processing system. In PBM and payer platforms, inv_ind is used to denote attributes such as manual review required, disputed status, or special handling, supporting routing logic, workflow automation, and exception-based reporting.

invoice instructioninv_instr

Contains specific processing directions or notes associated with a billing invoice, such as payment terms, special handling requirements, or payer-specific submission guidelines. Used in healthcare revenue cycle and accounts payable systems to ensure invoices are routed, processed, and adjudicated correctly according to contractual or administrative requirements.

invoice keyinv_key

Serves as the primary or surrogate database key used to uniquely identify and retrieve an invoice record within a healthcare financial or billing system. Used in revenue cycle management and accounts payable platforms to link invoice data across related tables, support join operations, and maintain referential integrity across financial datasets.

invoice languageinv_lang

Records the preferred or required language for invoice communications, documentation, or correspondence associated with a billing record. Used in healthcare financial systems to ensure that invoices, remittance notices, and billing statements are generated and delivered in the appropriate language for patients, guarantors, or vendor contacts.

invoice last nameinv_last_nm

Records the family surname of the individual associated with a billing invoice, typically the patient, guarantor, or vendor representative. Used in healthcare financial systems to accurately identify and match invoice records during payment processing, eligibility verification, account reconciliation, and billing dispute resolution workflows.

invoice legal nameinv_legal_nm

Stores the officially registered name of the individual or entity as it appears on legal or contractual documents associated with a billing invoice. Used in healthcare accounts payable and revenue cycle systems to ensure compliance with regulatory requirements, vendor contracts, and payer agreements during invoice validation and payment processing.

invoice levelinv_lvl

Indicates the hierarchical classification or tier of a billing invoice within a financial system, such as header versus line-item level, or patient versus encounter level. Used in healthcare revenue cycle management to structure invoice data for accurate claims adjudication, cost allocation, and reporting across billing and accounts payable workflows.

invoice license numberinv_lic_nbr

The professional license number associated with the rendering provider on a healthcare invoice. Used in billing systems to validate provider credentials, ensure regulatory compliance, and support accurate claim adjudication and reimbursement processing.

invoice marital statusinv_mar_sts

The marital status of the patient or subscriber recorded on a healthcare invoice. Used in billing and claims processing to determine coordination of benefits eligibility, dependent coverage, and appropriate payer sequencing for accurate reimbursement adjudication.

invoice master identifierinv_mstr_id

The enterprise-level master identifier assigned to a healthcare invoice, enabling cross-system linkage and deduplication across billing platforms. Supports accurate invoice tracking, payment reconciliation, and financial reporting across payer and provider billing environments.

invoice maximuminv_max

The maximum allowable monetary value defined for a healthcare invoice or billing transaction. Used in revenue cycle management to enforce billing thresholds, validate charges against contractual limits, and flag invoices exceeding payer-defined reimbursement caps for review.

invoice medical record numberinv_mrn

The patient medical record number linked to a healthcare invoice, establishing a direct association between the billing transaction and the patient's clinical record. Enables accurate patient matching, audit support, and reconciliation between clinical and financial systems.

invoice middle nameinv_mid_nm

The middle name or initial of the patient or responsible party recorded on a healthcare invoice. Used in billing systems to support accurate patient identity matching, reduce duplicate records, and ensure correct association of invoices with the appropriate individual's account.

invoice minimuminv_min

The minimum allowable monetary value defined for a healthcare invoice or billing transaction. Used in revenue cycle management to enforce billing floor thresholds, validate charge amounts, and identify invoices that fall below contractually or operationally defined payment minimums.

invoice mobileinv_mob

The mobile phone number associated with the patient or responsible party on a healthcare invoice. Used in billing systems to facilitate payment notifications, collections outreach, and patient communication regarding outstanding balances or invoice status updates.

invoice modified byinv_mod_by

The user identifier of the individual who last modified a healthcare invoice record. Used in billing audit trails to maintain accountability, support compliance reviews, and track changes made to invoice data throughout the revenue cycle workflow.

PreviousPage 48 of 65Next