Dict-Physical

Table MF_Room

Card of table MF_Room

Name	MF_Room
Dimensional Type	Fact
Comment	Areas and capacities of rooms. This data comes in at the granularity of one row per room. It has no longitudinal/date component. This fact table has limited utility. Typically, what people will use instead are views such as VMF_RoomUtilization and VMF_RoomUtilizationByDay, which tell us how well we're utilizing bookable space on campus. This table is uniquely useful, however, in doing things like quickly assembling square footage information on rooms, and on space occupied by various departments. Area and/or capacity may be NULL. Count will always be 1.

Check constraint name of the table MF_Room

CKT_MF_ROOM

List of outgoing references of the table MF_Room

Relationship_135

MD_Room (Shortcut)

MD_Room_SurrogateKey

Relationship_136

MD_Building (Shortcut)

MD_Building_SurrogateKey

Relationship_137

MD_CarletonDepartment (Shortcut)

MD_CarlDept_SurrogateKey

List of diagrams containing the table MF_Room

StarsSpaceDiagram

List of columns of the table MF_Room

MD_Room_SurrogateKey

<None>

numeric

MD_CarlDept_SurrogateKey

<None>

numeric

MD_Building_SurrogateKey

<None>

numeric

MF_Room_Area

Room area in square feet. May be NULL, since not all rooms/spaces have area values entered into Colleague.

<None>

int

MF_Room_Capacity

Room capacity in people (i.e., an integer count). May be NULL, since not all rooms actually have capacities marked in Colleague.

<None>

int

MF_Room_Count

Count of applicable rooms. Do not use as the divisor in average area and capacity calculations, since the area and/or capacity may be null.

<None>

int

MF_Room_AuditKey

DW_AuditKey

bigint

MF_Room_Timestamp

<None>

timestamp

List of indexes of the table MF_Room

MF_ROOM_PK

TRUE

TRUE

TRUE

FALSE

FALSE

RELATIONSHIP_136_FK

FALSE

FALSE

FALSE

TRUE

FALSE

RELATIONSHIP_137_FK

FALSE

FALSE

FALSE

TRUE

FALSE

List of keys of the table MF_Room

Identifier_1