Anyone here designed an HR Database?

[lightray]

Hi,
Am looking for someone to talk about how Annual Leave might be calculated, given that an Employee can have a different entitlement over their employment with a company.

Mainly interested in calc'ing a daily entitlement, and not getting involved in any Payroll side of things.

Much appreciated, lightray

 

[lightray]

Hi Pat, thanks for your input.
New Zealand administers a UK type standard when it comes to accruing [Annual Leave] more so when it's a government division. I've set my mdb up to query or requery every instant of a record change [Add or Change ]. There isn't likely to be more than 100 employees, but I can see this method will become weighty over a period, when all types of leave records are entered. I am considering archiving off old records.
Actually, as I write this I realise that I am only calc'ing figures for the [Current Leave Year] so may not be so bad.
When I put this post together I was mainly interested in the formula that would calculate the [Daily Increment] something like:
[DI] = [No. days worked in CLY] x ([Yearly Allowance] / 261)
261 being the number of working days in the year. the [CLY] is calculated minus weekends and Public Holidays. Is this a sound evaluation?
I was also interested in chatting to any other Developers who may have put an HR database together, to bounce ideas off

Any thoughts? lightray