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 should 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 box, with "Pay Type" as the default. The possible choices are:
Pay Type - Select "Pay Type" if the value to be mapped is a Costpoint pay type.
Account - Select "Account" if the value to be mapped is a Costpoint account.
Bonus Pay Type - Select "Bonus Pay Type" 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 Maintain Accounts screen in Costpoint General Ledger), and pay types must exist in the Pay Type table (the Pay Types screen in Costpoint Labor). Use Lookup to query these tables and select values. Lookup will display accounts and pay types based on your selection in the Map Type field.
Select the ADP field ID for hours from the drop-down box. See the ADP Fields table in the Processing Details section.
Select the ADP field ID for earnings from the drop-down box. 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 will not be 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 will be rolled up into one record in the External Paydata file (see next section).
Account not found in Account Table
The account entered has not been set up in the Account table. Use Lookup to select from a list of available accounts.
Pay Type not found in Pay Type Table
The pay type entered has not been set up in the Pay Type table. Use Lookup to select from a list of available pay types.
User Code may only be used with Field IDs of 016 through 025
You entered a User Code with a field ID that is less than 016. Delete the user code or change the field ID.
Hours and Earnings Field IDs do not match
Field IDs for hours must match those for earnings as follows:
012 corresponds to 014
013 corresponds to 015
016 corresponds to 020
017 corresponds to 021
018 corresponds to 022
019 corresponds to 023.
Any hours ID can be used with an earnings ID of 000, and any earnings ID can be used with an hours ID of 000.
Valid Shift Codes are 1 through 9
You did not enter a numeric Shift Code.
Valid User Codes are 1 - 79, A - Z, but not 40, 50, 60, or 61
You entered an invalid User Code.