| id | surname | firstNames | preferredName | address | phoneNumber | gender | status | jobTitle | start | finish | service_yy | service_mm | service | hourlyRate | annualSalary | notionalSalary | benefits | rate | rate2 | rate3 | rate4 | rate5 | additional_rate | rateType | rate2Type | rate3Type | rate4Type | rate5Type | hoursPerWeek | fte | userField | costCentre | paidTo | cashAdvance | proprietor | active | payMethod | bankAccount | annualBalance | annualBalanceValue | freq | tax_code | tax_number | tax_override | earner_premium_override | student_loan_override | ee_override | sscwt_override | KSE_rate | KSR_rate | kiwiSaverOptOut | dateOfBirth | age | nextBirthday | kiosk_id | notes | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| boss | M | F | john.matthews@ipayroll.co.nz | 10 | 11 | 10.92 | 16.0 | 33280.00 | 33280.00 | $665.60 | 33280.0 | 0.0 | 0.0 | 0.0 | 0.0 | A | H | H | H | H | 40.0 | 1.0 | QN | 0 | 1 | Active | B | 155.38 | $2,572.80 | 1 | M | 26-980-658 | 0.0 | 0.0 | 0.0 | None | 17.5 | 3.0 | 2.0 | 52 | |||||||||||||||||
| chris | F | F | 10 | 11 | 10.92 | 14.15 | 29432.00 | 29432.00 | $588.64 | 14.15 | 0.0 | 0.0 | 0.0 | 0.0 | H | H | H | H | H | 40.0 | 1.0 | AR | 0 | 0 | Active | B | 169.23 | $2,471.30 | 1 | M SL | 26-980-658 | 0.0 | 0.0 | 0.0 | None | 17.5 | 4.0 | 2.0 | 51 | ||||||||||||||||||
| fred | M | F | 0 | 0 | 0.00 | 10.0 | 20800.00 | 20800.00 | $0.00 | 10.0 | 0.0 | 0.0 | 0.0 | 0.0 | H | H | H | H | H | 40.0 | 1.0 | WN | 0 | 0 | Inactive | Q | 0.0 | $0.00 | 1 | ND | 00-000-000 | 0.0 | 0.0 | 0.0 | None | 0.0 | 0.0 | 0.0 | 33 |