Skip to main content

B0012 Employee Range Revisions and Reallocations

Purpose

The purpose of this report description is to explain the Employee Range Revisions and Reallocations report and how to generate it in the system.

Report Description

This report lists employees who have received a Range Revision or Reallocation and shows if there is a balance.  Provides jump to ‘B0022: Comments’ report. 

Report Location

PA: Compensation

Report Uses

  • Report shows if an increase was given to the employees.
  • Report shows if a partial increase was given and the remaining balance.
  • Agencies should generate this report to identify/validate which employees have received a Reallocation or Range Revision.

How to Generate This Report

This report is generated after selecting values for the mandatory prompts.  All mandatory prompts must have values selected before the Run Icon can be used to generate the report. Mandatory prompts can be identified as mandatory by the exclamation mark inside of the yellow-orange triangle, the square with the checkmark, or the display of (Mandatory).  Detailed instructions for interaction with each prompt can be found on the Web Intelligence Prompt List on the OSC website.

The Mandatory prompts for this report are:  

  • Organizational Unit
  • CalMonth/Year (Single Value/Interval, Mandatory)

This report can also be further limited by utilizing the Optional prompts to further limiting the amount of data that retrieved into the body of the report. Optional prompts are indicated as option in parentheses beside the prompt.   

The Optional prompts are: 

  • Action Type(s) - (Optional)
  • Action Reason(s) - (Optional)
  • Personnel Area(s) - (Optional)
  • Employee(s) PersNo. - (Optional)
  • Job(s) - (Optional)

Initial Layout

The report lists employees who have received a Reallocation or Range Revision during the time frame selected.  Below is a sample rendering.

Continued…

Available Objects

This is a list of the available objects that can be added to the report, from the Document Dictionary once in the Design mode:

Dimensions

  • Action Reason
  • Action Type
  • Agency Hire Date
  • Comments?
  • Effective Date
  • Emp Pay Area
  • Emp Pay Group
  • Emp Pay Level
  • Emp Pay Type
  • Employee
  • Employee Group
  • Employee Subgroup
  • Employee's Name
  • Job
  • Job Branch
  • Job Family
  • Organizational Unit
  • Original Hire Date
  • Personnel Area
  • Position
  • Prior Emp Pay Area
  • Prior Emp Pay Type
  • Processed Date
  • Prior Emp Pay Group - Key (Not Compounded)
  • Prior Emp Pay Level - Key (Not Compounded)

Measures

  • Annual Salary
  • Pct Chg in Salary
  • Prior Salary
  • Wage Type Amount

Variables

  • No Pct Change
  • Prompt Response Action Reason
  • Prompt Response Action Type
  • Prompt Response Cal Mth/Yr
  • Prompt Response Employee PersNo
  • Prompt Response Job
  • Prompt Response Organizational Unit
  • Prompt Response Personnel Area

Special Report Considerations/Features

  • Contractors are excluded.
  • Report only pulls active employees.
  • To change the sorting for the desired column.

By default, data is sorted by Personnel Area. (This can be changed as needed).

There are 7 steps to complete this process.

Step 1.    Left click to select the desired column.

Step 2.    Right click on the desired column.

Step 3.    Select Data.

Step 4.    Select Add Sort or Edit Sort.

Step 5.    The Sort menu will display on the right-side panel.

Step 6.    Hover the cursor in the top right corner of the desired category.

Step 7.    Click the X to remove the sort.

  • Conditional Formatting/Alerts
    • Columns Employee (1) and Pct Chg (2) will be highlighted to Red if the below criteria is true.
      • Criteria for Conditional Formatting: Turn cell red if Pct Change = 0 AND Action is Not (ZA/06 or ZE/05).

First Published

Last Updated