This data dictionary provides information about the available data in custom dashboards. It includes information on column definitions and values for data interpretation.
Desk & desk reservation data
|
Column Name |
Column Definition |
Column Details/Tips |
|---|---|---|
|
Actual End Time |
The actual time at which the reservation ended is determined by desk policies. |
If the actual end time reflects when the meeting was canceled or when it was ended. It will be null if the canceled time is before the planned start time. |
|
Actual Start Time |
The actual time at which the reservation began was determined by desk policies. |
If the desk requires check-in, the actual start time is the time at which the desk was checked into. If the desk does not require check-in, then it equals the planned start time. If the desk was canceled before the planned start time,it will be null. |
|
Assignee Department |
All departments that the assignee is associated with. |
If a user is associated with more than one department, the department names will be separated by commas. Note, department information is only reflected for Enterprise customers using OKTA and Azure AD. |
|
Assignee Email |
Email of the person whom the desk reservation was for. |
This includes non-Robin users who are assigned a desk by an email address only. |
|
Assignee Groups |
All groups that the assignee is associated with. |
If a user is associated with more than one group, the group names will be separated by commas. |
|
Assignee Name |
Name of the person for whom the desk reservation was for. |
|
|
Building |
The name of the location the desk resides in. |
|
|
Building ID |
The unique identifier of the location the desk resides in. |
|
|
Building Open |
Provides details on if this location is open. |
Open = True; Closed = False; Null =? |
|
Campus |
The name of the campus the desk resides in. |
|
|
Campus ID |
The unique identifier of the campus the desk resides in. |
|
|
Canceled |
Verifies if the reservation was canceled. |
True= Cancelled; False = Not cancelled; |
|
Canceled at |
The time at which a reservation was canceled by a user. |
A desk reservation can have a cancellation and check-in if the desk reservation was canceled after the user checked in to the desk. |
|
Cancellation Type |
This indicates how the reservation was canceled. |
There are 2 types: Automatic: Canceled via abandoned desk protection, a Robin setting managed by your administrator. Manual: Canceled programmatically by the API or by an end-user. |
|
Checked In |
Verifies if the reservation was checked into. |
True= Checked in; False = Not checked in; |
|
Checked In At |
The time at which a reservation was manually or automatically checked in. |
Null value if check-in is not required for the desk. |
|
Creator Department |
All departments that the creator is associated with. |
If a user is associated with more than one department, the department names will be separated by commas. Note, that department information is only reflected for Enterprise customers using OKTA and Azure AD. |
|
Creator Email |
Email of the person who made the reservation. |
|
|
Creator Groups |
All groups that the creator is associated with. |
If a user is associated with more than one group, the group names will be separated by commas. |
|
Creator Name |
Name of the person who made the reservation. |
|
|
Reservation Date |
The day of the desk reservation or the day that the desk was available. |
The date is always in UTC format. |
|
Desk Disabled |
Informs whether the desk is available for reservation. |
Bookable = False; Disabled = True; |
|
Desk Group |
The name of the group the desk resides in. |
|
|
Desk Group ID |
The unique identifier of the group the desk resides in. |
|
|
Desk ID |
The unique identifier number of the desk in Robin. |
|
|
Desk |
The human-readable name of the desk. This is the desk name that appears in search results and other parts of the user interface. |
|
|
Desk Type |
The type of desk - hoteled, assigned, or hot that is set by the administrator that informs how the desk can be booked. |
|
|
End Time |
When the desk reservation ended. |
|
|
Floor |
The floor the desk resides in. |
|
|
Floor ID |
The unique identifier of the floor the desk resides in. |
|
|
Actual Hour Duration |
This is the total time reserved within the desk reservation specified in hours down to 2 decimal places. |
This includes hot, hotel, or shared desks ("reverse hoteled") reservations. This field will be null for assigned desks, and if meetings are seconds long - our system rounds it to ‘0.00’ and displays null. |
|
Organization |
This is the name of the organization where the desk reservation took place. |
|
|
Organization ID |
The unique identifier for your organization. |
|
|
Planned Start Time |
The start time of the reservation when booked. |
|
|
Reservation ID |
The unique identifier for each reservation, regardless of type. |
If the reservation is part of a multi-day series, the Series ID appears as a prefix followed by a formatted timestamp that represents the start time of that specific instance in the recurring series. |
| Reservation Type | Represents the type of reservation created on a desk. | Hot, Hotel, reverse hoteled, or assigned reservation, |
| Series ID | For multi-day desk reservations created on the web (and coming soon, mobile), this is the unique identifier for the reservation as a whole. | For single-day desk reservations and older, non-recurring reservations (where a multi-day reservation was a single, continuous block of time), this is NULL. |
| Start Time | The expected time at which the desk reservation was scheduled to start. | If a desk was checked in past the reserved start time, it will still how the time at which the desk reservation was scheduled to start. |
Space reservation data
|
Column Name
|
Column Definition
|
Column Details/Tips
|
|---|---|---|
| Actual Start Time | This is the time at which the meeting actually started, depending on the meeting room policies. | If the meeting room requires check-in, the actual start time reflects when the meeting was checked into. If the meeting does not require check-in, the actual start time equals the planned start time. If the meeting was canceled before the planned start time, the actual start time is null. |
| All day meeting | This indicates if the event was an all-day event or not, as reported from the calendar. | True = All-day event; False = Not all day event. |
| Attendees |
The total number of people who have not explicitly declined the meeting invitation. |
Attendees are people who have been added to a meeting/event and do not reflect those who were actually in the office or joining virtually. Null means there were 0 attendees. |
| Automatically Unbooked At | If the meeting was canceled automatically due to no-shows, this field shows the time of cancelation. Shown in UTC. |
This feature requires room displays with Abandoned Meeting Protection enabled. |
| Building | The building in which the meeting took place | |
| Building ID | The unique identifier of the location the space resides in. | |
| Campus | The name of the campus the space resides in. | |
| Campus ID | The unique identifier of the campus the space resides in. | |
| Canceled | Informs whether the meeting was canceled or occurred. | |
| Canceled At | Provides the time and date stamp in UTC of when the meeting was canceled. | |
| Cancellation Type | Synced: The event was canceled on the remote calendar, and then the canceled event was synced to Robin.Automatic: The event was automatically canceled by Robin via abandoned meeting protection.Manual: The event was canceled programmatically by the API or by an end-user in the Robin Dashboard.Synced deletion: The event was removed from the room's resource calendar and is considered by Robin as cancelled. | |
| Capacity | The capacity of the space where the meeting took place. | Compare the capacity to the total attendees to understand if employees are selecting spaces that are a good fit. |
| Checked in At | Shows the time at which the meeting was confirmed (e.g., from the room display, mobile app, web dashboard, etc) as a timestamp in UTC. | |
| Created At | This timestamp shows when the event was created. This timestamp is in UTC. | |
| Created by email | This is the email address of the person who created the meeting. | |
| Creator department | All departments that the creator is associated with. | If a user is associated with more than one department, the department names will be separated by commas. Note department information is only reflected for Enterprise customers using OKTA and Azure AD. |
| Creator groups | This indicates all groups that the user who created the meeting is assigned to. | If a user is associated with more than one group, the group names will be separated by commas |
| Creator Name | This is the user name of the Robin user who created the meeting. | This field will be blank if the person creating the meeting does not have a Robin account. |
| Creator Robin Email | This is the email address of the Robin user who created the meeting. | This field will be blank if the person creating the meeting does not have a Robin account. |
| Creator Robin ID | This is the Robin user ID of the person who created the meeting. | This field will be blank for a couple of reasons: the person creating the meeting does not have a Robin account, and this was an ad hoc meeting booked using a room display. |
| Actual End Time | This is the end time of the meeting. Reported in UTC. | |
| Meeting ID | This is the unique identifier Robin assigns to the event | |
| Floor | The floor or level on which the meeting took place. | Sort by level to compare utilization across floors. |
| Floor ID | The unique identifier of the floor the space resides in. | If a map or floor is not set up, the floor ID will show null value. This is because spaces do not require a map to be reserved and alternatively can be connected to a location or campus but not a floor. |
| Hosting Calendar Email | This is the host’s calendar the event was created on. | |
| Host Department | All departments that the host is associated with. | If a user is associated with more than one department, the department names will be separated by commas. Note, that department information is only reflected for Enterprise customers using OKTA and Azure AD. |
| Host Groups | This indicates all groups that the host of the event is assigned to. | If the host is associated with more than one group, the group names will be separated by commas. |
| Host Robin Email | This is the email address of the person who is hosting the event. | |
| Host Robin ID | This is the Robin ID of the user or calendar the event was created on. | |
| Host Robin Name | This is the username of the person who is hosting the meeting. | |
| Invited People | The total number of people invited to the meeting. | |
| Is Recurring | Indicates whether the meeting is a recurring meeting. | True indicates the meeting is/was a part of a recurring meeting series. False indicates the meeting was a single event. |
| Location | The location of the meeting/event. | This is pulled from the location field in the meeting invite. This may be the same as the space or other information added by the meeting organizer. |
| Minutes Delayed | This field indicates whether the meeting started on time by comparing the check-in timestamp with the event start time by subtracting the check-in time from the actual start time, in the event it was confirmed more than a minute after the start time. | Null = Either there was no check-in, or it was checked into before or under 60 seconds after the start time. |
| Actual Minute Duration | This is the total duration of the meeting in minutes. | |
| Organization | This is the organization's name where the meeting took place. | |
| Organization ID | The unique identifier of your company. | |
| Reservation Date | This is the date for which the meeting was scheduled in a space. | |
| Room Declined | Room declined is true when the resource calendar for the room being booked rejects the request. This can happen if there is a conflict or if the calendar has scheduling restrictions. | |
| Space | This is the space in which the event took place. | |
| Space ID | This is the unique identifier Robin assigns to each space | |
| Space Type | This describes the type of space. | |
| Planned Start Time | This is the start time of the meeting when scheduled. Reported in UTC. | |
| Updated At | A timestamp that shows when the most recent change was made to the event in UTC. | Changes may include editing the time or location of the event, updating the invitees, or changes to the event’s status. |
| Title | This is the title of the meeting. | If this field is null, the meeting has no title. If this field is "Reserved", this meeting is marked as private. If the field contains “Meeting in…”, this meeting is considered adhoc. |
People Roster data
|
Column Name
|
Column Definition
|
Column Details/Tips
|
|---|---|---|
| Active | This indicates whether the user is active or deactivated. | |
| Created At | The date at which the user was created or added to Robin. | |
| Default Building | The default building is set by the user in their user profile and settings. | |
| Department | The department that the user is associated with. | |
| The user’s email. | ||
| Groups | This indicates all groups that the user is assigned to. | |
| Invitation Accepted | This indicates whether the user accepted the invitation or not. | |
| Name | The name of the user. | |
| Organization Id | The unique identifier of your company. | |
|
Roles |
This indicates all roles that the user is assigned to. |
|
|
User ID |
The unique identifier of the user. |