With the Access Payroll Extract plugin, as a PeopleHR administrator, you can export specific queries on the total number of hours an employee has worked and upload them easily in Access Payroll.
Query 1
Create your first query with the exact name Payrol: Assignments and the Assignment area with Task, Assignment End Time, Assignment Date, Detail, Assignment Total Hours, Project and Assignment Start Time fields. Skip the filters.
Query 2
Create your second query with the exact name Payrol: Timesheets and the Timesheet area with Timesheet Date, Time in 1, Time Out 1, Time in 2, Time Out 2, Time in 3, Time Out in 3. Feel free to select more options. Skip the filters.
Run the Access Payroll Extract plugin
To run the Access Payroll Extract plugin, follow the steps below:
Create an API key that includes the Employee and Query endpoints. You can select the two queries you created.
In PeopleHR, click Plugins then click New Requests.
Click Access Payroll Extract.
Enter the API Key.
Enter the Payroll Start and End date. With these days, you specify which assignment or timesheet details to pull from the query, based on the Assignment/Timesheet date.
Click Submit .
Once you create a new request, allow up to two minutes to view this in Requests.
To download any file attached to the request, click Download.
To repeat the same request, click Repeat.
If your request failed for any reason, to view the error details, click the log icon
.