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) |