Here is my problem:
I have a scheduling table where each work day, new employee records are created for that day. The record includes start and end times (e.g. 8:00am to 4:30pm), project assignment for the day, etc. There is one record for each employee for every day. If an employee calls in sick or takes a single day off as vacation, times are adjusted and a field is marked as "sick" or "Vac", etc.
So far, so good.
The problem that I have is managing time off for a range of dates - typically vacation time. What I have been doing is creating the vacation time-off records for employees in advance when they schedule that time. So a bunch of records are created for Sally, when she takes two weeks vacation in August. This works ok, but it doesn�t allow me to see at a glance the range of dates that an employee is off. Basically I have to look at each day and view that set of records one day at a time. I really want to see the range of dates all employees taking vacation, etc. off at a glance and makes adjustments as may be needed - e.g. an employee changes their vacation dates. I do this now, but it is clunky.
The issue comes down to handing items by date on a per day basis vs. a range of dates. Remember, I need one record for each employee for each day. How do other scheduling programs deal with this? Any ideas on how to handle this in an efficient and intuitive method would be greatly appreciated.
Peter
I have a scheduling table where each work day, new employee records are created for that day. The record includes start and end times (e.g. 8:00am to 4:30pm), project assignment for the day, etc. There is one record for each employee for every day. If an employee calls in sick or takes a single day off as vacation, times are adjusted and a field is marked as "sick" or "Vac", etc.
So far, so good.
The problem that I have is managing time off for a range of dates - typically vacation time. What I have been doing is creating the vacation time-off records for employees in advance when they schedule that time. So a bunch of records are created for Sally, when she takes two weeks vacation in August. This works ok, but it doesn�t allow me to see at a glance the range of dates that an employee is off. Basically I have to look at each day and view that set of records one day at a time. I really want to see the range of dates all employees taking vacation, etc. off at a glance and makes adjustments as may be needed - e.g. an employee changes their vacation dates. I do this now, but it is clunky.
The issue comes down to handing items by date on a per day basis vs. a range of dates. Remember, I need one record for each employee for each day. How do other scheduling programs deal with this? Any ideas on how to handle this in an efficient and intuitive method would be greatly appreciated.
Peter
Comment