Hourly Rate Functions for Overtime Accumulator Rules
The hourly rate functions for overtime accumulator rules are included in the Overtime Hourly Rate Functions module (N1861411). These functions use data structure D186141. You also use this data structure when you create a custom hourly rate function for overtime accumulator rules. This table lists examples of input and output information about the data items in this data structure:
Data Item |
Additional Information |
---|---|
LRSORSID |
Input: Overtime Rule Set ID |
LRSORID |
Input: Overtime Rule ID |
AN8 |
Input: Address Number (Employee Number) |
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 |
DWK |
Input: Date - Worked |
EV01 |
Input: EverestEventPoint01 |
GENLNG |
Input: GenericLong |
The predefined hourly rate functions for overtime accumulator rules are:
OHRF_EmployeeMasterRate
The Employee Master Rate function returns the hourly rate from the Rate-Hourly field (PHRT) in the F060116 table for the employee that the system is processing using the overtime rule set. For example, you might want to pay employees overtime pay based on the master hourly pay rate.
OHRF_HoursWorked
The Hours Worked on Timecard function returns the hours worked from the PHRW field on the current timecard that the system is processing using the overtime rule set. For example, you might want to pay employees overtime pay based on the hours worked on the current timecards.
OHRF_MaxRate
The Maximum Rate from Timecard vs. Employee Master function returns the greater rate of the timecard hourly rate from the Hourly Rate field (SHRT) or the hourly rate in the Rate-Hourly field (PHRT) in the Employee Master table. For example, you might want to pay employees overtime pay based on either the master hourly pay rate or the timecard hourly rate. This function provides the higher of these two hourly rates.
OHRF_PayFrequency
The Employee Master Pay Frequency function returns an employee's numeric pay frequency (which is derived from the Description 2 field in UDC 07/PF) based on the value in the PFRQ field (Pay Frequency) on an employee record. For example, this function would convert a value of W (Weekly) in the PFRQ field to the numeric value of 52, which can then be used in payroll calculations.
OHRF_PayRateMultiplier
The Pay Rate Multiplier function returns the pay rate multiplier from the Multiplier-Pay Type Multiplier field (PAYM) on the current timecard that the system is processing using the overtime rule set.
OHRF_Salary
The Employee Master Salary function returns the employee's salary from Rate-Salary, Annual field (SAL) on an employee record for the employee being processed by the overtime rule. For example, you might want to pay employees overtime pay based on the master salary.
OHRF_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 overtime rule set. For example, you might want to pay employees overtime pay based on the rate on the timecard instead of another rate.
OHRF_TotHoursWorked
The Total Hours Worked function returns the total hours worked by a given employee within the overtime period for a pay type of one of the pay types that you identify. For example, you might want to pay employees overtime pay based on the total hours that each employee worked.
OHRF_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 Union Rates File table (F069126), where you identify the appropriate column. This function returns the union rate by calling the Retrieve Union Rates function (N0500015) using fields on the current timecard that the system is processing using the overtime rule set. For example, you might want to pay employees overtime pay based on a particular union rate. This function provides you with the appropriate union rate.
OHRF_WeightedAverageHourlyRate
The Weighted Average of Employees' Regular Timecards in Overtime Period function returns an hourly rate weighted by hours worked. The function uses all timecards in the overtime period for a pay type of one of the pay types that you identify. For example, you might want to pay employees overtime pay based on an average of the hourly pay rates received in the past.