Introduction
Purpose of the Report
The purpose of the Fund Values Listing Report is to provide users of Harvard’s Chart of Accounts with a list of fund segment values and descriptions.
This report allows users to search for single or ranges of fund values as well as values that contain specific strings of text. Additionally, the report allows users to isolate the list of fund values to include values ‘owned’ by specific tubs, managed by specific orgs, and belonging to selected fund categories and fund types.
The fund segment may be populated only to the super level; however, this is local unit dependent. Rather than creating parent values, some tubs have chosen to group like fund values into subranges.
Intended Audience
The intended audience includes users required to code financial transactions or generate reports with Chart of Account values.
Old AWS Report
There is no comparable AWS report that meets the needs of the Fund Values Listing Report.
Parameters Screen
Note: |
Do not enter more than 240 characters total on the Parameters screen. This will impact reports with a large number of parameters. Keep request descriptions to a minimum. |
|
In This Field |
Enter |
|
Request Description: |
Description of the report request you are making Note: Use a unique description to help you identify this report later. |
|
Fund Statuses Displayed (R): |
Type of fund you would like displayed Note: Fund values will rarely be disabled. Selecting Disable displays fund values that may no longer be used. Selecting Enabled displays fund values that can be used. |
|
Fund Low Value: |
Value with which you would like the fund list to begin Note: Only fund values available to your responsibility display. If you do not complete this field, 0000000 Unspecified is the default value. |
|
Fund High Value: |
Value with which you would like the fund list to end Note: Only fund values available to your responsibility display. If you do not complete this field, ZZZZZZ will be the default value. |
|
Fund Text Search: |
Complete or partial fund name that you would like all fund values listed to contain Note: Use the fund section of the "Chart of Account Naming Conventions" document in ABLE for naming convention information. |
|
Owning Tub Low: |
3-digit tub that begins the range of owning tub values you would like incorporated in the fund list Note: Owning Tub is a descriptive flexfield that associates the fund value with a specific tub value. If you do not complete this field, 000 will be the default value. |
|
Owning Tub High: |
3-digit tub that ends the range of owning tub values you would like incorporated in the fund list Note: Owning Tub is a descriptive flexfield that associates the fund value with a specific tub value. If you do not complete this field, 999 will be the default value. |
|
Primary Managing Org Low: |
5-digit org that begins the range of primary managing org values you would like incorporated on the fund list Note: Primary managing org is a descriptive flexfield that associates the fund value with a specific org value. If you do not complete this field, All will be the default value. |
|
Primary Managing Org High: |
5-digit org that ends the range of primary managing org values that you would like incorporated on the fund list Note: Primary managing org is a descriptive flexfield that associates the fund value with a specific org value. If you do not complete this field, All will be the default value. |
|
Fund Category: |
One of six categories of fund you want included on the Fund Values Listing Report Note: If you do not complete this field, All will be the default value.
Unrestricted undesignated funds range from 000100 – 001999. Unrestricted designated funds range from 002000 – 054999. Sponsored support funds range from 100000 – 299999. Gift funds range from 300000 – 399999. Endowment funds range from 400000 – 699999. Other fund balances range from 700000 - 749999. |
|
Fund Type: |
Type of fund you want included on the Fund Values Listing Report Note: Fund type is a descriptive flexfield that associates the fund value with a specific type. If you do not complete this field, All will be the default value. |
|
Enable Security: |
Yes to see fund values your responsibility may use No to see all fund values, regardless of your security |
Interpret Report Output
Column Contents|
Column Name |
Contains |
|
Fund |
6-digit fund value |
|
Fund Description/ Full Name |
Description of the fund consistent with the naming convention standard |
|
Owning Tub |
3-digit tub value associated with the fund |
|
Prim Org |
5-digit org value associated with the fund |
| Category/Type | |
| Endow Type | |
| Endow Code | |
|
Start Date |
Date on which you are able to create journal entries or submit budgets to the fund value |
|
End Date |
Date after which you may no longer create journal entries or submit budgets to the fund value |
|
Enabled? |
Yes indicates that the value is currently active No indicates that the value is not active and may not be transacted against |
|
Parent? |
Yes indicates that the fund value represents a parent value No indicates that the fund value is a child value Note: Fund parent values are only populated to the super level. All parent values are alphanumeric. |
|
Rollup Group |
Rollup groups are not used |
|
Posting Allowed? |
Yes indicates that transactions may be posted to the value No indicates that transactions may not be posted to the value |
|
Budgeting Allowed? |
Yes indicates that the value may be used for budgeting No indicates that the value may not be used for budgeting |