HR - CAT - BSUM [3270]


This document illustrates the relationship between the Compensation Administration Tool and BSUM pages in the Legacy 3270 system.

You may click on the links below to navigate directly to a section:


The purpose of this KB is to illustrate the relationship between the CAT and the BSUM pages in the Legacy 3270 system.  BSUM is the system query tool used for budget development.  With the implementation of CAT, many of the functional pages of BSUM will be eliminated.  Data will be pulled instantly from the CAT and populate the appropriate fields on the remaining pages of 2, 3, 5, 6, 26, and 27 of BSUM.  Any employee class (including Student Help and LTE) can be loaded to or entered in the CAT Page, and will be included in FTE calculation in BSUM.

Users will now make all changes in CAT that were previously done in BDGT, BADJR, and BRATE pages in the Legacy system.  Users will refer to BSUM for reporting purposes to gather salary, budget, and allocation totals.


1.  Data is pulled from the CAT in the Funding Change section of the CAT Page and sent to BSUM.
a.  GL Business Unit on the CAT Page is the same as the letter indicator for Summary For on BSUM.  This is entered into the UDDS Field in BSUM.
b.  Fund on the CAT Page is the same as Fund in BSUM.
c.  Department on the CAT Page is the same as the number indicator for Summary For in BSUM.  This is entered into the UDDS field in BSUM.
d.  Project on the CAT Page is the same as Project in BSUM.
e.  Budgeted FTE and Budgeted Amount from the CAT Page are pulled into the totals in BSUM.
2.  BSUM will not populate Distribution Percentage or Full Time Rate reflected in the CAT Page.

3.  If the employee exists in the CAT Page, then that data will reflect in BSUM.  The 'Load to HRS' checkbox will not prevent this data from being sent to BSUM.

4.  Each institution will be responsible for monitoring FTE calculations in BSUM, and determining if Student Help and LTE should be entered in the CAT Page.  If the institution decides these employee classes should not be included, they can delete the employee record from the CAT Page.
Page 2 of BSUM is used for Record Totals and Total Salary and Wages information.
BSUM Picture 2
Page 3 of BSUM is used for budgeting information for Supplies and Expense, Sales Credit, Capital, Aids to Individuals, Fringe Benefits, and Special Purposes.
Picture 3
Page 5 of BSUM is used for Graduate Assistants and Classified Totals.
Picture 4
Page 6 of BSUM is used for Student Help and LTE data.

Picture 5

Page 26 of BSUM is used for Allocated Amounts, Salaries, Non-Salary, and Fringes.

Picture 6
Page 27 of BSUM is used for Activity Totals for Allocations and Requests.
Picture 7


Compare the CAT Position Report to BSUM

CAT Position Report

1.  Run the CAT Position Report
a.  Please refer to the following document for instructions on how to run this report:  HR - CAT - Position Report
2.  Once the Position Report has processed and has been downloaded into Excel:
a.  Apply a filter to row 13.
b.  Convert columns AL (Budgeted Amt $) & AM (Budgeted FTE) to number
c.  Add a subtotal to columns AL (Budgeted Amt $) & AM (Budgeted FTE)
i.  i.e. cells AL11 and AM11
ii.  the formula for sum subtotal is:  =subtotal(9, beginning cell:end cell)
iii.  Example:  =subtotal(9,AL14:AL1332)
d.  NOTE:  The CAT Position Report pulls a complete picture of a position across institutions.  If an institution shares employees with another institution, filter columns AF (GL Busienss Unit) to the user's institution.  ("Blanks" should also be included in the filter as these represent the AAP transactions.)  Likewise, if a Department or Division share employees, filter column AH (Dept) for the Department or Division the user is reconciling.

3.  Configure BSUM
a.  Enter the Page # on BSUM (recommend starting with page 2).
b.  Enter UDDS to match what was entered in the Position Report Run Control for Business Unit, Division, and/or Department.
c.  Enter Fund and/or Activity if reconciling to that level.
i.  Note that if reconciling to Fund and/or Activity, the Position Report should be filtered to that fund and activity as well.
d.  Compare "Total Salary & Wages" request total to Position Report column AL (Budgeted Amt $) subtotal.  These totals should match.
e.  Compare "Record Totals, FTE (Inc Asst)" request total to Position Report column AM (Budgeted FTE) subtotal.  These totals should match.
Picture 8

Possible Reasons Why CAT and BSUM Do Not Reconcile

There are funding edit errors.


Related KBs:

Related Links: