SPACE DETAIL Table
View exposing current detailed space inventory records including building, floor, room, space usage, square footage, room counters, and building component attributes.
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 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |