Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse FCLT MAJOR USE HIST Table


XXX


Field Name

Description

Data Type

Length

ASSIGNABLE

XXX

VARCHAR2

2

DESCRIPTION

the description

VARCHAR2

96

FCLT_MAJOR_USE_HIST_KEY

XXX

VARCHAR2

111

FCLT_MAJOR_USE_KEY

XXX

VARCHAR2

10

FISCAL_PERIOD

The fiscal year and month. For example: 199709 = March 1997.

VARCHAR2

100

MAJOR_USE

XXX

VARCHAR2

12

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE