to query these tables and select values. displays accounts and pay types based on your selection in the Map Type field.Use this screen to enter mapping information that matches Deltek Costpoint pay types and accounts with ADP field IDs. Each pay type used in Costpoint must have a mapping entry to specify the proper ADP field ID for both hours and earnings. For Costpoint accounts that must be broken out separately for ADP, such as vacation or sick leave, you can create a mapping entry for a specific account.
You must set up all accounts and pay types in the appropriate Costpoint screen before adding them to the ADP mappings.
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.
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.
Select the ADP field ID for hours from the drop-down list. See the ADP Fields table in the Processing Details section.
Select the ADP field ID for earnings from the drop-down list. See the ADP Fields table in the Processing Details section.
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).
Enter a one-digit shift code in this optional field. Use values 1 - 9.
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.