Payroll Register Report

Use the Payroll Register Report to review the reported earnings, taxes, deductions, and employer liabilities archived in the periodic archive process.

Verify total payment amounts per balance category and compare payment values to previous periods.

This table details the tasks available for you to run the Payroll Register Report and view latest process year-to-date and periodic balances.

Report Task Name	Purpose
Run Payroll Register Report	Use this task to run the legacy report.
Run Payroll Register Report for the Latest Process	Use this task to extract the year-to-date (YTD) payroll balances for large volumes of data. The report runs much faster than the legacy report and includes year-to-date totals from the last process run for a person prior to the specified end date, such as the last process run for each TRU. The results are the same as running the legacy report with the Latest Process YTD Total Only parameter set to Yes.
Run Periodic Payroll Register Report	Use this task to extract the periodic payroll balances for large volumes of data. The report runs much faster than the legacy report. The results are the same as running the legacy report with the Latest Process YTD Total Only parameter set to No.

When to Run Report

Run this report after you have successfully completed archival of your periodic payroll data. This usually occurs during your payroll flow.

Parameters to Consider

Parameter values determine which records to include in a report. Most parameters are self-explanatory, but some of them, as mentioned in this table have special meaning in the context of the report.

Payroll Register Report Parameters

Parameter Name	Description
Latest Process YTD Total Only	If you select No, the report lists current (run) balances based on the Balances Reported value against every process the report parameters include. For example, assume there are three payroll calculations run between the start and end dates of the report. The report lists the statutory deduction balances in three sets, one for each process. If you select Yes, the report includes year-to-date totals from only the last process run before the specified end date, such as the last process run for each TRU or PSU. However, it's recommended to run the Statutory Deduction Register for the latest process instead.
Balances Reported	Use this field to run this report for payment balances, nonpayment balances, or both, as given here. Payment Only: Includes balances included in the payments process. Nonpayment Only: Includes balances that aren't included in the payments process. If you leave the field blank, the report includes all balances.
Report Category	A report category is a group of delivery options. Select a value to determine the set of delivery options for this report submission. You can define your own delivery option and include it in the report category. For example, you can define a report category to use a combination of both PDF and Excel delivery options for a single submission of the report.
Run Mode	Use this parameter to decide if the report must retain or discard the transient data it creates during the report execution. If the default value is Normal, the temporary transient data produced during report execution is discarded. Select Debug only to investigate an issue with the report output or when instructed by Oracle Support. The Normal option discards the temporary data.

Report Output

Use the Scope parameter to generate the report output in any of these modes.

• Use the Summary option to verify total payment amounts per balance category for a payroll period for a PSU or TRU. The summary report provides a list of balances by:

  • Balance Category

  • PSU and TRU

  • Balance Name

  • References

  • Current Amount

  The PDF output has these summary sections with subtotals in each section as given here:

  • Balance Categories Summary

  • Balances Summary with subtotals for each balance category

  • Balances by PSU and TRU Summary with subtotals for each balance category within each PSU

• Use the Detail Report option to view the following employee-level deductions details in addition to the summary balances shown by the Summary report.

  • • Balance Category

    • Balance Name

    • Total Deduction Amount

    The PDF output has these summary sections with subtotals in each section as given here:

    • Balances and Balance Categories Summary with subtotals for each balance category.

    • Balances Summary for each balance category.

    • Balances by PSU and TRU Summary with subtotals for each balance category within each PSU.

    • Balance Details for a Person with subtotals for each balance and balance category. This section also includes:

      • Payroll relationship number

      • Run type

      • Payroll period

      • Calculation breakdown ID

      • Year-to-date deduction amount

    The detail report is sorted in the order of PSU, TRU, person name, payroll, pay period, balance category, and balance.