1 / 31

Compensation Administration Tool Training – Day One

Learn about the overall process flow and various setup activities in the Compensation Administration Tool (CAT) at the University of Wisconsin System. Explore topics such as user roles, data freezing, user locking, and locating the CAT and IPS.

gwalters
Download Presentation

Compensation Administration Tool Training – Day One

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Compensation Administration ToolTraining – Day One University of Wisconsin - System

  2. Overall Process Flow University of Wisconsin - System

  3. Training Overview University of Wisconsin - System

  4. Training Overview University of Wisconsin - System

  5. What Does an Admin Do? University of Wisconsin - System

  6. What Does an Update User Do? University of Wisconsin - System

  7. What Does a Read-Only User Do? University of Wisconsin - System

  8. Training Overview University of Wisconsin - System

  9. Training Overview University of Wisconsin - System

  10. A variety of setup and close out activities take place on an institutional level, and are housed in the CAT Setup pages CAT Setup University of Wisconsin - System

  11. Fiscal Year Update/View Status: to lock all users from editing or viewing CAT pages in order to close out the budget CAT Setup - Examples Include: University of Wisconsin - System

  12. CAT Rate Calculation Type: to determine the process of applying multiple compensation changes, usually aligned with the corresponding IPS version CAT Setup - Examples Include: University of Wisconsin - System

  13. SFS Ledger for Budget Edits: Specifying which type of funding edits are used when ‘Okay to Load to HRS’ is unchecked on a CAT page The AAP will also check against the funding edits selected here. CAT Setup - Examples Include: University of Wisconsin - System

  14. Calculation Method and Continuing Staff Base by Reason: to select which Action Reasons appear in the CAT drop down and how they calculate CAT Setup - Examples Include: University of Wisconsin - System

  15. Base Increase Percent by Empl Class and Reason: to reflect pay plan guidelines for a set Merit (or other action reason) percentage CAT Setup - Examples Include: University of Wisconsin - System

  16. CAT Setup - Data Freezing • When the time comes to perform final reconciliation, each institution will select the time to turn off the automatic job data feed between HRS Job Data and CAT records. • This can be done by division on the Data Freeze tab of the Annual Setup Page in CAT Setup. University of Wisconsin - System

  17. CAT Setup - User Locking • This page is used to ‘lock’ users, especially toward the end of the budgeting cycle. • When a user is locked, their access is switched to View Only. When a user is unlocked, their access corresponds to their given CAT security role. • If a user has the Read Only role, they will remain View Only regardless of if they are locked or unlocked. • At the beginning of each planning year and when a new user is given a CAT security role, the UW System CAT Admin must visit this page and unlock them in order for the new user to be given their full access. University of Wisconsin - System

  18. Lock Users: to lock users out of CAT at the end of the budget cycle Note: an institution can search by Department or Business Unit to find employees CAT Setup - User Locking University of Wisconsin - System

  19. Training Overview University of Wisconsin - System

  20. Locating the CAT • The CAT can be found by navigating in PeopleSoft to Workforce Administration  UW External HR Systems  Compensation Admin Tool University of Wisconsin - System

  21. Locating the IPS • The IPS template files can be found under the Resources and Training section on the homepage of the CAT website University of Wisconsin - System

  22. Training Overview University of Wisconsin - System

  23. Running one IR or multiple? Creating one IPS, duplicates, or unique files? Centralizing or distributing the IPS work? Business Process Considerations University of Wisconsin - System

  24. Initialization Report (IR) andInstitutional Planning Spreadsheet (IPS) The IR pulls current HRS data, which is transferred to the IPS -a spreadsheet used to analyze employee populations and assign rate and funding changes. These changes can be made enmasse or on an individual basis. University of Wisconsin - System

  25. Initialization Report (IR) • The IR allows the user to create a run control, specifying these particular fields: • Fiscal Year • Effective Date (ex. 07/01/2016) • Business Unit • Division • Employee Class University of Wisconsin - System

  26. Initialization Report (IR) • When the process is run, it will provide an Excel spreadsheet output file, specifying fields including: • Business Unit • Department ID • Employee ID • Employee Record Number • There may be two Excel outputs • One for employees with five or fewer funding splits • One for employees with more than five funding splits • Name • Employee Class • Etc. University of Wisconsin - System

  27. IR to IPS Transfer • This is a manual transfer process between the IR Excel file and the IPS Excel template file. • This template file can be found on the CAT website. • www.wisconsin.edu/compensation-administration-tool • Each institution will choose between the IPS Base template and the IPS Cumulative template depending on their institutional annual setup preferences. University of Wisconsin - System

  28. Institutional Planning Spreadsheet (IPS) • The input fields of the IPS are populated manually by copying and pasting from the IR. • Compensation and funding changes can be made en masse and automatically calculated on this sheet for employees with up to five funding splits. University of Wisconsin - System

  29. IPS Data Upload to CAT • The rate and funding data in the IPS is then loaded into the Compensation Administration Tool through the IPS to CAT Upload Process. University of Wisconsin - System

  30. IPS Data Upload to CAT • The rate and funding data in the IPS is then loaded into the Compensation Administration Tool through the IPS to CAT Upload Process. University of Wisconsin - System

  31. Example Annual Budget Timeline University of Wisconsin - System

More Related