A leave cycle spans a full calendar year of 12 months. The start of the cycle does not have to be January. The start of the cycle begins with a leave initialisation which you have to do. This leave initialisation computes the next year's leave allocation and performs other computations according to the leave type setting.

System generated identifier. It is blind to the user. It also holds the primary key for the Employee table.

Shows which year the leave report is for. This holds the primary key for the LeaveCycleRpt table.
Example: For the year 2012, it will show as 2012.

Stores the value of how much the employee earns in a day when he / she takes leave, on a yearly basis.

Shows the date of the start of a cycle. A cycle represents a year.
Example: 2012-01-01

Shows the date of the end of a cycle. A cycle represents a year.
Example: 2012-12-31

Shows the leave entitled earned in a year.
Example: 14 days of annual leave / 60 days of hospitalization leave

Shows the adjusted leave entitled earned in a year.
Example: If the employee has worked a number of hours overtime, he/she might be able to get an additional day of leave

Shows the brought forward entitled leave that the employee has earned in a year.
Example: If an employee did not clear a single of his leave of 14 days in 2012, the company would bring forward his leave to 2013 which will total up to 28 days

Shows the brought forward entitled leave that the employee has forfeited in a year.
Example: If the employee did not clear his leave of 5 days for 2012, he will not have an additional 5 days of leave brought forward to 2013

Shows the total leave the employee is entitled to in a year. A total added from CycEntEarned, CycEntAdjEarned and CycBFEarned.

Stores the number of days of leave taken from what year.

Shows if there were any leave taken from a different cycle, i.e. the previous year, or if the leave was taken from the next year.

Stores the number of days of leave the employee has left in a year. This amount is derived by deducting CycDayTaken from CycTotalEnt.

Shows the leave status of the employee.
Example: Active / Locked

Shows the date with time of when the leave cycle was last updated.