POOL UNITS HISTORY Table
View exposing pooled investment unit history including unit balances and related fund performance attributes.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
COST_COLLECTOR_FP_KEY |
Surrogate key identifying the cost collector fp. |
VARCHAR2 |
12 |
COST_COLLECTOR_KEY |
Surrogate key identifying the cost collector. |
VARCHAR2 |
12 |
DISTRIBUTION_RATE |
Distribution rate associated with the record. |
NUMBER |
5,2 |
NEXT_MONTH_POOL_UNITS |
Next month pool units associated with the record. |
NUMBER |
10,4 |
POOL_CODE |
Code identifying pool. |
VARCHAR2 |
4 |
POOL_UNITS |
Pool units associated with the record. |
NUMBER |
10,4 |
PREV_MONTH_POOL_UNITS |
Prev month pool units associated with the record. |
NUMBER |
10,4 |
TIME_MONTH_KEY |
Surrogate key identifying the time month. |
VARCHAR2 |
6 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |