FCLT ROOMS HIST Table
View exposing historical facilities room reference data used to track changes to room attributes over time.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACCESS_LEVEL |
Access level associated with the record. |
VARCHAR2 |
4 |
AREA |
Area associated with the record. |
NUMBER |
32,20 |
BUILDING_ROOM |
Building room associated with the record. |
VARCHAR2 |
16 |
DEPT_CODE |
Code identifying dept. |
VARCHAR2 |
16 |
EASTING_SPCS |
Easting spcs associated with the record. |
NUMBER |
32,20 |
FCLT_BUILDING_KEY |
Surrogate key identifying the fclt building. |
VARCHAR2 |
8 |
FCLT_FLOOR_KEY |
Surrogate key identifying the fclt floor. |
VARCHAR2 |
12 |
FCLT_MAJOR_USE_KEY |
Surrogate key identifying the fclt major use. |
VARCHAR2 |
16 |
FCLT_MINOR_ORGANIZATION_KEY |
Surrogate key identifying the fclt minor organization. |
VARCHAR2 |
16 |
FCLT_MINOR_USE_KEY |
Surrogate key identifying the fclt minor use. |
VARCHAR2 |
16 |
FCLT_ORGANIZATION_KEY |
Surrogate key identifying the fclt organization. |
VARCHAR2 |
16 |
FCLT_ROOM_HIST_KEY |
Surrogate key identifying the fclt room hist. |
VARCHAR2 |
117 |
FCLT_ROOM_KEY |
Surrogate key identifying the fclt room. |
VARCHAR2 |
16 |
FCLT_USE_KEY |
Surrogate key identifying the fclt use. |
VARCHAR2 |
16 |
FISCAL_PERIOD |
Fiscal period associated with the record. |
VARCHAR2 |
100 |
FLOOR |
Floor associated with the record. |
VARCHAR2 |
4 |
LATITUDE_WGS |
Latitude wgs associated with the record. |
NUMBER |
32,20 |
LONGITUDE_WGS |
Longitude wgs associated with the record. |
NUMBER |
32,20 |
MAJOR_USE_DESC |
Description of major use. |
VARCHAR2 |
12 |
MINOR_ORGANIZATION |
Minor organization associated with the record. |
VARCHAR2 |
32 |
MINOR_USE_DESC |
Description of minor use. |
VARCHAR2 |
16 |
NORTHING_SPCS |
Northing spcs associated with the record. |
NUMBER |
32,20 |
ORGANIZATION_NAME |
Organization name associated with the record. |
VARCHAR2 |
32 |
ROOM |
Room associated with the record. |
VARCHAR2 |
8 |
ROOM_FULL_NAME |
Room full name associated with the record. |
VARCHAR2 |
64 |
SPACE_ID |
Business identifier for the space. |
VARCHAR2 |
21 |
USE_DESC |
Description of use. |
VARCHAR2 |
10 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |