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 legal namewf_legal_nm

The officially registered legal name of the individual associated with a healthcare workflow instance. Used in care management, enrollment, and clinical operations systems where legal identity must be confirmed, such as prior authorization requests, credentialing workflows, or member identity verification processes.

workflow levelwf_lvl

The hierarchical tier or classification level assigned to a healthcare workflow instance. Used in care management and utilization review systems to determine workflow priority, escalation paths, and routing rules based on clinical complexity, acuity, or organizational hierarchy within a care management program.

workflow license numberwf_lic_nbr

The professional state or regulatory license number of the clinician or healthcare professional associated with a workflow instance. Used in credentialing, provider management, and clinical operations workflows to verify licensure status and ensure qualified practitioners are assigned to clinical workflow tasks.

workflow marital statuswf_mar_sts

The marital or domestic relationship status of the patient or member associated with a healthcare workflow instance. Used in care management and social determinants of health workflows to inform care planning, identify support systems, and ensure accurate member demographic data is applied to care coordination activities.

workflow master identifierwf_mstr_id

The enterprise master patient or member identifier linked to a healthcare workflow instance, typically sourced from a Master Patient Index or Enterprise Master Person Index. Used to reconcile workflow records across disparate systems and ensure consistent identity resolution throughout care management operations.

workflow maximumwf_max

The upper threshold or maximum allowable value defined for a parameter within a healthcare workflow instance. Used in clinical decision support, care management, and utilization review workflows to establish value boundaries that trigger alerts, escalations, or workflow branching logic when exceeded.

workflow medical record numberwf_mrn

The medical record number of the patient associated with a healthcare workflow instance, assigned by the treating facility or health system. Used in care coordination and clinical operations workflows to link workflow activity directly to the patient's medical record for clinical context and documentation purposes.

workflow middle namewf_mid_nm

The middle name or initial of the patient, member, or clinician associated with a healthcare workflow instance. Used in care management and clinical operations systems to support accurate identity matching, distinguish individuals with similar names, and display complete name information within workflow records.

workflow minimumwf_min

The lower threshold or minimum allowable value defined for a parameter within a healthcare workflow instance. Used in clinical decision support, care management, and utilization review workflows to establish value boundaries that trigger alerts, escalations, or workflow branching logic when values fall below acceptable ranges.

workflow mobilewf_mob

The mobile phone number associated with a healthcare workflow task or process step, used to contact the assigned staff member, patient, or care coordinator responsible for completing or monitoring the workflow activity in clinical or administrative systems.

workflow modified bywf_mod_by

The unique identifier of the user who last updated a healthcare workflow record, supporting audit trail requirements and accountability tracking across clinical, administrative, or operational process management systems such as care management platforms or EHR task modules.

workflow modified datewf_mod_dt

The calendar date on which a healthcare workflow record was most recently updated, used to track changes over time, support audit compliance, and sequence workflow events within clinical operations, care management, or administrative process management systems.

workflow modified timewf_mod_tm

The timestamp indicating the exact time a healthcare workflow record was last updated, providing granular audit trail detail that complements the modified date field and supports chronological sequencing of workflow changes in clinical or administrative systems.

workflow namewf_nm

The human-readable label assigned to a specific healthcare workflow, identifying the type of clinical or administrative process such as prior authorization, care gap outreach, or discharge planning, used for display, routing, and reporting within workflow management systems.

workflow numberwf_nbr

The unique numeric identifier assigned to a specific healthcare workflow instance, enabling consistent tracking and cross-system referencing of clinical or administrative process tasks such as referrals, authorizations, or care coordination activities throughout their lifecycle.

workflow onset datewf_onset_dt

The date on which the clinical condition, event, or triggering circumstance associated with a healthcare workflow first began, used to establish clinical timelines, prioritize interventions, and measure response time in care management or utilization management workflows.

workflow oxygen saturationwf_o2sat

The peripheral blood oxygen saturation (SpO2) measurement captured as part of a clinical workflow, typically recorded during triage, remote patient monitoring, or care management assessments to assess respiratory status and guide clinical decision-making or escalation protocols.

workflow paid amountwf_pd_amt

The dollar amount paid in connection with a healthcare workflow transaction, such as an approved claim or authorization payment, used to track financial outcomes associated with utilization management, claims adjudication, or care coordination workflows within payer or provider systems.

workflow paid datewf_pd_dt

The date on which payment was issued for a healthcare workflow-related financial transaction, such as a claims payment or vendor reimbursement, used to reconcile financial records and measure payment cycle timelines within revenue cycle or payer operations systems.

workflow parentwf_prnt

The identifier of the higher-level workflow to which a subordinate workflow task or subprocess belongs, establishing hierarchical relationships within complex clinical or administrative process structures such as multi-step care management programs or nested authorization workflows.

PreviousPage 315 of 325Next