PDA

View Full Version : Date Scheduling Paradigm Needed


ABC123

Peter.Greulich
06-18-2003, 05:32 AM
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

Keith Hubert
06-18-2003, 05:53 AM
Peter,

Very soon there will be the most fantasic Calendar available as an addin. You will be able to put all employees who have vacations booked and see them at a glance for a whole month. You will be able to create many calendars to view your data for the critreria that you want.

I'm afraid that is all I can tell you at the moment, any more and I would be shot. Only to say keep an eye on Announcments.

Keith Hubert
London.

Peter.Greulich
06-18-2003, 06:11 AM
Hhhmmmm....

JohnZaleski
06-18-2003, 07:48 AM
Given the one record per employee per day file structure, it should be a simple matter to display the scheduled vacation days by employee in some kind of a browse ( either as a child or not ). After all, it only means applying a filter by employee and by a vacation indicator.
It should be easy enough in a simple script to deselect these records as vacation records back to unscheduled records and then go thru your vacation process again.
If you are creating the unscheduled records far in advance, it should be an easy matter to display the records for a particular employee and select a start and end vacation date and tag the records accordingly.

Peter.Greulich
06-18-2003, 07:54 AM
John,

That's kind of what I was thinking about. Thanks.

Peter

Keith Hubert
06-18-2003, 11:00 AM
Peter,

Have a look in Code Archive. I put there some time back an activeX calendar that filters a browse on a date. You could also filter the form too.

Keith Hubert
London.