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

Position number

Previous salary/stipend

New salary/stipend

Baseline

Effective date of increase

GL override dates (if applicable)

Predecessor fund (e.g., “11000”)

GL

Account

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:

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.