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

write off datetimewo_dttm

The combined date and time value capturing the precise moment an uncollectible balance was written off in the accounts receivable system. Supports exact sequencing of write off transactions, system reconciliation, and detailed audit trail requirements in revenue cycle and financial close processes.

write off dea numberwo_dea_nbr

The Drug Enforcement Administration registration number associated with a prescriber or pharmacy linked to a write off transaction. Relevant in pharmacy billing contexts where controlled substance claims result in uncollectible balances, enabling regulatory cross-referencing and audit compliance during write off review.

write off death datewo_death_dt

The date of death for a uncollectible amount. Used to track temporal information related to write off death date. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for write off management and reporting.

write off deleted datewo_del_dt

The date on which a write off record was marked as deleted or voided in the billing system, indicating a reversal or correction of a previously posted uncollectible balance adjustment. Used in revenue cycle auditing to track write off reversals, reactivated accounts receivable balances, and system data cleanup activities.

write off deleted indicatorwo_del_ind

A flag identifying that a write off record has been voided, reversed, or logically removed from active accounts receivable processing. Allows billing systems to retain historical write off records for audit purposes while excluding deleted transactions from current bad debt reporting and financial reconciliation workflows.

write off descriptionwo_desc

A human-readable textual explanation categorizing or summarizing the reason an account balance was deemed uncollectible and written off. Common values include bad debt, contractual adjustment, charity care, or bankruptcy, supporting revenue cycle reporting, denial analysis, and financial statement footnote disclosures.

write off detailwo_dtl

Granular line-item information associated with a write off transaction, including specific charge codes, service dates, payer details, and adjustment amounts applied to individual claim lines. Supports precise accounts receivable reconciliation, payer-level bad debt analysis, and detailed auditing of uncollectible balance dispositions in revenue cycle management.

write off due datewo_due_dt

The original payment deadline associated with a balance before it was escalated to write off status in the billing system. Used in revenue cycle analysis to calculate the elapsed time between payment due and write off decision, supporting aging bucket reporting and evaluation of collection policy effectiveness.

write off effective datewo_eff_dt

The date from which a write off adjustment is considered active and applied to the patient or payer account balance in the billing system. Determines the financial period in which the uncollectible amount impacts accounts receivable and bad debt expense, which is critical for accurate period-end revenue cycle reporting.

write off emailwo_eml

The electronic mail address associated with the responsible party, guarantor, or contact linked to a write off account in the billing system. Used to document communication attempts made prior to write off determination and to support correspondence records in patient financial services and collections workflows.

write off end datewo_end_dt

The date marking the conclusion of the write off period or the expiration of a write off authorization in the billing system. Used in revenue cycle management to define the timeframe over which an uncollectible balance adjustment remains valid, supporting periodic bad debt reviews and accounts receivable reconciliation processes.

write off end timewo_end_tm

The specific time at which a write off transaction or authorization period concluded in the accounts receivable system. Used alongside the end date to precisely define the closing boundary of a write off event, supporting accurate audit logging, system reconciliation, and revenue cycle workflow sequencing for uncollectible balance processing.

write off entered bywo_ent_by

Identifies the user who recorded a balance write-off transaction in the revenue cycle system. Captures the staff member or automated process responsible for designating an uncollectible amount, supporting audit trails and accountability in accounts receivable management.

write off ethnicitywo_ethn

Records the ethnicity of the patient or account holder associated with a write-off transaction. Used in revenue cycle analytics to identify demographic patterns in uncollectible balances, supporting health equity reporting and financial assistance program evaluation across patient populations.

write off expiration datewo_exp_dt

Captures the date on which a write-off designation or related financial arrangement expires in the revenue cycle system. Used to manage time-limited adjustments, charity care approvals, or payment plans that affect how uncollectible balances are tracked and reported.

write off external identifierwo_ext_id

Stores the reference identifier assigned by an external system, such as a collections agency, EHR, or billing platform, to a write-off transaction. Enables cross-system reconciliation and tracking of uncollectible balances across revenue cycle and financial management platforms.

write off faxwo_fax

Records the fax number associated with the entity or account linked to a write-off transaction. Used in revenue cycle workflows to facilitate communication with patients, guarantors, or third-party collections agencies regarding uncollectible balance notifications and documentation requests.

write off feewo_fee

Captures the specific charge amount designated as uncollectible and written off from an account balance in the revenue cycle system. Reflects the dollar value of a service charge that has been removed from active collections after exhausting standard billing and payment recovery efforts.

write off first namewo_first_nm

Records the given name of the patient, guarantor, or account holder associated with a write-off transaction. Used in revenue cycle reporting and collections workflows to identify individuals linked to uncollectible balances and to personalize financial correspondence.

write off flagwo_flg

A binary indicator that marks an account, claim line, or balance as having been written off in the revenue cycle system. Used to filter uncollectible amounts from active accounts receivable reporting, preventing further billing activity on designated amounts while retaining the record for audit purposes.

PreviousPage 320 of 325Next