POOL UNIT VALUE HISTORY Table
History of Pool Unit Values by fiscal period, beginning with June 1997.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
NEXT_MONTH_UNIT_VALUE |
XXX |
NUMBER |
22 |
POOL_CODE |
Indicates which investment pool the funds should placed in. |
VARCHAR2 |
1 |
PREV_MONTH_UNIT_VALUE |
The dollar value of a Pool Unit in the immediately previous month. |
NUMBER |
13.2 |
TIME_MONTH_KEY |
Key used only for joining the TIME_MONTH table to other tables, NOT for reporting. |
VARCHAR2 |
6 |
UNIT_VALUE |
The current dollar value of a Pool Unit; provided monthly from the Treasurer's Office. |
NUMBER |
22 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |