MANAGE ADP 2.5 MAPPING VALUES

Use this screen to map Deltek Costpoint pay types and accounts to field IDs in ADP for Windows versions 2.5, 3.1, 4.0, 4.5, 5.0, or 5.1. You must set up all accounts and pay types in the appropriate Costpoint screens before adding them to the ADP 2.5 mappings.

Location

Identification

ADP Map Code

You can use this field with the Use Expanded Fields check box to enable expanded fields for certain locations and not for others. For example, if your office is in an area where use of expanded fields is allowed by ADP, select a Map Code that has the Use Expanded Fields check box selected when you execute the Export Timesheets to ADP Transfer screen.

Enter a maximum of three characters for an ADP map code.

ADP Map Description

Enter a maximum of 30 characters to describe your ADP Map Code.

Use Expanded Fields

Select this check box to use expanded fields in the ADP paydata file generated by Costpoint. If you select this check box, you can enter a three-character value in the ADP Hours Code and ADP Earnings Code fields.

Table Window

Map Type

From the drop-down list, select the type of value to be mapped. Valid options 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.

Costpoint Source Pay Type

Enter, or click to select, the pay type to be mapped. The pay type must exist in the Pay Type table (the Manage Pay Types screen).

Costpoint Source Description/Name

The pay type description defaults into this field when you enter the Costpoint Source Pay Type code.

Costpoint Source Account

Enter, or click to select, the account to be mapped. The account must exist in the Account table (the Manage Accounts screen).

Costpoint Source Description/Name

The account description defaults into this field when you enter the Costpoint Source Account code.

ADP Hours Type

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

• None

• Reg Hours

• O/T Hours

• Hours 3 Code

• Hours 4 Code

See the ADP Fields table in the Processing Details section.

ADP Hours Code

Specify the ADP hours code that applies to the selected ADP Hours Type. This field is available only if the ADP Hours Type is set to Hours 3 Code or Hours 4 Code.

ADP Earnings Type

From the drop-down list, select an ADP earnings type. Valid options are:

• None

• Reg Earnings

• O/T Earnings

• Earnings 3 Code

• Earnings 4 Code

• Earnings 5 Code

See the ADP Fields table in the Processing Details section.

ADP Earnings Code

Specify the ADP earnings code, which applies to the selected ADP Earnings Type. This field is available only if the ADP Earnings Type is set to Earnings 3 Code, Earnings 4 Code, or Earnings 5 Code.

Shift Code

Enter a one-digit shift code in this optional field. You can use values 1 through 9.

Tax Frequency

Enter the one-digit ADP tax frequency code that applies to the ADP Hours Type and ADP Earnings Type. When you export the pay type or account in the Export Timesheets to ADP application, the corresponding tax frequency is also exported. You can use values 0 through 9, S, M, D, T, B, F or H.  This is an optional field.

This value cannot be D or F if any of the quantitative fields in the import file are greater than 99,999.99 (or 99,999,999.99, if you are using expanded fields) or less than -40,500.00. Quantitative fields are all fields that have the same valid values as the Reg Earnings field, such as the Reg Earnings, O/T Earnings, and Earnings 3 Amount fields. The ADP Timesheet Transfer process generates an error if this scenario occurs.

Processing Details

ADP Fields

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

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, ADP Hours Type ID, ADP Earnings Type ID, and Shift Code are rolled up into one record in the external paydata file.

• Table Information

  Changes to this screen update the following tables:

  • X_ADP_MAP_25_HDR

  • X_ADP_MAP_25