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 countrystay_ctry

The nation in which the inpatient facility providing care is located. Used in claims processing and member benefit administration to determine whether services were rendered domestically or internationally, affecting coverage rules and reimbursement rates.

stay created bystay_crtd_by

The unique identifier of the user or system that initially created the inpatient stay record in the hospital or care management information system. Supports audit trail requirements, data governance, and accountability tracking for clinical and administrative records.

stay created datestay_crtd_dt

The calendar date on which the inpatient stay record was first entered into the hospital information or care management system. Used in audit logging, data lineage tracking, and reconciliation processes to establish when the stay was formally registered.

stay created timestay_crtd_tm

The timestamp indicating the precise time of day an inpatient stay record was first created in the clinical or administrative system. Used alongside the created date to support detailed audit trails, workflow sequencing, and system reconciliation processes.

stay creatininestay_cr

The serum creatinine laboratory value recorded during an inpatient stay, used as a key biomarker of kidney function. Supports clinical decision-making for acute kidney injury detection, medication dosing adjustments, and quality measure reporting during hospitalization.

stay datestay_dt

The primary calendar date associated with an inpatient stay event, such as admission or discharge. Used in hospital census reporting, claims adjudication, length-of-stay calculations, and utilization management to anchor the stay within a timeline of care.

stay datetimestay_dttm

The combined date and time value marking a specific event within an inpatient stay, such as admission, transfer, or discharge. Enables precise sequencing of clinical events, supports care transition tracking, and facilitates accurate length-of-stay calculations in hospital systems.

stay dea numberstay_dea_nbr

The Drug Enforcement Administration registration number associated with a prescribing clinician involved in an inpatient stay. Used to validate controlled substance prescribing authority during hospitalization and support pharmacy compliance and regulatory reporting requirements.

stay death datestay_death_dt

The recorded date on which a patient died during or in association with an inpatient hospital stay. Used in mortality reporting, quality measure calculations, claims finalization, and population health analytics to capture in-hospital and post-discharge death events.

stay deleted datestay_del_dt

The date on which an inpatient stay record was marked as deleted or voided in the hospital information or claims system. Used in audit logging, data reconciliation, and compliance processes to track when records were removed and maintain historical data integrity.

stay deleted indicatorstay_del_ind

A binary flag indicating that an inpatient stay record has been logically removed or voided from active processing in the hospital or payer system. Preserves the record for audit and historical reporting while preventing it from being included in active claims or utilization calculations.

stay descriptionstay_desc

A human-readable textual explanation of the inpatient stay, including relevant clinical or administrative context such as stay type, purpose of admission, or classification. Used in care management platforms, reporting dashboards, and member-facing communications to describe the stay clearly.

stay detailstay_dtl

Granular clinical or administrative information captured at the line or service level within an inpatient stay record. Includes specifics such as individual procedures, diagnoses, room assignments, or clinical observations used in claims adjudication, utilization review, and hospital reporting systems.

stay discharge datestay_dsch_dt

The date a patient was formally released from an inpatient hospital stay. Used in utilization management, claims adjudication, and length-of-stay calculations to determine the endpoint of a billable inpatient episode and trigger post-discharge follow-up workflows.

stay due datestay_due_dt

The date by which payment or authorization is required for an inpatient stay. Used in revenue cycle management to track billing deadlines, coordinate insurance reimbursement timelines, and flag overdue accounts for follow-up within hospital financial systems.

stay durationstay_dur

The total number of days or hours a patient remained in an inpatient facility, calculated from admission to discharge. Used in utilization review, case management, and claims processing to assess resource consumption, benchmark against expected length-of-stay norms, and support DRG-based reimbursement.

stay emailstay_eml

The electronic mail address associated with a patient or responsible party during an inpatient stay. Used for billing correspondence, discharge instructions, appointment scheduling, and patient portal communication tied to the specific inpatient encounter record.

stay emergency indicatorstay_emerg_ind

A flag denoting whether an inpatient stay originated as an emergency admission rather than a scheduled or elective hospitalization. Used in claims processing, utilization management, and quality reporting to distinguish emergency admissions, which may affect authorization requirements and reimbursement rates.

stay end datestay_end_dt

The calendar date marking the conclusion of an inpatient care episode, typically aligned with or derived from the discharge date. Used in claims adjudication, authorization tracking, and inpatient utilization reporting to define the closing boundary of a billable hospital stay.

stay end timestay_end_tm

The specific time of day at which an inpatient stay concluded, recorded alongside the end date. Used in hospital operations, bed management, and clinical documentation to calculate precise length-of-stay hours and coordinate discharge workflows and room turnover scheduling.

PreviousPage 662 of 806Next