|RBB Model Algorithms||Financial Position Report Categories|
|ALG 1||UG Tuition
Activities of Educational Dept
Sales & Services
|ALG 3||Graduate Tuition Revenue|
|ALG 4||Indirect Cost Recovery|
|ALG 5||Other Revenue*|
|College Specific Expenses||All Salaries & Total Compensation Unit Specific Expenses Transfers/Credits|
|ALG 6||Graduate Tuition Expense|
|ALG 7 -12||ALLOCATED|
*Other Revenue – ALG 1 revenue is allocated to PS account ‘RBBOTH’ and ALG 5 revenue is allocated to PS accounts ‘R11000- R12100, R12900-R13200, R16200-R16600, R16800, R17300, R17800, R17900-R18300, R18500’.
The financial position reports pulls data based on PS account.
The default view of the financial position report will show a standard view that is useful to colleges and non-college units. If a college would like to see a format which will translate the same data into the RBB Model Algorithms, they may click on the “Standard View” toggle button. To toggle back to the standard view, simply click the same button which will be then be labeled “College View”.
The data access is based on row level purpose security. A user will only see data for the departments/units they have security to approve/view. If you have questions regarding row level purpose security, please contact Marsha Lockard in University Finance.
If there is specific revenue allocated to the department, revenue will be available to view. However, revenue allocated through the RBB model is only allocated at the college level.
Many departments and units will only see expenses. The financial position can be determined by looking at the report from left to right; budget minus expenses. If you need additional guidance reading the financial position report, please contact your budget analyst.
The report defaults to the current month and will show activity as of the current date.
PO Obligations are any dollars remaining on existing Purchase Orders within the system for the college/unit. The obligations amount will include the total dollars remaining and not just the dollars obligated for the fiscal year.
Initially, the activity in the purpose code that the College or unit is closed to at the end of each fiscal year is included in the reserve balance. This purpose is identified with a RBB_OP_SORT attribute. If you have questions regarding the purpose used or would like the balance to include other unrestricted reserve accounts, please contact your budget analyst.
RBB_OP_SORT is an attribute that is used to group purposes at the college/unit level.
The list of RBB_OP_SORT’s can be found here: RBB_OP_SORT_List
The budget office has created PeopleSoft queries that use the RBB_OP_SORT that will provide detail for the summary totals on the financial position report.
Revenue and Expense Detail – FPR_ACTUAL_BAL_RBBOPSORT
Graduate Tuition Revenue Detail – FPR_ACTUAL_BAL_RBB_ALG3
Salary & Benefit Obligations – FPR_OBL_ACCT_W_RBBOPSORT
Purchase Order Obligations – FPR_PO_OBL_W_RBBOPSORT