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,492 operations terms

workflow titlewf_ttl

The formal name or designation assigned to a healthcare workflow process, used to identify and distinguish workflow types such as prior authorization, discharge planning, claims review, or medication reconciliation within clinical and administrative health information systems.

workflow totalwf_tot

The complete aggregated sum of costs, units, counts, or other measurable values associated with a healthcare workflow process. Used in claims adjudication, utilization management, and care coordination reporting to represent the final calculated outcome of a workflow cycle.

workflow total countwf_tot_cnt

The aggregate number of occurrences, items, or instances processed within a healthcare workflow, such as total tasks completed, claims reviewed, or authorizations processed. Used for operational reporting, performance benchmarking, and capacity planning across health information systems.

workflow typewf_typ

The categorical classification of a healthcare workflow process, distinguishing between types such as clinical, administrative, financial, or operational. Used to organize, route, and report on workflows including prior authorizations, claims processing, care transitions, and referral management.

workflow unitwf_unt

The unit of measure or single item associated with a healthcare workflow process, such as a service unit, dose, day, or encounter. Used to quantify clinical activities, pharmacy dispensing, claims line items, or care management interventions within health information systems.

workflow updated datewf_upd_dt

The date on which a healthcare workflow record was most recently modified, used to track changes in task status, routing, or data values. Supports audit trail maintenance, version control, and change management across clinical, administrative, and claims workflow systems.

workflow urgencywf_urg

The priority or time-sensitivity level assigned to a healthcare workflow task, such as routine, urgent, or emergent. Used to drive task routing, escalation rules, and response time expectations in clinical workflows including triage, prior authorization, and care management processes.

workflow versionwf_ver

The iteration or version number of a healthcare workflow record or process definition, used to track changes over time, manage concurrent updates, and maintain data integrity across clinical, administrative, and claims workflow systems within health information environments.

workflow zipwf_zip

The postal ZIP code associated with a healthcare workflow process, used to apply geographic routing logic, determine jurisdiction, calculate service area eligibility, or align tasks with regional care resources within clinical, administrative, and claims processing workflows.

write off addresswo_addr

The physical mailing or service address associated with a written-off account balance deemed uncollectible in revenue cycle management. Used in collections workflows to identify the last known contact location for the patient or responsible party tied to the bad debt transaction.

write off agewo_age

The age in years of the patient or responsible party associated with an uncollectible balance at the time the write-off was processed. Used in revenue cycle analytics to identify demographic patterns in bad debt and support collections prioritization within billing systems.

write off allowed amountwo_alwd_amt

The maximum reimbursable amount contractually permitted by the payer for a claim that has been subsequently written off as uncollectible. Used in revenue cycle reporting to reconcile contractual adjustments against actual bad debt write-offs in healthcare billing systems.

write off amountwo_amt

The specific dollar value of an account balance formally removed from accounts receivable after all collection efforts have been exhausted. Used in revenue cycle management to track bad debt expense, report financial losses, and reconcile general ledger entries in healthcare billing systems.

write off approval statuswo_appr_sts

The current authorization state of a write-off request within the revenue cycle workflow, indicating whether the uncollectible balance has been submitted, approved, denied, or is pending review. Used to enforce financial controls and audit trails in healthcare billing systems.

write off approved bywo_appr_by

The identifier or name of the authorized user, supervisor, or manager who approved the removal of an uncollectible balance from accounts receivable. Used in revenue cycle management to maintain accountability, audit trails, and compliance with financial write-off approval policies in healthcare billing systems.

write off arrival timewo_arrv_tm

The recorded time of patient arrival for the encounter associated with a balance that was subsequently written off as uncollectible. Used in revenue cycle analytics to correlate clinical visit data with bad debt outcomes and support retrospective billing reconciliation in healthcare systems.

write off arrived datewo_arrv_dt

The calendar date on which the patient arrived for the encounter whose associated balance was later written off as uncollectible. Used in revenue cycle management to link bad debt transactions back to the originating visit for financial reporting and audit purposes in healthcare billing systems.

write off assessmentwo_asmt

The clinical or financial evaluation associated with an encounter whose outstanding balance has been deemed uncollectible and written off. Used in revenue cycle workflows to link bad debt records back to the originating clinical documentation, supporting audits and denial management in healthcare billing systems.

write off balancewo_bal

The remaining outstanding dollar amount on a patient or guarantor account that has been identified as uncollectible and is pending or has been formally removed from accounts receivable. Used in revenue cycle management to track residual bad debt exposure and inform collection strategy in healthcare billing systems.

write off billed amountwo_bill_amt

The total charges originally invoiced to the payer or patient for services rendered on a claim that was subsequently written off as uncollectible. Used in revenue cycle analytics to measure the gross value of bad debt and compare billed charges against actual write-off amounts in healthcare billing systems.

PreviousPage 318 of 325Next