Costpoint Online Help

Contents of the Manage ADP 2.5 Mapping Values Screen

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

Identification

Field Description
ADP Map Code
Note:

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.

Include Unposted Timesheets

Select this check box to include timesheets that have not been posted on the Post Timesheets screen when you generate the ADP timesheet file. If you clear this check box, unposted timesheets will not be included in the export file. This setting is only applicable when you run the Export Timesheet Data to ADP process for ADP version 2.5+.

Table Window

Field Description
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.

Note:

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

Field Description
ADP Fields

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

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