Reservation Waitlist data model

  • Release version: Australia
  • Updated June 9, 2026
  • 2 minutes to read

    • The Reservation Waitlist data model describes the tables and configuration options that support waitlist requests, space allocation, and reservation fulfillment for employees.

    Reservation Waiting Lists

    The Reservation Waiting Lists table (sn_wsd_rsv_waitlist) is updated with Neighborhood, Reservable Module, and Fulfilled by columns for manual event planner fulfillment. Navigate to All > Workplace Reservation Management > Reservation Overview > My Waiting List.

    Reservation waiting list table showing the Reservable module configuration, status, and priority.

    Status: The waitlist Status column is updated with the following values:
    • Queued: When an employee submits a waitlist request, the system creates a record in the Reservation Waitlist [sn_wsd_rsv_waitlist] table with the status set to Queued
    • Confirmed: The queued waitlist request is approved or fulfilled, a space is assigned for reservation, and the status changes from Queued to Confirmed.
    • Expired: Stale or past waitlist records are removed by the nightly Waitlist Expiration scheduled job. The scheduled job identifies waitlist records in Queued state. The scheduled job detects past or stale timestamps for waitlist records. Waitlist records with a past start time are set to Expired. Expired records are retained for 30 days before being permanently purged.

      For more information, see Create a schedule job for waitlist.

    • Canceled: An employee or the Reservation Event Planner cancels a Queued waitlist record. The status changes from Queued to Canceled.

    Workplace Reservation

    The Workplace Reservation Table (sn_wsd_rsv_reservation) is updated with Waitlist origin column. By default, the value in this column is set to False. When a Queued waitlist record is fulfilled and confirmed, a space is assigned and a reservation is created. When a reservation record is created, the Waitlist origin column value changes to True. This column shows how many waitlist records are fulfilled, supporting waitlist management.

    Workplace Reservations table showing the Waitlist origin column.

    • Reservable Module Record: Workplace users can join a waitlist only for a reservable module — for example, desks or meeting rooms. For more information, see Configure a reservable module.
    • Neighborhood: Workplace users can also waitlist on a neighborhood so that preferred neighborhood space allocation is done when the space is free and available for reservation.
    • Weight (Priority): Only event planners can update the weight of a queued waitlist record. Records with the highest weight move to the top of the queue and are allocated a space first. For more information, see Manage reservation waitlist records.
    • Created: If no weight value is set, space allocation follows first-in, first-out (FIFO) logic based on the date and time the waitlist record was created. Records with an earlier start time are prioritized.
    • Fulfilled by: The Fulfilled by column value is updated only when a Workplace Reservation Event Planner manually assigns a space to an employee whose waitlist is in a Queued state. For more information, see Manage reservation waitlist records.

    Reservable Module Configuration

    The following configuration options must be enabled in the Reservable Module Configuration for employees to join a waitlist. For more information, see Configure a reservable module.

    • Enable Waitlist: When selected, enables employees to join a waitlist.
    • Enable browse by Neighborhood: When selected, enables employees to join a waitlist for a neighborhood space and have a preferred neighborhood space assigned when one is available.

      For more information, see Create a reservation waitlist.