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

Clinical

EHR, ICD-10, LOINC, SNOMED CT, patient care and clinical documentation

16,101 clinical terms

workflow history present illnesswf_hpi

Stores the structured or free-text narrative describing a patient's current condition as it relates to an active clinical workflow task. Provides contextual clinical background that informs care team decision-making, task prioritization, and documentation completeness within the workflow system.

workflow instructionwf_instr

Contains the procedural guidance text associated with a specific step in a clinical or administrative workflow sequence. Provides standardized directions to users performing the task, ensuring consistency in execution, reducing errors, and supporting training and compliance within healthcare operations.

workflow labelwf_lbl

Stores the human-readable display name assigned to a workflow task, step, or process category within the healthcare information system. Used to identify and differentiate workflow items in user interfaces, dashboards, and operational reports across clinical and administrative departments.

workflow notewf_nt

Captures free-text annotations or comments added by clinical or administrative staff during the execution of a workflow task. Documents decisions, exceptions, escalations, or status updates at individual process steps, providing an audit trail for care coordination and compliance review purposes.

workflow procedure datewf_proc_dt

Records the date on which a clinical procedure or treatment task was performed within an active workflow sequence. Used to align procedural events with workflow timelines, support claims processing accuracy, measure care delivery timeliness, and enable procedure-level performance reporting.

workflow rangewf_rng

Defines the acceptable minimum and maximum value boundaries for a measurable parameter within a clinical or administrative workflow step. Used to trigger validation rules, flag out-of-range results for review, and ensure data quality standards are met before a workflow task advances to the next stage.

workflow resultwf_rslt

Stores the output or outcome value produced upon completion of a clinical or administrative workflow step. May represent a test finding, approval decision, calculated score, or task status conclusion. Used to drive downstream routing logic, trigger alerts, and populate outcome reporting dashboards.

workflow routewf_rte

Defines the designated pathway or channel through which a clinical or administrative workflow task is directed after each processing step. Determines assignment queues, approval chains, and escalation paths based on task type, urgency, role, or outcome values within the workflow management system.

workflow surgery datewf_surg_dt

Records the scheduled or actual date on which a surgical procedure was performed as part of a clinical workflow sequence. Used to coordinate pre-operative and post-operative task routing, track surgical case timelines, and support perioperative reporting and resource utilization analysis.

write off active indicatorwo_actv_ind

A binary flag identifying whether a specific accounts receivable write-off record is currently active within the revenue cycle system. Used to filter active versus voided or reversed write-off transactions, ensuring accurate bad debt reporting, audit compliance, and financial reconciliation processes.

write off active statuswo_actv_sts

Captures the current lifecycle state of an accounts receivable write-off record within the revenue cycle management system. Status values may include active, pending, reversed, or closed, enabling finance teams to track write-off progression, manage bad debt workflows, and produce accurate aging reports.

write off admission datewo_admn_dt

Records the inpatient admission date associated with the original encounter for which an accounts receivable balance has been written off as uncollectible. Links the write-off transaction to its originating hospital stay, supporting bad debt analysis, payer performance reviews, and revenue cycle reconciliation reporting.

write off discharge datewo_dsch_dt

Records the inpatient discharge date associated with the encounter underlying an accounts receivable write-off transaction. Used to calculate the lag between service delivery and write-off decision, assess collection effort duration, and support revenue cycle performance analysis and payer contract evaluations.

write off durationwo_dur

Measures the elapsed time between the original account balance creation and the final write-off decision for an uncollectible receivable. Used in revenue cycle analytics to assess collection effectiveness, evaluate denial management timelines, benchmark bad debt aging, and optimize accounts receivable follow-up workflows.

write off emergency indicatorwo_emerg_ind

A binary flag indicating whether the original patient encounter associated with a write-off record involved emergency services. Used to segment bad debt portfolios by service type, analyze write-off patterns across emergency versus elective care, and support charity care and uncompensated care financial reporting.

write off history present illnesswo_hpi

Captures the clinical narrative describing the patient's presenting condition for the encounter that resulted in an uncollectible accounts receivable write-off. Retained for medical necessity documentation, audit defense, and retrospective review of write-off decisions in revenue cycle and compliance reporting contexts.

write off instructionwo_instr

Directional text guiding billing staff on how to process a write-off for an uncollectible balance in revenue cycle management. Specifies steps such as adjustment codes, authorization requirements, or payer-specific protocols for removing the amount from accounts receivable.

write off labelwo_lbl

Display text identifying the category or type of write-off applied to an uncollectible balance in billing and revenue cycle systems. Used in account statements, remittance reports, and financial dashboards to classify adjustments such as bad debt, contractual, or charity care write-offs.

write off notewo_nt

Free-text annotation entered by billing or collections staff documenting the reason an account balance was deemed uncollectible and written off. Captures context such as collection attempt history, payer denials, or financial hardship determinations for audit and compliance purposes.

write off procedure datewo_proc_dt

The date on which the formal write-off transaction was executed against an uncollectible balance in the revenue cycle system. Used in accounts receivable aging reports and financial audits to track when specific balances were removed from the collectible ledger.

PreviousPage 798 of 806Next