How to Export Payroll Data Using the ADP Paydata Extract Transform

The ADP Paydata Extract transform is identified on the Payroll Processing Company and is used in the processing of the Payroll Extract Criteria. The transform defines the output file format used to create a Microsoft ® Excel .CSV file which can then be transmitted to ADP for payroll processing. The output file contains hours and earnings data input via timesheets and labor adjustments for employees for the specified date range.

Prerequisites

The prerequisites required for the ADP Paydata Extract process are:

The BST Global Framework Service should be started
The Transaction Processor service should be started
The Extract Transform and Extract Output Folder properties must be defined on the Payroll Processing Company
The Payroll Processing Company must be identified on the Payroll Company

Create ADP Payroll Extract

To create the ADP Paydata Extract:

Verify that hours exist for employees in the date range for which a Payroll Extract Criteria is to be processed.
Create a new Payroll Extract Criteria document for a Payroll Company associated with a Payroll Processing Company, where the ADP Paydata Extract is defined in the Extract Transform.
Fill in the From Transaction Date and the To Transaction Date range and submit the Payroll Extract Criteria document.
Upon completion of the Payroll Extract Criteria processing, verify that the output file(s) exist in the defined Extract Output Folder location and are named as defined in the Payroll Processing Company.

For an explanation of the construction of data presented in the files, see File Details.

ADP Paydata Extracted File Details

The Payroll Extract Criteria process may create one or two output files if both hourly and salaried employees exist for the specified date range. The output file names will be in the format: EPIxxxyy.csv, where xxx is the 3-character ADP Company code and yy represents the codes SL (Salary) or HR (hourly).

ADP accepts two types of output files - Hours Only or Hours and Earnings.

Hours Only File

The Hours Only output file contains the following columns represented in a single row:

Co Code

Batch

File #

Temp Rate

Regular Hours

O/T Hours

Hours 3 Code

Hours 3 Amount

Hours 4 Code

Hours 4 Amount

The columns descriptions are:

Columns		Description
	Co Code	The Payroll Company Code.
	Batch ID	This is either one (1) or two (2), based on whether the employee is salaried or not.
	File #	The Payroll Employee Code.
	Temp Rate	The empty value.
	Reg Hours	The sum of employee's regular hours.
	O/T Hours	The sum of employee's overtime hours.
	Hours 3 Code	The first payroll earnings code.
	Hours 3 Amount	The number of hours for first payroll earnings code.
	Hours 4 Code	The second payroll earnings code.
	Hours 4 Amount	The number of hours for second payroll earnings code.
	Temp State Code	The state where work performed (optional).
	Temp Worked Local	The location where work performed (optional).

Note: If there are more than two earnings codes, then another row is added for the employee and the next earnings codes will be used in Hours 3 and Hours 3 of the next record.

Hours And Earnings File

The Hours and Earnings output file contains the following columns represented in a single row:

Co Code	Batch ID	File #	Regular Hours	Regular Earnings	O/T Hours	O/T Earnings
Hours 3 Code	Hours 3 Amount	Earnings 3 Code	Earnings 3 Amount
Hours 4 Code	Hours 4 Amount	Earnings 4 Code	Earnings 4 Amount

The ADP File # corresponds to the Employee code found in the Employee document.

Standard cost rates are not passed to the output files. Only hours and earnings information is extracted to the output file. The exception to these conditions is the case where the Temp Rate field is populated based on appropriate rates being selected from a Labor Prevailing Cost Rate Schedule.

The ADP Hours 3 (or 4) Code and Earnings 3 (or 4) Code fields will contain identical values in either form of the extract file and will correspond to ADP Earnings codes established in BST11. The Earnings Code based on the Hours Type must also consider if the time worked was regular or overtime. The Earnings Code based on the Fee Type must consider whether the time worked was regular or overtime. Both Hours Types and Fee Types can be mapped to ADP Earnings Codes. When Hours Types are mapped, all labor hours from timecard rows containing those Hours Types will be summed. When Fee Types are mapped, all labor hours from phases to which the fee types have been assigned will be summed.

Up to two ADP Hours / Earnings - 3/4 codes can be included in a row. If more than two exist for the employee, a new row will be written that does not contain any Regular hours or earnings nor any O/T hours or earnings.