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

standard timestampstd_ts

The combined date and time value recorded when a standardized clinical event, administrative transaction, or data exchange occurred. Used in HL7 messages, claims audit trails, and interoperability logs to establish an authoritative chronological record for regulatory compliance and data reconciliation.

standard titlestd_ttl

The official name or formal designation assigned to a standardized clinical protocol, coding guideline, quality measure, or administrative policy. Used in clinical decision support libraries, regulatory submissions, and data governance catalogs to uniquely identify and reference the standard by its recognized label.

standard totalstd_tot

The complete aggregated monetary or numeric amount calculated across all standardized line items within a claim, remittance advice, or financial report. Used in claims adjudication, EOB generation, and revenue cycle reporting to represent the final summed value after all charges, adjustments, and benefits are applied.

standard total countstd_tot_cnt

The cumulative number of records, events, or occurrences meeting the criteria of a standardized definition within a reporting period. Used in quality measure reporting, utilization management, and population health analytics to quantify how many instances satisfy a given clinical or administrative standard.

standard typestd_typ

A categorical classification that identifies the kind or category of an established healthcare standard, such as clinical, administrative, financial, or interoperability. Used in data governance, claims processing, and regulatory reporting to distinguish between coding standards, transaction sets, and clinical guidelines.

standard unitstd_unt

The unit of measure associated with a clinical or administrative standard, such as dosage units, time increments, or quantity thresholds. Used in care protocols and formulary management to define the base measure against which compliance or usage is evaluated.

standard updated datestd_upd_dt

The most recent date on which a clinical or administrative standard was modified, such as a clinical guideline, formulary rule, or coding policy. Used in version control workflows to ensure downstream systems and users are applying the current iteration of the standard.

standard urgencystd_urg

The time sensitivity classification assigned to a clinical or administrative standard, indicating how quickly it must be applied or acted upon. Used in care management and utilization review workflows to prioritize adherence activities based on clinical risk or regulatory deadlines.

standard versionstd_ver

The sequential version number assigned to a clinical or administrative standard, such as a care protocol, coding guideline, or formulary policy. Used in data governance and compliance tracking to identify which iteration of the standard was active at the time a transaction or decision was made.

standard zipstd_zip

The five-digit or nine-digit postal code associated with a clinical or administrative standard's applicable geographic region. Used in network adequacy assessments, regional policy enforcement, and geographic-based rule sets to determine jurisdiction-specific standard applicability.

statement addressstmt_addr

The mailing or billing address to which a patient financial statement is sent. Used in revenue cycle management to ensure billing communications reach the responsible party, and to support returned mail workflows, collections processing, and patient account reconciliation.

statement agestmt_age

The number of days or billing cycles elapsed since a patient financial statement was first issued without full resolution. Used in accounts receivable aging analysis to prioritize collection efforts, identify delinquent balances, and assess revenue cycle performance across payer and self-pay accounts.

statement allowed amountstmt_alwd_amt

The maximum dollar amount a payer has contractually agreed to reimburse for services reflected on a patient financial statement. Used in revenue cycle reconciliation to calculate patient responsibility after payer adjudication, and to validate that billed charges do not exceed contracted rates.

statement amountstmt_amt

The total dollar amount reflected on a patient financial statement issued for services rendered. Used in revenue cycle management to communicate the outstanding balance owed by the patient or guarantor after insurance adjudication, payments, and adjustments have been applied.

statement approval statusstmt_appr_sts

The current authorization state of a patient financial statement, indicating whether it has been reviewed, approved, held, or rejected prior to distribution. Used in billing workflow controls to prevent premature or erroneous statement delivery and to support audit trails in revenue cycle operations.

statement approved bystmt_appr_by

The identity of the user, role, or automated process that authorized a patient financial statement for distribution. Used in revenue cycle audit trails to document accountability for billing communications and to support dispute resolution when statement accuracy is questioned by patients or payers.

statement arrival timestmt_arrv_tm

The recorded time at which a patient arrived for a visit or encounter that is reflected on a financial statement. Used in revenue cycle and clinical operations to correlate billing events with service timelines, and to support documentation accuracy for time-sensitive billing requirements such as emergency department coding.

statement arrived datestmt_arrv_dt

The calendar date on which a patient arrived for a clinical encounter associated with a financial statement. Used in revenue cycle management to anchor billing timelines, validate service dates on claims, and ensure that statements are issued within payer-required timely filing windows.

statement birth datestmt_birth_dt

The date of birth of the patient or guarantor associated with a financial statement. Used in revenue cycle and patient identity verification processes to confirm the correct account is being billed, support age-based eligibility determinations, and meet payer requirements for claim and statement accuracy.

statement blood pressurestmt_bp

The systolic and diastolic blood pressure reading recorded for a patient during the encounter associated with a financial statement. Used to link clinical documentation to billing records, supporting medical necessity validation for cardiovascular-related services and ensuring compliance with diagnosis-driven reimbursement requirements.

PreviousPage 248 of 325Next