Costpoint Online Help

Using the Help Search
Using the Help Search
  • Phrase:Returns all topics that contain the exact phrase in the search criteria. Use quotation marks around the phrase.
    Ex."system administration"
  • And:Returns all topics that contain all the words in the search criteria, in any combination. Insert a plus sign between all words in the search criteria.
    Ex.system + administration
  • Or:Returns all topics with any combination of words in the search criteria. This is the default.
    Ex.system administration
For more information:Searching Online Help

Export Format

Before you can use the ADP Interface, you must specify the format of the exported payroll file: either the standard ADP format or the ADPRATE format.

When you execute the export process, Time and Expense exports payroll data to worktables. Then it reads the ExportTimesheets.properties file on the server to determine the final format of the export.

One of the parameters in the ExportTimesheets.properties file is PAYROLL=. You must supply one of the following values:

  • PAYROLL=NONE — The exported payroll file is not transformed.
  • PAYROLL=ADP — The exported payroll file is transformed using the standard ADP format.
  • PAYROLL=ADPRATE — The exported payroll file is transformed using the ADPRATE format. This format contains all the columns of the standard layout and also includes a temporary rate that overrides ADP's rate for the employee.

ADP Format

When you use the ADP format, the values in the ADP fields come from the following sources.

ADP Field Source
Co Code Payroll ID on the Manage Resource Information screen.
Batch ID Batch ID on the Export Timesheets screen.
File # Payroll Employee ID on the Manage Resource Information screen.
Reg Hours Sum of the hours charged to the pay type that has a Payroll Map Code of Regular.
Reg Earnings Not implemented.
OT Hours Sum of the hours charged to the pay type that has a Payroll Map Code of Overtime.
OT Earnings Not implemented.
Earnings 3 Code Payroll Earnings Code from the pay type that has a Payroll Map Code of Earnings 3.
Earnings 3 Amount Not implemented.
Earnings 4 Code Payroll Earnings Code from the pay type that has a Payroll Map Code of Earnings 4.
Earnings 4 Amount Not implemented.
Earnings 5 Code Payroll Earnings Code from the pay type that has a Payroll Map Code of Earnings 5.
Earnings 5 Amount Not implemented.
Hours 3 Code Payroll Earnings Code from the pay type that has a Payroll Map Code of Hours 3.
Hours 3 Amount Sum of the hours charged to the pay type that has a Payroll Map Code of Hours 3.
Hours 4 Code Payroll Earnings Code from the pay type that has a Payroll Map Code of Hours 4.
Hours 4 Amount Sum of the hours charged to the pay type that has a Payroll Map Code of Hours 4.

ADPRATE Format

When you use the ADPRATE format, the values in the ADP fields come from the following sources.

ADP Field Source
Co Code Payroll ID on the Manage Resource Information screen.
Batch ID Batch ID on the Export Timesheets screen.
File # Payroll Employee ID on the Manage Resource Information screen.
Reg Hours Sum of the hours charged to the pay type that has a Payroll Map Code of Regular.
Reg Earnings Not implemented.
OT Hours Sum of the hours charged to the pay type that has a Payroll Map Code of Overtime.
OT Earnings Not implemented.
Earnings 3 Code Payroll Earnings Code from the pay type that has a Payroll Map Code of Earnings 3.
Earnings 3 Amount Not implemented.
Earnings 4 Code Payroll Earnings Code from the pay type that has a Payroll Map Code of Earnings 4.
Earnings 4 Amount Not implemented.
Earnings 5 Code Payroll Earnings Code from the pay type that has a Payroll Map Code of Earnings 5.
Earnings 5 Amount Not implemented.
Hours 3 Code Payroll Earnings Code from the pay type that has a Payroll Map Code of Hours 3.
Hours 3 Amount Sum of the hours charged to the pay type that has a Payroll Map Code of Hours 3.
Hours 4 Code Payroll Earnings Code from the pay type that has a Payroll Map Code of Hours 4.
Hours 4 Amount Sum of the hours charged to the pay type that has a Payroll Map Code of Hours 4.
Temp Rate Sum of the Amount divided by the sum of Hours. Based on User-Defined Rate 1.