How to know when is the last salary update(Incerease) was made?
If the salary in a given year is 4000 per month and next month he got the raise of 3000,(For two months he got 4000 and rst of the year 7000) now the salary will be 4000 + 3000 per month I,e. 7000 per month ,but in my table when I update the salary field it updates to 7000 and I don't know how to know from when the salary has been incremented for the given Employee.
I have employee tabel
Date Of Joining Field
Do I have to make another table or I have to add some more fields to know that?
and for Tax returns I need to know when was 4000 salary drawan and later from which perid increased salary drawn.