The audit log within SelectHR can be used to identify records that have been, or are due to be, submitted to SelectPay as part of the integration functionality between the two systems.
The following records can be viewed as part of the audit submissions process in both the website and the Administrator Tool:
Submitted to Payroll
Pending Submission to Payroll
Failed Submission to Payroll
You can also use this process to resubmit any failed records after resolving the error message encountered during the initial submission.
The process can be accessed by following these steps.
Under Admin, click Admin.
Click Integration, then click SelectPay Audit Submissions.
Resubmit selected failed audits via the Admin Tool
In the Admin Tool, click Audit Log.
Use the dropdown menu in the top right to select Failed Submissions.
Identify the records you wish to resubmit and highlight them.
🤓 Tip: Use the Ctrl key to select multiple records or the Shift key to select all records between your selection.
Click Resubmit Selected, then confirm by clicking OK.
Resubmit all failed audit records to SelectPay
Under Admin, click Admin, then click Integration.
Click SelectPay Audit Submissions.
If a record has not been sent to SelectPay via integration, click the Failed Submissions tab to review any errors. The error message will provide guidance on the issue. If further assistance is required, raise a new case online and reference this article.
To resubmit all failed records, click Resubmit All. The records will be removed from the Active screen and added to the pending screen.
📌 Note: Records in the Pending Submissions list will transition to the Submitted or Failed listings during the next integration service poll (usually every 15 minutes).
Identify the specific audit number
To identify the required audit numbers, run an export in the Admin Tool for the employee.
Log in to the Admin Tool.
In the Maintenance section, click Import/Export Data.
Click Create an Export Definition, then Select the Data to Export.
Use the Database dropdown and select SelectHR.
Log in.
Copy and paste the following SQL query into the SQL tab of the export:
Select Person.Snapshot.[Person Number], Person.Snapshot.[First Name], Person.Snapshot.Surname, Person.Snapshot.[Payroll Number], Person.Snapshot.[Payroll Name] From Person.Snapshot
In the Query tab, enter the employee's name into the criteria fields.
Click Data and note the employee's Payroll Number.
Copy and paste the following SQL query into the SQL tab again:
Select pr.[Audit Number], pr.[Submitted Date], pr.[Response Date], pr.Error, pr.*, ec.* From PayrollAudit.[Employee Change] ec Left Join PayrollAudit.[Employee Change Request] ecr On ecr.[Employee Change Request Number] = ec.[Employee Change Request Number] Left Join PayrollAudit.[Employee Payroll Request] pr On ecr.[Employee Payroll Request Number] = pr.[Employee Payroll Request Number] Where pr.[Payroll Number] = 'ReplaceWithPayrollNumber' Order By pr.[Submitted Date]
Enter the Payroll Number into the criteria field and click the Data tab.
Note any Audit Numbers and Audit Dates that need to be resubmitted to SelectPay.
📌 Note: These are typically the most recent entries, but you can verify by checking the Audit Date to ensure it aligns with the missing records in SelectPay.
Follow the steps in the Resubmitting audit records to SelectPay section to complete the process.