FCLT MAJOR USE HIST Table
View exposing historical facilities major-use classification data used for facilities reporting and analysis.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ASSIGNABLE |
Assignable associated with the record. |
VARCHAR2 |
2 |
DESCRIPTION |
Description associated with the record. |
VARCHAR2 |
96 |
FCLT_MAJOR_USE_HIST_KEY |
Surrogate key identifying the fclt major use hist. |
VARCHAR2 |
111 |
FCLT_MAJOR_USE_KEY |
Surrogate key identifying the fclt major use. |
VARCHAR2 |
10 |
FISCAL_PERIOD |
Fiscal period associated with the record. |
VARCHAR2 |
100 |
MAJOR_USE |
Major use associated with the record. |
VARCHAR2 |
12 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |