|
Field
|
Description
|
| ActualEndDateTime |
The actual date and time the booking was ended. Native time zone. |
| ActualEndUTC |
The actual end date and time of the booking – when the booking was ended in the UTC time zone. |
| ActualStartDateTime |
The actual date and time the booking was started. Native time zone. |
| ActualStartUTC |
The actual start date and time of the booking – when the booking was started in the UTC time zone. |
| BookedByUserExtnld |
The external ID of the user who made the booking. |
| BookedByUserFirstName |
The first name of the user who made the booking. |
| BookedByUserId |
The user ID of the user who made the booking. |
| BookedByUserLastName |
The last name of the user who made the booking. |
| BookedByUserName |
The username of the user who made the booking. |
| BookingCreateDate |
The date the booking was created. |
| BookingId |
The unique booking ID – this key is associated with other tables. |
| Booking UniqueID |
An internal unique reference for this record. |
| BookingSource |
The source of the booking – web/mobile etc. |
| BookingType |
The booking ‘type’ set on the booking form (usually, 'internal' or 'external'). |
| Building |
Which building the booking was made in (part of the geographic hierarchy). |
| BusinessEnd |
Business end time set for business hours in the group settings. |
| BusinessStart |
Business start time set for business hours in the group settings. |
| CancellationDateTime |
The date and time the booking was canceled. |
| Capacity |
The capacity of the booked meeting space resource. |
| City |
Which city the booking was made in (part of the geographic hierarchy). |
| CleanDownTime |
Clean-down time associated with the booking (minutes). |
| CostCode |
The cost code associated with the booking. |
| CostCodeDescription |
The cost code description. |
| Country |
Which country the booking was made in (part of the geographic hierarchy). |
| CountryExtnId |
The external ID of the country. |
| Currency |
The currency code set for the location.
|
| DeskExtnId |
The external ID for the personal space resource. |
| FloorExtnId |
The external ID for the floor. |
| FloorNo |
Which floor the booking was made on (part of the geographic hierarchy). |
| GroupExtnId |
The group external ID. |
| HostEmailAddress |
The email address of the booking host. |
| HostName |
The name of the booking host. |
| HostTelephone |
The booking host's phone number. |
| HostUserId |
The booking host's user ID. |
| HostedByExtnId |
The booking host's external ID. |
| IsDeleted |
If the meeting was deleted, this is true. |
| IsPrimary |
If this is a primary room for a multi-room booking, then is true. |
| IsPrivateMeeting |
If this is a private meeting, then this is true. |
| LocationExtnId |
The booking locations external ID. |
| LocationId |
The booking location ID that the booking was made in (part of the geographic hierarchy). |
| LocationName |
The booking location name that the booking was made in (part of the geographic hierarchy). |
| LocationTimeZone |
The booking locations time zone. |
| MeetingTitle |
The meeting/booking title. |
| NumOfAttendees |
The number of attendees added to the booking. |
| PostalCode |
The postcode of the meeting location. |
| ReccuranceId [sic] |
The recurrence ID for recurring bookings. |
| ResourceGroupName |
The group name for the booked resource. |
| RegionExtnId |
The external ID for the Region. |
| RequestorByUserExtnId |
The booking requester external ID. |
| RequestorEmailAddress |
The booking requester's email address. |
| RequestorName |
The booking requester's name. |
| RequestorTelephone |
The booking requester's telephone. |
| RequestorUserID |
The booking requester's user ID. |
| ResourceGroupId |
The group ID for the booked resource group. |
| ResourceSubType |
The resource sub-type (room, bookable desk, fixed desk, or flexi desk). |
| ResourceType |
The resource type (meeting space/personal space). |
| RoomExtnID |
The external ID for the booked room. |
| RoomId |
The room ID for the booked room. |
| RoomName |
The name of the booked meeting space. |
| Roomlayout |
The room layout selected for the booking. |
| SetupTime |
The setup time for the booking (minutes). |
| ScheduledEnd |
The scheduled end date and time for the booking in the native time zone. |
| ScheduledEndUtc |
The scheduled end date and time for the booking in the UTC time zone. |
| ScheduledStart |
The scheduled start date and time for the booking in the native time zone. |
| ScheduledStartUtc |
The scheduled start date and time for the booking in the UTC time zone. |
| SkypeforBusinessMeeting |
If this booking is a Skype for Business meeting (true/false). |
| Street |
The booking locations street (part of the geographic hierarchy). |
| VCID |
Video Conference ID. |
| WasBumped |
If this booking was bumped (true/false). |
