FCLT USE Table
View exposing facilities use classification reference data used to categorize facilities space across MIT buildings.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACCESS_LEVEL |
Access level associated with the record. |
VARCHAR2 |
4 |
DESCRIPTION |
Description associated with the record. |
VARCHAR2 |
96 |
FCLT_MAJOR_USE_KEY |
Surrogate key identifying the fclt major use. |
VARCHAR2 |
16 |
FCLT_USE_KEY |
Surrogate key identifying the fclt use. |
VARCHAR2 |
16 |
ICR_CODE |
Code identifying icr. |
VARCHAR2 |
16 |
MAJOR_USE_DESC |
Description of major use. |
VARCHAR2 |
12 |
MAJOR_USE_ID |
Business identifier for the major use. |
VARCHAR2 |
16 |
USE_DESC |
Description of use. |
VARCHAR2 |
10 |
USE_ID |
Business identifier for the use. |
VARCHAR2 |
16 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |