FUND DESCRIPTION Table
Fund description
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
BENEFICIARY_TITLE |
XXX |
VARCHAR2 |
255 |
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 |
DESIGNATION_RESTRICTION_LEVEL |
XXX |
VARCHAR2 |
3 |
FUND_AWARD_CRITERIA |
XXX |
VARCHAR2 |
4000 |
FUND_CAO_NOTES |
Notes from the CAO's office related to the fund. |
VARCHAR2 |
255 |
FUND_COST_COLLECTOR_ID |
7-digit cost collector ID which identifies the fund. |
VARCHAR2 |
12 |
FUND_DESCRIPTION |
The description of the fund. |
VARCHAR2 |
1000 |
FUND_RESTRICTION |
Restrictions tied to the fund. |
VARCHAR2 |
255 |
FUND_RESTRICTION_LEVEL |
This field's source is SAP Internal Order classification data, i.e., only those funds that are internal orders will have value in this field. It is a 3-character code specifying the restriction level. |
VARCHAR2 |
3 |
FUND_SORT |
The name of the fund. |
VARCHAR2 |
100 |
IS_VALID_COST_COLLECTOR |
Flag indicating whether the cost collector is valid. Y=Yes, N=No. |
VARCHAR2 |
1 |
LAST_UPDATE_DATE |
Date the description was created or last altered. |
DATE |
8 |
POOL_CODE |
Indicates which investment pool the funds should placed in. |
VARCHAR2 |
1 |
SFS_STEWARD_IND |
XXX |
VARCHAR2 |
1 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |