SPACE ROOM Table
View exposing current room classification records including room numbers, classification codes, user-defined room attributes, DLC, and audit fields.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CLASSIFICATION_CODE |
Code identifying classification. |
VARCHAR2 |
50 |
DLC_KEY |
Surrogate key identifying the dlc. |
VARCHAR2 |
50 |
LAST_UPDATE_BY |
Last update by associated with the record. |
VARCHAR2 |
8 |
LAST_UPDATE_TIME |
Time associated with last update. |
DATE |
|
ROOM_NUMBER |
Room number associated with the record. |
VARCHAR2 |
25 |
USER_FIELD_1 |
User field 1 associated with the record. |
VARCHAR2 |
50 |
USER_FIELD_2 |
User field 2 associated with the record. |
VARCHAR2 |
50 |
USER_FIELD_3 |
User field 3 associated with the record. |
VARCHAR2 |
50 |
USER_FIELD_4 |
User field 4 associated with the record. |
VARCHAR2 |
50 |
USER_FIELD_5 |
User field 5 associated with the record. |
VARCHAR2 |
350 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |