Annual Academic Raise - Control totals by college/mau

Introduction

This tile opens a report to track merit control totals, Excellence & Equity amounts awarded, and submission status by College/MAU. Data display will be based on a user’s access. The report may be run wide open or filtered based on Year, College/MAU, or Approval Level.

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

Default Display

The default display provides a row for a College/MAU with approval and the raise data as follows:

  • College/MAU - the concatenated number and name of the College/MAU.
  • Merit* - calculated merit control total for the College/MAU.
  • Remaining Merit* - the amount of the calculated merit for the College/MAU that has not been awarded. 
  • UNTF Merit* -  calculated UNTF merit control for the College/MAU.
  • Remaining UNTF Merit* - the amount of the calculated UNTF merit for College/MAU that has not been awarded. 
  • Awarded Annual Excellence & Equity*- excellence & equity awarded in annual dollars for the College/MAU.
  • Awarded Annual Excellence & Equity* - excellence & equity awarded in Full Time Equivalent (FTE) dollars for the College/MAU.
  • Approval Level - current approval level for the College/MAU. Valid values are Department Approval, College/MAU Approval, and University Approval.

* College/MAU totals reflect amounts after removing duplicate relationships.

Tool Bar

  1. Expand All Double ArrowsExpand All
    • When clicked any grouped data that was previously collapsed will be expanded.
  2. Collapse All Double Up ArrowsCollapse 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.
  4. Settings GearSettings
    • Open settings to change the default groupings, sort, or column display.
  5. MaximizeMaximize
    • When 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 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_CTRL_(MAU/org number)_(date/time stamp)."

Notes: 

  1. Approval level will not be included in the downloaded file.

Authorization and Access

To access the Control Totals by College/MAU Report, users must have the applicable security role in place:

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

Employees will appear on lists 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 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.