e-PayDay Pty Ltd

Complete the Payroll Awards Table Import File

  1. AnnualLeaveWeeks (Number (Single)): Enter the number of weeks Annual Leave any Employees linked to this Award & Agreement are entitled to,
  2. AnnualLeaveYearly (Number (Single)): Enter the number of hours per year of Annual Leave any Employees linked to this Award & Agreement are entitled to,
  3. AwardDays (Number (Single)): Maximum number of days this employee will work.
    1. eg. 5
  4. AwardHours (Number (Single)): The maximum number of OTE hours that the employee is entitled to earn accruals/super.
    1. eg. -38.00 for Casual/Part Time or 38.00/40.00 for Salary/Full Time
  5. AwardRate (Number (Double)): Normal Hourly Rate (if salary, manually calculates this amount to complete).
  6. AwardClassDBID (Number (Integer)): Award & Agreement Classification ID. The Award Classification will need to be added prior to importing to obtain the AwardsClassDBID
    1. How do I add a new Award Description / Classification?
  7. Description (Text, 75): Award & Agreement Job Role Description
    1. eg. Level 1, Year 2
  8. LeaveLoading (Yes/No): Is this employee entitled to Annual Leave Loading (17.50%) as part of their Annual Leave entitlement.
  9. LongServiceAfterXX (Number (Single)): Enter the number of years any Employees linked to this Award & Agreement must work/serve before they are entitled to Long Service Leave.
  10. LongServiceWeeks (Number (Single)): Enter the number of weeks Long Service Leave any Employees linked to this Award & Agreement are entitled to.
  11. LongServiceYearly (Number (Double)): Enter the number of hours per year of Long Service Leave any Employees linked to this Award & Agreement are entitled to.
  12. NoSuperOverMonthDollar (Number (Currency)): Enter the Monthly Employer SG Superannuation rule.
  13. Salary (Number (Currency)): Annual Salary (if paid hourly, manually calculate this amount to complete).
  14. SalSac (Yes/No): Is this employee entitled to earn Superannuation before Concessional Superannuation Contributions are deducted,
  15. SickLeaveFirstYearDays (Number (Single)): Enter the number of days Personal Leave any Employees linked to this Award & Agreement are entitled to during their first year of employment.
  16. SickLeaveFirstYear (Number (Single)): Enter the number of hours Personal Leave any Employees linked to this Award & Agreement are entitled to during their first year of employment.
  17. SickLeaveDays (Number (Single)): Enter the number of days Personal Leave any Employees linked to this Award & Agreement are entitled to for each year after their first year of employment.
  18. SickLeaveYearly (Number (Single)): Enter the number of hours Personal Leave any Employees linked to this Award & Agreement are entitled to for each year after their first year of employment.
  19. SuperAmount (Text, 8): Enter the Employer SG percentage.
  20. Type (Text, 1)
    1. F = Full Time
    2. P = Part Time
    3. C = Casual
    4. O = Commission
    5. S = Salary
Revision: 5
Last modified: Mar 03, 2020