Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse SPACE USAGE Table


Physical Plant data -- space usage


Field Name

Description

Data Type

Length

SPACE_USAGE

The description of the room's usage, e.g., "LECTURE HALL", "CLASSROOM", "LOBBY".

VARCHAR2

16

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