Hi There,
Many years ago I developed and I am still running a basic payroll system, At the present moment I have all the standard employee data fields and the system has been running well for many years. However I have a question, currently each year we hire several new hires and over the years we provide salary increases to each of the employees but they have different hourly rates for each employee for each year. At the present moment I have separate records for each year for that employee eg, John Smith(yr1), John Smith (yr2) ..etc with their weekly wage.
Is there a smarter way of tying the weekly wage to some external table so that I can better track things like accrued annual leave, long service leave etc for a single employee?
Many years ago I developed and I am still running a basic payroll system, At the present moment I have all the standard employee data fields and the system has been running well for many years. However I have a question, currently each year we hire several new hires and over the years we provide salary increases to each of the employees but they have different hourly rates for each employee for each year. At the present moment I have separate records for each year for that employee eg, John Smith(yr1), John Smith (yr2) ..etc with their weekly wage.
Is there a smarter way of tying the weekly wage to some external table so that I can better track things like accrued annual leave, long service leave etc for a single employee?