This export is intended to accompany the ADP Payroll Instructions Export. It pulls Comp Worksheet Transaction data that has been tagged as part of a payroll batch and formats it as a comma separated values file (CSV) for input to ADP Payroll. A record will only be reported on once. After it has been processed through the payroll batch process it will be marked as run and will not be pulled on future batches. Previously run batch reports can be viewed on the Compensation Worksheet Payroll Reporting screen found under the Compensation Processing menu.

This Export sums up all amounts for each Wage Code used on the ADP Payroll Instructions Export and prints one Wage Code/Amount Pairing per line.

This export is available at the company and system levels but was designed to be used as part of the Payroll Reporting Batch Process at the company level.

This export has one parameter – PayrollSystemReportBatchItemID. However, it is auto-populated by the payroll reporting process. You will not need to manually enter in this parameter.

CompanyCode

Pay Cycle End Date

EXT_REF_CODE

Amount

CompanyCode:

This field is populated with the value located in the “Name” field found on the General tab of the Payroll System screen.

Pay Cycle End Date:

This field is populated with the End Date as defined by the Payroll System Payroll Calendar date used for the batch.

EXT_REF_CODE:

This is the Primary Wage Code associated with the account the entry has been created under.

Amount:

This is the “Description” field found on the General tab of the Payroll System screen.