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 languagestay_lang

Preferred or primary spoken and written language of the patient during an inpatient stay, recorded to ensure appropriate interpreter services, translated discharge materials, and culturally competent care are provided. Supports regulatory compliance with language access requirements in hospital settings.

stay last namestay_last_nm

Family surname of the patient associated with an inpatient stay, as recorded at the time of admission. Used for patient identification, medical record matching, and demographic reporting. Cross-referenced with master patient index records to prevent duplicate stay registrations and support accurate identity management.

stay legal namestay_legal_nm

Officially registered full name of the patient as it appears on government-issued identification at the time of inpatient admission. Used for consent documentation, insurance verification, billing claims submission, and compliance with hospital registration requirements to ensure accurate patient identity records.

stay levelstay_lvl

Designation indicating the intensity or classification tier of an inpatient stay, such as acute care, subacute, long-term care, or observation level. Determines reimbursement methodology, staffing ratios, and regulatory reporting requirements under Medicare, Medicaid, and commercial payer contracts.

stay license numberstay_lic_nbr

Professional license identifier associated with the admitting or attending clinician responsible for an inpatient stay. Used to verify provider credentials, support medical staff credentialing processes, and meet documentation requirements for claims submission and regulatory audits of inpatient services.

stay marital statusstay_mar_sts

Recorded relationship status of the patient at the time of inpatient admission, such as single, married, divorced, or widowed. Used in demographic profiling, next-of-kin and emergency contact documentation, insurance coordination of benefits determinations, and social determinants of health assessments.

stay master identifierstay_mstr_id

Enterprise master patient index identifier linked to an inpatient stay, enabling cross-system patient matching across hospitals, clinics, and health systems within an integrated delivery network. Supports longitudinal patient record consolidation, care coordination, and population health analytics across multiple care settings.

stay maximumstay_max

Upper boundary value defined for a measurable attribute of an inpatient stay, such as maximum authorized length of stay approved by a payer, maximum allowable bed days under a benefit plan, or ceiling values in clinical scoring thresholds used for utilization management and case management decisions.

stay middle namestay_mid_nm

Middle name or initial of the patient associated with an inpatient stay, recorded during hospital registration to improve accuracy of patient identity matching and reduce duplicate medical record creation. Supports master patient index integrity and accurate claims submission when payers require full legal name verification.

stay minimumstay_min

Lower boundary value defined for a measurable attribute of an inpatient stay, such as minimum required length of stay for a specific procedure under clinical protocols, minimum days before discharge eligibility, or floor values used in payer authorization criteria and utilization review thresholds.

stay mobilestay_mob

Mobile or cellular telephone number recorded for the patient or their designated contact during an inpatient stay registration. Used by hospital staff for discharge planning communications, appointment scheduling, care coordination follow-up, and patient outreach for post-discharge surveys and readmission prevention programs.

stay modified bystay_mod_by

Username or system identifier of the individual or automated process that last updated an inpatient stay record in the clinical or administrative system. Captured as part of the audit trail to support data governance, change management accountability, and compliance reviews of inpatient encounter documentation.

stay modified datestay_mod_dt

Timestamp recording when an inpatient stay record was most recently updated in the source system. Critical for data warehouse incremental load processing, audit trail maintenance, and identifying late-arriving updates to admission, discharge, transfer, or clinical documentation records associated with a hospitalization.

stay modified timestay_mod_tm

Timestamp recording the most recent update to an inpatient stay record. Captures the exact time any stay attribute was altered, supporting audit trails, data reconciliation, and change tracking across hospital information and clinical data warehouse systems.

stay namestay_nm

Human-readable label assigned to an inpatient stay record, typically reflecting the primary diagnosis, care episode type, or admission category. Used in clinical workflows and reporting interfaces to identify and distinguish stays without relying solely on numeric identifiers.

stay notestay_nt

Free-text annotation attached to an inpatient stay record capturing clinical observations, administrative remarks, or care coordination details not represented in structured fields. Supports continuity of care documentation and is referenced during utilization review and case management workflows.

stay numberstay_nbr

Unique alphanumeric identifier assigned to an inpatient stay episode, used to link clinical events, diagnoses, procedures, and billing records throughout the hospitalization. Serves as the primary reference key for tracking a patient's continuous inpatient encounter across hospital systems.

stay onset datestay_onset_dt

Calendar date on which the patient's presenting symptoms or condition first began, as documented within the inpatient stay record. Distinct from admission date, this value supports disease progression analysis, length of illness reporting, and clinical quality measure calculations.

stay oxygen saturationstay_o2sat

Recorded peripheral blood oxygen saturation percentage (SpO2) measured during an inpatient stay, typically captured via pulse oximetry. Used to monitor respiratory status, trigger clinical interventions, and support quality metrics such as sepsis and respiratory failure outcome tracking.

stay paid amountstay_pd_amt

Actual dollar amount remitted by the payer toward the total charges for an inpatient stay, recorded after adjudication. Used in hospital revenue cycle management to reconcile expected reimbursement against contractual rates and identify underpayments or claim discrepancies.

PreviousPage 664 of 806Next