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

task end timetsk_end_tm

Timestamp recording the exact time a workflow task was completed or closed in care management or clinical operations systems. Combined with task start time to calculate precise duration metrics, support productivity analysis, and document completion within required regulatory or contractual response windows.

task entered bytsk_ent_by

Identifier of the user account or staff member who created and submitted a workflow task into the care management or clinical operations system. Supports accountability tracking, audit trail documentation, and workload attribution reporting across care coordination and utilization management teams.

task ethnicitytsk_ethn

Ethnicity classification of the member or patient associated with a care management workflow task. Captured to support health equity reporting, population stratification, and culturally appropriate outreach coordination within care management and chronic disease management programs.

task expiration datetsk_exp_dt

Calendar date after which a workflow task is no longer valid or actionable within care management or utilization review systems. Tasks reaching expiration without completion may trigger escalation workflows, compliance alerts, or supervisor review processes to address unresolved work items.

task external identifiertsk_ext_id

Unique reference identifier assigned to a workflow task by an external system, such as a vendor platform, claims system, or partner organization. Enables cross-system task tracking, reconciliation between care management and claims platforms, and interoperability with third-party healthcare workflow applications.

task faxtsk_fax

Facsimile number associated with a workflow task in care management or utilization review systems, used to route clinical documentation, prior authorization requests, or correspondence to the appropriate provider office, facility, or external contact required to fulfill the task.

task feetsk_fee

Monetary amount associated with completing a workflow task in care management or vendor-managed clinical operations systems. May represent a contracted service fee for outsourced task completion, an incentive payment for care coordination activities, or a billable charge tied to task-based service delivery.

task first nametsk_first_nm

Given name of the member, patient, or staff contact associated with a care management workflow task. Used to identify the individual linked to the task for outreach, case coordination, or escalation purposes within care management and disease management program workflows.

task flagtsk_flg

Binary or coded indicator used to mark a workflow task with a specific status, priority level, or exception condition in care management or clinical operations systems. Common flags identify tasks requiring escalation, supervisor review, regulatory compliance action, or urgent clinical follow-up.

task frequencytsk_freq

Defined recurrence interval specifying how often a workflow task should be generated or repeated within care management or clinical operations systems. Governs scheduled outreach cadences, recurring authorization reviews, periodic member assessments, and other time-based care management activities.

task full nametsk_full_nm

Complete concatenated name of the member, patient, or contact associated with a care management workflow task, combining first, middle, and last name elements. Used for display in worklists, correspondence generation, and member identification across care coordination and utilization management systems.

task gendertsk_gndr

Gender classification of the member or patient linked to a care management workflow task. Captured to support clinically appropriate outreach, gender-specific care gap identification, health equity analytics, and population health stratification within care management and chronic disease management programs.

task glucosetsk_gluc

The blood glucose measurement recorded in association with a clinical workflow task, capturing the patient's blood sugar level at the time of task creation or completion. Used in care management and chronic disease monitoring workflows to track glycemic values tied to specific clinical actions.

task group numbertsk_grp_nbr

The insurance group number associated with a workflow task, linking the work item to a specific employer or subscriber group plan. Used in claims processing and care management systems to ensure task routing and resolution are aligned with the correct coverage group and payer contract.

task hemoglobintsk_hgb

The hemoglobin laboratory value recorded in association with a clinical workflow task, capturing the patient's hemoglobin level at the time of task creation or completion. Used in care management and utilization review workflows to track hematologic values tied to specific clinical actions or interventions.

task identifiertsk_id

The system-generated or assigned unique identifier for a discrete workflow task within a care management, utilization review, or clinical operations platform. Serves as the primary key for tracking, auditing, and linking task records across integrated healthcare systems and reporting tools.

task indextsk_idx

The sequential or ordinal position number assigned to a workflow task within a queue, batch, or task list. Used in care management and clinical operations systems to maintain processing order, support priority ranking, and enable efficient retrieval and display of task records.

task indicatortsk_ind

A flag or boolean value denoting a specific condition, status, or classification of a workflow task, such as urgency, escalation, or completion state. Used in care management and clinical operations systems to filter, route, and report on tasks based on defined business rules and workflow criteria.

task keytsk_key

The primary or surrogate key value used to uniquely identify and retrieve a workflow task record within a healthcare data system. Functions as the core lookup reference for joining task data across care management, utilization review, and clinical operations tables in downstream reporting and analytics.

task languagetsk_lang

The preferred spoken or written language associated with the member, patient, or subject of a workflow task. Used in care management and outreach platforms to ensure communications, documentation, and interventions are delivered in the appropriate language to support health equity and regulatory compliance.

PreviousPage 268 of 325Next