Set Up Payroll Custom Dimensions to Improve Performance

Sparkrock 365 includes functionality to improve performance when sending compensation data from Sparkrock 365 to Primo Payday.

To improve performance, you must perform the following high level steps:

  1. Set up a payroll custom dimension which informs Sparkrock 365 to automatically populate the Compensation Journal ID field when you load data into the compensation journal.

  2. Filter by the Compensation Journal ID field to reduce the amount of hours detail information that is sent to Primo Payday.

Set up a payroll custom dimension

To filter the amount of hours detail information that is sent to Primo Payday, you must first set up a payroll custom dimension.

To set up payroll custom dimension

  1. Choose Lightbulb that opens the Tell Me feature., enter payroll setup, and then choose the related link.

    The Payroll Setup page opens.

  2. On the Payroll Custom Dimensions FastTab, perform the following steps:

    1. In Custom Payroll Dimension 2 Code, specify a code to represent custom payroll dimension 2, for example, COMP. JOURNAL ID.
      Alternatively, you can perform this setup on custom dimensions 3 or 4.
    2. In Custom Dim. 2 Validation Table ID, specify 23068648.
      The Object ID of 23068648 represents the Compensation Journal Line table.
    3. In Custom Dim. 2 Validation Field ID, specify 23068816.
      The No. of 23068816 represents the Compensation Journal ID field.
    4. In Filter Hours Detail by:, specify Custom Dim. 2.
      This filters all of the hours detail information that is sent to Primo Payday, based on the custom dimension validation table and field IDs that you specified, for example, 23068648 and 23068816.

Compensation Journal ID field

After you set up a payroll custom dimension, when you load lines on the Compensation Journal page, Sparkrock 365 automatically populates a Compensation Journal ID field. The Compensation Journal ID field is hidden. The value of the Compensation Journal ID field is a concatenated value that is based on the value of Batch Name, the HR pay cycle Code and the HR pay cycle Starting Date.

Filter by the value of the Compensation Journal ID field when sending hours detail information to Primo Payday

On the Create Batch Payroll Processing page, you can filter by the value of the Compensation Journal ID field. This filter reduces the amount of hours detail information that is sent to Primo Payday.

To filter by the value of the Compensation Journal ID field when sending hours detail information to Primo Payday

  1. Choose Lightbulb that opens the Tell Me feature., enter compensation journal, and then choose the related link.

    The Compensation Journal page opens.

  2. Specify details in fields as required and load lines as per your normal process.

    For more information, see Compensation Journal.

  3. On the action bar, choose Payroll > Send to Payroll.

    The Send Compensation Journal to Payroll page opens.

  4. Turn on Create New Payroll Batch, specify values for other fields as required, and then choose OK.

    The Create Batch Payroll Processing page opens.

  5. In Custom Dimension Filter, specify the value for which you want to filter the hours detail information that you want to send to Primo Payday.

  6. Specify values for other fields as required, and then choose OK.

See also

Set Up Payroll Administration

Feedback

To send feedback about this page, select the following link:

feedback-product-docs@sparkrock.com