Costpoint Online Help

Using the Help Search
Using the Help Search
  • Phrase:Returns all topics that contain the exact phrase in the search criteria. Use quotation marks around the phrase.
    Ex."system administration"
  • And:Returns all topics that contain all the words in the search criteria, in any combination. Insert a plus sign between all words in the search criteria.
    Ex.system + administration
  • Or:Returns all topics with any combination of words in the search criteria. This is the default.
    Ex.system administration
For more information:Searching Online Help

Ceridian Mapping Subtask

Use the Ceridian Mapping subtask 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 subtask before exporting timesheet data in the Download Timesheets to Ceridian screen. You must have already set up the Ceridian Configuration ID on the main screen.

The information you enter in this subtask 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 uses the specified mappings to determine the Pay Code and Rate Code values of the timesheet export file.

Table Window

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.

Click to initialize this table.

Field Description
Map Type

From the drop-down list, select the map type. Valid options are:

  • Account
  • Pay Type
Account/Pay Type

Enter, or click 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 application exports 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 application exports the timesheet line to Ceridian with a pay code of 8 and a rate code of E.

Warning:

The labor calculation method for a Costpoint pay type MUST be identical to its equivalent Ceridian pay code and rate code. Differences in calculation methods between Costpoint and Ceridian could result in payroll variances and errors in paycheck calculations.

Account/Pay Type Description

After you enter 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.

Ceridian Pay Code

Enter the Ceridian pay code to be exported for this Costpoint account or pay type.

Ceridian Rate Code

From the drop-down list, select a Ceridian rate code to be exported for this Costpoint account or pay type. Valid options are:

  • E
  • R
  • P

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 is exported to Ceridian.

See your Ceridian documentation for more information on the use of rate codes.

Subtask

Subtask Description
Populate Mapping Table Use the Populate Mapping Table subtask to quickly add a range of Costpoint accounts and/or pay types to the mapping table.