FUNDS REPORTING Table
View exposing fund reporting records used to support financial reporting and analysis by fund across reporting periods.
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 |
DEPT_HEAD_GENERAL_AMOUNT |
Dept head general amount associated with the record. |
NUMBER |
13,2 |
FISCAL_YEAR |
Fiscal year associated with the record. |
VARCHAR2 |
4 |
FR_LEVEL1_CATEGORY |
Fr level1 category associated with the record. |
VARCHAR2 |
40 |
FR_LEVEL1_SORT |
Fr level1 sort associated with the record. |
NUMBER |
6 |
FR_LEVEL2_CATEGORY |
Fr level2 category associated with the record. |
VARCHAR2 |
40 |
FR_LEVEL2_SORT |
Fr level2 sort associated with the record. |
NUMBER |
6 |
GROUP_OF_FR_LEVEL2_CATEGORY |
Group of fr level2 category associated with the record. |
VARCHAR2 |
40 |
GROUP_OF_FR_LEVEL2_SORT |
Group of fr level2 sort associated with the record. |
NUMBER |
6 |
OTHER_FUNDS_AMOUNT |
Other funds amount associated with the record. |
NUMBER |
13,2 |
OTHER_FUNDS_FC_AMOUNT |
Other funds fc amount associated with the record. |
NUMBER |
13,2 |
POOL_A_AMOUNT |
Pool a amount associated with the record. |
NUMBER |
13,2 |
POOL_C_AMOUNT |
Pool c amount associated with the record. |
NUMBER |
13,2 |
POOL_C_FC_AMOUNT |
Pool c fc amount associated with the record. |
NUMBER |
13,2 |
SPONSORED_FUNDS_AMOUNT |
Sponsored funds amount associated with the record. |
NUMBER |
13,2 |
SPONSORED_FUNDS_FC_AMOUNT |
Sponsored funds fc amount associated with the record. |
NUMBER |
13,2 |
TIME_MONTH_KEY |
Surrogate key identifying the time month. |
VARCHAR2 |
6 |
TOTAL_GENERAL_AMOUNT |
Total general amount associated with the record. |
NUMBER |
13,2 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |