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

anesthesiologist frequencyanes_freq

The rate or count of anesthesiologist service events within a defined time period or per patient encounter. Used in utilization management, workforce planning, and operational analytics to measure anesthesia service demand, assess provider productivity, and support scheduling and resource allocation decisions across surgical programs.

appeal deadlineappeal_ddln_dt

The contractually or regulatorily mandated date by which a healthcare provider must submit a formal appeal challenging a payer claim denial or underpayment in order to preserve the right to contest the determination. Appeal deadlines vary significantly by payer type and appeal level — Medicare requires first-level redetermination requests within 120 days of the initial determination, commercial payers typically allow 90 to 180 days from the denial date, and Medicaid timelines vary by state. Missing an appeal deadline permanently forecloses the right to contest the denial regardless of the clinical or administrative merits of the appeal. Healthcare data teams build appeal deadline tracking systems that calculate appeal_ddln_dt from denial dates by payer and appeal type, generate automated alerts as deadlines approach, and produce daily appeal work queues prioritized by deadline urgency to ensure no recovery opportunity is lost due to missed filing windows.

appointment account numberappt_acct_nbr

Unique identifier assigned to a scheduled patient visit within a practice management or scheduling system. Used to link appointment records to patient accounts, provider schedules, and billing transactions, enabling tracking of visit history, no-show rates, and revenue attribution across ambulatory and outpatient care settings.

appointment balanceappt_bal

The outstanding patient or payer balance remaining after payment posting for a scheduled care visit. Used in accounts receivable management to track unpaid amounts associated with specific appointments, supporting patient billing statements, collections workflows, and revenue cycle performance reporting in ambulatory settings.

appointment billed amountappt_bill_amt

The total charges submitted for services rendered during a scheduled patient visit. Represents the gross billed amount before insurance adjudication or patient payment, used in revenue cycle management to track charge capture accuracy, measure collections performance, and analyze revenue by appointment type or care setting.

appointment costappt_cst

The monetary expense associated with delivering care during a scheduled patient visit, including clinical labor, supplies, and overhead. Used in ambulatory cost accounting and value-based care analytics to assess per-visit cost efficiency, support contract modeling, and benchmark resource utilization across appointment types and specialties.

appointment frequencyappt_freq

The rate or count of scheduled patient visits within a defined time period, per patient, provider, or care program. Used in utilization management, care gap analysis, and population health reporting to monitor care adherence, identify high-utilization patterns, and support panel management decisions in primary and specialty care settings.

approval account numberappr_acct_nbr

Unique identifier assigned to a prior authorization or service approval record within a payer or utilization management system. Used to link authorization decisions to claims, member records, and clinical documentation, supporting adjudication accuracy, audit readiness, and coordination of care across payer and provider systems.

approval costappr_cst

The monetary expense associated with processing a prior authorization or service approval request within a payer or utilization management system. Captures administrative costs of clinical review, approval workflows, and system processing, used in operational cost analysis and cost-of-care reporting for utilization management programs.

assessment account numberasmt_acct_nbr

Unique account identifier assigned to a clinical assessment encounter or evaluation record. Used to link assessment activities to billing, tracking, and reporting workflows across revenue cycle and clinical documentation systems, ensuring accurate reconciliation of assessment-related charges.

assessment balanceasmt_bal

The remaining unpaid dollar amount associated with a clinical assessment after payments, adjustments, and credits have been applied. Tracked in revenue cycle systems to manage outstanding patient or payer obligations resulting from diagnostic or clinical evaluation services rendered.

assessment billed amountasmt_bill_amt

The total charged dollar amount submitted to a payer or patient for a clinical assessment or evaluation service. Represents the gross charge before insurance adjustments, contractual discounts, or payments are applied, as recorded in claims and revenue cycle systems.

assessment costasmt_cst

The internal cost incurred by a healthcare facility to deliver a clinical assessment or evaluation service. Used in cost accounting and financial analytics to measure the difference between the expense of performing assessments and the reimbursement or revenue received.

assessment frequencyasmt_freq

The scheduled interval or recurrence rate at which a clinical assessment or evaluation is performed for a patient. Used in care management and clinical documentation systems to define how often assessments such as fall risk, pain, or functional status evaluations are conducted.

assistant account numberasst_acct_nbr

Unique account identifier associated with a clinical or surgical assistant involved in a patient encounter or procedure. Used in billing and credentialing systems to track assistant-rendered services, link claims to the assisting provider, and support accurate reimbursement processing.

assistant balanceasst_bal

The outstanding dollar amount remaining unpaid for services rendered by a clinical or surgical assistant after applicable payments and adjustments. Tracked in revenue cycle systems to manage open receivables tied specifically to assistant-performed or assistant-supported services.

assistant billed amountasst_bill_amt

The total dollar amount charged for services performed or supported by a clinical or surgical assistant during a patient encounter. Represents the gross claim amount submitted to a payer before contractual adjustments or payments are applied in the revenue cycle.

assistant costasst_cst

The internal expense attributed to employing or contracting a clinical or surgical assistant for a patient encounter or procedure. Used in healthcare cost accounting to assess labor and service delivery costs associated with assistant-level care in financial reporting systems.

assistant frequencyasst_freq

The rate or interval at which a clinical or surgical assistant is utilized across patient encounters or procedures within a defined period. Used in operational and workforce analytics to monitor assistant deployment, scheduling patterns, and resource utilization across care settings.

authorization account numberauth_acct_nbr

Unique account identifier linked to a prior authorization or pre-approval request for a healthcare service, procedure, or medication. Used in utilization management and claims systems to associate approved services with the corresponding member account, ensuring coverage validation before care delivery.

PreviousPage 4 of 69Next