This view contains the list of reservable objects in Workplace.
These can be meeting rooms, workplaces, equipment or services (see column “type”).
Data structure
Column |
Meaning |
Comment |
|---|---|---|
reference |
reservable reference for the user |
for end users |
unique_reference |
globally unique reference of a reservable object |
for integrations and automation |
type |
type of reservable object |
Enum: |
name |
name of reservable object |
|
capacity |
capacity (number of seats) of a reservable object |
|
category_name |
name of reservable object category |
|
category_reference |
reference of reservable object category |
|
building_name |
building name where the reservable object is located |
|
building_reference |
building reference where the reservable object is located |
|
floor_name |
floor name where the reservable object is located |
|
floor_reference |
floor reference where the reservable object is located |
|
time_zone |
time zone where the reservable object is located |
values are derived from buildings |
reservable_id |
unique identifier of a reservable object |
primary key |
building_id |
unique identifier of the building where a reservable object is located |
foreign key to locations_v1 |
floor_id |
unique identifier of the building where a reservable object is located |
foreign key to locations_v1 |
dwh_modified_timestamp |
timestamp (in UTC timezone) when this row was modified in the DWH) |