FAC BUILDING Table
View exposing facilities building reference data including building identifiers, parent building relationships, building names, area measures, site and campus-sector attributes, access level, building type, ownership and use classifications, cost collector, coordinates, key dates, and room counts.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ASSIGNABLE_AREA |
Assignable area associated with the record. |
NUMBER |
32,20 |
BUILDING_HEIGHT |
Building height associated with the record. |
VARCHAR2 |
32 |
BUILDING_NAMED_FOR |
Building named for associated with the record. |
VARCHAR2 |
96 |
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 |
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 |
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 |
OCCUPANCY_CLASS |
Occupancy class associated with the record. |
VARCHAR2 |
8 |
OWNERSHIP_TYPE |
Ownership type 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 |