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.