All University Benefits Pool
This article covers how to run and interpret the All University Benefits Pool report on the Revenue/Expense dashboard.
This user guide assumes basic knowledge of TitanInsights. View the TitanInsights Basics & Overview guides for more information.
What does this report show?
The All University Benefits Pool report is a summary of your university-funded benefits; it includes: Budgeted Baseline, Budget Revised, Current Period Actuals, Current Year Actuals, Encumbrance, Pre-encumbrance, and Budget Balance Available. Users can also view detailed information by clicking on hyperlinks within the report.
1. Access TitanInsights from the campus portal.
If you do not see the TitanInsights icon in your Titan Online widget in the portal, you may not have submitted an Access Request Form to request this access. View instructions on the Access Request Form process.
2. Click on Shared Folders, then select Finance.
- Click Shared Folders.
- Select Finance.
3. Select the Rev/Exp (CFS) folder.
4. Click Rev/Exp (CFS) to open the Revenue/Expense dashboard.
5. Click the All University Benefits Pool tab.
Report Overview
The All University Benefits Pool report is a year-to-date report by fiscal year.
When you access the report, your personal settings for the report (page) appear. If you have not set up your personal settings, the system defaults will automatically populate initially. If you select any filters, those settings will populate again when you open the report or move to another tab.
Report Filters
The first section of the report contains the available filters. Utilize the filters to narrow down your report results or find specific values.
By default, the report shows you all available values with transactions associated with them for the current accounting period (e.g., if you do not select any particular accounts, your report will show all account codes that have a transaction associated with them during that particular accounting period).
| Filter | Description |
|---|---|
| Fiscal Year | The beginning calendar year of the Fiscal Year for which you wish to view data (i.e., FY 2024-2025 = 2024). |
| Accounting Period | For this year-to-date report, this is the ending period for the year-to-date data The fiscal year begins July and ends June of the
following calendar year (e.g., choosing 6 will mean you see data from July 1st - December, or period 6.) |
| Fund | The specific fund code(s) for which you wish to view data along with the name associated with the fund code(s). Funds delineate the money source of the transaction. University-funded benefits are in fund THEFD. |
| Account | The specific account code(s) for which you wish to view data along with the name associated with the account code(s). Accounts record the nature of the transaction (e.g. 603001 = OASDI, 603005 = Retirement.) |
| Program | The specific program code(s) for which you wish to view data along with the name associated with the program code(s). Programs are used by departments to track specific expenditures and revenues (e.g. 7xxx= billable to auxiliary.) |
| Class | The specific class code(s) for which you wish to view data along with the name associated with the class code(s). Classes are used by departments to track specific expenditures and revenues (e.g. 20364 = Consolidated Course Fee, 20483 = Office Supply Program.) |
| Project | The specific project code(s) for which you wish to view data along with the name associated with the project code(s). Projects are used to track capital expenditures or one-time repairs/maintenance and are not commonly associated with benefit
accounts. |
| Division | The specific campus division(s) for which you wish to view data. |
| Sub-Division/College | The specific campus sub-division(s) or college(s) for which you wish to view data. |
| Master Department | A Master Department groups several departments together. Use this to select a specific master department for which you wish to view data. |
| Department | The specific department ID(s) for which you wish to view data along with the name associated with the department ID(s). |
Report Parameters and Available Column Headers
Just under the report filters are the report parameters and the available columns headers for the report results table.
Report Parameters
Business Unit will always be FLCMP (Fullerton Campus).
Fiscal Year will match the Fiscal Year in the report filters.
YTD Period will match the Accounting Period in the report filters.
Therefore, the report will be showing year-to-date information for the selected fiscal year from July 1st through the YTD Period.
The following column headers are available for the report results table.
Use the drop-down menus to select the columns you want to see on your report results table.
When you make a selection from one of the drop-down menus, the report will automatically re-run.
| Column |
Description |
|---|---|
| Dept ID | The five-digit Department ID associated with the transaction (e.g. 10356.) |
| Dept Descr | The name associated with the Department ID for the transaction (e.g. IT Training.) |
| Dept Fdescr | Both the Department ID and the name associated with the Department ID appear (e.g.10356 - IT Training.) |
| Fund | The five-character Fund code associated with the transaction (e.g. THEFD.) |
| Fund Descr | The name associated with the Fund code for the transaction (e.g. CSU Operating Fund.) |
| Fund Fdescr | Both the Fund code and the name associated with the Fund code appear (e.g. THEFD - CSU Operating Fund.) |
| Account | The six-digit Account code associated with the transaction (e.g. 603001.) |
| Acct Descr | The name associated with the Account code for the transaction (e.g. OASDI.) |
| Acct Fdescr | Both the Account code and the name associated with the Account code appear (e.g. 603001 - OASDI.) |
| Program | The four-digit Program code associated with the transaction (e.g. 7806.) |
| Prog Descr | The name associated with the Program code for the transaction (e.g. Philanthropic Foundation.) |
| Prog Fdesc | Both the Program code and the name associated with the Program code appear (e.g. 7806 - Philanthropic Foundation.) |
| Class | The five-digit Class code associated with the transaction (e.g. 20364.) |
| Class Descr | The name associated with the Class code for the transaction (e.g. Consolidated Course Fee.) |
| Class Fdescr | Both the Class code and the name associated with the Class code appear (e.g. 20364 - Consolidated Course Fee.) |
| Project | The eight-digit Project code associated with the transaction. |
| Project Descr | The name associated with the Project code for the transaction. |
| Project Fdescr | Both the Project code and the name associated with the Project code appear. |
| Level 2 Fdescr | This is equivalent to the Division designation. |
| Level 3 Fdescr | This is equivalent to the Sub-Division/College designation. |
| Level 4 Fdescr | This is equivalent to the Master Department designation. |
Report Results Table
The second section of the report contains the report results table.
| Column |
Description |
|---|---|
| Budgeted Baseline | The total amount of the baseline budget for the selected Fiscal Year as of the selected Accounting Period. |
| Budget Revised | The total amount of all budget-related transactions (i.e. baseline budget, budget adjustments, budget transfers, carry forward, etc) for the selected Fiscal Year as of the selected Accounting Period. |
| Current Period Actuals | The total amount of all expenditures that were posted during the Accounting Period in the report filters for the selected Fiscal Year. |
| Current Year Actuals | The total amount of all year-to-date expenditures as of the Accounting Period in the report filters for the selected Fiscal Year. |
| Encumbrance | The total amount of encumbrances (purchase orders) still active as of the Accounting Period in the report filters for the selected Fiscal Year. Benefit accounts do not typically have encumbrances. |
| Pre-Encumbrance | The total amount of pre-encumbrances (approved purchase requisitions) still active as of the Accounting Period in the report filters for the selected Fiscal Year. Benefit accounts do not typically have pre-encumbrances. |
| Budget Balance Available | This total is calculated based on your revised budget minus your current year actuals, encumbrances, and pre-encumbrances. |
Additional Detail
You can click on hyperlinks in the Budgeted Baseline, Budget Revised, Current Year Actuals, Encumbrance, or Pre-Encumbrance totals to view the specific transactions included in the total.
1. Click on a hyperlink to view additional details.
2. Select a drill report to open.
Budgeted Baseline and Budget Revised
These columns appear when you click on the Budgeted Baseline summary total or the Budget Revised summary total on the main summary report.
| Column |
Description |
|---|---|
| Scenario | The type of budget transaction. |
| Journal ID | The identification number assigned to the budget transaction. |
| Jrnl Ln Descr | The line description associated with the budget transaction. |
| Doc Ln Descr | The header description associated with the budget transaction. |
| Jrnl Ln Ref | The line reference for the budget transaction if entered. |
| Journal Date | The date of the budget transaction. |
| Fiscal Year | The first calendar year of the fiscal year during which the budget transaction occurred. (i.e. FY 2024-2025 = 2024.) |
| Period | The Accounting Period when the budget transaction was posted. |
| Baseline Budget | The amount of the transaction that was applied to the baseline budget. |
| Revised Budget | The amount of the transaction that was applied to the revised budget. |
Current Year Actuals
These columns appear when you click on the Current Year Actuals summary total on the main summary report.
| Column |
Description |
|---|---|
| Doc Src |
The type of transaction. Values include:
|
| Document ID |
For each Doc Src, the document ID is a different type of identification number:
|
| Document Date |
For each Doc Src, the document date denotes a different type of date:
|
| Journal ID |
The identification number associated with the accounting transaction that is posted to the general ledger. |
| Journal Date |
The date of the journal which determines the accounting period to which the system posts the journal. |
| Ln Number |
The line number on the transaction. |
| Ln Descr |
The line description associated with the transaction. |
| Invoice ID |
The identification number assigned to the invoice associated with this transaction. |
| Vendor/Customer ID |
The identification number assigned to the vendor or customer associated with this transaction. |
| Vendor/Customer Name |
The name of the vendor or customer associated with the transaction. |
| Reference 1 |
The line reference for the transaction if entered. May denote a PO# or Work Order #, CashNet Item Code, or other identifying information. |
| Reference 2 |
Additional reference information for the transaction. For HCM transactions, this includes FTE statistics amount if applicable. For VCH transactions, this includes the PO ID associated with the transaction. |
| Fiscal Year |
The first calendar year of the fiscal year during which the transaction occurred. (i.e. FY 2024-2025 = 2024.) |
| Period |
The Accounting Period when the transaction was posted. |
| Actuals |
The amount of the transaction. |
Encumbrance
Typically there will be no data in the Encumbrance column as there are no purchase orders associated with university-funded benefits.
Pre-Encumbrance
Typically there will be no data in the Pre-Encumbrance column as there are no purchase requisitions associated with university-funded benefits.
Need More Help?
For technical assistance with TitanInsights, please contact the IT Help Desk at [email protected] or 657-278-7777.
For questions about getting access to TitanInsights or how to use the reports, please contact IT Training at [email protected] or 657-278-5647.