How to determine Holiday Pay?

How to determine Holiday Pay

Holiday Pay = Holiday Pay Daily Rate x Holiday Days

If the visible check box for Holiday Pay in Payroll Module Setup, pay type tab is not turned on

No Holiday Pay Calculation

How to determine Holiday Pay Daily Rate

If Non-Continuous Contract Employee in Employee Master, HR Info tab is turned on

Holiday Pay Daily Rate = 0

If Months of Service > 3 or Holiday Pay for first three months employment use is 12-month Average Wage in Payroll Module Setup, Payroll tab 

If Payroll Calculation is compliant with Employment (Amendment) Ordinance 2007 (in Payroll Module Setup, Payroll tab) is not turned on

Holiday Pay Daily Rate = Daily Salary (Current Month Average Wage)

If EAO2007 Exemption (in Employee Master, HR Info tab) is turned on 

Holiday Pay Daily Rate = Daily Salary (Current Month Average Wage)

If Use 12-month Average Wages except Holiday Pay (in  Payroll Module Setup, Payroll tab) is turned on 

Holiday Pay Daily Rate = Daily Salary (Current Month Average Wage)

If Use Current Month Average Wages if 12-month Average Wages is less than Current Month Average Wages (in Payroll Module Setup, Payroll tab) is turned on

Holiday Pay Daily Rate = Daily Salary (Current Month Average Wage) or 12-month Average Wage whichever is larger

Else

Holiday Pay Daily Rate = 12-month Average Wage

If Months of Service <= 3 and Holiday Pay for first three months employment use is Current Month Average Wage in Payroll Module Setup, Payroll tab 

Holiday Pay Daily Rate = Daily Salary (Current Month Average Wage)

If Months of Service <= 3 and Holiday Pay for first three months employment use is No Wage in Payroll Module Setup, Payroll tab 

Holiday Pay Daily Rate = 0

How to determine Holiday Days

If Holiday Type (in Employee Master, HR Info tab) is None

    Holiday Days = 0

For Non-Roster Employee, if Holiday Type is not None, but no Holiday defined in Holiday Table for the period (Except (*))

    Holiday Days = 0

For Roster Employee, if no Shift Code with Shift Type = Statutory Holiday defined in Roster Table for the period  (Except (*))

    Holiday Days = 0

If Payroll Calculation is compliant with Employment (Amendment) Ordinance 2007 (in Payroll Module Setup, Payroll tab) is not turned on and is Monthly Pay Employee

Holiday Days = 0

If EAO2007 Exemption in Employee Master, HR Info tab is turned on and is Monthly Pay Employee

    Holiday Days = 0

If Months of Service <= 3 and First three months Holiday Pay is No Wage (in Payroll Module Setup, Payroll tab or Employee Class, Payroll tab)

    Holiday Days = 0

If Daily Pay Employee and Pay Regular Days for Daily Rate Employee is turned on

    Holiday Days = 0

If Hourly Pay Employee and Pay Regular Hours for Hourly Rate Employee is turned on

    Holiday Days = 0

If Daily/Hourly Pay Employee and Pay Regular Days for Daily Rate Employee is not turned on

    Holiday Days = Number of Statutory Holidays (*) in the Payroll Period

                            - Number of No Pay Leave/Maternity Leave Days that laid on Statutory Holiday

                            - Number of Sick Leave Days that laid on Statutory Holiday (if Statutory Sick Leave Days include Statutory Holiday in Leave Module Setup, Sick Leave tab is turned on)

(*) How to determine the Number of Statutory Holidays

For Non-Roster Employees,

    Count Statutory Holiday in the Holiday Table for the payroll period. 

For Roster Employees, 

    Depending on the check-box options Statutory Holiday for Roster Employee includes (in Leave Module Setup, General tab), count