FCLT BUILDING HIST Table
View exposing historical facilities building reference data used to track changes to building attributes over time.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACCESS_LEVEL_CODE |
Code identifying access level. |
NUMBER |
2 |
ACCESS_LEVEL_NAME |
Access level name associated with the record. |
VARCHAR2 |
32 |
ASSIGNABLE_AREA |
Assignable area associated with the record. |
NUMBER |
32,20 |
BUILDING_HEIGHT |
Building height associated with the record. |
VARCHAR2 |
32 |
BUILDING_NAME |
Building name associated with the record. |
VARCHAR2 |
64 |
BUILDING_NAMED_FOR |
Building named for associated with the record. |
VARCHAR2 |
96 |
BUILDING_NAME_LONG |
Building name long associated with the record. |
VARCHAR2 |
128 |
BUILDING_NUMBER |
Building number associated with the record. |
VARCHAR2 |
8 |
BUILDING_SORT |
Building sort associated with the record. |
VARCHAR2 |
10 |
BUILDING_TYPE |
Building type associated with the record. |
VARCHAR2 |
8 |
BUILDING_USE |
Building use associated with the record. |
VARCHAR2 |
32 |
CAMPUS_SECTOR |
Campus sector associated with the record. |
VARCHAR2 |
25 |
COST_CENTER_CODE |
Code identifying cost center. |
VARCHAR2 |
16 |
COST_COLLECTOR_KEY |
Surrogate key identifying the cost collector. |
VARCHAR2 |
24 |
DATE_ACQUIRED |
Date acquired associated with the record. |
VARCHAR2 |
16 |
DATE_BUILT |
Date built associated with the record. |
VARCHAR2 |
16 |
DATE_OCCUPIED |
Date occupied associated with the record. |
VARCHAR2 |
16 |
EASTING_X_SPCS |
Easting x spcs associated with the record. |
NUMBER |
32,20 |
EXT_GROSS_AREA |
Ext gross area associated with the record. |
NUMBER |
32,20 |
FCLT_BUILDING_HIST_KEY |
Surrogate key identifying the fclt building hist. |
VARCHAR2 |
109 |
FCLT_BUILDING_KEY |
Surrogate key identifying the fclt building. |
VARCHAR2 |
8 |
FISCAL_PERIOD |
Fiscal period associated with the record. |
VARCHAR2 |
100 |
LATITUDE_WGS |
Latitude wgs associated with the record. |
NUMBER |
32,20 |
LONGITUDE_WGS |
Longitude wgs associated with the record. |
NUMBER |
32,20 |
NON_ASSIGNABLE_AREA |
Non assignable area associated with the record. |
NUMBER |
32,20 |
NORTHING_Y_SPCS |
Northing y spcs associated with the record. |
NUMBER |
32,20 |
NUM_OF_ROOMS |
Num of rooms associated with the record. |
NUMBER |
|
OCCUPANCY_CLASS |
Occupancy class associated with the record. |
VARCHAR2 |
8 |
OWNERSHIP_TYPE |
Ownership type associated with the record. |
VARCHAR2 |
8 |
PARENT_BUILDING_NAME |
Parent building name associated with the record. |
VARCHAR2 |
64 |
PARENT_BUILDING_NAME_LONG |
Parent building name long associated with the record. |
VARCHAR2 |
128 |
PARENT_BUILDING_NUMBER |
Parent building number associated with the record. |
VARCHAR2 |
8 |
SITE |
Site associated with the record. |
VARCHAR2 |
16 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |