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

Operations

Scheduling, facilities, departments, workflows, and staff

6,492 operations terms

slot routeslot_rte

Identifies the delivery channel or booking pathway through which an appointment slot was created or accessed, such as online self-scheduling, call center, or referral. Used in scheduling systems to analyze slot utilization and access patterns across care settings.

slot scheduled dateslot_sched_dt

The calendar date on which an appointment slot is formally scheduled for patient use. Captured in scheduling and EHR systems to support appointment management, provider capacity planning, and no-show tracking across clinical and outpatient care settings.

slot scheduled timeslot_sched_tm

The specific time of day at which an appointment slot is formally scheduled for a patient visit. Used in scheduling systems to coordinate provider availability, prevent double-booking, and generate daily appointment rosters for clinical staff and front-desk operations.

slot scoreslot_scr

A calculated numeric rating assigned to an appointment slot based on criteria such as patient acuity, wait time priority, or scheduling algorithm weighting. Used in intelligent scheduling systems to optimize slot allocation and match patients to appropriate appointment openings.

slot sequenceslot_seq

A numeric value that defines the ordered position of an appointment slot within a provider's daily schedule or scheduling block. Used in scheduling systems to maintain the correct ordering of patient appointments and manage workflow across clinical sessions.

slot severityslot_sev

Indicates the clinical urgency or acuity level associated with an appointment slot, used to prioritize scheduling for patients requiring urgent or emergent care. Supports triage-based scheduling workflows in clinical and ambulatory care environments.

slot sexslot_sex

Records the biological sex designation associated with an appointment slot, used when slots are restricted to specific patient populations such as gender-specific screening programs or specialty clinics. Supports targeted scheduling rules in clinical workflow systems.

slot sourceslot_src

Identifies the originating system, referral channel, or intake method that generated an appointment slot request, such as a patient portal, referral management system, or call center. Used to track scheduling demand and optimize access across care coordination workflows.

slot start dateslot_start_dt

The calendar date marking the beginning of an appointment slot's availability window within a scheduling block. Recorded in scheduling systems to define when a provider's open time begins and to support accurate slot inventory management across clinical operations.

slot start timeslot_start_tm

The precise time of day at which an appointment slot becomes active and available for patient scheduling. Used in provider scheduling systems to define the opening boundary of a clinical appointment block and coordinate patient flow throughout the care day.

slot stateslot_st

Records the US state or geographic region associated with an appointment slot, typically used when scheduling across multi-state health systems or telehealth platforms where provider licensure and jurisdictional requirements vary by patient and provider location.

slot statusslot_sts

Indicates the current operational state of an appointment slot within the scheduling system, such as open, booked, cancelled, or held. Used to track real-time slot availability, monitor fill rates, and manage provider schedule utilization across clinical operations.

slot street addressslot_st_addr

The physical street address of the care location associated with an appointment slot, used in scheduling systems to direct patients to the correct facility. Supports multi-site health systems where providers operate across multiple clinic locations or satellite offices.

slot strengthslot_str

Defines the capacity or booking intensity of a scheduling slot, such as the number of patients or appointment units it can accommodate. Used in scheduling systems to differentiate between standard, complex, or high-demand appointment types within provider templates.

slot subtotalslot_subtot

A partial aggregate count or calculated sum of appointment slots within a defined scheduling subset, such as a morning block or specialty group. Used in scheduling analytics to measure partial capacity utilization and support resource planning across clinical operations.

slot targetslot_tgt

Identifies the intended recipient, care team, department, or patient population for which an appointment slot is designated. Used in scheduling systems to enforce slot reservation rules, manage referral queues, and ensure appropriate access for targeted patient groups.

slot taxonomy codeslot_tax_cd

The standardized NUCC taxonomy code identifying the clinical specialty or provider type associated with an appointment slot. Used in scheduling systems to match patient appointment needs to appropriately credentialed providers and to support payer-specific scheduling requirements.

slot temperatureslot_temp

A scheduling metadata attribute indicating the demand level or booking urgency of an appointment slot, categorized as hot, warm, or cold based on fill rate and wait time data. Used in scheduling optimization tools to prioritize slot release and manage patient access.

slot termination dateslot_term_dt

The calendar date on which an appointment slot or scheduling template is deactivated and no longer available for patient booking. Used in scheduling systems to manage provider schedule lifecycles, seasonal availability changes, and template expiration across clinical operations.

slot timeslot_tm

The time of day value associated with an appointment slot, representing when the slot occurs within a provider's daily schedule. Used in scheduling systems to define appointment timing, coordinate patient flow, and generate time-based schedule views for clinical staff.

PreviousPage 240 of 325Next