tags:

views:

17

answers:

0
Q: 

Best way to store availablility of employee

I am looking to add a component to our system (and build out the database tables) that will allow a user to set their availability with the following characteristics:

  • Hours of the day (and day of the week) generally available
  • Days during the month generally available
  • Days specifically not available - could be a day of the week, recurring, 2 weeks for a vacation, a month for illness.

This type of thing must already have been solved, but searches here come up with other kinds of availability.

Is there a best practices?

related questions

How can I use Excel for project management?
Run once a day
Should I create a new quartz job and trigger or one job and many triggers?
Bug distribution
todo.txt and task management
Scheduled Report(task) Monitor
How do I configure cocoon to use a database as a store for quartz jobs and triggers
What is the best method to generating ranking lists for my website homepage?
shared calendars
Teacher time schedule algorithm
Staff Rostering algorithms
What is the best method for scheduled tasks in PHP
Is there an equivalent to Thread.sleep when dealing with Eclipse Jobs?
Ruby rufus scheduler gem
Is there an easier way to track scope changes in ExtremePlanner?
Is there a Timer class in C# that isn't in the Windows.Forms namespace?
Is this an acceptable way to make a simple "scheduler" in C#?
Does programmer scheduling software exist?
What is the Windows version of cron?
PHP: running scheduled jobs (cron jobs)
Open Source Alternative to Microsoft Project?
Practical Alternative for Windows Scheduled Tasks (small shop)
What collaborative, electronic system do you use for managing releases, features, and tasks for developers and managers?
Task Schedulers
What Can Someone Do to Get Organized Around Here?