Actions Report

 View Options:              Print
Procedure Updated: 
05/10/19

Use this report to identify personnel actions within a specified date range; new hires, appointment changes (such as internal movement, home assignments, etc.), separations, leaves of absence, and/or all other personnel actions.

Tips: 

Authorization to view employee data is enforced based on the user’s active security profile in HRMS. For example, you cannot view actions that occurred at another agency.

  1. Enter transaction code ZHR_RPTPA807 in the command field and click the Enter button.

    Screenshot of command field.

  2. Complete the Date Selection section.

    The following fields will default to blank:

    • Date From
    • Date To

    Screenshot of date selection section.

    Tips: 

    The Date Selection section will determine the date range of actions that display in the results. The report will only display actions with an effective date during the date range entered.

    Date From is required. Date To can be left blank but doing so will result in Actions only effective on the Date From date.

    The Report results will return the active, valid record on the start date of the action. For example, if the Selection Dates are 01/01/2018 to 12/31/2018 and there was an Appointment Change action effective 5/1/2018, then the position, job, work contract, etc. fields in that row will show as what was active on 5/1/2018.

    When identifying separation actions for turnover, OFM State HR moves forward the Date From/To by one day to account for the effective date of the action. For example, if you set the Date From and Date To as 1/2/2018 through 2/1/2018, you will get turnover that occurred (the employee’s last day of employment) from January 1 to January 31, 2018.

  3. Complete the Selections section.

    The following fields are optional:

    Screenshot of selections section.

    Tips: 

    The Selections section will assist in getting only the information needed. A selection is not required for each field.

    If the Action Type field is left blank, the report will return all Action Types within the selected date range.

    Additional filtering to the report results may be necessary when entering Action Reason criteria because there are multiple Action Reasons with the same name and/or code.

    Position Number selections will not work with Separation Actions because the person is no longer assigned a position number as of the effective date of the separation.

    Checking the Include Annual Salary box will make the report run slower.

    Annual Salary will only populate in the report results when Include Annual Salary is selected. If Include Annual Salary is not selected, Annual Salary will display as “N/A” if brought into the report results.

  4. Previously saved layout variants may be added to the ALV Variant section.

    Screenshot of ALV variant section.

    Tips: 

    An ALV Variant name is not required. Leaving this field blank will result in a default layout for this report.

  5. Click the Execute button.

    Sample report results:

    Screenshot of report results. Click to expand.

    Sample report results. Click to expand.

    Tips: 

    Columns included in the report results depend on your default layout for this report. The report layout can be changed, saved or a previously saved layout can be selected.

    The full column names will display when hovering the cursor over the column headings.

    Effective Date of Action is the start date of action record on the Actions (0000) infotype.

    Annual Salary will only appear in the default report layout when the Include Annual Salary box is selected on the report selection screen.

    Position will be blank if the Action Type is Separation since the employee/position relationship was removed upon leaving state service.

The following table maps each field to the infotype:

Report Field Infotype Name Infotype Number
Appointment Date Date Specifications 0041
ACA Status Code Planned Working Time 0007
Action Reason Actions 0000
Action Reason Code Actions 0000
Action Type Actions 0000
Action Type Code Actions 0000
Anniversary Date Date Specifications 0041
Annual Salary Basic Pay 0008
Business Area Organizational Assignment 0001
Business Area Code Organizational Assignment 0001
Cap.util.lvl Basic Pay 0008
Effective Date of Action Actions 0000
Employee Group Organizational Assignment 0001
Employee Group Code Organizational Assignment 0001
Employee Subgroup Organizational Assignment 0001
Employee Subgroup Code Organizational Assignment 0001
Employment Percentage Planned Working Time 0007
Employment Status Actions 0000
Employment Status Code Actions 0000
End Date of Action Actions 0000
Full Name Organizational Assignment 0001
Hire Date Date Specifications 0041
Job Organizational Assignment 0001
Job Class Abbrev Job Object 1000
Job Code Job Object 1000
Organization Unit Code Organizational Assignment 0001
Organizational Key Organizational Assignment 0001
Organizational Unit Org Unit Object 1000
Organizational Unit Abbr Org Unit Object 1000
Pay Scale Level Basic Pay 0008
Personnel Area Organizational Assignment 0001
Personnel Area Code Organizational Assignment 0001
Personnel Number Organizational Assignment 0001
Personnel Subarea Organizational Assignment 0001
Personnel Subarea Code Organizational Assignment 0001
Position Position Object 1000
Position Abbr Position Object 1000
Position Number Organizational Assignment 0001
PT Indicator Planned Working Time 0007
Seniority Date Date Specifications 0041
UFI County (Employee) Duty Station Address 9105
UFI County (Position) Address 1028
Unbroken Service Date Date Specifications 0041
Work Contract Organizational Assignment 0001
Work Contract Code Organizational Assignment 0001
Workforce Indicator Job Relationship 1001

Example Scenarios

Below are examples of running the Actions Report. It is not a comprehensive list of every scenario.

Example 1 - View all New Hire actions that have been entered for the current pay period.

  • Today is 6/18/2018, payroll Day 1, and I need to review all the new hire actions that have been entered for the pay period of 6/1/2018 – 6/15/2018 to ensure they are complete and accurate.
  • On the report selection screen:
    • Date Selection:
      • Selection Dates = 6/1/2018 to 6/15/2018.
    • Selections:
      • Action Type = U0
      • Personnel area = 1790
      • Include Annual Salary = box checked

Screenshot of new hire actions.

  • Execute the report.

Click to enlarge.

Sample report results. Click to expand.

  • Two new hire actions have been entered for the pay period (layout has been changed for easy viewing and auditing).
  • I can compare report results against source documentation, such as appointment letter, internal data entry forms, etc., and make any corrections if needed prior to payroll processing.

Example 2 - View classification turnover related separation actions for fiscal year 2018.

  • I need to review all separation actions that are included in the OFM State HR definition of Classification Turnover for fiscal year 2018.
  • On the report selection screen:
    • Date Selection:
      • Selection Dates = 7/2/2017 to 7/1/2018

While the effective date of a separation action in HRMS is the first date the employee is no longer employed, OFM State HR uses the last day of state service as the turnover date. For example, separation actions with an effective date of 7/1/2017 are considered June 2017 turnover since the last day of state service was 6/30/2017.

In order to capture the correct turnover data in the Actions report, set the selection dates forward by one day, 7/2/2017 – 7/1/2018, to capture employees whose last day of employment was between 7/1/2017 and 6/30/2018 (fiscal year 2018).

  • Selections:

Screenshot of report parameters.

  • Execute the report.

Screenshot of report results. Click to expand.

Sample report results. Click to expand. 

  • Report results show 39 separation actions; however, when bringing Workforce Indicator into the results, we see that WMS and EMS are included.
  • Set a filter on Workforce Indicator to only show Classified WA General Service jobs.

Sample of report results. Click to enlarge.

Sample report results. Click to expand.

  • Report results show employee detail of all the agency’s Classification Turnover separation actions during FY18.