| Field |
Description |
| ActualEndUTC |
The actual end date of the booking – when the meeting was ended in UTC |
| ActualStartUTC |
The actual start date of the booking – when the meeting was started in UTC |
| BookedByUserExtnld |
The external ID of the user that made the booking |
| BookedByUserFirstName |
The first name of the user that made the booking |
| BookedByUserId |
The user ID of the user that made the booking |
| BookedByUserLastName |
The last name of the user that made the booking |
| BookingCreateDate |
The date that the booking was created on |
| BookingId |
The unique booking ID – this is the key to the other tables |
| Booking UniqueID |
An internal unique reference for this record |
| BookingSource |
The source of the booking – web/mobile etc. |
| BookingType |
The booking ‘type’ |
| Building |
Which building the booking was made in (part of the geographic hierarchy) |
| CancellationDatetime |
If the booking was cancelled, the date/time of the cancellation |
| Capacity |
The capacity of the resource booked |
| City |
Which city the booking was made in (part of the geographic hierarchy) |
| CleanDownTime |
Clean-down time associated with the booking (minutes) |
| CostCode |
The costcode associated with the booking |
| CostCodeDescription |
The costcode description |
| Country |
Which country the booking was made in (part of the geographic hierarchy) |
| CountryExtnId |
The external ID of the country |
| DeskExtnId |
The external ID of the desk |
| FloorNo |
Which floor the booking was made in (part of the geographich hierarchy) |
| GroupExtnId |
The group external ID |
| HostEmailAddress |
The email address of the booking host |
| HostName |
The hosts name |
| HostTelephone |
The hosts phone number |
| HostUserId |
The hosts user ID |
| HostedByExtnId |
The hosts 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 booked number of attendees |
| PostalCode |
The postcode of the meeting location |
| ReccuranceId |
For recurring meetings, this is the recurrence ID |
| ResourcegroupName |
The group name of the booked resource |
| RegionExtnId |
The regions external ID |
| RequestorByUserExtnId |
The booking requester external ID |
| RequestorEmailAddress |
The booking requester email address |
| RequestorName |
The booking requester name |
| RequestorTelephone |
The booking requester telephone |
| RequestorUserID |
The booking requester user ID |
| ResourceType |
The resource type (desk/room) |
| RoomExtnID |
The rooms external ID |
| RoomId |
The bookings rooms ID |
| RoomName |
The bookings rooms name |
| Roomlayout |
The room layout for this booking |
| SetupTime |
The setup time for the booking (minutes) |
| ScheduledEndUtc |
The booking scheduled end time in UTC |
| ScheduledStartUtc |
The booking scheduled start time in UTC |
| SkypeforBusinessMeeting |
If this is a Skype for Business meeting or not |
| Street |
The booking locations street (part of the geographic hierarchy) |
| VCID |
Video Conference ID |
| WasBumped |
If this booking was bumped (true/false) |
