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:

1. From My Client Groups, click Payroll.

2. Click Submit a Flow.

3. Select your US legislative data group.

4. 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.

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

Person Name

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.

1. Open the Element Results Register in Microsoft Excel.

2. Select the range of cells in the spreadsheet that contain data.

3. Click Pivot Table from the Insert menu.

4. In Create Pivot Table, select New Worksheet. Click OK.

5. Select these fields from the Pivot Table Field list.

   • Person Name

   • Payroll Statutory Unit

   • Tax Reporting Unit

   • Payroll

   • Run Type

   • Element Name

   • Value

6. 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

7. Refresh the page to display the populated columns and rows, and the summed totals.

8. Filter to view different results.