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 copay amountinv_cpay_amt

The fixed out-of-pocket dollar amount collected from the patient at the time of service or billed on a healthcare invoice, as defined by the patient's insurance plan. Tracked in revenue cycle systems to reconcile patient responsibility against total charges and adjudicated claim payments.

invoice costinv_cst

The total expense amount recorded on a healthcare invoice, representing the actual cost of services, supplies, or procedures rendered. Used in financial analytics and cost accounting to compare billed charges against reimbursement rates and calculate net revenue for healthcare services.

invoice countinv_cnt

The total number of invoice records associated with a defined grouping, such as a vendor, provider, plan, or reporting period. Used in financial operations and analytics within PBM, claims, and accounts payable systems, inv_cnt supports volume trending, workload analysis, audit sampling, and reconciliation validation across billing and payment workflows.

invoice countryinv_ctry

The country associated with the billing address or service location recorded on a healthcare invoice. Used in international billing workflows and claims processing to apply appropriate currency, regulatory requirements, and reimbursement rules for cross-border healthcare services or vendor payments.

invoice created byinv_crtd_by

The unique identifier of the user, system, or process that generated a healthcare invoice in the billing or revenue cycle management system. Used for audit trail purposes, workflow accountability, and tracking billing staff productivity across accounts receivable and claims submission processes.

invoice created dateinv_crtd_dt

The calendar date on which a healthcare invoice record was initially generated in the billing or revenue cycle management system. Used in accounts receivable reporting to measure billing lag time between date of service and invoice generation, supporting timely claims submission workflows.

invoice created timeinv_crtd_tm

The timestamp recording the precise time at which a healthcare invoice was generated in the billing system. Used alongside the created date for detailed audit logging, workflow sequencing, and measuring operational throughput in revenue cycle and claims management processes.

invoice creatinineinv_cr

The kidney function marker 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 currentinv_curr

An indicator or value reflecting the current status or active version of an invoice record within a financial or claims management system. In PBM and payer platforms, inv_curr is used to distinguish the most recent invoice iteration from historical or superseded versions, supporting accurate reconciliation, payment processing, and audit trail maintenance.

invoice dateinv_dt

The official date assigned to a healthcare invoice, typically representing when the billing request was issued to the payer or patient. Used in accounts receivable aging reports, claims timely filing compliance tracking, and revenue recognition within healthcare financial management systems.

invoice datetimeinv_dttm

The combined date and time value capturing the exact moment a healthcare invoice was issued or recorded in the billing system. Supports precise chronological ordering of billing transactions, audit trail reconstruction, and timely filing calculations in revenue cycle management systems.

invoice dea numberinv_dea_nbr

The Drug Enforcement Administration registration number associated with a prescribing provider or dispensing pharmacy on a healthcare invoice. Required for controlled substance billing verification, pharmacy claims adjudication, and regulatory compliance auditing within prescription drug billing workflows.

invoice death dateinv_death_dt

The date of death for a payment request document. Used to track temporal information related to invoice death date. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for invoice management and reporting.

invoice deductible amountinv_ded_amt

The portion of a healthcare invoice applied toward the patient's annual insurance deductible, representing the amount the patient must pay before insurance coverage begins. Tracked in revenue cycle systems to accurately calculate patient balances and coordinate benefits across payer adjudication records.

invoice deleted dateinv_del_dt

The date on which a healthcare invoice record was marked for deletion or voided in the billing system. Used in revenue cycle audit trails to maintain a historical record of removed invoices, supporting financial reconciliation, compliance reviews, and accounts receivable integrity monitoring.

invoice deleted indicatorinv_del_ind

A flag identifying whether a healthcare invoice has been voided, cancelled, or logically removed from active billing records. Used in revenue cycle management to exclude invalidated invoices from accounts receivable reporting while preserving the historical record for audit and reconciliation purposes.

invoice descriptioninv_desc

A free-text or structured narrative field providing human-readable details about the nature, purpose, or content of an invoice record. In PBM, claims, and vendor management systems, inv_desc supports manual review workflows, dispute resolution, and financial reporting by providing context that complements coded invoice fields and aids in reconciliation and audit processes.

invoice detailinv_dtl

The line-item breakdown of services, procedures, supplies, or charges included on a healthcare invoice, including CPT or HCPCS codes, quantities, and individual charge amounts. Used in claims adjudication, billing audits, and remittance reconciliation to validate charges against services rendered.

invoice due dateinv_due_dt

The deadline by which payment on a healthcare invoice is expected from the patient, payer, or vendor. Used in accounts receivable aging analysis, denial management workflows, and collections processes to identify overdue balances and trigger appropriate follow-up actions in revenue cycle management systems.

invoice durationinv_dur

The total time span covered by the services or charges included on a healthcare invoice, such as the period of an inpatient stay or recurring service contract. Used in revenue cycle reporting to validate billing periods, support claims adjudication, and reconcile episodic payment arrangements.

PreviousPage 46 of 65Next