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 temperaturestay_temp

The recorded body temperature of a patient during an inpatient hospital stay, typically measured in degrees Fahrenheit or Celsius. Used in clinical documentation and vital signs monitoring systems to track patient condition, detect fever or hypothermia, and inform treatment decisions throughout the admission.

stay termination datestay_term_dt

The date on which an inpatient hospital stay was formally ended, whether through discharge, transfer, or death. Used in hospital claims and utilization management systems to calculate length of stay, finalize billing records, and close the episode of care in administrative and clinical data warehouses.

stay timestay_tm

The specific time of day associated with a key event during an inpatient hospital stay, such as admission time or discharge time. Used in hospital operational and clinical systems to support bed management, nursing handoffs, regulatory reporting, and accurate calculation of length of stay in hours.

stay timestampstay_ts

The combined date and time value marking when a specific event or transaction occurred during an inpatient hospital stay, such as admission, procedure, or data entry. Used in hospital information systems and audit logs to establish precise chronological sequencing of clinical and administrative events.

stay titlestay_ttl

The formal name or label assigned to categorize or describe an inpatient hospital stay, such as the type of admission or service line designation. Used in clinical documentation and reporting systems to provide a standardized reference for the episode of care across hospital billing and quality datasets.

stay totalstay_tot

The aggregate sum of all charges, costs, or units associated with an inpatient hospital stay, representing the complete billed amount across all services rendered during the admission. Used in hospital claims adjudication and financial reporting to determine member liability, payer reimbursement, and cost of care analytics.

stay total countstay_tot_cnt

The cumulative number of distinct events, services, procedures, or occurrences recorded during an inpatient hospital stay. Used in hospital utilization reporting and claims analytics to quantify service volume per admission, supporting length of stay benchmarking, resource utilization analysis, and population health management.

stay typestay_typ

The classification category describing the nature of an inpatient hospital stay, such as elective, emergency, maternity, surgical, or psychiatric. Used in hospital claims and utilization management systems to segment admissions for reimbursement, quality reporting, and care management program eligibility determination.

stay updated datestay_upd_dt

The most recent date on which the inpatient hospital stay record was modified or corrected in the administrative or clinical system. Used in data governance and audit tracking to identify when claims, clinical documentation, or enrollment-linked stay records were last changed, supporting data integrity and reconciliation workflows.

stay urgencystay_urg

The level of clinical urgency or time sensitivity associated with an inpatient hospital admission, such as elective, urgent, or emergent. Used in hospital claims and utilization management to classify the medical necessity basis for admission, influencing authorization requirements, bed prioritization, and payer reimbursement determination.

stay versionstay_ver

The sequential version number assigned to an inpatient hospital stay record, incrementing each time the record is revised, corrected, or resubmitted. Used in claims adjudication and data warehousing to distinguish the most current version of a stay record from prior iterations and maintain a complete audit history.

stay zipstay_zip

The five or nine digit US postal code associated with either the admitting facility or the patient's residence at the time of an inpatient hospital stay. Used in hospital claims and population health data to support geographic analysis, network adequacy assessments, and social determinants of health reporting.

strength active indicatorstr_actv_ind

A flag indicating whether a specific drug strength or concentration is currently active and available for prescribing, dispensing, or formulary reference. Used in pharmacy benefit management and drug master file systems to control which medication strengths are valid for use in claims adjudication and clinical decision support.

strength active statusstr_actv_sts

Indicates whether a specific drug strength formulation is currently active and available for prescribing or dispensing in the pharmacy system. Used in drug formulary management to flag deprecated, discontinued, or superseded concentration values from active medication catalogs.

strength admission datestr_admn_dt

Records the inpatient admission date associated with a specific drug strength record, linking the concentration value to a hospital encounter. Used in pharmacy and clinical data systems to contextualize strength changes or medication orders within an inpatient stay timeline.

strength agestr_age

Captures the patient age corresponding to a drug strength record, used to validate age-appropriate dosing thresholds in pharmacy and clinical systems. Pediatric and geriatric dosing guidelines often require age-specific concentration values to ensure safe medication administration.

strength allowed amountstr_alwd_amt

The maximum reimbursable dollar amount a payer will approve for a specific drug strength on a pharmacy or medical claim. Used in adjudication systems to enforce formulary tier pricing and contractual reimbursement limits tied to approved concentration values.

strength amountstr_amt

Represents the monetary value associated with a specific drug strength transaction in pharmacy billing or claims processing. Used to record the cost or charge amount linked to a particular drug concentration, supporting financial reconciliation and pharmacy cost reporting.

strength approved bystr_appr_by

Identifies the credentialed user, pharmacist, or clinical reviewer who authorized a specific drug strength entry in the pharmacy or formulary management system. Provides an audit trail for concentration value approvals, supporting regulatory compliance and medication safety workflows.

strength arrival timestr_arrv_tm

Records the time a patient arrived at a care setting in relation to a drug strength record, used to establish medication administration timelines. In emergency or urgent care contexts, this timestamp helps calculate time-to-treatment intervals for specific drug concentrations.

PreviousPage 667 of 806Next