Release Notes
July 2024
Effective July 24, 2024 we use a new July 2024 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.
We are making these schema changes to improve connector performance.
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.5 total changes • 5 possible breaking changes
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
SUPERANNUATION_DETAIL | |||||
column | Primary Key Change | employee_id 🔑 | employee_id | No longer primary key. | |
column | Primary Key Change | _fivetran_id 🔑 | New primary key. | ||
TAX_DECLARATION | |||||
column | Primary Key Change | employee_id 🔑 | employee_id | No longer primary key. | |
column | Primary Key Change | organisation_id 🔑 | organisation_id | No longer primary key. | |
column | Primary Key Change | _fivetran_id 🔑 | New primary key. |
March 2024
Effective March 18, 2024 we use a new March 2024 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.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.
9 total changes • 9 possible breaking changes
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
BANK_ACCOUNT | |||||
column | Primary Key Change | organisation_id 🔑 | organisation_id | No longer a part of the primary key because id alone can serve as a primary key. | |
EMERGENCY_CONTACT | |||||
column | Primary Key Change | organisation_id 🔑 | organisation_id | No longer a part of the primary key because id alone can serve as a primary key. | |
EMPLOYEE_CERTIFICATION | |||||
column | Primary Key Change | employee_id 🔑 | employee_id | No longer a part of the primary key because id alone can serve as a primary key. | |
column | Primary Key Change | organisation_id 🔑 | organisation_id | No longer a part of the primary key because id alone can serve as a primary key. | |
EMPLOYEE_HISTORY | |||||
column | Primary Key Change | organisation_id 🔑 | organisation_id | No longer a part of the primary key because id alone can serve as a primary key. | |
LEAVE_REQUEST | |||||
column | Primary Key Change | organisation_id 🔑 | organisation_id | No longer a part of the primary key because id alone can serve as a primary key. | |
PAY_DETAIL | |||||
column | Primary Key Change | employee_id 🔑 | employee_id | No longer a part of the primary key because id alone can serve as a primary key. | |
column | Primary Key Change | organisation_id 🔑 | organisation_id | No longer a part of the primary key because id alone can serve as a primary key. | |
PAYSLIP | |||||
column | Primary Key Change | organisation_id 🔑 | organisation_id | No longer a part of the primary key because id alone can serve as a primary key. |
February 2024
We have changed the composite primary key of the TIMESHEET_ENTRY
table. The employment_id
and organization_id
columns are no longer part of the composite primary key for this table.
September 2023
Lite connectors are now available for the following sources: