2024 is the year of the connector - vote here

Knowledge base

Data Model Explorer

Our **Data Model Explorer** provides an _Entity Relationship Diagram_ (ERD) of your Employment Hero Payroll (Keypay) data, allowing you to see the relationships between your different tables. ### Navigating 1. Drag tables around the workspace, by clicking and dragging anywhere on a table 1. Drag the entire workspace around by clicking and dragging the background 1. Minimize/maximize your workspace to take up your entire browser screen ### Relationships Relationships are depicted by the arrows running between table properties. For a tidier view, you may select the _Relationships Only_ checkbox, which will hide all the other columns which are not part of a relationship ### Endpoints - Account setting - Deduction category - Employee - Employee expense category - Employee leave allowance - Employer liability category - Invoice - Journal account - Leave category - Leave request - Location - Pay category - Employee pay rate - Pay run - Employee pay run - Pay run payslip - Qualification - Role - Roster shift - Timesheet - Work type - Account setting category - Employee location - Invoice line - Payslip bank payment - Payslip earnings line - Payslip accrued leave - Payslip total accrued leave - Payslip leave taken - Payslip deduction - Payslip YTD detail - Payslip employee expense - Payslip kiwi saver payment - Payslip PAYE adjustment - Payslip super adjustment - Payslip super payment - Payslip PAYG adjustment - Roster shift break - Roster shift qualification - Timesheet break - Timesheet dimension