BUILDINGS Table
Physical Plant data -- buildings
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
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 |