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

Clinical

EHR, ICD-10, LOINC, SNOMED CT, patient care and clinical documentation

16,101 clinical terms

statement admission datestmt_admn_dt

The date on which a patient was admitted to a facility for an inpatient or observation encounter, as recorded on the billing statement. Used in revenue cycle and claims processing systems to define the service period start date for accurate billing and reimbursement.

statement assessmentstmt_asmt

The clinical evaluation or diagnostic summary documented by a provider on a patient statement, capturing impressions and findings related to the encounter. Used in clinical documentation and billing workflows to support coding accuracy and medical necessity determinations.

statement discharge datestmt_dsch_dt

The date on which a patient was formally released from an inpatient or observation facility stay, as recorded on the billing statement. Used in revenue cycle systems to define the service period end date and calculate length of stay for claims submission and reimbursement.

statement durationstmt_dur

The total length of time covered by a patient billing statement, typically calculated as the difference between admission and discharge dates for an inpatient encounter. Used in revenue cycle systems to validate billing periods and support length-of-stay reporting.

statement emergency indicatorstmt_emerg_ind

A binary flag on a patient billing statement designating that the associated encounter originated as an emergency visit. Used in revenue cycle and claims processing to apply appropriate billing codes, reimbursement rules, and compliance edits for emergency services.

statement history present illnessstmt_hpi

The narrative documentation describing the onset, duration, and progression of a patient's current condition as recorded on a billing statement. Used in clinical documentation and coding workflows to support diagnosis assignment, medical necessity, and claims accuracy.

statement instructionstmt_instr

Patient-facing or internal guidance text included on a billing statement, such as payment instructions, dispute procedures, or care follow-up directions. Used in revenue cycle and patient financial services systems to communicate account actions and support collections workflows.

statement labelstmt_lbl

A descriptive identifier or display name assigned to a patient billing statement for categorization and presentation purposes within revenue cycle systems. Used to distinguish statement types, billing periods, or account groupings in patient financial services and reporting.

statement notestmt_nt

A free-text annotation added to a patient billing statement to document account-specific information, such as payment arrangements, disputes, or follow-up actions. Used in revenue cycle management systems to maintain an audit trail of billing account activity and staff communications.

statement procedure datestmt_proc_dt

The date on which a clinical procedure or service was performed, as recorded on the patient billing statement. Used in revenue cycle and claims processing systems to establish the date of service for accurate charge capture, payer billing, and reimbursement adjudication.

statement rangestmt_rng

The span of dates or values associated with a patient billing statement, defining the boundaries of the covered service period or charge amounts. Used in revenue cycle systems to validate billing windows, aggregate charges, and ensure claims are submitted within payer timely filing requirements.

statement resultstmt_rslt

The outcome of a billed service or clinical test as documented on a patient billing statement, linking clinical findings to charges. Used in revenue cycle and clinical data systems to support diagnosis coding accuracy, claim validation, and medical necessity documentation for reimbursement.

statement routestmt_rte

The administration pathway for a medication or treatment as documented on a patient billing statement, such as oral or intravenous. Used in pharmacy billing and revenue cycle systems to validate that the billed route of administration aligns with payer coverage rules and clinical documentation.

statement strengthstmt_str

The drug concentration or potency recorded on a billing statement, such as milligrams per tablet or percentage solution. Used in pharmacy claims and medication billing to verify that the dispensed drug strength matches the prescribed and adjudicated medication on the account summary.

statement surgery datestmt_surg_dt

The date on which a surgical procedure was performed, as recorded on a patient billing statement or account summary. Used in hospital claims processing to align operative services with the correct billing period and support revenue cycle reconciliation for surgical encounters.

stay active indicatorstay_actv_ind

A flag indicating whether an inpatient hospital stay is currently active or has been closed, discharged, or otherwise resolved. Used in utilization management and case management systems to identify patients who remain admitted and require ongoing clinical or administrative monitoring.

stay active statusstay_actv_sts

The current activity state of an inpatient hospital stay, indicating whether the stay is ongoing, pending discharge, or completed. Used in care management platforms and hospital information systems to track real-time census data and support bed management and resource allocation decisions.

stay admission datestay_admn_dt

The calendar date on which a patient was formally admitted to a hospital or inpatient facility, marking the start of the inpatient stay. Used in claims processing, utilization review, and length-of-stay calculations to establish the admission episode and determine benefit eligibility periods.

stay agestay_age

The patient's age in years at the time of hospital admission or during the inpatient stay. Used in clinical documentation, utilization management, and case mix reporting to support age-based clinical protocols, pediatric versus adult classification, and demographic analysis of inpatient populations.

stay allowed amountstay_alwd_amt

The maximum dollar amount a payer will reimburse for services rendered during an inpatient hospital stay, based on the contracted rate or fee schedule. Used in claims adjudication to determine payment obligations and calculate member cost-sharing responsibilities such as deductibles and coinsurance.

PreviousPage 660 of 806Next