Generating time record totals

Payroll Administrators can generate totals for time record hours, units, and amounts using several aggregation charts.

Before your use this function, you must enable the use of delivered replication sets for payroll.

See Columnar replication sets for payroll.

  1. Sign in as Payroll Administrator.
  2. Select Time Record Processing > Time Record Totals.
  3. Click a tab to view information.
  4. If time record data has changed, click Replicate Time Record Columnar Data to replicate the time record data for updated totals.
  5. Perform a search to retrieve data.
    You can select time records by country, currency, payment schedule, pay frequency, legal entity, organization unit, employee number, employee name, and time record fields. All fields are optional. Subtotals are based on the selected aggregation chart.
  6. Click Amount to view the time records that make up that total.
    Note: If the time record data changed since the last time that the Replicate Time Record Columnar Data action was run, the time records could not match the total. The search form shows the date and time that the time record data was last replicated.
  7. Click Charts and select an option to view time records using that columnar data.
    Option Description
    Totals By Batch Number Aggregate time record data by pay summary group, then batch number.

    This chart is the default chart that is displayed on the Batch tab.
    Totals By Pay Summary Group Aggregate time record data by pay summary group.
    Totals By Legal Entity Aggregate time record data by pay summary group, then legal entity.
    Totals By Employee Aggregate time record data by pay summary group, then employee.
    Totals By Payment Schedule Aggregate time record data by pay summary group, then payment schedule.

    This chart is the default chart that is displayed on the Current Cycle and Future tabs.
    Totals By Payment Schedule and Employee Aggregate time record data by pay summary group, then employee, then payment schedule.
    Totals By Organization Unit Aggregate time record data by pay summary group, then organization unit.
    Totals By Legal Entity And Employee Aggregate time record data by pay summary group, then employee, then legal entity.
    Totals By Organization Unit And Employee Aggregate time record data by pay summary group, then employee, then organization unit.
    Note: 
    • Fifty records are returned at a time on this list. The grand total represents all the data that meets the search criteria.
    • The Totals By Batch Number option is only available on the Batch tab. The remaining options are available on all tabs.