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

stay resolution datestay_resol_dt

The date on which a clinical issue, utilization review determination, or appeal related to an inpatient stay was formally concluded. Used in case management and claims processing workflows to track the lifecycle of hospitalization reviews, denials, and medical necessity decisions from initiation through final disposition.

stay respirationstay_resp

The recorded respiratory rate or breathing assessment documented during an inpatient hospitalization, captured as part of routine vital sign monitoring. Used in clinical data systems to track patient acuity, support early warning scoring, and inform clinical decision-making throughout the inpatient stay.

stay resultstay_rslt

The clinical or administrative outcome recorded for an inpatient stay, such as test findings, treatment responses, or discharge disposition. Used in clinical data warehouses and care management platforms to evaluate episode effectiveness, measure quality metrics, and inform post-discharge follow-up planning.

stay revisionstay_rev

A versioned update to an inpatient stay record reflecting changes to authorization, length-of-stay determination, clinical documentation, or billing data. Tracks iterative amendments made during concurrent or retrospective review, ensuring audit trails are maintained when stay-related decisions are modified after initial submission.

stay riskstay_rsk

A stratified risk classification assigned to an inpatient stay based on clinical complexity, comorbidity burden, or readmission probability. Used in case management and utilization review to prioritize high-risk patients for intensive care coordination, transition planning, and targeted interventions during and after hospitalization.

stay routestay_rte

Identifies the clinical pathway or care setting through which a patient was admitted to or transitioned within an inpatient stay, such as emergency department, direct admission, or transfer from another facility. Used in inpatient claims and utilization data to classify admission type and support episode analysis.

stay scorestay_scr

A composite numeric value derived from clinical indicators, acuity measures, or utilization criteria that quantifies the complexity or intensity of an inpatient stay. Used in severity adjustment models, case mix analysis, and value-based payment programs to normalize outcomes and compare performance across patient populations.

stay sequencestay_seq

A numeric value indicating the chronological order of an inpatient stay within a series of hospitalizations for a member or patient. Used in claims and care management systems to track readmissions, identify recurring episodes, and analyze longitudinal inpatient utilization patterns across a defined measurement period.

stay severitystay_sev

A clinical classification indicating the seriousness or acuity level of a patient's condition during an inpatient hospitalization, often derived from diagnosis codes, comorbidities, or standardized severity tools. Used in risk adjustment, quality reporting, and utilization management to contextualize length-of-stay and resource consumption.

stay sexstay_sex

The biological sex of the patient recorded in association with an inpatient stay, used to support clinical stratification, quality measure reporting, and demographic analysis. Enables gender-based utilization comparisons, supports clinical protocol selection, and is required for risk adjustment in inpatient episode analytics.

stay sourcestay_src

Identifies the originating system, facility, or data feed from which the inpatient stay record was received or extracted. Used in data governance and claims processing workflows to validate record provenance, resolve duplicate stay submissions, and ensure data lineage integrity across integrated healthcare information systems.

stay start datestay_start_dt

The calendar date marking the official beginning of an inpatient hospitalization, typically corresponding to the admission date. Used in claims adjudication, authorization tracking, and length-of-stay calculations to establish the episode window, determine coverage eligibility, and measure inpatient utilization against contracted benefit parameters.

stay start timestay_start_tm

The precise time of day at which an inpatient admission began, recorded alongside the admission date to establish the exact episode start. Used in clinical documentation, bed management systems, and claims processing to calculate accurate length-of-stay in hours, support observation-to-inpatient status determinations, and meet regulatory billing requirements.

stay statestay_st

The US state or Canadian province associated with the facility where an inpatient stay occurred. Used in hospital claims and utilization data to identify the geographic jurisdiction of the admitting facility, supporting regional analysis and regulatory compliance reporting.

stay statusstay_sts

The administrative or clinical status of an inpatient hospital stay, such as active, discharged, transferred, or expired. Used in utilization management and claims adjudication to track the current disposition of an admission and determine appropriate billing and care coordination actions.

stay strengthstay_str

The concentration or potency of a medication administered during an inpatient hospital stay, expressed as the amount of active ingredient per unit dose. Used in inpatient pharmacy records to document drug dispensing details and support medication reconciliation and clinical decision-making.

stay subtotalstay_subtot

A partial sum of charges or costs accumulated during an inpatient hospital stay, representing a subset of the total billed amount such as room and board or ancillary services. Used in hospital billing systems to break down the financial components of an inpatient claim before final adjudication.

stay surgery datestay_surg_dt

The calendar date on which a surgical procedure was performed during an inpatient hospital stay. Used in hospital claims, surgical scheduling systems, and clinical data warehouses to associate operative procedures with specific admission episodes and support quality and outcomes reporting.

stay targetstay_tgt

The designated goal, benchmark, or destination reference associated with an inpatient hospital stay, such as a target discharge date or target length of stay. Used in utilization management and care coordination workflows to drive discharge planning and manage bed capacity effectively.

stay taxonomy codestay_tax_cd

The Health Care Provider Taxonomy Code identifying the specialty or type of treating clinician associated with an inpatient hospital stay. Used in hospital claims and credentialing systems to classify the clinical specialty responsible for the admission, supporting billing accuracy and provider profiling.

PreviousPage 666 of 806Next