Add Payroll Hours (Legal Entity Paygrid) - Paycor Data Target
Overview
DataBlend supports importing payroll hours at the legal entity level in Paycor using the Add Payroll Hours (Legal Entity Paygrid) data target action. This action submits a paygrid import request to Paycor, grouping rows that share the same legalEntityId and processId into a single import request.
Query Configuration
| DataBlend Query Field Example | Paycor Object (API) | Required / Optional | Notes |
| 1234 | legalEntityId | Required | The Paycor legal entity ID. Rows sharing the same legalEntityId and processId are grouped into a single paygrid import request. |
| true | replaceData | Optional | When set to true, replaces existing paygrid data for the legal entity and process with the submitted data. |
| false | appendData | Optional | When set to true, appends the submitted data to existing paygrid data rather than replacing it. |
| A1B2C3D4-E5F6-7890-ABCD-EF1234567890 | processId | Optional | Identifies the paygrid import process. Rows sharing the same legalEntityId and processId become one import request. |
| Datablend | IntegrationVendor | Optional | Identifies the integration vendor submitting the data. Defaults to DataBlend if left blank. |
| EMP001 | EmployeeNumber | Optional | The employee's number in Paycor. Used to identify the employee within the paygrid. |
| DEPT001 | BaseDepartmentCode | Optional | The employee's base department code. |
| DEPT001 | DepartmentCode | Optional | The department code to associate with the payroll hours entry. |
| REGOPER | EarningCode | Optional | The earning code identifying the type of pay for this hours entry. |
| 40 | EarningHours | Optional | The number of hours to record for this earning entry. |
| 500.00 | EarningAmount | Optional | The dollar amount to record for this earning entry. Use EarningAmount or EarningRate — not both. |
| 25.00 | EarningRate | Optional | The hourly rate for this earning entry. Use EarningRate or EarningAmount — not both. |
| 2026-09-15T00:00:00Z | BusinessStartDate | Optional | The start date of the pay period for this entry. |
| 2026-09-21T00:00:00Z | BusinessEndDate | Optional | The end date of the pay period for this entry. |
| 2026-09-15T00:00:00Z | DateWorked | Optional | The specific date the hours were worked. |
| PG001 | PayGroupId | Optional | The Paycor pay group ID to associate with this entry. |
| 1 | PayNumber | Optional | The pay number for this entry within the pay group. |
| CustomValue | ClientDefinedValue | Optional | A client-defined value for custom tracking or reporting purposes. |
| Department|Project | Category | Optional | Labor code category. Multiple values can be supplied as a pipe-delimited list (e.g. Department|Project). |
| DEPT001|PROJ001 | Code | Optional | Labor code value. Multiple values can be supplied as a pipe-delimited list, corresponding to the Category values in the same row. |
For more information about Paycor payroll API requirements, please visit the Paycor Developer Portal.