SPACE DETAIL SNAPSHOT Table
View exposing monthly snapshot records of detailed space inventory including building, floor, room, space usage, square footage, room counters, and snapshot timestamps.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
BUILDING_COMPONENT |
Building component associated with the record. |
VARCHAR2 |
8 |
BUILDING_KEY |
Surrogate key identifying the building. |
VARCHAR2 |
8 |
BUILDING_ROOM |
Building room associated with the record. |
VARCHAR2 |
16 |
BUILDING_ROOM_NAME |
Building room name associated with the record. |
VARCHAR2 |
20 |
FLOOR_KEY |
Surrogate key identifying the floor. |
VARCHAR2 |
4 |
ROOM_COUNTER |
Room counter associated with the record. |
NUMBER |
1 |
ROOM_NUMBER |
Room number associated with the record. |
VARCHAR2 |
8 |
ROOM_SQUARE_FOOTAGE |
Room square footage associated with the record. |
NUMBER |
13,2 |
SPACE_UNIT_KEY |
Surrogate key identifying the space unit. |
VARCHAR2 |
6 |
SPACE_USAGE_KEY |
Surrogate key identifying the space usage. |
NUMBER |
7 |
TIME_MONTH_KEY |
Surrogate key identifying the time month. |
VARCHAR2 |
6 |
WAREHOUSE_INSERT_TIMESTAMP |
Warehouse insert timestamp associated with the warehouse record. |
TIMESTAMP(6) |