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 entered bystay_ent_by

The identifier of the user or system that created or submitted the inpatient stay record in the healthcare information system. Used for audit trail purposes, data quality review, and accountability tracking when reconciling inpatient admissions across clinical and administrative platforms.

stay ethnicitystay_ethn

The self-reported or recorded ethnic background of a patient during an inpatient stay. Used in population health reporting, quality measure stratification, and regulatory compliance submissions such as HEDIS and CMS race and ethnicity data collection requirements tied to inpatient encounters.

stay expiration datestay_exp_dt

The date on which an inpatient stay authorization, certification, or associated record becomes invalid. Used in utilization management and prior authorization workflows to ensure continued stays receive updated approvals and to prevent claims denials due to lapsed inpatient certifications.

stay external identifierstay_ext_id

A reference identifier assigned by an external system, such as a health plan, clearinghouse, or trading partner, to uniquely identify an inpatient stay across organizational boundaries. Used for claims crosswalking, care coordination, and reconciliation between hospital and payer systems.

stay faxstay_fax

The facsimile number associated with a patient, guarantor, or facility contact during an inpatient stay. Used in administrative workflows such as transmitting authorization requests, clinical documentation, and discharge summaries to payers, referring providers, or post-acute care facilities.

stay feestay_fee

The charge amount billed or assessed for services rendered during an inpatient stay. Used in hospital revenue cycle management, claims submission, and cost reporting to capture the total or itemized financial obligation associated with a specific inpatient episode of care.

stay first namestay_first_nm

The given name of the patient associated with an inpatient stay record. Used for patient identity matching, admission verification, and display within hospital information systems to ensure accurate association of clinical and billing records to the correct individual during the inpatient episode.

stay flagstay_flg

A binary or coded indicator used to mark a specific condition, status, or attribute of an inpatient stay record. Used in care management and utilization review workflows to highlight stays requiring special handling, such as pending authorization, outlier review, or readmission risk assessment.

stay frequencystay_freq

The rate or recurrence pattern of inpatient admissions for a patient or population within a defined time period. Used in utilization management, case management, and population health analytics to identify high-frequency inpatient utilizers who may benefit from care coordination or chronic disease management interventions.

stay full namestay_full_nm

The complete legal name of the patient associated with an inpatient stay, combining first, middle, and last name components. Used in patient identity verification, admission registration, and medical record matching to ensure accurate linkage of inpatient encounters across clinical and administrative systems.

stay genderstay_gndr

The recorded gender of the patient at the time of an inpatient stay. Used in clinical documentation, quality measure reporting, and demographic analytics to support sex-specific clinical protocols, regulatory reporting requirements, and population health stratification tied to inpatient episodes.

stay glucosestay_gluc

The blood glucose measurement recorded for a patient during an inpatient stay, expressed in mg/dL or mmol/L. Used in clinical monitoring of diabetic or critically ill inpatients, informing insulin protocols, glycemic control quality metrics, and documentation within the inpatient clinical record.

stay hemoglobinstay_hgb

The hemoglobin concentration measured from a patient's blood sample during an inpatient stay, typically expressed in g/dL. Used to monitor anemia, guide transfusion decisions, and support clinical documentation for inpatient episodes involving surgical, oncological, or chronic condition management.

stay history present illnessstay_hpi

Narrative documentation describing the chronological development of a patient's chief complaint and symptoms leading to an inpatient admission. Captured in clinical notes within EHR systems, this text supports diagnosis coding, utilization review, and care coordination during the hospital stay.

stay identifierstay_id

Unique system-generated or assigned alphanumeric key that distinctly identifies a single inpatient stay episode across clinical, billing, and administrative systems. Used to link admission records, encounter data, claims, discharge summaries, and ancillary service records to a specific hospitalization event.

stay indexstay_idx

Sequential position number assigned to an inpatient stay within a series of hospitalizations for a given patient or encounter grouping. Used in data warehouses and analytics systems to order and retrieve stay records chronologically or by priority for reporting and longitudinal care analysis.

stay indicatorstay_ind

Boolean or coded flag that denotes a specific condition or status applicable to an inpatient stay, such as whether the stay was an observation admission, involved an ICU transfer, or met criteria for readmission. Drives workflow logic and quality reporting in hospital information systems.

stay instructionstay_instr

Structured or free-text guidance associated with an inpatient stay, including care directives, discharge instructions, isolation protocols, or bed management notes. Captured in EHR and hospital information systems to ensure clinical staff and patients follow appropriate care procedures throughout the hospitalization.

stay keystay_key

Surrogate or natural lookup reference value used to join inpatient stay records across relational database tables in clinical data warehouses. Enables efficient retrieval and linkage of stay-related data including diagnoses, procedures, charges, and clinical documentation within analytical and operational systems.

stay labelstay_lbl

Human-readable display text assigned to an inpatient stay record for identification in user interfaces, reports, and dashboards. May include a formatted combination of patient name, admission date, facility, and stay identifier to allow clinical and administrative staff to quickly recognize and select specific hospitalizations.

PreviousPage 663 of 806Next