FCLT FLOOR HIST Table
View exposing historical facilities floor reference data used to track changes to floor attributes over time.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACCESS_LEVEL |
Access level associated with the record. |
VARCHAR2 |
2 |
ASSIGNABLE_AREA |
Assignable area associated with the record. |
NUMBER |
32,20 |
BUILDING_WINGS_ID |
Business identifier for the building wings. |
VARCHAR2 |
64 |
EXT_GROSS_AREA |
Ext gross area associated with the record. |
NUMBER |
32,20 |
FCLT_BUILDING_KEY |
Surrogate key identifying the fclt building. |
VARCHAR2 |
8 |
FCLT_FLOOR_HIST_KEY |
Surrogate key identifying the fclt floor hist. |
VARCHAR2 |
114 |
FCLT_FLOOR_KEY |
Surrogate key identifying the fclt floor. |
VARCHAR2 |
13 |
FISCAL_PERIOD |
Fiscal period associated with the record. |
VARCHAR2 |
100 |
FLOOR |
Floor associated with the record. |
VARCHAR2 |
4 |
FLOOR_SORT_SEQUENCE |
Floor sort sequence associated with the record. |
VARCHAR2 |
3 |
LEVEL_ID |
Business identifier for the level. |
VARCHAR2 |
25 |
NON_ASSIGNABLE_AREA |
Non assignable area associated with the record. |
NUMBER |
32,20 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |