Use this screen to establish fringe rates (amount and method) and base pay rates (wage override amount and method). If you selected the Enable Wage Determination Feature and Require Labor Location on Timesheet checkboxes in the Labor Settings screen, this screen becomes available for use and can be filled out to meet your specific requirements, although it is not required. Use this screen only if you want to override the hourly pay amount of an employee in the Salary Info and History screen in Costpoint Employee or to establish fringe amounts per hour and related handling methods. The combinations of key codes entered on the timesheet line are in Lookup for this screen. If a record is found, the Base Rate for that record can be used in the labor cost calculation for that timesheet line, depending on the Hourly Rate Method associated with the Base Rate. A similar situation exists for the Fringe Amount per Hour and the associated Payment Method.
If you did not select the Enable Wage Determination Feature checkbox in the Labor Settings screen, all Wage Determination (WD) rate and WD Fringe Handling processing is inactive.
Initialize this screen after you select the Enable Wage Determination Feature checkbox in the Labor Settings screen and before you enter any timesheets using the Wage Determination Rate.
Use this field to specify the start or effective date for this record in the Wage Determination (WD) Rate table. The program compares the timesheet date to this Effective Date to determine whether the record should be accessed. If there are several records with effective dates with the same combination of key fields, the record with the Effective Date closest to the timesheet date and not later than the timesheet date will be accessed. Delete the override record to prevent its use or to stop a specific override.
Use the Effective Date to enter the WD rate record before it is used by the Enter Timesheets screen. The system format for date is MM/DD/YYYY. This is a required field.
This group box contains a field for the project associated with this WD rate and a checkbox to apply the rate to lower levels of the project.
Use this field to specify a project number, or the initial level of a project number. To designate a WD rate record for a specific project, enter, or use Lookup to select, that specific project number, up to 30 characters, including the delimiters. The non-editable field to the right displays the project name for the project you have entered. This is a required field.
Select this checkbox to apply the WD rate to lower levels of the project. You do not have to enter each level for a project; if there is one level of a project that has different rates that need to be applied, you can still enter the project number at that specific level.
Enter, or use Lookup to select, the labor location or local (code) to which this record applies. This is one of the key fields; different WD rate records can be established for different labor locations or locals. This is useful if your wage rates are determined by geographical location. This is a required field. There is also a display field to the right for the labor location or local description.
Enter, or use Lookup to select, the general labor category (code) to which this record applies. This is one of the key fields; therefore, different records can be established for different general labor categories. This is useful if your wage rates are determined by labor category, which is normally the case for wage determination rates. This is a required field. There is also a display field to the right for the Labor Category description.
Enter, or use Lookup to select, the three-character alphanumeric code which is the labor group or union code. This is one of the key fields; therefore, different wage determination rate records can be established for different labor groups or unions. This is useful if your wage rates are determined by labor groups or unions, which is normally the case for Union/Collective Bargaining Agreements. This is a required field. There is also a display field to the right for the Labor Group/Union description.
This numeric field displays the amount of pay per hour for this wage determination rate record. It relates to the fields defined above for the unique combination of Project, Labor Location/Local, Labor Category, and Labor Group/Union. The project, labor location/local, and labor category are part of the timesheet, and you can assign the labor group/union to each employee in the Salary Info and History screen in Costpoint Employee. You can use this Rate per Hour to calculate the timesheet line labor cost, depending on your selection in the Hourly Rate Method group box. This is a required field.
Use the radio buttons in this group box to determine the handling of the specified Rate per Hour.
Select this radio button to use the associated Rate per Hour in calculating the labor cost on the timesheet (i.e., hours on the timesheet times the rate per hour from the override record).
Select this radio button to compare the hourly rate contained in the Salary Info and History screen for the employee (employee's rate) to rate per hour in the override record. If the override record rate per hour is higher than the employee's rate, the override rate is used. If not, the employee's rate is used to calculate labor cost. The calculation is: hours on the timesheet times the greater of: 1) the override record rate per hour, or 2) the employee's rate.
Use the fields in this group box to enter the fringe amount per hour and a separate group box to select the payment method.
Use this field to specify a "fringe" amount per hour associated with this WD rate record, i.e., the combination of Project, Labor Location/Local, Labor Group/Union, and Labor Category. The amount specified is an amount per hour, in addition to the base rate above. You can use this fringe Amount per Hour to calculate the labor cost, depending on your selection in the Payment Method group box. This is a required field.
Use this group box to determine the handling of the Fringe Amount per Hour.
Select this radio button to use the fringe amount in the calculation of the associated labor cost. The system automatically generates a separate timesheet line to record this fringe amount, separate from the timesheet line recording the base labor cost. The settings in the WD Fringe Handling screen specify the codes for the timesheet line that will be generated (project, account, pay type and organization to use).
Select this radio button to omit labor cost impact on the timesheet line. This means that the fringe amount is in this record only for analysis purposes.
Changes to this screen update the following tables:
Wage Determination Rates - WAGE_DETERM
Billable Labor Categories - BILL_LAB_CAT
General Labor Categories - GENL_LAB_CAT
Labor Group/ Union - LAB_GRP
Labor Location/ Local - LAB_LOCATION
Labor Settings - LAB_SETTINGS
Projects - PROJ
Projects Government Contractors - PROJ_GOVT_CONTR