Pay Export Batch Report

The Pay Export Batch Report displays a summary and detailed breakdown of what has been exported out of the system within a given time period. Select a single batch if you are troubleshooting or select multiple batches if you are looking to get a detailed list of data.

Bullhorn Support is able to assist you with navigating the sample reports but are unable to build customizations on the reports for you. You'll need a Business Intelligence specialist who is familiar with writing database queries.

Report Criteria

Criteria	Definition
Summarize By	Typically this report should be run by Bullhorn Batch. If the payroll system sends back the Payroll Batch as a part of the integration and you are troubleshooting something related to the payroll systems batch then this field can be used instead.
View	Allows you to run the report in a summary view by batch or a detailed output of all transactions related to that batch. This option can be changed after the report is run without changing any other filters if you’d like to see both views.
Search by Batch Run Date	Enter a period and the system will automatically provide batches based on that export batch being created within this time period. Some options include entering the year, year and month or year/month/day. Once the batch(s) are returned, the combination of ctrl + click or shift + click will multi-select batch(s) for the report to be run against.
Search by Accounting Date	This field should be used If it’s preferred to select batches based on payroll export accounting date rather than date of export.
Hide Failed Transactions	This field allows you to display or hide data based on what the reason for running the report is. If the report is being run to troubleshoot what was successful and what failed to make it into the payroll system then displaying failed transactions would be useful. If the report is being run to account for all transactions that have been successfully exported over a given period then failed transactions should be hidden.

Summary Fields

Data Item	Definition
Bullhorn Batch	The Batch assigned to the export. This will either be the Bullhorn Batch or the External Batch from the payroll system.
Date Created	The date the batch was created.
Pay Export Accounting Date	The Accounting Date set at the time of Pay Export.
Number of Candidates	The total count of candidates included within this batch.
Number of Placements	The total count of placements included with this batch.
Number of Transactions	The total count of pay master transactions included with this batch.
Number of Payable Charges	The total count of Payable Charges included with this batch.
Total hours Completed	The total amount of hours that was successfully exported with this batch.
Total Amount Completed	The total dollar amount that was successfully exported with this batch.
Total Hours Failed	The total amount of hours that failed to export with this batch.
Total Amount Failed	The total dollar amount that failed to export with this batch.
Total Hours in Progress	The total amount of hours that is currently exporting or marked as "In Progress".
Total Amount in Progress	The total dollar amount that is currently exporting or marked as "In Progress".

Detail Fields

Data Item	Definition
External Bullhorn Batch ID	The Batch assigned to the export. This will either be the Bullhorn Batch or the External Batch from the payroll system.
Date Created	The date the batch was created.
Pay Master Transaction ID	The ID in Bullhorn associated with this specific Pay Transaction.
Payable Charge ID	The ID in Bullhorn associated with this specific Payable Charge.
Work Date	The date of work associated with this specific Pay Transaction.
Earn Code	The Earn Code associated with this specific Pay Transaction.
Quantity	The Quantity associated with this specific Pay Transaction.
Rate	The Pay Rate associated with this specific Pay Transaction.
Amount	The dollar amount associated with this specific Pay Transaction.
Pay Export Accounting Date	The Accounting Date set at the time of Pay Export for this transaction.
External Pay Export Batch	The external batch from the payroll system associated with this transaction. Not all payroll providers will send this data back to Bullhorn and so this column may always be empty.
Export Status	The status of this specific Pay Transaction as it relates to the export batch.
Candidate ID	The Candidate ID associated with this specific Pay Transaction.
Candidate Name	The Candidate Name associated with this specific Pay Transaction