Element Results Register for the US
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 run this process:
-
From My Client Groups, click Payroll.
-
Click Submit a Flow.
-
Select your US legislative data group.
-
Search for and select Element Results Register.
Report Parameters
Process Start Date
Select the beginning of the date range you want to check.
For example, to report on the elements involved a pay run, select the beginning of the run. If you want to review year-to-date results, select the beginning of the year.
Process Start Date
Select the end of the reporting range.
Payroll
Select the payroll definition you want to run against.
Leave blank to run against all.
Consolidation Group
Use this field to run the process against a consolidation group. If you don't select a value, the process 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 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 element 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.
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.
Use this field to view the element results for an individual employee.
Leave blank to generate the report for all active employees.
Process
Use this field to view element results for a specific process.
-
Balance adjustment
-
Calculate gross earnings
-
Payroll calculation
-
QuickPay
-
Reversal
Totals by Element and Person
After you run the report, view the output in Microsoft Excel. Use its pivot table feature to obtain totals by element and person.
-
Open the Element Results Register in Microsoft Excel.
-
Select the range of cells in the spreadsheet that contain data.
-
Click Pivot Table from the Insert menu.
-
In Create Pivot Table, select New Worksheet. Click OK.
-
Select 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.