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 paid datestay_pd_dt

Calendar date on which payment was received or posted for an inpatient stay claim. Used in hospital revenue cycle and accounts receivable workflows to calculate payment lag, monitor payer performance, and reconcile remittance advice against outstanding inpatient balances.

stay parentstay_prnt

Reference linking an inpatient stay record to a higher-level encounter, episode of care, or organizational hierarchy node. Used in data models where multiple stay segments or transfers must be grouped under a single overarching admission episode for reporting and care coordination purposes.

stay percentagestay_pct

Proportional ratio value associated with an inpatient stay, representing metrics such as payer responsibility share, cost allocation percentage, or occupancy rate contribution. Used in financial modeling, contract performance analysis, and inpatient utilization reporting across hospital systems.

stay periodstay_prd

Defined time interval encompassing an inpatient stay, typically bounded by admission and discharge dates. Used in utilization management, length-of-stay benchmarking, and payer authorization workflows to evaluate whether the care episode falls within approved or expected duration parameters.

stay phonestay_ph

Telephone contact number associated with an inpatient stay record, which may reference the patient's room line, a responsible party, or the admitting unit's direct number. Used for care coordination, discharge planning communication, and follow-up contact documentation during hospitalization.

stay preferred namestay_pref_nm

Patient's chosen name or alias as recorded for the inpatient stay, which may differ from the legal name on the admission record. Supports patient-centered care by ensuring clinical staff and communications use the name the patient identifies with throughout the hospitalization.

stay pricestay_prc

Total billed or estimated cost associated with an inpatient stay, reflecting charges for room, services, procedures, and supplies. Used in hospital financial reporting, patient cost estimation tools, and payer contract analysis to evaluate reimbursement adequacy against actual service costs.

stay primary indicatorstay_prim_ind

Boolean or coded flag designating whether an inpatient stay record is considered the primary encounter among multiple concurrent or related stays. Used in clinical data warehouses to prevent duplicate counting in reporting and to correctly attribute diagnoses and costs to the principal episode.

stay prioritystay_prty

Coded value indicating the clinical or administrative urgency assigned to an inpatient stay, such as emergent, urgent, or elective admission classifications. Used in bed management, resource allocation workflows, and utilization reporting to triage and sequence inpatient care delivery appropriately.

stay procedure datestay_proc_dt

Calendar date on which a clinical procedure was performed during an inpatient stay. Used to sequence surgical or diagnostic events within the hospitalization timeline, support ICD and CPT coding accuracy, and calculate procedure-to-admission intervals for quality and outcomes reporting.

stay pulsestay_pulse

Heart rate in beats per minute recorded for a patient during an inpatient stay, typically documented as part of routine vital sign assessment. Used to monitor cardiovascular status, flag deterioration events, and contribute to early warning scores and clinical decision support algorithms.

stay quantitystay_qty

Numeric count or measurable volume associated with an inpatient stay, such as the number of units of a service rendered, supplies consumed, or therapy sessions completed. Used in charge capture, utilization reporting, and resource consumption analysis across inpatient clinical and billing systems.

stay racestay_race

Patient's self-reported racial identity as captured within the inpatient stay record, following standard classifications such as OMB or CDC race categories. Used in population health equity analysis, mandatory regulatory reporting, and identifying disparities in inpatient care access and outcomes.

stay rangestay_rng

Defines the minimum and maximum allowable length-of-stay thresholds for an inpatient episode, used in utilization management to flag outlier cases, trigger concurrent review, and benchmark actual days against expected stay parameters for a given diagnosis or procedure.

stay ratestay_rt

The negotiated or standard per-diem dollar amount applied to an inpatient hospital stay for reimbursement calculation. Used in claims adjudication to compute facility payment based on the number of covered inpatient days multiplied by the contracted daily rate for the applicable bed type or service level.

stay ratingstay_rtg

A structured quality or utilization assessment assigned to an inpatient stay, reflecting clinical necessity, care appropriateness, or payer review outcomes. Used in utilization management and case management workflows to evaluate whether the hospitalization met medical necessity criteria for the duration billed.

stay ratiostay_ratio

The proportional relationship between actual inpatient length-of-stay and an expected or benchmarked duration for a given diagnosis or procedure group. Used in utilization analytics to measure efficiency, identify over- or under-utilization patterns, and support population health management reporting.

stay reasonstay_rsn

A coded or free-text explanation documenting why an inpatient stay occurred, was extended, or required continued hospitalization beyond expected thresholds. Captured during utilization review to support medical necessity determinations, appeals processing, and payer authorization workflows for inpatient admissions.

stay received datestay_rcvd_dt

The calendar date on which documentation, authorization request, or notification related to an inpatient stay was received by the payer or utilization management team. Used to calculate response turnaround compliance, track prior authorization timeliness, and support regulatory audit requirements for inpatient reviews.

stay referencestay_ref

A unique identifier or external pointer linking an inpatient stay record to an associated authorization, claim, case management episode, or prior review. Used to correlate inpatient hospitalization data across payer systems, enabling accurate claims matching, retrospective auditing, and coordination of benefits processing.

PreviousPage 665 of 806Next