FUND DESCRIPTION HISTORY Table
View exposing historical descriptive attributes for funds used for financial reporting and trend analysis.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
BENEFICIARY_TITLE |
Beneficiary title associated with the record. |
VARCHAR2 |
255 |
COST_COLLECTOR_FY_KEY |
Surrogate key identifying the cost collector fy. |
VARCHAR2 |
12 |
COST_COLLECTOR_KEY |
Surrogate key identifying the cost collector. |
VARCHAR2 |
12 |
DESIGNATION_RESTRICTION_LEVEL |
Designation restriction level associated with the record. |
VARCHAR2 |
3 |
FISCAL_YEAR |
Fiscal year associated with the record. |
VARCHAR2 |
4 |
FUND_AWARD_CRITERIA |
Fund award criteria associated with the record. |
VARCHAR2 |
4000 |
FUND_CAO_NOTES |
Fund cao notes associated with the record. |
VARCHAR2 |
255 |
FUND_COST_COLLECTOR_ID |
Business identifier for the fund cost collector. |
VARCHAR2 |
12 |
FUND_DESCRIPTION |
Description of fund. |
VARCHAR2 |
4000 |
FUND_RESTRICTION |
Fund restriction associated with the record. |
VARCHAR2 |
255 |
FUND_RESTRICTION_LEVEL |
Fund restriction level associated with the record. |
VARCHAR2 |
3 |
FUND_SORT |
Fund sort associated with the record. |
VARCHAR2 |
100 |
IS_VALID_COST_COLLECTOR |
Indicator identifying whether valid cost collector (Y/N). |
VARCHAR2 |
1 |
LAST_UPDATE_DATE |
Date associated with last update. |
DATE |
|
POOL_CODE |
Code identifying pool. |
VARCHAR2 |
1 |
SFS_STEWARD_IND |
Sfs steward ind associated with the record. |
VARCHAR2 |
1 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |