Dict-Physical

View VMD_Building

Card of view VMD_Building

Name	VMD_Building
Comment	See documentation on MD_Building in the StarsIssueTracking package.
Dimensional Type	Dimension

SQL query of the view VMD_Building

select
MD_Building_SurrogateKey,
MD_Building_ID,
MD_Building_Name,
MD_Building_Type,
MD_Building_Status,
MD_Building_AgeRange,
MD_Building_YearBuilt,
MD_Building_LastRenovatedRange,
MD_Building_LastRenovatedYear,
MD_Building_FloorCount,
MD_Building_GrossArea,
MD_Building_NetArea
from
MD_Building

List of incoming view references of the view VMD_Building

ViewReference_110

VMF_IssueTrackingTicket

ViewReference_128

VMF_IssueTrackingAssetValue

ViewReference_135

ViewReference_139

ViewReference_142

ViewReference_147

ViewReference_151

VMF_RoomUtilizationByDay

ViewReference_181

VMF_ReadingByHourAccumulating

ViewReference_193

VMF_ReadingByHourSnapshot

ViewReference_201

VMF_PerYearBuildingFacts

ViewReference_208

VMF_ReadingByHourNoAggregations

ViewReference_213

VMF_Building

ViewReference_219

VMF_CardTransaction

ViewReference_231

VMF_KeyedComputerEvent

ViewReference_238

VMF_KeyedComputerInUse

ViewReference_243

VMF_KeyedComputerInUseWithRoomUtilization

List of shortcuts of the view VMD_Building

View

View

View

View

List of diagrams containing the view VMD_Building

ViewsIssueTrackingDiagram

List of permissions of the view VMD_Building

SELECT,VIEW DEFINITION

CardAccessReader

SELECT,VIEW DEFINITION

EnergyReader

SELECT,VIEW DEFINITION

IssueTrackingReader

SELECT,VIEW DEFINITION

SpaceReader

List of view columns of the view VMD_Building

MD_Building_SurrogateKey

numeric

MD_Building_ID

varchar(16)

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

MD_Building_Name

nvarchar(32)

Name of building (not the long name; rather, just a 32-character or less designation for it). Based on BLDG.DESC in Colleague (not BLDG.LONG.DESC).

MD_Building_Type

varchar(32)

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.

MD_Building_Status

varchar(32)

Denotes the building's condition: Active or inactive.

MD_Building_AgeRange

varchar(32)

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).

MD_Building_YearBuilt

int

MD_Building_LastRenovatedRange

varchar(32)

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.

MD_Building_LastRenovatedYear

int

MD_Building_FloorCount

int

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

Defaults to zero.

MD_Building_GrossArea

varchar(32)

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

MD_Building_NetArea

varchar(32)

Net square footage of a building's interior spaces (for easier filtering and reporting).

Home