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

disorder account numberdsrd_acct_nbr

The unique account identifier assigned to track claims and financial transactions related to a specific diagnosed disorder or abnormal health condition. Used in disease management programs and claims analytics to associate treatment costs and utilization with a patient's diagnosed condition across episodes of care.

disorder costdsrd_cst

The total expense amount attributed to treating a specific diagnosed disorder or abnormal health condition across all associated claims. Used in population health analytics and condition-based cost reporting to evaluate total cost of care for members with defined diagnoses within a health plan.

document account numberdoc_acct_nbr

The unique account identifier associated with a clinical or administrative document record within healthcare information systems. Used to link documentation such as referrals, authorizations, or clinical notes to specific financial transactions and member accounts for audit, compliance, and billing reconciliation purposes.

document costdoc_cst

The expense amount associated with producing, processing, or managing a clinical or administrative document within healthcare operations. Used in administrative cost tracking and billing workflows to capture fees related to medical records requests, documentation services, and health information management activities.

documentation deficiencydoc_defcy

An identified gap, omission, or inadequacy in a medical record where required clinical documentation is missing, incomplete, or insufficient to support the billed diagnosis or procedure codes, meet accreditation standards, or demonstrate medical necessity for the services provided. Documentation deficiencies are identified through concurrent CDI review during hospitalization, retrospective coding audit, or payer medical record request review. Common deficiency types include unsigned or undated physician notes, missing final diagnosis at discharge, inadequate specificity of documented diagnoses, absent operative reports for surgical procedures, and missing authentication by the responsible provider. Healthcare data teams track doc_defcy by deficiency type, physician, service line, and deficiency age from creation to completion to measure documentation compliance, evaluate medical staff education program effectiveness, and identify chronic deficiency patterns that create coding accuracy and reimbursement risk.

dose account numberdose_acct_nbr

The unique account identifier assigned to track pharmacy claims and financial transactions associated with a specific medication dose. Used in pharmacy benefit management systems to link individual dispensing events, drug quantities, and associated costs to a member's prescription benefit account.

dose costdose_cst

The expense amount associated with a specific medication dose dispensed through the pharmacy benefit. Used in pharmacy claims analytics and drug spend reporting to capture per-dose pricing, including ingredient cost and dispensing fees, for formulary management and member cost-sharing calculations.

duration account numberdur_acct_nbr

The unique account identifier assigned to track the financial and administrative records associated with a defined treatment or coverage duration period. Used in claims and utilization management systems to link time-bound therapy episodes or benefit periods to member accounts for cost and outcome tracking.

duration costdur_cst

The total expense amount attributable to a defined treatment or therapy duration period for a member or patient. Used in utilization management and episode-of-care analytics to evaluate cumulative costs over specific treatment timeframes across inpatient, outpatient, and pharmacy benefit categories.

effective account numbereff_acct_nbr

The unique account identifier linked to a coverage effective date record within member enrollment and benefits administration systems. Used to track when health plan coverage becomes active for a member, supporting claims eligibility verification, enrollment reconciliation, and benefit period management across payer systems.

effective costeff_cst

The expense amount associated with initiating or administering coverage as of a specific effective date within a health plan. Used in enrollment and premium billing workflows to capture costs tied to coverage activation, retroactive adjustments, and benefit period financial reconciliation for member accounts.

electronic claimelec_clm_ind

A boolean indicator identifying that a healthcare claim was submitted electronically using a HIPAA-compliant standard transaction format rather than a paper claim form. The Health Insurance Portability and Accountability Act mandates electronic submission for most Medicare and Medicaid claims, and commercial payers strongly incentivize electronic submission through faster processing times and lower administrative fees. Electronic claims are transmitted in the X12 837P format for professional claims, 837I format for institutional claims, and 837D format for dental claims. Electronic submission through clearinghouses enables claim validation before payer submission, reducing rejection rates and accelerating payment. Healthcare data teams track elec_clm_ind to measure electronic submission rates by payer and facility, calculate administrative cost savings from paper-to-electronic conversion, identify remaining paper claim volumes by payer that could be converted to electronic submission, and benchmark electronic submission rates against industry standards.

electronic funds transfereft

The electronic transmission of healthcare claim payment funds directly from a health insurance payer bank account to a provider bank account, replacing paper check payments and enabling faster, more accurate cash management. The HIPAA Administrative Simplification provisions require payers to offer electronic funds transfer to providers upon request using the CCD+ format. Electronic funds transfer is paired with the HIPAA 835 electronic remittance advice transaction to provide both the payment and the detailed explanation of how each claim was processed in a standardized electronic format. Healthcare organizations that adopt EFT and ERA eliminate check handling costs, reduce payment posting errors, and accelerate cash availability. Healthcare data teams track EFT adoption rates by payer, measure the cost reduction from eliminating paper check processing, and reconcile EFT deposits against 835 remittance data to ensure all expected payments are received and accurately posted.

eligibility verificationelig_verif

The process of confirming that a patient is enrolled in and actively covered by a health insurance plan on the date of service, using real-time electronic inquiry through HIPAA 270/271 transactions or payer web portals. Eligibility verification confirms the member active enrollment status, coverage effective and termination dates, plan type and benefit structure, primary care physician assignment for HMO plans, and referral requirements. Eligibility errors are among the most common causes of claim denials, generating significant rework costs and payment delays. Industry best practice recommends verifying eligibility for all patients within 48 hours of the scheduled service and again on the date of service for high-volume payers. Healthcare data teams build eligibility verification analytics that track real-time verification rates by payer and service type, measure eligibility denial rates as a quality indicator, and calculate the revenue impact of eligibility-related denials to justify investment in automated eligibility verification technology.

emergency account numberemerg_acct_nbr

The unique account identifier assigned to track claims and financial transactions associated with emergency care services rendered to a member. Used in medical claims processing and care management systems to link emergency department visits, urgent interventions, and associated costs to a specific member benefit account.

emergency costemerg_cst

The total dollar amount paid or incurred for emergency department or urgent care services, captured at the claim or encounter level. Includes facility fees, physician services, and ancillary charges billed under emergency revenue codes in medical claims data.

endocrinology account numberendo_acct_nbr

The unique account identifier assigned to endocrinology specialty services, including diabetes, thyroid, and hormonal disorder care. Used to track and reconcile endocrinology-related claims, referrals, and patient encounters across billing and clinical systems.

endocrinology costendo_cst

The total dollar amount paid or incurred for endocrinology specialty services, including consultations, hormone testing, and treatment for conditions such as diabetes, thyroid disorders, and metabolic diseases. Captured at the claim or encounter level in medical cost data.

episode account numberepsd_acct_nbr

The unique identifier assigned to a discrete episode of care, representing all services delivered for a specific condition or procedure within a defined timeframe. Used in value-based care analytics to group related claims and track total cost across care settings.

episode balanceepsd_bal

The remaining unpaid dollar amount associated with all services within a defined episode of care after payments, adjustments, and credits have been applied. Used in revenue cycle management to monitor outstanding financial obligations tied to condition-specific care episodes.

PreviousPage 34 of 65Next