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

Operations

Scheduling, facilities, departments, workflows, and staff

6,391 operations terms

debit unitdb_unt

The unit of measure or quantity associated with a debit charge in healthcare billing systems. Represents the billable increment such as a service unit, procedure count, or time unit used to calculate the total debit amount on a claim or patient account statement.

deductible scheduled dateded_sched_dt

The calendar date on which a member's deductible obligation is scheduled to be applied or evaluated within health insurance claims processing. Used to track when cost-sharing thresholds are assessed, ensuring accurate accumulator updates and member benefit coordination.

deductible scheduled timeded_sched_tm

The specific time at which a deductible amount is scheduled to be applied or recalculated in health insurance claims or member benefits systems. Supports precise accumulator tracking and benefit period management when processing member cost-sharing obligations.

deductible unitded_unt

The unit of measure associated with a deductible value in claims, PBM, or member enrollment systems, typically expressed in currency such as USD. Ensures consistent interpretation of deductible amounts across adjudication engines, reporting pipelines, and cross-payer benefit coordination workflows.

department account numberdept_acct_nbr

The unique numeric identifier assigned to a hospital or clinic department for financial tracking and cost center reporting. Used in healthcare billing and general ledger systems to allocate charges, expenses, and revenue to the correct departmental cost center.

department active indicatordept_actv_ind

A binary flag indicating whether a hospital or clinic department is currently operational and accepting patients or processing transactions. Used in healthcare administrative systems to filter active departments for scheduling, billing, staffing, and reporting purposes.

department active statusdept_actv_sts

The current operational state of a hospital or clinic department, indicating whether it is active, inactive, or suspended within healthcare administrative and billing systems. Used to control department visibility in scheduling, claims processing, and resource allocation workflows.

department addressdept_addr

The physical or mailing location text associated with a specific organizational unit within a healthcare facility, stored in EHR, provider directory, or claims systems. Used for provider roster management, claims routing, facility credentialing, and regulatory reporting to ensure accurate departmental contact and location data.

department adjustment amountdept_adj_amt

The monetary value of a financial adjustment applied to a hospital or clinic department's charges or reimbursements in healthcare billing systems. Represents contractual write-offs, corrections, or payer-mandated changes that reconcile billed amounts against allowed payments in revenue cycle reporting.

department agedept_age

The length of time, typically in years, that a hospital or clinic department has been in operation since its establishment. Used in healthcare administrative reporting to support operational analysis, accreditation documentation, and historical context for departmental performance evaluations.

department allowed amountdept_alwd_amt

The maximum reimbursable dollar amount approved by a payer for services rendered by a specific hospital or clinic department. Used in healthcare claims processing and revenue cycle reporting to calculate contractual adjustments, patient cost-sharing, and net expected reimbursement.

department amountdept_amt

The monetary value attributed to a specific organizational department in healthcare financial, claims, or cost accounting systems. Used for departmental budget tracking, cost allocation, revenue cycle reporting, and analyzing resource utilization across service lines within hospital or health system data platforms.

department approval statusdept_appr_sts

The current authorization state of a hospital or clinic department, indicating whether it has been approved for operations, credentialing, or participation in specific clinical or financial workflows. Used in healthcare administrative systems to manage compliance and regulatory readiness.

department approved bydept_appr_by

The name or identifier of the individual or authority who granted approval for a hospital or clinic department's operational, financial, or clinical request. Used in healthcare administrative audit trails to document accountability and compliance with internal governance and regulatory requirements.

department arrival timedept_arrv_tm

The recorded time at which a patient arrived at a specific hospital or clinic department during an encounter. Used in healthcare operations and quality reporting to measure patient flow, wait times, throughput efficiency, and compliance with triage or service level benchmarks.

department arrived datedept_arrv_dt

The calendar date on which a patient arrived at a specific hospital or clinic department during a healthcare encounter. Used in clinical and operational reporting to support patient flow analysis, length of stay calculations, and compliance with regulatory throughput standards.

department assessmentdept_asmt

The clinical evaluation or findings documented by a healthcare provider within a specific hospital or clinic department during a patient encounter. Captures structured or free-text diagnostic impressions used to guide treatment planning and support continuity of care across departments.

department averagedept_avg

The calculated mean value of a specified metric, such as cost, volume, or length of stay, aggregated across encounters or transactions within a healthcare department. Used in EHR analytics, claims reporting, and operational dashboards to benchmark departmental performance and support resource allocation decisions.

department balancedept_bal

The outstanding financial amount attributed to a specific organizational unit within a healthcare system. Tracked in EHR billing modules and hospital cost accounting systems to reconcile departmental expenditures, charge capture, and revenue against budget allocations.

department billed amountdept_bill_amt

The total dollar amount charged by a hospital or clinic department for services rendered to a patient, submitted to a payer or patient account. Used in healthcare revenue cycle reporting to measure gross charges before contractual adjustments, write-offs, or payer-negotiated reductions are applied.

PreviousPage 73 of 320Next