SPACE DETAIL Table
Physical Plant data -- rooms.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
BUILDING_COMPONENT |
This field identifies the component of multi-component buildings to which a room belongs. For example, 14W, 14N, 14E, and 14S are components of building 14. The component is often found in the first part of the BUILDING_ROOM, such as 14S-332. |
VARCHAR2 |
8 |
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_ROOM |
The combined building and room number of a particular room or space within an MIT building: for example, N42-240X is room 240X in Building N42. |
VARCHAR2 |
16 |
BUILDING_ROOM_NAME |
The room name, e.g., E34-180 |
VARCHAR2 |
20 |
FLOOR_KEY |
Key field used to join the SPACE_DETAIL table and the SPACE_FLOOR table. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
3 |
ROOM_COUNTER |
Used to count rooms within a group on a report. Always contains a value of 1. |
NUMBER |
1 |
ROOM_NUMBER |
The identification/location number of a room on a floor of a building. For example: room E19-332B is on the third floor of building E19. Explanation: The characters before the hyphen always indicate the MIT building number; the room number follows the hyphen, and the initial digit(s) indicate the floor of the building. |
VARCHAR2 |
6 |
ROOM_SQUARE_FOOTAGE |
The room's square footage. |
NUMBER |
22 |
SPACE_UNIT_KEY |
Key field used to join to the SPACE_UNIT table. This field should only be used for joining data, NOT for reporting. |
NUMBER |
22 |
SPACE_USAGE_KEY |
Key field used to join to the SPACE_USAGE table. This field should only be used for joining data, NOT for reporting. |
NUMBER |
22 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |