Use this screen to establish the link between Costpoint pay types and accounts entered on timesheets and the Ceridian pay code and rate code to be used when exporting timesheet data.
Enter information in this screen before exporting timesheet data in the Download Timesheets to Ceridian screen. You should have already set up the Ceridian Configuration ID in the Maintain Ceridian Configuration screen.
The information you enter in this screen defines the mapping of Costpoint pay types and/or accounts to Ceridian pay codes and rate codes. Depending on the pay types and/or accounts on the timesheet, the Download Timesheets to Ceridian process will use the specified mappings to determine the Pay Code and Rate Code values of the timesheet export file.
Required. Enter, or use Lookup to select, the Ceridian Configuration ID to which the Account and/or Pay Type mappings apply.
When you enter an ID in the Ceridian Configuration ID field, these fields display the information entered in the Maintain Ceridian Configuration screen.
Every line entered on a Costpoint timesheet has a pay type and account associated with it. Either the three-character pay type or the 15-character account must be mapped to a two-character Ceridian pay code and a one-character rate code before a timesheet line can be exported by the interface. This table defines the translation matrix between Costpoint pay types/accounts and Ceridian pay codes and rate codes.
You must select the New Line button on the toolbar to initialize this table.
Required. From the drop-down list, select either "Account" or "Pay Type."
Required. Enter, or use Lookup to select, the Costpoint account or pay type to be mapped
When a timesheet is exported to Ceridian, the application examines each timesheet line by account and pay type. If a timesheet line has a Costpoint account value that is in this mapping table, the application exports the Ceridian pay code and rate code to which the account is mapped. If the account is not found in the mapping table, the Costpoint pay type is found in this table and exports the Ceridian pay code and rate code to which the pay type is mapped.
In this table, you must link each Costpoint pay type to be used in timesheet entry to its Ceridian pay code/rate code equivalents, whereas you must link accounts to Ceridian codes only when they are to explicitly override the pay type entered on a timesheet line.
For example, suppose that you link Costpoint pay type "OS2" to Ceridian pay code "OT" and rate code "P" in this table, while Costpoint account "02000-001" is linked to Ceridian pay code "8" and rate code "E." If a timesheet line was entered with an account of "04000" and a pay type of "OS2," the system will export it with a Ceridian pay code of "OT" and a rate code of "P" because account "04000" does not appear in the mapping table, and pay type "OS2" does.
Now suppose that the same timesheet line was entered with an account of "02000-001" and a pay type of "OS2." Even though pay type "OS2" is in the mapping table, its Ceridian equivalent is overridden because account "02000-001" is in the mapping table, and accounts take precedence over pay types. The system exports the timesheet line to Ceridian with a pay code of "8" and a rate code of "E."
After you have entered the Costpoint account or pay type in the Account/Pay Type column, the appropriate account name or pay type description displays in this non-editable column.
Required. Enter up to two characters for the Ceridian pay code to be exported for this Costpoint account or pay type.
Required. From the drop-down list, select a Ceridian rate code of "E," "P," or "R" to be exported for this Costpoint account or pay type.
Your selection in this column determines how labor costs are exported by the Ceridian Timesheet Interface. If a timesheet line is exported with a rate code of "E," the calculated labor cost amount for that timesheet line is exported to Ceridian.
If the rate code for a timesheet line is either "P" or "R," the base hourly rate for the timesheet line will be exported to Ceridian.
See your Ceridian documentation for more information on the use of rate codes.
Use this pushbutton to open the Populate Mapping Table subtask. You can access this subtask at any time to quickly add rows to the mapping table for a range of Costpoint accounts and/or pay types.