Contents of the Manage ADP Mapping Values Screen

Use the fields and options to configure the Manage ADP Mapping Values screen.

Identification

Field Description
Map Type

Select the record type from the drop-down list, with Pay Type as the default. The possible choices are:

  • Pay Type: Select this option if the value to be mapped is a Costpoint pay type.
  • Account: Select this option if the value to be mapped is a Costpoint account.
  • Bonus Pay Type: Select this option if the value to be mapped is a bonus payment. Bonuses must be mapped by a Costpoint pay type.
Account or Pay Type

Enter the Costpoint value to be mapped. Accounts must exist in the Account table (the Manage Accounts screen), and pay types must exist in the Pay Type table (the Manage Pay Types screen). Click to query these tables and select values. displays accounts and pay types based on your selection in the Map Type field.

ADP Values

Field Description
Hours Field

Select the ADP field ID for hours from the drop-down list. See the ADP Fields table in the Processing Details section.

Earnings Field ID

Select the ADP field ID for earnings from the drop-down list. See the ADP Fields table in the Processing Details section.

User Code

Enter a single or two-character ADP pay type code. Use values 1 - 79 or A - Z, but not 40, 50, 60, or 61. The User Code must be used with field IDs 016 through 025, but not with regular and overtime entries (field IDs 12 through 15).

Shift Code

Enter a one-digit shift code in this optional field. Use values 1 - 9.

Processing Details

Field Description
ADP Fields

Valid ADP field IDs and their ADP field names are as follows:

Hours Field ID Hours Field Name  Earnings Field ID Earnings Field Name
000 Do Not Send Hours 000 Do Not Send Earnings
012 Regular Hours 014 Regular Earnings
013 Overtime Hours 015 Overtime Earnings
016 Hours 3 020 Earnings 3
017 Hours 3 021 Earnings 3
018 Hours 4 022 Earnings 4
019 Hours 4 023 Earnings 4
024 Earnings 5
025 Earnings 5

Set up special pay types for adjustments that affect only Costpoint by mapping both hours and earnings to an ADP field ID of "000." These fields are not included in the paydata file transferred to ADP.

All timesheet lines that map to a unique combination of employee ID, Hours Field ID, Earnings Field ID, User Code, and Shift Code are rolled up into one record in the external paydata file.