BUILDINGS Table
View exposing building reference data including building identifiers, names, addresses, square footage measures, and related facilities attributes associated with MIT physical infrastructure.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
BLDG_ASSIGNABLE_SQUARE_FOOTAGE |
Bldg assignable square footage as provided by the source. |
NUMBER |
13,2 |
BLDG_GROSS_SQUARE_FOOTAGE |
Bldg gross square footage as provided by the source. |
NUMBER |
13,2 |
BUILDING_COUNTER |
Building counter as provided by the source. |
NUMBER |
|
BUILDING_KEY |
Surrogate key identifying the building. |
VARCHAR2 |
8 |
BUILDING_MAILING_ADDRESS |
Building mailing address as provided by the source. |
VARCHAR2 |
80 |
BUILDING_NAME |
Building name as provided by the source. |
VARCHAR2 |
64 |
BUILDING_NUMBER |
Building number as provided by the source. |
VARCHAR2 |
8 |
BUILDING_STREET_ADDRESS |
Building street address as provided by the source. |
VARCHAR2 |
36 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |