BUILDINGS Table

BLDG_ASSIGNABLE_SQUARE_FOOTAGE

The net assignable square footage of a building that can be occupied and assigned/reassigned by the DLC inhabiting the building. Excludes stairwells, mechanical spaces, etc..

NUMBER

22

BLDG_GROSS_SQUARE_FOOTAGE

This is the building's total square footage.

NUMBER

22

BUILDING_COUNTER

Used to count buildings within a group on a report. Always contains a value of 1.

NUMBER

1

BUILDING_KEY

Key field used to join to the BUILDINGS table. This field should only be used for joining data, NOT for reporting.

VARCHAR2

8

BUILDING_MAILING_ADDRESS

The official mailing address of an MIT building, e.g., "77 Massachusetts Ave" for most MIT buildings. The mailing address is not usually the actual street address.

VARCHAR2

80

BUILDING_NAME

The official MIT name given to a building. For example: Weisner Building, Horace Sayford Ford Building

VARCHAR2

64

BUILDING_NUMBER

The official MIT number given to a building. For example: N42, E19, W89

VARCHAR2

6

BUILDING_STREET_ADDRESS

The actual street address of an MIT building, e.g., "211 Massachusetts Ave" for Bldg. N42. The street address is not usually the official MIT mailing address, which is 77 Mass Ave for most buildings.

VARCHAR2

36

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE

8