Extracting Costs After a Pay Run

After loading payable time into Payroll for North America and running and confirming the payroll calculation process, Payroll for North America initiates the Extract Time and Labor Costs Application Engine process (PY_PULL_COST) to extract cost data that was generated through:

  • On-cycle and off-cycle pay runs.

  • Final check.

  • Online check.

What the Extract Process Does

The Extract process updates the payable time entries in Time and Labor as follows:

  • If the payable time is distributed, but not diluted, the Extract process changes the payable status to Distributed (PD).

  • If the payable time is distributed and diluted, the Extract process changes the status to Diluted (DL).

    Note:

    For time that is not being distributed , the Load Time and Labor process sets the payable time status to Closed (CL).

  • Provides the cross-reference (XREF) numbers generated during the consolidation process, the calculated costs, and percentages that represent how payroll consolidated the payable time rows.

    The system uses percentages when the consolidation process is not clean.

  • Triggers the Labor Distribution and Labor Dilution processes in Time and Labor, if applicable.

  • Sets the publish date and publish switch.

Note:

If Payable Time is pulled into paysheets, and Ok to Pay is cleared for those related earnings, these rows of payable time are not paid.

See Time and Labor Installation Page.

Example: Percentages Returned by the Extract Process

Of a time reporter's total hours, 75 percent are subject to New York state tax and 25 percent are subject to Connecticut state tax. In this case, the consolidation process creates two pay earnings rows for the individual—one for each state. The Extract process would return the percentages along with the resulting costs, so Time and Labor can distribute the costs during the Labor Distribution process.

Distributing and Diluting Costs

Costs are always distributed across payable time for the current period, prior period adjustments, and advance payments. You can view distributed and diluted costs on the Payable Time Detail page in the Time and Labor self service transactions.

If the pay calendar is on-cycle, then on-cycle earnings can only be distributed once; off-cycle earnings can be distributed multiple times. If the Pay Calendar is off-cycle, then its off-cycle earnings can only be distributed once. The system overlays existing labor distribution amounts with new amounts. This iterative processing makes it possible to redistribute earnings after modifying or adjusting pay-related information. Subsequent runs create offsets for existing paid time entries.

If Project Costing is installed, actual payable time entries that are closed, diluted, or distributed are published automatically to Project Costing after running the extract job.

Labor Distribution with Paycheck Reversals

For a discussion of labor distribution and paycheck reversals:

See Publishing Estimated and Actual Cost Data to Project Costing.