Dict-Physical

View VMF_Booking

Card of view VMF_Booking

Name	VMF_Booking
Comment	See documentation on MF_Booking in the StarsSpace package. The underlying dimension is populated from our room scheduling system (EMS as of 2010). If you're looking for the views underlying the room utilization graphs/charts, note that these are special (terribly performing) views that utilize coverage tables, so we can calculate usage / capacity ratios. See documentation, e.g., on VMF_BookingSnapshotCoverage.
Dimensional Type	Fact

SQL query of the view VMF_Booking

select
MF_Booking_ID,
MF_Booking_SchedulingSystem,
MD_BItem_SurrogateKey,
MF_Booking_IsCanceled,
MD_Time_BookingStartTime,
MD_Time_EventStartTime,
MD_Time_EventEndTime,
MD_Time_BookingEndTime,
MD_Date_BookingStartDate,
MD_Date_EventStartDate,
MD_Date_EventEndDate,
MD_Date_BookingEndDate,
MD_Sect_SurrogateKey,
MD_Building_SurrogateKey,
MD_Room_SurrogateKey,
MD_Event_SurrogateKey,
MD_SType_SurrogateKey,
MF_Booking_ExpectedAttendees,
MF_Booking_ActualAttendees,
MF_Booking_Duration,
MF_Booking_EventDuration,
/*
* Attendee clock hours are a standard measure used primarily with
* class (course) events. In that case they're called "student clock
* hours." The calculation is done by multiplying the number of
* scheduled hours for a class x the number of students enrolled in
* the class. Below we divide by 3600 because MF_Booking_Duration is
* measured in seconds.
*/
CAST((
CASE MF_Booking_Duration
WHEN 0 THEN ISNULL(MF_Booking_EventDuration, 0)
ELSE MF_Booking_Duration
END
*
CASE MF_Booking_ActualAttendees
WHEN 0 THEN ISNULL(MF_Booking_ExpectedAttendees, 0)
ELSE MF_Booking_ActualAttendees
END) / 3600 AS NUMERIC(17,2)) AS MF_Booking_AttendeeClockHours,
/*
* Event clock hours are like attendee clock hours, except that they
* count only the duration of the booked event, and the result is not
* multiplied by the number of attendees.
*/
CAST((
CASE MF_Booking_Duration
WHEN 0 THEN ISNULL(MF_Booking_EventDuration, 0)
ELSE MF_Booking_Duration
END) / 3600 AS NUMERIC(17,2)) AS MF_Booking_EventClockHours,

MF_Booking_Count
from
MF_BOOKING

List of outgoing view references of the view VMF_Booking

ViewReference_130

ViewReference_131

ViewReference_132

ViewReference_133

ViewReference_134

ViewReference_135

VMD_Building (Shortcut)

ViewReference_136

VMD_Room (Shortcut)

ViewReference_137

VMD_Section (Shortcut)

List of referenced objects of the view VMF_Booking

MF_Booking

List of diagrams containing the view VMF_Booking

ViewsSpaceDiagram

List of permissions of the view VMF_Booking

SELECT,VIEW DEFINITION

EnergyReader

SELECT,VIEW DEFINITION

SpaceReader

List of view columns of the view VMF_Booking

MF_Booking_ID

varchar(32)

MF_Booking_SchedulingSystem

nvarchar(64)

MD_BItem_SurrogateKey

numeric

MF_Booking_IsCanceled

char(3)

This field will be 'Yes' if a given booking is cancelled. 'No ' otherwise. The information provided here is, to some extent, redundant, since we also have MF_Booking_Status.

MD_Time_BookingStartTime

int

Integer representing the time of day in the format HHMMSS (e.g., 23:01:01 at one minute one second after eleven o'clock in the evening). Not typically used for reporting.

Unlike MD_Date_Dateinteger (in MD_Date), this integer is not really human-readable, because it's not set up for base-10. Rather, it's calculated using the formula: (hour << 16) Or (min << 8) Or (sec), where the Or's are logical, and the << operator is a binary left shift.

MD_Time_EventStartTime

int

MD_Time_EventEndTime

int

MD_Time_BookingEndTime

int

MD_Date_BookingStartDate

int

Integer representation of the date (e.g., 20070101 for 1 Jan 2007). Defaults to 99991231, for situations where a date is required but none is available.

MD_Date_EventStartDate

int

Integer representation of the date (e.g., 20070101 for 1 Jan 2007). Defaults to 99991231, for situations where a date is required but none is available.

MD_Date_EventEndDate

int

Integer representation of the date (e.g., 20070101 for 1 Jan 2007). Defaults to 99991231, for situations where a date is required but none is available.

MD_Date_BookingEndDate

int

Integer representation of the date (e.g., 20070101 for 1 Jan 2007). Defaults to 99991231, for situations where a date is required but none is available.

MD_Sect_SurrogateKey

numeric

MD_Building_SurrogateKey

numeric

MD_Room_SurrogateKey

numeric

MD_Event_SurrogateKey

numeric

MD_SType_SurrogateKey

numeric

MF_Booking_ExpectedAttendees

bigint

Count of attendees expected. May be NULL.

MF_Booking_ActualAttendees

bigint

Count of people who actually attended. May be NULL. Typicall this figure is not maintained, or is maintained badly.

MF_Booking_Duration

bigint

Duration of a booking in seconds (may be converted to other time values). Note that this is not the same thing as the actual duration of the event itself, because a booking may include setup and cleanup/takedown time.

MF_Booking_EventDuration

bigint

Duration of an event in seconds (may be converted to other time values). Note that this is not necessarily the same thing as the full duration of the booking associated with an event, because a booking may include setup and cleanup/takedown time. The value here is just that of the event.

MF_Booking_AttendeeClockHours

MF_BOOKING_EVENTCLOCKHOURS

MF_Booking_Count

int

Home