Staff - Detailed Table

Angling Adventures (Demo)

id surname firstNames preferredName address phoneNumber gender status jobTitle email 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 Matthews John William John Queenstown NEW ZEALAND 555-1234 M F General Manager john.matthews@ipayroll.co.nz 13-Jun-2001 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 2000 2012/05/20 0 1 Active B 12-3059-0211383-00 155.38 $2,572.80 1 M 26-980-658 0.0 0.0 0.0 None 17.5 3.0 2.0 17-Dec-1959 52 17-Dec-2012  johmat60939
chris Matthews Christine Chrissy Queenstown NEW ZEALAND F F Fishing Guide 13-Jun-2001 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 1000 2012/05/20 0 0 Active B 06-0902-0068389-00 169.23 $2,471.30 1 M SL 26-980-658 0.0 0.0 0.0 None 17.5 4.0 2.0 24-Jun-1960 51 24-Jun-2012  chrmat70121
fred Smith Fred Fred Queenstown New Zealand M F Tour Guide 13-Jun-2001 13-Jun-2001 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 1000 2001/08/17 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 22-Apr-1979 33 22-Apr-2013  DISABLED