Dict-Physical

Table MF_Booking

Card of table MF_Booking

Name	MF_Booking
Dimensional Type	Fact
Comment	Facts pertaining to events (such as classes, trips, meetings) or activities occuring at a particular time, and that require the use of a resource, such as a room, or a rental car. The data here is incomplete, since we draw it from EMS (the current room reservation system at Carleton College). EMS has course classroom usage data, but only because of a periodic import the Registrar does. It also has data on meetings and events in certain spaces. But it lacks bedroom/dorm and office usage information. And it lacks information on conference rooms controlled by individual departments, like CMC 6 and CMC 11. Still, the data is basically usable, and can be used to generate graphs depicting usage by time of day - so we can understand better when our buildings are being used and how well. Note that occasionally the utilization data may be skewed for classes, because classes sometimes meet jointly (e.g., two sections in the same room one or two days a week at the same time). Because EMS will not double book, we can only link one of the classes to a given meeting time. EMS also mingles information on room reservations with car reservations and reservations for some objects (equipment, etc.). Still, there is enough here to assemble useful facilities utilization information.

Check constraint name of the table MF_Booking

CKT_MF_BOOKING

List of outgoing references of the table MF_Booking

BookingToBookingEndDate

MD_Date (Shortcut)

MD_Date_BookingEndDate

BookingToBookingEndTime

MD_Time (Shortcut)

MD_Time_BookingEndTime

BookingToBookingStartDate

MD_Date (Shortcut)

MD_Date_BookingStartDate

BookingToBookingStartTime

MD_Time (Shortcut)

MD_Time_BookingStartTime

BookingToEventEndDate

MD_Date (Shortcut)

MD_Date_EventEndDate

BookingToEventEndTime

MD_Time (Shortcut)

MD_Time_EventEndTime

BookingToEventStartDate

MD_Date (Shortcut)

MD_Date_EventStartDate

BookingToEventStartTime

MD_Time (Shortcut)

MD_Time_EventStartTime

Relationship_131

MD_Event

MD_Event_SurrogateKey

Relationship_132

MD_BookedItem

MD_BItem_SurrogateKey

Relationship_133

MD_SetupType

MD_SType_SurrogateKey

Relationship_134

MD_Section (Shortcut)

MD_Sect_SurrogateKey

Relationship_142

MD_Building (Shortcut)

MD_Building_SurrogateKey

Relationship_143

MD_Room (Shortcut)

MD_Room_SurrogateKey

List of referencing views of the table MF_Booking

VMF_Booking

VMF_BOOKING

VMF_BookingSnapshotWithOverlap

VMF_BOOKINGSNAPSHOTWITHOVERLAP

VMF_SlotSnapshotWithOverlap

VMF_SLOTSNAPSHOTWITHOVERLAP

List of diagrams containing the table MF_Booking

StarsSpaceDiagram

List of columns of the table MF_Booking

MF_Booking_ID

DW_CodeDesc

varchar(32)

MF_Booking_SchedulingSystem

DW_CommonName

nvarchar(64)

MD_BItem_SurrogateKey

<None>

numeric

MD_Event_SurrogateKey

<None>

numeric

MD_SType_SurrogateKey

<None>

numeric

MF_Booking_Status

Degenerate dimension indicating a booking or reservation's status. Values here are system-dependent. E.g., if MF_Booking_SchedulingSystem = 'EMS' then this field will likely be one of: Class, Confirmed, or Cancelled.

DW_CodeDesc

varchar(32)

MF_Booking_IsCanceled

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.

DW_YesOrNoNOTNULL

char(3)

MD_Time_BookingStartTime

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.

<None>

int

MD_Time_EventStartTime

<None>

int

MD_Time_EventEndTime

<None>

int

MD_Time_BookingEndTime

<None>

int

MD_Date_BookingStartDate

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.

DW_DateInteger

int

MD_Date_EventStartDate

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.

DW_DateInteger

int

MD_Date_EventEndDate

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.

DW_DateInteger

int

MD_Date_BookingEndDate

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.

DW_DateInteger

int

MD_Sect_SurrogateKey

<None>

numeric

MD_Building_SurrogateKey

<None>

numeric

MD_Room_SurrogateKey

<None>

numeric

MF_Booking_ExpectedAttendees

Count of attendees expected. May be NULL.

<None>

bigint

MF_Booking_ActualAttendees

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

<None>

bigint

MF_Booking_Duration

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.

<None>

bigint

MF_Booking_EventDuration

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.

<None>

bigint

MF_Booking_Count

<None>

int

MF_Booking_HashBytesXsum

Do not expose to users.

Used to make it easier to determine whether a row needs updating or not, by comparing its calculated/new to its existing/old checksum.

DW_ChecksumHashBytes

nvarchar(4000)

4000

MF_Booking_AuditKey

DW_AuditKey

bigint

MF_Booking_Timestamp

<None>

timestamp