How Do I Show Leave Balance

Leave balance is derivable and dependent on leave entitlement and leave applied, so it should be calculated dynamically by code, it has no place in the database. Just like your age, you need store date of birth but not age as age is changing and derivable from date of birth.

hi Suraj

Leave Management sound complex in the beginning, but if you look closer you will notice it is not. Now Leave management should be treated the same as accounting transaction are treated. in a Year let us say the Employer gives an employee 30 days. Now these 30 days are not given instantly they get earned every month and for 12 months it form 30 days. So now in your table you should have fields like this


Create Table Employee_Leave_Balance
(
Employee_Leave_Balance_id int Identity(1,1) primary key,
User_id int ,--This is for the Employee , because he us a user in the system we use user_id,
Number_of_days decimal --This is because , there can be half day application so you need to cater
Leave_Type_ID int ,
Add_date datetime ,
Leave_Status int
)

Now the above table can contain data like this


Emploee_Leave_Balance_id user_id Number_of_days Add_date
1 44 2.4
2 44 2.4
3 44 2.4
4 34 2.4
5 44 2.4
6 33 2.4
6 44 -4


Now the above example tells you that user_id 44 accumulated days and later on he used 4 Days now when you sum the number of days remaining you will get his latest balance. Here you can have a view that will retrieve the total balance based on the user_id.

This is just my idea, you can just take what is good from it and make your own leave management module better