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. Select College/MAU.
  2. 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 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 will expand any grouped data that was previously collapsed.
  2. Collapse AllCollapse All
    • When clicked will collapse grouped data that was previously expanded.
  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 will pop the raise list out in from the the default application screen. The icon will switch to minimize at that point to close the new view.

Download Excel

  1. Enter any desired filter for College/MAU.
  2. Click on Download Excel icon.
  3. 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.