POOL UNIT VALUE HISTORY Table
View exposing historical investment pool unit values by fiscal month and pool code, including prior and subsequent month values used for valuation tracking and trend analysis.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
NEXT_MONTH_UNIT_VALUE |
Unit value of the pool for the subsequent reporting month. |
NUMBER |
10,4 |
POOL_CODE |
Code identifying the investment pool. |
VARCHAR2 |
1 |
PREV_MONTH_UNIT_VALUE |
Unit value of the pool for the prior reporting month. |
NUMBER |
10,4 |
TIME_MONTH_KEY |
Identifier representing the fiscal reporting month associated with the pool unit value. |
VARCHAR2 |
6 |
UNIT_VALUE |
Unit value of the pool for the reporting month. |
NUMBER |
10,4 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |