FAC ROOMS Table
View exposing facilities room reference data including building and floor identifiers, room and space identifiers, major and minor use classifications, organization assignments, area, access level, coordinates, and room full name.
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_KEY |
Surrogate key identifying the building. |
VARCHAR2 |
8 |
DEPT_CODE |
Code identifying dept. |
VARCHAR2 |
16 |
EASTING_SPCS |
Easting spcs associated with the record. |
NUMBER |
32,20 |
FAC_ROOM_KEY |
Surrogate key identifying the fac room. |
VARCHAR2 |
16 |
FLOOR |
Floor associated with the record. |
VARCHAR2 |
4 |
FLOOR_KEY |
Surrogate key identifying the floor. |
VARCHAR2 |
12 |
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 |
MAJOR_USE_KEY |
Surrogate key identifying the major use. |
VARCHAR2 |
16 |
MINOR_ORGANIZATION |
Minor organization associated with the record. |
VARCHAR2 |
32 |
MINOR_ORGANIZATION_KEY |
Surrogate key identifying the minor organization. |
VARCHAR2 |
16 |
MINOR_USE_DESC |
Description of minor use. |
VARCHAR2 |
16 |
MINOR_USE_KEY |
Surrogate key identifying the minor use. |
VARCHAR2 |
16 |
NORTHING_SPCS |
Northing spcs associated with the record. |
NUMBER |
32,20 |
ORGANIZATION_KEY |
Surrogate key identifying the organization. |
VARCHAR2 |
16 |
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 |
USE_KEY |
Surrogate key identifying the use. |
VARCHAR2 |
16 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |