Hourly Rate Functions for Retroactive Pay Rules

The hourly rate functions for retroactive pay rules are included in the Retropay Hourly Rate Functions module (N1861711). These functions use data structure D186171. You also use this data structure when you create a custom hourly rate function for retroactive pay rules. This table lists examples of input and output information about the data items in this data structure:

Data Item

Additional Information

LRSRRID

Input: Retroactive Pay Rule ID

PRTR

Input: Payroll Transaction No

LRSCHF

Input: Current/History option. This option indicates whether the payroll transaction number refers to a current timecard in F06116 or a historical timecard in F0618.

SHRT

Output: Hourly Rate

AN8

Input: Address Number (Employee Number)

DWK

Input: Date - Worked

PDBA

Input: PayDeductBenAccType

The predefined hourly rate functions for retroactive pay rules are:

  • RHRF_EmployeeMasterRate

    The Employee Master Rate function returns the rate from the Rate-Hourly field in the F060116 table for the employee on the current timecard that the system is processing using the retroactive pay rule. For example, you might want to pay employees retroactive pay based on the master hourly pay rate.

  • RHRF_MaxRate

    The Maximum Rate from Timecard vs. Employee Master function returns the greater rate of the timecard hourly rate from the Hourly Rate field or the employee master hourly rate from the Rate-Hourly field. For example, you might want to pay employees retroactive pay based on either the master hourly pay rate or the timecard hourly rate. This function provides the larger of these two hourly rates.

  • RHRF_PayRateMultiplier

    The Pay Rate Multiplier function returns the pay rate multiplier from the Multiplier-Pay Type Multiplier field on the current timecard that the system is processing using the retroactive pay rule.

  • RHRF_TimecardRate

    The Timecard Rate function returns the hourly rate from the Hourly Rate field on the current timecard that the system is processing using the retroactive pay rule. For example, you might want to pay employees retroactive pay based on the rate on the timecard instead of another rate.

  • RHRF_UnionRateX where X is A, B, C, D, or R

    The Union Rate X function returns the rate for a chosen employee from a particular column of the F069126 table. You identify the appropriate column. This function returns the union rate by calling the Retrieve Union Rates function (N0500015) and using fields on the current timecard that the system is processing in the retroactive pay rule. For example, you might want to pay employees retroactive pay based on a particular union rate. This function provides you with the appropriate union rate.

  • RHRF_WeightedAverageHourlyRate

    The Weighted Average of Employees' Timecards in Retroactive Pay Period function returns an hourly rate weighted by hours worked. The function uses all timecards in the overtime period for one of the pay types that you identify. For example, you might want to pay employees retroactive pay based on an average of the hourly pay rates received in the past.