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 minimumwo_min

The lower threshold dollar amount defining the floor for write-off transactions within revenue cycle or accounts receivable workflows. Used to enforce financial controls, filter de minimis balances eligible for automatic write-off, and support tiered approval processes for uncollectible account management.

write off mobilewo_mob

The mobile phone number of the patient or guarantor associated with an uncollectible account balance at the time of write-off processing. Retained in patient accounting systems to support late-stage collections outreach, financial counseling contact attempts, and demographic completeness for bad debt records.

write off modified bywo_mod_by

The user identifier of the individual who last updated the write-off record within the revenue cycle or patient accounting system. Used to maintain a complete audit trail of changes to uncollectible balance transactions, supporting compliance reviews, dispute resolution, and internal financial controls.

write off modified datewo_mod_dt

The calendar date on which a write-off record was most recently updated in the revenue cycle or patient accounting system. Used to track changes to uncollectible balance transactions, support audit trail requirements, and identify records modified during reconciliation, appeals, or financial close processes.

write off modified timewo_mod_tm

The timestamp indicating when a write-off record was most recently updated in the revenue cycle or patient accounting system. Combined with the modified date and user identifier to provide a precise audit trail for changes to uncollectible balance transactions, supporting financial controls and compliance documentation.

write off namewo_nm

The descriptive label or name assigned to a write-off transaction or category within revenue cycle and patient accounting systems. Used to identify the type or reason for the uncollectible balance adjustment, supporting financial reporting, general ledger coding, and accounts receivable aging analysis.

write off numberwo_nbr

The unique reference number assigned to a write-off transaction within the revenue cycle or patient accounting system. Used to identify, track, and audit individual uncollectible balance adjustments across billing platforms, general ledger systems, and financial reporting workflows throughout the accounts receivable lifecycle.

write off onset datewo_onset_dt

The date on which the condition, service, or billing event that ultimately resulted in an uncollectible balance first originated. Used in revenue cycle analysis to measure the lag between service delivery and write-off, supporting bad debt trending, denial root cause analysis, and accounts receivable aging reporting.

write off oxygen saturationwo_o2sat

The blood oxygen level for a uncollectible amount. Used in healthcare data management and clinical workflows. 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 paid amountwo_pd_amt

The dollar amount actually received from the patient, guarantor, or payer against a balance that was subsequently written off as uncollectible. Used in revenue cycle reporting to calculate net bad debt exposure, assess collection effectiveness, and reconcile partial payments against the original billed amount.

write off paid datewo_pd_dt

The date on which a payment was received against an account that was subsequently or partially written off as uncollectible. Used in revenue cycle and patient accounting systems to reconcile payment history against write-off transactions and calculate the elapsed time between payment activity and bad debt determination.

write off parentwo_prnt

The parent account, encounter, or transaction record to which a write-off entry is subordinately linked within the revenue cycle or patient accounting system. Used to maintain hierarchical relationships between uncollectible balance adjustments and originating billing accounts, supporting consolidated financial reporting and audit reconciliation.

write off percentagewo_pct

The proportional rate, expressed as a percentage, representing the portion of a billed or expected balance that has been written off as uncollectible. Used in revenue cycle analytics to benchmark bad debt performance, calculate contractual adjustment ratios, and monitor write-off trends across payers, service lines, or time periods.

write off periodwo_prd

The defined accounting or fiscal time interval during which an uncollectible balance write-off transaction is recorded and reported. Used in revenue cycle and financial systems to align bad debt adjustments with monthly, quarterly, or annual close cycles, supporting accurate general ledger posting and period-over-period financial analysis.

write off phonewo_ph

The primary telephone number of the patient or guarantor associated with an uncollectible account balance at the time of write-off processing. Retained in patient accounting systems to document contact information for collections history, support potential future recovery efforts, and maintain complete demographic records for bad debt reporting.

write off preferred namewo_pref_nm

The standardized display label assigned to a write-off transaction in revenue cycle management. Used to present the write-off category in billing reports and accounts receivable dashboards, distinguishing between bad debt, contractual adjustments, and charity care write-offs.

write off pricewo_prc

The gross dollar amount of a balance deemed uncollectible and removed from accounts receivable in the revenue cycle. Captures the original billed charge or outstanding balance being written off, used in financial reconciliation and bad debt reporting across healthcare billing systems.

write off primary indicatorwo_prim_ind

A flag identifying whether a write-off transaction is the principal or primary adjustment applied to a claim or patient balance in the revenue cycle. Used to differentiate the main write-off entry from secondary or supplemental adjustments when multiple write-offs exist on a single account.

write off prioritywo_prty

The ranked order in which write-off transactions are processed or applied against an outstanding patient or payer balance during revenue cycle operations. Determines sequencing when multiple write-off types compete for application against a claim, such as contractual adjustments before bad debt designations.

write off pulsewo_pulse

The heart rate value for a uncollectible amount. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for write off management and reporting.

PreviousPage 322 of 325Next