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