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

statement death datestmt_death_dt

The recorded date of death associated with a patient account when generating final billing statements. Used in revenue cycle management to halt future statement cycles, notify payers of patient death, and initiate estate billing processes for outstanding balances.

statement deleted datestmt_del_dt

The date on which a patient billing statement record was marked as deleted or removed from active processing within the revenue cycle system. Used for audit trail maintenance and to track when account summaries were voided or retracted.

statement deleted indicatorstmt_del_ind

A flag denoting that a patient billing statement has been logically removed from active revenue cycle processing. Enables soft-delete functionality in billing systems, preserving the historical record while excluding the statement from current account balance calculations.

statement descriptionstmt_desc

A human-readable textual explanation of a patient billing statement, summarizing the nature of charges, services rendered, or account balance details. Displayed on printed or electronic statements to help guarantors understand the content of their account summary.

statement detailstmt_dtl

Granular line-item information included within a patient billing statement, capturing individual charges, payments, adjustments, and service descriptions. Provides the itemized breakdown of an account summary used in revenue cycle management for transparency and dispute resolution.

statement due datestmt_due_dt

The payment deadline date by which a patient or guarantor must remit payment for charges listed on a billing statement. Used in patient accounting systems to trigger collection workflows, assess late fees, and track outstanding balances in revenue cycle management.

statement effective datestmt_eff_dt

The date on which a patient billing statement becomes active and charges are considered valid for payment processing. Used in revenue cycle systems to establish the billing period start, coordinate with insurance adjudication timelines, and manage patient financial responsibility workflows.

statement emailstmt_eml

The electronic mail address associated with a patient or guarantor account used to deliver electronic billing statements. Captured in patient financial systems to support paperless billing preferences, payment portal communications, and digital delivery of itemized charges and remittance notices.

statement end datestmt_end_dt

The closing date of the billing period covered by a patient financial statement, marking the final date for which charges, payments, and adjustments are included. Used in revenue cycle systems to define statement cycles and reconcile account activity within a defined billing window.

statement end timestmt_end_tm

The precise timestamp marking the end of the billing period captured in a patient financial statement. Used in revenue cycle and patient accounting systems to define exact billing cycle boundaries, support audit trails, and ensure accurate charge capture cutoffs within a given statement period.

statement entered bystmt_ent_by

The user identifier of the staff member or system process responsible for creating or posting a patient billing statement in the revenue cycle system. Used for audit tracking, accountability, and quality review of billing activities within patient financial services and accounts receivable workflows.

statement ethnicitystmt_ethn

The self-reported or administratively recorded ethnicity of the patient or guarantor associated with a billing statement. Used in healthcare financial and demographic reporting to support equity analysis, comply with federal reporting requirements, and monitor disparities in billing and collections outcomes across patient populations.

statement expiration datestmt_exp_dt

The date after which a patient billing statement is no longer considered valid for payment processing or financial obligation under current terms. Used in revenue cycle management to trigger account escalation, write-off evaluations, or collections referrals when statements remain unpaid beyond the defined validity window.

statement external identifierstmt_ext_id

A reference identifier assigned by an external system, clearinghouse, or billing vendor to uniquely identify a patient billing statement outside of the originating patient accounting system. Used to reconcile statement activity, match remittances, and track billing records across revenue cycle and third-party financial platforms.

statement faxstmt_fax

The facsimile number associated with a patient, guarantor, or facility account used to transmit billing statements and financial correspondence. Stored in patient financial systems to support alternative delivery methods for billing communications, especially for accounts requiring paper-based or institutional statement distribution.

statement feestmt_fee

The monetary charge associated with generating and distributing a patient billing statement, or a specific fee line item appearing on a patient financial statement. Used in revenue cycle systems to capture administrative billing costs, track service charges, and report total patient financial responsibility on account summaries.

statement first namestmt_first_nm

The given name of the patient or guarantor to whom a billing statement is addressed. Used in patient financial systems to personalize statement correspondence, verify account holder identity, and ensure accurate routing of billing communications during the revenue cycle billing and collections process.

statement flagstmt_flg

A binary or coded indicator applied to a patient billing statement to denote a specific processing status, such as suppressed, held, returned, or sent to collections. Used in revenue cycle systems to control statement workflow routing, identify accounts requiring special handling, and support targeted follow-up in patient financial services.

statement full namestmt_full_nm

The complete name of the patient or guarantor as it appears on a billing statement, combining first, middle, and last name components. Used in patient financial systems to ensure accurate addressee identification on printed and electronic statements, supporting proper delivery and legal documentation in revenue cycle workflows.

statement genderstmt_gndr

The gender identity or sex designation recorded for the patient or guarantor associated with a billing statement. Used in patient financial and demographic systems to support accurate account identification, comply with reporting standards, and analyze billing equity across gender categories within revenue cycle operations.

PreviousPage 250 of 325Next