The Payroll Register Report displays the balances for earnings, deductions, and taxes. Use Payroll Register Reporting to show employee and group level details, such as:

• Complete payroll run details for pay runs, quick pays, and reversals

• Specific federal or provincial taxes withheld

• Earnings and deductions

• Employer liability

  1. Predefined liabilities:

     • CPP ER Liability

     • EI ER Liability

     • PPIP ER Liability

     • QPIP ER Liability

     • WCB ER Liability

  2. User-defined employer liabilities. You must complete setup steps to view the user-defined employer liabilities in the Payroll Register Report. See: Setup Steps to View the User-Defined Employer Liabilities in the Payroll Register Report.

• Quarter-to-date and year-to-date details (includes balance adjustments)

Setup Steps to View the User-Defined Employer Liabilities in the Payroll Register Report

The Payroll Register Report displays the predefined or seeded liabilities by default. To view the user-defined employer liabilities, complete the following setup steps for each user-defined employer liability:

1. Create a primary balance with Category as 'Employer Liabilities'.

   1. Navigate to the Balance window.

   2. Enter the name of the balance.

   3. Select Employer Liabilities as the category.

   4. Enter Money as units.

   5. Click Dimensions. Add the following dimensions to this balance.

      Assignment within Government Reporting Entity Run

      Assignment Payments

      Assignment within Government Reporting Entity Month

      Assignment within Government Reporting Entity Year to Date

   6. Save your work.

   7. Query the balance and click the Attributes button.

   8. Make sure that the PAY_CA_EMPLOYER_LIABILITY attribute is attached to the balance.

2. Create a user-defined employer liability element.

   1. Navigate to the Element window.

   2. Create element details for the user employer liability element.

   3. Click the Further Information field. The Further Element Information window appears.

   4. Select the balance that you created in the Primary Balance field.

   5. Save your work.

   6. Click Balance Feeds. The Balance Feeds window appears.

   7. Add the balance that you created as the balance feed.

3. Attach the user-defined employer liability element to the employee record.

   1. Navigate to the People window.

   2. Search for the employee.

   3. Click Assignment and then Entries. The Element Entries window appears.

   4. Add the element that you created.

   5. Click Entry Values and provide the required details in the Entry Values window.

4. Run the Payroll and PrePayments Processes before you run the Payroll Register Report.

Payroll Register Report

The Payroll Register Report CA request set consists of two separate reports:

• Payroll Register Report

  This report shows details for Organizations, Locations, and GREs, as well as details for individual employees and any Earnings and Deductions element paid or deducted during that payroll run, sorted by employee.

  Note: Depending on the selected parameters, the Payroll Register report can be large and may take considerable time to run and print. See the final section of this document on report performance for more information.

• Payroll Register Totals Report

  This report shows the current totals for the selected sort options: Organizations, Locations, and GREs. It also shows the total value of all hours and earnings for all employees processed in the payroll run. It does not display employee, month-to-date, and year-to-date balances.

See: Payroll Register Reporting

Parameters

The following parameters exist for the Payroll Register reports:

• Beginning Date Paid (required)

  Select the beginning date for report selection. This date represents the payment date for the payroll runs/QuickPays or the effective date of the payroll reversals that are to be included in the report.

• Ending Date Paid (required)

  Select the end for the report selection. This date represents the payment date for the payroll runs/QuickPays or the effective date of the payroll reversals that are to be included in the report.

  Note: In very large organizations, there may be a slight delay in accessing the List of Values for Ending Date Paid.

• Payroll

  Select from the List of Values to run this report for a specific payroll. Either a payroll or a consolidation set is required to run the Payroll Register report.

• Consolidation Set

  Select from the List of Values to run this report for a consolidation set. If you select a payroll in the Payroll field that is associated with a consolidation set, this field automatically populates. Either a payroll or a consolidation set is required to run the Payroll Register report.

• Government Reporting Entity (GRE)

  Select from the List of Values to limit the report to a single GRE. If you enter nothing in this field, the report contains information for all valid GREs.

• Organization

  Select from the List of Values to limit the report to a single Organization. If you enter nothing in this field, the report contains information for all valid Organizations.

• Location

  Select from the List of Values to limit the report to a single Location. If you enter nothing in this field, the report contains information for all valid Locations.

• Employee Name

  Select from the List of Values to limit the report to a single employee. If you enter nothing in this field, the report contains information for all valid employees.

• Suppress Current Zero Records

  The default entry for this field is Yes. If you enter No in this field, the report shows balances for employees that have no current balances, but may have month-to-date or year-to-date balances.

  This parameter applies to individual line items only and does not suppress entire assignments with Zero Records.

• Full Report

  The default entry for this field is No. With No selected, the report shows balances for Hours, Earnings, and Deductions. If you select Yes, the report also includes balances for Taxable Wages and Employer Tax Liabilities.

• Reporting Dimensions

  The default entry for this field is Current. The Payroll Register report always show the current balances. In addition to current balances, the report detail can also display month-to-date and year-to-date balances.

  Note: You may encounter slow performance while running the Payroll Register report with a month-to-date Reporting Dimension selected.

  This parameter is ignored by the Payroll Register Totals report. Only current values display on the Payroll Register Totals report.

• Sort Options

  There are three fields for sort options. See the Sort Options section for more information on how to properly use these parameters.

• Employee Page Break

  The default entry for this field is No. If Yes is selected, the Payroll Register report prints with a page break after each employee contained in the report. This parameter is ignored by the Payroll Register Totals report.

Sort Options

You can organize Payroll Register reports according to user-defined criteria or sort options. Oracle Payroll does not require that you use sort options to generate your report, but they are the best way to customize the reports to your specific needs. You can sort reports by any or all of the following options:

• GRE

  Note: GRE should only be selected as a sort option if you have included all GREs in the parameters for a Payroll Register request set.

• Location

• Organization

• Employee Name

The sort options are hierarchical in nature. The Sort Option Two field enables only after you have made a selection in the Sort Option One field. The Sort Option Three field enables after you have made a selection in the Sort Option Two field.

The following is an example of how to use sort options to customize the Payroll Register reports.

If you want to create reports sorted by GRE, Organization, and Location, you enter GRE into the Sort Option One field, Organization into the Sort Option Two field, and the Location into the Sort Option Three field. Using the selected Sort Options, Oracle Payroll generates the reports listing payroll register data for each Location alphabetically by Organization within each GRE for the selected payroll or consolidation set.

Report Output

In order to make balance information more meaningful, Oracle HRMS groups similar types of balances in the report:

• Earnings (Including Non Payroll Payment)

• Deductions

• Employer Liabilities

• Information

The Payroll Register Report and Payroll Register Totals Report are two separate reports submitted by way of a single Request Set. Both reports are printed according to the parameters that you select. These reports are printed in landscape fashion and are designed to fit on 8.5" x 11" paper. The Payroll Register Report and Payroll Register Totals report do not contain page numbers.

For performance reasons (see below) the two reports are designed to take advantage of a multi-threaded environment, and contain sequence numbers that can be viewed from the Requests window.

Performance and the Payroll Register Reports

The Payroll Register reports can contain large amounts of information. For maximum system performance, these reports are designed to take advantage of a multi-threaded environment. In order to make sure you are getting maximum performance from the Payroll Register reporting process, your system should have the Payroll Action Parameters configured for Parallel Processing.

If you are running the Payroll Register request set for a large organization, you may experience performance concerns when including quarter-to-date balances in the Reporting Dimensions parameter. You may also experience performance issues if you change the Full Report parameter from No to Yes.