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)

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Please do not use this for support questions.
Condeco Support

Post Comment