Relationship_78

MF_SectionMeetsAt

MD_Building_SurrogateKey

Relationship_120

MF_IssueTrackingTicket

MD_Building_SurrogateKey

Relationship_136

MF_Room

MD_Building_SurrogateKey

Relationship_142

MF_Booking

MD_Building_SurrogateKey

Relationship_221

MF_PerYearBuildingFacts

MD_Building_SurrogateKey

Relationship_255

MF_KeyedComputerSoftwareUsage

MD_Building_SurrogateKey

Relationship_268

MF_KeyedComputerEvent

MD_Building_SurrogateKey

VMF_RoomAssignmentSnapshotCoverage

VMF_ROOMASSIGNMENTSNAPSHOTCOVERAGE

MD_Building_ID

Unique identifier in Colleague for building. Do not expose to users.

DW_CodeDescShort

varchar(16)

16

MD_Building_Group

Not currently used.

May be used to group buildings according to some reporting or other useful scheme yet to be determined.

DW_CodeDesc

varchar(32)

32

MD_Building_Type

In Colleague, this is just the type or category of a building (e.g., "student residence").

As of 2010, there is no way to represent multiple uses for a building in Colleague. As a workaround, therefore, the people who maintain this data create multiple buildings where just one physical structure exists - one building per primary use (e.g., the LDC, which is for classrooms and departments - mainly languages - but it's also a dining hall, and therefore has two distinct building entries in Colleague).

If we change this practice, we will probably need to rename this field as MD_Building_PrimaryType, and retain only the primary value.

DW_CodeDesc

varchar(32)

32

MD_Building_Longitude

<None>

float

MD_Building_Elevation

<None>

float

MD_Building_AgeRange

Age of building, discretized into ranges. Calculated based on BLDG.CONSTRUCTION.YEAR in Colleague (since it's multivalued, we take the earliest year in the list).

DW_CodeDesc

varchar(32)

32

MD_Building_LastRenovatedRange

How many years ago a given building was last renovated, discretized into ranges (e.g., 0-5 years ago).

Note that in Colleague this is a multi-valued field. Here we use only the last-renovated date.

DW_CodeDesc

varchar(32)

32

MD_Building_PrimaryConstructionType

Primary construction type for a building. The key here is that a building may have many construction types. We take only the first or primary one in Colleague (BLDG.CONSTRUCTION.TYPE).

DW_CodeDescShort

varchar(16)

16

MD_Building_PrimaryContractor

DW_CommonName

nvarchar(64)

64

MD_Building_ContentsValueRange

Value of building's contents (not the building itself). This is typically itemized separately for insurance purposes.

The value here has been discretized or "banded" for easier use in reports.

Currently not used.

DW_CodeDesc

varchar(32)

32

MD_Building_StudentsAssigned

How many students are assigned to a given building (typically a dorm), i.e., how many students (can) sleep there (discretized).

Calculated by adding up a count of all assignments to rooms in a given building where the status of the assignment = "Assigned" (not, e.g., "Canceled").

The value given here is for the current term, and will therefore change relatively frequently.

DW_CodeDesc

varchar(32)

32

MD_Building_ClassroomCount

Count of classrooms in a particular building. Discretized into ranges for easy reporting.

DW_CodeDesc

varchar(32)

32

MD_Building_FloorCount

Count of floors in a building (not the ordinal number of the top floor).

Defaults to zero.

<None>

int

MD_Building_Size

Based on BLDG.SIZE in Colleague. Not sure what this will contain yet.

DW_CodeDesc

varchar(32)

32

MD_Building_GrossArea

Gross square footage of a building's interior spaces, discretized into ranges (for easier filtering and reporting).

DW_CodeDesc

varchar(32)

32

MD_Building_IsAccessible

Whether a building is accessible by ADA standards (to people with disabilities).

DW_YesNoOrUnknown

varchar(7)

7

MD_Building_IsLandmark

"Yes" if a building is considered to hold landmark status.

DW_YesNoOrUnknown

varchar(7)

7

MD_Building_AuditKey

DW_AuditKey

bigint

MD_BUILDING_AK

TRUE

FALSE

FALSE

FALSE

TRUE

MD_Building

AltKey