March 25, 2009
Salary Increase Report (93A)
This report provides a summary of a unit’s salary adjustments (either across-the-board increases or step increases) processed by Human Resources. Based on the code entered in the parameters of the report, you can obtain a detailed list of across-the-board increases, step increases or stipend increases once they have been processed in VIP. (Please refer to “Increase Dates and Timing of Reports” at the end of this document for explanation on timing of increases and when to run reports.)
The report details the following:
Employee name and ID number
Effective date of increase
GL override dates (if applicable)
Predecessor fund (e.g., “11000”)
Previous annual salary
GL annual amount
Percentage paid from each GL
Compensation (“affiliate”) group
Running the Report
To run the report, go to the VIPEMP module and under the Report menu, click on Salary Increase Report. In the middle of the Disposition (DCS) screen you will see Parameter Name and Parameter Value. Enter the effective date of the increase in the space provided under Parameter Value(format is APR 1 2008) and click on the Include button.
There are two other required parameters: Reason Code which allows you to query for a specific type of increase, and Fiscal Year which indicates the baseline for the position, taken from Aurora. Under the drop-down menu for the Parameter Name, click on Reason Code and enter one of the following codes in the Parameter Value field:
024 – for step increases
025 – for general increases
083 – for minimum wage increases
090 – for stipend increases for UMFA department heads and UMFA non-standard stipends
Click on the Include button.
Under the drop-down menu for the Parameter Name, click on Fiscal Year and enter the fiscal year in which the increase is taking place (e.g., 2009 if the increase is in the 2008/2009 fiscal year; 2010 if the increase is in the 2009/2010 fiscal year). (The baseline column on the report provides information taken directly from Aurora and shows the current baseline assigned to the particular position.) Click on the Include button.
You may request the report by compensation group if you wish. This is an optional parameter and the report may be run without indicating this. (Do not enter compensation group when running the report for step increases or minimum wage increases.)
If you want to request information by compensation group, under the drop-down menu for the Parameter Name, click on Compensation Group and enter one of the following codes in the Parameter Value field and then click on Include:
001 - UMDCSA
002- UMFA ACADEMICS
003 – UMFA LIBRARIANS
004 - CAW
005 - AESES
006 – AESES-SECURITY
007 – CUPE 1482 (ENGINEERING)
008 – CUPE LOCAL 3909 SESSIONALS
009 - CUPE LOCAL 3909 STUDENTS
010 - EMAPS
011 - EMAPS
012 – EXECUTIVES/SR ADMIN
013 - GFTS
014 – ACADEMIC ADMINISTRATORS
015 – EXCLUDED PROF SESSIONAL ACADEMIC STAFF
017 –OTHER ACADEMICS
022 – MEDICAL PRACTITIONERS AND ADMINISTRATORS
023 – UMFA INSTRUCTORS
024 – CUPE 3909 LIBRARIANS
025 – ADMIN EXCLUDED ACADEMIC POSITIONS
EMAPS: When running a report on EMAPS increases, it is important to include both “010” and “011” compensation groups. To do so, enter the “010” and Include, then enter the “011” and Include before executing the report. You will have two compensation group codes show up in the Selection Criteria section of the screen.
UMFA: When running a report on UMFA increases, it is important to include “002”, “003” and “023” compensation groups. This will include all UMFA members in your unit. To do so, enter the “002” and Include, then enter the “003” and Include, then enter the “023” and Include before executing the report. You will have three compensation group codes show up in the Selection Criteria section of the screen.
Once you have chosen the parameters and included them in the query, click Execute at the bottom of the screen to generate the report. To print the report, click on the printer icon in the report window.
To export the report to Excel, click on the export icon in the report window (i.e., the “envelope”).
The UMFA report should show a minimum of two lines per individual, but most individuals will have three lines (for this year, the first line will show the $500 added to the March 31/08 salary, the second line will detail the 2.5% general increase and the third line, if applicable, will show the addition of the increment).
Codes “026” and “027” are for those individuals who have had a full or half increment withheld.
Increase Dates and Timing of Reports
General (“across-the-board”) Increases:
An email will be sent to PSUs once general salary increases are finalized in VIP. At this point you may wish to run the Salary Increase Report using the parameters that will be specified in the emails. If you run the reports prior to receiving the email there may be data in the report that is inaccurate as there are usually manual adjustments to be made prior to the finalization of the increase.
Step increases are processed on a biweekly basis for those employees who have set salary review dates. The step increases are always effective at the start of a biweekly pay period (i.e., the Saturday’s date). The effective date to use in the report is the start of the pay period (i.e., the first Saturday). There will not be a general email sent for step increases as this is a regular ongoing process. You may wish to run the Salary Increase Report for step increases on a regular basis closer to the actual paydate for that pay period.
For example, if you are running the report for step increases that are effective March 22, 2008 (for the biweekly pay period of March 22 – April 4, 2008), running it closer to the actual paydate of April 11, 2008 will ensure that the step increases are in VIP.
(This Salary Increase Report will not be used for the part-time step increases as they are effective whenever an employee actually reaches the required number of hours for the increase.)
If you have questions regarding the Salary Increase Report, please call Patty Sanders, HRIS Compensation Administrator at 474-9584.