Reservation Waitlist data model
Summarize
Summary of Reservation Waitlist data model
The Reservation Waitlist data model in the Zurich release supports managing waitlist requests, space allocation, and reservation fulfillment for employees within Workplace Reservation Management. It enables employees to join waitlists for reservable modules like desks or meeting rooms and neighborhoods, helping optimize space usage and reservation processes.
Show less
Key Features
- Reservation Waiting Lists Table (snwsdrsvwaitlist): Tracks waitlist requests with added columns such as Neighborhood, Reservable Module, and Fulfilled by for manual event planner fulfillment.
- Status Management: Waitlist entries progress through statuses—Queued (new requests), Confirmed (space assigned and reservation created), Expired (stale requests removed via scheduled job), and Canceled (requests canceled by employee or event planner).
- Workplace Reservation Table (snwsdrsvreservation): Includes a Waitlist origin column to indicate if a reservation originated from a waitlist fulfillment, useful for reporting and management.
- Reservable Module and Neighborhood Waitlisting: Employees can join waitlists for specific reservable modules or entire neighborhoods to receive preferred space allocations when available.
- Priority and Queue Management: Event planners can assign a priority weight to queued waitlist records, influencing the allocation order. Without a set weight, allocation follows a first-in, first-out (FIFO) system based on request creation time.
- Manual Fulfillment: Event planners can manually assign spaces to queued waitlist requests, updating the Fulfilled by column accordingly.
- Configuration Options: Reservable modules must have “Enable Waitlist” selected to allow employees to join waitlists, and “Enable browse by Neighborhood” activated to support neighborhood-based waitlisting.
Practical Application for ServiceNow Customers
ServiceNow customers can use this data model to efficiently manage reservation waitlists, automate expiration of stale requests, and prioritize space allocation based on configurable weights or FIFO logic. The model supports both employee self-service waitlisting and manual event planner interventions, enhancing flexibility and control over workplace space utilization.
By enabling the appropriate configuration options in reservable modules, customers ensure employees have the ability to join waitlists tailored to their workspace preferences, improving user satisfaction and operational efficiency.
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 .
- 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.
- 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.