POOL A FUND DATA Table
View exposing Pool A fund performance and valuation data by cost collector and fiscal period, including unit values, distribution rates, book and market values, and investment income amounts used for financial reporting and investment analysis.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
BOOK_VALUE_AMOUNT |
Book value of the pool for the reporting period. |
NUMBER |
|
COST_COLLECTOR_KEY |
Surrogate identifier for the cost collector associated with the pool fund record. |
VARCHAR2 |
12 |
DISTRIBUTION_RATE |
Distribution rate applied to the pool for the reporting period. |
NUMBER |
5,2 |
INVESTMENT_INCOME_AMOUNT |
Investment income generated by the pool during the reporting period. |
NUMBER |
|
MARKET_VALUE_AMOUNT |
Market value of the pool for the reporting period. |
NUMBER |
|
NEXT_MONTH_POOL_UNITS |
Number of pool units applicable for the next fiscal reporting month. |
NUMBER |
|
NXT_MONTH_POOL_UNIT_VALID_DATE |
Date the next month pool unit value becomes effective. |
DATE |
|
TIME_MONTH_KEY |
Identifier representing the fiscal reporting month associated with the pool fund data. |
VARCHAR2 |
6 |
UNIT_VALUE |
Unit value of the pool for the reporting period. |
NUMBER |
10,4 |
UNIT_VALUE_ENTRY_DATE |
Date the unit value was entered or recorded in the source system. |
DATE |
|
UNIT_VALUE_FISCAL_PERIOD |
Fiscal period associated with the recorded unit value. |
VARCHAR2 |
6 |
UNIT_VALUE_PERIOD_DESCRIPTION |
Description of the fiscal period associated with the unit value. |
VARCHAR2 |
30 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |