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 scheduled datewf_sched_dt

The calendar date on which a healthcare workflow activity, such as a procedure, follow-up appointment, or review task, is planned to occur. Used in scheduling systems, care coordination workflows, and operational planning to manage capacity, staffing, and patient throughput.

workflow scheduled timewf_sched_tm

The specific time of day at which a healthcare workflow activity, such as a clinical procedure, care team review, or administrative task, is planned to begin. Used alongside scheduled date to manage appointment slots, resource allocation, and workflow queue sequencing in clinical and operational systems.

workflow scorewf_scr

A numeric value calculated or assigned at a workflow step to represent clinical, financial, or operational performance, such as a risk score, quality metric, or compliance score. Used to drive routing decisions, trigger alerts, and support benchmarking and reporting in care management and administrative workflows.

workflow sequencewf_seq

A numeric or alphanumeric value indicating the ordered position of a task, step, or record within a healthcare workflow. Used to enforce processing order, manage dependencies between workflow stages, and ensure correct execution of clinical protocols, claims adjudication steps, and administrative procedures.

workflow severitywf_sev

A coded or categorical rating indicating the clinical or operational seriousness of a condition, issue, or task within a healthcare workflow, such as a diagnosis severity level or incident priority. Used to route cases appropriately, trigger escalation protocols, and support risk-adjusted reporting in care management workflows.

workflow sexwf_sex

The patient's biological sex as recorded within a clinical or administrative workflow step, distinct from gender identity. Used for clinical decision support, dosing calculations, eligibility determinations, and compliance with demographic data collection standards in care management and claims workflows.

workflow sourcewf_src

The originating system, channel, or entity from which a healthcare workflow record or task was initiated, such as an EDI transaction, provider portal submission, or internal referral. Used for data lineage tracking, routing logic, and performance reporting across claims, authorization, and care management workflows.

workflow start datewf_start_dt

The calendar date on which a healthcare workflow, episode of care, authorization period, or administrative process formally begins. Used to calculate durations, enforce regulatory timeframes, track benefit periods, and measure compliance with service level agreements across clinical and operational workflows.

workflow start timewf_start_tm

The specific time of day at which a healthcare workflow activity, such as a clinical procedure, care team task, or system processing job, formally begins. Used alongside start date to calculate elapsed durations, enforce time-sensitive clinical protocols, and measure operational throughput and efficiency.

workflow statewf_st

The geographic state or province associated with a healthcare workflow process, used to apply jurisdiction-specific rules, routing logic, or compliance requirements across clinical, administrative, or claims processing workflows within health information systems.

workflow statuswf_sts

The current operational state of a healthcare workflow instance, such as pending, in-progress, completed, or cancelled. Tracks progression through clinical or administrative process stages including prior authorizations, referrals, claims adjudication, and care management tasks.

workflow street addresswf_st_addr

The physical street address associated with a healthcare workflow process, used to route tasks, correspondence, or services to the correct facility, department, or member location within clinical, administrative, or claims processing workflows.

workflow strengthwf_str

The drug concentration or dosage strength associated with a medication-related healthcare workflow, such as pharmacy dispensing, medication reconciliation, or prior authorization processes. Expressed in units such as mg, mcg, or mg/mL to ensure accurate medication handling.

workflow subtotalwf_subtot

An intermediate calculated sum within a healthcare workflow process, representing a partial aggregation of costs, units, or counts prior to final totaling. Used in claims adjudication, billing reconciliation, and care management reporting to validate incremental financial or utilization data.

workflow targetwf_tgt

The designated destination, goal, or reference entity within a healthcare workflow process, such as a target department, care team, facility, or performance threshold. Used to direct task routing, escalation, or outcome measurement in clinical and administrative workflows.

workflow taxonomy codewf_tax_cd

The NUCC Health Care Provider Taxonomy code associated with a workflow process, identifying the provider specialty or credential type relevant to task routing, credentialing, prior authorization, or claims processing workflows within healthcare information systems.

workflow temperaturewf_temp

The body temperature measurement captured or referenced within a clinical workflow process, such as triage, patient monitoring, or care escalation. Recorded in Fahrenheit or Celsius and used to trigger clinical decision rules, alerts, or care pathway transitions within EHR workflows.

workflow termination datewf_term_dt

The date on which a healthcare workflow process is formally ended, closed, or deactivated. Used to track the lifecycle completion of clinical tasks, administrative processes, authorization periods, or care management episodes within health information systems.

workflow timewf_tm

The specific time of day associated with a healthcare workflow event or task, used to sequence clinical or administrative activities, enforce service level agreements, and support audit trails within EHR, claims, and care management systems.

workflow timestampwf_ts

The combined date and time value recorded when a healthcare workflow event occurs, such as task creation, status change, or completion. Provides a precise audit trail for clinical, administrative, and claims processes, supporting compliance, sequencing, and performance measurement.

PreviousPage 317 of 325Next