Contents of the Cost Pay Labor Code Tables Form

Use the form to specify effective dates for your employees' cost/pay labor code rates.

Header Information

Field	Description
Table Number	Enter a numeric code for the table.
Table Name	Enter a descriptive name to identify the table. For easier identification in lookup lists: Use as general a name as possible. For example, if you define a labor rate table because the project is located in Philadelphia, consider naming the table "Philadelphia" rather than naming it after the project or client. If you maintain both a cost and a pay rate table for the same projects or scenarios, consider including "cost" or "pay" in each table's table name.
Currency	If you use multiple currencies, specify the currency in which a table's rates are displayed. This is typically the currency in which employees are paid at the location for which the table is used. The currency must match the functional currency of the employee's owning organization in order for the table to be available for the employee in the Employees hub.
Rate Type	Select Cost Rate, Pay Rate, or Both from the drop-down list. If Payroll is not installed, you must select Cost Rate. Regardless of the rate type that you enter here, any table defined on this form displays in the Search lookup list.

Labor Code Grid

Field	Description
Drop-down	Click the drop-down arrow on a grid header to complete any of the following actions: To print grid data, click Print. On the Print Preview form, click File > Print to send the grid data to your default printer. To export grid data to an Excel spreadsheet, click Export to Excel. When Microsoft Excel opens, use its features to modify, print, or email the grid data, or to save the spreadsheet file locally. To turn on grouping for a grid, click Enable Grouping. When a field displays with the instruction: "Drag a column header here to group by that column," drag and drop column headers into the field, in the sequence that you want them to display. Not all options are available on all grids.
Insert	Click this option to enter a labor code in a blank row on the grid, below the currently selected row.
Copy	Click this option to copy a selected row directly below its original.
Delete	Click this option to delete a selected row from the table. When you delete a row, it is permanently removed from the database.
Labor Code Mask	Use the lookup to select the labor code. Use a wildcard to select all characters in that labor code level. All of a table's rows must use the same approach, either a labor code or a labor code mask. If you use labor code masks, all of the masks in a table must use a wildcard for the same labor code levels.
Description	Optional. Enter an internal description for the labor code, which will display in cost/pay labor code lists.
Effective Date	Specify the effective date for this labor code cost/pay rate. Each labor code in a table can have one row without an effective date specified. You can use this row to enter a default rate, which is used when no other row has an applicable effective date.
Reg Rate	Enter the cost/pay rate to use for this labor code.
Overtime Percent	Enter the overtime percent cost/pay rate that you want to use for costing/paying overtime labor by employees with this labor code. This field displays if it is enabled for Accounting or Payroll.
Overtime-2 Percent	Enter the secondary overtime percent cost/pay rate that you want to use for costing/paying secondary overtime labor by employees with this labor code. This field displays if it is enabled for Accounting or Payroll.