Wage Type Reporter
Use this report to create ad hoc reports using employee payroll results for a variety of reasons:
- View hours and amounts by wage type.
- View differences by pay period for overpayments or underpayments.
- View retroactivity amounts in-period and for-period.
- View breakdown of wage types or groups of wage types.
- View leave and leave without pay wage type hours and amounts.
- Assist with fund reconciliations.
OFM must have stored payroll for the period before you can run this report.
The HRMS Processor Guide recommends running this report during Payroll Days 1 through 4 to ensure the wage types processing are in accordance with your expectations.
There are many statewide variants available for the Wage Type Reporter report. Refer to the Statewide Variant List for more information.
Large amounts of payroll data will result in longer report run times. Depending on the filters you add to the selection screen, you may need to execute this report in the background.
Enter transaction code PC00_M99_CWTR in the command field and click the Enter button.
Complete the Selection section.
The following fields are optional:
- Personnel Number
- Company Code
- Personnel area
- Personnel subarea
- Employee group
- Employee subgroup
- Payroll area
Tips:The Selection section will assist in getting only the information needed. A selection is not required for each field.
Additional fields can be added to the Selection section using the Further selections button.
Complete the Payroll Interval section.
The following field is required:
- Period
The following field should be left blank:
- Payroll type
The following button is optional:
- Payroll Period
Tips:The Payroll Interval section will determine the time period of the employees and data that will display in the results.
The Payroll Period button can be selected if you want to run the report for one period. Or click the Payroll Comparison button to compare two periods.
Complete the Period determination section.
The following selection will default:
- In-view payroll periods
Tips:The Period determination section will default to In-view payroll periods but can be changed.
The following selections are available:
- In-view payroll periods: When checked, this selection will return information for the payroll period(s) in which a payroll result is created.
- For-view payroll periods: When checked, this selection will return information for which a payroll result is created. In the case of a retro calculation, the For-view period will be a prior period than the pay period in which the payroll results were created.
Complete the Other Selections section.
The following selections are optional:
- Wage Type
- Object selection
Tips:The Other selections section will assist in getting only the information needed.
A Wage Type selection is not needed, however, running this report without a wage type selection for multiple employees may result in long run times due to the large amount of payroll data.
The Object selection button is optional, however, running this report with the default objects selected will result in limited field options. We recommend adding Personnel Number to the objects selected.
Do not select the Archived Payroll Results or Display recs with null values check boxes. These are not used by the state of Washington.
Complete the Output section.
Select one of the following radio buttons:
- SAP List Viewer
- ALV Grid Control
- Microsoft Excel
The following fields are optional:
- Layout Variant
- Template PC File
Tips:The Output section determines the format of the report results.
The Output will default to SAP List Viewer but can be changed to a different selection.
A Layout Variant name is not required. Leaving this field blank will result in a default layout for this report.
Click the Execute button.
Sample report results:
Tips:Columns included in the report results depend on your Object selection fields and 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.
Example Scenarios
Below are examples of running the Wage Type Reporter. It is not a comprehensive list of every scenario.
Example 1 – Identify Montana state tax collection totals for year-end processing.
In this scenario, I have an employee who lives and works in the state of Montana and withholds Montana state tax using wage type 2686 in Recurring Deductions each period. Since the final period of the payroll year has completed, I need to identify how much Montana state income tax to report on the employee’s Form W2 (wage type 2686). As a payroll processor, I am going to run the Wage Type Reporter to view the employee's witholding amount.
On the report selection screen:
Example 2 – Provide a breakdown of worked time versus leave and holidays.
In this scenario, I have been asked to provide a breakdown of the hours and wages for time worked versus holidays and leave for the second quarter of 2025 for all employees. As a payroll processor, I am going to run the Wage Type Reporter to find this information.
On the report selection screen:
Note: Wage type /5UT does not show actual hours worked for full-time salaried employees; instead, it reports 80 hours each pay period. This wage type is used for reporting hours to Washington Labor and Industries workers' compensation program.
Example 3 – Report hours and wages to Employment Security Department for unemployment.
In this scenario, our agency has recently begun layoffs. I have been asked to audit the hours and wages reported by OFM to Employment Security Department (ESD) for the first quarter of the year to ensure all our employees’ hours and wages are reported to ESD correctly since we do not have any exemptions in our agency. HR has provided me with a report of all employees that I will use to cross check. I confirmed with the OFM Help Desk that the wage types I need to report to ESD are /5UH (hours) and /710 (wages). In addition, they’ve provided the following dates for quarterly reporting:
As a payroll processor, I am going to run the Wage Type Reporter to view the employees' quarterly data.
On the report selection screen: