Statutory Holiday Balance Report

Statutory Holiday Balance Report is under Leave ⇒ Leave Reports.

This report will calculate the Statutory Holiday Balance based on the Roster Table of the employee and the Holiday Table defined.

In general,

Statutory Holiday Balance = SH Entitle + SH Adjustment - SH Assigned

SH Entitle is the

Number of Statutory Holiday of the employee since Join Date.

SH Adjustment is the

Leave Adjustments that the Nature is Statutory Holiday Adjustment.

SH Assigned is depending on the check-box options Statutory Holiday for Roster Employee includes (1. Holiday Table, 2. Roster Table, 3. Statutory Holiday Nature Leave) in Leave Module Setup, General tab.

Current Year Entitle is the number of Statutory Holiday of the employee started from this Calendar Year and up to current date.

Current Year Adjustment is the total number of days of Leave Adjustments that the Nature is Statutory Holiday Adjustment started from this Calendar Year and up to current date.

Current Year Assigned is depending on the option Statutory Holiday for Roster Employee includes (1. Holiday Table, 2. Roster Table, 3. Statutory Holiday Nature Leave) start from this Calendar Year and up to current date.

  1. Holiday Table - number of Statutory Holiday of the employee started from this Calendar Year and up to current date.

  2. Roster Table - the number of shifts that the shift type is Statutory Holiday started from this Calendar Year and up to current date.

  3. Statutory Holiday Nature Leave - the leave taken that the Leave Nature is Statutory Holiday started from this Calendar Year and up to current date.

Brought Forward is Statutory Holiday Balance - Current Year Entitle - Current Year Adjustment + Current Year Assigned


Report Columns

    • EE No

    • Badge No

    • Employee Name

    • Department

    • Division

    • Employer

    • Roster Code

    • Brought Forward

    • Current Year Entitled

    • Current Year Adjustment

    • Current Year Assigned

    • Statutory Holiday Balance