Dict-Physical

Table MF_RoomAssignment

Card of table MF_RoomAssignment

Name	MF_RoomAssignment
Dimensional Type	Fact
Comment	Dorm and office assignments are kept here, as of 2010. Other sorts of room assignments will be added as time goes on. Note that rooms (classrooms, conference rooms, etc.) that are assigned in EMS are not kept here. They are kept in MF_Booking, because their granularity is per booked item, not per person per booked item/room, as here. Since the grain of this table is one row per person per room (with multiple people often occuping the same room), the MD_RoomAsgn_Count variable can be aggregated by room and by period (e.g., term) used as an attendee count. Summer dorm-room bookings, e.g., reunion bookings, are not available here.

Check constraint name of the table MF_RoomAssignment

CKT_MF_ROOMASSIGNMENT

List of outgoing references of the table MF_RoomAssignment

Relationship_138

MD_Building (Shortcut)

MD_Building_SurrogateKey

Relationship_139

MD_Room (Shortcut)

MD_Room_SurrogateKey

Relationship_140

MD_Date (Shortcut)

MD_Date_AssignmentStart

Relationship_141

MD_Date (Shortcut)

MD_Date_AssignmentEnd

Relationship_144

MD_Employee (Shortcut)

MD_CollPers_SurrogateKeyEmp

Relationship_145

MD_DegreeStudent (Shortcut)

MD_CollPers_SurrogateKeyDStu

List of diagrams containing the table MF_RoomAssignment

StarsSpaceDiagram

List of columns of the table MF_RoomAssignment

MF_RoomAsgn_ID

DW_CodeDesc

varchar(32)

MF_RoomAsgn_AssignmentSystem

DW_CommonName

nvarchar(64)

MD_Room_SurrogateKey

<None>

numeric

MD_Building_SurrogateKey

<None>

numeric

MD_Date_AssignmentStart

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_AssignmentEnd

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_CollPers_SurrogateKeyEmp

<None>

numeric

MD_CollPers_SurrogateKeyDStu

<None>

numeric

MF_RoomAsgn_IsCanceled

DW_YesOrNoNOTNULL

char(3)

MF_RoomAsgn_IsPrimary

Often someone will have multiple office assignments, and in those cases one office is the primary one. In such cases, the value will be 'Yes' here, and 'No' for the secondary office assignment(s). In cases like dorm rooms, where assignments are as a rule made only on a one-to-one basis (nobody gets more than one room), the value here will be 'Not Applicable'.

DW_YesNoOrNotApplicable

varchar(16)

MF_RoomAsgn_Duration

Duriation of room assignment in seconds (usually converted to some other value).

<None>

bigint

MF_RoomAsgn_Count

<None>

int

MF_RoomAsgn_HashBytesXsum

DW_ChecksumHashBytes

nvarchar(4000)