Skip to main content

 

Eptura Knowledge Center

Azure table storage fields

Table: Bookings

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

Table: Booking items

Field
Description
BookingId The unique booking ID – this is the key to the other tables.
CostPerHours The booking costs per hour.
Currency The currency of the costs of this item.
Price The price of this item.
Quantity The number of this item.
ScheduledEnd The booking scheduled end time in local time.
ScheduledEndUtc The booking scheduled end time in UTC.
ScheduledStart The booking scheduled start time in local time.
ScheduledStartUtc The booking scheduled start time in UTC.
Title The booking item title.
VendorId The booking vendors ID.

Table: Booking Attendees

Field
Description
BookingId The unique booking ID – this is the key to the other tables.
Company The attendee’s company.
Email The attendee’s email address.
Firstname The attendee’s first name.
isInternal If the attendee is an internal attendee.
LastName The attendee’s last name.
Telephone The booking attendee’s phone number.
UserId The booking attendees ID (for internal attendees).