Import Employee Time Punches into Paylocity Time & Labor
Field Mapping/Descriptions
| API Field Name | Description |
|---|---|
| employeeId | Required field. The employee's employee ID. |
| lastName | Employee's Last Name. NOTE: This is just for reference and will not be imported into the system. |
| firstName | Employee's First Name. NOTE: This is just for reference and will not be imported into the system. |
| date | Required field. Punch Date - Use format MM/DD/YYYY |
| time | Required field. Punch Time - Use 12 Hr Format or 24 Hr Format. In addition to Work times, time is also required for Durations/Dollars/Units entries like PTO, Sick, Bonus, and Mileage. Use 12:00 AM if no actual time is present. |
| recordType | Required field. In, Out, Transfer, EndLunch, StartLunch, EndBreak, StartBreak. These can be defined on the client level as well. |
| hoursDollars | Total Pay Type Duration or Total Adjustment Amount. This should only be used when importing Duration/Dollars/Units based entries like PTO, Sick, Bonus, Mileage, etc. This field should be left blank for punches. |
| EmployeeNote | Employee note associated with punch, pay type, or adjustment transaction |
| supervisorNote | Supervisor note associated with punch, pay type, or adjustment transaction |
| Paylevel | Pay level the hours are calculated towards. If left blank, the pay level will be calculated in Time & Labor based on the employee's payroll rules. |
| CC1 | Override Value for Cost Center 1. Leave blank for the employee's default Cost Center. |
| CC2 | Override Value for Cost Center 2. Leave blank for the employee's default Cost Center. |
| CC3 | Override Value for Cost Center 3. Leave blank for the employee's default Cost Center. |
| CC4 | Override Value for Cost Center 4. Leave blank for the employee's default Cost Center. |
| CC5 | Override Value for Cost Center 5. Leave blank for the employee's default Cost Center. |
| CC6 | Override Value for Cost Center 6. Leave blank for the employee's default Cost Center. |
| CC7 | Override Value for Cost Center 7. Leave blank for the employee's default Cost Center. |
| CC8 | Override Value for Cost Center 8. Leave blank for the employee's default Cost Center. |
| CC9 | Override Value for Cost Center 9. Leave blank for the employee's default Cost Center. |
| CC10 | Override Value for Cost Center 10. Leave blank for the employee's default Cost Center. |
| CC11 | Override Value for Cost Center 11. Leave blank for the employee's default Cost Center. |
| CC12 | Override Value for Cost Center 12. Leave blank for the employee's default Cost Center. |
| CC13 | Override Value for Cost Center 13. Leave blank for the employee's default Cost Center. |
| CC14 | Override Value for Cost Center 14. Leave blank for the employee's default Cost Center. |
| CC15 | Override Value for Cost Center 15. Leave blank for the employee's default Cost Center. |