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. FirstNames (Text, 50): The Employee’s first name.
  13. FlatTaxPercent (Number (Single)): If the Employee has chosen to be FLAT Tax, the set percentage to be deducted.
  14. GrossPayYTD (Number (Currency)): Total Gross Wages paid to this Employee.
  15. HECSTaxOption (Yes/No): Yes or No.
  16. HomePhone (Text, 12): Employee’s contact phone number
  17. Internet1 (Text, 76): Employee’s e-Mail Address
  18. JobTitle (Text, 30): Employee’s Job Title
  19. LabelInternet1 (Text, 1): H
  20. LabelPhone1 (Text, 1): H
  21. LeaveLoading (Yes/No): Yes or No
  22. Locality (Text, 27): City or Suburb
  23. LongServiceAccrued (Number (Double)): The number of hours Long Service Leave the Employee is owed.
  24. MemberFundID (Number (Interger)): Employee’s Superannuation Fund for Employee Contributions.
  25. MemberFundNo (Text, 20): Employee’s Superannuation Fund Client Idenfier
  26. NetYTD (Number (Currency)): Total Net Wages paid to this Employee.
  27. NonReportableNonTaxAllow (Number (Currency)): Total Non-Taxable and Non-Reportable Allowances paid to this Employee.
  28. NonSuperSalarySacrificeYTD (Number (Currency)): Total Before Tax Non-Superannuation Deductions deducted from the Employee’s pay.
  29. NonTaxableAllowancesYTD (Number (Currency)) : Total Taxable Allowances paid to this Employee.
  30. PAYGVoluntaryFlatTax (Text, 8): PAYG Non or FLAT Non
  31. PayLocation (Text, 25): Pay Location or Department (eg. Office)
  32. PaymentMethod (Text, 9): FAST-Bank or Deposit
  33. PayPeriod (Text, 1): W, F or M.
  34. PayRateList (Text, 113): 1
  35. PayrollTaxState (Text, 3): QLD, NSW, TAS, VIC, NT, WA, ACT
  36. PostCode (Text, 4): Post Code
  37. PrimaryPaymentMethod (Text, 1): P
  38. RDOsAccured (Number (Double): The number of hours RDO Leave the Employee is owed.
  39. ReportableSuperYTD (Number (Currency): Total Reportable Superannuation Amounts.
  40. RESCPercentOrDollar (Text, 10): Reportable Employer SG set percentage or dollar.
  41. SalarySacrificeYTD (Number (Currency): Total Before Tax Superannuation Deductions.
  42. Sex (Text, 1): M or F
  43. SFSSTaxOption (Yes/No): Yes or No
  44. SGLFundID (Number (Interger)): Employee’s Superannuation Fund for Employer Contributions.
  45. SGLFundNo (Text, 20): Employee’s Superannuation Fund Client Idenfier
  46. SGLPercentOrDollar (Text, 20): Typically 9.50%
  47. SGLStartDate (Date): The Date Super begun accumulating for this employee
  48. SickLeaveAccured (Number (Double)): The number of hours Personal Leave the Employee is owed.
  49. State (Text, 3): QLD, NSW, TAS, VIC, NT, WA, ACT
  50. StateAwardType (Text, 3): QLD, NSW, TAS, VIC, NT, WA, ACT
  51. Status (Text, 1): F, P, C or S
  52. SurName (Text, 50): The Employee’s Surname.
  53. TaxableAllowancesYTD (Number (Currency): Total Taxable Allowances paid to this Employee.
  54. TaxAllowInGross (Number (Currency): Total Taxable Allowances included as part of the Gross Income paid to this Employee.
  55. TaxFileNumber (Text, 11): The Employee’s TFN
  56. TaxFreeThreshold (Yes/No): Yes or No.
  57. TILAccured (Number (Double)): The number of hours TIL Leave the Employee is owed.
  58. TotalDeductionsYTD (Number (Currency): Total deductions debited from the Gross Income to this Employee.
  59. TotalTaxYTD (Number (Currency): Total Tax deducted from the Gross Income to this Employee.
Revision: 3
Last modified: Mar 03, 2020

Feedback

Thanks for your feedback.

Post your comment on this topic.

Post Comment