Skip to main content

Employee Pay

To capture any current employee's payroll data, including earnings, taxes, and other financial details.

Written by Marsha Galicia

The Employee Pay captures detailed payroll data for an employee, including earnings, taxes, superannuation and leave. Each employee carries a list of pay runs, so you can track amounts over time and answer questions about percentage changes, increases or decreases, quarters and financial years. This data is useful for monitoring payroll, financial reporting and compliance.


​The AI will only look back at 24 months' worth of data.

Key Properties:

  1. SourceLink: The identifier of the source employee record (used as the alert key).

  2. EmployeeFirstName: The first name of the employee.

  3. EmployeeLastName: The last name of the employee.

  4. EmployeeStartDate: The date when the employee started their employment.

  5. EmployeeTerminationDate: The date the employee was terminated, if applicable. A blank date (or 0001-01-01) means the employee has not been terminated.

  6. EmployeeStatus: The employee's current status, one of EMPTY, ACTIVE, INCOMPLETE or TERMINATED.

  7. DateOfBirth: The date of birth of the employee.

  8. EmploymentBasis: The basis of employment, one of EMPTY, CASUAL, FULLTIME, LABOURHIRE, NONEMPLOYEE, PARTTIME or SUPERINCOMESTREAM.

  9. PayRuns: The list of pay runs for this employee. Wages, Tax, Super and Total are per-pay-run amounts (not year-to-date), so aggregate across pay runs for financial-year or year-to-date totals.

    • PayRun

      • PayrunDate: The pay-period end date for the pay run.

      • EarningsType: The type of earnings (e.g. Salary, Hourly, Daily).

      • LeaveName: The name of the leave type (e.g. Annual Leave, Sick Leave).

      • LeaveAnnualUnits: The annual entitlement of leave units.

      • LeaveBalance: The current balance of leave units.

      • PayoutType: The type of payout for the leave.

      • CalendarType: The pay cadence (e.g. WEEKLY, FORTNIGHTLY); use it to work out the expected days between pay runs.

      • WageUnits: The number of wage units. The unit is given by UnitType (Hours, Days or Weekly) — it only equals hours when UnitType is Hours.

      • SuperContribution: The superannuation contribution type.

      • RateType: The rate type for the pay (e.g. Hourly, Daily, Salary).

      • UnitType: The unit the wage units are measured in (Hours, Days or Weekly).

      • CalculationType: The type of calculation used (e.g. Statutory).

      • Wages: The total wages for the pay run.

      • Tax: The total tax deducted for the pay run.

      • Super: The total superannuation for the pay run.

      • Reimbersments: The total reimbursements for the pay run.

      • Total: The total amount for the pay run.

      • PayrunCount: The number of pay runs represented by this record.

      • Status: The pay-run posting status, one of DRAFT, POSTED or DELETED. Single Touch Payroll only lodges with the ATO once a run is POSTED, so a DRAFT run with a PaymentDate in the past is unfiled or overdue.

      • PaymentDate: The date employees are or were paid for this pay run (distinct from PayrunDate, which is the pay-period end date).

📝 Example Alerts

Let me know when the total of wages exceeds the NSW payroll tax threshold for the current financial year
Tell me which months casual wages exceeded permanent wages
Alert me when Jane Smith is included in a new pay run
Alert me when Bob Johnson's total wages for a pay run exceed $4,000
Alert me when an employee under 18 is paid for more than 30 hours in a pay run
Alert me when an employee over 18 is not receiving employer super contributions
Related Articles
Did this answer your question?