annual academic raise - Excellence and Equity Report

Introduction

This tile opens a report to track Excellence & Equity raises awarded. College/MAU and department data display will be based on a user’s access.

To begin, from Excellence & Equity Report Tile:

  1. Enter/Select Raise Year.
  2. Enter/Select College/MAU.
  3. A row will be provided for each employee with Excellence & Equity amount awarded. 

Note:

An additional filter exists for Department and Personnel Number, but College/MAU is a required field.

Tip: For best results when typing in a search field select the appropriate values that prefill.

Default Display

A row is provided for each employee with Excellence & Equity raises given including the following data:

  • Person Name – employee’s preferred name formatted ‘last name, first name’.
  • Personnel Number – unique number for employee’s assignment.
  • Employee Unit - the concatenated number and name of the employee’s primary department.
  • Job Title – the job title for the employee’s assignment.
  • Employee Subgroup – employee’s appointment type.
  • UNTF% - percent of the employee's assignment that is union.
  • Emp % - employment percent.
  • Current FTE Salary – Full-Time Equivalent salary for the employee’s assignment.
  • Merit Raise Given – the dollar amount awarded, if any, for merit.
  • Deans Withhold Raise Given – the dollar amount awarded, if any, for deans withhold.
  • Excellence & Equity Raise Given – the dollar amount awarded for excellence & equity.
  • Promotion Increment – the dollar increment, if any, for promotion.
  • UNTF Merit Raise Given – the dollar amount awarded, if any, for UNTF merit.
  • Final Increase % – the overall all raise percentage for all raise increments awarded.
  • Final FTE Salary – the final FTE salary after all raises awarded

Tool Bar

  1. Expand AllExpand All
    • When clicked any grouped data that was previously collapsed will be expanded.
  2. Collapse AllCollapse All
    • When clicked any grouped data that was previously expanded will collapse.
  3. Download ExcelDownload Excel
    • When clicked will download the specified department using the default layout with all formulas.
  4. SettingsSettings
    • Open settings to change the default groupings, sort, or column display.
  5. MaximizeMaximize
    • While clicked the report pops out in front of the default application screen. The icon will switch to minimize at that point to close the new view.

Download Excel

  1. Enter/Select Raise Year.
  2. Enter/Select any desired filter for College/MAU.
  3. Click on Download Excel icon.
  4. The file that downloads will be given a name using the following format “AcadRaise_EE_(MAU/org number)_(date time stamp).

Note:

Single department download is only available for users with access to a single department. If a user has full College/MAU access the full College/MAU will download with a tab for each department. 

Authorization and Access

To access the Excellence & Equity Report, users must have an applicable security role in place:

  • Department Maintenance roles:  ZDHR_Raise_Dept_Maint_XXXXXXXX
  • College/MAU Maintenance roles:  ZDHR_Raise_MAU_Maint_XXXXXXXX
    • Automatically inherits edit access at the department level for all departments reporting to that College/MAU.
  • Department Display Only roles:  ZDHR_Raise_Dept_View_XXXXXXXX
  • College/MAU Display Only roles:  ZDHR_Raise_MAU_View_XXXXXXXX
    • Automatically inherits view access at the department level for all departments reporting to that College/MAU.
  • University Display Only role: ZDHR_Raise_Univ_View

Employees will appear on the report according to their position’s reporting relationships as well as funding, with exception. Employees appearing on multiple lists will be labeled as Joint. 

If you do not find the expected list Colleges/MAUs or Departments in the Annual Academic Raise tiles, please request access through an IT Access Request. If you do not find employees where expected, please reach out to Classification & Compensation.