1. AccrualCommencementDate (Date): The Date Leave Accruals begun accruing for this employee.
  2. AddAmountToTax (Text, 10): Set percentage or dollar amount that the Employee has chosen to pay.
  3. AddressLine1 (Text, 38): The Employee’s Physical Address
  4. AddressLine2 (Text, 38): The Employee’s Physical Address
  5. AnnualLeaveAccrued (Number (Double)): The number of hours Annual Leave the Employee is owed.
  6. AustralianResident (Text, 1): Yes or No
  7. AwardDBID (Number (Short)): Award Database ID which is most suitable to this Employee.
  8. Birthdate (Date) : Employee’s Date of Birth.
  9. Country (Text, 20): au
  10. DateHired (Date): The Date the Employee / Employer relationship commenced.
  11. EmpClockID (Text, 8): Biometric Clock or Time Recording Device ID.
  12. EmpCode (Text, 20): Identifier from your previous payroll software (where required).
  13. FirstNames (Text, 50): The Employee’s first name.
  14. FlatTaxPercent (Number (Single)): If the Employee has chosen to be FLAT Tax, the set percentage to be deducted.
  15. GrossPayYTD (Number (Currency)): Total Gross Wages paid to this Employee.
  16. HECSTaxOption (Yes/No): Yes or No.
  17. HomePhone (Text, 12): Employee’s contact phone number
  18. Internet1 (Text, 76): Employee’s e-Mail Address
  19. JobTitle (Text, 30): Employee’s Job Title
  20. LabelInternet1 (Text, 1): H
  21. LabelPhone1 (Text, 1): H
  22. LeaveLoading (Yes/No): Yes or No
  23. Locality (Text, 27): City or Suburb
  24. LongServiceAccrued (Number (Double)): The number of hours Long Service Leave the Employee is owed.
  25. MemberFundID (Number (Integer)): Employee’s Superannuation Fund for Employee Contributions.
  26. MemberFundNo (Text, 20): Employee’s Superannuation Fund Client Identifier
  27. NetYTD (Number (Currency)): Total Net Wages paid to this Employee.
  28. NonReportableNonTaxAllow (Number (Currency)): Total Non-Taxable and Non-Reportable Allowances paid to this Employee.
  29. NonSuperSalarySacrificeYTD (Number (Currency)): Total Before Tax Non-Superannuation Deductions deducted from the Employee’s pay.
  30. NonTaxableAllowancesYTD (Number (Currency)) : Total Taxable Allowances paid to this Employee.
  31. PAYGVoluntaryFlatTax (Text, 8): PAYG Non or FLAT Non
  32. PayLocation (Text, 25): Pay Location or Department (eg. Office)
  33. PaymentMethod (Text, 9): FAST-Bank or Deposit
  34. PayPeriod (Text, 1): W, F or M.
  35. PayRateList (Text, 113): 1
  36. PayrollTaxState (Text, 3): QLD, NSW, TAS, VIC, NT, WA, ACT
  37. PostCode (Text, 4): Post Code
  38. PrimaryPaymentMethod (Text, 1): P
  39. RDOsAccured (Number (Double): The number of hours RDO Leave the Employee is owed.
  40. ReportableSuperYTD (Number (Currency): Total Reportable Superannuation Amounts.
  41. RESCPercentOrDollar (Text, 10): Reportable Employer SG set percentage or dollar.
  42. SalarySacrificeYTD (Number (Currency): Total Before Tax Superannuation Deductions.
  43. Sex (Text, 1): M or F
  44. SFSSTaxOption (Yes/No): Yes or No
  45. SGLFundID (Number (Integer)): Employee’s Superannuation Fund for Employer Contributions.
  46. SGLFundNo (Text, 20): Employee’s Superannuation Fund Client Identifier
  47. SGLPercentOrDollar (Text, 20): Typically 10.50%
  48. SGLStartDate (Date): The Date Super began accumulating for this employee
  49. SickLeaveAccured (Number (Double)): The number of hours Personal Leave the Employee is owed.
  50. State (Text, 3): QLD, NSW, TAS, VIC, NT, WA, ACT
  51. StateAwardType (Text, 3): QLD, NSW, TAS, VIC, NT, WA, ACT
  52. Status (Text, 1): F, P, C or S
  53. SurName (Text, 50): The Employee’s Surname.
  54. TaxableAllowancesYTD (Number (Currency): Total Taxable Allowances paid to this Employee.
  55. TaxAllowInGross (Number (Currency): Total Taxable Allowances included as part of the Gross Income paid to this Employee.
  56. TaxFileNumber (Text, 11): The Employee’s TFN
  57. TaxFreeThreshold (Yes/No): Yes or No.
  58. TILAccured (Number (Double)): The number of hours TIL Leave the Employee is owed.
  59. TotalDeductionsYTD (Number (Currency): Total deductions debited from the Gross Income to this Employee.
  60. TotalTaxYTD (Number (Currency): Total Tax deducted from the Gross Income to this Employee.
Revision: 6
Last modified: Jul 25, 2022