Release Notes
April 2026
Effective April 15, 2026 we use a new April 2026 schema. Review the latest ERD to better understand the schema changes.You should review the changes and update your downstream queries if necessary. Failing to do so may lead to missing or incomplete data in your data pipelines.
We are updating the connector schema to enhance its usability.
22 total changes • 22 possible breaking changes
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
EMPLOYEE | |||||
| column | Primary Key Change | company_id 🔑 | Added to primary key. | ||
EMPLOYEE_DEDUCTION | |||||
| column | Primary Key Change | company_id 🔑 | Added to primary key. | ||
EMPLOYEE_DEDUCTION_COST_CENTER | |||||
| column | Primary Key Change | company_id 🔑 | Added to primary key. | ||
EMPLOYEE_EARNING | |||||
| column | Primary Key Change | company_id 🔑 | Added to primary key. | ||
EMPLOYEE_EARNING_COST_CENTER | |||||
| column | Primary Key Change | company_id 🔑 | Added to primary key. | ||
EMPLOYEE_FUTURE_PAY_RATE | |||||
| column | Primary Key Change | company_id 🔑 | Added to primary key. | ||
EMPLOYEE_POSITION_FAMILY | |||||
| column | Primary Key Change | company_id 🔑 | Added to primary key. | ||
EMPLOYEE_PUNCH_DETAIL | |||||
| column | Primary Key Change | company_id 🔑 | Added to primary key. | ||
EMPLOYEE_PUNCH_DETAILS_SEGMENT | |||||
| column | Primary Key Change | date 🔑 | date | No longer a primary key. | |
| column | Primary Key Change | punch_type 🔑 | punch_type | No longer a primary key. | |
| column | Primary Key Change | company_id 🔑 | Added to primary key. | ||
| column | Primary Key Change | employee_punch_relative_end 🔑 | Added to primary key. | ||
| column | Primary Key Change | employee_punch_relative_start 🔑 | Added to primary key. | ||
| column | Primary Key Change | index 🔑 | Added to primary key. | ||
EMPLOYEE_PUNCH_DETAILS_SEGMENTS_COSTCENTER | |||||
| column | Primary Key Change | id 🔑 | id | No longer a primary key. | |
| column | Discontinued Column | punch_date 🔑 | No longer a primary key. | ||
| column | Discontinued Column | punch_type 🔑 | No longer a primary key. | ||
| column | Primary Key Change | company_id 🔑 | Added to primary key. | ||
| column | Primary Key Change | employee_punch_relative_end 🔑 | Added to primary key. | ||
| column | Primary Key Change | employee_punch_relative_start 🔑 | Added to primary key. | ||
| column | Primary Key Change | employee_punch_segment_index 🔑 | Added to primary key. | ||
| column | Primary Key Change | index 🔑 | Added to primary key. | ||
February 2026
We’ve added support for multiple Company IDs. You can now enter multiple comma-separated Company IDs when creating a new Paylocity connection.
October 2025
Lite connectors are now available for the following sources: