Element Results Register
The Element Results Register lists the elements and their primary output for processes that generate run results, such as the Calculate Payroll and Calculate Gross Earnings tasks.
To generate the report, submit the Run Element Results Register flow on the Submit a Flow page. Use Submit a Flow under Payroll in My Client Groups on the Home page.
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. Predefine these groups before you can use them. Most parameters are self-explanatory, while the following have special meaning in the context of this report.
Process Start Date
Use this field to specify the first effective date of the payroll process to include in the report. All processes with an effective date equal to or greater than the Process Start Date is reported.
Process End Data
Use this field to specify the last effective date of the payroll process to include in the report. For Payroll Runs this is the 'Payroll Run Date'. All processes with an effective date equal to or prior to the Process End Date are reported.
For offset payrolls, the effective date of the payroll or Quick-Pay run could be after the end date of the payroll period. In such cases, you must ensure that your Process End Date must be on or after the effective date of the process you want to include in the report.
Payroll
Select the required payroll name. Leave blank to run against all payrolls.
Consolidation Group
Use this field to run the report against a consolidation group. A consolidation group defines a grouping of different payrolls for reporting purposes. For example, you can use this field to run this report for a subset of payrolls. You can select a value only if you have a predefined consolidation group. If you don't select a value, the application uses the default consolidation group assigned to the payroll.
Payroll Statutory Unit
To include all employees in a payroll statutory unit (PSU) in your report results, specify it here. Leave blank to run against all PSUs.
Tax Reporting Unit
To include all employees in a tax reporting unit (TRU) in your report results, specify it here. Leave blank to run against all TRUs.
Location
Use this field to view the elements results for employees who have at least one assignment for the selected location.
Element Group
Use this field to run this report against all elements in the selected element group. Leave blank to run against all elements.
Element
Use this field to run this report against a specific element. Leave blank to run against all elements.
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.
You must 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 elements of an individual employee. If left blank, the report is generated for all active employees.
Process Type
The options that you can select include:
-
Payroll Calculation
-
Quick-Pay
-
Reversal
-
Balance Adjustment
-
Calculate Gross Earning
Totals by Element and Person
After you run the report, use the pivot table feature in Microsoft Excel to obtain totals by element and person. For example, complete these steps to create a pivot table that displays these totals:
-
Open the Element Results Register in Microsoft Excel.
-
Select the range of cells in the spreadsheet that contain data.
-
Click PivotTable from the Insert menu.
-
In the Create Pivot Table dialog, select New Worksheet. Click OK.
-
Click these fields from the Pivot Table Field List:
-
Person Name
-
Payroll Statutory Unit
-
Tax Reporting Unit
-
Payroll
-
Run Type
-
Element Name
-
Value
-
-
Drag the fields to these areas:
Area
Fields
Report Filter
Payroll Statutory Unit, Tax Reporting Unit, Run Type, Payroll
Column Labels
Element Name
Row Labels
Person Name
Values
Sum of Value
-
Refresh the page to display the populated columns and rows, and the summed totals.
-
Filter to view different results.