Reviewing Prevailing Wage Transactions Information

Access the Prevailing Wage Transactions form.

Employee Number

Displays the number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or location.

Work Date

Displays the date used as the actual work date or pay-period ending date.

Trans. No.

Displays the unique number that is assigned to each timecard.

Check Number

Displays the number used to group all payroll transactions for each payment or individual interim payment. This number is carried into the accounting journal entries and facilitates the update of the actual check number after payment printing is complete.

This number is also used for automatically voiding payments. The payment work table contains both the actual check number and the check control number. All associated payment transactions are automatically reversed using the check control number.

Note: This is not the actual check number.

Payroll ID

Displays the code that identifies a group of employees for whom payroll is being processed. Use the Payroll ID to process each step of the payroll cycle.

This code is also used to identify the interim identifier that you select when you enter interim payments.

Calculation Method

Displays the calculation method used to compute the prevailing wages.

Values are:

WI: If you use the WI (wage invasion) method, the system adds a lump sum timecard to the employee's pay if the employee's actual pay is lower than the prevailing wage. If the employee's actual pay is higher, the system creates a negative lump sum timecard to reduce the employee's pay to an amount not lower than the employee's base hourly rate defined in the Employee Master Information table (F060116).

NW: If you use the NW (non-wage invasion) method, the system adds a lump sum timecard if the employee's actual pay is lower than the prevailing wage.

DB: If you use the DB (Davis-Bacon) method, the system adds a flat dollar one-time override to the DBA Ledger File table (F0709) if the employee's actual pay is lower than the prevailing wage.

FC: If you use the FC (fringe credit) method, the system provides a credit to the employer for the fringe benefits paid to an employee. The system creates a negative lump sum timecard that is equal to the employee's fringe benefit hourly rate multiplied by the timecard hours.

Base Rate

This is the employee's base hourly rate assigned to the timecard record.

Note: If you change the value of the data display decimals for the PHRT or SHRT fields in Time Entry, you must also change the base rate (BHRT) field to have exactly the same data display decimals.

Fringe per Hour

Displays the employee's actual fringe benefit hourly rate calculated based on the existing DBA instructions.

Prevailing Wage Rate

Displays the prevailing wage hourly rate associated with the processed timecard that is retrieved from the Union Rates File table (F069126).

Prevailing Fringe Rate

Displays the prevailing wage fringe rate retrieved from the Union Benefits Master table (F069106). If the Job Fringe Multiplier field is set to 'Y' on the Prevailing Wage DBA Types form, the prevailing wage fringe rate will be further increased by the timecard multiplier.

Difference Per Hour

Displays the difference between the prevailing wage job rate and the employee's total hourly rate, which includes the timecard base rate and the employee's calculated fringe hourly rate.

When comparing fringe amounts only, this amount is the difference between the prevailing wage fringe hourly rate and the employee's fringe hourly rate.

If you use the prevailing wage fringe credit (FC) method, this amount is the employee's calculated fringe hourly rate as a negative value.

Adjustment Amount

Displays the amount paid to the employee due to a difference in the prevailing wage rate and the employee's actual rate.

Adjustment PDBA Code

Displays the PDBA code used to calculate the prevailing wage adjustment. When the adjustment is a lump sum timecard, this value is a valid pay type from the F069116 table. When the adjustment is a flat amount benefit, this value is a valid DBA code from the F069116 table.

Union Code

Displays the user-defined code (UDC) (06/UN) that represents the union or plan in which the employee or group of employees work or participate.

Job Type

Displays the user-defined code (UDC) (07/G) that defines the jobs within the organization. You can associate pay and benefit information with a job type and apply that information to the employees who are linked to that job type.

The value in this field overrides the rates that are set up in the F069126 table if the table is set up by job or business unit.

Job Step

Displays the user-defined code (UDC) (06/GS) that indicates a specific level within a particular job type. The system uses this code in conjunction with the job type to determine pay rates by job in the Pay Rates table.