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

site labelsite_lbl

A human-readable display name or descriptive text assigned to a specific care delivery location for identification purposes within clinical and administrative systems. Used in scheduling, reporting, and patient-facing interfaces to clearly identify and distinguish between facilities, units, or care sites.

site notesite_nt

A free-text annotation or comment associated with a specific care delivery location, capturing supplemental clinical or operational information not accommodated by structured fields. Used in clinical documentation systems to record observations, special circumstances, or contextual details relevant to care delivered at that site.

site procedure datesite_proc_dt

The date on which a clinical procedure or treatment was performed at a specific care delivery location. Used in facility-based clinical records and procedure documentation to establish the timing of interventions, support billing workflows, and enable site-level procedural utilization reporting.

site rangesite_rng

The acceptable or observed value range associated with a clinical measurement or parameter recorded at a specific care delivery location. Used in clinical data systems to define normal reference intervals or capture the scope of results tied to a particular facility or care site context.

site resultsite_rslt

The recorded outcome, finding, or measurement value obtained at a specific care delivery location, such as a diagnostic test result or clinical assessment outcome. Used in clinical data systems to associate laboratory, imaging, or observational findings with the facility or site where they were produced.

site routesite_rte

The documented administration pathway or method of treatment delivery associated with a specific care delivery location, such as intravenous, oral, or topical. Used in clinical documentation to record how medications or therapies were administered within the context of a particular facility or care site.

site surgery datesite_surg_dt

The date on which a surgical procedure was performed at a specific care delivery location. Used in operative and facility-based clinical records to document the timing of surgical interventions, support perioperative care coordination, and enable site-level surgical volume and outcomes reporting.

slot active indicatorslot_actv_ind

A binary flag indicating whether a specific scheduling time slot at a care delivery location is currently active and available for patient appointment booking. Used in scheduling and practice management systems to enable or disable individual time blocks within a provider or facility calendar.

slot active statusslot_actv_sts

A categorical value describing the current operational state of a scheduling time slot, such as open, blocked, or cancelled. Used in appointment scheduling systems to manage availability, control booking access, and support capacity planning across care delivery locations and provider schedules.

slot admission dateslot_admn_dt

The date associated with a patient admission event linked to a specific scheduling slot, capturing when the patient was formally received into care following a booked appointment or pre-admission reservation. Used in scheduling and facility management systems to align slot utilization with inpatient admission workflows.

slot discharge dateslot_dsch_dt

The date associated with a patient discharge event linked to a specific scheduling slot, capturing when care concluded following an appointment or inpatient stay tied to a reserved time block. Used in scheduling and facility management systems to reconcile slot utilization against actual care episode end dates.

slot emergency indicatorslot_emerg_ind

Flag identifying whether a scheduling slot is designated for emergency or urgent care appointments. Enables scheduling systems to reserve or prioritize specific time blocks for walk-in emergencies, ensuring appropriate access to care within clinical workflows.

slot history present illnessslot_hpi

Narrative text field capturing the history of present illness documented within a specific scheduling slot context. Records the patient's symptom progression, onset, and clinical background associated with the appointment, supporting clinical documentation during the encounter.

slot instructionslot_instr

Free-text or coded instructions associated with a specific appointment scheduling slot, such as patient preparation requirements, resource setup directions, or staff guidance. Ensures clinical and administrative teams follow correct protocols for the scheduled appointment type.

slot labelslot_lbl

Display name or descriptive text assigned to a specific scheduling slot to identify its purpose, appointment type, or clinical service category. Used in scheduling interfaces and reporting to distinguish slot types such as follow-up, new patient, or procedure visits.

slot noteslot_nt

Annotation or free-text comment attached to a specific scheduling slot, capturing special circumstances, patient preferences, or administrative details relevant to the appointment. Supports care coordination and scheduling staff communication within appointment management systems.

slot procedure dateslot_proc_dt

The calendar date on which a clinical procedure is scheduled or was performed within a specific appointment slot. Used in scheduling and clinical data systems to align procedure documentation, resource planning, and billing timelines for procedural appointments.

slot rangeslot_rng

The defined time span or value boundaries associated with a scheduling slot, specifying the allowable start and end parameters for appointment booking. Used in scheduling systems to enforce constraints on appointment length, availability windows, or acceptable booking intervals.

slot resultslot_rslt

The recorded outcome or finding associated with a specific appointment slot, capturing clinical results, test outcomes, or disposition decisions documented during the encounter. Links scheduling activity to clinical outcomes in health information and scheduling management systems.

slot surgery dateslot_surg_dt

The calendar date on which a surgical procedure is scheduled or performed within a designated appointment slot. Used in surgical scheduling and perioperative systems to coordinate operating room resources, pre-operative preparation, and post-operative care planning.

PreviousPage 646 of 806Next