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

The identifier of the user or system that created or recorded the scheduling slot in the appointment management system. Used for audit tracking, accountability, and resolving scheduling discrepancies in clinical operations and health information systems.

slot ethnicityslot_ethn

The ethnicity of the patient or resource associated with a scheduling slot, captured to support health equity reporting and population health analytics. Used in scheduling and EHR systems to align with demographic data collection requirements for regulatory compliance.

slot expiration dateslot_exp_dt

The date after which a scheduling slot is no longer valid or available for booking. Used in appointment management systems to automatically retire unused or outdated slot templates and ensure scheduling availability accurately reflects current provider or facility capacity.

slot external identifierslot_ext_id

A reference identifier assigned to a scheduling slot by an external system, such as a third-party scheduling platform or health information exchange. Used to cross-reference and reconcile slot records across integrated healthcare scheduling and EHR systems.

slot faxslot_fax

The facsimile number associated with the provider, department, or facility linked to a scheduling slot. Used in scheduling and referral management systems to route appointment-related documents, referral requests, and clinical communications to the appropriate destination.

slot feeslot_fee

The charge amount associated with booking or utilizing a specific scheduling slot, reflecting the cost of the appointment type or clinical service. Used in scheduling and revenue cycle systems to support pre-service cost estimation and financial planning for patient visits.

slot first nameslot_first_nm

The given name of the patient or staff resource associated with a scheduling slot. Used in appointment management systems to personalize scheduling records, display human-readable booking information, and verify patient identity during appointment confirmation workflows.

slot flagslot_flg

A binary indicator used to mark a scheduling slot with a specific status or condition, such as blocked, overbooked, or reserved. Used in clinical scheduling systems to communicate slot availability restrictions or special handling requirements to scheduling staff and automated booking engines.

slot frequencyslot_freq

The recurrence pattern of a scheduling slot, indicating how often the slot repeats within a scheduling template, such as daily, weekly, or monthly. Used in appointment management systems to configure recurring provider or resource availability across clinical scheduling calendars.

slot full nameslot_full_nm

The complete name of the patient or resource associated with a scheduling slot, combining first, middle, and last name components. Used in scheduling systems to clearly identify the individual assigned to the appointment block and support patient matching during check-in workflows.

slot genderslot_gndr

The gender of the patient or resource associated with a scheduling slot, used to support clinical appropriateness checks and demographic reporting. Captured in scheduling and EHR systems to align with health equity data standards and ensure accurate patient identification.

slot glucoseslot_gluc

The blood sugar level for a available time period. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for slot management and reporting.

slot group numberslot_grp_nbr

The insurance group number associated with the patient occupying a scheduling slot, used to verify eligibility and benefits prior to the appointment. Referenced in scheduling and revenue cycle systems to streamline pre-authorization and billing workflows for the planned clinical service.

slot hemoglobinslot_hgb

The blood hemoglobin level for a available time period. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for slot management and reporting.

slot identifierslot_id

The unique primary key assigned to a specific scheduling slot within an appointment management system. Used to distinctly identify, retrieve, and reference individual time blocks across scheduling, EHR, and health information systems for booking, reporting, and audit purposes.

slot indexslot_idx

A numeric position value indicating the sequential order of a scheduling slot within a series of appointment blocks or a daily scheduling template. Used in scheduling systems to organize and navigate slots within provider schedules and support capacity planning workflows.

slot indicatorslot_ind

A coded value representing the current status or condition of a scheduling slot, such as available, booked, cancelled, or waitlisted. Used in appointment management systems to communicate real-time slot availability and drive scheduling logic for patient booking and resource allocation.

slot keyslot_key

Unique surrogate or natural key that identifies a specific schedulable appointment slot in scheduling systems. Used to join slot records across scheduling, EHR, and data warehouse tables, enabling accurate retrieval of availability windows tied to providers, locations, or service types.

slot languageslot_lang

Preferred or required spoken language associated with a schedulable appointment slot, used to match patients with providers or staff who can communicate in that language. Supports language-concordant care matching in scheduling workflows and health equity reporting.

slot last nameslot_last_nm

Family surname associated with a schedulable appointment slot, typically referencing the patient or provider linked to that booking window. Used in scheduling systems to display and search slot assignments within appointment management and clinical workflow interfaces.

PreviousPage 237 of 325Next