Hello everyone
Haven't quite got my head around it yet but I thought I'd post a question before I start making something that may not be possible
I wonder if there could be a database that would manage a (monthly) shift schedule for employees (doctors in a hospital) that would also take into account things like the following:
On call schedule
- 12hour on call shifts every 4 days
- 24hour on call shifts for the rest of the month
- annual (and any other) leave
- people's preferences as to when not to be on call
- the shifts have to be evenly divided (as much as possible)
Daily work (9-5) schedule for various posts
- annual (and any other) leave
- zero days (meaning that people can't work after an on call shift - with some exceptions)
- e.g. post1 will be covered by employee2 on 1st July, employee3 on 2nd July etc. There will be around 10 posts.
The database will produce a monthly on call schedule and a monthly daily work schedule.
- The on call schedule will be a table with the dates of the month and the names of the on call staff
- The daily work schedule will be a table with the dates (rows) and the posts (columns) and then the initials (or something like that) of the person covering each post each day in the table
This is a rough design I have in my mind
I suspect there will be some (maybe heavy) vba involved in it
Do you think it's feasible?
Any thoughts or advice?
Thank you