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 frequencywo_freq

Captures how often write-off transactions occur for a given account, payer, or service category within the revenue cycle system. Used in financial analytics to identify recurring uncollectible balance patterns, evaluate collection effectiveness, and inform denial management or charity care policy decisions.

write off full namewo_full_nm

Stores the complete name of the patient, guarantor, or responsible party associated with a write-off transaction. Used in revenue cycle workflows and financial reporting to provide a human-readable identifier for accounts where balances have been designated as uncollectible.

write off genderwo_gndr

Records the gender of the patient or account holder associated with a write-off transaction. Used in revenue cycle analytics and health equity reporting to identify demographic trends in uncollectible balances and evaluate the equitable application of financial assistance and charity care programs.

write off glucosewo_gluc

The blood sugar 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 group numberwo_grp_nbr

Stores the insurance group number linked to the account or claim at the time a balance was written off. Used in revenue cycle analysis to track uncollectible amounts by payer group, identify coverage gaps, and assess the financial impact of specific insurance plans on bad debt outcomes.

write off hemoglobinwo_hgb

The blood hemoglobin 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 identifierwo_id

The unique system-generated or assigned identifier for a specific write-off transaction in the revenue cycle system. Used to distinctly reference, track, and audit individual uncollectible balance adjustments across billing, financial reporting, and accounts receivable management workflows.

write off indexwo_idx

A numeric position or sequence value assigned to a write-off transaction within a set of related financial records in the revenue cycle system. Used to order, reference, and process multiple write-off entries associated with a single account, claim, or billing encounter.

write off indicatorwo_ind

A coded field that signals whether a specific balance, claim line, or account has been designated as uncollectible within the revenue cycle system. Used to distinguish written-off amounts from active receivables in financial reporting, payer analysis, and accounts receivable aging workflows.

write off keywo_key

A system lookup or surrogate key value used to uniquely reference a write-off record within the revenue cycle data environment. Supports relational joins and data retrieval across financial tables, enabling efficient querying of uncollectible balance transactions in reporting and analytics systems.

write off languagewo_lang

Records the preferred communication language of the patient or guarantor associated with a write-off account. Used in revenue cycle workflows to ensure financial correspondence regarding uncollectible balances, charity care determinations, and collections notices are delivered in the appropriate language.

write off last namewo_last_nm

Stores the family surname of the patient, guarantor, or responsible party linked to a write-off transaction. Used in revenue cycle reporting, collections workflows, and audit processes to identify and distinguish individuals associated with uncollectible balance adjustments in the billing system.

write off legal namewo_legal_nm

Captures the officially registered name of the patient, guarantor, or entity associated with a write-off transaction. Used in revenue cycle and legal workflows to ensure accurate identification on formal documentation, such as charity care agreements, debt forgiveness notices, or collections legal proceedings.

write off levelwo_lvl

Indicates the hierarchical tier at which a write-off transaction is applied within the revenue cycle system, such as claim line, encounter, account, or guarantor level. Used to classify the scope of uncollectible balance adjustments and support accurate financial reporting across billing hierarchies.

write off license numberwo_lic_nbr

The professional license number associated with the rendering or billing provider linked to an uncollectible account balance. Used in revenue cycle management to track write-off accountability, support audit trails, and comply with regulatory reporting requirements for bad debt reconciliation.

write off marital statuswo_mar_sts

The marital status of the patient or guarantor associated with an uncollectible account balance at the time of write-off processing. Captured in revenue cycle systems to support demographic analysis, collections segmentation, and financial assistance eligibility determinations for bad debt accounts.

write off master identifierwo_mstr_id

The enterprise master patient or account identifier assigned to an uncollectible balance record, enabling cross-system linkage within revenue cycle and financial systems. Used to reconcile write-off transactions against the originating claim, encounter, or billing account across disparate healthcare platforms.

write off maximumwo_max

The upper threshold dollar amount permitted for a write-off transaction within revenue cycle or accounts receivable workflows. Used to enforce financial controls, trigger approval routing for high-value uncollectible balances, and support compliance with organizational write-off authorization policies.

write off medical record numberwo_mrn

The unique patient medical record number linked to an uncollectible account balance being written off. Used in revenue cycle and patient accounting systems to tie the write-off transaction back to the originating clinical encounter, supporting audit trails and bad debt analysis by patient.

write off middle namewo_mid_nm

The middle name or initial of the patient or guarantor associated with an uncollectible account balance. Captured in patient accounting systems to support accurate identity matching, distinguish between patients with similar names, and maintain complete demographic records for write-off documentation and collections history.

PreviousPage 321 of 325Next