Periodic Payroll Activity Report for the US

Run the Periodic Payroll Activity Report for payroll verification, validation, and auditing purposes. Use it to view and reconcile the payroll balances info with the data archived by the periodic payroll archive process.

This report provides a high-level summary of all relationship-level balances across various balance categories, payroll statutory units (PSUs), and tax reporting units (TRUs). Use the Periodic Payroll Activity report to verify:

• Balance adjustments for all employees within a given time period

• Gross earning calculations

• Reversals within a given time period

• Balance initialization for a selected employee or all employees for a given time period

• Payroll or QuickPay runs for a given time period

To run this report:

1. From My Client Groups, click Payroll.

2. Click Submit a Flow.

3. Select your US legislative data group.

4. Search for and select Periodic Payroll Activity Report.

Report Parameters

The parameter values determine which records to include in the report. For example, run this report for a specific consolidation group or payroll relationship group. You must predefine these groups before you can use them.

Scope

Control the results of the report by setting its scope.

What you set	What it does
Summary	Provides a summary of payroll relationship-level balances across all workers by balance category, balance type, TRU, and payroll activity.
Detail	Provides the detail of each payroll relationship-level balance for every worker in every payroll activity.

Process Start Date

Select the first effective date of the payroll process to include in the report. Reports all processes with an effective date equal to or later than this date.

Process End Date

Select the last effective date of the payroll process to include in the report. Reports all processes with an effective date equal to or earlier than this date.

Note: For payroll runs, the process end date is the payroll run date.For offset payrolls, the effective date of the payroll or QuickPay run could be after the end date of the payroll period. In such cases, make sure your process end date is on or after the effective date of the process you want to include.

Payroll

Select the name of the payroll.

Process Type

The options that you can select are:

• Balance adjustment

• Balance initialization

• Calculate gross earning

• Payroll calculation

• QuickPay

• Reversal

Consolidation Group

Use this field to run the report against a consolidation group. If you don't select a value, the report uses the default consolidation group assigned to the payroll.

For further info, see Consolidation Groups for the US in the Help Center.

Payroll Statutory Unit

To include all employees in a PSU in your report results, select it here.

Leave blank to run against all PSUs.

Tax Reporting Unit

To include all employees in a TRU in your report results, select it here.

Leave blank to run against all TRUs.

Location

Use this field to view the balance results for employees who have at least one assignment for the selected location. The balance values might not correspond to the location parameter only. It is also dependent on the dimensions and the other associated contexts.

Department

To include all employees in a specific department, select it here.

Leave blank to run against all departments.

Payroll Relationship Group

Select the payroll relationship group name, if you have defined one. Payroll relationship groups limit the persons processed for payroll, data entry, and reporting. For example, you can create a group to process the report for terminated employees.

Note: Use the Object Groups task to define the payroll relationship group before you can select it here.

Person

Select the person number to view the balances of an individual employee.

Leave blank to generate the report for all active employees. This field is disabled for the summary report.

Person Page Break

Select Yes to generate the report with details per person per page. This field is disabled for the summary report.

Hide Records with Zero Value

If you select Yes, balances with 0 values aren't displayed in the report.

Process Configuration Group

Select the process configuration group if you have defined one. Use a process configuration group to provide sets of processing parameters, primarily related to logging and performance. If you don't select a process configuration group, the report uses the parameters in the default group for the selected payroll.

Balances Reported

Use this field to run this report for payment balances, nonpayment balances, or both.

Select this	To do this
Payment only	Includes balances included in the payments process.
Nonpayment only	Includes balances that aren't included in the payments process.
Blank	Includes all balances.

This field is disabled if you set Latest Process YTD Total Only to Yes. This includes all balances in the report. For further info, see Report Payment and Nonpayment Balances in the Help Center.

Report Category

If you have defined a report category for delivery of output in multiple formats, select it here.

For further info, see Delivery Options for Extract-Based Payroll Reports for the US in the Help Center.

Run Mode

Use to control whether the report retains or discards the transient data it creates when producing the output file.

Select Debug only to investigate an issue with the report output or when instructed by Oracle Support.

The Normal option discards the temporary data.

Display All Hours

Select Yes to include hours from supplemental earnings and other element classifications. If you select No, the report includes only hours from Regular or Standard Earnings and Absence Earnings.

For further info, see Display All Hours in Payroll Reports in the Help Center.

Report Results

The report provides details of payroll balance results for matching persons, filtered by the specified time frame and the selected parameters. The results of the report depend on the scope value you selected when you ran the report.

Note: You can view the archived info in the Payroll Register.

Report name	What it contains
Summary Report	The summary report has these sections: Summary for Balance Categories Summary for Balances Summary for Balances by PSU and TRU Balances by Payroll and Process Type Summary This report is included when you set Latest Process YTD Total Only to No or left blank. It returns one of the following, depending on the Balances Reported parameter. Payment balances data Nonpayment balances data Both
Detail Report	The detail report includes the three summary sections, followed by a fourth for employee-level balances. It's separated by payment and nonpayment balances. Unpaid balance adjustments when you set Include adjustment in payment balance to No during the adjustment Unpaid reversals