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 entered bywf_ent_by

The identifier of the user, system, or role that originally created or submitted a workflow record in a healthcare system. Used for audit trail purposes in care management, claims, and clinical documentation systems to establish accountability and support data quality reviews.

workflow ethnicitywf_ethn

The ethnicity classification of the patient or member associated with a healthcare workflow. Captured in care management and population health systems to support health equity reporting, culturally competent care coordination, and compliance with federal and state demographic data collection requirements.

workflow expiration datewf_exp_dt

The date after which a healthcare workflow, authorization, or process configuration is no longer valid for use. Used in prior authorization, credentialing, and care management systems to automatically retire outdated tasks, prevent processing against expired approvals, and prompt renewal actions.

workflow external identifierwf_ext_id

A reference identifier assigned by an external system, trading partner, or source application to a healthcare workflow record. Used to maintain traceability and enable reconciliation between internal processing platforms and external systems such as health information exchanges, payers, or vendor platforms.

workflow faxwf_fax

The facsimile number associated with a participant, facility, or contact involved in a healthcare workflow. Used in prior authorization, referral management, and care coordination processes to route documents and communications to clinical or administrative staff when electronic interfaces are unavailable.

workflow feewf_fee

The charge or cost amount associated with a specific healthcare workflow task or service activity. Used in administrative and financial processing systems to track fees tied to case management services, care coordination programs, or ancillary processes for billing, reporting, and cost allocation purposes.

workflow first namewf_first_nm

The given name of the patient, member, provider, or staff participant associated with a healthcare workflow record. Used to display and identify individuals in care management, prior authorization, and clinical task systems to ensure accurate assignment and person-level tracking across processes.

workflow flagwf_flg

A binary or coded indicator used to mark a specific condition, exception, or status on a healthcare workflow record. Used in claims, care management, and utilization review systems to signal priority handling, escalation needs, compliance requirements, or processing exceptions for routing and decision support.

workflow frequencywf_freq

The interval or recurrence schedule at which a healthcare workflow task, clinical activity, or care management touchpoint is performed. Used in chronic disease management, medication management, and care coordination programs to define how often interventions, assessments, or follow-up actions should occur for a patient.

workflow full namewf_full_nm

The complete concatenated name associated with a workflow instance, combining first, middle, and last name components. Used in healthcare task routing and care coordination systems to identify the patient, member, or clinician tied to a specific workflow process.

workflow genderwf_gndr

The sex or gender classification of the individual associated with a healthcare workflow instance. Used in clinical task routing, care management, and population health workflows to ensure gender-appropriate care protocols, screenings, and clinical decision support rules are applied correctly.

workflow glucosewf_gluc

The blood glucose measurement captured or referenced within a clinical workflow instance. Used in chronic disease management workflows, such as diabetes care coordination, to track lab values that trigger clinical tasks, alerts, or escalation pathways within care management systems.

workflow group numberwf_grp_nbr

The insurance group number associated with the member or patient linked to a healthcare workflow instance. Used in care management and utilization review workflows to connect workflow activity to the correct insurance benefit group for authorization, eligibility verification, and claims coordination.

workflow hemoglobinwf_hgb

The hemoglobin measurement captured or referenced within a clinical workflow instance. Used in chronic disease management and care coordination workflows, such as anemia or diabetes monitoring programs, to track lab values that trigger clinical tasks, care alerts, or escalation pathways.

workflow identifierwf_id

The unique system-generated or assigned identifier for a specific healthcare workflow instance. Used across care management, utilization review, and clinical operations platforms to track, reference, and audit individual workflow records throughout their lifecycle in the system.

workflow indexwf_idx

The positional sequence number assigned to a workflow instance within an ordered set or processing queue. Used in healthcare operations and care management systems to establish processing order, maintain workflow step sequences, and support batch processing of clinical or administrative tasks.

workflow indicatorwf_ind

A flag or boolean value that signals the current state, condition, or classification of a healthcare workflow instance. Used in care management and clinical operations systems to mark workflows as active, pending, completed, escalated, or requiring intervention based on defined business rules.

workflow keywf_key

The primary or surrogate key value used to uniquely identify and join a healthcare workflow record across tables or systems. Used in clinical data warehouses and care management platforms to support relational lookups, data integration, and cross-system workflow tracking and reporting.

workflow languagewf_lang

The preferred spoken or written communication language of the individual associated with a healthcare workflow instance. Used in care management and patient outreach workflows to ensure that clinical communications, care plans, and member correspondence are delivered in the appropriate language.

workflow last namewf_last_nm

The family surname of the patient, member, or clinician associated with a healthcare workflow instance. Used in care coordination and clinical operations systems to identify individuals linked to workflow tasks, support member searches, and display human-readable workflow records in care management platforms.

PreviousPage 314 of 325Next