Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse POOL YIELD HISTORY Table


View exposing pooled investment yield history including rate of return and related performance measures.


Field Name

Description

Data Type

Length

POOL_CODE

Code identifying pool.

VARCHAR2

1

TIME_MONTH_KEY

Surrogate key identifying the time month.

VARCHAR2

6

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE

YIELD_PERCENT_RETURN

Yield percent return associated with the record.

NUMBER

10,4