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 arrival timeinv_arrv_tm

The timestamp recording when an invoice was received by the processing system or billing department in a healthcare revenue cycle workflow. Used to measure processing turnaround times, track submission deadlines, and ensure timely handling within payer filing limit windows.

invoice arrived dateinv_arrv_dt

The calendar date on which an invoice was received by the processing entity in a healthcare billing or accounts payable system. Used to calculate aging, monitor payer response timelines, enforce filing deadlines, and support dispute resolution for late or missing payments.

invoice assessmentinv_asmt

A structured or free-text evaluation associated with an invoice in a healthcare billing review process, capturing reviewer findings, discrepancies, or compliance determinations. Used during audits, dispute resolution, or internal quality reviews to document invoice accuracy assessments.

invoice averageinv_avg

The calculated mean monetary value across a set of invoice records within a defined grouping, such as vendor, plan, or time period. Used in financial analytics and reporting systems to benchmark billing patterns, detect anomalies, and support cost trend analysis across provider, pharmacy, or vendor payment data within PBM and payer platforms.

invoice balanceinv_bal

The remaining dollar amount owed on an invoice after applying payments, adjustments, and credits in a healthcare billing system. Reflects the net unpaid obligation at any point in the revenue cycle and is used to track accounts receivable and patient or payer financial responsibilities.

invoice billed amountinv_bill_amt

The total charges submitted on an invoice before any contractual adjustments, discounts, or payments are applied in a healthcare billing system. Represents the gross amount requested from payers or patients and serves as the starting value for all subsequent payment calculations.

invoice birth dateinv_birth_dt

The date of birth of the patient or member associated with an invoice in a healthcare billing system. Used to verify patient identity, confirm eligibility, support coordination of benefits determinations, and ensure accurate claim submission to the appropriate payer.

invoice blood pressureinv_bp

The arterial pressure value 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 cancelled dateinv_cncl_dt

The date on which an invoice was formally voided or withdrawn in a healthcare billing or accounts payable system. Used to maintain an accurate audit trail, reverse associated financial entries, and track cancellation activity for reporting, compliance, and reconciliation purposes.

invoice categoryinv_cat

A classification label assigned to an invoice in a healthcare billing system that groups it by type such as professional services, facility charges, pharmacy, or durable medical equipment. Used to organize invoices for reporting, routing, processing workflows, and financial analysis.

invoice charge amountinv_chrg_amt

The gross dollar amount charged for a specific service, procedure, or item listed on a healthcare invoice prior to payer adjustments or payments. Forms the basis for revenue cycle calculations including allowed amounts, patient responsibility, and contractual write-offs.

invoice chief complaintinv_cc

The primary diagnosis or clinical reason for service documented on a healthcare invoice, often derived from the encounter record. Used to support medical necessity review, coding accuracy audits, and payer adjudication processes that require clinical justification for billed services.

invoice childinv_chld

Identifies a subordinate invoice linked to a parent invoice in a hierarchical healthcare billing structure. Used to manage split billing scenarios, itemized line-level charges, or related transactions that must be tracked collectively for accurate payment reconciliation and reporting.

invoice cityinv_city

The city associated with the billing or service address recorded on a healthcare invoice. Used to verify provider or patient location for claims processing, tax jurisdiction determination, network validation, and geographic reporting in healthcare billing systems.

invoice classinv_cls

A categorical designation that classifies an invoice by service setting or billing type within a healthcare revenue cycle system, such as inpatient, outpatient, or professional. Determines processing rules, fee schedules, reimbursement logic, and reporting groupings applied during adjudication.

invoice codeinv_cd

A structured code value associated with an invoice record used to classify, categorize, or route the invoice within financial and claims management systems. In PBM and payer platforms, inv_cd may represent invoice type, billing category, or service classification, supporting automated processing, reconciliation workflows, and downstream financial reporting logic.

invoice coinsurance amountinv_coins_amt

The portion of an invoice's allowed amount that the patient is contractually responsible for paying as cost-sharing under their health insurance plan. Calculated as a percentage of the allowed amount after the deductible is met, and tracked in billing systems for patient balance invoicing.

invoice commentinv_cmt

A free-text field on a healthcare invoice used to capture notes, explanations, or clarifying information related to billing, adjustments, disputes, or processing instructions. Supports communication between billing staff, payers, and auditors throughout the invoice lifecycle and review process.

invoice completed dateinv_cmpl_dt

The date on which all services, items, or charges associated with a healthcare invoice were finalized and the billing request was marked complete. Used in revenue cycle management to measure billing cycle duration and track payment timelines.

invoice confidential indicatorinv_conf_ind

A flag denoting whether a healthcare invoice contains sensitive information requiring restricted access, such as behavioral health, substance abuse, or reproductive services. Governs visibility controls in billing and accounts receivable systems to ensure regulatory compliance with privacy mandates.

PreviousPage 45 of 65Next