SPACE USAGE SNAPSHOT Table
XXX
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 |
|
TIME_MONTH_KEY |
Key used only for joining the TIME_MONTH table to other tables, NOT for reporting. |
VARCHAR2 |
6 |
WAREHOUSE_INSERT_TIMESTAMP |
XXX |
TIMESTAMP(6) |