Australian Payroll Data Model
Tables
The Tables section, which details standard SQL tables, and the Views section, which lists read-only SQL tables, contain samples of what you might have access to in your Xero account.
Common tables include:
| Table | Description |
| Employees | Allows you to query, insert, and update employee records. Employees are individuals working for the organization, and their data includes payroll, tax, and employment information. |
| PayRuns | Used to query, insert, and update pay runs. A pay run represents the payroll process for a specific pay period and includes all employee payments, deductions, and taxes. |
| PaySlips | Allows querying payslips for a Xero organization. Payslips provide detailed breakdowns of employee pay, deductions, taxes, and other compensations for a specific pay period. |
| LeaveApplications | Manages leave applications submitted by employees. It allows for querying, inserting, and updating leave requests for various types of employee leave. |
| LeaveBalances | Queries the leave balance for an employee, showing how much leave they have accrued and used, as well as how much leave is available for future use. |
| Timesheets | Used to query, insert, and update timesheets for a Xero organization. Timesheets record the hours worked by employees, which are used to calculate pay for hourly workers. |
| PayrollCalendars | Stores and manages payroll calendars. It tracks the pay periods (for example, weekly, bi-weekly, or monthly) for the organization, helping to determine payroll schedules. |
| PayItemsEarnings | Used to query, insert, and update earnings that are part of the employee's pay items, such as regular wages, bonuses, and other forms of compensation. |
| PayItemsDeductions | Used to query, insert, and update deductions that are part of the employee's pay items, such as tax, union fees, or other voluntary deductions. |
| PayItemsLeave | Allows you to manage leave-related pay items. It is used to query, insert, and update leave accruals, including annual leave and sick leave. |
| PayItemsReimbursements | Manages reimbursement-related pay items. It allows you to track and manage employee expense reimbursements within the payroll system. |
| PaySlipEarnings | Manages payslip earnings line items. It includes details about an employee's earnings, such as salary, wages, bonuses, and commissions. |
| PaySlipDeductions | Manages payslip deduction line items for employees. It tracks the various deductions applied to an employee's pay, such as tax or superannuation. |
| PaySlipTaxes | Tracks tax-related line items in payslips. It includes information on the tax deductions applied to an employee's pay, such as income tax and other levies. |
| PaySlipSuperannuations | Manages payslip superannuation line items. Superannuation refers to the employer's contribution to an employee's retirement fund. |
| PaySlipReimbursements | Used to query, insert, and update manual journals. Manual journals are used to record financial transactions that don't follow standard processes. |
| PaySlipLeaveAccrual | Tracks leave accruals on the payslip. It helps manage and report on the amount of leave an employee has accrued over time. |
| PaySlipLeaveEarnings | Queries the leave earnings line items for a payslip. Leave earnings refer to the pay associated with leave taken by the employee, such as annual leave or sick leave. |
| SuperFunds | Used to manage payroll super funds for employees. It tracks the superannuation funds to which employees are contributing for their retirement savings. |
| EmployeeBankAccounts | Queries the bank accounts associated with an employee. It is used to track the employee's payment details and manage their salary or reimbursement payments. |
API limitations and requirements are documented in each table.
Stored Procedures
Stored Procedures are actions that are invoked via SQL queries. They perform tasks beyond standard create, read, update, delete (CRUD) operations, including managing OAuth tokens.