POOL A FUND DATA Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
BOOK_VALUE_AMOUNT |
XXX |
NUMBER |
|
COST_COLLECTOR_KEY |
Key used to join the Cost Collector to the financial transaction, and to get the master data that were current at the time of the transaction. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
12 |
DISTRIBUTION_RATE |
XXX |
NUMBER |
5,2 |
INVESTMENT_INCOME_AMOUNT |
XXX |
NUMBER |
|
MARKET_VALUE_AMOUNT |
XXX |
NUMBER |
|
NEXT_MONTH_POOL_UNITS |
The number of pool units this cost object has in the next fiscal period. This field is set to zero in the current fiscal period. |
NUMBER |
|
NXT_MONTH_POOL_UNIT_VALID_DATE |
XXX |
DATE |
|
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 |
10,4 |
UNIT_VALUE_ENTRY_DATE |
XXX |
DATE |
|
UNIT_VALUE_FISCAL_PERIOD |
XXX |
VARCHAR2 |
6 |
UNIT_VALUE_PERIOD_DESCRIPTION |
XXX |
VARCHAR2 |
30 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |