Reservation Waitlist data model
Summarize
Summary of Reservation Waitlist data model
The Reservation Waitlist data model in ServiceNow's Yokohama release supports managing waitlist requests, space allocation, and reservation fulfillment for employees within Workplace Reservation Management. It enhances how employees join waitlists for reservable spaces like desks or meeting rooms and how event planners fulfill these requests.
Show less
Key Features
- Reservation Waiting Lists Table (snwsdrsvwaitlist): Tracks waitlist requests with updated columns including Neighborhood, Reservable Module, and Fulfilled by for manual fulfillment by event planners.
- Status Management: Waitlist records have statuses such as Queued (new requests), Confirmed (fulfilled and space assigned), Expired (stale requests removed by scheduled job after 30 days), and Canceled (requests canceled by employees or event planners).
- Workplace Reservation Table (snwsdrsvreservation): Includes the Waitlist origin column to indicate if a reservation originated from fulfilling a waitlist request, supporting reporting and management.
- Reservable Module and Neighborhood: Employees can join waitlists specifically for reservable modules (e.g., desks, meeting rooms) or neighborhoods to receive preferred space allocation when available.
- Priority Handling: Event planners can set a Weight value on queued waitlist records to prioritize allocation, overriding the default first-in, first-out (FIFO) based on creation timestamp.
- Manual Fulfillment: The Fulfilled by column records when an event planner manually assigns a space to fulfill a queued waitlist.
- Configuration Options: Reservable Module Configuration must have "Enable Waitlist" selected to allow employees to join waitlists, and optionally "Enable browse by Neighborhood" to support neighborhood-based waitlisting.
Practical Benefits for ServiceNow Customers
- Streamlines waitlist management by providing clear statuses and automated expiration of stale requests.
- Enables flexible waitlisting for specific spaces or neighborhoods, improving employee experience in space allocation.
- Allows event planners to prioritize and manually fulfill waitlist requests, ensuring critical needs are met efficiently.
- Tracks reservation origins from waitlists to monitor fulfillment rates and manage resource utilization effectively.
- Provides configuration controls to tailor waitlist capabilities to organizational policies and workplace strategies.
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.