POOL YIELD HISTORY Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
POOL_CODE |
Indicates which investment pool the funds should placed in. |
VARCHAR2 |
1 |
TIME_MONTH_KEY |
Key used only for joining the TIME_MONTH table to other tables, NOT for reporting. |
VARCHAR2 |
6 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |
YIELD_PERCENT_RETURN |
Monthly yield percent return for the specified pool. Values are provided by CAO. |
NUMBER |
22 |