creating a staff holiday-entitlement database

[Anon]

Hi there,

I'm trying to create a db for the 30+ staff here that lists their holiday entitlements: how much they originally had, how much they have left, and details of the time they're already taken ('from' and 'to' dates, type of leave, etc).

Has anyone ever done this before?
Looks like I just need to create a table for each person and put in the details - but as this means creating 30+ tables I was wondering if there's any way around this or a facility that I'm not aware of.

any comments gratefully received :o)

thanks - dunstan orchard

[Anon]

Two or more tables would greately help...

One for employee info (with one column for employee ID)

Another for Holiday entitlements (using rel_eid -> relative employee ID)

Possible a third for number of days taken already

Also possible a fourth for number of days remaining

[Anon]

I see 3 tables needed.

1 - employees: holds the employees information

2 - dayoff-types: holds the types of days that the employee can take

3 - days-taken: holds the dates that any employee was off along with the hours and type (from table 2).

This way you would hold your current avaiable vacation time in the employees table, and also the total vacation time accrued. When the employee accrues more time you just need to add to these 2 fields. When the employee takes time you subtract it from the current, and put an entry int the days-taken table.

[Anon]

great stuff, thanks guys :o)

• dunstan