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 cancelled datestmt_cncl_dt

The date on which a patient financial statement was voided or withdrawn from the billing cycle. Used in revenue cycle tracking to document when a statement was cancelled due to reasons such as insurance reprocessing, account adjustments, or patient account corrections, and to maintain an accurate billing audit trail.

statement categorystmt_cat

The classification type assigned to a patient financial statement, such as self-pay, insurance balance, or guarantor billing. Used in revenue cycle segmentation to route statements through appropriate collection workflows, apply correct fee schedules, and generate category-specific financial performance reports.

statement charge amountstmt_chrg_amt

The gross billed dollar amount for services rendered that appears on a patient financial statement before insurance payments, contractual adjustments, or write-offs are applied. Used in revenue cycle management as the starting point for adjudication calculations and as a benchmark for evaluating payer reimbursement rates.

statement chief complaintstmt_cc

The primary symptom or reason for the clinical visit documented on the encounter associated with a patient financial statement. Used in revenue cycle operations to support medical necessity review, validate diagnosis coding on claims, and ensure that billed services align with the presenting condition recorded in clinical documentation.

statement childstmt_chld

A subordinate financial statement linked to a parent account summary, representing a line-item charge, secondary encounter, or dependent transaction within a hierarchical billing structure. Used in revenue cycle systems to associate individual service charges with a consolidated patient account for reporting and collections management.

statement citystmt_city

The municipality name associated with a patient billing statement, used to identify the city portion of the statement mailing address. Supports accurate delivery of account summaries and financial correspondence in revenue cycle management systems.

statement classstmt_cls

The classification tier assigned to a patient billing statement, categorizing the account summary by statement type such as guarantor, insurance, or self-pay. Drives billing workflow routing and financial reporting in revenue cycle management systems.

statement codestmt_cd

The standardized code value assigned to a patient billing statement, used to identify statement type, billing cycle, or processing category. Enables consistent tracking and classification of account summaries across revenue cycle and patient financial services systems.

statement commentstmt_cmt

Free-text notation attached to a patient billing statement, capturing supplementary information from billing staff regarding account status, payment arrangements, or special handling instructions within revenue cycle management systems.

statement completed datestmt_cmpl_dt

The date on which a patient billing statement was fully processed and finalized for delivery. Used in revenue cycle management to track statement cycle completion, measure billing timeliness, and audit account summary generation workflows.

statement confidential indicatorstmt_conf_ind

A flag indicating that a patient billing statement contains sensitive information requiring restricted access or special handling. Supports privacy compliance in revenue cycle systems by controlling which staff or systems can view or process the account summary.

statement countstmt_cnt

The total number of billing statements generated for a patient account within a defined period or billing cycle. Used in revenue cycle management to track statement frequency, identify accounts with repeated balances, and monitor collection activity.

statement countrystmt_ctry

The country associated with the mailing address on a patient billing statement, identifying the nation for international or cross-border account correspondence. Ensures accurate address formatting and postal routing in revenue cycle management systems.

statement created bystmt_crtd_by

The identifier of the user or system process that generated a patient billing statement. Used for audit trail purposes in revenue cycle management, enabling traceability of account summary creation to specific staff members or automated billing workflows.

statement created datestmt_crtd_dt

The calendar date on which a patient billing statement record was initially generated in the revenue cycle system. Used to track billing cycle timing, measure days to statement issuance, and support audit and reconciliation of account summary records.

statement created timestmt_crtd_tm

The timestamp recording the exact time a patient billing statement was generated in the revenue cycle system. Combined with the created date, enables precise audit trail tracking and sequencing of account summary generation in billing workflows.

statement creatininestmt_cr

The creatinine laboratory value documented in association with a clinical statement or patient record, reflecting kidney function as measured in serum or urine. Used in clinical data systems to track renal health markers and inform care decisions.

statement datestmt_dt

The calendar date assigned to a patient billing statement, representing when the account summary was issued to the guarantor or payer. Used in revenue cycle management to define billing cycles, calculate payment due dates, and track outstanding balances.

statement datetimestmt_dttm

The combined date and time value recorded for a patient billing statement event, capturing the precise moment of statement generation or transmission. Supports detailed audit logging and chronological sequencing in revenue cycle management systems.

statement dea numberstmt_dea_nbr

The Drug Enforcement Administration registration number associated with a billing statement, typically referencing the prescribing provider for controlled substance claims. Used in pharmacy and revenue cycle systems to validate prescriber authorization and support regulatory compliance.

PreviousPage 249 of 325Next