This table will contain the different ranges for each FormulaId and each range can has its own set of formula.

C1 - C5 are the constant
K1 - K10 are the keywords where the values will be supplied by the system.
U1 - U5 are the user defined keywords where the user will supply the values.

Shows the identity of the leave formula. It also acts as a primary key for the LeaveFormula table.

Shows if the leave formula is active or not.

Shows the category of the formula.

Shows the sub category of the formula.

Shows the type of leave formula.
Example:
- Formula: The amount depends on the formula you have created
- Free: The amount varies with each payroll run
- Tabulated: The amount varies with each range based criteria
- Fixed: The amount is a constant amount

Shows the range basis of the formula.

Stores the description of the leave formula.