FCLT ROOM USE HIST Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACCESS_LEVEL |
XXX |
VARCHAR2 |
4 |
DESCRIPTION |
the description |
VARCHAR2 |
96 |
FCLT_MAJOR_USE_KEY |
XXX |
VARCHAR2 |
16 |
FCLT_ROOM_USE_HIST_KEY |
XXX |
VARCHAR2 |
117 |
FCLT_ROOM_USE_KEY |
XXX |
VARCHAR2 |
16 |
FCLT_USE_KEY |
XXX |
VARCHAR2 |
16 |
FISCAL_PERIOD |
The fiscal year and month. For example: 199709 = March 1997. |
VARCHAR2 |
100 |
ICR_CODE |
XXX |
VARCHAR2 |
16 |
MAJOR_USE_DESC |
XXX |
VARCHAR2 |
12 |
USE_DESC |
XXX |
VARCHAR2 |
10 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |